squirrels

119 rows where Hectare Squirrel Number = 8 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Foraging ✖

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
2192 2192 -73.9593410965431 40.7923134010383 33D-AM-1017-08 33D AM 10172018 8 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9593410965431 40.7923134010383)   19 4 19 13
1645 1645 -73.9619673317128 40.7924176673037 33B-PM-1010-08 33B PM 10102018 8 Juvenile Gray   Gray+   Above Ground   running up tree false false true false false   false false false false false false false true   POINT (-73.9619673317128 40.7924176673037)   19 4 19 13
1559 1559 -73.9631648674122 40.7926529617419 32A-PM-1013-08 32A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9631648674122 40.7926529617419)   19 4 19 13
924 924 -73.9591695545875 40.7938116360767 35D-PM-1013-08 35D PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9591695545875 40.7938116360767)   19 4 19 13
2714 2714 -73.9600738985438 40.7938328798752 35C-PM-1013-08 35C PM 10132018 8       +         false false false false false   true false false false false false false false did not *see* POINT (-73.9600738985438 40.7938328798752)   19 4 19 13
2257 2257 -73.95431338448 40.7940537582585 37G-PM-1007-08 37G PM 10072018 8 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.95431338448 40.7940537582585)   19 4 19 13
1514 1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   true false false true false false true false   POINT (-73.9548006161673 40.7945503341011)   19 4 19 13
839 839 -73.9615602805554 40.7945662185621 35A-PM-1013-08 35A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9615602805554 40.7945662185621)   19 4 19 13
1140 1140 -73.9615817859213 40.7945839663845 35A-AM-1014-08 35A AM 10142018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9615817859213 40.79458396638451)   19 4 19 13
564 564 -73.9570086212285 40.7946679755816 37E-PM-1006-08 37E PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95700862122851 40.7946679755816)   19 4 19 13
1880 1880 -73.9562362816756 40.7950457218996 38E-AM-1010-08 38E AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9562362816756 40.7950457218996)   19 4 19 13
956 956 -73.9581173730857 40.7954772170549 37D-PM-1014-08 37D PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9581173730857 40.7954772170549)   19 4 19 13
955 955 -73.960657061561 40.7956150744102 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" true false false false false running from #7 false false false false false false false true   POINT (-73.960657061561 40.7956150744102)   19 4 19 13
2710 2710 -73.9577919365342 40.7960853285059 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false false false false true   POINT (-73.9577919365342 40.7960853285059)   19 4 19 13
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   true false false false false false true false   POINT (-73.9582150734453 40.7962862794303)   19 4 19 13
717 717 -73.9574749571848 40.7981898890735 40C-PM-1006-08 40C PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE By the main road true false false false false   false false false false false false false true   POINT (-73.9574749571848 40.7981898890735)   19 4 19 13
1761 1761 -73.9575307970434 40.7983176419483 40B-PM-1014-08 40B PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9575307970434 40.7983176419483)   19 4 19 13
1185 1185 -73.958230674366 40.7989268396525 40B-AM-1019-08 40B AM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false false false true true   POINT (-73.958230674366 40.7989268396525)   19 4 19 13
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   false false true true false   false false false false false true false false   POINT (-73.9577297187155 40.799225295679)   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 685.685ms