Compile NYC Primary Winners Database
Budget: $10 – $30 USD
I have two raw lists ready for you: one is the full roster of every candidate who filed to run for office in New York City (complete with phone, email and mailing details) and the other is a clean list of everyone who actually won their primary. Your task is to merge those sources and hand back a single, tidy Excel workbook that contains only the winners.
Each record in the final sheet must preserve all original contact fields and also include two additional columns I specify—“Office they ran for” and “Party affiliation.” If a candidate appears more than once across districts or data files, please keep only one consolidated row. Any winners you cannot match to contact data should be flagged separately so I can chase missing information myself.
Deliverables
• A fully formatted .xlsx file with one sheet showing all primary winners, complete contact details, Office and Party columns in place.
• A short note (second sheet or text file) listing names that could not be matched or any data assumptions you had to make.
I will send the source files in their original format (they’re not PDF/Word/Text—just raw exports), and I’m flexible on how you sort the final list; alphabetical by candidate name is perfectly fine if you don’t have a strong preference. Speed and accuracy matter more to me than fancy styling, but the sheet should be ready for immediate mail-merge and filtering once I receive it.
Each record in the final sheet must preserve all original contact fields and also include two additional columns I specify—“Office they ran for” and “Party affiliation.” If a candidate appears more than once across districts or data files, please keep only one consolidated row. Any winners you cannot match to contact data should be flagged separately so I can chase missing information myself.
Deliverables
• A fully formatted .xlsx file with one sheet showing all primary winners, complete contact details, Office and Party columns in place.
• A short note (second sheet or text file) listing names that could not be matched or any data assumptions you had to make.
I will send the source files in their original format (they’re not PDF/Word/Text—just raw exports), and I’m flexible on how you sort the final list; alphabetical by candidate name is perfectly fine if you don’t have a strong preference. Speed and accuracy matter more to me than fancy styling, but the sheet should be ready for immediate mail-merge and filtering once I receive it.