squirrels

45 rows where Date = 10122018, Foraging = "false" and Location = "Ground Plane"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Running, Chasing, Climbing, Eating, Other Activities, Kuks, 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
142 142 -73.9724063986771 40.7705711897977 7F-PM-1012-01 07F PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9724063986771 40.7705711897977)   19 4 19 13
285 285 -73.9691433356733 40.7731708333242 11G-AM-1012-01 11G AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9691433356733 40.77317083332421)   19 4 19 13
328 328 -73.9652357279671 40.7819296887147 21E-PM-1012-02 21E PM 10122018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9652357279671 40.7819296887147)   19 4 19 13
392 392 -73.9802376131034 40.7680707516627 1B-AM-1012-12 01B AM 10122018 12 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9802376131034 40.7680707516627)   19 4 19 13
420 420 -73.9671851611243 40.7750878657618 14H-PM-1012-01 14H PM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false false true false false approaches (came very close to me) POINT (-73.9671851611243 40.7750878657618)   19 4 19 13
447 447 -73.9725906016474 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9725906016474 40.7713889729739)   19 4 19 13
549 549 -73.9549082481152 40.7933537584624 36G-PM-1012-01 36G PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false crossing east drive false false false false false false false false   POINT (-73.9549082481152 40.7933537584624)   19 4 19 13
568 568 -73.9799441493404 40.7671499997527 1C-AM-1012-01 01C AM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9799441493404 40.7671499997527) 12081 11 4 51 10
606 606 -73.9717580228664 40.7715726159383 8F-PM-1012-01 08F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.97175802286641 40.7715726159383)   19 4 19 13
772 772 -73.9584188461059 40.7913241048498 33E-PM-1012-07 33E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9584188461059 40.7913241048498)   19 4 19 13
907 907 -73.958060992131 40.7907158878729 32F-AM-1012-06 32F AM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.958060992131 40.7907158878729)   19 4 19 13
947 947 -73.9736543790582 40.7651444188432 1H-AM-1012-02 01H AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9736543790582 40.7651444188432)   19 4 19 13
1001 1001 -73.9801985977846 40.7680159511705 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false fighting w/ pigeons false false false false false false true false   POINT (-73.9801985977846 40.7680159511705)   19 4 19 13
1090 1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.967767372181 40.784702631615)   19 4 19 13
1100 1100 -73.980542388615 40.7682048804794 1B-AM-1012-14 01B AM 10122018 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
1166 1166 -73.980048119915 40.7676638655026 1B-AM-1012-06 01B AM 10122018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false false false true false   POINT (-73.980048119915 40.7676638655026)   19 4 19 13
1219 1219 -73.9661892200474 40.7836798072777 22D-PM-1012-06 22D PM 10122018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9661892200474 40.7836798072777)   19 4 19 13
1231 1231 -73.9555583724966 40.7932879745739 36F-PM-1012-07 36F PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9555583724966 40.7932879745739)   19 4 19 13
1292 1292 -73.959019987128 40.7912546691805 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.959019987128 40.7912546691805)   19 4 19 13
1349 1349 -73.9806805581636 40.7681537966505 1B-AM-1012-16 01B AM 10122018 16 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9806805581636 40.7681537966505)   19 4 19 13
1428 1428 -73.9666113598566 40.7752662550312 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)   19 4 19 13
1444 1444 -73.9763852372393 40.768876248561 4D-AM-1012-02 04D AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9763852372393 40.768876248561)   19 4 19 13
1461 1461 -73.956926909344 40.7965323262487 39D-PM-1012-03 39D PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.956926909344 40.7965323262487)   19 4 19 13
1551 1551 -73.9785114291288 40.7719779589449 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785114291288 40.7719779589449)   19 4 19 13
1721 1721 -73.9587330707463 40.7907682009641 32F-AM-1012-02 32F AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray patches on back legs Ground Plane FALSE   false false false false false curious about me false false false false false true false true   POINT (-73.9587330707463 40.7907682009641)   19 4 19 13
1805 1805 -73.9590328527128 40.7912214417577 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.9590328527128 40.7912214417577)   19 4 19 13
1840 1840 -73.9733222531339 40.7649975371546 1I-PM-1012-01 01I PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733222531339 40.7649975371546)   19 4 19 13
2051 2051 -73.9544808708211 40.7906575852286 34I-AM-1012-02 34I AM 10122018 2 Adult Gray White Gray+White Short tail Ground Plane FALSE   false false false false false hiding false false false false false false false true   POINT (-73.9544808708211 40.7906575852286)   19 4 19 13
2113 2113 -73.9582904814652 40.7905915749564 32F-AM-1012-04 32F AM 10122018 4 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9582904814652 40.7905915749564)   19 4 19 13
2199 2199 -73.9677500862135 40.7726060987821 11I-AM-1012-01 11I AM 10122018 1 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.9677500862135 40.7726060987821)   19 4 19 13
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9583688637255 40.791388958496)   19 4 19 13
2304 2304 -73.9715251156965 40.774621784862 11E-PM-1012-07 11E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9715251156965 40.774621784862)   19 4 19 13
2309 2309 -73.966824257293 40.7753405377869 14H-PM-1012-04 14H PM 10122018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.966824257293 40.7753405377869)   19 4 19 13
2369 2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9801956082236 40.767836440957)   19 4 19 13
2391 2391 -73.9721497679014 40.7716160199386 8F-PM-1012-02 08F PM 10122018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9721497679014 40.7716160199386)   19 4 19 13
2394 2394 -73.9785829546046 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785829546046 40.7719652299132)   19 4 19 13
2480 2480 -73.9546780963388 40.7903216522111 34I-AM-1012-03 34I AM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false nut in mouth false false false false false false true false   POINT (-73.9546780963388 40.7903216522111)   19 4 19 13
2598 2598 -73.976658503418 40.7686868456917 4D-AM-1012-03 04D AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   false true true false false   false false false false true false true false   POINT (-73.976658503418 40.7686868456917)   19 4 19 13
2600 2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9544553697736 40.7912866208106)   19 4 19 13
2617 2617 -73.9564228238736 40.7936908887644 36F-PM-1012-06 36F PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9564228238736 40.7936908887644)   19 4 19 13
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13
2821 2821 -73.9754536566013 40.7698604918771 5E-PM-1012-04 05E PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9754536566013 40.7698604918771)   19 4 19 13
2852 2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.97281464823851 40.765295171474506)   19 4 19 13
2898 2898 -73.9794118234651 40.7674495540569 1C-AM-1012-02 01C AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false true false false   false false false false true false false true   POINT (-73.9794118234651 40.7674495540569)   19 4 19 13
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9800094828465 40.7677782585639)   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 62.012ms