tally

Per-ballot-option vote count for each election — one row per option per election. Options include each union on the ballot and "No union".
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.

68,833 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ election_id option votes created_at
1 1 1 1 No union   2021-05-28 23:57:49
2 2 1 1 PIPEFITTERS ASSOCIATION LOCAL UNION #537   2021-05-28 23:57:49
3 3 2 2 No union 47 2021-05-28 23:57:49
4 4 2 2 SERVICE EMPLOYEES INTERNATIONAL UNION, L 101 2021-05-28 23:57:49
5 5 3 3 No union 229 2021-05-28 23:57:49
6 6 3 3 SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 285   2021-05-28 23:57:49
7 7 4 4 NEW ENGLAND JOINT BOARD, UNION OF NEEDLETRADES, INDUSTRIAL AND TEXTILE EMPLOYEES 47 2021-05-28 23:57:49
8 8 4 4 No union 52 2021-05-28 23:57:49
9 9 5 5 AMALGAMATED TRANSIT UNION, LOCAL NO. 714, AFL-CIO 5 2021-05-28 23:57:49
10 10 5 5 No union 4 2021-05-28 23:57:49
11 11 6 6 INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 25 10 2021-05-28 23:57:49
12 12 6 6 No union 2 2021-05-28 23:57:49
13 13 7 7 INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 25 14 2021-05-28 23:57:49
14 14 7 7 No union 6 2021-05-28 23:57:49
15 15 8 8 INTERNATIONAL UNION, SECURITY, POLICE, AND FIRE PROFESSIONALS OF AMERICA (SPFPA) 32 2021-05-28 23:57:49
16 16 8 8 No union 9 2021-05-28 23:57:49
17 17 9 9 INTERNATIONAL ASSOCIATION OF EMT'S AND PARAMEDICS, LOCAL 95, A/W SERVICE EMPLOYEES INTERNATIONAL UN 6 2021-05-28 23:57:49
18 18 9 9 No union 1 2021-05-28 23:57:49
19 19 10 10 No union 16 2021-05-28 23:57:49
20 20 10 10 UNITED FOOD AND COMMERCIAL WORKERS INTERNATIONAL UNION, LOCAL 1445 22 2021-05-28 23:57:49
21 21 11 11 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL 99, AFL-CIO 10 2021-05-28 23:57:49
22 22 11 11 No union 9 2021-05-28 23:57:49
23 23 12 12 INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL UNION NO. 122 5 2021-05-28 23:57:49
24 24 12 12 No union 1 2021-05-28 23:57:49
25 25 13 13 INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 404 4 2021-05-28 23:57:49
26 26 13 13 No union 12 2021-05-28 23:57:49
27 27 14 14 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS, AFL-CIO 7 2021-05-28 23:57:49
28 28 14 14 No union   2021-05-28 23:57:49
29 29 15 15 INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL UNION NO. 59 21 2021-05-28 23:57:49
30 30 15 15 No union 4 2021-05-28 23:57:49
31 31 16 16 INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL 25 7 2021-05-28 23:57:49
32 32 16 16 No union 3 2021-05-28 23:57:49
33 33 17 17 INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL UNION NO. 653 13 2021-05-28 23:57:49
34 34 17 17 No union 37 2021-05-28 23:57:49
35 35 18 18 INTERNATIONAL BROTHEROOD OF TEAMSTERS LOCAL 25 5 2021-05-28 23:57:49
36 36 18 18 No union   2021-05-28 23:57:49
37 37 19 19 GENERAL TEAMSTERS, CHAUFFEURS, WAREHOUSEMEN & HELPERS OF BROCKTON & VICINITY, LOCAL UNION NO. 653, A 95 2021-05-28 23:57:49
38 38 19 19 No union 111 2021-05-28 23:57:49
39 39 20 20 No union   2021-05-28 23:57:49
40 40 20 20 TRUCK DRIVERS UNION LOCAL NO. 170, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS 2 2021-05-28 23:57:49
41 41 21 21 1199 SERVICE EMPLOYEES INTERNATIONAL UNION, HEALTH CARE WORKERS EAST, MA DIVISION 20 2021-05-28 23:57:49
42 42 21 21 No union 3 2021-05-28 23:57:49
43 43 22 22 NATIONAL EDUCATION ASSOCIATION RHODE ISLAND 25 2021-05-28 23:57:49
44 44 22 22 No union 12 2021-05-28 23:57:49
45 45 23 23 MAINE STATE EMPLOYEES ASSOCIATION, LOCAL 1989, A/W SERVICE EMPLOYEES INTERNATIONAL UNION 15 2021-05-28 23:57:49
46 46 23 23 No union 7 2021-05-28 23:57:49
47 47 24 24 No union 2 2021-05-28 23:57:49
48 48 24 24 TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS 2 2021-05-28 23:57:49
49 49 25 25 No union 25 2021-05-28 23:57:49
50 50 25 25 UNITED FOOD AND COMMERCIAL WORKERS INTERNATIONAL UNION, LOCAL 1445 9 2021-05-28 23:57:49
51 51 26 26 No union 2 2021-05-28 23:57:49
52 52 26 26 TEAMSTERS LOCAL UNION NO. 59, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS   2021-05-28 23:57:49
53 53 27 27 NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION 80 2021-05-28 23:57:49
54 54 27 27 No union 220 2021-05-28 23:57:49
55 55 27 27 OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO   2021-05-28 23:57:49
56 56 28 28 NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION 159 2021-05-28 23:57:49
57 57 28 28 No union 174 2021-05-28 23:57:49
58 58 28 28 OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO   2021-05-28 23:57:49
59 59 29 29 NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION 97 2021-05-28 23:57:49
60 60 29 29 No union 371 2021-05-28 23:57:49
61 61 30 30 No union 3 2021-05-28 23:57:49
62 62 30 30 TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS 4 2021-05-28 23:57:49
63 63 31 31 No union 4 2021-05-28 23:57:49
64 64 31 31 TEAMSTERS LOCAL UNION NO. 251, A/W INTERNATIONAL BROTHEROOD OF TEAMSTERS 4 2021-05-28 23:57:49
65 65 32 32 No union 29 2021-05-28 23:57:49
66 66 32 32 TRUCK DRIVERS UNION, LOCAL UNION NO. 170, A/W INTERNATIONAL BROTHERHOOD OF TEAMSTERS 14 2021-05-28 23:57:49
67 67 33 33 No union   2021-05-28 23:57:49
68 68 33 33 PROFESSIONAL AIR TRAFFIC CONTROLLERS ORGANZATION, FPD/NUHHCE/AFSCME, AFL-CIO 3 2021-05-28 23:57:49
69 69 34 34 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS, DISTRICT LODGE 15, LOCAL LODGE 264, A 10 2021-05-28 23:57:49
70 70 34 34 No union 16 2021-05-28 23:57:49
71 71 35 35 NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION 80 2021-05-28 23:57:49
72 72 35 35 No union 220 2021-05-28 23:57:49
73 73 35 35 OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO   2021-05-28 23:57:49
74 74 36 36 NATIONAL EMERGENCY MEDICAL SERVICES ASSOCIATION 159 2021-05-28 23:57:49
75 75 36 36 No union 174 2021-05-28 23:57:49
76 76 36 36 OFFICE AND PROFESSIONAL EMPLOYEES INTERNATIONAL UNION, LOCAL 6, AFL-CIO   2021-05-28 23:57:49
77 77 37 37 No union 2 2021-05-28 23:57:49
78 78 37 37 PROFESSIONAL AIR TRAFFIC CONTROLLERS ORGANIZATION {PATCO} FPD, NUHHCE, AFSCME, AFL-CIO 3 2021-05-28 23:57:49
79 79 38 38 INTERNATIONAL UNION, SECURITY, POLICE AND FIRE PROFESSIONALS OF AMERICA (SPFPA) 47 2021-05-28 23:57:49
80 80 38 38 No union 1 2021-05-28 23:57:49
81 81 39 39 No union 20 2021-05-28 23:57:49
82 82 39 39 UNITED ELECTRICAL, RADIO AND MACHINE WORKERS OF AMERICA (UE) 17 2021-05-28 23:57:49
83 83 40 40 INTERNATIONAL UNION OF OPERATING ENGINEERS, LOCAL 4, AFL-CIO 4 2021-05-28 23:57:49
84 84 40 40 No union 1 2021-05-28 23:57:49
85 85 41 41 NATIONAL ASSOCIATION OF BROADCAST EMPLOYEES AND TECHNICIANS, A/W COMMUNICATIONS WORKERS OF AMERICA, 18 2021-05-28 23:57:49
86 86 41 41 No union 20 2021-05-28 23:57:49
87 87 42 42 No union   2021-05-28 23:57:49
88 88 42 42 UNITED BROTHERHOOD OF CARPENTERS & JOINERS OF AMERICA, LOCAL UNION NO. 723, A/W NEW ENGLAND REGIONA 10 2021-05-28 23:57:49
89 89 43 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
90 90 43 43 No union 3 2021-05-28 23:57:49
91 91 44 44 No union 1 2021-05-28 23:57:49
92 92 44 44 STATE, HEALTHCARE AND RESEARCH EMPLOYEES (SHARE)/AFSCME LOCAL 3900 14 2021-05-28 23:57:49
93 93 45 45 International Brotherhood of Teamsters Local Union #25 25 2021-05-28 23:57:49
94 94 45 45 No union 31 2021-05-28 23:57:49
95 95 46 46 No union 36 2021-05-28 23:57:49
96 96 46 46 UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPE FITTING INDUSTRY OF THE UNITED 4 2021-05-28 23:57:49
97 97 47 47 No union 42 2021-05-28 23:57:49
98 98 47 47 UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPE FITTING INDUSTRY OF THE UNITED 1 2021-05-28 23:57:49
99 99 48 48 AMALGAMATED TRANSIT UNION, LOCAL 448, AFL-CIO 49 2021-05-28 23:57:49
100 100 48 48 No union 97 2021-05-28 23:57:49

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE tally(election_id int,
                   option text,
		   votes int,
		   created_at timestamp default CURRENT_TIMESTAMP,
		   FOREIGN KEY(election_id) REFERENCES election(election_id));