2018_Central_Park_Squirrel_Census_-_Squirrel_Data

33 rows where Indifferent = 1, Primary Fur Color = "Cinnamon" and Tail twitches = 1 sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Runs from

Tail twitches ✖

Primary Fur Color ✖

  • Cinnamon · 33 ✖

Indifferent ✖

Link rowid longitude latitude Unique Squirrel ID Hectare Shift ▼ Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long
12 12 -73.96836135162249 40.772590884749896 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9683613516225 40.7725908847499)
26 26 -73.9649866016038 40.776492969445705 16I-AM-1008-01 16I AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9649866016038 40.7764929694457)
405 405 -73.97866031471492 40.7671937837017 1D-AM-1006-09 01D AM 10062018 9 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9786603147149 40.7671937837017)
485 485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9677423154682 40.77288133502451)
1121 1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9645060433292 40.7768322057794)
1394 1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
1492 1492 -73.9807078515193 40.768333529264204 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9807078515193 40.7683335292642)
1816 1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9710187505339 40.7797265666746)
2007 2007 -73.9684834138222 40.772428912021105 11H-AM-1010-06 11H AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9684834138222 40.7724289120211)
2241 2241 -73.95752586279659 40.787715550749 30H-AM-1007-03 30H AM 10072018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9575258627966 40.787715550749)
2255 2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
2367 2367 -73.9681671864047 40.7753770538635 14G-AM-1012-04 14G AM 10122018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9681671864047 40.7753770538635)
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2539 2539 -73.97810334484679 40.766672406621296 1D-AM-1006-03 01D AM 10062018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9781033448468 40.7666724066213)
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
2746 2746 -73.95614328368629 40.798266534723396 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9561432836863 40.7982665347234)
2938 2938 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)
67 67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.968381325559 40.7780143443779)
165 165 -73.969058856545 40.776635622697896 14F-PM-1012-06 14F PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.969058856545 40.7766356226979)
217 217 -73.9712327308512 40.7748702909218 12E-PM-1018-06 12E PM 10182018 6 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9712327308512 40.7748702909218)
423 423 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756754297747 40.7738518843446)
432 432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9757787135906 40.7737231427345)
620 620 -73.9655905300923 40.775261463802295 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9655905300923 40.7752614638023)
748 748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756603846107 40.7672531319384)
1961 1961 -73.953664715831 40.7981256393159 41E-PM-1013-04 41E PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.953664715831 40.7981256393159)
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees 0 0 1 1 1 scratching self 0 0 0 0 1 0 1 0   POINT (-73.9639505810228 40.789573183584)
2099 2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9685612289881 40.7778488829217)
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9686370726471 40.7780382348833)
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people 1 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9596083366477 40.7949526729608)
2612 2612 -73.97116730065241 40.77479796145771 12E-PM-1018-05 12E PM 10182018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9711673006524 40.7747979614577)
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9697665830132 40.7759094917104)
3004 3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 191.879ms