squirrels

171 rows where Combination of Primary and Highlight Color = "Gray+" and Eating = "true" sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Climbing ✖

Eating ✖

  • true · 71 ✖

Combination of Primary and Highlight Color ✖

  • Gray+ · 71 ✖
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
1399 1399 -73.970442878377 40.7763755560359 14E-AM-1008-22 14E AM 10082018 22 Adult Gray   Gray+   Ground Plane FALSE   false false false true true burying false false false false false false true false   POINT (-73.970442878377 40.7763755560359)   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
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   true false true true false got fed twice by grandpa,grabbed from grass and ate in tree false false false false false true true true approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)   19 4 19 13
1550 1550 -73.9698642668906 40.7784669316504 16D-PM-1010-10 16D PM 10102018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9698642668906 40.7784669316504)   19 4 19 13
1632 1632 -73.9592392692535 40.7961869951798 37B-AM-1018-02 37B AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9592392692535 40.7961869951798)   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
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9795585338537 40.768895893226)   19 4 19 13
1674 1674 -73.9589698681439 40.7906520520417 32E-PM-1017-06 32E PM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9589698681439 40.7906520520417)   19 4 19 13
1690 1690 -73.96052295327 40.7934359372871 34C-PM-1012-04 34C PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.96052295327 40.7934359372871)   19 4 19 13
1732 1732 -73.9767141407274 40.7737313251559 8A-PM-1014-02 08A PM 10142018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true runs from (goes up a tree) POINT (-73.9767141407274 40.7737313251559)   19 4 19 13
1742 1742 -73.9701023478746 40.7803527061859 17C-PM-1013-04 17C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9701023478746 40.7803527061859)   19 4 19 13
1743 1743 -73.9635412640983 40.7902529354639 30B-AM-1007-11 30B AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9635412640983 40.7902529354639)   19 4 19 13
1766 1766 -73.972757765574 40.7654285510067 2I-AM-1006-01 02I AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.972757765574 40.7654285510067)   19 4 19 13
1771 1771 -73.9750688083336 40.7665584681025 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750688083336 40.7665584681025)   19 4 19 13
1774 1774 -73.9668909481942 40.7841298584027 22C-PM-1006-12 22C PM 10062018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   true false false false false false false false human friendly POINT (-73.9668909481942 40.7841298584027)   19 4 19 13
1789 1789 -73.9596271142953 40.7906612313673 32E-PM-1017-12 32E PM 10172018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false true false false false false false false   POINT (-73.9596271142953 40.7906612313673)   19 4 19 13
1795 1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false true true false false false look at humans determining POINT (-73.968004352343 40.7726669278308)   19 4 19 13
1812 1812 -73.9590074024938 40.7907059424675 32E-PM-1017-05 32E PM 10172018 5 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9590074024938 40.7907059424675)   19 4 19 13
1829 1829 -73.9746965894947 40.7664351724309 2G-AM-1010-03 02G AM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9746965894947 40.7664351724309)   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
1881 1881 -73.9674984567017 40.7745938268705 13H-PM-1010-04 13H PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9674984567017 40.7745938268705)   19 4 19 13
1902 1902 -73.9703314162405 40.778584776139 16D-PM-1010-12 16D PM 10102018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9703314162405 40.778584776139)   19 4 19 13
1934 1934 -73.969756965598 40.7786455091699 16D-PM-1010-02 16D PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.969756965598 40.7786455091699)   19 4 19 13
1936 1936 -73.9667911565238 40.779321901098 18F-AM-1014-02 18F AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE In small tree by water false false false true true   false true false false false false true false   POINT (-73.9667911565238 40.77932190109801)   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
1946 1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9692925815903 40.7774506065008)   19 4 19 13
1971 1971 -73.9591880400132 40.7950071252836 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   true true false false true false true false   POINT (-73.95918804001322 40.7950071252836)   19 4 19 13
2073 2073 -73.9661108248377 40.7891945123815 28A-AM-1014-01 28A AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9661108248377 40.7891945123815)   19 4 19 13
2083 2083 -73.9702382274798 40.7721754848905 10G-PM-1017-03 10G PM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9702382274798 40.7721754848905)   19 4 19 13
2100 2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9638312025305 40.7903826659569)   19 4 19 13
2118 2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2139 2139 -73.9697471123497 40.7773163388327 15E-PM-1008-10 15E PM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9697471123497 40.777316338832705)   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
2188 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
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
2203 2203 -73.9710531485298 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.97105314852982 40.777375706944504)   19 4 19 13
2219 2219 -73.9709242364673 40.7684217215595 5I-AM-1010-04 05I AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9709242364673 40.7684217215595)   19 4 19 13
2263 2263 -73.9569375355884 40.7935398008612 36E-AM-1013-02 36E AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9569375355884 40.7935398008612)   19 4 19 13
2269 2269 -73.9695518341907 40.7762145993937 14E-AM-1008-15 14E AM 10082018 15 Adult Gray   Gray+   Ground Plane FALSE   false false false true true walking false false false false false false true false   POINT (-73.9695518341907 40.7762145993937)   19 4 19 13
2338 2338 -73.9716621112698 40.7742862219469 11E-AM-1013-01 11E AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9716621112698 40.7742862219469)   19 4 19 13
2339 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
2345 2345 -73.965738547469 40.7886962740167 27B-PM-1006-01 27B PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE By large tree false false false true true   false false false false false false false true   POINT (-73.965738547469 40.7886962740167)   19 4 19 13
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false following #1 false false false false true false false false   POINT (-73.9573119777312 40.7875347862766)   19 4 19 13
2376 2376 -73.9594204646985 40.7905923765213 32E-PM-1017-11 32E PM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9594204646985 40.7905923765213)   19 4 19 13
2383 2383 -73.9686551213305 40.7728617837174 11H-PM-1013-04 11H PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true true false   POINT (-73.9686551213305 40.7728617837174)   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
2470 2470 -73.96388775887 40.7915477304252 31A-AM-1010-02 31A AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true true scratching false false false false false false true false   POINT (-73.96388775887 40.7915477304252)   19 4 19 13
2475 2475 -73.9736489041867 40.7712143385426 7E-AM-1006-04 07E AM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE under a tree false false false true false   false false false false false false false false   POINT (-73.9736489041867 40.7712143385426)   19 4 19 13
2533 2533 -73.9766195697096 40.7661907261547 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9766195697096 40.7661907261547)   19 4 19 13
2566 2566 -73.9744226682925 40.7755625717273 11B-AM-1007-04 11B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9744226682925 40.7755625717273)   19 4 19 13
2578 2578 -73.9765386965371 40.766371971273 1F-AM-1010-02 01F AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9765386965371 40.766371971273)   19 4 19 13
2593 2593 -73.9590191812452 40.7906166981409 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area false false false true true   false false false false false false false true   POINT (-73.9590191812452 40.7906166981409)   19 4 19 13
2614 2614 -73.9765877920583 40.7660946071574 1F-AM-1010-04 01F AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9765877920583 40.7660946071574)   19 4 19 13
2625 2625 -73.9699188544459 40.7772180370053 15E-PM-1008-09 15E PM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9699188544459 40.7772180370053)   19 4 19 13
2641 2641 -73.9615516703494 40.7905219388359 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground true false false true true   false false false false true false true false   POINT (-73.9615516703494 40.7905219388359)   19 4 19 13
2677 2677 -73.97348276186 40.7656171832911 2H-PM-1006-02 02H PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.97348276186 40.7656171832911)   19 4 19 13
2726 2726 -73.9734206435334 40.7657854684194 2H-PM-1006-01 02H PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9734206435334 40.7657854684194)   19 4 19 13
2736 2736 -73.9593895253501 40.7973085844087 38B-AM-1019-03 38B AM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9593895253501 40.7973085844087)   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
2756 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
2775 2775 -73.9697109398302 40.7776218260789 15E-PM-1008-06 15E PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true true burying false false false false false false true false   POINT (-73.9697109398302 40.7776218260789)   19 4 19 13
2781 2781 -73.9752673884392 40.7662642413761 2G-AM-1010-04 02G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9752673884392 40.7662642413761)   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
2921 2921 -73.9699573485164 40.7765857838015 14E-AM-1008-10 14E AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9699573485164 40.7765857838015)   19 4 19 13
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9742986032935 40.7770454318226)   19 4 19 13
2984 2984 -73.9700158929437 40.7762359066591 14E-AM-1008-18 14E AM 10082018 18 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9700158929437 40.7762359066591)   19 4 19 13
2996 2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970033345821 40.777259393859)   19 4 19 13
3006 3006 -73.9744390217386 40.7663168362582 2G-AM-1010-02 02G AM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9744390217386 40.7663168362582)   19 4 19 13
3007 3007 -73.9635140434993 40.7912807969365 31B-AM-1017-01 31B AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9635140434993 40.7912807969365)   19 4 19 13
3014 3014 -73.9665572004288 40.7804347548303 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9665572004288 40.7804347548303)   19 4 19 13
3019 3019 -73.9639431360458 40.7908677445466 30B-AM-1007-04 30B AM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9639431360458 40.7908677445466)   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 8.65ms