This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 80 | -73.9688454483585 | 40.78453012881629 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9688454483585 40.7845301288163) | |||
112 | 112 | -73.96517544644391 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651754464439 40.7755181941559) | |||
151 | 151 | -73.9714789136757 | 40.7694886645194 | 6H-AM-1008-01 | 06H | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714789136757 40.7694886645194) | ||||
210 | 210 | -73.97112984911321 | 40.76769026035429 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9711298491132 40.7676902603543) | |||
265 | 265 | -73.9691094942294 | 40.776760392858 | 14E-AM-1008-01 | 14E | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9691094942294 40.776760392858) | ||||
276 | 276 | -73.9758579666874 | 40.767932654884504 | 3E-PM-1008-05 | 03E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | jump | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9758579666874 40.7679326548845) | ||||
382 | 382 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | ||
511 | 511 | -73.9653142636891 | 40.776001512929795 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653142636891 40.7760015129298) | |||||
524 | 524 | -73.970173142921 | 40.77623499240811 | 14E-AM-1008-19 | 14E | AM | 10082018 | 19 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970173142921 40.7762349924081) | |||||
587 | 587 | -73.9771843912229 | 40.772366638212496 | 7B-AM-1008-01 | 07B | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771843912229 40.77236663821251) | |||||
615 | 615 | -73.96532790698879 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653279069888 40.7758743113817) | ||
792 | 792 | -73.97301156879641 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730115687964 40.7741018274312) | ||||
812 | 812 | -73.9699675160516 | 40.7773012642758 | 15E-PM-1008-07 | 15E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9699675160516 40.7773012642758) | |||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9758959798289 40.7694125671679) | ||||
925 | 925 | -73.9763116425885 | 40.768883957648704 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | |||
939 | 939 | -73.97614477914841 | 40.7690147873986 | 4D-PM-1008-02 | 04D | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761447791484 40.7690147873986) | ||||
1257 | 1257 | -73.97672475936541 | 40.772620005419704 | 7B-AM-1008-15 | 07B | AM | 10082018 | 15 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9767247593654 40.7726200054197) | ||||
1290 | 1290 | -73.96681408040659 | 40.77681001473329 | 15G-AM-1008-06 | 15G | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9668140804066 40.7768100147333) | ||||
1430 | 1430 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970804709441 40.7758611111219) | ||||
1439 | 1439 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | ||||
1545 | 1545 | -73.9669207809051 | 40.779276785012605 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9669207809051 40.7792767850126) | ||||
1664 | 1664 | -73.97291429122029 | 40.772409114667795 | 9E-AM-1008-03 | 09E | AM | 10082018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729142912203 40.7724091146678) | ||||
1687 | 1687 | -73.97547909645608 | 40.768336388516005 | 4E-PM-1008-07 | 04E | PM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754790964561 40.768336388516) | ||||
1863 | 1863 | -73.96828305109541 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682830510954 40.7810151087286) | ||
1990 | 1990 | -73.9774584305147 | 40.770813398619204 | 5B-AM-1008-02 | 05B | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9774584305147 40.7708133986192) | ||||
2005 | 2005 | -73.9755259087781 | 40.770725612418104 | 6D-AM-1008-01 | 06D | AM | 10082018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755259087781 40.7707256124181) | ||||
2151 | 2151 | -73.96971787697879 | 40.77915441024221 | 17D-AM-1008-03 | 17D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.96971787697882 40.7791544102422) | ||||
2190 | 2190 | -73.9657040391563 | 40.7755567428199 | 15I-AM-1008-06 | 15I | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657040391563 40.7755567428199) | ||||
2355 | 2355 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 10082018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | ||||
2456 | 2456 | -73.9698446365683 | 40.784260716857794 | 22A-AM-1008-01 | 22A | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | on fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9698446365683 40.7842607168578) | |||
2499 | 2499 | -73.96900799240942 | 40.7845473505585 | 22A-AM-1008-06 | 22A | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690079924094 40.7845473505585) | |||||
2526 | 2526 | -73.96464954504991 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646495450499 40.7791203699027) | ||||
2706 | 2706 | -73.9745141185576 | 40.76914797812071 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745141185576 40.7691479781207) | |||
2725 | 2725 | -73.9658867660358 | 40.7756523577509 | 15H-PM-1008-06 | 15H | PM | 10082018 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | base of gingko tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9658867660358 40.7756523577509) | |||
2801 | 2801 | -73.9697665830132 | 40.7759094917104 | 13E-PM-1008-08 | 13E | PM | 10082018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697665830132 40.7759094917104) | ||||
2862 | 2862 | -73.967466716152 | 40.782434654827796 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | i scared it | POINT (-73.967466716152 40.7824346548278) | |||
2925 | 2925 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) | ||||
2996 | 2996 | -73.970033345821 | 40.777259393859 | 15E-PM-1008-08 | 15E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970033345821 40.777259393859) |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" ( "longitude" REAL, "latitude" REAL, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare Squirrel Number" INTEGER, "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" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other Activities" TEXT, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail flags" INTEGER, "Tail twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs from" INTEGER, "Other Interactions" TEXT, "Lat/Long" TEXT );