This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
921 | 921 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
924 | 924 | -73.9591695545875 | 40.7938116360767 | 35D-PM-1013-08 | 35D | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9591695545875 40.7938116360767) | 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 | |||||
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 | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
965 | 965 | -73.9708301070924 | 40.7820200927465 | 19A-PM-1013-01 | 19A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | planting acorns | false | false | false | false | false | false | true | false | POINT (-73.9708301070924 40.7820200927465) | 19 | 4 | 19 | 13 | ||||
966 | 966 | -73.958317581802 | 40.7916566683158 | 33E-AM-1014-12 | 33E | AM | 10142018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | sleeping | false | false | false | false | false | false | false | false | asleep | POINT (-73.958317581802 40.7916566683158) | 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 | |||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 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 | |||||
1028 | 1028 | -73.9707012345661 | 40.7758938984066 | 13E-PM-1008-03 | 13E | PM | 10082018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | hanging upside down to get a nut | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9707012345661 40.7758938984066) | 19 | 4 | 19 | 13 | ||||
1047 | 1047 | -73.9580111056675 | 40.7854339401483 | 27I-PM-1020-02 | 27I | PM | 10202018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580111056675 40.7854339401483) | 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 | |||||
1085 | 1085 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 10182018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
1092 | 1092 | -73.9711319254625 | 40.7760324859879 | 13D-PM-1018-12 | 13D | PM | 10182018 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9711319254625 40.776032485987905) | 19 | 4 | 19 | 13 | |||||
1093 | 1093 | -73.9584106786233 | 40.7902777556926 | 32F-PM-1008-02 | 32F | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584106786233 40.7902777556926) | 19 | 4 | 19 | 13 | |||||
1116 | 1116 | -73.9729847109778 | 40.7740709049602 | 10D-AM-1008-03 | 10D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9729847109778 40.7740709049602) | 19 | 4 | 19 | 13 | |||||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728700359494 40.7659842666881) | 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 | |||||
1133 | 1133 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 10182018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.9712550584322 40.7764273475386) | 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 | |||||
1141 | 1141 | -73.9664669369583 | 40.7774085361976 | 16G-AM-1010-05 | 16G | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9664669369583 40.7774085361976) | 19 | 4 | 19 | 13 | |||||
1151 | 1151 | -73.9557602499712 | 40.7956452424385 | 38E-PM-1014-01 | 38E | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9557602499712 40.7956452424385) | 19 | 4 | 19 | 13 | |||||
1154 | 1154 | -73.9786936992465 | 40.7713943674666 | 5A-PM-1010-02 | 05A | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9786936992465 40.7713943674666) | 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 | ||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 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 | ||||
1184 | 1184 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9807982742225 40.7678795985389) | 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 | ||||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9616999731028 40.7954126939561) | 19 | 4 | 19 | 13 | ||||
1204 | 1204 | -73.9762965341309 | 40.775112516678 | 10A-AM-1006-02 | 10A | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Bridle Path lawn | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9762965341309 40.775112516678) | 19 | 4 | 19 | 13 | ||||
1213 | 1213 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
1224 | 1224 | -73.9572530843479 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572530843479 40.7987460430546) | 19 | 4 | 19 | 13 | |||||
1225 | 1225 | -73.9584803513939 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9584803513939 40.7933802077327) | 19 | 4 | 19 | 13 | |||||
1241 | 1241 | -73.9651817987035 | 40.7819082838334 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | false | false | false | true | true | false | false | false | false | true | false | false | false | walks from | POINT (-73.9651817987035 40.7819082838334) | 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 | |||||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.976864402584 40.7705663751959) | 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 | |||||
1292 | 1292 | -73.959019987128 | 40.7912546691805 | 33E-PM-1012-05 | 33E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | false | false | false | false | POINT (-73.959019987128 40.7912546691805) | 19 | 4 | 19 | 13 | ||||
1302 | 1302 | -73.9704024529864 | 40.7729256063889 | 10G-AM-1006-04 | 10G | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | chasing (#3) | true | false | false | false | false | false | false | false | POINT (-73.9704024529864 40.7729256063889) | 19 | 4 | 19 | 13 | ||||
1308 | 1308 | -73.9560396440844 | 40.7945080361909 | 37E-AM-1013-01 | 37E | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9560396440844 40.7945080361909) | 19 | 4 | 19 | 13 | |||||
1310 | 1310 | -73.9546201403481 | 40.7989423768656 | 42D-AM-1014-03 | 42D | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9546201403481 40.7989423768656) | 19 | 4 | 19 | 13 | |||||
1318 | 1318 | -73.9714907235676 | 40.774058386152 | 11E-PM-1012-01 | 11E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714907235676 40.774058386152) | 19 | 4 | 19 | 13 | |||||
1340 | 1340 | -73.9773083616259 | 40.7710535931636 | 6B-PM-1017-01 | 06B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | true | false | false | POINT (-73.9773083616259 40.7710535931636) | 19 | 4 | 19 | 13 | ||||
1342 | 1342 | -73.9662063642345 | 40.7890778665307 | 28A-PM-1007-04 | 28A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | false | looking at me & #5 | true | false | false | false | true | false | false | false | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
1349 | 1349 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 10122018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
1358 | 1358 | -73.9693772461788 | 40.7706875892901 | 8I-AM-1006-03 | 08I | AM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
1374 | 1374 | -73.9653739273979 | 40.7889762096967 | 28B-PM-1010-02 | 28B | PM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653739273979 40.7889762096967) | 19 | 4 | 19 | 13 | |||||
1387 | 1387 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 10062018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.96971605724461 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
1397 | 1397 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | true | false | looking | POINT (-73.9655233748105 40.7792737287734) | 19 | 4 | 19 | 13 | ||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
1411 | 1411 | -73.9802840031759 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
1413 | 1413 | -73.9810032206428 | 40.7681625634979 | 1A-AM-1007-01 | 01A | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
1414 | 1414 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580513096783 40.79909641532) | 19 | 4 | 19 | 13 | |||||
1423 | 1423 | -73.9600204328201 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9600204328201 40.782877291358) | 19 | 4 | 19 | 13 | |||||
1430 | 1430 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.970804709441 40.7758611111219) | 19 | 4 | 19 | 13 | |||||
1435 | 1435 | -73.9582534432858 | 40.7917772296796 | 34F-PM-1012-01 | 34F | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582534432858 40.7917772296796) | 19 | 4 | 19 | 13 | |||||
1439 | 1439 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9729645190377 40.7723310150843) | 19 | 4 | 19 | 13 | |||||
1453 | 1453 | -73.9555856074105 | 40.7969457685677 | 40E-AM-1014-04 | 40E | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | on rocks/bushy rocks | true | false | false | false | false | hiding from bird | false | true | false | false | true | false | true | false | POINT (-73.9555856074105 40.79694576856771) | 19 | 4 | 19 | 13 | |||
1456 | 1456 | -73.9714242426496 | 40.7744535798123 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | foraging (foraged,ran to tree root,munched) | false | false | false | false | false | false | true | false | POINT (-73.9714242426496 40.7744535798123) | 19 | 4 | 19 | 13 | ||||
1460 | 1460 | -73.9714329979305 | 40.7741873388945 | 11E-PM-1012-04 | 11E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714329979305 40.7741873388945) | 19 | 4 | 19 | 13 | |||||
1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | false | false | false | true | false | staring at me | false | false | false | false | false | false | true | false | POINT (-73.96763709851662 40.7869888639434) | 19 | 4 | 19 | 13 | ||||
1482 | 1482 | -73.9588610195699 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9588610195699 40.7945269936639) | 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 | |||||
1494 | 1494 | -73.9525752408169 | 40.7954915417553 | 39H-AM-1007-03 | 39H | AM | 10072018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9525752408169 40.7954915417553) | 19 | 4 | 19 | 13 | |||||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9765064169087 40.7737211426714) | 19 | 4 | 19 | 13 | |||||
1500 | 1500 | -73.9769969548024 | 40.7710711265211 | 6C-AM-1007-01 | 06C | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | vid! | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | false | curious,but wary | POINT (-73.97699695480242 40.7710711265211) | 19 | 4 | 19 | 13 | |||
1510 | 1510 | -73.9655670884957 | 40.7763728890554 | 16H-PM-1014-03 | 16H | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | followed man across bridge | POINT (-73.9655670884957 40.7763728890554) | 19 | 4 | 19 | 13 | ||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1532 | 1532 | -73.9779263114572 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9779263114572 40.7682681855369) | 19 | 4 | 19 | 13 | |||||
1541 | 1541 | -73.9711617997772 | 40.7761212878075 | 13D-PM-1018-04 | 13D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9711617997772 40.7761212878075) | 19 | 4 | 19 | 13 | ||||
1545 | 1545 | -73.9669207809051 | 40.7792767850126 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9669207809051 40.7792767850126) | 19 | 4 | 19 | 13 | |||||
1547 | 1547 | -73.958939037549 | 40.7913193931203 | 33E-PM-1012-04 | 33E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | playing | false | false | false | false | false | false | false | false | POINT (-73.958939037549 40.7913193931203) | 19 | 4 | 19 | 13 | ||||
1549 | 1549 | -73.9777978497894 | 40.7668620784309 | 1D-AM-1006-01 | 01D | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | false | POINT (-73.9777978497894 40.7668620784309) | 19 | 4 | 19 | 13 | |||||
1559 | 1559 | -73.9631648674122 | 40.7926529617419 | 32A-PM-1013-08 | 32A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9631648674122 40.7926529617419) | 19 | 4 | 19 | 13 | |||||
1580 | 1580 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9775079672882 40.7691500357424) | 19 | 4 | 19 | 13 | |||||
1582 | 1582 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
1585 | 1585 | -73.9611312355348 | 40.7950130863913 | 36A-PM-1013-04 | 36A | PM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | ON ROCK NEAR POND | false | false | false | false | false | sitting | false | false | false | false | true | false | true | false | POINT (-73.9611312355348 40.7950130863913) | 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 | |||
1588 | 1588 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
1590 | 1590 | -73.9610388059192 | 40.79395293584 | 34B-PM-1007-01 | 34B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9610388059192 40.79395293584) | 19 | 4 | 19 | 13 | |||||
1604 | 1604 | -73.9734644470766 | 40.7782766486921 | 14A-PM-1014-05 | 14A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97346444707661 40.7782766486921) | 19 | 4 | 19 | 13 | |||||
1644 | 1644 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 10082018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9734654671008 40.7715988711659) | 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 | |||||||
1659 | 1659 | -73.9690498876944 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 10062018 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
1663 | 1663 | -73.9696720362627 | 40.7791851598197 | 17D-AM-1008-04 | 17D | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9696720362627 40.7791851598197) | 19 | 4 | 19 | 13 | |||||
1667 | 1667 | -73.9645989003589 | 40.7782157459155 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9645989003589 40.7782157459155) | 19 | 4 | 19 | 13 | |||||
1671 | 1671 | -73.9611399573659 | 40.781130706026 | 22I-AM-1007-01 | 22I | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9611399573659 40.781130706026005) | 19 | 4 | 19 | 13 | |||||
1672 | 1672 | -73.9640989602986 | 40.7899295439265 | 29B-PM-1010-03 | 29B | PM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9640989602986 40.7899295439265) | 19 | 4 | 19 | 13 | |||||
1685 | 1685 | -73.9678822983274 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
1689 | 1689 | -73.9547031549299 | 40.7978867539322 | 41E-PM-1013-01 | 41E | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9547031549299 40.7978867539322) | 19 | 4 | 19 | 13 | |||||
1709 | 1709 | -73.9771696835698 | 40.7697011100487 | 4C-AM-1006-04 | 04C | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
1717 | 1717 | -73.9714952092767 | 40.7748063281815 | 12E-AM-1017-02 | 12E | AM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714952092767 40.7748063281815) | 19 | 4 | 19 | 13 | |||||
1727 | 1727 | -73.9692472299565 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692472299565 40.7722592187215) | 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 | |||||
1730 | 1730 | -73.9796142848349 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9796142848349 40.7702117898305) | 19 | 4 | 19 | 13 | |||||
1745 | 1745 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 10062018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20 | tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9688438058715 40.7703014325728) | 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 );