squirrels

54 rows where Date = 10132018, Highlight Fur Color = "White" and Indifferent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

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
27 27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
29 29 -73.9671786715256 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9671786715256 40.7867352791232)   19 4 19 13
30 30 -73.9692943291611 40.7769536102488 15E-AM-1013-01 15E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9692943291611 40.7769536102488)   19 4 19 13
51 51 -73.9801666435401 40.7686905339212 2B-PM-1013-01 02B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false running (with nut) false false false false false false false false   POINT (-73.9801666435401 40.7686905339212)   19 4 19 13
143 143 -73.9661361310677 40.7787872561177 18G-PM-1013-01 18G PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true burying false false false false false false false true   POINT (-73.9661361310677 40.7787872561177)   19 4 19 13
173 173 -73.958770180151 40.7934123941528 35D-PM-1013-04 35D PM 10132018 4 Juvenile Gray White Gray+White         false false false false false   false false false false false false false false   POINT (-73.958770180151 40.7934123941528)   19 4 19 13
586 586 -73.9789126088606 40.7685079149692 2C-PM-1013-08 02C PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false true false false   POINT (-73.9789126088606 40.7685079149692)   19 4 19 13
839 839 -73.9615602805554 40.7945662185621 35A-PM-1013-08 35A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9615602805554 40.7945662185621)   19 4 19 13
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false true true false true   POINT (-73.9600964585868 40.7952339524416)   19 4 19 13
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
902 902 -73.969105907 40.7820474909192 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   true false false false false being chased by dog false false false false false false false true   POINT (-73.969105907 40.7820474909192)   19 4 19 13
927 927 -73.9609885686834 40.7961108640319 37A-PM-1013-01 37A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.96098856868342 40.7961108640319)   19 4 19 13
986 986 -73.978400938697 40.7677411911854 2C-PM-1013-03 02C PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.978400938697 40.7677411911854)   19 4 19 13
1027 1027 -73.9640016324897 40.7921759097124 32A-PM-1013-01 32A PM 10132018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9640016324897 40.7921759097124)   19 4 19 13
1083 1083 -73.9788117755401 40.7707347137469 5B-PM-1013-04 05B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.97881177554011 40.7707347137469)   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
1146 1146 -73.9794367096274 40.7672720598482 1C-PM-1013-04 01C PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9794367096274 40.7672720598482)   19 4 19 13
1157 1157 -73.9704449096084 40.7689970778303 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing with #6 false false false false true false false false   POINT (-73.9704449096084 40.7689970778303)   19 4 19 13
1187 1187 -73.9793334416378 40.7674142089209 1C-PM-1013-02 01C PM 10132018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true digging false false false false false false false false   POINT (-73.9793334416378 40.7674142089209)   19 4 19 13
1202 1202 -73.9694979297007 40.7694667408721 7I-PM-1013-02 07I PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE Construction materials true false false false false   false false false false true false false false   POINT (-73.9694979297007 40.7694667408721)   19 4 19 13
1252 1252 -73.9777998932399 40.7709815865334 5B-PM-1013-02 05B PM 10132018 2 Adult Gray White Gray+White   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9777998932399 40.7709815865334)   19 4 19 13
1264 1264 -73.9785353775382 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9785353775382 40.7674923683184)   19 4 19 13
1485 1485 -73.9791085350047 40.7677025342633 2C-PM-1013-12 02C PM 10132018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9791085350047 40.7677025342633)   19 4 19 13
1587 1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false climbing fence! false false false false false false false false snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)   19 4 19 13
1648 1648 -73.9790263372004 40.7683513714892 2C-PM-1013-07 02C PM 10132018 7 Adult Gray White Gray+White         true false false false true   false false false false false false false false   POINT (-73.9790263372004 40.7683513714892)   19 4 19 13
1699 1699 -73.9706968708903 40.7821499135828 19A-PM-1013-06 19A PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9706968708903 40.7821499135828)   19 4 19 13
1707 1707 -73.9604524271167 40.7956624328733 36B-AM-1013-01 36B AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9604524271167 40.7956624328733)   19 4 19 13
1728 1728 -73.9787846880249 40.7682545903488 2C-PM-1013-05 02C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9787846880249 40.7682545903488)   19 4 19 13
1852 1852 -73.9792161469158 40.7679285436253 2C-PM-1013-10 02C PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9792161469158 40.7679285436253)   19 4 19 13
1915 1915 -73.9797112925048 40.7688046778472 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   true false false false false   false false false false false false false false   POINT (-73.9797112925048 40.7688046778472)   19 4 19 13
2014 2014 -73.9786474809514 40.7679715341109 2C-PM-1013-04 02C PM 10132018 4 Adult Gray White Gray+White         false false false false true   false false false false false false false false   POINT (-73.9786474809514 40.7679715341109)   19 4 19 13
2042 2042 -73.9800896621713 40.7684379810317 2B-PM-1013-03 02B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9800896621713 40.7684379810317)   19 4 19 13
2072 2072 -73.9618709589382 40.7944969066792 35A-PM-1013-02 35A PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9618709589382 40.7944969066792)   19 4 19 13
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       false false false true true watching false false false false false false false true   POINT (-73.9593909381748 40.7961036981921)   19 4 19 13
2138 2138 -73.9791536183194 40.7672705931866 1C-PM-1013-03 01C PM 10132018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9791536183194 40.7672705931866)   19 4 19 13
2212 2212 -73.9801138983722 40.7685721515635 2B-PM-1013-02 02B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9801138983722 40.7685721515635)   19 4 19 13
2249 2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9785709201168 40.7674391934208)   19 4 19 13
2278 2278 -73.964539031099 40.7809916310012 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.964539031099 40.7809916310012)   19 4 19 13
2349 2349 -73.980033740004 40.7683608292333 2B-PM-1013-04 02B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.980033740004 40.7683608292333)   19 4 19 13
2358 2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true cleaning face & tail false false false false true true false false   POINT (-73.9788379085607 40.7683896583055)   19 4 19 13
2438 2438 -73.969532160039 40.7822616641357 20B-PM-1013-01 20B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969532160039 40.7822616641357)   19 4 19 13
2458 2458 -73.969517504176 40.7820741344297 20B-PM-1013-02 20B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969517504176 40.7820741344297)   19 4 19 13
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9657958433575 40.7763496875058)   19 4 19 13
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9589475065438 40.7934846881536)   19 4 19 13
2532 2532 -73.9695150319891 40.782613519363 20B-PM-1013-04 20B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true chased a bird carrying massive wad of grass false false false false true false false false   POINT (-73.9695150319891 40.782613519363)   19 4 19 13
2571 2571 -73.9695468150218 40.7821142051746 20B-PM-1013-03 20B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9695468150218 40.7821142051746)   19 4 19 13
2669 2669 -73.9615900833886 40.7945431292846 35A-PM-1013-07 35A PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9615900833886 40.7945431292846)   19 4 19 13
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9618094076328 40.7944097368153)   19 4 19 13
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   19 4 19 13
2815 2815 -73.9747311312394 40.7677319725044 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   false false true false false   false true false false false false false true   POINT (-73.97473113123941 40.7677319725044)   19 4 19 13
2819 2819 -73.9550350096938 40.797694218705 41E-PM-1013-02 41E PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9550350096938 40.797694218705004)   19 4 19 13
2926 2926 -73.9714653576023 40.7717400139502 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714653576023 40.7717400139502)   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
2997 2997 -73.9619735385483 40.7944667974974 35A-PM-1013-01 35A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9619735385483 40.7944667974974)   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 60.5ms