2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Hectare Squirrel Number = 3, Shift = "AM" and Tail twitches = 1 sorted by Color notes

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Approaches, Indifferent, Runs from

Tail twitches

Shift

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
12 -73.96836135162249 40.772590884749896 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9683613516225 40.7725908847499)
53 -73.95849706432129 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9584970643213 40.7982886348696)
232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 1 approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)
335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963858549251 40.7808999610914)
1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9645060433292 40.7768322057794)
1159 -73.9682129261841 40.77542323581179 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9682129261841 40.7754232358118)
1160 -73.97772569893621 40.766623699564 1E-AM-1006-03 01E AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9777256989362 40.766623699564)
1310 -73.9546201403481 40.798942376865604 42D-AM-1014-03 42D AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9546201403481 40.7989423768656)
1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log 0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9690645326017 40.7773822116124)
1819 -73.9711378905748 40.7696218346333 7H-AM-1006-03 07H AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE on rock (large) 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9711378905748 40.769621834633305)
1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         1 1 1 0 0 chasing (#4),digging 0 0 0 0 1 0 1 0   POINT (-73.957138794884 40.7985389822719)
2091 -73.96761128642859 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road 1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9676112864286 40.7772792086081)
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)
2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)
2241 -73.95752586279659 40.787715550749 30H-AM-1007-03 30H AM 10072018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9575258627966 40.787715550749)
2539 -73.97810334484679 40.766672406621296 1D-AM-1006-03 01D AM 10062018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9781033448468 40.7666724066213)
2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2598 -73.976658503418 40.768686845691704 4D-AM-1012-03 04D AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.976658503418 40.7686868456917)
2736 -73.95938952535009 40.797308584408704 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593895253501 40.7973085844087)
2883 -73.9698592838836 40.7743071443959 12F-AM-1020-03 12F AM 10202018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 1 0 0 0   POINT (-73.9698592838836 40.7743071443959)
820 -73.9801902133148 40.769557595068 3A-AM-1012-03 03A AM 10122018 3 Juvenile Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Above Ground 1   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9801902133148 40.769557595068)

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