squirrels

119 rows where Hectare Squirrel Number = 8 sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

Kuks ✖

Police Precincts ✖

Hectare Squirrel Number ✖

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
2257 2257 -73.95431338448 40.7940537582585 37G-PM-1007-08 37G PM 10072018 8 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.95431338448 40.7940537582585)   19 4 19 13
2266 2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9716402454355 40.7665133780672)   19 4 19 13
2437 2437 -73.9619856085821 40.7919516520091 32C-PM-1013-08 32C PM 10132018 8 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9619856085821 40.7919516520091)   19 4 19 13
2535 2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   false false true false false   false false false false true false false false   POINT (-73.9700101107283 40.7696729501144)   19 4 19 13
2593 2593 -73.9590191812452 40.7906166981409 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9590191812452 40.7906166981409)   19 4 19 13
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   19 4 19 13
2662 2662 -73.9708628933624 40.7725630886784 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell true false false false true digging false false false false false false false true   POINT (-73.9708628933624 40.7725630886784)   19 4 19 13
2710 2710 -73.9577919365342 40.7960853285059 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false false false false true   POINT (-73.9577919365342 40.7960853285059)   19 4 19 13
2714 2714 -73.9600738985438 40.7938328798752 35C-PM-1013-08 35C PM 10132018 8       +         false false false false false   true false false false false false false false did not *see* POINT (-73.9600738985438 40.7938328798752)   19 4 19 13
2723 2723 -73.960642602756 40.7917265419842 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false false stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)   19 4 19 13
2735 2735 -73.9768096953647 40.7708185213129 5C-PM-1010-08 05C PM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9768096953647 40.7708185213129)   19 4 19 13
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9697665830132 40.7759094917104)   19 4 19 13
2901 2901 -73.9735833104203 40.7786318041581 14A-PM-1014-08 14A PM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true new movement flailing arms while foraging false false false false false false false true   POINT (-73.9735833104203 40.7786318041581)   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
2939 2939 -73.9680204438195 40.7743882322654 13H-PM-1010-08 13H PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9680204438195 40.77438823226541)   19 4 19 13
2945 2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE false false true false false   false false false false false false true false   POINT (-73.9649103330443 40.7823913860445)   19 4 19 13
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9790980124501 40.7685934093915)   19 4 19 13
2996 2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970033345821 40.777259393859)   19 4 19 13
3004 3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9528482858163 40.7922056218325)   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 12.645ms