squirrels

25 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 8, Police Precincts = 13, Primary Fur Color = "Gray" and Runs from = "false" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches, Indifferent

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
152 152 -73.9755133710665 40.7697883435981 5E-AM-1008-08 05E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9755133710665 40.7697883435981)   19 4 19 13
564 564 -73.9570086212285 40.7946679755816 37E-PM-1006-08 37E PM 10062018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95700862122851 40.7946679755816)   19 4 19 13
1000 1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   19 4 19 13
1065 1065 -73.9769700777377 40.7728489574967 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   true false false false false   false false false false false false true false   POINT (-73.9769700777377 40.7728489574967)   19 4 19 13
1069 1069 -73.9595485734618 40.7835326425693 25I-PM-1007-08 25I PM 10072018 8 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #7 false false false false false   false false false false false false false false   POINT (-73.9595485734618 40.7835326425693)   19 4 19 13
1084 1084 -73.9698839750249 40.7781433076692 16D-PM-1010-08 16D PM 10102018 8 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false true false   POINT (-73.9698839750249 40.7781433076692)   19 4 19 13
1234 1234 -73.9701412231078 40.7714534088899 9H-PM-1018-08 09H PM 10182018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9701412231078 40.7714534088899)   19 4 19 13
1378 1378 -73.9669762657479 40.7835913293646 22C-PM-1006-08 22C PM 10062018 8 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669762657479 40.7835913293646)   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
1684 1684 -73.9637824756607 40.7904737110761 30B-AM-1007-08 30B AM 10072018 8 Adult Gray   Gray+   Above Ground 40   true false false true false   false false false false false false false false   POINT (-73.9637824756607 40.7904737110761)   19 4 19 13
1820 1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false true false true false   POINT (-73.9546337446865 40.7898772579576)   19 4 19 13
1821 1821 -73.9676314068477 40.7788030406918 17E-AM-1017-08 17E AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9676314068477 40.7788030406918)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
2198 2198 -73.9709738166531 40.7774102689734 14D-PM-1019-08 14D PM 10192018 8 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9709738166531 40.7774102689734)   19 4 19 13
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
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
2826 2826 -73.9600357018376 40.7906539766881 32E-AM-1007-08 32E AM 10072018 8 Adult Gray   Gray+   Above Ground 65 tree top false false true false false   false false false false false false false false   POINT (-73.9600357018376 40.7906539766881)   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
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
1321 1321 -73.9699285688296 40.7774474015189 15D-AM-1007-08 15D AM 10072018 8 Adult Gray   Gray+   Ground Plane FALSE   false true false false true chasing #7 false false false false false false true false   POINT (-73.9699285688296 40.7774474015189)   19 4 19 13
1527 1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#7),playing? false false false false false false true false   POINT (-73.970216605149 40.7702960667277)   19 4 19 13
801 801 -73.9743342303548 40.7727742948332 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   false false false false false communicating from tree false false false false false false false false   POINT (-73.97433423035481 40.7727742948332)   19 4 19 13
1546 1546 -73.976422624924 40.7735818387346 8B-AM-1007-08 08B AM 10072018 8 Adult Gray   Gray+   Above Ground 6   false false false true false holding nut false false false false false false true false   POINT (-73.976422624924 40.7735818387346)   19 4 19 13
1598 1598 -73.9726828460055 40.7705707694822 7F-AM-1008-08 07F AM 10082018 8 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #9 false false false false false false true false   POINT (-73.9726828460055 40.7705707694822)   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 83.875ms