squirrels

151 rows where Approaches = "true" and Climbing = "false" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Tail flags ✖

Climbing ✖

  • false · 51 ✖

City Council Districts ✖

Approaches ✖

  • true · 51 ✖
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
2348 2348 -73.9531965469704 40.7947437983977 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false true true false   POINT (-73.9531965469704 40.7947437983977)   19 4 19 13
2383 2383 -73.9686551213305 40.7728617837174 11H-PM-1013-04 11H PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true true false   POINT (-73.9686551213305 40.7728617837174)   19 4 19 13
2399 2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false false begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)   19 4 19 13
2428 2428 -73.9755643404768 40.7697569149388 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9755643404768 40.7697569149388)   19 4 19 13
2453 2453 -73.9756105226696 40.7696531972655 5D-AM-1020-03 05D AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9756105226696 40.7696531972655)   19 4 19 13
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   false false false false true   false false false false false true true false   POINT (-73.9550131837533 40.7958617258176)   19 4 19 13
2523 2523 -73.9619016393127 40.7925160126921 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9619016393127 40.7925160126921)   19 4 19 13
2575 2575 -73.9735753352129 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9735753352129 40.7687061447032)   19 4 19 13
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road false false false false true   false false false false false true false false   POINT (-73.9568524771058 40.7974664985551)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   19 4 19 13
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench false false false true false   false false false false false true false false   POINT (-73.9700264128414 40.7692014637698)   19 4 19 13
2670 2670 -73.9531041906469 40.7919916819219 36I-PM-1007-02 36I PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false true true true false chased birds (blue jay) POINT (-73.9531041906469 40.7919916819219)   19 4 19 13
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9690174442945 40.7817617696508)   19 4 19 13
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.957775998085 40.7932880937406)   19 4 19 13
2772 2772 -73.9677368646039 40.7821550964837 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.96773686460392 40.782155096483706)   19 4 19 13
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false true true false true   POINT (-73.9563473341712 40.78937123984251)   19 4 19 13
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating false false false true true   false false false false true true true false   POINT (-73.9809342290598 40.7687265606227)   19 4 19 13
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false true false false   POINT (-73.9531953594918 40.7960413520131)   19 4 19 13
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path false false false false true   false false false false false true false false   POINT (-73.9751615527833 40.767013871509)   19 4 19 13
2922 2922 -73.9703421391442 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9703421391442 40.7773706575356)   19 4 19 13
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9730926233232 40.7781330751738)   19 4 19 13
2932 2932 -73.9705837974358 40.7758494849673 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock false false false false true   false false false false false true false false   POINT (-73.97058379743581 40.7758494849673)   19 4 19 13
2957 2957 -73.9747313152152 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9747313152152 40.7653888351839)   19 4 19 13
2998 2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
3023 3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   19 4 19 13
806 806 -73.970475755546 40.7763348062134 13E-AM-1017-02 13E AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true begging (came one yard away from me and stood there) false false false false false true false false   POINT (-73.970475755546 40.7763348062134)   19 4 19 13
1205 1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true burying false false false false false true false false   POINT (-73.9611118778753 40.7952007875354)   19 4 19 13
2536 2536 -73.9685087288072 40.7779068128051 16E-AM-1014-01 16E AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false burying food false false false false false true false false   POINT (-73.9685087288072 40.7779068128051)   19 4 19 13
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true checkin' his stashes false false false true false true false true   POINT (-73.9767953468937 40.7676376977667)   19 4 19 13
2358 2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true cleaning face & tail false false false false true true false false   POINT (-73.9788379085607 40.7683896583055)   19 4 19 13
1721 1721 -73.9587330707463 40.7907682009641 32F-AM-1012-02 32F AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray patches on back legs Ground Plane FALSE   false false false false false curious about me false false false false false true false true   POINT (-73.9587330707463 40.7907682009641)   19 4 19 13
1340 1340 -73.9773083616259 40.7710535931636 6B-PM-1017-01 06B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false true false false   POINT (-73.9773083616259 40.7710535931636)   19 4 19 13
2976 2976 -73.9724083320538 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true drinking false false false false false true false false   POINT (-73.9724083320538 40.7744163768061)   19 4 19 13
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
1650 1650 -73.9762494239719 40.7750175306716 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields false false false true false eating (a peanut) false false false false false true false false   POINT (-73.9762494239719 40.7750175306716)   19 4 19 13
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass false false false true false eating (nuts) false false false false false true false false approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)   19 4 19 13
2275 2275 -73.9614218413356 40.7938945058793 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping false false false false true true false false   POINT (-73.9614218413356 40.7938945058793)   19 4 19 13
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false false moseying false false false false true true false false   POINT (-73.957342596188 40.7944359654227)   19 4 19 13
1137 1137 -73.9520280004414 40.7946345014466 39I-PM-1013-03 39I PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false false playing false false false false false true false false   POINT (-73.9520280004414 40.7946345014466)   19 4 19 13
1533 1533 -73.9520024654602 40.7947329828155 39I-PM-1013-04 39I PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false playing false false false false false true false false   POINT (-73.95200246546021 40.7947329828155)   19 4 19 13
1623 1623 -73.9770119133023 40.7732949090005 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence true true false true true playing tag together false false false false false true false false   POINT (-73.9770119133023 40.7732949090005)   19 4 19 13
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   false false false false true standing on back legs false false false false false true true false   POINT (-73.9601851468038 40.7968698151479)   19 4 19 13
1075 1075 -73.9640534906634 40.7777383899836 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false standing upright false false false false false true false true runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)   19 4 19 13
1111 1111 -73.9632799339872 40.7808316436308 21H-PM-1018-01 21H PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false false true true false false   POINT (-73.9632799339872 40.7808316436308)   19 4 19 13
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false true false true false false approaches (very close) POINT (-73.9682067129876 40.7779911208015)   19 4 19 13
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false false true stood on back legs false false false false false true true true   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
1322 1322 -73.9701824376506 40.7763703306736 14E-AM-1008-21 14E AM 10082018 21 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false true false false curious,but not expecting food POINT (-73.9701824376506 40.7763703306736)   19 4 19 13
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false wandering,interacting with tourists false false false false false true false false approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)   19 4 19 13
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false false false watching false false false false false true false false   POINT (-73.9651541395415 40.7798283208748)   19 4 19 13
594 594 -73.9727488640736 40.7781916780621 14B-PM-1014-06 14B PM 10142018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false watching me false false false false false true false false skittish POINT (-73.9727488640736 40.7781916780621)   19 4 19 13
478 478 -73.954482814186 40.7987031768001 42D-PM-1013-01 42D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Drawing included. Ground Plane FALSE   false false false false true watching passers-by false false false false false true true false   POINT (-73.954482814186 40.7987031768001)   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 11.201ms