campaigns

we collect and organize data on filed campaigns for specific offices this data is the primary unit of our electoral data graph note we consider the different stages in an election (e g , primary, run off, general) to be distinct elections with distinct campaigns for example, as of march 26, 2024, colin allred has a single candidate id but six distinct entries in this table with their own campaign id values – covering two congressional primaries, one congressional run off, two congressional general elections, and one (pending) u s senate primary schema true false 175false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type