2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Above Ground Sighter Measurement = "FALSE", Foraging = 0 and Hectare Squirrel Number = 8 sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Kuks, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Hectare Squirrel Number ✖

Foraging ✖

Above Ground Sighter Measurement ✖

  • FALSE · 25 ✖
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
152 152 -73.9755133710665 40.7697883435981 5E-AM-1008-08 05E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755133710665 40.7697883435981)
235 235 -73.97535742799359 40.768321169425704 4E-PM-1008-08 04E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9753574279936 40.7683211694257)
586 586 -73.9789126088606 40.7685079149692 2C-PM-1013-08 02C PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9789126088606 40.7685079149692)
717 717 -73.9574749571848 40.7981898890735 40C-PM-1006-08 40C PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE By the main road 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9574749571848 40.7981898890735)
724 724 -73.9532952763106 40.792007446262204 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#7) 0 0 0 0 1 0 0 1 runs from (me) POINT (-73.95329527631061 40.7920074462622)
885 885 -73.97504638449841 40.7666871742836 2F-PM-1014-08 02F PM 10142018 8 Adult Gray Black Gray+Black   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9750463844984 40.7666871742836)
902 902 -73.969105907 40.782047490919204 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   1 0 0 0 0 being chased by dog 0 0 0 0 0 0 0 1   POINT (-73.969105907 40.7820474909192)
955 955 -73.96065706156101 40.79561507441021 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" 1 0 0 0 0 running from #7 0 0 0 0 0 0 0 1   POINT (-73.960657061561 40.7956150744102)
1084 1084 -73.96988397502491 40.778143307669204 16D-PM-1010-08 16D PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9698839750249 40.7781433076692)
1102 1102 -73.9688173465755 40.7782009764626 16E-AM-1014-08 16E AM 10142018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9688173465755 40.7782009764626)
1140 1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615817859213 40.79458396638451)
1270 1270 -73.967762162893 40.7823359027165 20C-PM-1018-08 20C PM 10182018 8 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 1 runs from (dog) POINT (-73.967762162893 40.7823359027165)
1339 1339 -73.96864133261721 40.7817423907284 19C-PM-1018-08 19C PM 10182018 8 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9686413326172 40.7817423907284)
1582 1582 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9804065254162 40.7681481183296)
1821 1821 -73.9676314068477 40.7788030406918 17E-AM-1017-08 17E AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9676314068477 40.7788030406918)
2047 2047 -73.9721656413591 40.7722869065638 9F-PM-1014-08 09F PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 turned to face me while eating POINT (-73.9721656413591 40.7722869065638)
2198 2198 -73.97097381665309 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9709738166531 40.7774102689734)
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9583688637255 40.791388958496)
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801956082236 40.767836440957)
2723 2723 -73.96064260275601 40.791726541984204 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0 stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)
2735 2735 -73.97680969536471 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768096953647 40.7708185213129)
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)
2939 2939 -73.9680204438195 40.774388232265395 13H-PM-1010-08 13H PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9680204438195 40.77438823226541)
2996 2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970033345821 40.777259393859)
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 170.954ms