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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1620 | 1620 | -73.96356061997841 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9635606199784 40.782206970617) | ||||
1007 | 1007 | -73.96353178229771 | 40.7821352080233 | 22G-AM-1018-01 | 22G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9635317822977 40.7821352080233) | ||||
1111 | 1111 | -73.96327993398721 | 40.7808316436308 | 21H-PM-1018-01 | 21H | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9632799339872 40.7808316436308) | |||
527 | 527 | -73.9632646049622 | 40.781740129208295 | 22G-AM-1018-05 | 22G | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9632646049622 40.7817401292083) | ||||
1518 | 1518 | -73.9632265832593 | 40.7816914475461 | 22G-AM-1018-04 | 22G | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632265832593 40.78169144754611) | ||||
2972 | 2972 | -73.9631468456897 | 40.7926110399714 | 32A-AM-1018-03 | 32A | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631468456897 40.7926110399714) | |||||
1970 | 1970 | -73.96314646937691 | 40.793415656751 | 33A-PM-1018-02 | 33A | PM | 10182018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Tree cavity [of] London Plane tree | 0 | 0 | 0 | 0 | 0 | hanging out,watching world | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching | POINT (-73.9631464693769 40.793415656751) | |
2966 | 2966 | -73.9630596103391 | 40.792572062055605 | 32A-AM-1018-04 | 32A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Base of tree | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630596103391 40.7925720620556) | ||||
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630381400083 40.7807571827321) | ||||
1463 | 1463 | -73.96300972763659 | 40.7936658446251 | 33A-PM-1018-04 | 33A | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9630097276366 40.79366584462511) | ||||
2048 | 2048 | -73.96276614653759 | 40.7819356810575 | 22G-PM-1018-02 | 22G | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9627661465376 40.7819356810575) | ||||
2960 | 2960 | -73.96252481451499 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962524814515 40.7810022923615) | |||||
1942 | 1942 | -73.96249054313 | 40.793538903878705 | 33A-PM-1018-01 | 33A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | stopped to see what i would do 1st | POINT (-73.96249054313 40.7935389038787) | ||||
1704 | 1704 | -73.9624052832372 | 40.7809656348254 | 21H-PM-1018-04 | 21H | PM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9624052832372 40.7809656348254) | ||||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9616999731028 40.7954126939561) | |||
488 | 488 | -73.9615751148595 | 40.795455123814605 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615751148595 40.7954551238146) | |||
2531 | 2531 | -73.9599424115626 | 40.79574725853271 | 37B-AM-1018-05 | 37B | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599424115626 40.7957472585327) | ||||
2884 | 2884 | -73.9598378495787 | 40.7956843021662 | 37B-AM-1018-04 | 37B | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9598378495787 40.7956843021662) | |||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9597048490102 40.7955846466241) | |||||
296 | 296 | -73.9596964641652 | 40.795775359158505 | 37B-AM-1018-03 | 37B | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596964641652 40.7957753591585) | |||||
1042 | 1042 | -73.9593374341938 | 40.797258337802 | 38B-PM-1018-01 | 38B | PM | 10182018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9593374341938 40.797258337802) | ||||
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | 0 | 0 | 0 | 0 | 0 | unknown | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9593126695714 40.797533370163) | |||||||
1632 | 1632 | -73.9592392692535 | 40.796186995179795 | 37B-AM-1018-02 | 37B | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9592392692535 40.7961869951798) | |||||
119 | 119 | -73.9592038887673 | 40.796382675378 | 38B-PM-1018-02 | 38B | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying nut | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9592038887673 40.796382675378) | |||
467 | 467 | -73.95797241199429 | 40.794870990001606 | 37D-AM-1018-01 | 37D | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579724119943 40.7948709900016) | ||||
1978 | 1978 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | ||||
2876 | 2876 | -73.95589957376541 | 40.7960097734603 | 39E-AM-1018-05 | 39E | AM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9558995737654 40.7960097734603) | ||||
1509 | 1509 | -73.9556450015702 | 40.796718805800204 | 39E-AM-1018-04 | 39E | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9556450015702 40.7967188058002) | |||||
2830 | 2830 | -73.9556083695689 | 40.7965223709493 | 39E-AM-1018-02 | 39E | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9556083695689 40.7965223709493) | |||||
2888 | 2888 | -73.955258162768 | 40.7958147673603 | 39E-AM-1018-01 | 39E | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.955258162768 40.7958147673603) | |||
2374 | 2374 | -73.9551370586201 | 40.7946465469021 | 38F-AM-1018-06 | 38F | AM | 10182018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hopped away | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95513705862011 40.7946465469021) | |||
631 | 631 | -73.95488778301359 | 40.795015748910295 | 38F-AM-1018-04 | 38F | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95488778301362 40.7950157489103) | ||||
258 | 258 | -73.9534333425633 | 40.793256416332795 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9534333425633 40.7932564163328) | |||
1304 | 1304 | -73.9533319519277 | 40.7933647909449 | 37H-AM-1018-02 | 37H | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | Large tree by (fence of the conservatory) about to climb up | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | busy,ready to climb | POINT (-73.9533319519277 40.7933647909449) | ||||
945 | 945 | -73.9532838338416 | 40.79311126745829 | 37H-AM-1018-01 | 37H | AM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Right behind fence of the conservatory | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532838338416 40.7931112674583) | ||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | 0 | 0 | 0 | 0 | 0 | sitting & watching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532657715601 40.7949046809422) | |||
148 | 148 | -73.9532620128307 | 40.795247554804796 | 39G-AM-1018-01 | 39G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | dead (something ran over it) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532620128307 40.7952475548048) | |||
913 | 913 | -73.9514111329059 | 40.797508587289705 | 42G-AM-1018-01 | 42G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9514111329059 40.797508587289705) |
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 );