squirrels

30 rows where Chasing = "true" and Eating = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Climbing ✖

Eating ✖

  • true · 30 ✖

Community Districts ✖

Chasing ✖

  • true · 30 ✖
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
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false true false true false   false false false false false false true false   POINT (-73.970252675331 40.77059995882221)   19 4 19 13
82 82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   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
315 315 -73.9539734770934 40.7956055442 39G-PM-1013-04 39G PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false false false   POINT (-73.9539734770934 40.7956055442)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
629 629 -73.9573724133264 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true false chasing (#1) false false false false false false false true   POINT (-73.9573724133264 40.7980080911115)   19 4 19 13
684 684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9691057326088 40.7765973509721)   19 4 19 13
740 740 -73.9583477850634 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true true   true false false false true false false false   POINT (-73.9583477850634 40.7914073632782)   19 4 19 13
874 874 -73.9591957793992 40.7949568873453 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9591957793992 40.7949568873453)   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
1009 1009 -73.9636551433178 40.7901572818776 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false true false true true   false false false false true false false true   POINT (-73.9636551433178 40.7901572818776)   19 4 19 13
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false false false true false   POINT (-73.9716271494641 40.7796462634184)   19 4 19 13
1167 1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9593244415072 40.794964729747)   19 4 19 13
1282 1282 -73.974451175321 40.7701294635264 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #3 false false false false false false true false   POINT (-73.974451175321 40.7701294635264)   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
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   false true false true true   false false false false true false true false   POINT (-73.9704677007779 40.7786860108302)   19 4 19 13
1513 1513 -73.9662409997642 40.7891042935432 28A-PM-1007-03 28A PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false true true chasing #2 took #2 food wrapper and is foraging through it false false false false false false true false   POINT (-73.9662409997642 40.7891042935432)   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
1705 1705 -73.9765417282001 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765417282001 40.7740994735325)   19 4 19 13
1772 1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true true false true true   false false false false false false true false   POINT (-73.9690540696008 40.7766014124609)   19 4 19 13
1971 1971 -73.9591880400132 40.7950071252836 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   true true false false true false true false   POINT (-73.95918804001322 40.7950071252836)   19 4 19 13
2106 2106 -73.9801651470389 40.7677698656935 1B-AM-1012-05 01B AM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9801651470389 40.7677698656935)   19 4 19 13
2118 2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9801956082236 40.767836440957)   19 4 19 13
2485 2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   19 4 19 13
2845 2845 -73.9765016413674 40.7740672862953 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765016413674 40.7740672862953)   19 4 19 13
2946 2946 -73.974515099169 40.7700650799886 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #4 false false false false false false true false   POINT (-73.974515099169 40.770065079988605)   19 4 19 13
2993 2993 -73.9570722262693 40.7985706143519 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true chasing (#3) false false false false false false true false   POINT (-73.9570722262693 40.7985706143519)   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 199.304ms