squirrels

45 rows where Date = 10172018, Foraging = "false" and Shift = "PM" sorted by Approaches

View and edit SQL

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Shift

Foraging

  • false · 45

Date

  • 10172018 · 45
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
105 -73.9589249555235 40.7908193284981 32E-PM-1017-03 32E PM 10172018 3 Adult Gray   Gray+   Above Ground 2 bottom of tree false false false true false still false false false false false false true false   POINT (-73.9589249555235 40.7908193284981)   19 4 19 13
174 -73.9707274055755 40.7723889080377 10G-PM-1017-10 10G PM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   false true false false false playing (with #9) false false false false false false true false   POINT (-73.9707274055755 40.7723889080377)   19 4 19 13
288 -73.9731113265165 40.7786640676355 15A-PM-1017-01 15A PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   false false true true false eating in tree false false false false false false true false   POINT (-73.9731113265165 40.7786640676355)   19 4 19 13
321 -73.9694288806212 40.7842952265291 22A-PM-1017-01 22A PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9694288806212 40.7842952265291)   19 4 19 13
368 -73.970315671921 40.7720905395472 10G-PM-1017-02 10G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970315671921 40.7720905395472)   19 4 19 13
430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
438 -73.9525747516914 40.7977257435263 42F-PM-1017-02 42F PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false playing false false false false false false true false   POINT (-73.95257475169142 40.7977257435263)   19 4 19 13
457 -73.965848283831 40.7797243033057 19F-PM-1017-01 19F PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.965848283831 40.7797243033057)   19 4 19 13
461 -73.9648195433192 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false staring false false false false true false false false   POINT (-73.9648195433192 40.7796399955868)   19 4 19 13
533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false true false false true   POINT (-73.9652584749758 40.7803011124382)   19 4 19 13
542 -73.9713487591577 40.7784353043714 15C-PM-1017-03 15C PM 10172018 3 Adult Black   Black+   Above Ground 17 running across overpass true false false false false   false false false false false false true false   POINT (-73.9713487591577 40.7784353043714)   19 4 19 13
679 -73.955018489069 40.7971235333699 40E-PM-1017-02 40E PM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.955018489069 40.7971235333699)   19 4 19 13
805 -73.9706851546184 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence true false false false false   false false false false false false true false   POINT (-73.9706851546184 40.7780777016038)   19 4 19 13
808 -73.9716881838671 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   false false true false false   false false false false false false false true   POINT (-73.9716881838671 40.778553537087)   19 4 19 13
834 -73.9703914126866 40.7722457975176 10G-PM-1017-01 10G PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false false standing false false false false false false true false   POINT (-73.9703914126866 40.7722457975176)   19 4 19 13
844 -73.9642379942652 40.7774792520738 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false false was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)   19 4 19 13
940 -73.9700879096644 40.7765899724756 14E-PM-1017-05 14E PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9700879096644 40.7765899724756)   19 4 19 13
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
1173 -73.959070754026 40.7906675143413 32E-PM-1017-07 32E PM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE treed area false false true false false   false false false false false false false true   POINT (-73.959070754026 40.7906675143413)   19 4 19 13
1182 -73.9667206046912 40.7779993565098 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667206046912 40.7779993565098)   19 4 19 13
1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9634835346077 40.7918244310746)   19 4 19 13
1210 -73.9707937464541 40.7725282708448 10G-PM-1017-07 10G PM 10172018 7 Adult Black White Black+White   Ground Plane FALSE   false false false false false traveling false false false false false false true false   POINT (-73.9707937464541 40.7725282708448)   19 4 19 13
1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   true false true false false   false false false false false false false true   POINT (-73.9664986446294 40.778308334318)   19 4 19 13
1479 -73.9707498430394 40.7723724480959 10G-PM-1017-09 10G PM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9707498430394 40.7723724480959)   19 4 19 13
1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.96423978295472 40.7918992406575)   19 4 19 13
1731 -73.9692846326638 40.7841049008492 22A-PM-1017-02 22A PM 10172018 2 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9692846326638 40.7841049008492)   19 4 19 13
1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true false false true   POINT (-73.9652134469963 40.7803438278765)   19 4 19 13
1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false false false false false false false false   POINT (-73.9693159934697 40.7831212338295)   19 4 19 13
1846 -73.9653311136561 40.780193490343 19F-PM-1017-07 19F PM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9653311136561 40.78019349034301)   19 4 19 13
1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false true false false false false false false stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)   19 4 19 13
2071 -73.9667694439895 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667694439895 40.7779501809095)   19 4 19 13
2083 -73.9702382274798 40.7721754848905 10G-PM-1017-03 10G PM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9702382274798 40.7721754848905)   19 4 19 13
2137 -73.9648831611629 40.7801326414973 19G-PM-1017-02 19G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false patting ground false false false false true false false true   POINT (-73.9648831611629 40.7801326414973)   19 4 19 13
2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false digging/burying,drinking from lake false false false false true false true false   POINT (-73.9737247632185 40.7759469280872)   19 4 19 13
2442 -73.9699369796844 40.7720350191273 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9699369796844 40.7720350191273)   19 4 19 13
2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false playing false false false false false false true false   POINT (-73.9526681107152 40.7977012009146)   19 4 19 13
2658 -73.9690212174 40.7834099404107 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9690212174 40.7834099404107)   19 4 19 13
2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false walking false false false false false false false false stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)   19 4 19 13
2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false false paused to look at me POINT (-73.9692660977515 40.7830532310766)   19 4 19 13
2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9705409446299 40.7764608087703)   19 4 19 13
2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         true false false false false   false false false false false false true false   POINT (-73.953092053256 40.7982256930243)   19 4 19 13
2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9532163535175 40.7982970313067)   19 4 19 13
2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.969370141813 40.7840721191988)   19 4 19 13
682 -73.9651828383592 40.7802820943863 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true true false false   POINT (-73.9651828383592 40.7802820943863)   19 4 19 13
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

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 75.174ms