squirrels

57 rows where Date = 10172018, Indifferent = "false" and Runs from = "false" sorted by Location

✎ 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, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Other Interactions

Runs from ✖

  • false · 57 ✖

Indifferent ✖

  • false · 57 ✖

Date ✖

  • 10172018 · 57 ✖
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
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump false false false false true   false false false false false false false false   POINT (-73.9702676472613 40.7762126854894)   19 4 19 13
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
778 778 -73.9677054870327 40.778992870166 17E-AM-1017-03 17E AM 10172018 3 Adult Gray   Gray+   Above Ground 9 Tree trunk false false true false false   false false false false false false false false   POINT (-73.9677054870327 40.778992870166)   19 4 19 13
844 844 -73.9642379942652 40.7774792520738 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   false false true false false   false false false false false false false false was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)   19 4 19 13
1241 1241 -73.9651817987035 40.7819082838334 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree false false false true true   false false false false true false false false walks from POINT (-73.9651817987035 40.7819082838334)   19 4 19 13
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false false false false false false false false   POINT (-73.9693159934697 40.7831212338295)   19 4 19 13
1916 1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false true false false false false false false stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)   19 4 19 13
2084 2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   false false false false false staying very still to avoid two very curious dogs on the ground false false false false false false false false petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)   19 4 19 13
2114 2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false false false watching false false false false false true false false   POINT (-73.9651541395415 40.7798283208748)   19 4 19 13
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   false false false false false   true false false false false false false false   POINT (-73.9567801028221 40.7960096659564)   19 4 19 13
70 70 -73.9804528867547 40.7696753655986 3A-PM-1017-05 03A PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9804528867547 40.76967536559861)   19 4 19 13
106 106 -73.9634623418761 40.7917685404482 31A-PM-1017-04 31A PM 10172018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9634623418761 40.7917685404482)   19 4 19 13
240 240 -73.9767080512177 40.7717708794221 6B-PM-1017-04 06B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767080512177 40.7717708794221)   19 4 19 13
321 321 -73.9694288806212 40.7842952265291 22A-PM-1017-01 22A PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9694288806212 40.7842952265291)   19 4 19 13
350 350 -73.9707471099503 40.7759255131734 13E-AM-1017-08 13E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9707471099503 40.7759255131734)   19 4 19 13
461 461 -73.9648195433192 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false staring false false false false true false false false   POINT (-73.9648195433192 40.7796399955868)   19 4 19 13
502 502 -73.9683312453011 40.7801661685712 18D-PM-1017-01 18D PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9683312453011 40.7801661685712)   19 4 19 13
651 651 -73.9801661903932 40.7697950141751 3A-PM-1017-03 03A PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9801661903932 40.7697950141751)   19 4 19 13
659 659 -73.9572686979412 40.796268457326 38D-AM-1017-03 38D AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false false false false   POINT (-73.9572686979412 40.796268457326)   19 4 19 13
677 677 -73.9799155966086 40.7698034314993 3A-PM-1017-08 03A PM 10172018 8 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9799155966086 40.7698034314993)   19 4 19 13
682 682 -73.9651828383592 40.7802820943863 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true true false false   POINT (-73.9651828383592 40.7802820943863)   19 4 19 13
723 723 -73.9654397484763 40.7798863522904 19F-PM-1017-03 19F PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9654397484763 40.7798863522904)   19 4 19 13
763 763 -73.9767455430709 40.7717866237826 6B-PM-1017-06 06B PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767455430709 40.7717866237826)   19 4 19 13
806 806 -73.970475755546 40.7763348062134 13E-AM-1017-02 13E AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true begging (came one yard away from me and stood there) false false false false false true false false   POINT (-73.970475755546 40.7763348062134)   19 4 19 13
875 875 -73.9700861859051 40.7770639340582 14E-PM-1017-04 14E PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9700861859051 40.7770639340582)   19 4 19 13
973 973 -73.9705977059862 40.7760413182276 13E-AM-1017-09 13E AM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9705977059862 40.776041318227605)   19 4 19 13
1050 1050 -73.9562642076935 40.7983338763074 41C-AM-1017-02 41C AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9562642076935 40.7983338763074)   19 4 19 13
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9594406225891 40.7918533707789)   19 4 19 13
1113 1113 -73.9679309130266 40.7792437838039 17E-AM-1017-04 17E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE Shore false false false false true   false false false false false false false false   POINT (-73.9679309130266 40.779243783803906)   19 4 19 13
1132 1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9798390387307 40.7700761090896)   19 4 19 13
1191 1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 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.9634835346077 40.7918244310746)   19 4 19 13
1276 1276 -73.9798005188704 40.7691868791734 3A-PM-1017-01 03A PM 10172018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.97980051887042 40.7691868791734)   19 4 19 13
1340 1340 -73.9773083616259 40.7710535931636 6B-PM-1017-01 06B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false true false false   POINT (-73.9773083616259 40.7710535931636)   19 4 19 13
1366 1366 -73.9711582199102 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false true true false false   POINT (-73.9711582199102 40.7783674409485)   19 4 19 13
1474 1474 -73.9801971465604 40.7697081749827 3A-PM-1017-04 03A PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9801971465604 40.7697081749827)   19 4 19 13
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.96423978295472 40.7918992406575)   19 4 19 13
1712 1712 -73.9801899519657 40.7695777009264 3A-PM-1017-02 03A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9801899519657 40.7695777009264)   19 4 19 13
1731 1731 -73.9692846326638 40.7841049008492 22A-PM-1017-02 22A PM 10172018 2 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9692846326638 40.7841049008492)   19 4 19 13
1789 1789 -73.9596271142953 40.7906612313673 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false true false false false false false false   POINT (-73.9596271142953 40.7906612313673)   19 4 19 13
1792 1792 -73.9705704527481 40.7762853012151 13E-AM-1017-06 13E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9705704527481 40.7762853012151)   19 4 19 13
1868 1868 -73.9712265022781 40.7783790991192 15C-PM-1017-04 15C PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9712265022781 40.7783790991192)   19 4 19 13
2148 2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767317539505 40.7717600450632)   19 4 19 13
2376 2376 -73.9594204646985 40.7905923765213 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9594204646985 40.7905923765213)   19 4 19 13
2400 2400 -73.9768268467857 40.7714608041933 6B-PM-1017-02 06B PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9768268467857 40.7714608041933)   19 4 19 13
2414 2414 -73.9708175461804 40.7759228565501 13E-AM-1017-10 13E AM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9708175461804 40.7759228565501)   19 4 19 13
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767590273554 40.7717561807266)   19 4 19 13
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.95744422055 40.7961046528557)   19 4 19 13
2643 2643 -73.9693719015914 40.7768710160557 14E-PM-1017-02 14E PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true staring false false false false false false false false   POINT (-73.9693719015914 40.7768710160557)   19 4 19 13
2656 2656 -73.972399596842 40.7788765078432 15B-PM-1017-04 15B PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE on hill false false false false true   false false false false false false false false   POINT (-73.972399596842 40.7788765078432)   19 4 19 13
2658 2658 -73.9690212174 40.7834099404107 21B-PM-1017-05 21B PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9690212174 40.7834099404107)   19 4 19 13
2697 2697 -73.9710674928906 40.7778757544025 15D-PM-1017-06 15D PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false walking false false false false false false false false stopped and watched me before slowly moving on POINT (-73.9710674928906 40.7778757544025)   19 4 19 13
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false false paused to look at me POINT (-73.9692660977515 40.7830532310766)   19 4 19 13
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9705409446299 40.7764608087703)   19 4 19 13
2867 2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.969370141813 40.7840721191988)   19 4 19 13
2932 2932 -73.9705837974358 40.7758494849673 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock false false false false true   false false false false false true false false   POINT (-73.97058379743581 40.7758494849673)   19 4 19 13
2964 2964 -73.9703604542938 40.7762690223294 13E-AM-1017-04 13E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9703604542938 40.7762690223294)   19 4 19 13
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9643538221947 40.7917565604735)   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 85.474ms