squirrels

53 rows where Date = 10182018, Foraging = "false" and Indifferent = "true"

View and edit SQL

Suggested facets: Hectare, Shift, 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, Tail flags, Tail twitches, 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
82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
166 -73.963846339804 40.7834051716226 23F-AM-1018-01 23F AM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.963846339804 40.7834051716226)   19 4 19 13
309 -73.9696001184129 40.7820810673532 19B-PM-1018-05 19B PM 10182018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9696001184129 40.7820810673532)   19 4 19 13
329 -73.967832992543 40.7783669913408 17E-PM-1018-03 17E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.967832992543 40.7783669913408)   19 4 19 13
339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false true true false   false false false false true false true false   POINT (-73.96550957640301 40.7752456763263)   19 4 19 13
380 -73.9649590119935 40.7822107920769 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false true false true false   POINT (-73.9649590119935 40.7822107920769)   19 4 19 13
408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false chilling false false false false false false true false observed POINT (-73.96337601736352 40.7818422357619)   19 4 19 13
450 -73.9644293195773 40.7813829172072 21F-AM-1018-02 21F AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9644293195773 40.7813829172072)   19 4 19 13
469 -73.9717201378775 40.776120280884 13D-PM-1018-02 13D PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9717201378775 40.776120280884)   19 4 19 13
488 -73.9615751148595 40.7954551238146 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9615751148595 40.7954551238146)   19 4 19 13
620 -73.9655905300923 40.7752614638023 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   true false true false false   false false false false true false true false   POINT (-73.9655905300923 40.7752614638023)   19 4 19 13
710 -73.9695569897042 40.7712062147171 9H-PM-1018-01 09H PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.96955698970422 40.7712062147171)   19 4 19 13
746 -73.9591407691 40.7960846903122 37B-AM-1018-01 37B AM 10182018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9591407691 40.7960846903122)   19 4 19 13
884 -73.9678937289837 40.7782808361645 16E-PM-1018-01 16E PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9678937289837 40.7782808361645)   19 4 19 13
1007 -73.9635317822977 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   true false false true false false true false   POINT (-73.9635317822977 40.7821352080233)   19 4 19 13
1061 -73.9532657715601 40.7949046809422 39G-AM-1018-02 39G AM 10182018 2 Juvenile Gray   Gray+   Above Ground 25 Tree false false false false false sitting & watching false false false false false false true false   POINT (-73.9532657715601 40.7949046809422)   19 4 19 13
1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9722265046794 40.7700916895929)   19 4 19 13
1086 -73.9713399316534 40.7750678026757 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   false false true false false lounging on tree upside down false false false false true false true false   POINT (-73.9713399316534 40.7750678026757)   19 4 19 13
1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   false false true false false cleaning false false false false false false true false   POINT (-73.9712550584322 40.7764273475386)   19 4 19 13
1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9616999731028 40.7954126939561)   19 4 19 13
1262 -73.9683345414813 40.7779016280345 16E-PM-1018-07 16E PM 10182018 7 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   true false false false false false true false   POINT (-73.9683345414813 40.7779016280345)   19 4 19 13
1338 -73.9716624574422 40.7762037110101 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false scratching false false false false false false true false   POINT (-73.9716624574422 40.7762037110101)   19 4 19 13
1370 -73.9681627331154 40.7785099665602 17E-PM-1018-02 17E PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE On the rock true false false false false   false false false false false false true false   POINT (-73.9681627331154 40.7785099665602)   19 4 19 13
1393 -73.9687134137786 40.7812207913391 19C-PM-1018-03 19C PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9687134137786 40.7812207913391)   19 4 19 13
1402 -73.9745009906157 40.7741574075364 10C-AM-1018-01 10C AM 10182018 1 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.9745009906157 40.7741574075364)   19 4 19 13
1509 -73.9556450015702 40.7967188058002 39E-AM-1018-04 39E AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9556450015702 40.7967188058002)   19 4 19 13
1528 -73.9690104245067 40.7853358193723 23A-AM-1018-02 23A AM 10182018 2 Juvenile Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690104245067 40.7853358193723)   19 4 19 13
1530 -73.9689305978751 40.7818152496266 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence true false true false false climbing (fence) false false false false false false true false   POINT (-73.9689305978751 40.7818152496266)   19 4 19 13
1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9630381400083 40.7807571827321)   19 4 19 13
1691 -73.9703705008688 40.7818586173755 19B-PM-1018-02 19B PM 10182018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9703705008688 40.7818586173755)   19 4 19 13
1736 -73.9743873549635 40.7745426051392 10C-AM-1018-04 10C AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9743873549635 40.7745426051392)   19 4 19 13
1737 -73.9640741640547 40.7807274581426 20G-AM-1018-01 20G AM 10182018 1 Juvenile Gray   Gray+   Above Ground 7 Tree limb false false false false false sitting still on limb false false false false false false true false   POINT (-73.9640741640547 40.7807274581426)   19 4 19 13
1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false false true false true false   POINT (-73.9720365327715 40.7762329714016)   19 4 19 13
1856 -73.9782940231149 40.7694236097224 4B-PM-1018-05 04B PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9782940231149 40.7694236097224)   19 4 19 13
1874 -73.9657327332849 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   false false true false false   false false false false false false true false   POINT (-73.9657327332849 40.7747554568985)   19 4 19 13
1895 -73.954699659637 40.7951308856929 38F-AM-1018-02 38F AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.954699659637 40.7951308856929)   19 4 19 13
1898 -73.9721263050502 40.7698763846186 7G-PM-1018-01 07G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9721263050502 40.7698763846186)   19 4 19 13
1989 -73.9631646754647 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631646754647 40.7925716810884)   19 4 19 13
2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk false false true false false   false false false false true false true false   POINT (-73.9686370726471 40.7780382348833)   19 4 19 13
2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761776424664 40.7695941843825)   19 4 19 13
2294 -73.9630820577441 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.9630820577441 40.7821632293136)   19 4 19 13
2407 -73.9555724351776 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9555724351776 40.7967602498249)   19 4 19 13
2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false sitting in the sun false false false false false false true false   POINT (-73.9748635473782 40.7742591029151)   19 4 19 13
2543 -73.9691424997919 40.780542852496 18C-AM-1018-02 18C AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9691424997919 40.780542852496)   19 4 19 13
2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9635981227569 40.7928169540326)   19 4 19 13
2599 -73.9689893412693 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree false false true false false   false false false false false false true false   POINT (-73.9689893412693 40.785308737683)   19 4 19 13
2611 -73.951448051873 40.7973951649254 42G-AM-1018-02 42G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.951448051873 40.7973951649254)   19 4 19 13
2822 -73.9711120079542 40.7760801911766 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false false climbing (down) false false false false false false true false   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
2897 -73.9689554458632 40.7778593393957 16E-PM-1018-10 16E PM 10182018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9689554458632 40.7778593393957)   19 4 19 13
2941 -73.9690266660317 40.7853134751509 23A-AM-1018-01 23A AM 10182018 1 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690266660317 40.7853134751509)   19 4 19 13
2960 -73.962524814515 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true false   POINT (-73.962524814515 40.7810022923615)   19 4 19 13
3014 -73.9665572004288 40.7804347548303 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9665572004288 40.7804347548303)   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 57.591ms