squirrels

63 rows where Date = 10192018 and Shift = "AM" sorted by Combination of Primary and Highlight Color

✎ 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, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Shift ✖

Police Precincts ✖

Date ✖

  • 10192018 · 63 ✖
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
455 455 -73.9688574691102 40.7837825208444 21B-AM-1019-04 21B AM 10192018 4       +         false false false false false   false false false false false false false false   POINT (-73.9688574691102 40.7837825208444)   19 4 19 13
512 512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
2608 2608 -73.9522677657659 40.7934034811368 38I-AM-1019-02 38I AM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9522677657659 40.7934034811368)   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
2882 2882 -73.956581233786 40.7902127690837 33H-AM-1019-01 33H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray Cinnamon patches Ground Plane FALSE   false false false false false wrestling with child false false false false false false false false   POINT (-73.956581233786 40.79021276908371)   19 4 19 13
699 699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
185 185 -73.9588468413094 40.7963852299012 38B-AM-1019-05 38B AM 10192018 5 Adult Gray   Gray+   Above Ground 28   false false true false false sitting still false true false false false false false false   POINT (-73.9588468413094 40.7963852299012)   19 4 19 13
273 273 -73.9579218587172 40.7960605028848 38C-AM-1019-04 38C AM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true true false false false false true false   POINT (-73.9579218587172 40.79606050288481)   19 4 19 13
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1653 1653 -73.9695881075086 40.7842441291991 21A-AM-1019-01 21A AM 10192018 1 Juvenile Gray Black Gray+Black   Above Ground 3   false false true false false   false false false false false false false false keeps to tree,drops down on side away from people POINT (-73.9695881075086 40.7842441291991)   19 4 19 13
1286 1286 -73.9589096782789 40.7939698757903 35D-AM-1019-02 35D AM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Black tail & edge, Cinnamon mid, While tail edge Ground Plane FALSE   false false false false true very quietly searching in long grass false false false false false false false false   POINT (-73.9589096782789 40.7939698757903)   19 4 19 13
6 6 -73.9565700386162 40.7902561000937 33H-AM-1019-02 33H AM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false wrestling with mother false false false false false false false false   POINT (-73.9565700386162 40.7902561000937)   19 4 19 13
200 200 -73.9510747586301 40.7973106833951 42H-AM-1019-02 42H AM 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.9510747586301 40.7973106833951)   19 4 19 13
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.958356112357 40.796014459571)   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
1152 1152 -73.9608399003798 40.7817704502248 23I-AM-1019-01 23I AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 18 on a tree false false true false false   false false false false false false false false eyed me warily,then went up the tree POINT (-73.9608399003798 40.7817704502248)   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
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
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
2342 2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false true false false true runs from (me) POINT (-73.9533645762606 40.7983709215535)   19 4 19 13
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false posing false false false false false false true true indifferent then runs from POINT (-73.9700162034073 40.7815277479588)   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
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
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
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
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
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
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
170 170 -73.9597205966324 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9597205966324 40.7969409510133)   19 4 19 13
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false false false   POINT (-73.958535640774 40.7982737896998)   19 4 19 13
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)   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
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
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1423 1423 -73.9600204328201 40.782877291358 24I-AM-1019-01 24I AM 10192018 1 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9600204328201 40.782877291358)   19 4 19 13
1540 1540 -73.957710975899 40.7984055614047 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.957710975899 40.7984055614047)   19 4 19 13
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9581241870185 40.7961057536141)   19 4 19 13
1759 1759 -73.9576219570858 40.7963351225672 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9576219570858 40.7963351225672)   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
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   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
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
2168 2168 -73.9582363437135 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9582363437135 40.7987752300505)   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
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

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