squirrels

50 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Eating = "true" and Hectare Squirrel Number = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Tail flags, Tail twitches, Indifferent, 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
32 32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9576530157255 40.7868659490397)   19 4 19 13
94 94 -73.9641971813967 40.7813537959435 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9641971813967 40.7813537959435)   19 4 19 13
112 112 -73.9651754464439 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree false false true true false   false false false false false false true false   POINT (-73.9651754464439 40.7755181941559)   19 4 19 13
161 161 -73.9649632550828 40.7809187761995 20F-PM-1007-01 20F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9649632550828 40.7809187761995)   19 4 19 13
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree false false false true true walking up & down branches false false false false false false true false   POINT (-73.9667560049684 40.7882333830729)   19 4 19 13
404 404 -73.9680774548516 40.7762491903691 14F-PM-1012-01 14F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9680774548516 40.7762491903691)   19 4 19 13
581 581 -73.9556218199258 40.7980460204041 41D-PM-1014-01 41D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false digging,drinking false false false false false false false true   POINT (-73.9556218199258 40.7980460204041)   19 4 19 13
606 606 -73.9717580228664 40.7715726159383 8F-PM-1012-01 08F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.97175802286641 40.7715726159383)   19 4 19 13
719 719 -73.9626881234742 40.7905208345549 30C-AM-1014-01 30C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9626881234742 40.7905208345549)   19 4 19 13
860 860 -73.9713519158027 40.7798470142991 17B-AM-1010-01 17B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9713519158027 40.7798470142991)   19 4 19 13
911 911 -73.9697277998257 40.7705198722028 8H-AM-1017-01 08H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9697277998257 40.7705198722028)   19 4 19 13
942 942 -73.9533923917973 40.7961701874769 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree false false true true false   false false false false false false true false   POINT (-73.9533923917973 40.7961701874769)   19 4 19 13
1052 1052 -73.9773858189627 40.770807701562 5B-PM-1013-01 05B PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9773858189627 40.770807701562)   19 4 19 13
1094 1094 -73.9773898301093 40.7708581562057 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running across ball field 5,near home plate false false false false false false true false   POINT (-73.9773898301093 40.7708581562057)   19 4 19 13
1109 1109 -73.9678154033099 40.7742783484486 12H-PM-1007-01 12H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false false true false   false false false false false false false false   POINT (-73.9678154033099 40.7742783484486)   19 4 19 13
1115 1115 -73.9545214613307 40.7943801121036 37G-PM-1007-01 37G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9545214613307 40.7943801121036)   19 4 19 13
1169 1169 -73.9570391901515 40.7930697207834 35F-AM-1007-01 35F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9570391901515 40.7930697207834)   19 4 19 13
1178 1178 -73.9507772992986 40.7949188960194 40I-PM-1013-01 40I PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   false false false true false eating (berries) false false false false false false true false   POINT (-73.9507772992986 40.7949188960194)   19 4 19 13
1208 1208 -73.9662804925774 40.7890284642399 28A-PM-1007-01 28A PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9662804925774 40.7890284642399)   19 4 19 13
1316 1316 -73.9674724790652 40.7768771349868 15G-PM-1019-01 15G PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9674724790652 40.7768771349868)   19 4 19 13
1380 1380 -73.9806959248152 40.7684820679479 2A-AM-1010-01 02A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9806959248152 40.7684820679479)   19 4 19 13
1408 1408 -73.973230162241 40.7689824531444 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence true false false true false   false false false false false false false false   POINT (-73.973230162241 40.7689824531444)   19 4 19 13
1429 1429 -73.9706533131129 40.768902033819 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     true false true true true   false false false false false false false true runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)   19 4 19 13
1499 1499 -73.9625205538171 40.7810785055136 21H-AM-1017-01 21H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9625205538171 40.7810785055136)   19 4 19 13
1609 1609 -73.9639024988123 40.7776953065849 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639024988123 40.7776953065849)   19 4 19 13
1621 1621 -73.9734969320943 40.7722754599865 8E-AM-1013-01 08E AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9734969320943 40.7722754599865)   19 4 19 13
1703 1703 -73.956998502609 40.7948117428147 37E-PM-1006-01 37E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.956998502609 40.7948117428147)   19 4 19 13
1965 1965 -73.9719359643975 40.772699885583 9F-PM-1014-01 09F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false he is fed every day by a woman who calls him "chiquita"! he ran right up to her. POINT (-73.9719359643975 40.772699885583)   19 4 19 13
1975 1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9753291616796 40.7687376032936)   19 4 19 13
2121 2121 -73.9693462354257 40.7764444385452 14E-PM-1017-01 14E PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9693462354257 40.7764444385452)   19 4 19 13
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false true false false true false   POINT (-73.9614373639552 40.7945051962914)   19 4 19 13
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9651217998407 40.7761115392738)   19 4 19 13
2169 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
2183 2183 -73.967334936601 40.7773289724189 16F-PM-1013-01 16F PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods false false false true true   false false false false false false false true   POINT (-73.967334936601 40.7773289724189)   19 4 19 13
2324 2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false digging/burying,drinking from lake false false false false true false true false   POINT (-73.9737247632185 40.7759469280872)   19 4 19 13
2382 2382 -73.9743970455533 40.7687880243986 5F-PM-1007-01 05F PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9743970455533 40.7687880243986)   19 4 19 13
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false true true true   false false false false false false false true   POINT (-73.973552877209 40.7715638228207)   19 4 19 13
2424 2424 -73.9684752839242 40.7765816261518 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   true false false true true   false false false false false false true true   POINT (-73.9684752839242 40.7765816261518)   19 4 19 13
2431 2431 -73.9630054996358 40.7905225147022 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9630054996358 40.7905225147022)   19 4 19 13
2446 2446 -73.9522704511969 40.7965668878961 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9522704511969 40.7965668878961)   19 4 19 13
2456 2456 -73.9698446365683 40.7842607168578 22A-AM-1008-01 22A AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4 on fence false false false true false   false false false false false false false false   POINT (-73.9698446365683 40.7842607168578)   19 4 19 13
2463 2463 -73.9653343572865 40.7775286924617 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true false   false false false true false false false true   POINT (-73.9653343572865 40.7775286924617)   19 4 19 13
2489 2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false true true false true false   POINT (-73.9663168490265 40.7825083721362)   19 4 19 13
2507 2507 -73.964868521585 40.7821064183815 22F-PM-1014-01 22F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.964868521585 40.7821064183815)   19 4 19 13
2580 2580 -73.970795746101 40.7704727212299 8H-PM-1014-01 08H PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970795746101 40.7704727212299)   19 4 19 13
2602 2602 -73.9754822938869 40.7717766893833 7C-PM-1020-01 07C PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9754822938869 40.7717766893833)   19 4 19 13
2682 2682 -73.9711001278389 40.7787466095841 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9711001278389 40.7787466095841)   19 4 19 13
2711 2711 -73.9628842960118 40.7938048572403 34A-PM-1013-01 34A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true took a chestnut false false false false false false false false   POINT (-73.9628842960118 40.7938048572403)   19 4 19 13
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true chirps false false false false true false true false   POINT (-73.9552595564798 40.7889533029466)   19 4 19 13
2995 2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9668442742942 40.7870781042595)   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.687ms