squirrels

58 rows where Kuks = "true" and Location = "Above Ground" sorted by Approaches

✎ 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, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Location ✖

  • Above Ground · 58 ✖

Kuks ✖

  • true · 58 ✖
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
5 5 -73.9593126695714 40.797533370163 39B-AM-1018-01 39B AM 10182018 1       +   Above Ground     false false false false false unknown true false false false false false false false   POINT (-73.9593126695714 40.797533370163)   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
260 260 -73.978436117932 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree false false true false false   true false false false false false false false   POINT (-73.978436117932 40.7724769242403)   19 4 19 13
286 286 -73.9720907384613 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   false false true false false   true false false false false false true false   POINT (-73.9720907384613 40.7762987836055)   19 4 19 13
384 384 -73.968045072743 40.7836626717225 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   false false true false true   true false false true false false false true   POINT (-73.968045072743 40.7836626717225)   19 4 19 13
401 401 -73.965862100991 40.7825926896917 22D-PM-1012-01 22D PM 10122018 1 Adult Gray Black, White Gray+Black, White   Above Ground 5   false false true false false   true false false false false false false false climbing tree POINT (-73.965862100991 40.7825926896917)   19 4 19 13
415 415 -73.9570131890379 40.7991786736124 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true true   POINT (-73.9570131890379 40.7991786736124)   19 4 19 13
433 433 -73.9558474701153 40.7913335515534 34H-AM-1007-01 34H AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree false false false false false   true true false false false false false false   POINT (-73.9558474701153 40.7913335515534)   19 4 19 13
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree false false false false false   true true false false false false false false not backing down POINT (-73.9690968160819 40.769923269444)   19 4 19 13
512 512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
686 686 -73.9695745672033 40.7791835122147 17D-AM-1008-06 17D AM 10082018 6       +   Above Ground   high in tree, couldn't see it, only heard it false false false false false   true false false false false false false false   POINT (-73.9695745672033 40.7791835122147)   19 4 19 13
767 767 -73.9655734633649 40.7805366922231 20F-AM-1014-02 20F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false pulling leaves true false false false false false false false   POINT (-73.9655734633649 40.7805366922231)   19 4 19 13
771 771 -73.9648626810032 40.7804506112843 20G-AM-1018-02 20G AM 10182018 2 Adult Gray   Gray+   Above Ground 5 Ran up tree true false true false false   true false false false false false false false   POINT (-73.9648626810032 40.7804506112843)   19 4 19 13
935 935 -73.9666195118963 40.7839216739357 22C-PM-1006-10 22C PM 10062018 10 Adult Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666195118963 40.78392167393571)   19 4 19 13
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   true false true false true   true true false false false false true false   POINT (-73.9547959269955 40.7925162926273)   19 4 19 13
1144 1144 -73.9743184653765 40.7667932997 3G-AM-1008-01 03G AM 10082018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9743184653765 40.7667932997)   19 4 19 13
1206 1206 -73.9748709206354 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   false false true false false   true false false false false false false true   POINT (-73.9748709206354 40.77608025411)   19 4 19 13
1262 1262 -73.9683345414813 40.7779016280345 16E-PM-1018-07 16E PM 10182018 7 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   true false false false false false true false   POINT (-73.9683345414813 40.7779016280345)   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
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
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
1397 1397 -73.9655233748105 40.7792737287734 18G-AM-1014-01 18G AM 10142018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true false false   true false false false false false true false looking POINT (-73.9655233748105 40.7792737287734)   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
1420 1420 -73.9647605121306 40.7803961531517 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree true false false false false   true false false false false false false false   POINT (-73.9647605121306 40.7803961531517)   19 4 19 13
1449 1449 -73.9561124892063 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   false false true true false   true false false false false false false true   POINT (-73.9561124892063 40.7949440648632)   19 4 19 13
1508 1508 -73.9693894305786 40.7756906748026 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false false false false   true false false false false false false false   POINT (-73.9693894305786 40.7756906748026)   19 4 19 13
1574 1574 -73.9561840935803 40.7992037821497 42C-PM-1013-05 42C PM 10132018 5 Adult Gray   Gray+   Above Ground 20   false false false true false   true false false false false false true false   POINT (-73.9561840935803 40.7992037821497)   19 4 19 13
1596 1596 -73.9666945123922 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666945123922 40.7839956493194)   19 4 19 13
1625 1625 -73.9736873018042 40.7649106677138 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree false false true false false   true false false false false false false true   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
1768 1768 -73.9773696455031 40.7687241866704 3D-PM-1010-14 03D PM 10102018 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false crying out true true false false false false false false   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
1778 1778 -73.9685598106128 40.7807054868066 19D-PM-1008-02 19D PM 10082018 2       + unknown - cannot see, only hear Above Ground     false false false false false   true false false false false false false false   POINT (-73.9685598106128 40.7807054868066)   19 4 19 13
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   false true false false false chasing squirrel #6 true true false false true false false false   POINT (-73.978844141973 40.7696046074378)   19 4 19 13
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   false false true false false   true true false false false false false true   POINT (-73.9581366214863 40.7988964092722)   19 4 19 13
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   false false true false false   true false false false false false true false   POINT (-73.956806913988 40.7987736900857)   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
1955 1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   true false false false false false true false   POINT (-73.9606559309874 40.7889527629826)   19 4 19 13
2026 2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch false false false false false watching me scratching true false false true false false true false   POINT (-73.9622752768962 40.7814921913101)   19 4 19 13
2056 2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   false false true false false   true false false false false false true false   POINT (-73.9589600626433 40.7913690265064)   19 4 19 13
2069 2069 -73.9538377039825 40.7980605334961 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree false false true false true   true false false false false false true false   POINT (-73.9538377039825 40.7980605334961)   19 4 19 13
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2195 2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true true false   true false false false false false true false   POINT (-73.955352152771 40.7988549523022)   19 4 19 13
2206 2206 -73.9594446018346 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   false false true false false   true true false false false false false true runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)   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
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true false false   true false false false false false false false   POINT (-73.9587678566254 40.7962656030995)   19 4 19 13
2295 2295 -73.9590632051055 40.7963146584827 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   false false false false false sitting in tree true true false true false false true false observant POINT (-73.9590632051055 40.7963146584827)   19 4 19 13
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   false false true true true   true false false false false false true false   POINT (-73.9789251806378 40.7699558513225)   19 4 19 13
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   false false false false false   true false false false false false false false   POINT (-73.9567801028221 40.7960096659564)   19 4 19 13
2478 2478 -73.9674931070324 40.7783693690954 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   false false false true false chilling true false false false false false true false   POINT (-73.9674931070324 40.7783693690954)   19 4 19 13
2515 2515 -73.9693338657183 40.7757055884538 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk true false false true true   true false false false true false false false   POINT (-73.9693338657183 40.77570558845381)   19 4 19 13
2588 2588 -73.9581007437094 40.7959403112722 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   false false true false false   true false false true false false true false   POINT (-73.9581007437094 40.7959403112722)   19 4 19 13
2693 2693 -73.9561498646036 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks false false false false false   true false false false false false false false   POINT (-73.9561498646036 40.79492885618931)   19 4 19 13
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   19 4 19 13
2731 2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   false false true false false   true true false false false false true true   POINT (-73.9595886063173 40.7918405182594)   19 4 19 13
2960 2960 -73.962524814515 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true false   POINT (-73.962524814515 40.7810022923615)   19 4 19 13
3011 3011 -73.9678831312936 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   false false false false false   true false false false false false false false scolding POINT (-73.9678831312936 40.7847605974975)   19 4 19 13
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   false false true true false eating (on branch) true false false false false false true false   POINT (-73.9662895079734 40.7843300758044)   19 4 19 13
188 188 -73.9570528770427 40.7990973804149 41B-AM-1010-07 41B AM 10102018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   false false false false false   true false false true false true false false mad! POINT (-73.9570528770427 40.7990973804149)   19 4 19 13
2005 2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   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 73.815ms