2018_Central_Park_Squirrel_Census_-_Squirrel_Data

51 rows where Foraging = 1, Hectare Squirrel Number = 3 and Runs from = 1 sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 35

Hectare Squirrel Number ✖

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
774 774 -73.9673603655908 40.787697417778205 26A-PM-1006-03 26A PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9673603655908 40.7876974177782)
791 791 -73.9772635911119 40.7709428872533 6B-PM-1017-03 06B PM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9772635911119 40.7709428872533)
825 825 -73.9580105174865 40.7974468322692 39C-PM-1006-03 39C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9580105174865 40.7974468322692)
891 891 -73.9613351649026 40.79098668513571 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9613351649026 40.7909866851357)
962 962 -73.97154668503241 40.7695584933538 6H-PM-1020-03 06H PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (kids kicking the fence) POINT (-73.9715466850324 40.7695584933538)
963 963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9621066718851 40.7942427079733)
1024 1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 1   POINT (-73.9521514669041 40.7949515182825)
1159 1159 -73.9682129261841 40.77542323581179 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9682129261841 40.7754232358118)
1200 1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657721715305 40.778534830257)
1250 1250 -73.9585133340331 40.796372167947396 38C-PM-1014-03 38C PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1   POINT (-73.9585133340331 40.7963721679474)
1375 1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
1443 1443 -73.9728511531484 40.7782654840595 14B-PM-1014-03 14B PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9728511531484 40.7782654840595)
1502 1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
1657 1657 -73.97682540587091 40.7716757945251 6C-PM-1020-03 06C PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9768254058709 40.7716757945251)
1658 1658 -73.9736016229655 40.772378137671396 8D-AM-1007-03 08D AM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.9736016229655 40.77237813767141)
1678 1678 -73.95687265085459 40.7878795081255 30I-PM-1006-03 30I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 up tree POINT (-73.9568726508546 40.7878795081255)
1759 1759 -73.9576219570858 40.79633512256721 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9576219570858 40.7963351225672)
1798 1798 -73.9558180952889 40.7886810505944 31I-PM-1019-03 31I PM 10192018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9558180952889 40.7886810505944)
1914 1914 -73.9588714413332 40.7895787115444 31F-PM-1007-03 31F PM 10072018 3 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9588714413332 40.7895787115444)
1920 1920 -73.95453837191879 40.7899711263765 33I-PM-1006-03 33I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.95453837191882 40.7899711263765)
1967 1967 -73.96472472541271 40.780613656578396 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9647247254127 40.7806136565784)
1992 1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9586085843149 40.7946617684536)
2055 2055 -73.9806928007664 40.768255422025 1A-PM-1014-03 01A PM 10142018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9806928007664 40.768255422025)
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)
2234 2234 -73.9734741818047 40.766328451425 3H-PM-1014-03 03H PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9734741818047 40.766328451425)
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 2/3 were chasing each other 0 0 0 0 1 0 0 1   POINT (-73.96786208407411 40.784719027304)
2373 2373 -73.9613276802049 40.7943813964442 35B-PM-1013-03 35B PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 threatened by approaching dog (dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.96132768020492 40.7943813964442)
2494 2494 -73.9713968424625 40.774039018852704 11E-PM-1012-03 11E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713968424625 40.7740390188527)
2541 2541 -73.9579097104326 40.797227339471604 39C-AM-1017-03 39C AM 10172018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9579097104326 40.7972273394716)
2544 2544 -73.9713680837672 40.77716615083639 14D-PM-1019-03 14D PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713680837672 40.77716615083641)
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9618094076328 40.7944097368153)
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9726598256924 40.7707862446236)
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)

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