squirrels

21 rows where Date = 10082018, Foraging = "false" and Hectare Squirrel Number = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, 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, Other Activities, Kuks, Tail twitches, 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
196 196 -73.965796978969 40.7760402842845 15H-PM-1008-03 15H PM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE lawn moving east over Park path false false false false false not sure walk-pause-walk false false false false false false true false   POINT (-73.96579697896901 40.7760402842845)   19 4 19 13
279 279 -73.9550082056509 40.7894521543449 33I-AM-1008-03 33I AM 10082018 3 Adult Gray   Gray+   Above Ground 2 98th @ edge of park false false true false false   false false false false false false true false   POINT (-73.9550082056509 40.7894521543449)   19 4 19 13
645 645 -73.9758152322587 40.7692377401467 4E-PM-1008-03 04E PM 10082018 3 Adult Gray   Gray+         false true false false false chasing #4 false false false false false false false false   POINT (-73.9758152322587 40.7692377401467)   19 4 19 13
665 665 -73.9563661256875 40.7966823114508 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9563661256875 40.7966823114508)   19 4 19 13
695 695 -73.9685080639873 40.7745309794155 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree false false true false false   false false false false false false true false   POINT (-73.9685080639873 40.77453097941551)   19 4 19 13
811 811 -73.9771695272048 40.7724277276263 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771695272048 40.7724277276263)   19 4 19 13
925 925 -73.9763116425885 40.7688839576487 4D-PM-1008-03 04D PM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true ran two feet up tree trunk POINT (-73.9763116425885 40.7688839576487)   19 4 19 13
978 978 -73.9676692772518 40.7764726688908 15G-AM-1008-03 15G AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   true false false false false false false false   POINT (-73.9676692772518 40.7764726688908)   19 4 19 13
1116 1116 -73.9729847109778 40.7740709049602 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9729847109778 40.7740709049602)   19 4 19 13
1569 1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.973047824163 40.7700873791211)   19 4 19 13
1610 1610 -73.9607056611532 40.7889786103871 30E-AM-1008-03 30E AM 10082018 3 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false false false true false   POINT (-73.9607056611532 40.7889786103871)   19 4 19 13
1664 1664 -73.9729142912203 40.7724091146678 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729142912203 40.7724091146678)   19 4 19 13
1715 1715 -73.9745709109056 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   true false true false false in tree false false false false false false true false   POINT (-73.9745709109056 40.7672225695415)   19 4 19 13
1863 1863 -73.9682830510954 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree false false false true false   false false false false false false true false   POINT (-73.9682830510954 40.7810151087286)   19 4 19 13
2091 2091 -73.9676112864286 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road true false false false false   false false false false true false true false   POINT (-73.9676112864286 40.7772792086081)   19 4 19 13
2151 2151 -73.9697178769788 40.7791544102422 17D-AM-1008-03 17D AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.96971787697882 40.7791544102422)   19 4 19 13
2268 2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590191655172 40.7926139425111)   19 4 19 13
2334 2334 -73.9754922970511 40.7707686392991 6D-AM-1008-03 06D AM 10082018 3 Juvenile Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9754922970511 40.7707686392991)   19 4 19 13
2452 2452 -73.9727323797981 40.7669035463955 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest false false true false false   false false false false false false true false   POINT (-73.9727323797981 40.7669035463955)   19 4 19 13
2528 2528 -73.9676529780724 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676529780724 40.7823206990549)   19 4 19 13
2630 2630 -73.965019827314 40.7759864291323 15I-AM-1008-03 15I AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.965019827314 40.7759864291323)   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 117.554ms