squirrels

45 rows where Hectare Squirrel Number = 6, Indifferent = "false" and Shift = "AM" sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, 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, Tail twitches, Approaches, Other Interactions

Runs from ✖

Shift ✖

Indifferent ✖

  • false · 45 ✖

Hectare Squirrel Number ✖

Community Districts ✖

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
686 686 -73.9695745672033 40.7791835122147 17D-AM-1008-06 17D AM 10082018 6       +   Above Ground   high in tree, couldn't see it, only heard it false false false false false   true false false false false false false false   POINT (-73.9695745672033 40.7791835122147)   19 4 19 13
2577 2577 -73.9597048490102 40.7955846466241 37B-AM-1018-06 37B AM 10182018 6 Adult Gray   Gray+   Above Ground 1   false false true false false   false true false false false false false true   POINT (-73.9597048490102 40.7955846466241)   19 4 19 13
1329 1329 -73.9772164524209 40.7688399538756 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree true false true false false   false false false false false false false false did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)   19 4 19 13
2206 2206 -73.9594446018346 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   false false true false false   true true false false false false false true runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)   19 4 19 13
2640 2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   true false false false false running from squirrel #5 false false false false false false false false   POINT (-73.9788304714091 40.7696373635315)   19 4 19 13
2502 2502 -73.9758375334287 40.7676793289765 3E-AM-1006-06 03E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 14   false false false true false   false false false false false false false false   POINT (-73.9758375334287 40.7676793289765)   19 4 19 13
260 260 -73.978436117932 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree false false true false false   true false false false false false false false   POINT (-73.978436117932 40.7724769242403)   19 4 19 13
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true false true false true   true false false false true false false true   POINT (-73.9565824187667 40.797312050952)   19 4 19 13
1495 1495 -73.9735137178369 40.769109895294 5F-AM-1007-06 05F AM 10072018 6 Adult Gray   Gray+   Above Ground 2 branch false false false true false   false false false false false false false false   POINT (-73.9735137178369 40.769109895294)   19 4 19 13
1162 1162 -73.9568544270881 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock false false false false false   false false false false false false false true   POINT (-73.9568544270881 40.7972517274475)   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
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
2499 2499 -73.9690079924094 40.7845473505585 22A-AM-1008-06 22A AM 10082018 6 Adult Gray   Gray+   Above Ground 30   false false false true false   false false false false false false false false   POINT (-73.9690079924094 40.7845473505585)   19 4 19 13
1032 1032 -73.9632868561794 40.7907806312915 30B-AM-1007-06 30B AM 10072018 6 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9632868561794 40.7907806312915)   19 4 19 13
1128 1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638599044346 40.7809288795308)   19 4 19 13
2742 2742 -73.9628041577934 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   false false false true false   false false false false false false false true   POINT (-73.9628041577934 40.78841801560551)   19 4 19 13
116 116 -73.9572093760529 40.7988487300216 41B-AM-1010-06 41B AM 10102018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   false false true false false   false false false false false false false false   POINT (-73.9572093760529 40.7988487300216)   19 4 19 13
1099 1099 -73.9761527947483 40.7709607002539 6C-AM-1007-06 06C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   false false true false false   false false false false false false false false disappeared when jogger ran by POINT (-73.9761527947483 40.7709607002539)   19 4 19 13
41 41 -73.9639159298446 40.7891774637988 29C-AM-1007-06 29C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9639159298446 40.7891774637988)   19 4 19 13
63 63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9745630038492 40.7692602628745)   19 4 19 13
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
477 477 -73.9701481200298 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9701481200298 40.7751110354034)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
712 712 -73.9736169886655 40.7714942196257 7E-AM-1006-06 07E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9736169886655 40.7714942196257)   19 4 19 13
713 713 -73.956200809768 40.798181446265 40C-AM-1017-06 40C AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.956200809768 40.798181446265)   19 4 19 13
850 850 -73.9642288873015 40.7820439983567 22F-AM-1007-06 22F AM 10072018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9642288873015 40.7820439983567)   19 4 19 13
907 907 -73.958060992131 40.7907158878729 32F-AM-1012-06 32F AM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.958060992131 40.7907158878729)   19 4 19 13
943 943 -73.9773096718574 40.7738053862489 8A-AM-1013-06 08A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9773096718574 40.7738053862489)   19 4 19 13
987 987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
1172 1172 -73.9706929270645 40.7727841119424 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   false true false false false chasing (#5) true false false false false false false false   POINT (-73.9706929270645 40.7727841119424)   19 4 19 13
1260 1260 -73.9811585807616 40.768706748732 2A-AM-1010-06 02A AM 10102018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true true false false false chasing #5 false false false false false false false false   POINT (-73.9811585807616 40.768706748732)   19 4 19 13
1290 1290 -73.9668140804066 40.7768100147333 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9668140804066 40.7768100147333)   19 4 19 13
1540 1540 -73.957710975899 40.7984055614047 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.957710975899 40.7984055614047)   19 4 19 13
1555 1555 -73.9784942525972 40.7672600003683 1D-AM-1006-06 01D AM 10062018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false tumbling false false false false false false false false   POINT (-73.9784942525972 40.7672600003683)   19 4 19 13
1562 1562 -73.974084681071 40.7728197139621 8D-AM-1007-06 08D AM 10072018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.974084681071 40.7728197139621)   19 4 19 13
1792 1792 -73.9705704527481 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9705704527481 40.7762853012151)   19 4 19 13
1803 1803 -73.9588076804698 40.7912942607296 33E-AM-1014-06 33E AM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9588076804698 40.7912942607296)   19 4 19 13
2168 2168 -73.9582363437135 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9582363437135 40.7987752300505)   19 4 19 13
2239 2239 -73.9668922014699 40.7823535653774 21D-AM-1008-06 21D AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9668922014699 40.7823535653774)   19 4 19 13
2276 2276 -73.9611985783336 40.791604823372 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9611985783336 40.791604823372)   19 4 19 13
2281 2281 -73.9691520826028 40.7717104037783 10H-AM-1014-06 10H AM 10142018 6   Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9691520826028 40.7717104037783)   19 4 19 13
2374 2374 -73.9551370586201 40.7946465469021 38F-AM-1018-06 38F AM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false hopped away false false false false false false false true   POINT (-73.95513705862011 40.7946465469021)   19 4 19 13
2637 2637 -73.968891673893 40.7767001471729 15F-AM-1007-06 15F AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false pair with #5 false false false false false false false true   POINT (-73.968891673893 40.7767001471729)   19 4 19 13
2892 2892 -73.9688070760806 40.7779688294172 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9688070760806 40.777968829417205)   19 4 19 13
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9575791421589 40.7959934459432)   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 77.587ms