csv-data

Data source: NYC Open Data · About: The Squirrel Census

Custom SQL query returning 32 rows (hide)

Query parameters

rowidLongitudeLatitudeUnique_Squirrel_IDHectareShiftDateHectare_Squirrel_NumberAgePrimary_Fur_ColorHighlight_Fur_ColorCombination_of_Primary_and_Highlight_ColorColor_notesLocationAbove_Ground_Sighter_MeasurementSpecific_LocationRunningChasingClimbingEatingForagingOther_ActivitiesKuksQuaasMoansTail_flagsTail_twitchesApproachesIndifferentRuns_fromOther_InteractionsLatlongZip_CodesCommunity_DistrictsBorough_BoundariesCity_Council_DistrictsPolice_Precincts
871 -73.98054238861499 40.768204880479395 1B-AM-1012-14 01B AM 1012 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
3894 -73.98054238861499 40.768204880479395 1B-AM-1012-14 01B AM 1012 14   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980542388615 40.7682048804794)   19 4 19 13
202 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 1007 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
401 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 1008 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
888 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 1018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
929 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 1014 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
1166 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 1006 14 Adult Gray White Gray+White   Above Ground 12.0   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)   19 4 19 13
1214 -73.96919687484821 40.776586299619204 14E-AM-1008-14 14E AM 1008 14 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691968748482 40.7765862996192)   19 4 19 13
1243 -73.97720265726741 40.7691598773017 4D-PM-1008-14 04D PM 1008 14 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772026572674 40.7691598773017)   19 4 19 13
1321 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 1006 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
1707 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 1019 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
2064 -73.9646023053207 40.7810680044024 20F-PM-1007-14 20F PM 1007 14 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646023053207 40.7810680044024)   19 4 19 13
2108 -73.9775067398903 40.772656614240105 7B-AM-1008-14 07B AM 1008 14 Adult Gray   Gray+   Above Ground   on fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775067398903 40.7726566142401)   19 4 19 13
2163 -73.9596413903948 40.790312888902896 32E-PM-1017-14 32E PM 1017 14 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9596413903948 40.7903128889029)   19 4 19 13
2425 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 1007 14 Adult Gray   Gray+   Above Ground 50.0 literally fell to ground from 50 feet up 0 0 0 0 0 falling 0 0 0 0 0 0 0 1   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
3225 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 1007 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)   19 4 19 13
3424 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 1008 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)   19 4 19 13
3911 -73.9711120079542 40.776080191176604 13D-PM-1018-14 13D PM 1018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0 climbing (down) 0 0 0 0 0 0 1 0   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
3952 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 1014 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
4189 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 1006 14 Adult Gray White Gray+White   Above Ground 12.0   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)   19 4 19 13
4237 -73.96919687484821 40.776586299619204 14E-AM-1008-14 14E AM 1008 14 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691968748482 40.7765862996192)   19 4 19 13
4266 -73.97720265726741 40.7691598773017 4D-PM-1008-14 04D PM 1008 14 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772026572674 40.7691598773017)   19 4 19 13
4344 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 1006 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
4730 -73.97063044050999 40.77710605948079 14D-PM-1019-14 14D PM 1019 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97063044051 40.7771060594808)   19 4 19 13
5087 -73.9646023053207 40.7810680044024 20F-PM-1007-14 20F PM 1007 14 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9646023053207 40.7810680044024)   19 4 19 13
5131 -73.9775067398903 40.772656614240105 7B-AM-1008-14 07B AM 1008 14 Adult Gray   Gray+   Above Ground   on fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775067398903 40.7726566142401)   19 4 19 13
5186 -73.9596413903948 40.790312888902896 32E-PM-1017-14 32E PM 1017 14 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9596413903948 40.7903128889029)   19 4 19 13
5448 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 1007 14 Adult Gray   Gray+   Above Ground 50.0 literally fell to ground from 50 feet up 0 0 0 0 0 falling 0 0 0 0 0 0 0 1   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
892 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 1010 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10.0   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
1862 -73.9775099290913 40.76976090631371 4C-PM-1010-14 04C PM 1010 14 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 1 0 0 0 chasing #15 0 0 0 0 0 0 0 0   POINT (-73.9775099290913 40.7697609063137)   19 4 19 13
3915 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 1010 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10.0   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
4885 -73.9775099290913 40.76976090631371 4C-PM-1010-14 04C PM 1010 14 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 1 0 0 0 chasing #15 0 0 0 0 0 0 0 0   POINT (-73.9775099290913 40.7697609063137)   19 4 19 13
Powered by Datasette · Query took 1.98ms · Data source: NYC Open Data · About: The Squirrel Census