squirrels

44 rows where Date = 10102018 and Hectare Squirrel Number = 3 sorted by Zip Codes

✎ 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, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Hectare Squirrel Number ✖

Date ✖

  • 10102018 · 44 ✖
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
3 3 -73.9768311751004 40.7667178072558 2E-AM-1010-03 02E AM 10102018 3 Adult Cinnamon   Cinnamon+   Above Ground 4   false false true false false   false false false false false false true false   POINT (-73.9768311751004 40.76671780725581)   19 4 19 13
12 12 -73.9683613516225 40.7725908847499 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false true false true false   POINT (-73.9683613516225 40.7725908847499)   19 4 19 13
16 16 -73.9722500196844 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false grooming false false false false false false true false   POINT (-73.9722500196844 40.7742879599026)   19 4 19 13
123 123 -73.9671147090087 40.7772624641112 16G-AM-1010-03 16G AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true was hanging out w/ #2 until i showed up true false false false false false false true   POINT (-73.9671147090087 40.7772624641112)   19 4 19 13
124 124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill false false false true true   false false false true false false true true dog chased POINT (-73.9588660250232 40.7982597947515)   19 4 19 13
140 140 -73.9768652785664 40.7684838168207 3D-PM-1010-03 03D PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.97686527856641 40.7684838168207)   19 4 19 13
297 297 -73.9685604013735 40.7773439909065 15F-PM-1010-03 15F PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9685604013735 40.7773439909065)   19 4 19 13
307 307 -73.9683965841952 40.7718679848978 10I-AM-1010-03 10I AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9683965841952 40.7718679848978)   19 4 19 13
391 391 -73.9790875480358 40.7676104780657 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9790875480358 40.7676104780657)   19 4 19 13
396 396 -73.9669206605745 40.7748155701122 13H-PM-1010-03 13H PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in glen false false false true false   false false false false false false true false   POINT (-73.9669206605745 40.7748155701122)   19 4 19 13
414 414 -73.9721899838568 40.7761519045651 13C-AM-1010-03 13C AM 10102018 3 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9721899838568 40.7761519045651)   19 4 19 13
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   false false true false false   false false false false false false true false   POINT (-73.9789952029637 40.7697758333099)   19 4 19 13
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   false false true true false   false false false false false false true false   POINT (-73.9696360756453 40.7786545659072)   19 4 19 13
554 554 -73.973351945818 40.768814796037 5G-PM-1010-03 05G PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.973351945818 40.768814796037)   19 4 19 13
752 752 -73.9768617690725 40.7741877060705 9A-PM-1010-03 09A PM 10102018 3   Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false froze - standing on hind legs for ~10 seconds then scampered off POINT (-73.97686176907251 40.7741877060705)   19 4 19 13
828 828 -73.9545101041865 40.7903823616782 34I-PM-1010-03 34I PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE in the playground. true false false false true with some nuts in the mouth false false false false false false false false   POINT (-73.9545101041865 40.7903823616782)   19 4 19 13
893 893 -73.9799311173259 40.7685576997559 2B-AM-1010-03 02B AM 10102018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9799311173259 40.7685576997559)   19 4 19 13
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree false false true false false   false false false false false false true false   POINT (-73.9527227282134 40.7935061484064)   19 4 19 13
1268 1268 -73.9623984262936 40.7913900453449 31C-PM-1010-03 31C PM 10102018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9623984262936 40.7913900453449)   19 4 19 13
1448 1448 -73.9772810073685 40.7693577540392 4C-PM-1010-03 04C PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false true   false false false false false false true false   POINT (-73.9772810073685 40.7693577540392)   19 4 19 13
1548 1548 -73.9790044506465 40.7689469479245 3B-AM-1010-03 03B AM 10102018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false chasing #2 false false false false false false false true   POINT (-73.9790044506465 40.7689469479245)   19 4 19 13
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree false false true true true   false false false false true false true false   POINT (-73.9594391759139 40.784115697669)   19 4 19 13
1672 1672 -73.9640989602986 40.7899295439265 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9640989602986 40.7899295439265)   19 4 19 13
1773 1773 -73.9611126813593 40.7943113021522 35B-AM-1010-03 35B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9611126813593 40.7943113021522)   19 4 19 13
1824 1824 -73.9617250054003 40.7925390432044 33B-PM-1010-03 33B PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false true false false true   POINT (-73.9617250054003 40.7925390432044)   19 4 19 13
1829 1829 -73.9746965894947 40.7664351724309 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9746965894947 40.7664351724309)   19 4 19 13
1890 1890 -73.9787723082807 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9787723082807 40.7713655754004)   19 4 19 13
1979 1979 -73.9612759291399 40.7930468323219 33B-AM-1010-03 33B AM 10102018 3 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9612759291399 40.7930468323219)   19 4 19 13
2076 2076 -73.9712636931964 40.77998098773 17B-AM-1010-03 17B AM 10102018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   false false false false false false false false   POINT (-73.9712636931964 40.77998098773)   19 4 19 13
2127 2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9562442622553 40.7957285542564)   19 4 19 13
2172 2172 -73.9642900903774 40.7917017168842 31A-AM-1010-03 31A AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9642900903774 40.7917017168842)   19 4 19 13
2256 2256 -73.9720050204318 40.7699419094168 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9720050204318 40.7699419094168)   19 4 19 13
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   true false true false true   false false false false false false true false   POINT (-73.975565603566 40.7738462518304)   19 4 19 13
2379 2379 -73.9711865134364 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   false false false true false sitting false false false false false false true false   POINT (-73.9711865134364 40.7785039981892)   19 4 19 13
2392 2392 -73.9578981223015 40.7989967754358 41B-AM-1010-03 41B AM 10102018 3 Adult     +   Above Ground 60   false false false false false   false false false false false false false false   POINT (-73.9578981223015 40.7989967754358)   19 4 19 13
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2476 2476 -73.9710843362124 40.7679739601336 5I-AM-1010-03 05I AM 10102018 3 Adult Gray   Gray+   Above Ground 3   false false false false false   false false false false false false true false   POINT (-73.9710843362124 40.7679739601336)   19 4 19 13
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk false false false true false   false false false false false false true false   POINT (-73.9810149147578 40.7683925377714)   19 4 19 13
2620 2620 -73.9771800098131 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9771800098131 40.7708863131336)   19 4 19 13
2631 2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true true   POINT (-73.9690080105286 40.7710230515054)   19 4 19 13
2912 2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9632164738341 40.7921270121312)   19 4 19 13
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   true false false false false   false false false false false false true false   POINT (-73.9722053355548 40.7662094993614)   19 4 19 13
2946 2946 -73.974515099169 40.7700650799886 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #4 false false false false false false true false   POINT (-73.974515099169 40.770065079988605)   19 4 19 13
2957 2957 -73.9747313152152 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9747313152152 40.7653888351839)   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.659ms