squirrels

60 rows where Hectare Squirrel Number = 6 and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foraging ✖

Location ✖

  • Above Ground · 60 ✖

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
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false true false true false   false false false false false false true false   POINT (-73.970252675331 40.77059995882221)   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
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
300 300 -73.9528149779809 40.7924984810637 36I-AM-1017-06 36I AM 10172018 6 Adult Gray Black Gray+Black Darker than others Above Ground 10 Running down tree true false true false false   false false false false false false true false   POINT (-73.9528149779809 40.7924984810637)   19 4 19 13
311 311 -73.9578779556574 40.7934116539732 35E-PM-1006-06 35E PM 10062018 6 Adult Gray   Gray+   Above Ground     false false false false true   false false false false false false false false   POINT (-73.9578779556574 40.7934116539732)   19 4 19 13
344 344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench false false false true true   false false false false false false true false   POINT (-73.9759432151552 40.7733240612552)   19 4 19 13
352 352 -73.970540988328 40.7698103067062 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false true false false false   false false false false false false true false   POINT (-73.970540988328 40.7698103067062)   19 4 19 13
378 378 -73.9584835416846 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9584835416846 40.7978213396921)   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
620 620 -73.9655905300923 40.7752614638023 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   true false true false false   false false false false true false true false   POINT (-73.9655905300923 40.7752614638023)   19 4 19 13
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
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
726 726 -73.973305698325 40.7783823311296 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   false false true false false   false false false false false false false true   POINT (-73.973305698325 40.7783823311296)   19 4 19 13
737 737 -73.9711176999471 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree false false true false false   false false false false false false true false   POINT (-73.9711176999471 40.7724278547281)   19 4 19 13
780 780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree false false false true false   false false false false false false false false   POINT (-73.9675472064204 40.7835947167436)   19 4 19 13
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552035011902 40.7889851896334)   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
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
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
1133 1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   false false true false false cleaning false false false false false false true false   POINT (-73.9712550584322 40.7764273475386)   19 4 19 13
1161 1161 -73.9694066600156 40.7805662180672 18C-PM-1018-06 18C PM 10182018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 1   false false true true true   false false false false false false true false   POINT (-73.9694066600156 40.7805662180672)   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
1194 1194 -73.9687462566073 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false digging false false false false false false false false   POINT (-73.9687462566073 40.783898987005)   19 4 19 13
1273 1273 -73.9558943880051 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false false false false false true   POINT (-73.9558943880051 40.7971535141896)   19 4 19 13
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9680522379372 40.772389813511)   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
1464 1464 -73.9532074573139 40.7934669464908 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree true false true false false   false false false false false false false false   POINT (-73.9532074573139 40.7934669464908)   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
1530 1530 -73.9689305978751 40.7818152496266 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence true false true false false climbing (fence) false false false false false false true false   POINT (-73.9689305978751 40.7818152496266)   19 4 19 13
1535 1535 -73.9703921271418 40.7700276115314 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #7 false false false false false false true false   POINT (-73.9703921271418 40.770027611531404)   19 4 19 13
1554 1554 -73.9597462612063 40.7832801145306 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree false false false false false   false true false false false false false false   POINT (-73.9597462612063 40.7832801145306)   19 4 19 13
1599 1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   true false true false false   false false false false false false false false   POINT (-73.9782603348665 40.7705790257951)   19 4 19 13
1770 1770 -73.9728170980779 40.7703557830437 7F-AM-1008-06 07F AM 10082018 6 Adult Gray   Gray+   Above Ground 28 in hole in tree false false false false false sitting false false false false false false true false   POINT (-73.9728170980779 40.770355783043705)   19 4 19 13
1777 1777 -73.9711751356843 40.7752422758202 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false false true true   false false false false false false true false   POINT (-73.9711751356843 40.7752422758202)   19 4 19 13
1871 1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House true false false false false   false false false false false false false true   POINT (-73.9748367344424 40.7693513000034)   19 4 19 13
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   false false true false false   true false false false false false true false   POINT (-73.956806913988 40.7987736900857)   19 4 19 13
1943 1943 -73.9690447463294 40.783913304529 21B-AM-1019-06 21B AM 10192018 6 Juvenile Gray   Gray+   Above Ground 7   false false true true false   false false false false false false true false   POINT (-73.9690447463294 40.78391330452901)   19 4 19 13
1998 1998 -73.9595686513629 40.7906859748696 32E-AM-1007-06 32E AM 10072018 6 Adult Gray   Gray+   Above Ground 40   false false true false false   false false false false false false true false   POINT (-73.9595686513629 40.7906859748696)   19 4 19 13
2010 2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false false false   POINT (-73.96738215574692 40.7786375267659)   19 4 19 13
2025 2025 -73.9766541879006 40.7674077265375 2E-AM-1010-06 02E AM 10102018 6 Adult Cinnamon   Cinnamon+   Above Ground 35   false false false false false leaping branch to branch false false false false false false true false   POINT (-73.9766541879006 40.7674077265375)   19 4 19 13
2052 2052 -73.9746493441414 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false false false cleaning false false false false false false true false   POINT (-73.9746493441414 40.7750478734868)   19 4 19 13
2081 2081 -73.9675718059539 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   false false true false false   false false false false false false true false   POINT (-73.9675718059539 40.7786049141486)   19 4 19 13
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree false false true false false cleaning false false false false false false true false   POINT (-73.975198284551 40.7740343763399)   19 4 19 13
2190 2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9657040391563 40.7755567428199)   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
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
2247 2247 -73.9559520137172 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #7 false false false false true false true false   POINT (-73.95595201371721 40.7950536287174)   19 4 19 13
2323 2323 -73.9715921982161 40.7746153066601 11E-PM-1012-06 11E PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 5   false false true true false   false false false false false false true false   POINT (-73.9715921982161 40.7746153066601)   19 4 19 13
2331 2331 -73.9694681803635 40.770585795359 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     false false false false true   false false false false false false true false   POINT (-73.9694681803635 40.770585795359)   19 4 19 13
2385 2385 -73.9787552947847 40.7690779628762 3B-AM-1010-06 03B AM 10102018 6 Adult Gray   Gray+   Above Ground 20   true false false false false   false false false false false false true false   POINT (-73.9787552947847 40.7690779628762)   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
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
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
2588 2588 -73.9581007437094 40.7959403112722 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   false false true false false   true false false true false false true false   POINT (-73.9581007437094 40.7959403112722)   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
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree false false true false true   false false false false true false true false   POINT (-73.9588339897601 40.7848084865431)   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
2815 2815 -73.9747311312394 40.7677319725044 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   false false true false false   false true false false false false false true   POINT (-73.97473113123941 40.7677319725044)   19 4 19 13
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   false false true false true   false false false false false false false false   POINT (-73.9578840941242 40.7955586232429)   19 4 19 13
3011 3011 -73.9678831312936 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   false false false false false   true false false false false false false false scolding POINT (-73.9678831312936 40.7847605974975)   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 3305.137ms