squirrels

44 rows where Hectare Squirrel Number = 1, Indifferent = "false" and Primary Fur Color = "Cinnamon" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Police Precincts

Foraging

Primary Fur Color

  • Cinnamon · 44

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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true begging false false false false false false false false   POINT (-73.9511118711108 40.7950813345902)   19 4 19 13
1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar false false false true false   false false false true true true false false   POINT (-73.9594357049738 40.7840678890949)   19 4 19 13
2757 -73.9671419119456 40.7758602486862 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9671419119456 40.7758602486862)   19 4 19 13
470 -73.9581243021722 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false true   false false false false false false false true avoiding a dog POINT (-73.95812430217221 40.794431473386)   19 4 19 13
534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   true false true false false   false false false false true false false true   POINT (-73.9650499507011 40.7908191782173)   19 4 19 13
789 -73.9675023138703 40.7872554700995 25A-PM-1007-01 25A PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 40 tree false false true false false   false false false false false false false false   POINT (-73.9675023138703 40.7872554700995)   19 4 19 13
1042 -73.9593374341938 40.797258337802 38B-PM-1018-01 38B PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9593374341938 40.797258337802)   19 4 19 13
1098 -73.9604954276129 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   false false false false true scanning (drawing included) false false false false false false false true   POINT (-73.9604954276129 40.7965682182001)   19 4 19 13
1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9693465383617 40.7744996336934)   19 4 19 13
1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1155 -73.964572179093 40.7811208719018 21F-PM-1018-01 21F PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.964572179093 40.7811208719018)   19 4 19 13
1215 -73.9728895595977 40.7699378332299 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9728895595977 40.7699378332299)   19 4 19 13
1276 -73.9798005188704 40.7691868791734 3A-PM-1017-01 03A PM 10172018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.97980051887042 40.7691868791734)   19 4 19 13
1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true true false   false false false false false false false true   POINT (-73.9587072763996 40.7850256219415)   19 4 19 13
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2244 -73.9509628195532 40.7977775674178 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false false false false   false false false false true false false true   POINT (-73.9509628195532 40.7977775674178) 12423 18 4 36 18
2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   19 4 19 13
2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench false false false true false   false false false false false true false false   POINT (-73.9700264128414 40.7692014637698)   19 4 19 13
2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   false false false false false wrestling with child false false false false false false false false   POINT (-73.956581233786 40.79021276908371)   19 4 19 13
2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9749251267433 40.7679111971294)   19 4 19 13
151 -73.9714789136757 40.7694886645194 6H-AM-1008-01 06H AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714789136757 40.7694886645194)   19 4 19 13
813 -73.9758959798289 40.7694125671679 4D-PM-1008-01 04D PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9758959798289 40.7694125671679)   19 4 19 13
982 -73.9676424599715 40.7777766106807 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence false false false false true   false false false false true true false false   POINT (-73.9676424599715 40.7777766106807)   19 4 19 13
1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9594676326588 40.7984457363388)   19 4 19 13
1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true false true   false false false false false true false false   POINT (-73.9790889008147 40.7676402781925)   19 4 19 13
2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.954499539822 40.7949716693686)   19 4 19 13
2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9643538221947 40.7917565604735)   19 4 19 13
3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   19 4 19 13
27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
844 -73.9642379942652 40.7774792520738 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false false was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)   19 4 19 13
931 -73.9785948413883 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.9785948413883 40.7718908026758)   19 4 19 13
1650 -73.9762494239719 40.7750175306716 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields false false false true false eating (a peanut) false false false false false true false false   POINT (-73.9762494239719 40.7750175306716)   19 4 19 13
2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   19 4 19 13
2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   19 4 19 13
2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false false false watching false false false false false true false false   POINT (-73.9651541395415 40.7798283208748)   19 4 19 13
2278 -73.964539031099 40.7809916310012 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.964539031099 40.7809916310012)   19 4 19 13
2387 -73.9808517324721 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false true false false false   POINT (-73.9808517324721 40.7683154647217)   19 4 19 13
2550 -73.9694805745522 40.7743556902843 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree false false false false false jumping false false false false false false false false   POINT (-73.9694805745522 40.7743556902843)   19 4 19 13
2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false false paused to look at me POINT (-73.9692660977515 40.7830532310766)   19 4 19 13
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   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 106.153ms