squirrels

53 rows where Climbing = "true", Hectare Squirrel Number = 3 and Indifferent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, 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, Quaas, Tail flags, Tail twitches, Approaches, Runs from, 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
168 168 -73.9745691353018 40.7771035589298 13A-PM-1014-03 13A PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false false false false false false false true child chasing POINT (-73.9745691353018 40.7771035589298)   19 4 19 13
220 220 -73.967181612203 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   false false true true false   false false false false false false false false   POINT (-73.967181612203 40.7787752287055)   19 4 19 13
222 222 -73.9770273553525 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence true true true true false playing tag together false false false false false true false false   POINT (-73.9770273553525 40.7732399463626)   19 4 19 13
226 226 -73.9775681731459 40.7676421190309 2D-AM-1007-03 02D AM 10072018 3 Adult Gray   Gray+   Above Ground 100   false false true false false   false false false false false false false false   POINT (-73.9775681731459 40.7676421190309)   19 4 19 13
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area true false true false false climbing (rock) false false false false false true false false approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)   19 4 19 13
388 388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9592537496995 40.7919271821316)   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
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true runs from the dog POINT (-73.9681917366128 40.7723298813768)   19 4 19 13
461 461 -73.9648195433192 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false staring false false false false true false false false   POINT (-73.9648195433192 40.7796399955868)   19 4 19 13
561 561 -73.9581982486469 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   true false true false false   false false false false true false false false   POINT (-73.95819824864691 40.7992194575293)   19 4 19 13
665 665 -73.9563661256875 40.7966823114508 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9563661256875 40.7966823114508)   19 4 19 13
698 698 -73.9585537668382 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false bringing green leaves to nest false false false false false false false false   POINT (-73.9585537668382 40.7903905787005)   19 4 19 13
778 778 -73.9677054870327 40.778992870166 17E-AM-1017-03 17E AM 10172018 3 Adult Gray   Gray+   Above Ground 9 Tree trunk false false true false false   false false false false false false false false   POINT (-73.9677054870327 40.778992870166)   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
852 852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   true false true false false hopping false false false false false true false true   POINT (-73.9609704650925 40.7938786854735)   19 4 19 13
869 869 -73.9629483374528 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9629483374528 40.7936809905265)   19 4 19 13
958 958 -73.9613862251332 40.791282169715 32C-AM-1014-03 32C AM 10142018 3 Adult Gray   Gray+   Above Ground 3   false true true false false   false false false false false false false false   POINT (-73.9613862251332 40.791282169715)   19 4 19 13
991 991 -73.9635689059841 40.790163434915 30B-PM-1019-03 30B PM 10192018 3 Adult Gray Black Gray+Black   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9635689059841 40.790163434915)   19 4 19 13
1012 1012 -73.9755569170561 40.7668006977526 2F-AM-1006-03 02F AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false true false false   false false false false false false false false   POINT (-73.9755569170561 40.7668006977526)   19 4 19 13
1116 1116 -73.9729847109778 40.7740709049602 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9729847109778 40.7740709049602)   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
1248 1248 -73.9719729323923 40.7668318394546 4I-AM-1006-03 04I AM 10062018 3 Adult     + Can't tell :( Above Ground 28 Tree false false true false false building nest! false false false false false false false false   POINT (-73.9719729323923 40.7668318394546)   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
1328 1328 -73.9765758043111 40.7713803154032 6C-AM-1007-03 06C AM 10072018 3 Adult Gray White Gray+White   Above Ground 8 another tree true false true false false   false false false false false false false true   POINT (-73.9765758043111 40.7713803154032)   19 4 19 13
1355 1355 -73.9655277320465 40.7806120529369 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9655277320465 40.7806120529369)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1522 1522 -73.9538970554532 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9538970554532 40.7955196793479)   19 4 19 13
1543 1543 -73.9713906492842 40.7750061310143 12E-PM-1018-03 12E PM 10182018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9713906492842 40.7750061310143)   19 4 19 13
1551 1551 -73.9785114291288 40.7719779589449 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785114291288 40.7719779589449)   19 4 19 13
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   false false true false false   false false false false false false false false stared at me POINT (-73.9638167248251 40.77764856793541)   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
1931 1931 -73.9533085932603 40.7934877861075 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree false false true false false   true false false false false false false false   POINT (-73.9533085932603 40.7934877861075)   19 4 19 13
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   false false true false false   false false false false false false false false   POINT (-73.9573692542155 40.7989252908321)   19 4 19 13
2015 2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! false false true false true throwing down acorns false false false false false false false false   POINT (-73.9574365550758 40.7886924675052)   19 4 19 13
2028 2028 -73.9687347731861 40.7718955594385 10H-AM-1014-03 10H AM 10142018 3 Juvenile     +   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.9687347731861 40.7718955594385)   19 4 19 13
2034 2034 -73.9699135187297 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9699135187297 40.7782354186163)   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
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true true true   false false false false false false false true   POINT (-73.9569759970802 40.79314974522941)   19 4 19 13
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods false false true false true   false false false false false false false true   POINT (-73.96747266034902 40.7772125619715)   19 4 19 13
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   false false true true false   false false false false false false false false   POINT (-73.976716425804 40.7736889979965)   19 4 19 13
2228 2228 -73.9714045891597 40.7715418333976 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.97140458915972 40.7715418333976)   19 4 19 13
2262 2262 -73.9556177490335 40.7888569161537 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)   19 4 19 13
2377 2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9704328573603 40.7739347247552)   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
2441 2441 -73.9579865329778 40.794906535675 37D-PM-1014-03 37D PM 10142018 3 Adult Gray   Gray+   Above Ground 40   false false true false false   false false false false false false false false   POINT (-73.9579865329778 40.794906535675)   19 4 19 13
2528 2528 -73.9676529780724 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676529780724 40.7823206990549)   19 4 19 13
2534 2534 -73.9744368038675 40.7674281958115 3G-PM-1013-03 03G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true runs from (climbed tree to run from) POINT (-73.97443680386752 40.7674281958115)   19 4 19 13
2586 2586 -73.9752965316933 40.7752538575789 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree false false true false false   false false false false true true false false   POINT (-73.9752965316933 40.7752538575789)   19 4 19 13
2592 2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9758128509653 40.7715946097064)   19 4 19 13
2603 2603 -73.9708781504528 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9708781504528 40.7724138070355)   19 4 19 13
2660 2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   19 4 19 13
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false true true false false   false true false false false false false false looked at us from tree POINT (-73.9677903197449 40.7826561917755)   19 4 19 13
2985 2985 -73.9721159387757 40.7660503188637 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9721159387757 40.7660503188637)   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 83.569ms