squirrels

42 rows where Date = 10082018, Police Precincts = 13 and Primary Fur Color = "Cinnamon"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, 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, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, 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
26 26 -73.9649866016038 40.7764929694457 16I-AM-1008-01 16I AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9649866016038 40.7764929694457)   19 4 19 13
63 63 -73.9745630038492 40.7692602628745 5E-AM-1008-06 05E AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9745630038492 40.7692602628745)   19 4 19 13
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
151 151 -73.9714789136757 40.7694886645194 6H-AM-1008-01 06H AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714789136757 40.7694886645194)   19 4 19 13
194 194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9764839973068 40.7691725326976)   19 4 19 13
247 247 -73.9733117663541 40.7694584620114 6F-PM-1008-05 06F PM 10082018 5 Adult Cinnamon White Cinnamon+White white patch Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97331176635412 40.7694584620114)   19 4 19 13
249 249 -73.9786339295735 40.7684918638639 3C-PM-1008-02 03C PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9786339295735 40.7684918638639)   19 4 19 13
303 303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true true true climbed fence staring at me - went up tree false false false false false false false true   POINT (-73.97623482246482 40.7694522315322)   19 4 19 13
376 376 -73.9698817079185 40.7758322627711 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false true   POINT (-73.9698817079185 40.7758322627711)   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
458 458 -73.9735750352959 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       false false false false false   false false false false false false true false   POINT (-73.9735750352959 40.7694500333777)   19 4 19 13
464 464 -73.9664450399121 40.7887844904695 27A-AM-1008-02 27A AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9664450399121 40.7887844904695)   19 4 19 13
695 695 -73.9685080639873 40.7745309794155 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree false false true false false   false false false false false false true false   POINT (-73.9685080639873 40.77453097941551)   19 4 19 13
715 715 -73.9772026572674 40.7691598773017 4D-PM-1008-14 04D PM 10082018 14 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9772026572674 40.7691598773017)   19 4 19 13
813 813 -73.9758959798289 40.7694125671679 4D-PM-1008-01 04D PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9758959798289 40.7694125671679)   19 4 19 13
863 863 -73.9764016030666 40.7689894344251 4D-PM-1008-05 04D PM 10082018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764016030666 40.7689894344251)   19 4 19 13
897 897 -73.9734687538064 40.7694308959222 6F-PM-1008-04 06F PM 10082018 4 Adult Cinnamon White Cinnamon+White patches of white on haunches Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9734687538064 40.7694308959222)   19 4 19 13
925 925 -73.9763116425885 40.7688839576487 4D-PM-1008-03 04D PM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true ran two feet up tree trunk POINT (-73.9763116425885 40.7688839576487)   19 4 19 13
939 939 -73.9761447791484 40.7690147873986 4D-PM-1008-02 04D PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761447791484 40.7690147873986)   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
1003 1003 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 10082018 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9 tree hollow false false false false false in hollow false false false false false false false false curious POINT (-73.9645547556826 40.776877007081)   19 4 19 13
1121 1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9645060433292 40.7768322057794)   19 4 19 13
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1142 1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
1199 1199 -73.9756993198381 40.7681956641913 3E-PM-1008-08 03E PM 10082018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9756993198381 40.7681956641913)   19 4 19 13
1266 1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9709897849823 40.768627964006)   19 4 19 13
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   19 4 19 13
1290 1290 -73.9668140804066 40.7768100147333 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9668140804066 40.7768100147333)   19 4 19 13
1384 1384 -73.9787608762005 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   false false false false false walked between trees false false false false false false true false   POINT (-73.9787608762005 40.7686062296462)   19 4 19 13
1982 1982 -73.9729979174723 40.7742904356698 10D-PM-1008-01 10D PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9729979174723 40.7742904356698)   19 4 19 13
2005 2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   19 4 19 13
2190 2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   false false false true false   false false false false false false true false   POINT (-73.9657040391563 40.7755567428199)   19 4 19 13
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9694382427984 40.7846350692923)   19 4 19 13
2268 2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9590191655172 40.7926139425111)   19 4 19 13
2516 2516 -73.9649823687651 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9649823687651 40.7763395359636)   19 4 19 13
2725 2725 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 10082018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree false false false true false   false false false false false false true false   POINT (-73.9658867660358 40.7756523577509)   19 4 19 13
2787 2787 -73.9765306970303 40.7694956875859 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         false false false false true   false false false false false false true false   POINT (-73.9765306970303 40.7694956875859)   19 4 19 13
2801 2801 -73.9697665830132 40.7759094917104 13E-PM-1008-08 13E PM 10082018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9697665830132 40.7759094917104)   19 4 19 13
2837 2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9772691210241 40.7690960712994)   19 4 19 13
2886 2886 -73.9729265300533 40.7741768291642 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9729265300533 40.7741768291642)   19 4 19 13
2952 2952 -73.9763719445827 40.7689551413337 4D-PM-1008-04 04D PM 10082018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9763719445827 40.7689551413337)   19 4 19 13
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture false false true false true   false false false false false true false false   POINT (-73.9767389132988 40.7689323691424)   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 56.041ms