squirrels

59 rows where Hectare Squirrel Number = 5 and Runs from = "true" sorted by Combination of Primary and Highlight Color

✎ 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, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Other Interactions, Zip Codes, Community Districts, City Council Districts

Police Precincts ✖

Indifferent ✖

Runs from ✖

  • true · 59 ✖

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
2817 2817 -73.9596445861554 40.7971948679007 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9596445861554 40.7971948679007)   19 4 19 13
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
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   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
1891 1891 -73.9749641575871 40.7673305056277 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9749641575871 40.7673305056277)   19 4 19 13
2245 2245 -73.9774228454023 40.7686399839016 3D-AM-1006-05 03D AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (chased by boy),wary of humans in playground POINT (-73.9774228454023 40.7686399839016)   19 4 19 13
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9686925781295 40.7705688673142)   19 4 19 13
4 4 -73.9757249834141 40.7697032606755 5D-PM-1018-05 05D PM 10182018 5 Juvenile Gray   Gray+   Above Ground 3   false false true false false   false false false false false false false true   POINT (-73.9757249834141 40.7697032606755)   19 4 19 13
341 341 -73.9703161745884 40.7702610461336 8H-PM-1014-05 08H PM 10142018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9703161745884 40.7702610461336)   19 4 19 13
415 415 -73.9570131890379 40.7991786736124 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true true   POINT (-73.9570131890379 40.7991786736124)   19 4 19 13
558 558 -73.9579335275486 40.7953080673706 37D-PM-1014-05 37D PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9579335275486 40.7953080673706)   19 4 19 13
696 696 -73.9656098194149 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9656098194149 40.7757643078973)   19 4 19 13
793 793 -73.9730111650468 40.7782157736204 14B-PM-1014-05 14B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9730111650468 40.7782157736204)   19 4 19 13
1348 1348 -73.9599197612389 40.7954836456006 36B-PM-1013-05 36B PM 10132018 5 Adult Gray   Gray+   Above Ground 4   true false false false false   false false false false false false false true   POINT (-73.9599197612389 40.7954836456006)   19 4 19 13
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   true false true false false   false false false false false false false true   POINT (-73.9778730762957 40.770827251547)   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
1900 1900 -73.9529224802393 40.7961895763649 40G-PM-1013-05 40G PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (to the tree) POINT (-73.9529224802393 40.7961895763649)   19 4 19 13
2000 2000 -73.9591070579246 40.7896776771157 31F-PM-1007-05 31F PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9591070579246 40.7896776771157)   19 4 19 13
2209 2209 -73.9697583235533 40.7787320391004 16D-AM-1007-05 16D AM 10072018 5 Adult Gray   Gray+ didn't get a good look Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.96975832355331 40.7787320391004)   19 4 19 13
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9697787673802 40.7781746195436)   19 4 19 13
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.96159260312531 40.7944223235385)   19 4 19 13
2991 2991 -73.9684632673603 40.7848909525198 23A-AM-1018-05 23A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9684632673603 40.7848909525198)   19 4 19 13
703 703 -73.9576304473722 40.7959810622342 38D-AM-1017-05 38D AM 10172018 5 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Black stripe along sides Ground Plane FALSE   true false false true false eating (nut) false false false false false false false true   POINT (-73.9576304473722 40.7959810622342)   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
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false true true false   false false false false true false false true   POINT (-73.9605163698302 40.7914179994956)   19 4 19 13
90 90 -73.9787180870736 40.7715877863274 5A-AM-1006-05 05A AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near 65th St arch false false false false true   false false false true false false false true   POINT (-73.9787180870736 40.7715877863274)   19 4 19 13
231 231 -73.9527808174534 40.7924167234441 36I-AM-1017-05 36I AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true runs from (me) POINT (-73.9527808174534 40.7924167234441)   19 4 19 13
313 313 -73.9646610347972 40.7790583544252 19H-AM-1010-05 19H AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE near a brush false false false true true   false false false false false false false true   POINT (-73.9646610347972 40.7790583544252)   19 4 19 13
337 337 -73.9583101927652 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree true false false false false   false false false false false false false true runs from (us) POINT (-73.9583101927652 40.7852649316039)   19 4 19 13
536 536 -73.9561141662309 40.7976258458604 40D-PM-1013-05 40D PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9561141662309 40.7976258458604)   19 4 19 13
697 697 -73.970465600402 40.7701125773248 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. true false false true true   false false false false true false false true   POINT (-73.970465600402 40.7701125773248)   19 4 19 13
1501 1501 -73.9608167300104 40.7954348688268 36A-PM-1013-05 36A PM 10132018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS false false false false true   false false false false false false false true   POINT (-73.9608167300104 40.7954348688268)   19 4 19 13
1571 1571 -73.9673129010312 40.7778169845999 16F-PM-1013-05 16F PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Pine tree near utility shed false false false true true   false false false false false false false true   POINT (-73.9673129010312 40.7778169845999)   19 4 19 13
1734 1734 -73.9524132295658 40.7933777553406 37I-AM-1010-05 37I AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.95241322956582 40.7933777553406)   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
2164 2164 -73.955013129397 40.7954024311542 38F-AM-1018-05 38F AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false ran up tree false false false false false false false true   POINT (-73.955013129397 40.7954024311542)   19 4 19 13
2365 2365 -73.9688773306324 40.7766669852358 15F-AM-1007-05 15F AM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false true   POINT (-73.9688773306324 40.7766669852358)   19 4 19 13
2439 2439 -73.9587459136391 40.7982497351812 40B-PM-1014-05 40B PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9587459136391 40.7982497351812)   19 4 19 13
2925 2925 -73.9672152696834 40.7823874581829 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9672152696834 40.7823874581829)   19 4 19 13
2936 2936 -73.9809876538513 40.7683223242143 1A-PM-1014-05 01A PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9809876538513 40.7683223242143)   19 4 19 13
795 795 -73.9582523503306 40.7996897499473 41A-PM-1007-05 41A PM 10072018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9582523503306 40.7996897499473)   19 4 19 13
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false false true   POINT (-73.9581310602492 40.7960214726964)   19 4 19 13
1592 1592 -73.9575517912392 40.7889158268192 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     false false true false false   false false false false false false false true   POINT (-73.9575517912392 40.7889158268192)   19 4 19 13
1950 1950 -73.9643016116839 40.7904796216068 30B-PM-1019-05 30B PM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true hiding a nut false false false false true false false true   POINT (-73.9643016116839 40.7904796216068)   19 4 19 13
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
277 277 -73.9619070229674 40.79525566925 35A-AM-1014-05 35A AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9619070229674 40.79525566925)   19 4 19 13
574 574 -73.9706360005275 40.7717074044466 9G-PM-1007-05 09G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9706360005275 40.7717074044466)   19 4 19 13
841 841 -73.9746933852572 40.773313866931 9C-PM-1006-05 09C PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true w/ dog POINT (-73.9746933852572 40.773313866931)   19 4 19 13
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
940 940 -73.9700879096644 40.7765899724756 14E-PM-1017-05 14E PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9700879096644 40.7765899724756)   19 4 19 13
1054 1054 -73.9570050460867 40.7985192250745 40C-AM-1017-05 40C AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9570050460867 40.7985192250745)   19 4 19 13
1324 1324 -73.954554245377 40.7983935730557 41E-AM-1007-05 41E AM 10072018 5 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true man/pit bull mix wandered POINT (-73.954554245377 40.7983935730557)   19 4 19 13
1347 1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616693665254 40.792971019627)   19 4 19 13
1466 1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
1489 1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9581241870185 40.7961057536141)   19 4 19 13
2061 2061 -73.9608834102446 40.790624710005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9608834102446 40.790624710005)   19 4 19 13
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   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 93.776ms