squirrels

68 rows where Date = 10182018, Indifferent = "false" and Runs from = "false" sorted by Tail twitches descending

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, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Other Interactions

Runs from

  • false · 68

Indifferent

  • false · 68

Date

  • 10182018 · 68

Community Districts

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
1111 -73.9632799339872 40.7808316436308 21H-PM-1018-01 21H PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false false true true false false   POINT (-73.9632799339872 40.7808316436308)   19 4 19 13
1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9624052832372 40.7809656348254)   19 4 19 13
1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   19 4 19 13
2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2156 -73.9650387848001 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9650387848001 40.7814134438394)   19 4 19 13
2884 -73.9598378495787 40.7956843021662 37B-AM-1018-04 37B AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9598378495787 40.7956843021662)   19 4 19 13
5 -73.9593126695714 40.797533370163 39B-AM-1018-01 39B AM 10182018 1       +   Above Ground     false false false false false unknown true false false false false false false false   POINT (-73.9593126695714 40.797533370163)   19 4 19 13
39 -73.9716147061553 40.7813911036179 18A-PM-1018-01 18A PM 10182018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9716147061553 40.7813911036179)   19 4 19 13
113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   true false false false false flying false false false false false false false false   POINT (-73.9700100617602 40.7815739959357)   19 4 19 13
119 -73.9592038887673 40.796382675378 38B-PM-1018-02 38B PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true burying nut false false false false false false false false   POINT (-73.9592038887673 40.796382675378)   19 4 19 13
120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true begging false false false false false false false false   POINT (-73.9511118711108 40.7950813345902)   19 4 19 13
138 -73.9721442939797 40.7700750802317 7G-PM-1018-03 07G PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9721442939797 40.7700750802317)   19 4 19 13
148 -73.9532620128307 40.7952475548048 39G-AM-1018-01 39G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false dead (something ran over it) false false false false false false false false   POINT (-73.9532620128307 40.7952475548048)   19 4 19 13
180 -73.9690828325179 40.7818038172275 19C-PM-1018-04 19C PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9690828325179 40.7818038172275)   19 4 19 13
202 -73.9718729101676 40.7703692621371 7G-PM-1018-05 07G PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9718729101676 40.7703692621371)   19 4 19 13
266 -73.9786481009499 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786481009499 40.7697372811949)   19 4 19 13
296 -73.9596964641652 40.7957753591585 37B-AM-1018-03 37B AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9596964641652 40.7957753591585)   19 4 19 13
320 -73.9684376038582 40.7824275067237 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9684376038582 40.7824275067237)   19 4 19 13
334 -73.9687395228846 40.7807364481385 18D-AM-1018-02 18D AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9687395228846 40.7807364481385)   19 4 19 13
442 -73.9502466289084 40.7959228779883 41I-AM-1018-02 41I AM 10182018 2 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false runs off POINT (-73.9502466289084 40.7959228779883)   19 4 19 13
551 -73.9643825381614 40.7815445841195 21F-PM-1018-03 21F PM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9643825381614 40.7815445841195)   19 4 19 13
579 -73.9786714207307 40.7696870806229 4B-PM-1018-01 04B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786714207307 40.7696870806229)   19 4 19 13
631 -73.9548877830136 40.7950157489103 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.95488778301362 40.7950157489103)   19 4 19 13
691 -73.9695964983454 40.7802302192799 18C-PM-1018-08 18C PM 10182018 8 Juvenile Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9695964983454 40.7802302192799)   19 4 19 13
751 -73.9683479943823 40.7815827298303 20C-PM-1018-01 20C PM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9683479943823 40.7815827298303)   19 4 19 13
771 -73.9648626810032 40.7804506112843 20G-AM-1018-02 20G AM 10182018 2 Adult Gray   Gray+   Above Ground 5 Ran up tree true false true false false   true false false false false false false false   POINT (-73.9648626810032 40.7804506112843)   19 4 19 13
782 -73.9710559113762 40.7794279914209 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   false false true false false   false false false false false false false false disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)   19 4 19 13
870 -73.9718720403657 40.7702335056337 7G-PM-1018-04 07G PM 10182018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9718720403657 40.7702335056337)   19 4 19 13
882 -73.9786805884996 40.7697559231927 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786805884996 40.7697559231927)   19 4 19 13
970 -73.97035767623 40.7714036487747 9H-PM-1018-09 09H PM 10182018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.97035767623 40.7714036487747)   19 4 19 13
995 -73.9698843507358 40.7803754187581 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9698843507358 40.7803754187581)   19 4 19 13
1013 -73.969553896295 40.7709884929277 9H-PM-1018-04 09H PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969553896295 40.7709884929277)   19 4 19 13
1042 -73.9593374341938 40.797258337802 38B-PM-1018-01 38B PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9593374341938 40.797258337802)   19 4 19 13
1087 -73.9679955831115 40.7818431607916 20C-PM-1018-04 20C PM 10182018 4 Adult Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9679955831115 40.7818431607916)   19 4 19 13
1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false true false true false false approaches (very close) POINT (-73.9682067129876 40.7779911208015)   19 4 19 13
1234 -73.9701412231078 40.7714534088899 9H-PM-1018-08 09H PM 10182018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9701412231078 40.7714534088899)   19 4 19 13
1240 -73.9696119179789 40.7802926111865 18C-PM-1018-09 18C PM 10182018 9 Juvenile Gray   Gray+   Above Ground 5   false false true true true   false false false false false false false false   POINT (-73.9696119179789 40.7802926111865)   19 4 19 13
1304 -73.9533319519277 40.7933647909449 37H-AM-1018-02 37H AM 10182018 2 Adult Gray   Gray+   Above Ground   Large tree by (fence of the conservatory) about to climb up false false true false false   false false false false false false false false busy,ready to climb POINT (-73.9533319519277 40.7933647909449)   19 4 19 13
1339 -73.9686413326172 40.7817423907284 19C-PM-1018-08 19C PM 10182018 8 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 false false   POINT (-73.9686413326172 40.7817423907284)   19 4 19 13
1415 -73.9678561384348 40.7782877397822 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false false   false false false true false false false false gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
1420 -73.9647605121306 40.7803961531517 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree true false false false false   true false false false false false false false   POINT (-73.9647605121306 40.7803961531517)   19 4 19 13
1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   19 4 19 13
1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false false false false   POINT (-73.9632265832593 40.78169144754611)   19 4 19 13
1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9681874036914 40.7817948690964)   19 4 19 13
1655 -73.969570012716 40.7816501516863 19B-PM-1018-04 19B PM 10182018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969570012716 40.7816501516863)   19 4 19 13
1828 -73.9682965197661 40.7805378963883 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   false false true false true   false false false false false false false false   POINT (-73.9682965197661 40.7805378963883)   19 4 19 13
1889 -73.9679319758284 40.7821154802399 20C-PM-1018-07 20C PM 10182018 7 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9679319758284 40.7821154802399)   19 4 19 13
1957 -73.9684187207423 40.780592789876 18D-AM-1018-01 18D AM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true cleaning false false false false false false false false   POINT (-73.9684187207423 40.780592789876)   19 4 19 13
1958 -73.9693120090055 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.9693120090055 40.771096102012)   19 4 19 13
1970 -73.9631464693769 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree false false false false false hanging out,watching world false false false false false false false false watching POINT (-73.9631464693769 40.793415656751)   19 4 19 13
2049 -73.9692650850957 40.7713793846002 9H-PM-1018-03 09H PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9692650850957 40.7713793846002)   19 4 19 13
2082 -73.9696802053043 40.7816057406125 19B-PM-1018-03 19B PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9696802053043 40.7816057406125)   19 4 19 13
2130 -73.9695572903383 40.780822981713 18C-AM-1018-01 18C AM 10182018 1 Adult Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9695572903383 40.780822981713)   19 4 19 13
2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9678923667678 40.781967562623606)   19 4 19 13
2188 -73.9676113345824 40.7803482448467 19E-PM-1018-03 19E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE Baseball field #3 false false false true false   false false false false false false false false   POINT (-73.9676113345824 40.7803482448467)   19 4 19 13
2301 -73.968906907671 40.7816278267843 19C-PM-1018-07 19C PM 10182018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false true false false   false false false false false false false false   POINT (-73.968906907671 40.7816278267843)   19 4 19 13
2313 -73.9646174034945 40.7781287528262 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other true true false false false playing? false false false false false false false false   POINT (-73.9646174034945 40.7781287528262)   19 4 19 13
2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2444 -73.966590487009 40.7802469052891 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false true false false false false   POINT (-73.96659048700901 40.7802469052891)   19 4 19 13
2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692849074642 40.7708755098145)   19 4 19 13
2681 -73.968807163616 40.7812018159499 19C-PM-1018-02 19C PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.968807163616 40.7812018159499)   19 4 19 13
2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9690174442945 40.7817617696508)   19 4 19 13
2756 -73.9787312025627 40.7701071405918 4B-PM-1018-04 04B PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9787312025627 40.7701071405918)   19 4 19 13
2765 -73.971525123573 40.7703685359842 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true grooming false false false false false false false false   POINT (-73.971525123573 40.7703685359842)   19 4 19 13
2772 -73.9677368646039 40.7821550964837 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.96773686460392 40.782155096483706)   19 4 19 13
2853 -73.9678613185071 40.7822170887526 20C-PM-1018-03 20C PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9678613185071 40.7822170887526)   19 4 19 13
2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692563597762 40.770904999952)   19 4 19 13
2937 -73.9683460607021 40.7805408447877 18D-AM-1018-03 18D AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9683460607021 40.7805408447877)   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 124.285ms