2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Hectare Squirrel Number = 6, Indifferent = 0 and Location = "Above Ground" sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Runs from

Tail twitches ✖

  • 0 31
  • 1 1

Location ✖

  • Above Ground · 32 ✖

Indifferent ✖

Hectare Squirrel Number ✖

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
116 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)
260 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)
311 311 -73.95787795565741 40.7934116539732 35E-PM-1006-06 35E PM 10062018 6 Adult Gray   Gray+   Above Ground     0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9578779556574 40.7934116539732)
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9548430741605 40.798207350942)
686 686 -73.9695745672033 40.7791835122147 17D-AM-1008-06 17D AM 10082018 6       +   Above Ground   high in tree, couldn't see it, only heard it 0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9695745672033 40.7791835122147)
708 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)
726 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)
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9675472064204 40.7835947167436)
1032 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)
1099 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 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 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)
1194 1194 -73.96874625660729 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9687462566073 40.783898987005)
1273 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)
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9680522379372 40.772389813511)
1329 1329 -73.9772164524209 40.768839953875606 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree 1 0 1 0 0   0 0 0 0 0 0 0 0 did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)
1464 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 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)
1554 1554 -73.95974626120629 40.783280114530605 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree 0 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9597462612063 40.7832801145306)
1599 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)
1871 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 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 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)
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)
2502 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)
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)
2640 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)
2742 2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2815 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)
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9578840941242 40.7955586232429)
3011 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)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)

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 119.32ms