2018_Central_Park_Squirrel_Census_-_Squirrel_Data

63 rows where Age = "Adult", Foraging = 0, Hectare Squirrel Number = 6 and Indifferent = 0

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches, 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
31 -73.9540054100539 40.795244599983604 39G-PM-1013-06 39G PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9540054100539 40.7952445999836)
41 -73.96391592984459 40.789177463798794 29C-AM-1007-06 29C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9639159298446 40.7891774637988)
58 -73.9704082821356 40.7690280985956 6I-PM-1013-06 06I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 playing with #5 0 0 0 0 1 0 0 0   POINT (-73.9704082821356 40.7690280985956)
63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9745630038492 40.7692602628745)
83 -73.9617088749928 40.7944585082367 35A-PM-1013-06 35A PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9617088749928 40.7944585082367)
116 -73.9572093760529 40.798848730021604 41B-AM-1010-06 41B AM 10102018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9572093760529 40.7988487300216)
130 -73.95816559494371 40.799770819002205 41A-PM-1007-06 41A PM 10072018 6 Adult Black   Black+   Ground Plane FALSE   1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9581655949437 40.7997708190022)
133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 0 0 1 0 0   0 0 0 1 0 0 0 0 studying us looking for food POINT (-73.9664711607022 40.787896428768)
171 -73.971086588091 40.77197032351779 9G-PM-1007-06 09G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.971086588091 40.7719703235178)
260 -73.97843611793199 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.978436117932 40.7724769242403)
477 -73.97014812002979 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701481200298 40.7751110354034)
494 -73.958837574505 40.7985003987784 40A-PM-1014-06 40A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958837574505 40.7985003987784)
501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9708798496132 40.7761532088521)
522 -73.97738211356109 40.769045349438294 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9773821135611 40.7690453494383)
682 -73.9651828383592 40.780282094386294 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9651828383592 40.7802820943863)
708 -73.9592819491968 40.7941062008626 35C-AM-1007-06 35C AM 10072018 6 Adult     +   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9592819491968 40.7941062008626)
712 -73.9736169886655 40.7714942196257 7E-AM-1006-06 07E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9736169886655 40.7714942196257)
713 -73.956200809768 40.798181446265 40C-AM-1017-06 40C AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956200809768 40.798181446265)
726 -73.973305698325 40.778382331129606 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.973305698325 40.7783823311296)
850 -73.9642288873015 40.782043998356706 22F-AM-1007-06 22F AM 10072018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9642288873015 40.7820439983567)
866 -73.9792091200122 40.7685845475313 2B-PM-1013-06 02B PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 sat there! in front of us POINT (-73.9792091200122 40.7685845475313)
907 -73.95806099213101 40.7907158878729 32F-AM-1012-06 32F AM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958060992131 40.7907158878729)
987 -73.96498278073409 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649827807341 40.7817322832767)
1032 -73.96328685617941 40.7907806312915 30B-AM-1007-06 30B AM 10072018 6 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632868561794 40.7907806312915)
1082 -73.96174906802979 40.792153784924395 32C-PM-1013-06 32C PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9617490680298 40.7921537849244)
1099 -73.9761527947483 40.770960700253895 6C-AM-1007-06 06C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared when jogger ran by POINT (-73.9761527947483 40.7709607002539)
1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638599044346 40.7809288795308)
1162 -73.95685442708809 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock 0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568544270881 40.7972517274475)
1219 -73.96618922004741 40.7836798072777 22D-PM-1012-06 22D PM 10122018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9661892200474 40.7836798072777)
1247 -73.96709048698709 40.7832091658006 21D-PM-1008-06 21D PM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9670904869871 40.7832091658006)
1260 -73.9811585807616 40.768706748732 2A-AM-1010-06 02A AM 10102018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 1 0 0 0 chasing #5 0 0 0 0 0 0 0 0   POINT (-73.9811585807616 40.768706748732)
1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
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)
1464 -73.95320745731391 40.793466946490796 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9532074573139 40.7934669464908)
1495 -73.97351371783691 40.769109895294 5F-AM-1007-06 05F AM 10072018 6 Adult Gray   Gray+   Above Ground 2 branch 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9735137178369 40.769109895294)
1562 -73.97408468107099 40.7728197139621 8D-AM-1007-06 08D AM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.974084681071 40.7728197139621)
1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782603348665 40.7705790257951)
1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9759428006237 40.7715081817329)
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 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9734654671008 40.7715988711659)
1679 -73.9545399102352 40.7898646267709 33I-PM-1006-06 33I PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9545399102352 40.7898646267709)
1792 -73.97057045274809 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9705704527481 40.7762853012151)
1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9588076804698 40.7912942607296)
1805 -73.9590328527128 40.791221441757706 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9590328527128 40.7912214417577)
1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748367344424 40.7693513000034)
2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96738215574692 40.7786375267659)
2206 -73.95944460183459 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   0 0 1 0 0   1 1 0 0 0 0 0 1 runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)
2274 -73.96980442184758 40.7697007833531 7I-PM-1013-06 07I PM 10132018 6 Adult Cinnamon   Cinnamon+ "Brown" written in as Primary Ground Plane FALSE Under the tree 0 0 0 1 0 playing,interacting with #7 0 0 0 0 1 0 0 1   POINT (-73.9698044218476 40.7697007833531)
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)
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)
2502 -73.9758375334287 40.7676793289765 3E-AM-1006-06 03E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 14   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9758375334287 40.7676793289765)
2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9589475065438 40.7934846881536)
2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
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)
2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9564228238736 40.7936908887644)
2637 -73.968891673893 40.776700147172896 15F-AM-1007-06 15F AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 pair with #5 0 0 0 0 0 0 0 1   POINT (-73.968891673893 40.7767001471729)
2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   1 0 0 0 0 running from squirrel #5 0 0 0 0 0 0 0 0   POINT (-73.9788304714091 40.7696373635315)
2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692849074642 40.7708755098145)
2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 0 0 stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)
2795 -73.9541056052047 40.793986392323106 37G-PM-1007-06 37G PM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9541056052047 40.7939863923231)
2814 -73.9551625272308 40.791193071916 34H-PM-1006-06 34H PM 10062018 6 Adult Gray   Gray+   Ground Plane FALSE in grass 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9551625272308 40.791193071916)
2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)
2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575791421589 40.7959934459432)
3011 -73.96788313129359 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   0 0 0 0 0   1 0 0 0 0 0 0 0 scolding POINT (-73.9678831312936 40.7847605974975)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Query took 182.094ms