squirrels

50 rows where Runs from = "true", Shift = "AM" and Tail twitches = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, Approaches, Indifferent, Other Interactions

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
27 27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
110 110 -73.9711318790279 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   true false false false false   false false false false true false false true   POINT (-73.9711318790279 40.7701941550273)   19 4 19 13
232 232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true true true approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)   19 4 19 13
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.958356112357 40.796014459571)   19 4 19 13
342 342 -73.9605966636226 40.7889849108637 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)   19 4 19 13
417 417 -73.9639888092327 40.791449395909 31A-AM-1010-01 31A AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9639888092327 40.791449395909005)   19 4 19 13
506 506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false true false false true   POINT (-73.9649611089685 40.7814371834837)   19 4 19 13
510 510 -73.9638590768396 40.7776782114981 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   false false true false false   false false false false true false false true   POINT (-73.9638590768396 40.7776782114981)   19 4 19 13
513 513 -73.963100689807 40.7920255189467 32B-AM-1017-02 32B AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on its head Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.963100689807 40.79202551894671)   19 4 19 13
534 534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   true false true false false   false false false false true false false true   POINT (-73.9650499507011 40.7908191782173)   19 4 19 13
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   19 4 19 13
641 641 -73.9719036217446 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree true false true false true   false false false false true false false true   POINT (-73.9719036217446 40.7803588122409)   19 4 19 13
650 650 -73.9809610117171 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence false false false true false   false false false false true false false true   POINT (-73.9809610117171 40.7683896665502)   19 4 19 13
724 724 -73.9532952763106 40.7920074462622 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#7) false false false false true false false true runs from (me) POINT (-73.95329527631061 40.7920074462622)   19 4 19 13
820 820 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 10122018 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1   false false true false false   false false false false true false false true   POINT (-73.9801902133148 40.769557595068)   19 4 19 13
923 923 -73.9578924882613 40.789806297824 32G-AM-1010-02 32G AM 10102018 2 Adult Gray   Gray+   Above Ground 13   false false true true false   false false false false true false false true   POINT (-73.9578924882613 40.789806297824)   19 4 19 13
929 929 -73.9738611257716 40.7737246779587 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   true false false false true false false true   POINT (-73.9738611257716 40.7737246779587)   19 4 19 13
987 987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree true false true false true   false false false false true false false true   POINT (-73.9719460335398 40.7810508156287)   19 4 19 13
1159 1159 -73.9682129261841 40.7754232358118 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9682129261841 40.7754232358118)   19 4 19 13
1256 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
1294 1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   true false false false false   false false false false true true false true   POINT (-73.9604089940153 40.7910028063138)   19 4 19 13
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   true false false false false   false false false false true false false true   POINT (-73.9802831706033 40.7692763295564)   19 4 19 13
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false true false false true was with a lot of robins POINT (-73.9534910562766 40.7935774443789)   19 4 19 13
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9716736557408 40.7749333494336)   19 4 19 13
1553 1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1714 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
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false true false false true runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)   19 4 19 13
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
2199 2199 -73.9677500862135 40.7726060987821 11I-AM-1012-01 11I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9677500862135 40.7726060987821)   19 4 19 13
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9694382427984 40.7846350692923)   19 4 19 13
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true false true false true   true false false false true false false true   POINT (-73.9565824187667 40.797312050952)   19 4 19 13
2271 2271 -73.9673949458096 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9673949458096 40.78262185394961)   19 4 19 13
2330 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
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false true false false true runs from (me) POINT (-73.9533645762606 40.7983709215535)   19 4 19 13
2389 2389 -73.9801343393329 40.7691512453402 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   false false false true false   false false false false true false false true   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
2406 2406 -73.9668964315686 40.7777577990886 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9668964315686 40.7777577990886)   19 4 19 13
2449 2449 -73.9599911537509 40.7914452542845 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   false false true false false   false false false false true false false true   POINT (-73.9599911537509 40.7914452542845)   19 4 19 13
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   true false true true false   false false false false true false false true   POINT (-73.9621253644004 40.7912082086879)   19 4 19 13
2757 2757 -73.9671419119456 40.7758602486862 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9671419119456 40.7758602486862)   19 4 19 13
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9647845655965 40.7816573808695)   19 4 19 13
2849 2849 -73.9709912560997 40.7758965595198 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9709912560997 40.7758965595198)   19 4 19 13
2898 2898 -73.9794118234651 40.7674495540569 1C-AM-1012-02 01C AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false true false false   false false false false true false false true   POINT (-73.9794118234651 40.7674495540569)   19 4 19 13
2963 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
2969 2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true climbed tree (oak) false false false false true false false true   POINT (-73.9654409838612 40.7901338748522)   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 76.207ms