squirrels

52 rows where Above Ground Sighter Measurement = 3 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Above Ground Sighter Measurement ✖

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
394 394 -73.9719888241794 40.7667681685356 4I-PM-1007-03 04I PM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 ran to tree false false false false false being chased false false false false false false false false   POINT (-73.9719888241794 40.7667681685356)   19 4 19 13
2755 2755 -73.9712022111028 40.7672504368263 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp true false false false false   false false false false false false true false   POINT (-73.9712022111028 40.7672504368263)   19 4 19 13
1891 1891 -73.9749641575871 40.7673305056277 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9749641575871 40.7673305056277)   19 4 19 13
899 899 -73.9792754037291 40.7679690700399 2C-AM-1010-08 02C AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 stay on side of trunk false false true false false   false false false false false false false false   POINT (-73.9792754037291 40.7679690700399)   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
2864 2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   false false true false true   false false false false false false true false   POINT (-73.9761879300037 40.7683918970301)   19 4 19 13
1384 1384 -73.9787608762005 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   false false false false false walked between trees false false false false false false true false   POINT (-73.9787608762005 40.7686062296462)   19 4 19 13
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   19 4 19 13
2988 2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk false true true false false   false false false false true false true false   POINT (-73.9766342759486 40.7687518380873)   19 4 19 13
4 4 -73.9757249834141 40.7697032606755 5D-PM-1018-05 05D PM 10182018 5 Juvenile Gray   Gray+   Above Ground 3   false false true false false   false false false false false false false true   POINT (-73.9757249834141 40.7697032606755)   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
1788 1788 -73.9685567075413 40.7703797723105 8I-AM-1006-10 08I AM 10062018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 bush false false true false false   false false false false false false false true   POINT (-73.96855670754131 40.7703797723105)   19 4 19 13
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   true false true false false   false false false false false false false true   POINT (-73.9778730762957 40.770827251547)   19 4 19 13
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
849 849 -73.9736165917399 40.7724543901497 8D-AM-1007-04 08D AM 10072018 4 Adult Gray   Gray+   Above Ground 3   false true false false false chasing squirrel #3 false false false false false false false false   POINT (-73.9736165917399 40.7724543901497)   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
1086 1086 -73.9713399316534 40.7750678026757 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   false false true false false lounging on tree upside down false false false false true false true false   POINT (-73.9713399316534 40.7750678026757)   19 4 19 13
776 776 -73.9686816795392 40.775770422667 14F-PM-1012-02 14F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   false false true true false   false false false false false false true false   POINT (-73.9686816795392 40.775770422667)   19 4 19 13
1150 1150 -73.9744726434743 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false chased up a tree by #4 false false false false false false true false   POINT (-73.9744726434743 40.776729630785)   19 4 19 13
237 237 -73.967895656898 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence true false false false false   false false false false false false false true   POINT (-73.967895656898 40.7767409597341)   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
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk false false true false false   false false false false true false true false   POINT (-73.9686370726471 40.7780382348833)   19 4 19 13
996 996 -73.9703149829421 40.7785583630323 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9703149829421 40.7785583630323)   19 4 19 13
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   false false true true true   false false false false false false false true   POINT (-73.9657487923637 40.7786823090663)   19 4 19 13
782 782 -73.9710559113762 40.7794279914209 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   false false true false false   false false false false false false false false disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)   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
428 428 -73.96362827608 40.7807994595242 21G-AM-1014-02 21G AM 10142018 2 Adult Gray White Gray+White   Above Ground 3 fence false false true false false   false false false false false false true false   POINT (-73.96362827608 40.7807994595242)   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
1518 1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false false false false   POINT (-73.9632265832593 40.78169144754611)   19 4 19 13
1241 1241 -73.9651817987035 40.7819082838334 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree false false false true true   false false false false true false false false walks from POINT (-73.9651817987035 40.7819082838334)   19 4 19 13
1235 1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false jumping back & forth on tree false false false true true false true false   POINT (-73.9679686793869 40.7825993867876)   19 4 19 13
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false true false false false alert & aware POINT (-73.9646597452128 40.7827698220703)   19 4 19 13
1653 1653 -73.9695881075086 40.7842441291991 21A-AM-1019-01 21A AM 10192018 1 Juvenile Gray Black Gray+Black   Above Ground 3   false false true false false   false false false false false false false false keeps to tree,drops down on side away from people POINT (-73.9695881075086 40.7842441291991)   19 4 19 13
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false true false false approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)   19 4 19 13
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
1053 1053 -73.9685859705486 40.7848805065322 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree false false true false false   false false false false false false false true   POINT (-73.9685859705486 40.7848805065322)   19 4 19 13
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false false true   POINT (-73.96641208260151 40.7888022709721)   19 4 19 13
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552861155228 40.788973931872)   19 4 19 13
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552035011902 40.7889851896334)   19 4 19 13
2258 2258 -73.9547785081171 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th false false true false false   false false false false true false true false   POINT (-73.9547785081171 40.789612183711)   19 4 19 13
1825 1825 -73.9624209799704 40.7910200972752 31C-PM-1010-01 31C PM 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.9624209799704 40.7910200972752)   19 4 19 13
2663 2663 -73.9613429184974 40.7912158057267 32C-AM-1014-02 32C AM 10142018 2 Adult Gray   Gray+   Above Ground 3   false true true false false   false false false false false false false false   POINT (-73.9613429184974 40.7912158057267)   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
1631 1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false false false false true me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
1854 1854 -73.9618076359384 40.7947808718203 35A-PM-1013-05 35A PM 10132018 5 Adult Gray   Gray+   Above Ground 3 in tree false false true false false   false false false false false false false false   POINT (-73.9618076359384 40.7947808718203)   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
1162 1162 -73.9568544270881 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock false false false false false   false false false false false false false true   POINT (-73.9568544270881 40.7972517274475)   19 4 19 13
1613 1613 -73.9599202233536 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599202233536 40.7972599930224)   19 4 19 13
2466 2466 -73.9599419926299 40.7972774728811 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599419926299 40.7972774728811)   19 4 19 13
822 822 -73.9576559099012 40.7992598626483 41B-AM-1010-09 41B AM 10102018 9 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false true false   POINT (-73.9576559099012 40.7992598626483)   19 4 19 13
1433 1433 -73.9574077497624 40.8001185184892 42B-AM-1014-01 42B AM 10142018 1 Adult Gray   Gray+   Above Ground 3   false false true false false   false false false false false false true false   POINT (-73.9574077497624 40.8001185184892)   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 107.36ms