squirrels

23 rows where Hectare Squirrel Number = 11 and Shift = "PM" sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Shift ✖

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
126 126 -73.9792155473689 40.7693711799946 3B-PM-1007-11 03B PM 10072018 11 Adult Gray   Gray+   Above Ground 5 in tree false false true false false   false false false false false false false false   POINT (-73.9792155473689 40.7693711799946)   19 4 19 13
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
281 281 -73.9619411917909 40.7923536640283 33B-PM-1010-11 33B PM 10102018 11 Adult Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9619411917909 40.7923536640283)   19 4 19 13
332 332 -73.9705123624953 40.7731723757869 10F-PM-1019-11 10F PM 10192018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Grassy area false false false false true   false false false false false false false true   POINT (-73.9705123624953 40.7731723757869)   19 4 19 13
366 366 -73.9673548527075 40.7765669058396 15G-PM-1019-11 15G PM 10192018 11 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false stared POINT (-73.9673548527075 40.7765669058396)   19 4 19 13
390 390 -73.970720187655 40.7774564799983 14D-PM-1019-11 14D PM 10192018 11 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.970720187655 40.7774564799983)   19 4 19 13
625 625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.97642353733221 40.770606513989)   19 4 19 13
678 678 -73.977447585355 40.7697167828003 4C-PM-1010-11 04C PM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false false   POINT (-73.977447585355 40.7697167828003)   19 4 19 13
952 952 -73.9699763667769 40.7757060731026 13E-PM-1008-11 13E PM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9699763667769 40.775706073102604)   19 4 19 13
1131 1131 -73.9793082679745 40.7679930598805 2C-PM-1013-11 02C PM 10132018 11 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9793082679745 40.7679930598805)   19 4 19 13
1344 1344 -73.9618591510932 40.7921343738001 32C-PM-1013-11 32C PM 10132018 11 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9618591510932 40.7921343738001)   19 4 19 13
1417 1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.974828939898 40.7668886121909)   19 4 19 13
1596 1596 -73.9666945123922 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666945123922 40.7839956493194)   19 4 19 13
1631 1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false false false false true me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
1787 1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false false true false true false   POINT (-73.9720365327715 40.7762329714016)   19 4 19 13
1903 1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701379806066 40.7785234812393)   19 4 19 13
1913 1913 -73.9774630821854 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774630821854 40.76806266740861)   19 4 19 13
1946 1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9692925815903 40.7774506065008)   19 4 19 13
2348 2348 -73.9531965469704 40.7947437983977 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false true true false   POINT (-73.9531965469704 40.7947437983977)   19 4 19 13
2376 2376 -73.9594204646985 40.7905923765213 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9594204646985 40.7905923765213)   19 4 19 13
2672 2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9614599022015 40.7945181285991)   19 4 19 13
2760 2760 -73.9701808122548 40.7744632730919 12F-PM-1007-11 12F PM 10072018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701808122548 40.7744632730919)   19 4 19 13
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree false false true false false   false false false false false false false false   POINT (-73.9653873284496 40.7804699882574)   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 231.882ms