2018_Central_Park_Squirrel_Census_-_Squirrel_Data

246 rows where Hectare Squirrel Number = 5 and Tail twitches = 0 sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

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
2506 2506 -73.9719038949487 40.770353349248204 7G-AM-1010-05 07G AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719038949487 40.7703533492482)
2531 2531 -73.9599424115626 40.79574725853271 37B-AM-1018-05 37B AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9599424115626 40.7957472585327)
2537 2537 -73.9735533713513 40.7690605609001 5F-PM-1007-05 05F PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9735533713513 40.7690605609001)
2552 2552 -73.97249477106979 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch 0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9724947710698 40.7696619340886)
2581 2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9635981227569 40.7928169540326)
2582 2582 -73.9665004148497 40.780565641175606 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665004148497 40.7805656411756)
2645 2645 -73.9584967368893 40.797732034109394 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. 0 0 0 0 0 0 1 0   POINT (-73.9584967368893 40.7977320341094)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
2651 2651 -73.9632993246327 40.78881995196561 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9632993246327 40.7888199519656)
2658 2658 -73.9690212174 40.783409940410706 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9690212174 40.7834099404107)
2659 2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   0 0 0 0 1 standing on back legs 0 0 0 0 0 1 1 0   POINT (-73.9601851468038 40.7968698151479)
2693 2693 -73.95614986460359 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks 0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9561498646036 40.79492885618931)
2701 2701 -73.97912175106559 40.767658347539395 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9791217510656 40.7676583475394)
2703 2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9690082314914 40.7738993942891)
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97518067271972 40.7671940332258)
2777 2777 -73.98108436110859 40.768790549369896 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9810843611086 40.7687905493699)
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711634340673 40.7760553338671)
2817 2817 -73.9596445861554 40.79719486790071 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9596445861554 40.7971948679007)
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   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.96159260312531 40.7944223235385)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)
2859 2859 -73.9786940945874 40.769082027688796 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9786940945874 40.7690820276888)
2873 2873 -73.955068474109 40.79117881528779 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.955068474109 40.7911788152878)
2876 2876 -73.95589957376541 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9558995737654 40.7960097734603)
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
2889 2889 -73.9771646835311 40.769304916508396 4C-PM-1010-05 04C PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9771646835311 40.7693049165084)
2891 2891 -73.9636482556874 40.7775831570186 18I-PM-1007-05 18I PM 10072018 5 Juvenile Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 0 1 jumping crazily / digging hole 0 0 0 0 0 0 1 0   POINT (-73.9636482556874 40.7775831570186)
2899 2899 -73.9686358129525 40.7778035516486 16E-AM-1014-05 16E AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686358129525 40.7778035516486)
2907 2907 -73.96852016269341 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685201626934 40.783329261225)
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9621297946132 40.7944058222814)
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9770313887741 40.772486925209904)
2923 2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9672160533827 40.7830263908749)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
2930 2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692563597762 40.770904999952)
2936 2936 -73.9809876538513 40.768322324214296 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9809876538513 40.7683223242143)
2940 2940 -73.963911430308 40.7809127228847 21G-AM-1014-05 21G AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.963911430308 40.7809127228847)
2944 2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)
2953 2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 eating (in a tree cage thing) 0 0 0 0 0 0 1 0   POINT (-73.9585862117341 40.7986549251083)
2962 2962 -73.9722530826293 40.7667138028361 3I-AM-1010-05 03I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9722530826293 40.7667138028361)
2970 2970 -73.9619019299709 40.7924476439693 33B-PM-1010-05 33B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619019299709 40.7924476439693)
2990 2990 -73.97660121083071 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   0 1 1 0 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.9766012108307 40.7712310725379)
2991 2991 -73.96846326736029 40.784890952519795 23A-AM-1018-05 23A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9684632673603 40.7848909525198)
3020 3020 -73.97040158596391 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704015859639 40.7825600069973)

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