Fourteen quick tips for crowdsourcing geographically linked data for public health advocacy
Fig 3
Example of centralized data storage for a crowdsourcing project and shared data entry table.
(a) Directory tree on Google Drive containing web-scraped data (“Schoolboard Daily Snapshot”), spreadsheets for manual data entry (“Nightly Data Entry”; see detail in b), and supporting documents for case reports (“Supporting Docs”). Created using Biorender.com. (b) Example of a manual data entry file for the COVID Schools Canada project. Fields are standardized across spreadsheets, and the “Instructions” tab contains a reference for data for each field. The sheet contains a master list of school names, addresses, and geographic coordinates, which team members copy-pasted to create new case entries and minimize errors due to typing (“Master List of School Codes”).