squirrels

26 rows where Date = 10172018 and Hectare Squirrel Number = 4 sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, 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 twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts ✖

Date ✖

  • 10172018 · 26 ✖
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
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
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false false false false true   POINT (-73.9623696148045 40.792184861375)   19 4 19 13
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false true false false true   POINT (-73.9652584749758 40.7803011124382)   19 4 19 13
805 805 -73.9706851546184 40.7780777016038 15D-PM-1017-04 15D PM 10172018 4 Adult Cinnamon   Cinnamon+   Above Ground 2 on fence true false false false false   false false false false false false true false   POINT (-73.9706851546184 40.7780777016038)   19 4 19 13
851 851 -73.9528462779437 40.7923843043685 36I-AM-1017-04 36I AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9528462779437 40.7923843043685)   19 4 19 13
1072 1072 -73.9566571713254 40.7989855775435 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9566571713254 40.7989855775435)   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
1182 1182 -73.9667206046912 40.7779993565098 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667206046912 40.7779993565098)   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
2246 2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9711607544742 40.774988247642)   19 4 19 13
2449 2449 -73.9599911537509 40.7914452542845 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   false false true false false   false false false false true false false true   POINT (-73.9599911537509 40.7914452542845)   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
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
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9532163535175 40.7982970313067)   19 4 19 13
2866 2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9744025383371 40.7777296605765)   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
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
245 245 -73.9589414339242 40.7907073888277 32E-PM-1017-04 32E PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9589414339242 40.7907073888277)   19 4 19 13
293 293 -73.9696173677837 40.7705202790525 8H-AM-1017-04 08H AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9696173677837 40.7705202790525)   19 4 19 13
618 618 -73.957976896139 40.797027128241 39C-AM-1017-04 39C AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.957976896139 40.797027128241005)   19 4 19 13
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   true false false true true   true false false false false true false true approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)   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
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
2442 2442 -73.9699369796844 40.7720350191273 10G-PM-1017-04 10G PM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9699369796844 40.7720350191273)   19 4 19 13
2983 2983 -73.9689586689061 40.7839613907139 21B-PM-1017-04 21B PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9689586689061 40.7839613907139)   19 4 19 13
2993 2993 -73.9570722262693 40.7985706143519 40C-AM-1017-04 40C AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true true chasing (#3) false false false false false false true false   POINT (-73.9570722262693 40.7985706143519)   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 100.937ms