squirrels

24 rows where Above Ground Sighter Measurement = 1, Location = "Above Ground" and Running = "false" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Climbing, Eating, Other Activities, Kuks, Tail twitches, Indifferent, Runs from, Other Interactions

Foraging ✖

Zip Codes ✖

  • 24

Running ✖

  • false · 24 ✖

Location ✖

  • Above Ground · 24 ✖

Above Ground Sighter Measurement ✖

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
552 552 -73.9625416200877 40.7811302397912 21H-AM-1017-02 21H AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 1   false false true false false   false false false false false false false true   POINT (-73.9625416200877 40.78113023979121)   19 4 19 13
2516 2516 -73.9649823687651 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9649823687651 40.7763395359636)   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
1832 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
1916 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
1254 1254 -73.9764013589865 40.7663063499207 1F-PM-1019-03 01F PM 10192018 3 Juvenile Gray   Gray+   Above Ground 1   false false false false false hiding false false false false false false false false   POINT (-73.9764013589865 40.7663063499207)   19 4 19 13
1476 1476 -73.976609486498 40.7717832922535 7C-PM-1020-04 07C PM 10202018 4 Adult Gray   Gray+   Above Ground 1   false false true false false   false false false false false false false true   POINT (-73.976609486498 40.7717832922535)   19 4 19 13
1723 1723 -73.9747959143543 40.7768078174366 12A-AM-1008-01 12A AM 10082018 1 Adult Gray   Gray+   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9747959143543 40.7768078174366)   19 4 19 13
2122 2122 -73.9692946938852 40.7767389791452 14E-AM-1008-13 14E AM 10082018 13 Adult Gray   Gray+   Above Ground 1   false false true true true   false false false false false false true false curious POINT (-73.9692946938852 40.7767389791452)   19 4 19 13
2215 2215 -73.9674978826751 40.776288410765 15G-PM-1019-10 15G PM 10192018 10 Adult Gray   Gray+   Above Ground 1 on a log false false false true false   false false false false false false false true   POINT (-73.9674978826751 40.776288410765)   19 4 19 13
2577 2577 -73.9597048490102 40.7955846466241 37B-AM-1018-06 37B AM 10182018 6 Adult Gray   Gray+   Above Ground 1   false false true false false   false true false false false false false true   POINT (-73.9597048490102 40.7955846466241)   19 4 19 13
820 820 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 10122018 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1   false false true false false   false false false false true false false true   POINT (-73.9801902133148 40.769557595068)   19 4 19 13
1625 1625 -73.9736873018042 40.7649106677138 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree false false true false false   true false false false false false false true   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
2874 2874 -73.9597453664295 40.7891382153733 30F-PM-1007-01 30F PM 10072018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 1 tree false false true false false   false false false false true false false true   POINT (-73.9597453664295 40.7891382153733)   19 4 19 13
318 318 -73.9743990576746 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   false true false false false chasing #3 false false false false false false true false   POINT (-73.9743990576746 40.7768690723163)   19 4 19 13
758 758 -73.9703621616472 40.775032271482 12E-AM-1017-08 12E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false true false chilling false false false false false false true false   POINT (-73.9703621616472 40.775032271482)   19 4 19 13
1564 1564 -73.9703816112358 40.7773846065919 15D-PM-1017-02 15D PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false true false true   false false false false false false true false   POINT (-73.9703816112358 40.7773846065919)   19 4 19 13
1662 1662 -73.9561600237284 40.7953143196705 38E-AM-1010-10 38E AM 10102018 10 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 over a log across stream false false false false false chillin' false false false false false false false true runs from leaf blower POINT (-73.9561600237284 40.7953143196705)   19 4 19 13
1714 1714 -73.9763542780331 40.7736531303622 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush false false true false true   false false false false true false false true froze POINT (-73.9763542780331 40.773653130362206)   19 4 19 13
1923 1923 -73.9743795190073 40.7692030411004 5E-AM-1008-05 05E AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false false false true   false false false false false false true false   POINT (-73.9743795190073 40.7692030411004)   19 4 19 13
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk false false false true false   false false false false false false true false   POINT (-73.9810149147578 40.7683925377714)   19 4 19 13
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence false false false false true   false false false false false false true false   POINT (-73.9753585157592 40.7698398607941)   19 4 19 13
1161 1161 -73.9694066600156 40.7805662180672 18C-PM-1018-06 18C PM 10182018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 1   false false true true true   false false false false false false true false   POINT (-73.9694066600156 40.7805662180672)   19 4 19 13
2389 2389 -73.9801343393329 40.7691512453402 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   false false false true false   false false false false true false false true   POINT (-73.9801343393329 40.7691512453402)   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 9675.784ms