squirrels

39 rows where Date = 10102018, Indifferent = "true" and Location = "Above Ground"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, 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
3 3 -73.9768311751004 40.7667178072558 2E-AM-1010-03 02E AM 10102018 3 Adult Cinnamon   Cinnamon+   Above Ground 4   false false true false false   false false false false false false true false   POINT (-73.9768311751004 40.76671780725581)   19 4 19 13
16 16 -73.9722500196844 40.7742879599026 11D-AM-1010-03 11D AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false true false false grooming false false false false false false true false   POINT (-73.9722500196844 40.7742879599026)   19 4 19 13
46 46 -73.9673253417305 40.7749505252981 13H-PM-1010-02 13H PM 10102018 2 Adult Gray   Gray+   Above Ground 5 tree false false false false true   false false false false false false true false   POINT (-73.9673253417305 40.7749505252981)   19 4 19 13
191 191 -73.9787105069657 40.7693708133873 3B-AM-1010-08 03B AM 10102018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false together w/ #7 false false false false false false true false   POINT (-73.9787105069657 40.7693708133873)   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
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
414 414 -73.9721899838568 40.7761519045651 13C-AM-1010-03 13C AM 10102018 3 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9721899838568 40.7761519045651)   19 4 19 13
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   false false true false false   false false false false false false true false   POINT (-73.9789952029637 40.7697758333099)   19 4 19 13
530 530 -73.9696360756453 40.7786545659072 16D-PM-1010-03 16D PM 10102018 3 Adult Gray   Gray+   Above Ground 18   false false true true false   false false false false false false true false   POINT (-73.9696360756453 40.7786545659072)   19 4 19 13
729 729 -73.9776044578446 40.7697607308033 4C-PM-1010-15 04C PM 10102018 15 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on tree false true false false false chasing #14 false false false false false false true false   POINT (-73.9776044578446 40.7697607308033)   19 4 19 13
822 822 -73.9576559099012 40.7992598626483 41B-AM-1010-09 41B AM 10102018 9 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false true false   POINT (-73.9576559099012 40.7992598626483)   19 4 19 13
908 908 -73.9594120573719 40.7841945750598 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree false false true false true   false false false false false false true false   POINT (-73.9594120573719 40.7841945750598)   19 4 19 13
1164 1164 -73.9790226400629 40.7698997653792 4B-AM-1010-01 04B AM 10102018 1 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Above Ground 2   false false true false false   false false false false true false true false   POINT (-73.9790226400629 40.7698997653792)   19 4 19 13
1227 1227 -73.9527924755398 40.7934366260533 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree false false true false false   false false false false false false true false   POINT (-73.9527924755398 40.7934366260533)   19 4 19 13
1253 1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree false false true false false   false false false false false false true false   POINT (-73.9527227282134 40.7935061484064)   19 4 19 13
1331 1331 -73.9588809150045 40.7847231576181 26I-PM-1010-01 26I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   false false true false true   false false false false false false true false   POINT (-73.9588809150045 40.7847231576181)   19 4 19 13
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree false false true true true   false false false false true false true false   POINT (-73.9594391759139 40.784115697669)   19 4 19 13
1762 1762 -73.9769106838192 40.7674414870702 2E-AM-1010-05 02E AM 10102018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 33   false false true false false   false false false false false false true false   POINT (-73.9769106838192 40.7674414870702)   19 4 19 13
1976 1976 -73.9770920860805 40.7694698040083 4C-PM-1010-01 04C PM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false true false false   false true false false false false true false   POINT (-73.9770920860805 40.7694698040083)   19 4 19 13
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees false false true true true scratching self false false false false true false true false   POINT (-73.9639505810228 40.789573183584)   19 4 19 13
2025 2025 -73.9766541879006 40.7674077265375 2E-AM-1010-06 02E AM 10102018 6 Adult Cinnamon   Cinnamon+   Above Ground 35   false false false false false leaping branch to branch false false false false false false true false   POINT (-73.9766541879006 40.7674077265375)   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
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree false false true false false cleaning false false false false false false true false   POINT (-73.975198284551 40.7740343763399)   19 4 19 13
2226 2226 -73.9624296435843 40.791320813687 31C-PM-1010-02 31C PM 10102018 2 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9624296435843 40.791320813687)   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
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   true false true false true   false false false false false false true false   POINT (-73.975565603566 40.7738462518304)   19 4 19 13
2297 2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   false false true false false together w/ #8 false false false true false false true false   POINT (-73.9787771053108 40.76935621227501)   19 4 19 13
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   false false true true true   true false false false false false true false   POINT (-73.9789251806378 40.7699558513225)   19 4 19 13
2361 2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   false false true false false nest building false false false false false false true false   POINT (-73.9708032298419 40.77842656745441)   19 4 19 13
2379 2379 -73.9711865134364 40.7785039981892 15C-AM-1010-03 15C AM 10102018 3 Adult Gray   Gray+   Above Ground 6   false false false true false sitting false false false false false false true false   POINT (-73.9711865134364 40.7785039981892)   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
2474 2474 -73.9721448879766 40.7762112840981 13C-AM-1010-02 13C AM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true false false burying false false false false false false true false   POINT (-73.9721448879766 40.7762112840981)   19 4 19 13
2476 2476 -73.9710843362124 40.7679739601336 5I-AM-1010-03 05I AM 10102018 3 Adult Gray   Gray+   Above Ground 3   false false false false false   false false false false false false true false   POINT (-73.9710843362124 40.7679739601336)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2569 2569 -73.9559663734409 40.7945828261377 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false true false false true false   POINT (-73.9559663734409 40.7945828261377)   19 4 19 13
2573 2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk false false false true false   false false false false false false true false   POINT (-73.9810149147578 40.7683925377714)   19 4 19 13
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree false false true false true   false false false false true false true false   POINT (-73.9588339897601 40.7848084865431)   19 4 19 13
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false true false true false   POINT (-73.970595860252 40.7832060751268)   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

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