squirrels

37 rows where Approaches = "true" and Hectare Squirrel Number = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Indifferent, Runs from, 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
162 162 -73.957219204335 40.7931529059779 35E-PM-1006-01 35E PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false looking/begging for food POINT (-73.957219204335 40.7931529059779)   19 4 19 13
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false true false false approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)   19 4 19 13
340 340 -73.9744960829844 40.7652585501959 1H-AM-1012-01 01H AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false true first approaches then runs from - he was less than 1 yd. away from me. POINT (-73.9744960829844 40.7652585501959)   19 4 19 13
382 382 -73.9735946835545 40.7724155751282 8E-PM-1008-01 08E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE by tree trunk base false false false true false   false false false false false true false false eating food being thrown at it by a mom & baby POINT (-73.9735946835545 40.7724155751282)   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
478 478 -73.954482814186 40.7987031768001 42D-PM-1013-01 42D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Drawing included. Ground Plane FALSE   false false false false true watching passers-by false false false false false true true false   POINT (-73.954482814186 40.7987031768001)   19 4 19 13
579 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
913 913 -73.9514111329059 40.7975085872897 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false true   POINT (-73.9514111329059 40.797508587289705)   19 4 19 13
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   false false true false false   false false false false false true false false started climbing down to me POINT (-73.9676514056678 40.7730853732876)   19 4 19 13
982 982 -73.9676424599715 40.7777766106807 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence false false false false true   false false false false true true false false   POINT (-73.9676424599715 40.7777766106807)   19 4 19 13
1111 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
1138 1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar false false false true false   false false false true true true false false   POINT (-73.9594357049738 40.7840678890949)   19 4 19 13
1205 1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true burying false false false false false true false false   POINT (-73.9611118778753 40.7952007875354)   19 4 19 13
1214 1214 -73.9699517492486 40.7753169595373 13F-PM-1008-01 13F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9699517492486 40.7753169595373)   19 4 19 13
1215 1215 -73.9728895595977 40.7699378332299 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false true false false   POINT (-73.9728895595977 40.7699378332299)   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
1521 1521 -73.9723922904119 40.7729164833027 9E-AM-1008-01 09E AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9723922904119 40.7729164833027)   19 4 19 13
1650 1650 -73.9762494239719 40.7750175306716 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields false false false true false eating (a peanut) false false false false false true false false   POINT (-73.9762494239719 40.7750175306716)   19 4 19 13
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true false true   false false false false false true false false   POINT (-73.9790889008147 40.7676402781925)   19 4 19 13
2005 2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   19 4 19 13
2019 2019 -73.9566705412766 40.7935560645735 36F-PM-1012-01 36F PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Near rock false false false false true   false false false false false true false false   POINT (-73.9566705412766 40.7935560645735)   19 4 19 13
2030 2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9749251267433 40.7679111971294)   19 4 19 13
2044 2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   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
2161 2161 -73.9715375915057 40.7751212088827 12D-AM-1013-01 12D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9715375915057 40.7751212088827)   19 4 19 13
2275 2275 -73.9614218413356 40.7938945058793 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping false false false false true true false false   POINT (-73.9614218413356 40.7938945058793)   19 4 19 13
2312 2312 -73.9765867029226 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9765867029226 40.7674304266107)   19 4 19 13
2333 2333 -73.9771924901559 40.7666722729471 1E-PM-1007-01 01E PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false people feeding squirrel POINT (-73.9771924901559 40.7666722729471)   19 4 19 13
2536 2536 -73.9685087288072 40.7779068128051 16E-AM-1014-01 16E AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false burying food false false false false false true false false   POINT (-73.9685087288072 40.7779068128051)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   19 4 19 13
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench false false false true false   false false false false false true false false   POINT (-73.9700264128414 40.7692014637698)   19 4 19 13
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false true false false   POINT (-73.9531953594918 40.7960413520131)   19 4 19 13
2922 2922 -73.9703421391442 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9703421391442 40.7773706575356)   19 4 19 13
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   false false true false false   false false false false false true false false   POINT (-73.9672063784809 40.7826070395665)   19 4 19 13
2998 2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
3023 3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   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 106.287ms