r_pre_elect_hearing

56,031 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number unit_id action_sequence recurrence date_notice_issued date_hearing_scheduled date_rescheduled_issued length_of_transcript p_p_party p_p_determination p_p_rcvd_region p_p_response_date hearing_opened hearing_closed hearing_days_on_record hearing_off_rep_date hearing_time hearing_city hearing_state hearing_address
1 1 01-AC-00093 A 0 0 1999-12-28T00:00:00 2000-01-19T00:00:00                     10:00 a.m. Boston MA  
2 2 01-AC-00094 A 0 0 2001-07-11T00:00:00 2001-07-20T00:00:00   39         2001-07-20T00:00:00 2001-07-20T00:00:00 1 2001-07-23T00:00:00 10:00 a.m. Boston MA  
3 3 01-RC-19536 A 0 0 1991-04-24T00:00:00 1991-04-30T00:00:00             1991-04-30T00:00:00 1991-04-30T00:00:00            
4 4 01-RC-19910 A 0 0 1992-12-01T00:00:00                              
5 5 01-RC-19926 A 0 0 1993-01-19T00:00:00 1993-01-22T00:00:00             1993-01-22T00:00:00 1993-03-03T00:00:00 6 1993-03-03T00:00:00 10:00 a.m. Boston MA  
6 6 01-RC-19980 A 0 0 1993-06-21T00:00:00                              
7 7 01-RC-20080 A 0 0 1994-01-25T00:00:00 1994-01-28T00:00:00             1994-01-28T00:00:00 1994-02-04T00:00:00   1994-02-07T00:00:00 10:00 a.m. Boston MA  
8 8 01-RC-20106 A 0 0 1994-03-28T00:00:00 1994-03-31T00:00:00             1994-03-31T00:00:00 1994-03-31T00:00:00 1 1994-04-01T00:00:00        
9 9 01-RC-20309 A 0 0 1995-06-09T00:00:00 1995-06-19T00:00:00   418         1995-06-19T00:00:00 1995-07-19T00:00:00 10 1995-07-20T00:00:00 10:00 Boston MA  
10 10 01-RC-20310 A 0 0 1995-06-09T00:00:00 1995-06-19T00:00:00   418         1995-06-19T00:00:00 1995-07-19T00:00:00 10 1995-07-20T00:00:00 10:00 a.m. Boston MA  
11 11 01-RC-20460 A 0 0 1996-05-13T00:00:00 1996-05-24T00:00:00                     10:00 Boston MA  
12 12 01-RC-20463 A 0 0 1995-05-21T00:00:00 1996-06-02T00:00:00 1996-06-10T00:00:00           1996-06-10T00:00:00 1996-06-10T00:00:00 1 1996-06-11T00:00:00 10:00 a.m. Boston MA  
13 13 01-RC-20463 A 0 1   1996-06-10T00:00:00                     10:00 a.m. Boston MA  
14 14 01-RC-20467 A 0 0 1996-05-28T00:00:00 1996-06-11T00:00:00                     10:00 a.m. Boston MA  
15 15 01-RC-20508 A 0 0 1996-09-16T00:00:00 1996-09-30T00:00:00             1996-09-30T00:00:00 1996-09-30T00:00:00 1 1996-10-01T00:00:00        
16 16 01-RC-20538 A 0 0 1996-11-22T00:00:00 1996-12-05T00:00:00                     10:00 a.m. Boston MA  
17 17 01-RC-20574 A 0 0 1997-02-14T00:00:00 1997-03-18T00:00:00   2171         1997-03-18T00:00:00 1997-07-17T00:00:00 22 1997-07-18T00:00:00 10:00 Boston MA  
18 18 01-RC-20622 A 0 0 1997-05-14T00:00:00 1997-05-27T00:00:00                     10:00 a.m. Boston MA  
19 19 01-RC-20626 A 0 0 1997-05-27T00:00:00 1997-06-10T00:00:00                     10:00 a.m. Boston MA  
20 20 01-RC-20634 A 0 0 1997-06-04T00:00:00 1997-06-18T00:00:00                     10:00 a.m. Boston MA  
21 21 01-RC-20649 A 0 0 1997-07-11T00:00:00 1997-07-25T00:00:00                            
22 22 01-RC-20761 A 0 0 1998-01-30T00:00:00               1998-02-17T00:00:00 1998-02-18T00:00:00            
23 23 01-RC-20804 A 0 0 1998-03-19T00:00:00 1998-04-07T00:00:00   418         1998-04-07T00:00:00 1998-04-15T00:00:00 2 1998-04-15T00:00:00 10:00 a.m. Boston MA  
24 24 01-RC-20815 A 0 0 1998-04-02T00:00:00 1998-04-13T00:00:00                            
25 25 01-RC-20826 A 0 0 1998-04-23T00:00:00 1998-05-04T00:00:00                     10:00 a.m. Boston MA  
26 26 01-RC-20869 A 0 0 1998-07-21T00:00:00 1998-07-31T00:00:00                     10:00 Boston MA  
27 27 01-RC-20880 A 0 0 1998-08-13T00:00:00 1998-08-24T00:00:00                     10:00 a.m. Boston MA  
28 28 01-RC-20890 A 0 0 1998-08-31T00:00:00 1998-09-10T00:00:00                     10 Boston MA  
29 29 01-RC-20897 A 0 0 1998-09-18T00:00:00 1998-10-02T00:00:00                     10:00 a.m. Boston MA  
30 30 01-RC-20905 A 0 0 1998-10-02T00:00:00 1998-10-13T00:00:00 1998-10-09T00:00:00 301         1998-10-14T00:00:00 1998-10-14T00:00:00 1 1998-10-15T00:00:00 10 Boston MA  
31 31 01-RC-20905 A 0 1   1998-10-14T00:00:00                     10 Boston MA  
32 32 01-RC-20906 A 0 0 1998-10-02T00:00:00 1998-10-14T00:00:00                     10:00 a.m. Boston MA  
33 33 01-RC-20910 A 0 0 1998-10-13T00:00:00 1998-10-23T00:00:00 1998-10-22T00:00:00                   10:00 Boston MA  
34 34 01-RC-20910 A 0 1   1998-10-27T00:00:00                     10:00 Boston MA  
35 35 01-RC-20912 A 0 0 1998-10-15T00:00:00 1998-10-26T00:00:00 1998-10-19T00:00:00                   10 Boston MA  
36 36 01-RC-20912 A 0 1   1998-10-27T00:00:00                     10 Boston MA  
37 37 01-RC-20914 A 0 0 1998-10-22T00:00:00 1998-11-02T00:00:00 1998-10-29T00:00:00 900         1998-11-16T00:00:00 1998-11-16T00:00:00 1 1998-11-17T00:00:00 10:00 a.m. Boston MA  
38 38 01-RC-20915 A 0 0 1998-10-22T00:00:00 1998-11-02T00:00:00 1998-10-29T00:00:00 900         1998-11-16T00:00:00 1998-11-16T00:00:00 1 1998-11-17T00:00:00 10:00 a.m. Boston MA  
39 39 01-RC-20916 A 0 0 1998-10-22T00:00:00 1998-11-02T00:00:00                     10:00 a.m. Boston MA  
40 40 01-RC-20921 A 0 0 1998-10-27T00:00:00 1998-11-06T00:00:00 1998-11-06T00:00:00 358         1998-11-12T00:00:00 1998-11-16T00:00:00 3 1998-11-17T00:00:00 10:00 a.m. Boston MA  
41 41 01-RC-20921 A 0 1   1998-11-10T00:00:00                     10:00 a.m. Boston MA  
42 42 01-RC-20922 A 0 0 1998-10-29T00:00:00 1998-11-09T00:00:00                            
43 43 01-RC-20923 A 0 0 1998-10-29T00:00:00 1999-01-19T00:00:00                     10:00 a.m. Boston MA  
44 44 01-RC-20924 A 0 0 1998-10-29T00:00:00 1998-11-17T00:00:00                     10:00 a.m. Boston MA  
45 45 01-RC-20925 A 0 0 1998-10-30T00:00:00 1998-11-18T00:00:00   314         1998-11-18T00:00:00 1998-11-18T00:00:00 1 1998-11-19T00:00:00 10:00 Boston MA  
46 46 01-RC-20927 A 0 0 1998-11-03T00:00:00 1998-11-13T00:00:00   440         1998-11-17T00:00:00 1998-11-17T00:00:00 1 1998-11-19T00:00:00 10:00 Boston MA  
47 47 01-RC-20935 A 0 0 1999-03-26T00:00:00 1999-04-15T00:00:00                     10:00 a.m. Boston MA  
48 48 01-RC-20936 A 0 0 1998-11-23T00:00:00 1998-12-03T00:00:00                     10:00 Boston MA  
49 49 01-RC-20937 A 0 0 1998-11-23T00:00:00 1998-12-03T00:00:00                     10:00 a.m. Boston MA  
50 50 01-RC-20938 A 0 0 1998-11-24T00:00:00 1998-12-04T00:00:00 1998-12-02T00:00:00                   10:00 a.m. Boston MA  
51 51 01-RC-20938 A 0 1   1998-12-08T00:00:00                     10:00 a.m. Boston MA  
52 52 01-RC-20939 A 0 0 1998-11-25T00:00:00 1998-12-07T00:00:00                     10:00 Boston MA  
53 53 01-RC-20940 A 0 0 1998-11-25T00:00:00 1998-12-09T00:00:00   1000         1998-12-09T00:00:00 1998-12-18T00:00:00 3 1998-12-22T00:00:00 10:00 a.m. Boston MA  
54 54 01-RC-20941 A 0 0 1998-11-30T00:00:00 1998-12-11T00:00:00                     10:00 a.m. Boston MA  
55 55 01-RC-20942 A 0 0 1998-11-30T00:00:00 1998-12-10T00:00:00                     10:00 Boston MA  
56 56 01-RC-20943 A 0 0 1998-12-02T00:00:00 1998-12-12T00:00:00                     10:00 boston MA  
57 57 01-RC-20944 A 0 0 1998-12-03T00:00:00 1999-12-14T00:00:00                     10:00 Boston MA  
58 58 01-RC-20945 A 0 0 1998-12-04T00:00:00 1998-12-14T00:00:00 1998-12-11T00:00:00 50         1998-12-17T00:00:00 1998-12-17T00:00:00 1 1998-12-18T00:00:00 10:00 Boston MA  
59 59 01-RC-20945 A 0 1   1998-12-17T00:00:00                     10:00 Boston MA  
60 60 01-RC-20946 A 0 0 1998-12-07T00:00:00 1998-12-14T00:00:00 1998-12-11T00:00:00                   10 Boston MA  
61 61 01-RC-20946 A 0 1   1998-12-17T00:00:00                     10 Boston MA  
62 62 01-RC-20947 A 0 0 1998-12-08T00:00:00 1998-12-18T00:00:00             1998-12-18T00:00:00 1998-12-21T00:00:00   1998-12-22T00:00:00 10:00 a.m. Boston MA  
63 63 01-RC-20949 A 0 0 1998-12-09T00:00:00 1998-12-21T00:00:00   50         1998-12-21T00:00:00 1998-12-21T00:00:00 1 1998-12-21T00:00:00 10:00 Boston MA  
64 64 01-RC-20950 A 0 0 1998-12-16T00:00:00 1998-12-22T00:00:00                     10:00 Boston MA  
65 65 01-RC-20952 A 0 0 1998-12-10T00:00:00 1998-12-21T00:00:00                     10:00 am Boston MA  
66 66 01-RC-20953 A 0 0 1998-12-14T00:00:00 1998-12-24T00:00:00                     10:00 Boston MA  
67 67 01-RC-20955 A 0 0 1998-12-18T00:00:00 1998-12-30T00:00:00                     10:00 a.m. Boston MA  
68 68 01-RC-20956 A 0 0 1998-12-21T00:00:00 1998-12-31T00:00:00                     10:00 Boston MA  
69 69 01-RC-20957 A 0 0 1998-12-22T00:00:00               1999-01-04T00:00:00 1999-01-04T00:00:00            
70 70 01-RC-20958 A 0 0 1998-12-23T00:00:00 1999-01-04T00:00:00   251         1999-01-04T00:00:00 1999-01-05T00:00:00 2 1999-01-07T00:00:00 10:00 a.m. Boston MA  
71 71 01-RC-20959 A 0 0 1998-12-29T00:00:00 1999-01-08T00:00:00                     10:00 Boston MA  
72 72 01-RC-20960 A 0 0 1999-01-06T00:00:00 1999-01-19T00:00:00 1999-01-20T00:00:00 124         1999-01-20T00:00:00 1999-01-20T00:00:00 1 1999-01-21T00:00:00 10:00 a.m. Boston MA  
73 73 01-RC-20960 A 0 1   1999-01-20T00:00:00                     10:00 a.m. Boston MA  
74 74 01-RC-20964 A 0 0 1999-01-13T00:00:00 1999-01-25T00:00:00                     10:00 Boston MA  
75 75 01-RC-20966 A 0 0 1999-01-19T00:00:00 1999-01-29T00:00:00 1999-02-11T00:00:00                   10:00 a.m. Boston    
76 76 01-RC-20966 A 0 1   1999-02-16T00:00:00                     10:00 a.m. Boston    
77 77 01-RC-20968 A 0 0 1999-02-01T00:00:00 1999-02-11T00:00:00   97         1999-02-11T00:00:00 1999-02-11T00:00:00 1 1999-02-17T00:00:00 10:00 a.m. Boston MA  
78 78 01-RC-20969 A 0 0 1999-02-03T00:00:00 1999-02-12T00:00:00 1999-02-12T00:00:00 459         1999-02-17T00:00:00 1999-02-19T00:00:00 3 1999-02-22T00:00:00 10:00 a.m. Boston MA  
79 79 01-RC-20969 A 0 1   1999-02-17T00:00:00                     10:00 a.m. Boston MA  
80 80 01-RC-20970 A 0 0 1999-02-08T00:00:00 1999-02-18T00:00:00   180         1999-02-23T00:00:00 1999-03-01T00:00:00 2 1999-03-02T00:00:00 10:00 a.m. Boston MA  
81 81 01-RC-20970 A 0 1   1999-02-23T00:00:00                     10:00 a.m. Boston MA  
82 82 01-RC-20971 A 0 0 1999-02-09T00:00:00 1999-02-19T00:00:00   313         1999-02-19T00:00:00 1999-02-19T00:00:00 1 1999-02-22T00:00:00 10:00 a.m. Boston MA  
83 83 01-RC-20972 A 0 0 1999-02-17T00:00:00 1999-02-25T00:00:00                     10:00 a.m. Boston MA  
84 84 01-RC-20973 A 0 0 1999-02-18T00:00:00 1999-02-26T00:00:00                     10:00 Boston MA  
85 85 01-RC-20974 A 0 0 1999-02-17T00:00:00 1999-02-26T00:00:00                     10:00 a.m. Boston MA  
86 86 01-RC-20975 A 0 0 1999-02-17T00:00:00 1999-02-26T00:00:00 1999-03-01T00:00:00           1999-03-03T00:00:00 1999-03-03T00:00:00 1 1999-03-04T00:00:00 10:00 a.m. Boston MA  
87 87 01-RC-20975 A 0 1   1999-03-03T00:00:00                     10:00 a.m. Boston MA  
88 88 01-RC-20976 A 0 0 1999-02-23T00:00:00 1999-03-05T00:00:00                     10:00 Boston MA  
89 89 01-RC-20977 A 0 0 1999-02-23T00:00:00 1999-03-05T00:00:00                     10:00 a.m. Boston MA  
90 90 01-RC-20978 A 0 0 1999-02-25T00:00:00 1999-03-08T00:00:00 1999-03-02T00:00:00                   10:00 Boston MA  
91 91 01-RC-20978 A 0 1   1999-03-09T00:00:00                     10:00 Boston MA  
92 92 01-RC-20979 A 0 0 1999-02-25T00:00:00 1999-03-08T00:00:00                     10:00 Boston MA  
93 93 01-RC-20980 A 0 0 1999-03-02T00:00:00 1999-03-11T00:00:00                     10:00 A.M. Boston MA  
94 94 01-RC-20981 A 0 0 1999-03-02T00:00:00 1999-03-12T00:00:00                     10:00 a.m. Boston MA  
95 95 01-RC-20982 A 0 0 1999-03-02T00:00:00 1999-03-12T00:00:00                     10:00 Boston MA  
96 96 01-RC-20983 A 0 0 1999-03-03T00:00:00 1999-03-15T00:00:00   17         1999-03-15T00:00:00 1999-03-15T00:00:00 1 1999-03-15T00:00:00 10:00 Boston MA  
97 97 01-RC-20984 A 0 0 1999-03-04T00:00:00 1999-03-15T00:00:00 1999-03-10T00:00:00 1022         1999-03-19T00:00:00 1999-03-23T00:00:00 3 1999-03-25T00:00:00 10:00 Boston MA  
98 98 01-RC-20984 A 0 1   1999-03-19T00:00:00                     10:00 Boston MA  
99 99 01-RC-20984 A 1 0 2002-01-28T00:00:00 2002-02-06T00:00:00   1022         2002-02-06T00:00:00 2002-03-04T00:00:00 5 2002-03-22T00:00:00 10:00 Portland ME  
100 100 01-RC-20985 A 0 0 1999-03-12T00:00:00 1999-03-22T00:00:00 1999-03-22T00:00:00 264         1999-03-29T00:00:00 1999-03-30T00:00:00 2 1999-04-01T00:00:00 10:00 Boston MA  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_pre_elect_hearing" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "recurrence" integer,
    "date_notice_issued" text,
    "date_hearing_scheduled" text,
    "date_rescheduled_issued" text,
    "length_of_transcript" integer,
    "p_p_party" text,
    "p_p_determination" text,
    "p_p_rcvd_region" text,
    "p_p_response_date" text,
    "hearing_opened" text,
    "hearing_closed" text,
    "hearing_days_on_record" integer,
    "hearing_off_rep_date" text,
    "hearing_time" text,
    "hearing_city" text,
    "hearing_state" text,
    "hearing_address" text,
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id),
    FOREIGN KEY ([p_p_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([hearing_state]) REFERENCES[l_state] ([state]),
    FOREIGN KEY ([p_p_determination]) REFERENCES[l_r_preelec_hear_det_p_p] ([determination_request_p_p])
);