squirrels

27 rows where Date = 10142018, Hectare Squirrel Number = 6 and Police Precincts = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

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
47 47 -73.9640032826529 40.7820309825448 22F-PM-1014-06 22F PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9640032826529 40.7820309825448)   19 4 19 13
81 81 -73.9578237168359 40.7980959471034 40B-PM-1014-06 40B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9578237168359 40.7980959471034)   19 4 19 13
378 378 -73.9584835416846 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9584835416846 40.7978213396921)   19 4 19 13
393 393 -73.9577212629651 40.7965525296722 38C-PM-1014-06 38C PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9577212629651 40.7965525296722)   19 4 19 13
492 492 -73.9703010856224 40.7701983575511 8H-PM-1014-06 08H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9703010856224 40.7701983575511)   19 4 19 13
494 494 -73.958837574505 40.7985003987784 40A-PM-1014-06 40A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.958837574505 40.7985003987784)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
576 576 -73.9622047677701 40.7945126358465 35A-AM-1014-06 35A AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9622047677701 40.7945126358465)   19 4 19 13
594 594 -73.9727488640736 40.7781916780621 14B-PM-1014-06 14B PM 10142018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false watching me false false false false false true false false skittish POINT (-73.9727488640736 40.7781916780621)   19 4 19 13
726 726 -73.973305698325 40.7783823311296 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   false false true false false   false false false false false false false true   POINT (-73.973305698325 40.7783823311296)   19 4 19 13
818 818 -73.9608757424052 40.7906686504657 31D-AM-1014-06 31D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9608757424052 40.7906686504657)   19 4 19 13
967 967 -73.9683994064731 40.7710765500799 9I-AM-1014-06 09I AM 10142018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.96839940647311 40.7710765500799)   19 4 19 13
1128 1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638599044346 40.7809288795308)   19 4 19 13
1194 1194 -73.9687462566073 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false digging false false false false false false false false   POINT (-73.9687462566073 40.783898987005)   19 4 19 13
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false false true   POINT (-73.980919134781 40.7683772453336)   19 4 19 13
1424 1424 -73.9709722223794 40.7767329646325 14D-AM-1014-06 14D AM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9709722223794 40.7767329646325)   19 4 19 13
1694 1694 -73.9730196342874 40.766022437401 3H-PM-1014-06 03H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9730196342874 40.766022437401)   19 4 19 13
1803 1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9588076804698 40.7912942607296)   19 4 19 13
1870 1870 -73.9542118614769 40.7939171395463 37G-AM-1014-06 37G AM 10142018 6 Adult Gray White Gray+White White tail Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95421186147692 40.7939171395463)   19 4 19 13
1964 1964 -73.9622859117854 40.7886169186966 29D-AM-1014-06 29D AM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9622859117854 40.7886169186966)   19 4 19 13
2052 2052 -73.9746493441414 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false false false cleaning false false false false false false true false   POINT (-73.9746493441414 40.7750478734868)   19 4 19 13
2276 2276 -73.9611985783336 40.791604823372 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9611985783336 40.791604823372)   19 4 19 13
2281 2281 -73.9691520826028 40.7717104037783 10H-AM-1014-06 10H AM 10142018 6   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9691520826028 40.7717104037783)   19 4 19 13
2410 2410 -73.9755192076934 40.7664413570796 2F-PM-1014-06 02F PM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9755192076934 40.7664413570796)   19 4 19 13
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   false false true false true   false false false false false false false false   POINT (-73.9578840941242 40.7955586232429)   19 4 19 13
2892 2892 -73.9688070760806 40.7779688294172 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9688070760806 40.777968829417205)   19 4 19 13
2980 2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   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 59.521ms