squirrels

29 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 7, 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, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, 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
28 28 -73.958736593111 40.7908524370626 32F-PM-1008-07 32F PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false false false true false   POINT (-73.958736593111 40.7908524370626)   19 4 19 13
76 76 -73.9530035564643 40.7921822457613 36I-PM-1007-07 36I PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9530035564643 40.7921822457613)   19 4 19 13
129 129 -73.9705092958892 40.7761092972965 13E-PM-1008-07 13E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9705092958892 40.7761092972965)   19 4 19 13
668 668 -73.9706903740547 40.7726873760687 10G-AM-1006-07 10G AM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9706903740547 40.77268737606871)   19 4 19 13
812 812 -73.9699675160516 40.7773012642758 15E-PM-1008-07 15E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9699675160516 40.7773012642758)   19 4 19 13
910 910 -73.9796383715206 40.7682477738244 2B-AM-1010-07 02B AM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9796383715206 40.7682477738244)   19 4 19 13
926 926 -73.9596006938677 40.7834706440535 25I-PM-1007-07 25I PM 10072018 7 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #8 false false false false false   false false false false false false false false   POINT (-73.9596006938677 40.7834706440535)   19 4 19 13
1073 1073 -73.9769742179824 40.7727484521829 7B-AM-1008-07 07B AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9769742179824 40.7727484521829)   19 4 19 13
1207 1207 -73.9594708328732 40.791192982895 32E-AM-1007-07 32E AM 10072018 7 Adult Gray   Gray+   Above Ground   on tennis club house roof false false true false false   false false false false false false true false   POINT (-73.9594708328732 40.791192982895)   19 4 19 13
1390 1390 -73.9677146741772 40.7788231332337 17E-AM-1017-07 17E AM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9677146741772 40.7788231332337)   19 4 19 13
1438 1438 -73.971685475224 40.7706668465923 7G-PM-1018-07 07G PM 10182018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.971685475224 40.7706668465923)   19 4 19 13
1517 1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   true false true false false   false false false false false false true false   POINT (-73.970041085185 40.783442758031306)   19 4 19 13
1666 1666 -73.9649465476871 40.7822708362663 22F-PM-1014-07 22F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9649465476871 40.7822708362663)   19 4 19 13
1771 1771 -73.9750688083336 40.7665584681025 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750688083336 40.7665584681025)   19 4 19 13
1922 1922 -73.9602197762862 40.7936850570022 35C-PM-1013-07 35C PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9602197762862 40.7936850570022)   19 4 19 13
1958 1958 -73.9693120090055 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.9693120090055 40.771096102012)   19 4 19 13
2080 2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         true false false false true   false false false false false false false false   POINT (-73.954530253849 40.7910247489879)   19 4 19 13
2292 2292 -73.9669891940463 40.7835635162331 22C-PM-1006-07 22C PM 10062018 7 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669891940463 40.7835635162331)   19 4 19 13
2339 2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2567 2567 -73.9690241805398 40.7837967580773 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9690241805398 40.7837967580773)   19 4 19 13
2707 2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2780 2780 -73.9700634278 40.7784223722453 16D-PM-1010-07 16D PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9700634278 40.7784223722453)   19 4 19 13
2311 2311 -73.9680171894351 40.7724644426313 11I-PM-1012-07 11I PM 10122018 7 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true burying its food into the ground false false false false false false false false   POINT (-73.96801718943512 40.7724644426313)   19 4 19 13
1817 1817 -73.9703076450783 40.770158422629 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#8),playing? false false false false false false true false   POINT (-73.9703076450783 40.770158422629)   19 4 19 13
2402 2402 -73.9777206733344 40.7668595585487 1D-PM-1007-07 01D PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false false lying down false false false false false false true false   POINT (-73.9777206733344 40.7668595585487)   19 4 19 13
2362 2362 -73.9700263936574 40.7699335098581 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #6 false false false false false false true false   POINT (-73.9700263936574 40.7699335098581)   19 4 19 13
2267 2267 -73.9727926335397 40.77037055775 7F-AM-1008-07 07F AM 10082018 7 Adult Gray   Gray+   Above Ground 28 next to the hole of #6 false false false false false standing false false false false false false true false   POINT (-73.9727926335397 40.77037055775)   19 4 19 13
2297 2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   false false true false false together w/ #8 false false false true false false true false   POINT (-73.9787771053108 40.76935621227501)   19 4 19 13
559 559 -73.9704166194815 40.7766720346576 14E-AM-1008-07 14E AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false false true false   POINT (-73.9704166194815 40.7766720346576)   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 8640.5ms