tally
- created_at
- Scrape timestamp.
- election_id
- Foreign key to election.election_id.
- option
- Ballot option name — typically a union name, or "No union" for the no-representation choice.
- votes
- Number of votes the option received.
70,144 rows
Suggested facets: created_at (date)
| election_id | option | votes | created_at |
|---|---|---|---|
| 1 | No union | 2021-05-28 23:57:49 | |
| 1 | PIPEFITTERS ASSOCIATION LOCAL UNION #537 | 2021-05-28 23:57:49 | |
| 2 | No union | 47 | 2021-05-28 23:57:49 |
| 2 | SERVICE EMPLOYEES INTERNATIONAL UNION, L | 101 | 2021-05-28 23:57:49 |
| 3 | No union | 229 | 2021-05-28 23:57:49 |
| 3 | SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 285 | 2021-05-28 23:57:49 | |
| 4 | NEW ENGLAND JOINT BOARD, UNION OF NEEDLETRADES, INDUSTRIAL AND TEXTILE EMPLOYEES | 47 | 2021-05-28 23:57:49 |
| 4 | No union | 52 | 2021-05-28 23:57:49 |
| 5 | AMALGAMATED TRANSIT UNION, LOCAL NO. 714, AFL-CIO | 5 | 2021-05-28 23:57:49 |
| 5 | No union | 4 | 2021-05-28 23:57:49 |
| 6 | INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 25 | 10 | 2021-05-28 23:57:49 |
| 6 | No union | 2 | 2021-05-28 23:57:49 |
| 7 | INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 25 | 14 | 2021-05-28 23:57:49 |
| 7 | No union | 6 | 2021-05-28 23:57:49 |
| 8 | INTERNATIONAL UNION, SECURITY, POLICE, AND FIRE PROFESSIONALS OF AMERICA (SPFPA) | 32 | 2021-05-28 23:57:49 |
| 8 | No union | 9 | 2021-05-28 23:57:49 |
| 9 | INTERNATIONAL ASSOCIATION OF EMT'S AND PARAMEDICS, LOCAL 95, A/W SERVICE EMPLOYEES INTERNATIONAL UN | 6 | 2021-05-28 23:57:49 |
| 9 | No union | 1 | 2021-05-28 23:57:49 |
| 10 | No union | 16 | 2021-05-28 23:57:49 |
| 10 | UNITED FOOD AND COMMERCIAL WORKERS INTERNATIONAL UNION, LOCAL 1445 | 22 | 2021-05-28 23:57:49 |
| 11 | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 99, AFL-CIO | 10 | 2021-05-28 23:57:49 |
| 11 | No union | 9 | 2021-05-28 23:57:49 |
| 12 | INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL UNION NO. 122 | 5 | 2021-05-28 23:57:49 |
| 12 | No union | 1 | 2021-05-28 23:57:49 |
| 13 | INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 404 | 4 | 2021-05-28 23:57:49 |
| 13 | No union | 12 | 2021-05-28 23:57:49 |
| 14 | INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS, AFL-CIO | 7 | 2021-05-28 23:57:49 |
| 14 | No union | 2021-05-28 23:57:49 | |
| 15 | INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL UNION NO. 59 | 21 | 2021-05-28 23:57:49 |
| 15 | No union | 4 | 2021-05-28 23:57:49 |
| 16 | INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL 25 | 7 | 2021-05-28 23:57:49 |
| 16 | No union | 3 | 2021-05-28 23:57:49 |
| 17 | INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 653 | 13 | 2021-05-28 23:57:49 |
| 17 | No union | 37 | 2021-05-28 23:57:49 |
| 18 | INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL 25 | 5 | 2021-05-28 23:57:49 |
| 18 | No union | 2021-05-28 23:57:49 | |
| 19 | GENERAL TEAMSTERS, CHAUFFEURS, WAREHOUSEMEN & HELPERS OF BROCKTON & VICINITY, LOCAL UNION NO. 653, A | 95 | 2021-05-28 23:57:49 |
| 19 | No union | 111 | 2021-05-28 23:57:49 |
| 20 | No union | 2021-05-28 23:57:49 | |
| 20 | TRUCK DRIVERS UNION LOCAL NO. 170, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS | 2 | 2021-05-28 23:57:49 |
| 21 | 1199 SERVICE EMPLOYEES INTERNATIONAL UNION, HEALTH CARE WORKERS EAST, MA DIVISION | 20 | 2021-05-28 23:57:49 |
| 21 | No union | 3 | 2021-05-28 23:57:49 |
| 22 | NATIONAL EDUCATION ASSOCIATION RHODE ISLAND | 25 | 2021-05-28 23:57:49 |
| 22 | No union | 12 | 2021-05-28 23:57:49 |
| 23 | MAINE STATE EMPLOYEES ASSOCIATION, LOCAL 1989, A/W SERVICE EMPLOYEES INTERNATIONAL UNION | 15 | 2021-05-28 23:57:49 |
| 23 | No union | 7 | 2021-05-28 23:57:49 |
| 24 | No union | 2 | 2021-05-28 23:57:49 |
| 24 | TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS | 2 | 2021-05-28 23:57:49 |
| 25 | No union | 25 | 2021-05-28 23:57:49 |
| 25 | UNITED FOOD AND COMMERCIAL WORKERS INTERNATIONAL UNION, LOCAL 1445 | 9 | 2021-05-28 23:57:49 |
| 26 | No union | 2 | 2021-05-28 23:57:49 |
| 26 | TEAMSTERS LOCAL UNION NO. 59, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS | 2021-05-28 23:57:49 | |
| 27 | NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION | 80 | 2021-05-28 23:57:49 |
| 27 | No union | 220 | 2021-05-28 23:57:49 |
| 27 | OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO | 2021-05-28 23:57:49 | |
| 28 | NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION | 159 | 2021-05-28 23:57:49 |
| 28 | No union | 174 | 2021-05-28 23:57:49 |
| 28 | OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO | 2021-05-28 23:57:49 | |
| 29 | NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION | 97 | 2021-05-28 23:57:49 |
| 29 | No union | 371 | 2021-05-28 23:57:49 |
| 30 | No union | 3 | 2021-05-28 23:57:49 |
| 30 | TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS | 4 | 2021-05-28 23:57:49 |
| 31 | No union | 4 | 2021-05-28 23:57:49 |
| 31 | TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS | 4 | 2021-05-28 23:57:49 |
| 32 | No union | 29 | 2021-05-28 23:57:49 |
| 32 | TRUCK DRIVERS UNION, LOCAL UNION NO. 170, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS | 14 | 2021-05-28 23:57:49 |
| 33 | No union | 2021-05-28 23:57:49 | |
| 33 | PROFESSIONAL AIR TRAFFIC CONTROLLERS ORGANZATION, FPD/NUHHCE/AFSCME, AFL-CIO | 3 | 2021-05-28 23:57:49 |
| 34 | INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS, DISTRICT LODGE 15, LOCAL LODGE 264, A | 10 | 2021-05-28 23:57:49 |
| 34 | No union | 16 | 2021-05-28 23:57:49 |
| 35 | NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION | 80 | 2021-05-28 23:57:49 |
| 35 | No union | 220 | 2021-05-28 23:57:49 |
| 35 | OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO | 2021-05-28 23:57:49 | |
| 36 | NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION | 159 | 2021-05-28 23:57:49 |
| 36 | No union | 174 | 2021-05-28 23:57:49 |
| 36 | OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO | 2021-05-28 23:57:49 | |
| 37 | No union | 2 | 2021-05-28 23:57:49 |
| 37 | PROFESSIONAL AIR TRAFFIC CONTROLLERS ORGANIZATION {PATCO} FPD, NUHHCE, AFSCME, AFL-CIO | 3 | 2021-05-28 23:57:49 |
| 38 | INTERNATIONAL UNION, SECURITY, POLICE AND FIRE PROFESSIONALS OF AMERICA (SPFPA) | 47 | 2021-05-28 23:57:49 |
| 38 | No union | 1 | 2021-05-28 23:57:49 |
| 39 | No union | 20 | 2021-05-28 23:57:49 |
| 39 | UNITED ELECTRICAL, RADIO AND MACHINE WORKERS OF AMERICA (UE) | 17 | 2021-05-28 23:57:49 |
| 40 | INTERNATIONAL UNION OF OPERATING ENGINEERS, LOCAL 4, AFL-CIO | 4 | 2021-05-28 23:57:49 |
| 40 | No union | 1 | 2021-05-28 23:57:49 |
| 41 | NATIONAL ASSOCIATION OF BROADCAST EMPLOYEES AND TECHNICIANS, A/W COMMUNICATIONS WORKERS OF AMERICA, | 18 | 2021-05-28 23:57:49 |
| 41 | No union | 20 | 2021-05-28 23:57:49 |
| 42 | No union | 2021-05-28 23:57:49 | |
| 42 | UNITED BROTHERHOOD OF CARPENTERS & JOINERS OF AMERICA, LOCAL UNION NO. 723, A/W NEW ENGLAND REGIONA | 10 | 2021-05-28 23:57:49 |
| 43 | AREA TRADES COUNCIL A/W IUOE, LOCAL 877, IBEW LOCAL 103, NERCC, LOCAL 51, PLUMBERS & GASFITTERS, LOC | 6 | 2021-05-28 23:57:49 |
| 43 | No union | 3 | 2021-05-28 23:57:49 |
| 44 | No union | 1 | 2021-05-28 23:57:49 |
| 44 | STATE, HEALTHCARE AND RESEARCH EMPLOYEES (SHARE)/AFSCME LOCAL 3900 | 14 | 2021-05-28 23:57:49 |
| 45 | International Brotherhood of Teamsters Local Union #25 | 25 | 2021-05-28 23:57:49 |
| 45 | No union | 31 | 2021-05-28 23:57:49 |
| 46 | No union | 36 | 2021-05-28 23:57:49 |
| 46 | UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPE FITTING INDUSTRY OF THE UNITED | 4 | 2021-05-28 23:57:49 |
| 47 | No union | 42 | 2021-05-28 23:57:49 |
| 47 | UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPE FITTING INDUSTRY OF THE UNITED | 1 | 2021-05-28 23:57:49 |
| 48 | AMALGAMATED TRANSIT UNION, LOCAL 448, AFL-CIO | 49 | 2021-05-28 23:57:49 |
| 48 | No union | 97 | 2021-05-28 23:57:49 |
Table schema
CREATE TABLE tally(election_id BIGINT, "option" VARCHAR, votes BIGINT, created_at TIMESTAMP, FOREIGN KEY (election_id) REFERENCES election(election_id));