squirrels

36 rows where Date = 10102018, Running = "true" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, 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, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

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
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
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
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
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   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
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
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
903 903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9719941577406 40.77037129313)   19 4 19 13
916 916 -73.9561887624471 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false true false false false true me POINT (-73.95618876244711 40.7958187455815)   19 4 19 13
1000 1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   19 4 19 13
1141 1141 -73.9664669369583 40.7774085361976 16G-AM-1010-05 16G AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9664669369583 40.7774085361976)   19 4 19 13
1236 1236 -73.9792039071114 40.7678749471267 2C-AM-1010-07 02C AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true false false false #7 & #8 chased each other up diff tree false false false false false false false true   POINT (-73.9792039071114 40.76787494712671)   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
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
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
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
1740 1740 -73.9577758125518 40.799384716477 41B-AM-1010-10 41B AM 10102018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9577758125518 40.799384716477)   19 4 19 13
1773 1773 -73.9611126813593 40.7943113021522 35B-AM-1010-03 35B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9611126813593 40.7943113021522)   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
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
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
2172 2172 -73.9642900903774 40.7917017168842 31A-AM-1010-03 31A AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9642900903774 40.7917017168842)   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
2256 2256 -73.9720050204318 40.7699419094168 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9720050204318 40.7699419094168)   19 4 19 13
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   true false true false true   false false false false false false true false   POINT (-73.975565603566 40.7738462518304)   19 4 19 13
2319 2319 -73.9756870789187 40.7733646782679 9B-AM-1010-09 09B AM 10102018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false food in mouth false false false false false false false false   POINT (-73.9756870789187 40.7733646782679)   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
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
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
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
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9752915601718 40.7739329570033)   19 4 19 13
2799 2799 -73.9682627382073 40.7730766743452 11H-AM-1010-09 11H AM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9682627382073 40.7730766743452)   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
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   true false false false false   false false false false false false true false   POINT (-73.9722053355548 40.7662094993614)   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

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 61.234ms