squirrels

29 rows where Date = 10062018 and Tail flags = "true" sorted by Police Precincts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Eating, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Tail flags ✖

  • true · 29 ✖

Date ✖

  • 10062018 · 29 ✖
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 ▼
15 15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false true true false false false   POINT (-73.9674285955293 40.7829723919744)   19 4 19 13
78 78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false gathering acorns false false false true false false false true gnd to tree POINT (-73.964474836001 40.7883840104749)   19 4 19 13
90 90 -73.9787180870736 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch false false false false true   false false false true false false false true   POINT (-73.9787180870736 40.7715877863274)   19 4 19 13
133 133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 false false true false false   false false false true false false false false studying us looking for food POINT (-73.9664711607022 40.787896428768)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
379 379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9606817053484 40.7917320450401)   19 4 19 13
569 569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree true false true false false   false false false true false false true false   POINT (-73.9709040623777 40.7701163892686)   19 4 19 13
652 652 -73.9570056123953 40.7878756067582 30I-PM-1006-02 30I PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9570056123953 40.7878756067582)   19 4 19 13
658 658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree false false false true true   false false false true false true false true   POINT (-73.9704575848926 40.7693499326095)   19 4 19 13
663 663 -73.9766440589836 40.7682390282581 3E-AM-1006-02 03E AM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9766440589836 40.7682390282581)   19 4 19 13
730 730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9607280801601 40.7901506706248)   19 4 19 13
1019 1019 -73.9704269630964 40.7722964640257 10G-AM-1006-09 10G AM 10062018 9 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9704269630964 40.7722964640257)   19 4 19 13
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree false false true false false   false false false true true false false false curious POINT (-73.9782120139407 40.7717154468791)   19 4 19 13
1201 1201 -73.9782813538421 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true true false false   false false false true false false false false   POINT (-73.9782813538421 40.7715730368712)   19 4 19 13
1230 1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   false false true true false   false false false true false false false true   POINT (-73.9790822606486 40.7714466633386)   19 4 19 13
1523 1523 -73.9673103881521 40.7874267409618 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9673103881521 40.7874267409618)   19 4 19 13
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false true false false true false   POINT (-73.9692401421068 40.7707128895661)   19 4 19 13
1815 1815 -73.9603268255317 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603268255317 40.7900154505092)   19 4 19 13
1995 1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603366992925 40.789961288953904)   19 4 19 13
2044 2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   19 4 19 13
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2363 2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true true false true false   POINT (-73.9690638424196 40.7713869295685)   19 4 19 13
2397 2397 -73.9704592500888 40.772962887933 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   false false true false false   false false false true false false false true   POINT (-73.9704592500888 40.772962887933)   19 4 19 13
2425 2425 -73.9791141532217 40.7714888835416 5A-AM-1006-04 05A AM 10062018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9791141532217 40.77148888354161)   19 4 19 13
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
2521 2521 -73.976869549792 40.7706982454723 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree false false false false false relaxing false false false true false false true false   POINT (-73.976869549792 40.7706982454723)   19 4 19 13
2547 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
2583 2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   19 4 19 13
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true checkin' his stashes false false false true false true false true   POINT (-73.9767953468937 40.7676376977667)   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 65.98ms