squirrels

84 rows where Foraging = "false", Location = "Above Ground", Running = "true" and Runs from = "false" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Color notes, Above Ground Sighter Measurement, Specific Location, Climbing, Eating, Other Activities, Other Interactions

Tail twitches ✖

Police Precincts ✖

Running ✖

  • true · 84 ✖

Location ✖

  • Above Ground · 84 ✖

Foraging ✖

  • false · 84 ✖
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
222 222 -73.9770273553525 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence true true true true false playing tag together false false false false false true false false   POINT (-73.9770273553525 40.7732399463626)   19 4 19 13
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9752915601718 40.7739329570033)   19 4 19 13
369 369 -73.9596398997228 40.7933386953847 34D-PM-1007-02 34D PM 10072018 2 Adult Black   Black+   Above Ground 25   true false true false false   false false false false false false false false cautiously aware POINT (-73.9596398997228 40.7933386953847)   19 4 19 13
542 542 -73.9713487591577 40.7784353043714 15C-PM-1017-03 15C PM 10172018 3 Adult Black   Black+   Above Ground 17 running across overpass true false false false false   false false false false false false true false   POINT (-73.9713487591577 40.7784353043714)   19 4 19 13
1516 1516 -73.9625383795297 40.7883862331728 28D-AM-1012-03 28D AM 10122018 3 Adult Black   Black+   Above Ground 30   true false false false false   false false false false false false true false   POINT (-73.9625383795297 40.7883862331728)   19 4 19 13
2755 2755 -73.9712022111028 40.7672504368263 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp true false false false false   false false false false false false true false   POINT (-73.9712022111028 40.7672504368263)   19 4 19 13
1741 1741 -73.9736995552241 40.7722712518637 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree true false true false false   false false false false false false false false   POINT (-73.9736995552241 40.7722712518637)   19 4 19 13
256 256 -73.976798124308 40.7741316574113 9A-PM-1010-04 09A PM 10102018 4   Cinnamon   Cinnamon+   Above Ground 20   true false true false false   false false false false false false true false   POINT (-73.97679812430802 40.7741316574113)   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
1006 1006 -73.9686296217893 40.771812308875 10H-AM-1014-02 10H AM 10142018 2 Juvenile Cinnamon   Cinnamon+   Above Ground 6   true false false false false   false false false false false false false false   POINT (-73.9686296217893 40.771812308875)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
620 620 -73.9655905300923 40.7752614638023 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   true false true false false   false false false false true false true false   POINT (-73.9655905300923 40.7752614638023)   19 4 19 13
377 377 -73.9757001944781 40.769499790547 5E-AM-1008-09 05E AM 10082018 9 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2 went up tree true false false false false   false false false false false false true false   POINT (-73.9757001944781 40.769499790547)   19 4 19 13
525 525 -73.952526164386 40.7963759240504 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   true false true false false   false false false false false false true false   POINT (-73.952526164386 40.7963759240504)   19 4 19 13
2280 2280 -73.9767143644151 40.7684756941321 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree true false true false false   false false false false false false true false   POINT (-73.9767143644151 40.7684756941321)   19 4 19 13
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2913 2913 -73.9621297946132 40.7944058222814 34A-PM-1013-05 34A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   true false false false false   false false false false false false false false   POINT (-73.9621297946132 40.7944058222814)   19 4 19 13
1165 1165 -73.9689504114652 40.7766770153764 14F-PM-1012-05 14F PM 10122018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 2 on a fallen branch true false false true false sitting false false false false false false false false looking at me POINT (-73.9689504114652 40.7766770153764)   19 4 19 13
199 199 -73.9771614686616 40.7709677983247 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   true false true true false   false false false false false false true false   POINT (-73.9771614686616 40.7709677983247)   19 4 19 13
336 336 -73.9757413215621 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   true true true false false   false false false false false false true false   POINT (-73.9757413215621 40.7692582758978)   19 4 19 13
371 371 -73.964080104186 40.7907898627287 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   true false false false false   false false false false false false false false   POINT (-73.964080104186 40.7907898627287)   19 4 19 13
480 480 -73.9641293283734 40.7907654006019 30B-AM-1007-03 30B AM 10072018 3 Adult Gray   Gray+   Above Ground 30   true false false false false   false false false false false false false false   POINT (-73.9641293283734 40.7907654006019)   19 4 19 13
569 569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree true false true false false   false false false true false false true false   POINT (-73.9709040623777 40.7701163892686)   19 4 19 13
610 610 -73.9671549566066 40.7751342870705 14H-AM-1007-01 14H AM 10072018 1 Adult Gray   Gray+   Above Ground 180 top of tree true false false false false jumping between branches false false false false false false true false   POINT (-73.9671549566066 40.7751342870705)   19 4 19 13
757 757 -73.9783185278595 40.7724861675504 7A-AM-1006-03 07A AM 10062018 3 Adult Gray   Gray+ 3/4 length tail, hair loss Above Ground 20 in trees, then to ground true false true false false jumping false false false false false false true false   POINT (-73.9783185278595 40.7724861675504)   19 4 19 13
771 771 -73.9648626810032 40.7804506112843 20G-AM-1018-02 20G AM 10182018 2 Adult Gray   Gray+   Above Ground 5 Ran up tree true false true false false   true false false false false false false false   POINT (-73.9648626810032 40.7804506112843)   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
1046 1046 -73.9647891228606 40.789853066039 29B-AM-1007-02 29B AM 10072018 2 Adult Gray   Gray+   Above Ground 30   true false false false false   false false false true false false false false   POINT (-73.9647891228606 40.789853066039)   19 4 19 13
1065 1065 -73.9769700777377 40.7728489574967 7B-AM-1008-08 07B AM 10082018 8 Adult Gray   Gray+   Above Ground 5   true false false false false   false false false false false false true false   POINT (-73.9769700777377 40.7728489574967)   19 4 19 13
1147 1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1329 1329 -73.9772164524209 40.7688399538756 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree true false true false false   false false false false false false false false did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)   19 4 19 13
1420 1420 -73.9647605121306 40.7803961531517 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree true false false false false   true false false false false false false false   POINT (-73.9647605121306 40.7803961531517)   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
1517 1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   true false true false false   false false false false false false true false   POINT (-73.970041085185 40.783442758031306)   19 4 19 13
1575 1575 -73.9703169373939 40.7700658823854 7H-AM-1006-13 07H AM 10062018 13 Adult Gray   Gray+   Above Ground 10   true false false false false running (up tree) false false false false false false true false   POINT (-73.9703169373939 40.7700658823854)   19 4 19 13
1599 1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   true false true false false   false false false false false false false false   POINT (-73.9782603348665 40.7705790257951)   19 4 19 13
1613 1613 -73.9599202233536 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599202233536 40.7972599930224)   19 4 19 13
1684 1684 -73.9637824756607 40.7904737110761 30B-AM-1007-08 30B AM 10072018 8 Adult Gray   Gray+   Above Ground 40   true false false true false   false false false false false false false false   POINT (-73.9637824756607 40.7904737110761)   19 4 19 13
1715 1715 -73.9745709109056 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   true false true false false in tree false false false false false false true false   POINT (-73.9745709109056 40.7672225695415)   19 4 19 13
1823 1823 -73.9612854506075 40.7920830673571 32C-PM-1013-04 32C PM 10132018 4 Juvenile Gray   Gray+   Above Ground     true false true false false   false false false false false false false false   POINT (-73.9612854506075 40.7920830673571)   19 4 19 13
1867 1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree true false false false false   false false false false true false false false   POINT (-73.9745204169071 40.7736282868469)   19 4 19 13
1989 1989 -73.9631646754647 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631646754647 40.7925716810884)   19 4 19 13
2136 2136 -73.9721897915211 40.7660434203132 3I-AM-1010-02 03I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   true false false false false   false false false false false false true false   POINT (-73.9721897915211 40.76604342031321)   19 4 19 13
2385 2385 -73.9787552947847 40.7690779628762 3B-AM-1010-06 03B AM 10102018 6 Adult Gray   Gray+   Above Ground 20   true false false false false   false false false false false false true false   POINT (-73.9787552947847 40.7690779628762)   19 4 19 13
2436 2436 -73.95827701417 40.7856610238891 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   true false true false false   false false false false false false true false   POINT (-73.95827701417 40.7856610238891)   19 4 19 13
2466 2466 -73.9599419926299 40.7972774728811 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   true true true false false   false false false false false false true false   POINT (-73.9599419926299 40.7972774728811)   19 4 19 13
2629 2629 -73.9604576237503 40.7818120101394 23I-PM-1019-01 23I PM 10192018 1 Adult Gray   Gray+   Above Ground 35   true false false false false running (across branches) false false false false false false false false   POINT (-73.9604576237503 40.7818120101394)   19 4 19 13
2640 2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   true false false false false running from squirrel #5 false false false false false false false false   POINT (-73.9788304714091 40.7696373635315)   19 4 19 13
2708 2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   true true false false false burying nut false false false false true false false false   POINT (-73.9528429238071 40.7922651848867)   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
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   true false false false false   false false false false false false true false   POINT (-73.9722053355548 40.7662094993614)   19 4 19 13
300 300 -73.9528149779809 40.7924984810637 36I-AM-1017-06 36I AM 10172018 6 Adult Gray Black Gray+Black Darker than others Above Ground 10 Running down tree true false true false false   false false false false false false true false   POINT (-73.9528149779809 40.7924984810637)   19 4 19 13
2609 2609 -73.9596865318094 40.7893787188526 31F-AM-1013-01 31F AM 10132018 1 Adult Gray Black Gray+Black   Above Ground 25   true false true false false   false false false false false false false false   POINT (-73.9596865318094 40.7893787188526)   19 4 19 13
113 113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   true false false false false flying false false false false false false false false   POINT (-73.9700100617602 40.7815739959357)   19 4 19 13
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true false true false false   false false false false true false true false   POINT (-73.9574648097543 40.78925084286221)   19 4 19 13
462 462 -73.9661785940531 40.7742569936186 13I-PM-1008-01 13I PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 climbed tree true false true false false   false false false false false false true false   POINT (-73.9661785940531 40.7742569936186)   19 4 19 13
797 797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false   false false false false false true false false   POINT (-73.969345754447 40.7770429650288)   19 4 19 13
1150 1150 -73.9744726434743 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false chased up a tree by #4 false false false false false false true false   POINT (-73.9744726434743 40.776729630785)   19 4 19 13
1235 1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false jumping back & forth on tree false false false true true false true false   POINT (-73.9679686793869 40.7825993867876)   19 4 19 13
1338 1338 -73.9716624574422 40.7762037110101 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false scratching false false false false false false true false   POINT (-73.9716624574422 40.7762037110101)   19 4 19 13
1408 1408 -73.973230162241 40.7689824531444 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence true false false true false   false false false false false false false false   POINT (-73.973230162241 40.7689824531444)   19 4 19 13
1451 1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   19 4 19 13
1464 1464 -73.9532074573139 40.7934669464908 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree true false true false false   false false false false false false false false   POINT (-73.9532074573139 40.7934669464908)   19 4 19 13
1530 1530 -73.9689305978751 40.7818152496266 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence true false true false false climbing (fence) false false false false false false true false   POINT (-73.9689305978751 40.7818152496266)   19 4 19 13
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true false false true false   false false false false false false true false   POINT (-73.9604083891356 40.7910284106931)   19 4 19 13
1960 1960 -73.9730158913661 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true true false false false chasing #2 false false false false false false false false   POINT (-73.9730158913661 40.7701310707272)   19 4 19 13
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9687213827744 40.7843586374648)   19 4 19 13
2247 2247 -73.9559520137172 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #7 false false false false true false true false   POINT (-73.95595201371721 40.7950536287174)   19 4 19 13
2465 2465 -73.9686999860219 40.7844014735136 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9686999860219 40.7844014735136)   19 4 19 13
2652 2652 -73.9620542514749 40.7943731722138 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9620542514749 40.7943731722138)   19 4 19 13
1576 1576 -73.9619985187616 40.7943277743532 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground true true true false false   false false false false false false true false   POINT (-73.9619985187616 40.7943277743532)   19 4 19 13
25 25 -73.9671130680114 40.7784859700171 17F-AM-1007-07 17F AM 10072018 7 Adult Gray White Gray+White   Above Ground 24   true false false false false   false false false true false false true false   POINT (-73.9671130680114 40.7784859700171)   19 4 19 13
426 426 -73.9741944367138 40.7769889953596 13B-PM-1008-01 13B PM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on railing true false false false false   false false false false false false true false   POINT (-73.9741944367138 40.7769889953596)   19 4 19 13
561 561 -73.9581982486469 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   true false true false false   false false false false true false false false   POINT (-73.95819824864691 40.7992194575293)   19 4 19 13
999 999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   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
1915 1915 -73.9797112925048 40.7688046778472 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   true false false false false   false false false false false false false false   POINT (-73.9797112925048 40.7688046778472)   19 4 19 13
2002 2002 -73.9581706950566 40.7906321397269 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9581706950566 40.7906321397269)   19 4 19 13
2071 2071 -73.9667694439895 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 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.9667694439895 40.7779501809095)   19 4 19 13
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   true true false false false 2/3 chasing each other false false false false true false true false   POINT (-73.9707487237344 40.7800822831001)   19 4 19 13
2224 2224 -73.9662310606968 40.7747758221226 14I-AM-1013-01 14I AM 10132018 1 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false true false   POINT (-73.9662310606968 40.7747758221226)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
2632 2632 -73.950827557335 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge true false false false false   false false false false false false true false   POINT (-73.950827557335 40.797579073666)   18 4 36 18

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 18798.163ms