2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Hectare Squirrel Number = 6, Running = 0 and Runs from = 1 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Unique Squirrel ID, Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Kuks, Quaas, Tail twitches, Indifferent

Running ✖

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
61 61 -73.9797084866613 40.7698885241349 3A-PM-1017-06 03A PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9797084866613 40.7698885241349)
522 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)
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)
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 1 0 0 0 0 0 1   POINT (-73.9541837143178 40.7944340477396)
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)
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)
1290 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)
1520 1520 -73.968021326951 40.7778807692445 16F-PM-1013-06 16F PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Big rock in meadow 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.968021326951 40.7778807692445)
1540 1540 -73.957710975899 40.79840556140471 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.957710975899 40.7984055614047)
1674 1674 -73.9589698681439 40.7906520520417 32E-PM-1017-06 32E PM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589698681439 40.7906520520417)
1699 1699 -73.9706968708903 40.7821499135828 19A-PM-1013-06 19A PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9706968708903 40.7821499135828)
1803 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)
2079 2079 -73.96430251719141 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9643025171914 40.790570391517)
2168 2168 -73.95823634371351 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9582363437135 40.7987752300505)
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)
2239 2239 -73.9668922014699 40.7823535653774 21D-AM-1008-06 21D AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9668922014699 40.7823535653774)
2274 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 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)
2519 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)
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)
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)
2892 2892 -73.9688070760806 40.777968829417205 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688070760806 40.777968829417205)
988 988 -73.97870401924729 40.767901024728104 2C-AM-1010-06 02C AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 stood still & watched me then jumped on a fence and ran away 0 0 0 0 0 0 1 1   POINT (-73.9787040192473 40.7679010247281)
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)

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