squirrels

73 rows where Date = 10102018, Foraging = "true", Indifferent = "false" and Police Precincts = 13 sorted by Approaches

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

Hectare

Combination of Primary and Highlight Color

Police Precincts

Indifferent

  • false · 73
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
13 -73.9541201789795 40.7931811701082 36H-AM-1010-02 36H AM 10102018 2 Adult Gray   Gray+ just outside hectare Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9541201789795 40.7931811701082)   19 4 19 13
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
157 -73.9637946878735 40.7915700446878 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9637946878735 40.7915700446878)   19 4 19 13
186 -73.9788138172962 40.7693001754769 3B-AM-1010-09 03B AM 10102018 9 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9788138172962 40.7693001754769)   19 4 19 13
278 -73.9787796921165 40.7707526535381 5A-PM-1010-01 05A PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9787796921165 40.7707526535381)   19 4 19 13
283 -73.9529060669193 40.7927909735388 37I-AM-1010-01 37I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9529060669193 40.7927909735388)   19 4 19 13
313 -73.9646610347972 40.7790583544252 19H-AM-1010-05 19H AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near a brush false false false true true   false false false false false false false true   POINT (-73.9646610347972 40.7790583544252)   19 4 19 13
514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   19 4 19 13
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
563 -73.9700330712119 40.7782913925727 16D-PM-1010-06 16D PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false true walking false false false false false false false false checking me out POINT (-73.9700330712119 40.7782913925727)   19 4 19 13
607 -73.9547711796823 40.7908540751983 34I-PM-1010-06 34I PM 10102018 6 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9547711796823 40.7908540751983)   19 4 19 13
625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.97642353733221 40.770606513989)   19 4 19 13
704 -73.9793565564361 40.7679259390448 2C-AM-1010-09 02C AM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false climbed up tree as i neared POINT (-73.9793565564361 40.7679259390448)   19 4 19 13
705 -73.9779228287629 40.7681019683859 3D-PM-1010-01 03D PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9779228287629 40.7681019683859)   19 4 19 13
739 -73.9620597449066 40.7922465876813 33B-PM-1010-10 33B PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true false false false false false false false   POINT (-73.9620597449066 40.7922465876813)   19 4 19 13
768 -73.9729394928432 40.7743256716496 11D-AM-1010-01 11D AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9729394928432 40.7743256716496)   19 4 19 13
769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   true false false false false false false true   POINT (-73.976521916284 40.773784724458)   19 4 19 13
785 -73.9619417432685 40.7930365939865 33B-PM-1010-12 33B PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9619417432685 40.7930365939865)   19 4 19 13
807 -73.9777259022441 40.7682059907903 3D-PM-1010-10 03D PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9777259022441 40.7682059907903)   19 4 19 13
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
903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9719941577406 40.77037129313)   19 4 19 13
968 -73.9689781843873 40.7709333833783 9I-PM-1010-04 09I PM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9689781843873 40.7709333833783)   19 4 19 13
1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   19 4 19 13
1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   19 4 19 13
1158 -73.9763894759543 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9763894759543 40.7705523372364)   19 4 19 13
1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9679457364586 40.7717350221981)   19 4 19 13
1258 -73.9789385196073 40.7675202157155 2C-AM-1010-02 02C AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9789385196073 40.7675202157155)   19 4 19 13
1277 -73.9619609976132 40.7922824443528 33B-PM-1010-09 33B PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9619609976132 40.7922824443528)   19 4 19 13
1293 -73.9775465365348 40.7681943707876 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9775465365348 40.7681943707876)   19 4 19 13
1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616693665254 40.792971019627)   19 4 19 13
1532 -73.9779263114572 40.7682681855369 3D-PM-1010-08 03D PM 10102018 8 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9779263114572 40.7682681855369)   19 4 19 13
1567 -73.9774407362587 40.7698056129554 4C-PM-1010-12 04C PM 10102018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774407362587 40.7698056129554)   19 4 19 13
1606 -73.9628932797886 40.7923116396365 32B-PM-1010-05 32B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9628932797886 40.7923116396365)   19 4 19 13
1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false false false couldn't get near POINT (-73.9806718258385 40.76927768969951)   19 4 19 13
1693 -73.9593781427412 40.7841519912635 26I-AM-1010-02 26I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   false false false false true   false false false false false false false false   POINT (-73.95937814274122 40.7841519912635)   19 4 19 13
1714 -73.9763542780331 40.7736531303622 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush false false true false true   false false false false true false false true froze POINT (-73.9763542780331 40.773653130362206)   19 4 19 13
1751 -73.9594045885402 40.7840886870652 26I-AM-1010-01 26I AM 10102018 1 Adult Gray   Gray+   Above Ground 40   false false false false true   false false false false false false false false   POINT (-73.9594045885402 40.7840886870652)   19 4 19 13
1763 -73.9768286349595 40.7687012827059 3D-PM-1010-05 03D PM 10102018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9768286349595 40.7687012827059)   19 4 19 13
1913 -73.9774630821854 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774630821854 40.76806266740861)   19 4 19 13
1996 -73.977641787698 40.7695830265784 4C-PM-1010-10 04C PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.977641787698 40.7695830265784)   19 4 19 13
2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         true false false false true   false false false false false false false false   POINT (-73.954530253849 40.7910247489879)   19 4 19 13
2097 -73.9773486521595 40.7708454902113 5C-PM-1010-02 05C PM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9773486521595 40.7708454902113)   19 4 19 13
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
2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9686925781295 40.7705688673142)   19 4 19 13
2169 -73.9787736280005 40.7676126748454 2C-AM-1010-01 02C AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9787736280005 40.7676126748454)   19 4 19 13
2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9697787673802 40.7781746195436)   19 4 19 13
2285 -73.9576325087936 40.7988448745116 41B-AM-1010-04 41B AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9576325087936 40.7988448745116)   19 4 19 13
2315 -73.9767849679735 40.768566516928 3D-PM-1010-04 03D PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9767849679735 40.768566516928)   19 4 19 13
2330 -73.9724618533895 40.7745021602455 11D-AM-1010-02 11D AM 10102018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true walking false false false false true false false true   POINT (-73.9724618533895 40.7745021602455)   19 4 19 13
2343 -73.9719194877439 40.7748000962909 11D-AM-1010-04 11D AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9719194877439 40.7748000962909)   19 4 19 13
2501 -73.9616944195776 40.7927250423024 33B-PM-1010-02 33B PM 10102018 2 Adult     +   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616944195776 40.7927250423024)   19 4 19 13
2565 -73.9708640291801 40.7781721063527 15C-AM-1010-01 15C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9708640291801 40.7781721063527)   19 4 19 13
2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree true false true false true   false false false false true false false true   POINT (-73.978199543688 40.7695660563362)   19 4 19 13
2587 -73.9789971286844 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9789971286844 40.7707024146365)   19 4 19 13
2615 -73.9734605176646 40.7686218881386 5G-PM-1010-02 05G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9734605176646 40.7686218881386)   19 4 19 13
2633 -73.9776151109912 40.7694681558386 4C-PM-1010-09 04C PM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9776151109912 40.7694681558386)   19 4 19 13
2644 -73.9775445441194 40.7697096533728 4C-PM-1010-13 04C PM 10102018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9775445441194 40.7697096533728)   19 4 19 13
2674 -73.9771009024581 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9771009024581 40.7688793288864)   19 4 19 13
2701 -73.9791217510656 40.7676583475394 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 false false false true true   false false false false false false false false   POINT (-73.9791217510656 40.7676583475394)   19 4 19 13
2769 -73.9769885189342 40.7708936173356 5C-PM-1010-06 05C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9769885189342 40.7708936173356)   19 4 19 13
2875 -73.9546616782922 40.790974533739 34I-PM-1010-05 34I PM 10102018 5 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9546616782922 40.790974533739)   19 4 19 13
2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9687020800791 40.7735903424522)   19 4 19 13
2977 -73.9580681648547 40.7992010012653 41B-AM-1010-01 41B AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9580681648547 40.7992010012653)   19 4 19 13
3015 -73.9759163300535 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9759163300535 40.7736180793606)   19 4 19 13
692 -73.9594529310985 40.7840492606552 26I-PM-1010-04 26I PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.95945293109851 40.7840492606552)   19 4 19 13
1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false true false true false false ran from human with dog POINT (-73.9643032554205 40.7794514526463)   19 4 19 13
1336 -73.9733820053679 40.7687330473562 5G-PM-1010-05 05G PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9733820053679 40.7687330473562)   19 4 19 13
1597 -73.9789401448556 40.7697373141498 4B-AM-1010-04 04B AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9789401448556 40.7697373141498)   19 4 19 13
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
2523 -73.9619016393127 40.7925160126921 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9619016393127 40.7925160126921)   19 4 19 13
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
2976 -73.9724083320538 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true drinking false false false false false true false false   POINT (-73.9724083320538 40.7744163768061)   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 77.563ms