squirrels

35 rows where Date = 10072018 and Hectare Squirrel Number = 5 sorted by Longitude

✎ 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, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts ✖

Hectare Squirrel Number ✖

Date ✖

  • 10072018 · 35 ✖
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
599 599 -73.9530263552489 40.7920949788358 36I-PM-1007-05 36I PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9530263552489 40.7920949788358)   19 4 19 13
1324 1324 -73.954554245377 40.7983935730557 41E-AM-1007-05 41E AM 10072018 5 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true man/pit bull mix wandered POINT (-73.954554245377 40.7983935730557)   19 4 19 13
2173 2173 -73.9546123259441 40.7941434862099 37G-PM-1007-05 37G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false jumping around! false false false false false false false false   POINT (-73.9546123259441 40.7941434862099)   19 4 19 13
795 795 -73.9582523503306 40.7996897499473 41A-PM-1007-05 41A PM 10072018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9582523503306 40.7996897499473)   19 4 19 13
2000 2000 -73.9591070579246 40.7896776771157 31F-PM-1007-05 31F PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9591070579246 40.7896776771157)   19 4 19 13
634 634 -73.9596375907038 40.7907347708353 32E-AM-1007-05 32E AM 10072018 5 Adult Black   Black+   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9596375907038 40.79073477083531)   19 4 19 13
1994 1994 -73.9598463837775 40.7834524724254 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9598463837775 40.7834524724254)   19 4 19 13
49 49 -73.9602222116708 40.793779699421 35C-AM-1007-05 35C AM 10072018 5 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9602222116708 40.793779699421)   19 4 19 13
2651 2651 -73.9632993246327 40.7888199519656 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9632993246327 40.7888199519656)   19 4 19 13
2891 2891 -73.9636482556874 40.7775831570186 18I-PM-1007-05 18I PM 10072018 5 Juvenile Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   false false false false true jumping crazily / digging hole false false false false false false true false   POINT (-73.9636482556874 40.7775831570186)   19 4 19 13
983 983 -73.9641552070803 40.7908479527923 30B-AM-1007-05 30B AM 10072018 5 Adult Gray   Gray+   Above Ground 10   true false false false false   false false false false false false false false   POINT (-73.9641552070803 40.7908479527923)   19 4 19 13
440 440 -73.9642717435966 40.782087049693 22F-AM-1007-05 22F AM 10072018 5 Adult Gray White Gray+White   Above Ground 10 tree false false true false false   false false false false false false true false   POINT (-73.9642717435966 40.782087049693)   19 4 19 13
1466 1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
36 36 -73.9662438996681 40.7890381809441 28A-PM-1007-05 28A PM 10072018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9662438996681 40.7890381809441)   19 4 19 13
928 928 -73.967042958599 40.7784370719371 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.967042958599 40.7784370719371)   19 4 19 13
2074 2074 -73.9676246014119 40.786355136088 24A-PM-1007-05 24A PM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45 in tree false false true false false   false false false false false false false false   POINT (-73.9676246014119 40.786355136088)   19 4 19 13
2305 2305 -73.9679833225379 40.7738547093402 12H-PM-1007-05 12H PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9679833225379 40.7738547093402)   19 4 19 13
613 613 -73.9688466874605 40.7737911559867 12G-PM-1007-05 12G PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9688466874605 40.7737911559867)   19 4 19 13
2365 2365 -73.9688773306324 40.7766669852358 15F-AM-1007-05 15F AM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false true   POINT (-73.9688773306324 40.7766669852358)   19 4 19 13
57 57 -73.9690175838534 40.7760432720017 14F-AM-1007-05 14F AM 10072018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690175838534 40.7760432720017)   19 4 19 13
2209 2209 -73.9697583235533 40.7787320391004 16D-AM-1007-05 16D AM 10072018 5 Adult Gray   Gray+ didn't get a good look Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.96975832355331 40.7787320391004)   19 4 19 13
475 475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9697855573137 40.7742186391935)   19 4 19 13
1407 1407 -73.9704778551644 40.7783119113627 15D-AM-1007-05 15D AM 10072018 5 Adult     +         false false false false false   false false false false false false false false   POINT (-73.9704778551644 40.7783119113627)   19 4 19 13
574 574 -73.9706360005275 40.7717074044466 9G-PM-1007-05 09G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9706360005275 40.7717074044466)   19 4 19 13
2537 2537 -73.9735533713513 40.7690605609001 5F-PM-1007-05 05F PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9735533713513 40.7690605609001)   19 4 19 13
1624 1624 -73.9737060043988 40.7725660224983 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9737060043988 40.7725660224983)   19 4 19 13
2944 2944 -73.9739403850622 40.7693162287509 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree true false false false true   false false false false false false false false   POINT (-73.9739403850622 40.7693162287509)   19 4 19 13
1944 1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
2990 2990 -73.9766012108307 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #4 false false false false false false true false   POINT (-73.9766012108307 40.7712310725379)   19 4 19 13
2486 2486 -73.9766317094163 40.7734230472026 8B-AM-1007-05 08B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9766317094163 40.7734230472026)   19 4 19 13
1446 1446 -73.9775238847836 40.7675792683587 2D-AM-1007-05 02D AM 10072018 5 Adult Gray   Gray+   Above Ground 100   true false false false false   false false false false false false false false   POINT (-73.9775238847836 40.7675792683587)   19 4 19 13
2260 2260 -73.9784685928652 40.7669924015341 1D-PM-1007-05 01D PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9784685928652 40.7669924015341)   19 4 19 13
2859 2859 -73.9786940945874 40.7690820276888 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock false false true true false   false false false false false false true false   POINT (-73.9786940945874 40.7690820276888)   19 4 19 13
2167 2167 -73.9799594281222 40.7701978146968 4A-AM-1007-05 04A AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9799594281222 40.7701978146968)   19 4 19 13
1660 1660 -73.9800499498034 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock false false false false true   false false false true true false true false   POINT (-73.9800499498034 40.770218109957305)   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 71.558ms