squirrels

158 rows where Date = 10192018 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Police Precincts ✖

Date ✖

  • 10192018 · 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
693 693 -73.969353372175 40.7838247422369 21A-AM-1019-06 21A AM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.969353372175 40.7838247422369)   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
766 766 -73.9684463154398 40.7834813319352 21B-AM-1019-02 21B AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9684463154398 40.7834813319352)   19 4 19 13
804 804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   true false false true false   false false false false false false true true indifferent then runs from POINT (-73.9697196619878 40.7814068507607)   19 4 19 13
827 827 -73.97002473509 40.7836929044459 21A-AM-1019-08 21A AM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.97002473509 40.7836929044459)   19 4 19 13
846 846 -73.9582643954055 40.8000460061272 42A-AM-1019-01 42A AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.95826439540551 40.8000460061272)   19 4 19 13
922 922 -73.9708002461415 40.7726685284831 10F-PM-1019-10 10F PM 10192018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Arbor path & hill w/ bushes true false false true true   false false false false true false true false   POINT (-73.9708002461415 40.7726685284831)   19 4 19 13
999 999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   19 4 19 13
1026 1026 -73.9710951149579 40.772501245008 10F-PM-1019-04 10F PM 10192018 4 Adult Black   Black+   Ground Plane FALSE Behind fence, grass false false false false true   false false false false false false true false   POINT (-73.9710951149579 40.772501245008)   19 4 19 13
1175 1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground false false false false true   false false false true false false true false   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
1184 1184 -73.9807982742225 40.7678795985389 1B-PM-1019-01 01B PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9807982742225 40.7678795985389)   19 4 19 13
1185 1185 -73.958230674366 40.7989268396525 40B-AM-1019-08 40B AM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false false false true true   POINT (-73.958230674366 40.7989268396525)   19 4 19 13
1196 1196 -73.9580111496275 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9580111496275 40.7985365971474)   19 4 19 13
1269 1269 -73.9652921233647 40.790440565854 29A-PM-1019-01 29A PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9652921233647 40.790440565854)   19 4 19 13
1316 1316 -73.9674724790652 40.7768771349868 15G-PM-1019-01 15G PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9674724790652 40.7768771349868)   19 4 19 13
1445 1445 -73.9696196840065 40.7836431098335 21A-AM-1019-09 21A AM 10192018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9696196840065 40.7836431098335)   19 4 19 13
1517 1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   true false true false false   false false false false false false true false   POINT (-73.970041085185 40.783442758031306)   19 4 19 13
1582 1582 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9804065254162 40.7681481183296)   19 4 19 13
1583 1583 -73.9701030393506 40.7838953063625 21A-AM-1019-04 21A AM 10192018 4 Juvenile Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701030393506 40.7838953063625)   19 4 19 13
1591 1591 -73.9576223390082 40.7979746639647 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false true true false   POINT (-73.9576223390082 40.79797466396471)   19 4 19 13
1613 1613 -73.9599202233536 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599202233536 40.7972599930224)   19 4 19 13
1801 1801 -73.9587072373474 40.7985209579925 40B-AM-1019-01 40B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9587072373474 40.7985209579925)   19 4 19 13
1877 1877 -73.9524490779105 40.7936003219524 38I-AM-1019-01 38I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9524490779105 40.7936003219524)   19 4 19 13
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9594174605642 40.7973128653773)   19 4 19 13
1897 1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) false false true false false   false false false false false false true false   POINT (-73.97107389601 40.7723265810536)   19 4 19 13
1907 1907 -73.9689227467959 40.7837541607494 21B-AM-1019-03 21B AM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9689227467959 40.7837541607494)   19 4 19 13
1912 1912 -73.9698064901149 40.7842538115839 21A-AM-1019-03 21A AM 10192018 3 Adult Gray   Gray+   Ground Plane FALSE Tree & ground false true false false false   false false false false false false true false   POINT (-73.9698064901149 40.78425381158391)   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
1986 1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true true   POINT (-73.958247706428 40.7989079136796)   19 4 19 13
2064 2064 -73.970260899173 40.783651724865 21A-AM-1019-05 21A AM 10192018 5 Adult Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.970260899173 40.783651724865)   19 4 19 13
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false false true stood on back legs false false false false false true true true   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
2140 2140 -73.9598875541307 40.7973415580717 38A-AM-1019-04 38A AM 10192018 4 Adult Gray   Gray+   Above Ground 2   false false false false false walking false false false false false false true false   POINT (-73.9598875541307 40.7973415580717)   19 4 19 13
2200 2200 -73.9698080328304 40.7842252948542 21A-AM-1019-02 21A AM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE Tree & ground false true false false false   false false false false false false true false   POINT (-73.9698080328304 40.7842252948542)   19 4 19 13
2203 2203 -73.9710531485298 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.97105314852982 40.777375706944504)   19 4 19 13
2283 2283 -73.9628982772673 40.7884304803386 28D-PM-1019-01 28D PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9628982772673 40.7884304803386)   19 4 19 13
2295 2295 -73.9590632051055 40.7963146584827 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   false false false false false sitting in tree true true false true false false true false observant POINT (-73.9590632051055 40.7963146584827)   19 4 19 13
2320 2320 -73.9576897478787 40.7964695328457 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9576897478787 40.7964695328457)   19 4 19 13
2375 2375 -73.9563720614251 40.7879453306251 31I-PM-1019-01 31I PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9563720614251 40.7879453306251)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
2466 2466 -73.9599419926299 40.7972774728811 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599419926299 40.7972774728811)   19 4 19 13
2482 2482 -73.9805927710872 40.7679989116642 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9805927710872 40.7679989116642)   19 4 19 13
2517 2517 -73.9710221361528 40.7724939691584 10F-PM-1019-01 10F PM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Above Ground 2 Behind fence, tree trunk false false true false false sitting false false false false false false true false   POINT (-73.9710221361528 40.7724939691584)   19 4 19 13
2567 2567 -73.9690241805398 40.7837967580773 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9690241805398 40.7837967580773)   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
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   true false false false false false true false   POINT (-73.9582150734453 40.7962862794303)   19 4 19 13
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9809688694074 40.7688535974878)   19 4 19 13
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   false false false false true standing on back legs false false false false false true true false   POINT (-73.9601851468038 40.7968698151479)   19 4 19 13
2688 2688 -73.9799302952205 40.7677207209798 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9799302952205 40.7677207209798)   19 4 19 13
2736 2736 -73.9593895253501 40.7973085844087 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9593895253501 40.7973085844087)   19 4 19 13
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9802983138318 40.7676540772339)   19 4 19 13
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9533101544112 40.7938634280159)   19 4 19 13
2834 2834 -73.9651132904127 40.7905384124102 29A-PM-1019-02 29A PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9651132904127 40.7905384124102)   19 4 19 13
2841 2841 -73.9693262952166 40.783260411082 21B-AM-1019-01 21B AM 10192018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9693262952166 40.783260411082)   19 4 19 13
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9530811255728 40.79830691185791)   19 4 19 13
2904 2904 -73.9720389756717 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9720389756717 40.7763524091989)   19 4 19 13
2907 2907 -73.9685201626934 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9685201626934 40.783329261225)   19 4 19 13
2987 2987 -73.9563724838337 40.7882504581015 31I-PM-1019-04 31I PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.95637248383372 40.7882504581015)   19 4 19 13
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   false false true true false eating (on branch) true false false false false false true false   POINT (-73.9662895079734 40.7843300758044)   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 13.11ms