r_elect_scheduled

37,721 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number unit_id action_sequence election_mode election_type election_state election_time election_city schedule_date self_deter_election expedited_under_8b7 scheduled_tally_date election_cancelled date_excelsior_list_due date_excelsior_list_received date_excelsior_list_sent date_eligible election_place additional_languages
1 1 01-RC-19536 A 0 Manual MANL Initial Initi VT   Bellows Falls 1991-06-20T00:00:00 N N 1991-06-20T00:00:00 N 1991-05-31T00:00:00          
2 2 01-RC-19926 A 0 Manual MANL Initial Initi       1993-05-20T00:00:00 N N 1993-05-20T00:00:00 N 1993-05-13T00:00:00          
3 3 01-RC-20080 A 0 Manual MANL Initial Initi RI various Providence 1994-04-08T00:00:00 N N 1994-04-08T00:00:00 N 1994-03-18T00:00:00          
4 4 01-RC-20080 A 1 Manual MANL Second Secon RI various Providence 2000-01-14T00:00:00 N N 2000-01-14T00:00:00 Y 1994-03-18T00:00:00          
5 5 01-RC-20292 A 0 Manual MANL Initial Initi       1995-06-01T00:00:00 N N 1995-06-01T00:00:00 N 1995-05-09T00:00:00          
6 6 01-RC-20309 A 0 Manual MANL Initial Initi MA various Leominster 1995-09-28T00:00:00 N N 1995-09-28T00:00:00 Y 1995-09-08T00:00:00          
7 7 01-RC-20310 A 0 Manual MANL Initial Initi MA various Leominster 1995-09-28T00:00:00 N N 1995-09-28T00:00:00 Y 1995-09-08T00:00:00          
8 8 01-RC-20467 A 0 Manual MANL Initial Initi MA various Ludlow 1996-07-11T00:00:00 N N 1996-07-11T00:00:00 N 1996-06-21T00:00:00          
9 9 01-RC-20508 A 0 Manual MANL Initial Initi MA   Watertown 1996-12-06T00:00:00 N N 1996-12-06T00:00:00 N 1996-11-14T00:00:00          
10 10 01-RC-20574 A 0 Manual MANL Initial Initi MA various Boston 1999-12-21T00:00:00 N N 1999-12-21T00:00:00 N 1997-10-24T00:00:00          
11 11 01-RC-20626 A 0 Manual MANL Initial Initi MA various Worcester 1997-06-27T00:00:00 N N 1997-06-27T00:00:00 N 1997-07-01T00:00:00          
12 12 01-RC-20634 A 0 Manual MANL Initial Initi MA various Lowell 1997-07-17T00:00:00 N N 1997-07-17T00:00:00 N 1997-07-07T00:00:00          
13 13 01-RC-20649 A 0 Manual MANL Initial Initi       1997-08-19T00:00:00 N N 1997-08-19T00:00:00 N 1997-08-06T00:00:00          
14 14 01-RC-20761 A 0 Manual MANL Initial Initi RI 6-8 a.m., 2-4 p.m. Coventry 2001-01-26T00:00:00 N N 2001-01-26T00:00:00 N 1998-03-26T00:00:00          
15 15 01-RC-20804 A 0 Mail MAIL Initial Initi MA 11:00 a.m. Boston 1998-06-18T00:00:00 N N 1998-06-29T00:00:00 N 1998-05-28T00:00:00          
16 16 01-RC-20815 A 0 Manual MANL Initial Initi RI 6-8 a.m., 2-4 p.m. Coventry 2001-01-26T00:00:00 N N 2001-01-26T00:00:00 N 2001-01-17T00:00:00          
17 17 01-RC-20890 A 0 Mail MAIL Initial Initi RI 7-9 a.m. & 2-4 p.m. Warwick 1998-10-15T00:00:00 N N 1998-10-15T00:00:00 N 1998-09-25T00:00:00          
18 18 01-RC-20897 A 0 Manual MANL Initial Initi MA 5-6:00 p.m. Stoneham 1998-11-02T00:00:00 N N 1998-11-02T00:00:00 N 1998-10-13T00:00:00          
19 19 01-RC-20905 A 0 Manual MANL Initial Initi MA 8:30 - 10:30 a.m. - 3 - 6 pm Revere 1998-12-10T00:00:00 N N 1998-12-10T00:00:00 N 1998-11-17T00:00:00          
20 20 01-RC-20906 A 0 Manual MANL Initial Initi MA 6:30-8:30 a.m. Dalton 1998-11-19T00:00:00 N N 1998-11-19T00:00:00 N 1998-10-30T00:00:00          
21 21 01-RC-20910 A 0 Manual MANL Initial Initi MA 1:30 - 4:30 p.m. Springfield 1998-12-01T00:00:00 N N 1998-12-01T00:00:00 N 1998-11-06T00:00:00          
22 22 01-RC-20912 A 0 Manual MANL Initial Initi MA 6-10, 1:30-5:30 and 10-12 Boston 1998-12-11T00:00:00 N N 1998-12-11T00:00:00 N 1998-11-04T00:00:00          
23 23 01-RC-20914 A 0 Manual MANL Initial Initi MA various worcester 1999-01-21T00:00:00 N N 1999-01-22T00:00:00 N 1998-12-28T00:00:00          
24 24 01-RC-20915 A 0 Manual MANL Initial Initi MA various worcester 1999-01-21T00:00:00 N N 1999-01-22T00:00:00 N 1998-12-28T00:00:00          
25 25 01-RC-20921 A 0 Manual MANL Initial Initi MA   Franklin 1999-01-14T00:00:00 N N 1999-01-14T00:00:00 N 1998-12-22T00:00:00          
26 26 01-RC-20922 A 0 Manual MANL Initial Initi       1998-11-19T00:00:00 N N 1998-11-19T00:00:00 N 1998-11-17T00:00:00          
27 27 01-RC-20923 A 0 Manual MANL Initial Initi RI 1-2 and 5-6 p.m. Manville 1998-12-03T00:00:00 N N 1998-12-03T00:00:00 N 1998-11-17T00:00:00          
28 28 01-RC-20925 A 0 Manual MANL Initial Initi VT 6:00 - 8:00 a.m. 2:00 - 3:00 pm St. Albans 1999-01-08T00:00:00 N N 1999-01-08T00:00:00 N 1998-12-18T00:00:00          
29 29 01-RC-20927 A 0 Manual MANL Initial Initi NH various Claremont and Newport 1999-01-21T00:00:00 N N 1999-01-21T00:00:00 N 1998-12-31T00:00:00          
30 30 01-RC-20936 A 0 Manual MANL Initial Initi MA 6:30 am - 7:30 am Pittsfield 1998-12-30T00:00:00 N N 1998-12-30T00:00:00 N 1998-12-14T00:00:00          
31 31 01-RC-20937 A 0 Mail MAIL Initial Initi MA 1:00 p.m. Boston 1999-01-08T00:00:00 N N 1999-02-02T00:00:00 Y 1998-12-17T00:00:00          
32 32 01-RC-20938 A 0 Manual MANL Initial Initi MA 9:45-11:45 a.m. & 1-3 p.m. Taunton 1999-01-14T00:00:00 N N 1999-01-14T00:00:00 N 1998-12-17T00:00:00          
33 33 01-RC-20940 A 0 Manual MANL Initial Initi MA 6-9 a.m. & 3-5 p.m. Boston 1999-03-11T00:00:00 N N 1999-03-11T00:00:00 Y 1999-02-19T00:00:00          
34 34 01-RC-20941 A 0 Manual MANL Initial Initi RI various Cranston 1999-04-11T00:00:00 N N 1999-04-15T00:00:00 Y 1998-12-24T00:00:00          
35 35 01-RC-20942 A 0 Manual MANL Initial Initi MA 3 - 3:30 wakefield 1999-01-14T00:00:00 N N 1999-01-14T00:00:00 N 1998-12-18T00:00:00          
36 36 01-RC-20944 A 0 Manual MANL Initial Initi ME 2:45 - 4:00 pm Cornish 1999-01-21T00:00:00 N N 1999-01-21T00:00:00 N 1998-12-29T00:00:00          
37 37 01-RC-20945 A 0 Manual MANL Initial Initi MA 7:00 a.m. - 8:30 a.m. North Andover 1999-01-28T00:00:00 N N 1999-01-28T00:00:00 N 1999-01-07T00:00:00          
38 38 01-RC-20946 A 0 Manual MANL Initial Initi MA 8 - 9:30 a.m. Charlestown 1999-01-21T00:00:00 N N 1999-01-21T00:00:00 N 1998-12-30T00:00:00          
39 39 01-RC-20947 A 0 Mail MAIL Initial Initi MA various Lawrence 1999-03-23T00:00:00 N N 1999-03-23T00:00:00 N 1999-01-21T00:00:00          
40 40 01-RC-20949 A 0 Manual MANL Initial Initi MA 11:00 a.m. - 12 noon New Bedford 1999-02-13T00:00:00 N N 1999-02-17T00:00:00 N 1999-02-04T00:00:00          
41 41 01-RC-20950 A 0 Manual MANL Initial Initi RI 1:30-3:00 p.m. & 4-6:00 p.m. Johnston & Kingston 1999-02-03T00:00:00 N N 1999-02-03T00:00:00 N 1999-01-20T00:00:00          
42 42 01-RC-20952 A 0 Manual MANL Initial Initi MA 5:00am to 7:00am, 12:00 noon to 4:00 pm Woburn 1999-02-05T00:00:00 N N 1999-02-05T00:00:00 N 1998-12-31T00:00:00          
43 43 01-RC-20953 A 0 Manual MANL Initial Initi MA 5:30 am to 8:00 am Hopkinton 1999-01-21T00:00:00 N N 1999-01-21T00:00:00 N 1999-01-12T00:00:00          
44 44 01-RC-20955 A 0 Manual MANL Initial Initi MA 3:30-4:30 Hyannis 1999-01-28T00:00:00 N N 1999-01-28T00:00:00 N 1999-01-11T00:00:00          
45 45 01-RC-20956 A 0 Manual MANL Initial Initi ME 12 - 2:00 p.m. Portland 1999-01-22T00:00:00 N N 1999-01-22T00:00:00 N 1999-01-06T00:00:00          
46 46 01-RC-20958 A 0 Manual MANL Initial Initi MA 6:00 am to 9:00 am, 2:00 pm to 5:00 pm Wilbraham 1999-02-26T00:00:00 N N 1999-02-26T00:00:00 N 1999-02-04T00:00:00          
47 47 01-RC-20959 A 0 Manual MANL Initial Initi MA 2-3 p.m. E. Longmeadow 1999-02-04T00:00:00 N N 1999-02-04T00:00:00 N 1999-01-15T00:00:00          
48 48 01-RC-20960 A 0 Mixed, Manual and Mail MIXED Initial Initi VT various White River Jct,Burlington VT 1999-03-04T00:00:00 N N 1999-03-10T00:00:00 N 1999-02-09T00:00:00          
49 49 01-RC-20964 A 0 Manual MANL Initial Initi MA 5:30 am to 8:30 am, 4:00 pm to 8:00 pm Melrose, Lynn 1999-02-25T00:00:00 N N 1999-02-25T00:00:00 N 1999-02-11T00:00:00          
50 50 01-RC-20965 A 0 Manual MANL Initial Initi RI various Providence 1999-02-18T00:00:00 N N 1999-02-18T00:00:00 N 1999-02-25T00:00:00          
51 51 01-RC-20966 A 0 Mail MAIL Initial Initi MA 11:00 a.m. Boston 1999-03-17T00:00:00 N N 1999-05-16T00:00:00 N 1999-02-25T00:00:00          
52 52 01-RC-20968 A 0 Manual MANL Initial Initi MA 6-7 p.m. Woburn 1999-04-01T00:00:00 N N 1999-04-01T00:00:00 N 1999-03-11T00:00:00          
53 53 01-RC-20969 A 0 Manual MANL Initial Initi MA 5:30 - 8:00 a.m.; 2:00 - 4:00 p.m. Milford 1999-04-15T00:00:00 N N 1999-04-15T00:00:00 N 1999-03-26T00:00:00          
54 54 01-RC-20970 A 0 Manual MANL Initial Initi MA 1-5:00 p.m. Fall River 1999-04-15T00:00:00 N N 1999-04-15T00:00:00 N 1999-03-25T00:00:00          
55 55 01-RC-20971 A 0 Manual MANL Initial Initi MA 8:00-8:30 a.m. Wilmington 1999-04-15T00:00:00 N N 1999-04-15T00:00:00 N 1999-03-26T00:00:00          
56 56 01-RC-20972 A 0 Manual MANL Initial Initi RI 5:45-7:30 a.m. & 5:45-6:45 p.m. Providence 1999-03-28T00:00:00 N N 1999-03-30T00:00:00 N 1999-03-05T00:00:00          
57 57 01-RC-20973 A 0 Manual MANL Initial Initi MA 2:30-4:00 p.m. & 10:30-11:30 p.m. Chicopee 1999-03-25T00:00:00 N N 1999-03-25T00:00:00 N 1999-02-25T00:00:00          
58 58 01-RC-20974 A 0 Manual MANL Initial Initi MA various various 1999-03-11T00:00:00 N N 1999-03-11T00:00:00 N 1999-03-08T00:00:00          
59 59 01-RC-20976 A 0 Manual MANL Initial Initi MA 6:30-7:30 a.m. & 2:30-3:30 p.m. Brockton 1999-04-01T00:00:00 N N 1999-04-01T00:00:00 N 1999-03-12T00:00:00          
60 60 01-RC-20977 A 0 Manual MANL Initial Initi MA 7:00 - 8:00 a.m. Franklin 1999-04-08T00:00:00 N N 1999-04-08T00:00:00 N 1999-03-15T00:00:00          
61 61 01-RC-20978 A 0 Manual MANL Initial Initi MA 4-6 a.m., 8-10 a.m. Woburn 1999-04-16T00:00:00 N N 1999-04-16T00:00:00 Y 1999-03-18T00:00:00          
62 62 01-RC-20979 A 0 Manual MANL Initial Initi RI 6-8 a.m. & 2-5 p.m. Providence 1999-04-06T00:00:00 N N 1999-04-06T00:00:00 N 1999-03-16T00:00:00          
63 63 01-RC-20980 A 0 Manual MANL Initial Initi MA 7-8:30 a.m., noon-12:30, 5-6 p.m. Springfield 1999-04-09T00:00:00 N N 1999-04-09T00:00:00 N 1999-03-17T00:00:00          
64 64 01-RC-20981 A 0 Manual MANL Initial Initi MA 4:30-5:30 a.m. Marlboro 1999-04-15T00:00:00 N N 1999-04-15T00:00:00 N 1999-03-30T00:00:00          
65 65 01-RC-20982 A 0 Manual MANL Initial Initi MA 3:00 p.m. - 5:00 p.m. Haverhill 1999-04-15T00:00:00 N N 1999-04-15T00:00:00 N 1999-03-19T00:00:00          
66 66 01-RC-20983 A 0 Manual MANL Initial Initi MA 6:30-7:00 a.m. Hyde Park 1999-04-22T00:00:00 N N 1999-04-22T00:00:00 N 1999-04-01T00:00:00          
67 67 01-RC-20984 A 0 Manual MANL Initial Initi ME 6-9 am., 11 am - 1pm, 2-6 pm Gorham 1999-05-20T00:00:00 N N 1999-05-20T00:00:00 N 1999-04-28T00:00:00 1999-04-28T00:00:00 1999-04-28T00:00:00 1999-04-17T00:00:00 Storage room, 15 New Portand  
68 68 01-RC-20985 A 0 Manual MANL Initial Initi MA 7-9am, 2-4pm, 6-8pm Chelsea 1999-05-26T00:00:00 N N 1999-05-26T00:00:00 N 1999-05-04T00:00:00          
69 69 01-RC-20986 A 0 Manual MANL Initial Initi MA 5:30-8:00 a.m.; 2:30-4:30 p.m. Medford 1999-04-22T00:00:00 N N 1999-04-22T00:00:00 N 1999-04-01T00:00:00          
70 70 01-RC-20987 A 0 Manual MANL Initial Initi MA 2:30 P.M. TO 4:15 P.M. Braintree 1999-04-29T00:00:00 N N 1999-04-29T00:00:00 N 1999-04-01T00:00:00          
71 71 01-RC-20988 A 0 Manual MANL Initial Initi MA 7:30-9:00 a.m. Dartmouth 1999-04-22T00:00:00 N N 1999-04-22T00:00:00 N 1999-04-07T00:00:00          
72 72 01-RC-20989 A 0 Manual MANL Initial Initi MA 2-4:00 p.m. Cambridge 1999-05-06T00:00:00 N N 1999-05-06T00:00:00 N 1999-04-15T00:00:00          
73 73 01-RC-20991 A 0 Manual MANL Initial Initi MA 2:00 - 4:00 p.m. Marlborough 1999-05-08T00:00:00 N N 1999-05-08T00:00:00 N 1999-04-12T00:00:00          
74 74 01-RC-20992 A 0 Manual MANL Initial Initi NH 11:00 a.m.-1:15 p.m.; 6:45-7:00 p.m. Nashua 1999-04-22T00:00:00 N N 1999-04-22T00:00:00 N 1999-04-14T00:00:00          
75 75 01-RC-20993 A 0 Manual MANL Initial Initi MA 11:30 a.m.-12:30 p.m. S. Boston 1999-05-07T00:00:00 N N 1999-05-07T00:00:00 N 1999-04-19T00:00:00          
76 76 01-RC-20994 A 0 Manual MANL Initial Initi MA 6-8 a.m., 11 a.m.-1:00 p.m.; 2-6:00 p.m. Brockton 1999-05-13T00:00:00 N N 1999-05-13T00:00:00 N 1999-04-22T00:00:00          
77 77 01-RC-20997 A 0 Manual MANL Initial Initi MA 5:- 9 a.m ;11:30 a.m. -1:30p.m; 3-6 p.m Marlborough 1999-05-20T00:00:00 N N 1999-05-20T00:00:00 N 1999-04-21T00:00:00          
78 78 01-RC-20998 A 0 Manual MANL Initial Initi MA 1:30-2:30 p.m. Barnstable 1999-04-28T00:00:00 N N 1999-04-28T00:00:00 N 1999-04-16T00:00:00          
79 79 01-RC-21001 A 0 Manual MANL Initial Initi VT 7:30 - 8:30 a.m. Richford 1999-05-28T00:00:00 N N 1999-05-28T00:00:00 N 1999-05-10T00:00:00          
80 80 01-RC-21002 A 0 Mail MAIL Initial Initi MA 11 a.m. Boston 1999-06-03T00:00:00 N N 1999-06-03T00:00:00 N 1999-05-05T00:00:00          
81 81 01-RC-21003 A 0 Manual MANL Initial Initi MA 7-7:15 a.m. Melrose 1999-05-17T00:00:00 N N 1999-05-17T00:00:00 N 1999-05-07T00:00:00          
82 82 01-RC-21004 A 0 Manual MANL Initial Initi MA 4 am - 7 am; 11 am - 1 pm; 5 pm - 7 pm Chelsea 1999-05-14T00:00:00 N N 1999-05-14T00:00:00 N 1999-05-05T00:00:00          
83 83 01-RC-21007 A 0 Manual MANL Initial Initi MA 6:30-7:30 p.m.; 1:30-2:30 p.m.; 6:30-7:30 p.m. Pittsfield 1999-06-02T00:00:00 N N 1999-06-03T00:00:00 N 1999-05-07T00:00:00          
84 84 01-RC-21008 A 0 Manual MANL Initial Initi ME 9 a.m.-12 p.m. Portland 1999-06-10T00:00:00 N N 1999-06-10T00:00:00 N 1999-05-10T00:00:00          
85 85 01-RC-21010 A 0 Manual MANL Initial Initi MA 3:30 - 4:00 pm Hopedale 1999-06-10T00:00:00 N N 1999-06-10T00:00:00 Y 1999-05-19T00:00:00          
86 86 01-RC-21011 A 0 Manual MANL Initial Initi ME (6/30 6 - 8 a.m.) (7/1 6-8 p.m.) Biddeford 1999-06-30T00:00:00 N N 1999-07-01T00:00:00 N 1999-06-10T00:00:00          
87 87 01-RC-21012 A 0 Manual MANL Initial Initi MA 6-7 a.m., 2-4 p.m. Canton 1999-06-17T00:00:00 N N 1999-06-17T00:00:00 N 1999-05-28T00:00:00          
88 88 01-RC-21013 A 0 Manual MANL Initial Initi NH 9-11:00 a.m. Hanover 1999-06-10T00:00:00 N N 1999-06-10T00:00:00 N 1999-05-28T00:00:00          
89 89 01-RC-21015 A 0 Manual MANL Initial Initi MA 6:45-8:30 a.m.; 2:30-4:30 p.m. Shirley & Gardner 1999-06-24T00:00:00 N N 1999-06-24T00:00:00 N 1999-05-26T00:00:00          
90 90 01-RC-21015 A 1 Manual MANL Rerun MA various various 2000-05-25T00:00:00 N N 2000-05-25T00:00:00 Y 1999-05-26T00:00:00          
91 91 01-RC-21016 A 0 Manual MANL Initial Initi ME various Lewiston 1999-06-23T00:00:00 N N 1999-06-23T00:00:00 N 1999-06-01T00:00:00          
92 92 01-RC-21017 A 0 Manual MANL Initial Initi VT 6:30-7:30 a.m. & 6:30-8:00 p.m. Bellow Falls 1999-06-24T00:00:00 N N 1999-06-24T00:00:00 N 1999-06-02T00:00:00          
93 93 01-RC-21018 A 0 Manual MANL Initial Initi RI 7:00 - 11:00 a.m., 12 noon to 1:00 pm Coventry 1999-06-25T00:00:00 N N 1999-06-25T00:00:00 N 1998-06-10T00:00:00          
94 94 01-RC-21019 A 0 Manual MANL Initial Initi ME 7-9:00 a/m. & 2:30-3:30 p.m. Brewer 1999-06-25T00:00:00 N N 1999-06-25T00:00:00 N 1999-06-03T00:00:00          
95 95 01-RC-21020 A 0 Manual MANL Initial Initi NH 1:00 - 4:00 p.m. Brentwood 1999-07-23T00:00:00 N N 1999-07-23T00:00:00 N 1999-07-06T00:00:00          
96 96 01-RC-21021 A 0 Manual MANL Initial Initi MA 3-4:00 p.m. Springfield 1999-06-29T00:00:00 N N 1999-06-29T00:00:00 N 1999-06-10T00:00:00          
97 97 01-RC-21022 A 0 Manual MANL Initial Initi MA 10-11:00 a.m. Worcester 1999-07-02T00:00:00 N N 1999-07-02T00:00:00 N 1999-06-11T00:00:00          
98 98 01-RC-21023 A 0 Manual MANL Initial Initi VT 10:30-11:00 a.m. Vergennes 1999-07-02T00:00:00 N N 1999-07-02T00:00:00 N 1999-06-15T00:00:00          
99 99 01-RC-21024 A 0 Mail MAIL Initial Initi MA 10:00 a.m. Boston 1999-06-30T00:00:00 N N 1999-07-16T00:00:00 N 1999-06-24T00:00:00          
100 100 01-RC-21026 A 0 Manual MANL Initial Initi MA 6-9:00 a.m. & 3-5:00 p.m. Boston 1999-08-05T00:00:00 N N 1999-08-05T00:00:00 N 1999-07-13T00:00:00          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_elect_scheduled" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "election_mode" text,
    "election_type" text,
    "election_state" text,
    "election_time" text,
    "election_city" text,
    "schedule_date" text,
    "self_deter_election" text,
    "expedited_under_8b7" text,
    "scheduled_tally_date" text,
    "election_cancelled" text,
    "date_excelsior_list_due" text,
    "date_excelsior_list_received" text,
    "date_excelsior_list_sent" text,
    "date_eligible" text,
    "election_place" text,
    "additional_languages" text,
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id),
    FOREIGN KEY ([election_state]) REFERENCES[l_state] ([state]),
    FOREIGN KEY ([election_type]) REFERENCES[l_r_case_elect_type] ([election_type]),
    FOREIGN KEY ([election_mode]) REFERENCES[l_r_elect_mode] ([election_mode])
);