squirrels

58 rows where Date = 10102018 and Hectare Squirrel Number = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Date ✖

  • 10102018 · 58 ✖
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
117 117 -73.9607746337979 40.7939581069382 35B-AM-1010-01 35B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE lawn false false false false false walking w/ something in mouth false false false false false false true false   POINT (-73.9607746337979 40.793958106938206)   19 4 19 13
278 278 -73.9787796921165 40.7707526535381 5A-PM-1010-01 05A PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9787796921165 40.7707526535381)   19 4 19 13
283 283 -73.9529060669193 40.7927909735388 37I-AM-1010-01 37I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9529060669193 40.7927909735388)   19 4 19 13
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
317 317 -73.9545799024508 40.7908084039886 34I-PM-1010-01 34I PM 10102018 1 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9545799024508 40.7908084039886)   19 4 19 13
417 417 -73.9639888092327 40.791449395909 31A-AM-1010-01 31A AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9639888092327 40.791449395909005)   19 4 19 13
429 429 -73.9694784056618 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9694784056618 40.7787735291442)   19 4 19 13
520 520 -73.9749446629706 40.7720659696067 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare true false false false false   false false false false false false false false   POINT (-73.9749446629706 40.7720659696067)   19 4 19 13
534 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
557 557 -73.9792153893146 40.7688272492961 3B-AM-1010-01 03B AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9792153893146 40.7688272492961)   19 4 19 13
623 623 -73.9662939630722 40.7878502338031 26B-AM-1010-01 26B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE running across bridle path true false false false false   false false false false false false false true   POINT (-73.9662939630722 40.7878502338031)   19 4 19 13
632 632 -73.9767314435027 40.7661199889431 1F-AM-1010-01 01F AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9767314435027 40.7661199889431)   19 4 19 13
661 661 -73.9700759073973 40.7680560871695 5I-AM-1010-01 05I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9700759073973 40.7680560871695) 10090 23 4 51 11
690 690 -73.9767949141123 40.774454583585 9A-PM-1010-01 09A PM 10102018 1 Adult     +   Ground Plane FALSE by large tree in sectioned off area false false true false false i think it climbed the tree when i first saw it. false false false false false false true false   POINT (-73.9767949141123 40.774454583585)   19 4 19 13
705 705 -73.9779228287629 40.7681019683859 3D-PM-1010-01 03D PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9779228287629 40.7681019683859)   19 4 19 13
768 768 -73.9729394928432 40.7743256716496 11D-AM-1010-01 11D AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9729394928432 40.7743256716496)   19 4 19 13
769 769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   true false false false false false false true   POINT (-73.976521916284 40.773784724458)   19 4 19 13
847 847 -73.9771335416403 40.7668431485224 2E-AM-1010-01 02E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9771335416403 40.7668431485224)   19 4 19 13
860 860 -73.9713519158027 40.7798470142991 17B-AM-1010-01 17B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9713519158027 40.7798470142991)   19 4 19 13
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   false false true false false   false false false false false true false false started climbing down to me POINT (-73.9676514056678 40.7730853732876)   19 4 19 13
933 933 -73.9616204569548 40.7926188605509 33B-PM-1010-01 33B PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9616204569548 40.7926188605509)   19 4 19 13
948 948 -73.9568143871234 40.7899001700041 32G-AM-1010-01 32G AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9568143871234 40.7899001700041)   19 4 19 13
1156 1156 -73.9688929282726 40.7768899536946 15F-PM-1010-01 15F PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9688929282726 40.7768899536946)   19 4 19 13
1164 1164 -73.9790226400629 40.7698997653792 4B-AM-1010-01 04B AM 10102018 1 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Above Ground 2   false false true false false   false false false false true false true false   POINT (-73.9790226400629 40.7698997653792)   19 4 19 13
1181 1181 -73.9690395363594 40.771128205027 9I-PM-1010-01 09I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9690395363594 40.771128205027)   19 4 19 13
1251 1251 -73.9748247677824 40.7667893867839 2G-AM-1010-01 02G AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9748247677824 40.7667893867839)   19 4 19 13
1309 1309 -73.9545841828392 40.7926924268376 36H-AM-1010-01 36H AM 10102018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9545841828392 40.7926924268376)   19 4 19 13
1331 1331 -73.9588809150045 40.7847231576181 26I-PM-1010-01 26I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   false false true false true   false false false false false false true false   POINT (-73.9588809150045 40.7847231576181)   19 4 19 13
1357 1357 -73.9631350020634 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false true false false true   POINT (-73.9631350020634 40.791907210332)   19 4 19 13
1380 1380 -73.9806959248152 40.7684820679479 2A-AM-1010-01 02A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9806959248152 40.7684820679479)   19 4 19 13
1406 1406 -73.9746204802221 40.7699294840733 6E-PM-1010-01 06E PM 10102018 1 Juvenile     +   Ground Plane FALSE along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail false false false false false   false false false false false false true false   POINT (-73.9746204802221 40.7699294840733)   19 4 19 13
1505 1505 -73.9733461334967 40.7684314285151 5G-PM-1010-01 05G PM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9733461334967 40.7684314285151)   19 4 19 13
1511 1511 -73.9721642509914 40.7701179390078 7G-AM-1010-01 07G AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9721642509914 40.7701179390078)   19 4 19 13
1615 1615 -73.9564215689843 40.7957539444068 38E-AM-1010-01 38E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9564215689843 40.7957539444068)   19 4 19 13
1751 1751 -73.9594045885402 40.7840886870652 26I-AM-1010-01 26I AM 10102018 1 Adult Gray   Gray+   Above Ground 40   false false false false true   false false false false false false false false   POINT (-73.9594045885402 40.7840886870652)   19 4 19 13
1825 1825 -73.9624209799704 40.7910200972752 31C-PM-1010-01 31C PM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9624209799704 40.7910200972752)   19 4 19 13
1976 1976 -73.9770920860805 40.7694698040083 4C-PM-1010-01 04C PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false true false false false false true false   POINT (-73.9770920860805 40.7694698040083)   19 4 19 13
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees false false true true true scratching self false false false false true false true false   POINT (-73.9639505810228 40.789573183584)   19 4 19 13
2116 2116 -73.9801562527339 40.7687267327113 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9801562527339 40.7687267327113)   19 4 19 13
2163 2163 -73.9643664403785 40.7793670703727 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false false false false true false run from human w/ dog POINT (-73.9643664403785 40.7793670703727)   19 4 19 13
2169 2169 -73.9787736280005 40.7676126748454 2C-AM-1010-01 02C AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9787736280005 40.7676126748454)   19 4 19 13
2235 2235 -73.9748522796455 40.7719586621003 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare true false false false false   false false false false false false false false   POINT (-73.9748522796455 40.7719586621003)   19 4 19 13
2386 2386 -73.9565738895972 40.7900160952624 32H-AM-1010-01 32H AM 10102018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false not sure; walking-stop-walking-stop false false false false false false true false did seem to observe me for a moment POINT (-73.9565738895972 40.7900160952624)   19 4 19 13
2406 2406 -73.9668964315686 40.7777577990886 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9668964315686 40.7777577990886)   19 4 19 13
2418 2418 -73.9683653449966 40.7719661592206 10I-AM-1010-01 10I AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9683653449966 40.7719661592206)   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
2435 2435 -73.972087127535 40.776237268628 13C-AM-1010-01 13C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.972087127535 40.776237268628)   19 4 19 13
2451 2451 -73.9775865217038 40.7704928300008 5C-PM-1010-01 05C PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9775865217038 40.7704928300008)   19 4 19 13
2468 2468 -73.9674603784345 40.7749493803168 13H-PM-1010-01 13H PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9674603784345 40.774949380316805)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2553 2553 -73.9714744574918 40.7736266158925 10E-AM-1010-01 10E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9714744574918 40.7736266158925)   19 4 19 13
2565 2565 -73.9708640291801 40.7781721063527 15C-AM-1010-01 15C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9708640291801 40.7781721063527)   19 4 19 13
2569 2569 -73.9559663734409 40.7945828261377 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false true false false true false   POINT (-73.9559663734409 40.7945828261377)   19 4 19 13
2570 2570 -73.9721064150173 40.7667053821991 3I-AM-1010-01 03I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9721064150173 40.7667053821991)   19 4 19 13
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false true false true false   POINT (-73.970595860252 40.7832060751268)   19 4 19 13
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree false false true false false   false false false false false false false false   POINT (-73.9654741695628 40.7890427851106)   19 4 19 13
2977 2977 -73.9580681648547 40.7992010012653 41B-AM-1010-01 41B AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9580681648547 40.7992010012653)   19 4 19 13
2994 2994 -73.9617207091245 40.7922839025935 33B-AM-1010-01 33B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9617207091245 40.7922839025935)   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 129.019ms