squirrels

52 rows where Date = 10102018, Hectare Squirrel Number = 2 and Police Precincts = 13

✎ 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, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, 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
13 13 -73.9541201789795 40.7931811701082 36H-AM-1010-02 36H AM 10102018 2 Adult Gray   Gray+ just outside hectare Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9541201789795 40.7931811701082)   19 4 19 13
46 46 -73.9673253417305 40.7749505252981 13H-PM-1010-02 13H PM 10102018 2 Adult Gray   Gray+   Above Ground 5 tree false false false false true   false false false false false false true false   POINT (-73.9673253417305 40.7749505252981)   19 4 19 13
110 110 -73.9711318790279 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   true false false false false   false false false false true false false true   POINT (-73.9711318790279 40.7701941550273)   19 4 19 13
253 253 -73.9589627056561 40.7847591558491 26I-PM-1010-02 26I PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true hiding food false false false false true false true false   POINT (-73.9589627056561 40.7847591558491)   19 4 19 13
287 287 -73.9709281471442 40.7828097939777 20A-AM-1010-02 20A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9709281471442 40.7828097939777)   19 4 19 13
535 535 -73.9772396728545 40.7668696411765 2E-AM-1010-02 02E AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false true false totally indifferent POINT (-73.9772396728545 40.7668696411765)   19 4 19 13
650 650 -73.9809610117171 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence false false false true false   false false false false true false false true   POINT (-73.9809610117171 40.7683896665502)   19 4 19 13
671 671 -73.9709244006956 40.7676942639697 5I-AM-1010-02 05I AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9709244006956 40.7676942639697)   19 4 19 13
680 680 -73.9564011421122 40.7958097849369 38E-AM-1010-02 38E AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false false climbs POINT (-73.95640114211221 40.7958097849369)   19 4 19 13
711 711 -73.9767980925124 40.774362775678 9A-PM-1010-02 09A PM 10102018 2 Adult     +   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9767980925124 40.774362775678)   19 4 19 13
745 745 -73.9671640520938 40.7772236833816 16G-AM-1010-02 16G AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9671640520938 40.7772236833816)   19 4 19 13
923 923 -73.9578924882613 40.789806297824 32G-AM-1010-02 32G AM 10102018 2 Adult Gray   Gray+   Above Ground 13   false false true true false   false false false false true false false true   POINT (-73.9578924882613 40.789806297824)   19 4 19 13
1154 1154 -73.9786936992465 40.7713943674666 5A-PM-1010-02 05A PM 10102018 2 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9786936992465 40.7713943674666)   19 4 19 13
1238 1238 -73.9773692131441 40.7679771150149 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9773692131441 40.7679771150149)   19 4 19 13
1256 1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9679457364586 40.7717350221981)   19 4 19 13
1258 1258 -73.9789385196073 40.7675202157155 2C-AM-1010-02 02C AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9789385196073 40.7675202157155)   19 4 19 13
1330 1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false true false true false false ran from human with dog POINT (-73.9643032554205 40.7794514526463)   19 4 19 13
1333 1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false false false false laying on tree branch false false false true true false false false   POINT (-73.9754527701832 40.7656088463928)   19 4 19 13
1374 1374 -73.9653739273979 40.7889762096967 28B-PM-1010-02 28B PM 10102018 2 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9653739273979 40.7889762096967)   19 4 19 13
1414 1414 -73.9580513096783 40.79909641532 41B-AM-1010-02 41B AM 10102018 2 Adult Gray White Gray+White   Above Ground 16   false true false false false   false false false false false false false false   POINT (-73.9580513096783 40.79909641532)   19 4 19 13
1536 1536 -73.9746128451271 40.7700957046709 6E-PM-1010-02 06E PM 10102018 2 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false false false false true   false false false false false false true false   POINT (-73.9746128451271 40.7700957046709)   19 4 19 13
1643 1643 -73.9530535624781 40.7929809144271 37I-AM-1010-02 37I AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9530535624781 40.7929809144271)   19 4 19 13
1693 1693 -73.9593781427412 40.7841519912635 26I-AM-1010-02 26I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   false false false false true   false false false false false false false false   POINT (-73.95937814274122 40.7841519912635)   19 4 19 13
1714 1714 -73.9763542780331 40.7736531303622 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush false false true false true   false false false false true false false true froze POINT (-73.9763542780331 40.773653130362206)   19 4 19 13
1816 1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9710187505339 40.7797265666746)   19 4 19 13
1838 1838 -73.9686622009739 40.7767294380502 15F-PM-1010-02 15F PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9686622009739 40.7767294380502)   19 4 19 13
1909 1909 -73.9772070122251 40.7694343352509 4C-PM-1010-02 04C PM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.97720701222511 40.7694343352509)   19 4 19 13
1934 1934 -73.969756965598 40.7786455091699 16D-PM-1010-02 16D PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.969756965598 40.7786455091699)   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
2038 2038 -73.9803562137049 40.7685780990634 2B-AM-1010-02 02B AM 10102018 2 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9803562137049 40.7685780990634)   19 4 19 13
2097 2097 -73.9773486521595 40.7708454902113 5C-PM-1010-02 05C PM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9773486521595 40.7708454902113)   19 4 19 13
2136 2136 -73.9721897915211 40.7660434203132 3I-AM-1010-02 03I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   true false false false false   false false false false false false true false   POINT (-73.9721897915211 40.76604342031321)   19 4 19 13
2226 2226 -73.9624296435843 40.791320813687 31C-PM-1010-02 31C PM 10102018 2 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9624296435843 40.791320813687)   19 4 19 13
2229 2229 -73.9620719414292 40.788637452988 29D-PM-1010-02 29D PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9620719414292 40.788637452988)   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
2330 2330 -73.9724618533895 40.7745021602455 11D-AM-1010-02 11D AM 10102018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true walking false false false false true false false true   POINT (-73.9724618533895 40.7745021602455)   19 4 19 13
2361 2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   false false true false false nest building false false false false false false true false   POINT (-73.9708032298419 40.77842656745441)   19 4 19 13
2426 2426 -73.9790203973636 40.7688837114832 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false together w/ #3 false false false false false false false true   POINT (-73.9790203973636 40.7688837114832)   19 4 19 13
2470 2470 -73.96388775887 40.7915477304252 31A-AM-1010-02 31A AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true scratching false false false false false false true false   POINT (-73.96388775887 40.7915477304252)   19 4 19 13
2474 2474 -73.9721448879766 40.7762112840981 13C-AM-1010-02 13C AM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true false false burying false false false false false false true false   POINT (-73.9721448879766 40.7762112840981)   19 4 19 13
2500 2500 -73.9689703880705 40.7712025611298 9I-PM-1010-02 09I PM 10102018 2 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.96897038807052 40.7712025611298)   19 4 19 13
2501 2501 -73.9616944195776 40.7927250423024 33B-PM-1010-02 33B PM 10102018 2 Adult     +   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616944195776 40.7927250423024)   19 4 19 13
2525 2525 -73.9612352611518 40.7944813634744 35B-AM-1010-02 35B AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE landscaped area false false false false true   false false false false false false true false   POINT (-73.9612352611518 40.7944813634744)   19 4 19 13
2578 2578 -73.9765386965371 40.766371971273 1F-AM-1010-02 01F AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9765386965371 40.766371971273)   19 4 19 13
2615 2615 -73.9734605176646 40.7686218881386 5G-PM-1010-02 05G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9734605176646 40.7686218881386)   19 4 19 13
2717 2717 -73.9632238528617 40.7920328991252 32B-PM-1010-02 32B PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9632238528617 40.7920328991252)   19 4 19 13
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         false false false true false   false false false false true false true false   POINT (-73.9681960138614 40.7726867422002)   19 4 19 13
2807 2807 -73.9618213644671 40.7927648819738 33B-AM-1010-02 33B AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.96182136446711 40.7927648819738)   19 4 19 13
2968 2968 -73.9587236619579 40.7991850180434 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West true false true false false   false false false true false false false true   POINT (-73.9587236619579 40.7991850180434)   19 4 19 13
2999 2999 -73.972415182837 40.773080463452 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.972415182837 40.773080463452)   19 4 19 13
3006 3006 -73.9744390217386 40.7663168362582 2G-AM-1010-02 02G AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9744390217386 40.7663168362582)   19 4 19 13
3022 3022 -73.9639941227864 40.7899152327912 29B-PM-1010-02 29B PM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9639941227864 40.7899152327912)   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 71.737ms