squirrels

33 rows where Above Ground Sighter Measurement = 30 and Climbing = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Other Interactions

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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
16 16 -73.9722500196844 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false grooming false false false false false false true false   POINT (-73.9722500196844 40.7742879599026)   19 4 19 13
39 39 -73.9716147061553 40.7813911036179 18A-PM-1018-01 18A PM 10182018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9716147061553 40.7813911036179)   19 4 19 13
166 166 -73.963846339804 40.7834051716226 23F-AM-1018-01 23F AM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.963846339804 40.7834051716226)   19 4 19 13
347 347 -73.9611696144784 40.7816692895155 22I-AM-1007-03 22I AM 10072018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9611696144784 40.7816692895155)   19 4 19 13
391 391 -73.9790875480358 40.7676104780657 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9790875480358 40.7676104780657)   19 4 19 13
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree false false true false true   false false false false false false false false   POINT (-73.9548430741605 40.798207350942)   19 4 19 13
508 508 -73.9746918762076 40.7655231883678 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   false false true false true   false false false false true false true false   POINT (-73.9746918762076 40.7655231883678)   19 4 19 13
567 567 -73.9756972647636 40.773624164826 9B-PM-1013-04 09B PM 10132018 4 Juvenile Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false true false true false   POINT (-73.9756972647636 40.773624164826)   19 4 19 13
634 634 -73.9596375907038 40.7907347708353 32E-AM-1007-05 32E AM 10072018 5 Adult Black   Black+   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9596375907038 40.79073477083531)   19 4 19 13
708 708 -73.9592819491968 40.7941062008626 35C-AM-1007-06 35C AM 10072018 6 Adult     +   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9592819491968 40.7941062008626)   19 4 19 13
767 767 -73.9655734633649 40.7805366922231 20F-AM-1014-02 20F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false pulling leaves true false false false false false false false   POINT (-73.9655734633649 40.7805366922231)   19 4 19 13
835 835 -73.9707900566519 40.7771670550089 14D-AM-1014-09 14D AM 10142018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9707900566519 40.7771670550089)   19 4 19 13
1022 1022 -73.9548853492712 40.7984783584388 41D-PM-1014-04 41D PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false jumping tree to tree false false false false false false false false   POINT (-73.9548853492712 40.7984783584388)   19 4 19 13
1041 1041 -73.9643236505425 40.7887854771596 28C-AM-1014-02 28C AM 10142018 2 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9643236505425 40.7887854771596)   19 4 19 13
1044 1044 -73.9693254080548 40.7761600327118 14F-AM-1007-01 14F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9693254080548 40.7761600327118)   19 4 19 13
1144 1144 -73.9743184653765 40.7667932997 3G-AM-1008-01 03G AM 10082018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9743184653765 40.7667932997)   19 4 19 13
1201 1201 -73.9782813538421 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true true false false   false false false true false false false false   POINT (-73.9782813538421 40.7715730368712)   19 4 19 13
1355 1355 -73.9655277320465 40.7806120529369 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9655277320465 40.7806120529369)   19 4 19 13
1845 1845 -73.9626560807032 40.7884633049896 28D-AM-1012-05 28D AM 10122018 5 Juvenile Black   Black+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9626560807032 40.7884633049896)   19 4 19 13
1890 1890 -73.9787723082807 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9787723082807 40.7713655754004)   19 4 19 13
1951 1951 -73.9548431601579 40.7906346271566 34I-PM-1010-02 34I PM 10102018 2 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9548431601579 40.7906346271566)   19 4 19 13
1972 1972 -73.9558370309765 40.7921977208472 35G-AM-1007-02 35G AM 10072018 2 Adult Gray White Gray+White   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9558370309765 40.7921977208472)   19 4 19 13
1994 1994 -73.9598463837775 40.7834524724254 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9598463837775 40.7834524724254)   19 4 19 13
2016 2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false   false false false false true false true false stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)   19 4 19 13
2103 2103 -73.9782983634755 40.7668314364263 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9782983634755 40.7668314364263)   19 4 19 13
2130 2130 -73.9695572903383 40.780822981713 18C-AM-1018-01 18C AM 10182018 1 Adult Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9695572903383 40.780822981713)   19 4 19 13
2228 2228 -73.9714045891597 40.7715418333976 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.97140458915972 40.7715418333976)   19 4 19 13
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   false false true true true   true false false false false false true false   POINT (-73.9789251806378 40.7699558513225)   19 4 19 13
2377 2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9704328573603 40.7739347247552)   19 4 19 13
2420 2420 -73.9587787592751 40.7981699014259 40A-AM-1010-01 40A AM 10102018 1 Juvenile Gray   Gray+   Above Ground 30 bottom of great hill false false true false false   false false false false false false false false climbing up a tree POINT (-73.9587787592751 40.7981699014259)   19 4 19 13
2552 2552 -73.9724947710698 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch false false true false false sitting false false false false false false true false   POINT (-73.9724947710698 40.7696619340886)   19 4 19 13
2851 2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   false false true false false different sound - happy,playful chirps false false false false true false true false   POINT (-73.955208233231 40.7890574331084)   19 4 19 13
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false true true false false   false true false false false false false false looked at us from tree POINT (-73.9677903197449 40.7826561917755)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 59.025ms