squirrels

25 rows where Eating = "false", Hectare Squirrel Number = 5 and Tail twitches = "true"

✎ 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, Chasing, Climbing, Foraging, Other Activities, Kuks, Quaas, Tail flags, Approaches, 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
36 36 -73.9662438996681 40.7890381809441 28A-PM-1007-05 28A PM 10072018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9662438996681 40.7890381809441)   19 4 19 13
360 360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   false true false false false   false false false false true false false false   POINT (-73.9672054610151 40.7876519923501)   19 4 19 13
447 447 -73.9725906016474 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9725906016474 40.7713889729739)   19 4 19 13
506 506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false true false false true   POINT (-73.9649611089685 40.7814371834837)   19 4 19 13
599 599 -73.9530263552489 40.7920949788358 36I-PM-1007-05 36I PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9530263552489 40.7920949788358)   19 4 19 13
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false true false false false   POINT (-73.9734762649298 40.7663703404546)   19 4 19 13
905 905 -73.9757216124349 40.7754310239649 11A-PM-1013-05 11A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true digging false false false false true false false false   POINT (-73.9757216124349 40.7754310239649)   19 4 19 13
1043 1043 -73.9758564394842 40.7674758942811 3E-AM-1006-05 03E AM 10062018 5 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9758564394842 40.7674758942811)   19 4 19 13
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree false false true false false   false false false true true false false false curious POINT (-73.9782120139407 40.7717154468791)   19 4 19 13
1157 1157 -73.9704449096084 40.7689970778303 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing with #6 false false false false true false false false   POINT (-73.9704449096084 40.7689970778303)   19 4 19 13
1188 1188 -73.9669529835992 40.7871864151365 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO true false true false false d.p.t. false false false true true false true false calm POINT (-73.96695298359921 40.7871864151365)   19 4 19 13
1196 1196 -73.9580111496275 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9580111496275 40.7985365971474)   19 4 19 13
1312 1312 -73.9712034320741 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9712034320741 40.7764415506669)   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
1394 1394 -73.95488263914 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree true false true false true   false false false false true false true false   POINT (-73.95488263914 40.7959474571251)   19 4 19 13
1660 1660 -73.9800499498034 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock false false false false true   false false false true true false true false   POINT (-73.9800499498034 40.770218109957305)   19 4 19 13
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true false false true   POINT (-73.9652134469963 40.7803438278765)   19 4 19 13
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   false true false false false chasing squirrel #6 true true false false true false false false   POINT (-73.978844141973 40.7696046074378)   19 4 19 13
2135 2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   false false true false true   false false false false true false true false   POINT (-73.9596251284566 40.7916254797561)   19 4 19 13
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree true false true false true   false false false false true false true false   POINT (-73.9657171357842 40.7773277532224)   19 4 19 13
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
2486 2486 -73.9766317094163 40.7734230472026 8B-AM-1007-05 08B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9766317094163 40.7734230472026)   19 4 19 13
2612 2612 -73.9711673006524 40.7747979614577 12E-PM-1018-05 12E PM 10182018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9711673006524 40.7747979614577)   19 4 19 13
2824 2824 -73.9750618008099 40.7737521167094 9B-AM-1010-05 09B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9750618008099 40.7737521167094)   19 4 19 13
2875 2875 -73.9546616782922 40.790974533739 34I-PM-1010-05 34I PM 10102018 5 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9546616782922 40.790974533739)   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 78.838ms