r_elect_certification

29,844 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ election_id cert_of_representative cert_of_results certified_bargaining_agent
1 1 01-00012 1999-11-17T00:00:00    
2 2 01-00026   1999-01-12T00:00:00  
3 3 01-00029 1999-01-27T00:00:00    
4 4 01-00034   1999-04-07T00:00:00  
5 5 01-00044 1999-10-01T00:00:00    
6 6 01-00045 1999-07-12T00:00:00    
7 7 01-00047   1999-03-08T00:00:00  
8 8 01-00048   1999-04-12T00:00:00  
9 9 01-00049 1999-03-09T00:00:00    
10 10 01-00050   1999-03-24T00:00:00  
11 11 01-00058   1999-06-10T00:00:00  
12 12 01-00060   1999-02-02T00:00:00  
13 13 01-00061   1999-02-02T00:00:00  
14 14 01-00062   1999-01-26T00:00:00  
15 15 01-00063 1999-03-24T00:00:00    
16 16 01-00065 1999-03-31T00:00:00    
17 17 01-00066 1999-02-08T00:00:00   Teamsters Union Local 59, a/w Internatio
18 18 01-00067 1999-04-05T00:00:00    
19 19 01-00068   1999-02-08T00:00:00  
20 20 01-00069 1999-04-12T00:00:00    
21 21 01-00070   1999-04-12T00:00:00  
22 22 01-00071   1999-05-05T00:00:00  
23 23 01-00072 1999-01-25T00:00:00    
24 24 01-00073 1999-02-01T00:00:00    
25 25 01-00074 1999-02-01T00:00:00    
26 26 01-00075 1999-01-25T00:00:00    
27 27 01-00076   1999-01-08T00:00:00  
28 28 01-00077 1999-01-22T00:00:00    
29 29 01-00078   1999-02-02T00:00:00  
30 30 01-00079   1999-02-01T00:00:00  
31 31 01-00080   1999-02-01T00:00:00  
32 32 01-00085 1999-01-25T00:00:00    
33 33 01-00086 1999-01-12T00:00:00    
34 34 01-00089 1999-04-26T00:00:00    
35 35 01-00092 1999-04-16T00:00:00    
36 36 01-00093 1999-04-19T00:00:00    
37 37 01-00094 1999-04-26T00:00:00    
38 38 01-00095   1999-04-27T00:00:00  
39 39 01-00096 1999-05-07T00:00:00    
40 40 01-00098   1999-05-03T00:00:00  
41 41 01-00100 1999-05-03T00:00:00    
42 42 01-00101 1999-05-03T00:00:00    
43 43 01-00102 1999-05-10T00:00:00    
44 44 01-00103 1999-05-18T00:00:00    
45 45 01-00104   1999-06-22T00:00:00  
46 46 01-00105 1999-05-18T00:00:00    
47 47 01-00106 1999-05-24T00:00:00    
48 48 01-00107   1999-05-26T00:00:00  
49 49 01-00108   1999-06-01T00:00:00  
50 50 01-00110   1999-06-07T00:00:00  
51 51 01-00111   1999-06-11T00:00:00  
52 52 01-00112 1999-06-14T00:00:00    
53 53 01-00113 1999-06-08T00:00:00    
54 54 01-00114   1999-06-14T00:00:00  
55 55 01-00115 1999-06-22T00:00:00    
56 56 01-00116   1999-06-22T00:00:00  
57 57 01-00117 1999-06-25T00:00:00    
58 58 01-00118   1999-06-28T00:00:00  
59 59 01-00119   1999-07-14T00:00:00  
60 60 01-00120 1999-07-07T00:00:00    
61 61 01-00121   1999-07-09T00:00:00  
62 62 01-00122 1999-07-09T00:00:00    
63 63 01-00124 2000-03-29T00:00:00   United Food & Commercial Workers International Union, AFL-CIO
64 64 01-00125   1999-07-12T00:00:00  
65 65 01-00126 1999-07-27T00:00:00    
66 66 01-00127 1999-07-16T00:00:00    
67 67 01-00129 1999-07-26T00:00:00    
68 68 01-00131 1999-02-26T00:00:00    
69 69 01-00132   1999-02-19T00:00:00  
70 70 01-00133   1999-02-19T00:00:00  
71 71 01-00134   1999-02-19T00:00:00  
72 72 01-00136 1999-08-03T00:00:00    
73 73 01-00137   1999-08-02T00:00:00  
74 74 01-00138   1999-08-04T00:00:00  
75 75 01-00139 1999-07-22T00:00:00    
76 76 01-00140 1999-08-04T00:00:00    
77 77 01-00141 1999-08-05T00:00:00    
78 78 01-00142   1999-08-09T00:00:00  
79 79 01-00144 1999-09-07T00:00:00    
80 80 01-00145 1999-08-17T00:00:00    
81 81 01-00146   1999-08-17T00:00:00  
82 82 01-00147 1999-08-24T00:00:00    
83 83 01-00148 1999-03-01T00:00:00    
84 84 01-00150 1999-03-01T00:00:00    
85 85 01-00151   1999-03-03T00:00:00  
86 86 01-00152 1999-02-22T00:00:00    
87 87 01-00153   1999-02-23T00:00:00  
88 88 01-00156 1999-09-07T00:00:00    
89 89 01-00157   1999-09-16T00:00:00  
90 90 01-00158   1999-09-20T00:00:00  
91 91 01-00159   1999-09-16T00:00:00  
92 92 01-00160   1999-09-20T00:00:00  
93 93 01-00161   1999-09-20T00:00:00  
94 94 01-00162   1999-09-27T00:00:00  
95 95 01-00163 1999-09-28T00:00:00    
96 96 01-00164   2000-01-18T00:00:00  
97 97 01-00165   1999-09-28T00:00:00  
98 98 01-00166 1999-10-04T00:00:00    
99 99 01-00167   1999-10-04T00:00:00  
100 100 01-00168 1999-10-04T00:00:00    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_elect_certification" (
    "election_id" text,
    "cert_of_representative" text,
    "cert_of_results" text,
    "certified_bargaining_agent" text,
    FOREIGN KEY (election_id) REFERENCES r_election (election_id)
);