squirrels

67 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 5, Police Precincts = 13, Primary Fur Color = "Gray" and Runs from = "false" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions

Police Precincts ✖

Hectare Squirrel Number ✖

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
49 49 -73.9602222116708 40.793779699421 35C-AM-1007-05 35C AM 10072018 5 Adult Gray   Gray+   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9602222116708 40.793779699421)   19 4 19 13
59 59 -73.9684910712272 40.7768811640021 15F-PM-1010-05 15F PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9684910712272 40.7768811640021)   19 4 19 13
66 66 -73.9749243901189 40.7761393551781 11B-PM-1014-05 11B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9749243901189 40.7761393551781)   19 4 19 13
202 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
208 208 -73.9677646187171 40.7746492806333 13H-PM-1010-05 13H PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9677646187171 40.7746492806333)   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
370 370 -73.9548957862084 40.7944844464619 37G-AM-1014-05 37G AM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9548957862084 40.7944844464619)   19 4 19 13
456 456 -73.9547878025303 40.7899151873467 33I-PM-1006-05 33I PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9547878025303 40.7899151873467)   19 4 19 13
500 500 -73.9568305513017 40.7974086631267 40C-PM-1006-05 40C PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9568305513017 40.7974086631267)   19 4 19 13
578 578 -73.9671306431211 40.7838870159057 22C-PM-1006-05 22C PM 10062018 5 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9671306431211 40.783887015905705)   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
672 672 -73.9588708103486 40.7905794078843 32F-PM-1008-05 32F PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9588708103486 40.7905794078843)   19 4 19 13
676 676 -73.9710207438538 40.7682187144432 5I-AM-1010-05 05I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9710207438538 40.7682187144432)   19 4 19 13
975 975 -73.956869086031 40.7988858771114 41C-AM-1017-05 41C AM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.956869086031 40.7988858771114)   19 4 19 13
977 977 -73.9764601882854 40.766070446642 1F-AM-1010-05 01F AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9764601882854 40.766070446642)   19 4 19 13
983 983 -73.9641552070803 40.7908479527923 30B-AM-1007-05 30B AM 10072018 5 Adult Gray   Gray+   Above Ground 10   true false false false false   false false false false false false false false   POINT (-73.9641552070803 40.7908479527923)   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
1288 1288 -73.9730454295997 40.7702909454392 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730454295997 40.7702909454392)   19 4 19 13
1428 1428 -73.9666113598566 40.7752662550312 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)   19 4 19 13
1446 1446 -73.9775238847836 40.7675792683587 2D-AM-1007-05 02D AM 10072018 5 Adult Gray   Gray+   Above Ground 100   true false false false false   false false false false false false false false   POINT (-73.9775238847836 40.7675792683587)   19 4 19 13
1496 1496 -73.9615500510038 40.7920799263699 32C-PM-1013-05 32C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9615500510038 40.7920799263699)   19 4 19 13
1568 1568 -73.9681079869821 40.7723494081345 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681079869821 40.7723494081345)   19 4 19 13
1574 1574 -73.9561840935803 40.7992037821497 42C-PM-1013-05 42C PM 10132018 5 Adult Gray   Gray+   Above Ground 20   false false false true false   true false false false false false true false   POINT (-73.9561840935803 40.7992037821497)   19 4 19 13
1606 1606 -73.9628932797886 40.7923116396365 32B-PM-1010-05 32B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9628932797886 40.7923116396365)   19 4 19 13
1624 1624 -73.9737060043988 40.7725660224983 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9737060043988 40.7725660224983)   19 4 19 13
1637 1637 -73.9699513151755 40.7722062991044 10G-PM-1017-05 10G PM 10172018 5 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9699513151755 40.7722062991044)   19 4 19 13
1682 1682 -73.9759258407288 40.7667622711142 2F-PM-1014-05 02F PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9759258407288 40.7667622711142)   19 4 19 13
1692 1692 -73.973268329435 40.7708296517073 7E-AM-1006-05 07E AM 10062018 5 Adult Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false false false false false   POINT (-73.973268329435 40.7708296517073)   19 4 19 13
1711 1711 -73.975836799137 40.7691593428471 4E-PM-1008-05 04E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.975836799137 40.769159342847104)   19 4 19 13
1839 1839 -73.9655925527354 40.7760049171097 15H-PM-1008-05 15H PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE lawn false false false false true   false false false false false false true false   POINT (-73.9655925527354 40.7760049171097)   19 4 19 13
1854 1854 -73.9618076359384 40.7947808718203 35A-PM-1013-05 35A PM 10132018 5 Adult Gray   Gray+   Above Ground 3 in tree false false true false false   false false false false false false false false   POINT (-73.9618076359384 40.7947808718203)   19 4 19 13
1856 1856 -73.9782940231149 40.7694236097224 4B-PM-1018-05 04B PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9782940231149 40.7694236097224)   19 4 19 13
1883 1883 -73.9568108465086 40.7971727026108 39D-AM-1008-05 39D AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.95681084650862 40.7971727026108)   19 4 19 13
1888 1888 -73.9673919075839 40.7786845769177 17F-PM-1020-05 17F PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9673919075839 40.7786845769177)   19 4 19 13
1940 1940 -73.9696445614055 40.7791486203627 17D-AM-1008-05 17D AM 10082018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9696445614055 40.7791486203627)   19 4 19 13
1944 1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
1994 1994 -73.9598463837775 40.7834524724254 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9598463837775 40.7834524724254)   19 4 19 13
2032 2032 -73.9590157104896 40.7956884493421 37C-PM-1013-05 37C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590157104896 40.7956884493421)   19 4 19 13
2053 2053 -73.9711810222421 40.7773445611969 14D-PM-1019-05 14D PM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9711810222421 40.7773445611969)   19 4 19 13
2064 2064 -73.970260899173 40.783651724865 21A-AM-1019-05 21A AM 10192018 5 Adult Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.970260899173 40.783651724865)   19 4 19 13
2131 2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9752225195115 40.7703747669865)   19 4 19 13
2167 2167 -73.9799594281222 40.7701978146968 4A-AM-1007-05 04A AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9799594281222 40.7701978146968)   19 4 19 13
2170 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
2202 2202 -73.9556039997621 40.7977549157287 40D-AM-1013-05 40D AM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9556039997621 40.7977549157287)   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
2581 2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9635981227569 40.7928169540326)   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
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.957775998085 40.7932880937406)   19 4 19 13
2777 2777 -73.9810843611086 40.7687905493699 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree true false false false false   false false false false false false false false   POINT (-73.9810843611086 40.7687905493699)   19 4 19 13
2859 2859 -73.9786940945874 40.7690820276888 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock false false true true false   false false false false false false true false   POINT (-73.9786940945874 40.7690820276888)   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
2907 2907 -73.9685201626934 40.783329261225 21B-AM-1019-05 21B AM 10192018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9685201626934 40.783329261225)   19 4 19 13
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     false true false false false   false false false false false false true false   POINT (-73.9770313887741 40.772486925209904)   19 4 19 13
2930 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
2962 2962 -73.9722530826293 40.7667138028361 3I-AM-1010-05 03I AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9722530826293 40.7667138028361)   19 4 19 13
2970 2970 -73.9619019299709 40.7924476439693 33B-PM-1010-05 33B PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9619019299709 40.7924476439693)   19 4 19 13
1487 1487 -73.965394655961 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true burying the food on ground false false false false false false false false look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)   19 4 19 13
2990 2990 -73.9766012108307 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #4 false false false false false false true false   POINT (-73.9766012108307 40.7712310725379)   19 4 19 13
471 471 -73.9707215394887 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#6) true false false false false false false false   POINT (-73.9707215394887 40.7727508149058)   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
34 34 -73.9704402681017 40.7798965621203 17C-PM-1013-05 17C PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false eating (ate upside down on a tree — #jealous) false false false false false false true false   POINT (-73.9704402681017 40.77989656212031)   19 4 19 13
276 276 -73.9758579666874 40.7679326548845 3E-PM-1008-05 03E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false jump false false false false false false true false   POINT (-73.9758579666874 40.7679326548845)   19 4 19 13
203 203 -73.9638774579549 40.7913532129148 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true jumping false false false true true false true false eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)   19 4 19 13
139 139 -73.969847380865 40.7769884612305 14E-AM-1008-05 14E AM 10082018 5 Adult Gray   Gray+   Above Ground 25   false false true false false nest building false false false false false false true false   POINT (-73.969847380865 40.7769884612305)   19 4 19 13
306 306 -73.9689700100267 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   false false false false false sitting false true false false false false false false   POINT (-73.9689700100267 40.7775169562765)   19 4 19 13
2552 2552 -73.9724947710698 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch false false true false false sitting false false false false false false true false   POINT (-73.9724947710698 40.7696619340886)   19 4 19 13
185 185 -73.9588468413094 40.7963852299012 38B-AM-1019-05 38B AM 10192018 5 Adult Gray   Gray+   Above Ground 28   false false true false false sitting still false true false false false false false false   POINT (-73.9588468413094 40.7963852299012)   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 79.982ms