With dplyr’s mutate, one can count the number of drones seen each week in each location. Finally, filter excludes the reports from Alaska or Hawai to focus on the mainland.
To lower the reliance on the Google Maps api, the final dataset is saved.