squirrels

33 rows where Hectare Squirrel Number = 12 sorted by Unique Squirrel ID

View and edit SQL

Suggested facets: Shift, Date, 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, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts

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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
901 -73.9702228131711 40.7742131587983 12F-PM-1007-12 12F PM 10072018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   false false false false true going down tree false false false false false false true false   POINT (-73.9702228131711 40.7742131587983)   19 4 19 13
1092 -73.9711319254625 40.7760324859879 13D-PM-1018-12 13D PM 10182018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9711319254625 40.776032485987905)   19 4 19 13
796 -73.9706641770728 40.7759229213762 13E-AM-1017-12 13E AM 10172018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9706641770728 40.7759229213762)   19 4 19 13
843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
363 -73.9707197274481 40.7773956803431 14D-PM-1019-12 14D PM 10192018 12 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9707197274481 40.7773956803431)   19 4 19 13
1696 -73.9694591667705 40.7766518221998 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   false false true true true   false false false false false false true false   POINT (-73.9694591667705 40.7766518221998)   19 4 19 13
981 -73.9673160165357 40.7766158001202 15G-PM-1019-12 15G PM 10192018 12 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false stared POINT (-73.9673160165357 40.7766158001202)   19 4 19 13
1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9703314162405 40.778584776139)   19 4 19 13
392 -73.9802376131034 40.7680707516627 1B-AM-1012-12 01B AM 10122018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9802376131034 40.7680707516627)   19 4 19 13
2730 -73.9653575758687 40.7805339953372 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree false false true true false   false false false false false false false false   POINT (-73.9653575758687 40.7805339953372)   19 4 19 13
1774 -73.9668909481942 40.7841298584027 22C-PM-1006-12 22C PM 10062018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   true false false false false false false false human friendly POINT (-73.9668909481942 40.7841298584027)   19 4 19 13
1485 -73.9791085350047 40.7677025342633 2C-PM-1013-12 02C PM 10132018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9791085350047 40.7677025342633)   19 4 19 13
974 -73.9753744539307 40.7671162211032 2F-PM-1014-12 02F PM 10142018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.97537445393071 40.7671162211032)   19 4 19 13
2354 -73.9636740170308 40.7903538224977 30B-AM-1007-12 30B AM 10072018 12 Adult Gray   Gray+   Above Ground 4   false false true false true   false false false false false false false true   POINT (-73.96367401703081 40.79035382249771)   19 4 19 13
176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false true true false false   POINT (-73.9618064639153 40.792158440043)   19 4 19 13
1760 -73.9597072533787 40.7905581853786 32E-AM-1007-12 32E AM 10072018 12 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9597072533787 40.79055818537861)   19 4 19 13
1789 -73.9596271142953 40.7906612313673 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false true false false false false false false   POINT (-73.9596271142953 40.7906612313673)   19 4 19 13
785 -73.9619417432685 40.7930365939865 33B-PM-1010-12 33B PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9619417432685 40.7930365939865)   19 4 19 13
966 -73.958317581802 40.7916566683158 33E-AM-1014-12 33E AM 10142018 12 Adult Gray White Gray+White   Above Ground 15   false false false false false sleeping false false false false false false false false asleep POINT (-73.958317581802 40.7916566683158)   19 4 19 13
583 -73.9612398509782 40.7950033150385 35A-PM-1013-12 35A PM 10132018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9612398509782 40.7950033150385)   19 4 19 13
1875 -73.9527430510248 40.7924807950552 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   false false false false true   false false false false false false false false   POINT (-73.9527430510248 40.7924807950552)   19 4 19 13
1038 -73.9563311167069 40.7950901563337 38E-AM-1010-12 38E AM 10102018 12 Adult Cinnamon   Cinnamon+   Ground Plane FALSE running on rocks false true false false false   false false false true false false false false runs toward something POINT (-73.9563311167069 40.7950901563337)   19 4 19 13
514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
2547 -73.9743393747021 40.7676346798325 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9743393747021 40.7676346798325)   19 4 19 13
1567 -73.9774407362587 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774407362587 40.7698056129554)   19 4 19 13
1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   19 4 19 13
1158 -73.9763894759543 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9763894759543 40.7705523372364)   19 4 19 13
969 -73.9773529368499 40.7728750685699 7B-AM-1008-12 07B AM 10082018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9773529368499 40.7728750685699)   19 4 19 13
1386 -73.9730085729495 40.7708933570327 7F-AM-1008-12 07F AM 10082018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9730085729495 40.7708933570327)   19 4 19 13
1275 -73.9702541471417 40.7698584231797 7H-AM-1006-12 07H AM 10062018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702541471417 40.7698584231797)   19 4 19 13
700 -73.9691261755936 40.7702929428604 8I-AM-1006-12 08I AM 10062018 12 Adult Gray   Gray+   Above Ground 50 tree false false true false false   false false false false false false true false   POINT (-73.9691261755936 40.7702929428604)   19 4 19 13
2919 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 10132018 12 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE foot of tree true true false false false   false false false false false false true false   POINT (-73.9768563402344 40.7744487310786)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 62.419ms