This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | false | false | false | true | false | still | false | false | false | false | false | false | true | false | POINT (-73.9589249555235 40.7908193284981) | 19 | 4 | 19 | 13 | ||||
174 | 174 | -73.9707274055755 | 40.7723889080377 | 10G-PM-1017-10 | 10G | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | playing (with #9) | false | false | false | false | false | false | true | false | POINT (-73.9707274055755 40.7723889080377) | 19 | 4 | 19 | 13 | |||||
288 | 288 | -73.9731113265165 | 40.7786640676355 | 15A-PM-1017-01 | 15A | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | true | false | eating in tree | false | false | false | false | false | false | true | false | POINT (-73.9731113265165 40.7786640676355) | 19 | 4 | 19 | 13 | ||||
321 | 321 | -73.9694288806212 | 40.7842952265291 | 22A-PM-1017-01 | 22A | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694288806212 40.7842952265291) | 19 | 4 | 19 | 13 | ||||||
368 | 368 | -73.970315671921 | 40.7720905395472 | 10G-PM-1017-02 | 10G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970315671921 40.7720905395472) | 19 | 4 | 19 | 13 | |||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 19 | 4 | 19 | 13 | |||||
438 | 438 | -73.9525747516914 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.95257475169142 40.7977257435263) | 19 | 4 | 19 | 13 | ||||
457 | 457 | -73.965848283831 | 40.7797243033057 | 19F-PM-1017-01 | 19F | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.965848283831 40.7797243033057) | 19 | 4 | 19 | 13 | |||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
533 | 533 | -73.9652584749758 | 40.7803011124382 | 19F-PM-1017-04 | 19F | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9652584749758 40.7803011124382) | 19 | 4 | 19 | 13 | |||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9713487591577 40.7784353043714) | 19 | 4 | 19 | 13 | |||||
679 | 679 | -73.955018489069 | 40.7971235333699 | 40E-PM-1017-02 | 40E | PM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.955018489069 40.7971235333699) | 19 | 4 | 19 | 13 | |||||
805 | 805 | -73.9706851546184 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
808 | 808 | -73.9716881838671 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9716881838671 40.778553537087) | 19 | 4 | 19 | 13 | |||||
834 | 834 | -73.9703914126866 | 40.7722457975176 | 10G-PM-1017-01 | 10G | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | standing | false | false | false | false | false | false | true | false | POINT (-73.9703914126866 40.7722457975176) | 19 | 4 | 19 | 13 | |||||
844 | 844 | -73.9642379942652 | 40.7774792520738 | 17I-PM-1017-01 | 17I | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | was in a tree,so i couldn't really tell | POINT (-73.9642379942652 40.7774792520738) | 19 | 4 | 19 | 13 | ||||
940 | 940 | -73.9700879096644 | 40.7765899724756 | 14E-PM-1017-05 | 14E | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9700879096644 40.7765899724756) | 19 | 4 | 19 | 13 | |||||
1139 | 1139 | -73.9716271494641 | 40.7796462634184 | 16B-PM-1017-02 | 16B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9716271494641 40.7796462634184) | 19 | 4 | 19 | 13 | |||||
1173 | 1173 | -73.959070754026 | 40.7906675143413 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.959070754026 40.7906675143413) | 19 | 4 | 19 | 13 | |||||
1182 | 1182 | -73.9667206046912 | 40.7779993565098 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
1191 | 1191 | -73.9634835346077 | 40.7918244310746 | 31A-PM-1017-03 | 31A | PM | 10172018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9634835346077 40.7918244310746) | 19 | 4 | 19 | 13 | |||||
1210 | 1210 | -73.9707937464541 | 40.7725282708448 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | false | false | false | false | false | traveling | false | false | false | false | false | false | true | false | POINT (-73.9707937464541 40.7725282708448) | 19 | 4 | 19 | 13 | ||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
1479 | 1479 | -73.9707498430394 | 40.7723724480959 | 10G-PM-1017-09 | 10G | PM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9707498430394 40.7723724480959) | 19 | 4 | 19 | 13 | ||||||
1561 | 1561 | -73.9642397829547 | 40.7918992406575 | 31A-PM-1017-02 | 31A | PM | 10172018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.96423978295472 40.7918992406575) | 19 | 4 | 19 | 13 | |||||
1731 | 1731 | -73.9692846326638 | 40.7841049008492 | 22A-PM-1017-02 | 22A | PM | 10172018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692846326638 40.7841049008492) | 19 | 4 | 19 | 13 | ||||||
1754 | 1754 | -73.9652134469963 | 40.7803438278765 | 19F-PM-1017-05 | 19F | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9652134469963 40.7803438278765) | 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 | |||||
1846 | 1846 | -73.9653311136561 | 40.780193490343 | 19F-PM-1017-07 | 19F | PM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9653311136561 40.78019349034301) | 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 | ||||
2071 | 2071 | -73.9667694439895 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667694439895 40.7779501809095) | 19 | 4 | 19 | 13 | ||||
2083 | 2083 | -73.9702382274798 | 40.7721754848905 | 10G-PM-1017-03 | 10G | PM | 10172018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9702382274798 40.7721754848905) | 19 | 4 | 19 | 13 | ||||||
2137 | 2137 | -73.9648831611629 | 40.7801326414973 | 19G-PM-1017-02 | 19G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | patting ground | false | false | false | false | true | false | false | true | POINT (-73.9648831611629 40.7801326414973) | 19 | 4 | 19 | 13 | ||||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | digging/burying,drinking from lake | false | false | false | false | true | false | true | false | POINT (-73.9737247632185 40.7759469280872) | 19 | 4 | 19 | 13 | ||||
2442 | 2442 | -73.9699369796844 | 40.7720350191273 | 10G-PM-1017-04 | 10G | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699369796844 40.7720350191273) | 19 | 4 | 19 | 13 | ||||||
2460 | 2460 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.9526681107152 40.7977012009146) | 19 | 4 | 19 | 13 | ||||
2658 | 2658 | -73.9690212174 | 40.7834099404107 | 21B-PM-1017-05 | 21B | PM | 10172018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9690212174 40.7834099404107) | 19 | 4 | 19 | 13 | ||||||
2697 | 2697 | -73.9710674928906 | 40.7778757544025 | 15D-PM-1017-06 | 15D | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | walking | false | false | false | false | false | false | false | false | stopped and watched me before slowly moving on | POINT (-73.9710674928906 40.7778757544025) | 19 | 4 | 19 | 13 | |||
2764 | 2764 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | 19 | 4 | 19 | 13 | ||||
2774 | 2774 | -73.9705409446299 | 40.7764608087703 | 14E-PM-1017-03 | 14E | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9705409446299 40.7764608087703) | 19 | 4 | 19 | 13 | |||||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2867 | 2867 | -73.969370141813 | 40.7840721191988 | 22A-PM-1017-03 | 22A | PM | 10172018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.969370141813 40.7840721191988) | 19 | 4 | 19 | 13 | |||||
682 | 682 | -73.9651828383592 | 40.7802820943863 | 19F-PM-1017-06 | 19F | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | true | true | false | false | POINT (-73.9651828383592 40.7802820943863) | 19 | 4 | 19 | 13 | |||||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | false | false | watching | false | false | false | false | false | true | false | false | POINT (-73.9651541395415 40.7798283208748) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
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 );