squirrels

79 rows where Indifferent = "false", Location = "Ground Plane", Runs from = "false" and Tail twitches = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Approaches, 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
15 15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false true true false false false   POINT (-73.9674285955293 40.7829723919744)   19 4 19 13
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
58 58 -73.9704082821356 40.7690280985956 6I-PM-1013-06 06I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false playing with #5 false false false false true false false false   POINT (-73.9704082821356 40.7690280985956)   19 4 19 13
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
128 128 -73.9746229094643 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false false false avoided people POINT (-73.9746229094643 40.7748467061969)   19 4 19 13
136 136 -73.9528682507794 40.7925807808307 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
157 157 -73.9637946878735 40.7915700446878 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9637946878735 40.7915700446878)   19 4 19 13
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false false false   POINT (-73.958535640774 40.7982737896998)   19 4 19 13
176 176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false true true false false   POINT (-73.9618064639153 40.792158440043)   19 4 19 13
278 278 -73.9787796921165 40.7707526535381 5A-PM-1010-01 05A PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9787796921165 40.7707526535381)   19 4 19 13
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false false moseying false false false false true true false false   POINT (-73.957342596188 40.7944359654227)   19 4 19 13
310 310 -73.9795081274695 40.7691431548544 3B-PM-1007-03 03B PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9795081274695 40.7691431548544)   19 4 19 13
314 314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.960601067176 40.7917243850136)   19 4 19 13
361 361 -73.9614824437251 40.7912929799884 32C-PM-1013-03 32C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9614824437251 40.7912929799884)   19 4 19 13
419 419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9777328709928 40.7669087724668)   19 4 19 13
431 431 -73.9757436019432 40.7746064363227 10B-PM-1014-01 10B PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE on lawn in front of a tree false false false false true   false false false false true false false false stay on ground but went to other side of tree to hide from a dog POINT (-73.9757436019432 40.7746064363227)   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
461 461 -73.9648195433192 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false true true false staring false false false false true false false false   POINT (-73.9648195433192 40.7796399955868)   19 4 19 13
482 482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
589 589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false true false false false curious POINT (-73.97826438139 40.7717086090782)   19 4 19 13
682 682 -73.9651828383592 40.7802820943863 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true true false false   POINT (-73.9651828383592 40.7802820943863)   19 4 19 13
740 740 -73.9583477850634 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true true   true false false false true false false false   POINT (-73.9583477850634 40.7914073632782)   19 4 19 13
868 868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9738481771673 40.7706540698938)   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
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
1000 1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   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
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9594406225891 40.7918533707789)   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
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
1160 1160 -73.9777256989362 40.766623699564 1E-AM-1006-03 01E AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9777256989362 40.766623699564)   19 4 19 13
1202 1202 -73.9694979297007 40.7694667408721 7I-PM-1013-02 07I PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE Construction materials true false false false false   false false false false true false false false   POINT (-73.9694979297007 40.7694667408721)   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
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)   19 4 19 13
1296 1296 -73.9705509170542 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass false false false true false   false false false false true false false false   POINT (-73.9705509170542 40.7689416540228)   19 4 19 13
1352 1352 -73.9616770335086 40.7921648631096 32C-PM-1013-13 32C PM 10132018 13 Adult Gray   Gray+   Ground Plane FALSE   false false false false true buried nut false false false false true false false false   POINT (-73.9616770335086 40.7921648631096)   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
1549 1549 -73.9777978497894 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false true false true   false false false false true false false false   POINT (-73.9777978497894 40.7668620784309)   19 4 19 13
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence false false false false true   false false false false true false false false   POINT (-73.9676539688726 40.7777229934129)   19 4 19 13
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false false false couldn't get near POINT (-73.9806718258385 40.76927768969951)   19 4 19 13
1704 1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9624052832372 40.7809656348254)   19 4 19 13
1725 1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   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
1797 1797 -73.9697178096275 40.7697036696301 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree false true false false false playing,interacting with #6 false false false false true false false false   POINT (-73.9697178096275 40.769703669630104)   19 4 19 13
1808 1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true true true false false   POINT (-73.9698870647042 40.7826510985538)   19 4 19 13
1872 1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9613998967903 40.7912437235667)   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
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2066 2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 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 true true   false false false false true false false false   POINT (-73.9784610031588 40.7668839966177)   19 4 19 13
2088 2088 -73.9651155880346 40.790694632578 30A-PM-1020-01 30A PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9651155880346 40.790694632578)   19 4 19 13
2124 2124 -73.9730039581521 40.7730688398468 9E-PM-1014-03 09E PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE underneath a tree false false false true true   false false false false true false false false   POINT (-73.9730039581521 40.7730688398468)   19 4 19 13
2133 2133 -73.9736164871197 40.7725695048569 8D-PM-1007-04 08D PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9736164871197 40.7725695048569)   19 4 19 13
2147 2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9651217998407 40.7761115392738)   19 4 19 13
2156 2156 -73.9650387848001 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9650387848001 40.7814134438394)   19 4 19 13
2159 2159 -73.9696688162449 40.7741422177187 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9696688162449 40.7741422177187)   19 4 19 13
2216 2216 -73.9735195018446 40.7787147279715 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false true false false false   POINT (-73.9735195018446 40.7787147279715)   19 4 19 13
2273 2273 -73.9671534029191 40.7810849804467 20D-AM-1007-02 20D AM 10072018 2 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   false false false false true quieter false false false false true false false false   POINT (-73.9671534029191 40.7810849804467)   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
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9691692160865 40.7725330502929)   19 4 19 13
2343 2343 -73.9719194877439 40.7748000962909 11D-AM-1010-04 11D AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9719194877439 40.7748000962909)   19 4 19 13
2344 2344 -73.9786310308892 40.7669349368183 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9786310308892 40.7669349368183)   19 4 19 13
2358 2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true cleaning face & tail false false false false true true false false   POINT (-73.9788379085607 40.7683896583055)   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
2511 2511 -73.9584561537421 40.7911211164754 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false true false false false   POINT (-73.9584561537421 40.7911211164754)   19 4 19 13
2529 2529 -73.9800271487863 40.7702554167042 4A-PM-1007-06 04A PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE A rock false false false false true   false false false false true false false false   POINT (-73.9800271487863 40.7702554167042)   19 4 19 13
2532 2532 -73.9695150319891 40.782613519363 20B-PM-1013-04 20B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true chased a bird carrying massive wad of grass false false false false true false false false   POINT (-73.9695150319891 40.782613519363)   19 4 19 13
2587 2587 -73.9789971286844 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9789971286844 40.7707024146365)   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
2655 2655 -73.9659156108069 40.7810709818696 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9659156108069 40.7810709818696)   19 4 19 13
2723 2723 -73.960642602756 40.7917265419842 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false false stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)   19 4 19 13
2766 2766 -73.9551639847466 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree false false false true false   false false false false true false false false   POINT (-73.9551639847466 40.790858199891)   19 4 19 13
2878 2878 -73.969720780557 40.7741105688757 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false false true false false false   POINT (-73.969720780557 40.7741105688757)   19 4 19 13
2883 2883 -73.9698592838836 40.7743071443959 12F-AM-1020-03 12F AM 10202018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false false playing false false false false true false false false   POINT (-73.9698592838836 40.7743071443959)   19 4 19 13
2884 2884 -73.9598378495787 40.7956843021662 37B-AM-1018-04 37B AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9598378495787 40.7956843021662)   19 4 19 13
2900 2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   19 4 19 13
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9643538221947 40.7917565604735)   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
3015 3015 -73.9759163300535 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9759163300535 40.7736180793606)   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 86.739ms