2018_Central_Park_Squirrel_Census_-_Squirrel_Data

58 rows where Eating = 0, Hectare Squirrel Number = 4 and Highlight Fur Color = "Cinnamon" sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Highlight Fur Color ✖

  • Cinnamon · 58 ✖

Hectare Squirrel Number ✖

Eating ✖

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
2798 2798 -73.9753825640019 40.767166201386104 3F-PM-1013-04 03F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753825640019 40.7671662013861)
2315 2315 -73.9767849679735 40.768566516928 3D-PM-1010-04 03D PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767849679735 40.768566516928)
2961 2961 -73.9736238258579 40.7688712771191 5F-PM-1007-04 05F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9736238258579 40.7688712771191)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1474 1474 -73.9801971465604 40.7697081749827 3A-PM-1017-04 03A PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9801971465604 40.7697081749827)
486 486 -73.971213385696 40.769872094337 7H-AM-1006-04 07H AM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97121338569602 40.769872094337)
2264 2264 -73.97735205827341 40.7708198505781 5B-AM-1008-04 05B AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773520582734 40.7708198505781)
2738 2738 -73.9691801791373 40.770927235357206 9I-AM-1014-04 09I AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691801791373 40.7709272353572)
2425 2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9791141532217 40.77148888354161)
240 240 -73.9767080512177 40.7717708794221 6B-PM-1017-04 06B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767080512177 40.7717708794221)
445 445 -73.97140573271591 40.7720375135272 9F-PM-1014-04 09F PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714057327159 40.7720375135272)
145 145 -73.971970670614 40.7720868124544 9F-AM-1013-04 09F AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.971970670614 40.7720868124544)
2133 2133 -73.9736164871197 40.7725695048569 8D-PM-1007-04 08D PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9736164871197 40.7725695048569)
302 302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9695176417703 40.7741725190048)
190 190 -73.9695507965155 40.7743070423435 12F-PM-1007-04 12F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 stared POINT (-73.96955079651552 40.7743070423435)
1401 1401 -73.9681202146851 40.7743979416812 13G-PM-1008-04 13G PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE lawn @ edge of landscaped area 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681202146851 40.7743979416812)
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765595553183 40.7748455340432)
1508 1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0 he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)
1089 1089 -73.9655955841325 40.7762063860571 15H-PM-1008-04 15H PM 10082018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of landscape 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9655955841325 40.7762063860571)
499 499 -73.96572880550109 40.776458003628704 16H-PM-1014-04 16H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657288055011 40.7764580036287)
318 318 -73.97439905767459 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 1 0 0 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.9743990576746 40.7768690723163)
2809 2809 -73.9686756254868 40.777745910265104 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9686756254868 40.7777459102651)
1809 1809 -73.96901686738441 40.777761204391396 15E-AM-1013-04 15E AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9690168673844 40.7777612043914)
1506 1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9728339757306 40.7782891207966)
343 343 -73.9730224561601 40.7796833353894 16A-PM-1019-04 16A PM 10192018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9730224561601 40.7796833353894)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
1704 1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9624052832372 40.7809656348254)
1518 1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632265832593 40.78169144754611)
180 180 -73.96908283251791 40.781803817227505 19C-PM-1018-04 19C PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9690828325179 40.7818038172275)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2828 2828 -73.9587439756541 40.7849006107353 27I-AM-1007-04 27I AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9587439756541 40.7849006107353)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
681 681 -73.9552880892701 40.7889040503316 32I-AM-1013-04 32I AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552880892701 40.7889040503316)
1919 1919 -73.9637440847107 40.789142741937205 29C-AM-1007-04 29C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9637440847107 40.7891427419372)
1008 1008 -73.9553038162633 40.7909367783223 34H-PM-1006-04 34H PM 10062018 4   Gray Cinnamon Gray+Cinnamon   Above Ground   Elm tree 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9553038162633 40.790936778322305)
1362 1362 -73.9629184712372 40.7921410511633 32B-PM-1010-04 32B PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9629184712372 40.7921410511633)
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623696148045 40.792184861375)
851 851 -73.9528462779437 40.792384304368504 36I-AM-1017-04 36I AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9528462779437 40.7923843043685)
1391 1391 -73.95786586329571 40.7933712188923 35E-AM-1020-04 35E AM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 0 0 0 hunkered down,tail over body; sitting perfectly still 0 0 0 0 0 0 1 0   POINT (-73.9578658632957 40.7933712188923)
1463 1463 -73.96300972763659 40.7936658446251 33A-PM-1018-04 33A PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9630097276366 40.79366584462511)
2158 2158 -73.9597593485091 40.7937528403249 35C-AM-1007-04 35C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9597593485091 40.7937528403249)
1076 1076 -73.96279043284021 40.7939375305761 34A-PM-1013-04 34A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 digging & burying 0 0 0 0 0 0 0 0   POINT (-73.9627904328402 40.7939375305761)
2011 2011 -73.9603245806655 40.79427124776971 35C-PM-1013-04 35C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9603245806655 40.7942712477697)
1368 1368 -73.95427708888809 40.794361036685295 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542770888881 40.79436103668531)
2520 2520 -73.95482071063391 40.7946991812402 38F-PM-1013-04 38F PM 10132018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548207106339 40.7946991812402)
631 631 -73.95488778301359 40.795015748910295 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95488778301362 40.7950157489103)
2447 2447 -73.9589670987899 40.795212703928705 37C-AM-1012-04 37C AM 10122018 4 Adult Gray Cinnamon Gray+Cinnamon Cinnamon flanks Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589670987899 40.7952127039287)
823 823 -73.954595058342 40.7956567934304 39F-AM-1014-04 39F AM 10142018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.954595058342 40.7956567934304)
1608 1608 -73.9545425520879 40.7956853415959 39F-PM-1006-04 39F PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 in tree 0 0 1 0 0 climbing down 0 0 0 0 0 0 0 1 ran when saw me POINT (-73.9545425520879 40.7956853415959)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
2664 2664 -73.95983503855409 40.7973274000224 38A-PM-1013-04 38A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598350385541 40.7973274000224)
1176 1176 -73.9553263156025 40.79755920605721 40D-PM-1013-04 40D PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9553263156025 40.7975592060572)
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)
242 242 -73.9590236602085 40.798263245686606 40A-AM-1010-04 40A AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom great hill 0 0 0 0 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9590236602085 40.7982632456866)
2832 2832 -73.958607566971 40.7983695505584 40B-PM-1014-04 40B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958607566971 40.7983695505584)
1022 1022 -73.95488534927121 40.7984783584388 41D-PM-1014-04 41D PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 jumping tree to tree 0 0 0 0 0 0 0 0   POINT (-73.9548853492712 40.7984783584388)
920 920 -73.9571233640232 40.7992458980266 41B-PM-1014-04 41B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0 climbing POINT (-73.9571233640232 40.7992458980266)

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 198.034ms