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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2656 | 2656 | -73.97239959684201 | 40.7788765078432 | 15B-PM-1017-04 | 15B | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | on hill | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.972399596842 40.7788765078432) | ||||
2682 | 2682 | -73.97110012783891 | 40.778746609584104 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9711001278389 40.7787466095841) | ||||
2694 | 2694 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | |||
2721 | 2721 | -73.95519234082391 | 40.796830266140205 | 40E-PM-1017-01 | 40E | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9551923408239 40.7968302661402) | ||||
2728 | 2728 | -73.9507140045973 | 40.7957700986293 | 41I-PM-1017-01 | 41I | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon oval on back | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9507140045973 40.7957700986293) | |||
2746 | 2746 | -73.95614328368629 | 40.798266534723396 | 41C-AM-1017-07 | 41C | AM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9561432836863 40.7982665347234) | ||||
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971314838366 40.774951285041) | ||||
2843 | 2843 | -73.97147871782009 | 40.779804947074496 | 16B-PM-1017-01 | 16B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714787178201 40.7798049470745) | ||||
2890 | 2890 | -73.9726236083428 | 40.7788217771475 | 15B-PM-1017-03 | 15B | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by water | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726236083428 40.778821777147506) | |||
2932 | 2932 | -73.9705837974358 | 40.775849484967296 | 13E-AM-1017-13 | 13E | AM | 10172018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.97058379743581 40.7758494849673) | |||
2964 | 2964 | -73.9703604542938 | 40.776269022329394 | 13E-AM-1017-04 | 13E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9703604542938 40.7762690223294) | |||||
2983 | 2983 | -73.9689586689061 | 40.7839613907139 | 21B-PM-1017-04 | 21B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9689586689061 40.7839613907139) | ||||
2989 | 2989 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 10172018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9643538221947 40.7917565604735) | |||
2993 | 2993 | -73.95707222626929 | 40.798570614351895 | 40C-AM-1017-04 | 40C | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing (#3) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570722262693 40.7985706143519) | |||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | ||
853 | 853 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (#8),scratching | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9534509627885 40.7921084224711) | |||
1366 | 1366 | -73.97115821991021 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9711582199102 40.7783674409485) | ||||
1502 | 1502 | -73.97052548010001 | 40.7763606494306 | 13E-AM-1017-03 | 13E | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | acknowledges | POINT (-73.9705254801 40.7763606494306) |
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 );