squirrels

37 rows where Date = 10072018, Eating = "true" and Foraging = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Other Activities, Tail flags, Tail twitches, Approaches, 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
68 68 -73.9694240327509 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         false false false true true   false false false false false false true false   POINT (-73.96942403275091 40.7755898126674)   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
304 304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9523001834395 40.7949231000186)   19 4 19 13
349 349 -73.9689657039917 40.7767834276767 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9689657039917 40.7767834276767)   19 4 19 13
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock false false false true true   false false false false false false true false   POINT (-73.9793952066038 40.77078376578591)   19 4 19 13
441 441 -73.9742973420446 40.7691801644292 5F-AM-1007-04 05F AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   rocks false false false true true   false false false false false false false false   POINT (-73.9742973420446 40.7691801644292)   19 4 19 13
475 475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9697855573137 40.7742186391935)   19 4 19 13
489 489 -73.97780296909 40.7676321060669 2D-AM-1007-06 02D AM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.97780296909002 40.767632106066905)   19 4 19 13
912 912 -73.958024711869 40.7938724278575 36D-PM-1007-01 36D PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.958024711869 40.7938724278575)   19 4 19 13
954 954 -73.9658443548822 40.7796704898979 19F-AM-1007-03 19F AM 10072018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true true   false false false false false false false false scared POINT (-73.9658443548822 40.7796704898979)   19 4 19 13
1067 1067 -73.9695305996721 40.7745386896959 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9695305996721 40.7745386896959)   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
1117 1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9693465383617 40.7744996336934)   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
1216 1216 -73.9707245013626 40.7780656588337 15D-AM-1007-06 15D AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9707245013626 40.7780656588337)   19 4 19 13
1404 1404 -73.9700666654946 40.7742857042581 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false stared POINT (-73.9700666654946 40.7742857042581)   19 4 19 13
1457 1457 -73.9697744662785 40.7755950428973 13F-AM-1007-04 13F AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9697744662785 40.7755950428973)   19 4 19 13
1494 1494 -73.9525752408169 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9525752408169 40.7954915417553)   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
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
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9795585338537 40.768895893226)   19 4 19 13
1906 1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9700066659086 40.7744028820163)   19 4 19 13
1944 1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
2001 2001 -73.9521655419974 40.7948785497717 39H-AM-1007-04 39H AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9521655419974 40.7948785497717)   19 4 19 13
2040 2040 -73.9648167334089 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   false false false true true digging one hole w/ determination false false false false true false false true   POINT (-73.96481673340891 40.7811164976329)   19 4 19 13
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9638312025305 40.7903826659569)   19 4 19 13
2184 2184 -73.9694938608335 40.7745700102115 12F-PM-1007-03 12F PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9694938608335 40.7745700102115)   19 4 19 13
2187 2187 -73.9699134052609 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false true true false   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
2222 2222 -73.9639048209454 40.7777373345558 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639048209454 40.7777373345558)   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
2508 2508 -73.979381450452 40.7709033697887 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false true false true false   POINT (-73.979381450452 40.770903369788705)   19 4 19 13
2566 2566 -73.9744226682925 40.7755625717273 11B-AM-1007-04 11B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9744226682925 40.7755625717273)   19 4 19 13
2579 2579 -73.9698130452581 40.7745000645436 12F-PM-1007-15 12F PM 10072018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9698130452581 40.7745000645436)   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
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9639431360458 40.7908677445466)   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 60.912ms