c_hearing

69,580 rows

✎ View and edit SQL

Link c_case_number hearing_type action_sequence recurrence scheduled_hearing_date hearing_opened hearing_closed record_form date_notice_issued date_rescheduled_issued p_p_rcvd_region p_p_deter_source p_p_determination p_p_party p_p_deter_date hearing_days_on_record length_of_transcript hearing_time hearing_city hearing_state hearing_address
1 01-CA-19224-001 ULP 0 0 1984-01-30T00:00:00 1984-01-30T00:00:00 1988-01-19T00:00:00   1983-12-07T00:00:00                 10:00 a.m. Boston MA  
2 01-CA-19567-001 ULP 0 0 1984-01-30T00:00:00 1984-01-30T00:00:00 1988-01-19T00:00:00                            
3 01-CA-19690-001 ULP 0 0 1984-01-30T00:00:00 1984-01-30T00:00:00 1988-01-19T00:00:00                            
4 01-CA-19731-001 ULP 0 0   1982-12-06T00:00:00 1983-03-03T00:00:00                            
5 01-CA-19797-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
6 01-CA-19903-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
7 01-CA-19958-001 ULP 0 0   1984-01-30T00:00:00 1988-01-19T00:00:00   1983-12-07T00:00:00                        
8 01-CA-20007-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
9 01-CA-20157-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
10 01-CA-20218-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
11 01-CA-20283-001 ULP 0 0 1984-01-30T00:00:00 1984-01-30T00:00:00 1988-01-19T00:00:00                            
12 01-CA-20291-001 ULP 0 0   1984-01-30T00:00:00 1988-01-19T00:00:00                            
13 01-CA-20304-001 ULP 0 0 1984-01-30T00:00:00 1984-01-30T00:00:00 1988-01-19T00:00:00   1983-12-07T00:00:00                        
14 01-CA-20442-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
15 01-CA-20508-001 ULP 0 0   1984-01-30T00:00:00 1988-01-19T00:00:00                            
16 01-CA-20521-001 ULP 0 0   1988-12-13T00:00:00 1988-12-13T00:00:00                            
17 01-CA-21438-001 ULP 0 0   1984-04-23T00:00:00 1984-04-23T00:00:00                            
18 01-CA-21560-001 ULP 0 0   1984-01-30T00:00:00 1988-01-19T00:00:00                            
19 01-CA-21943-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
20 01-CA-22040-002 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
21 01-CA-22687-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1985-03-18T00:00:00                        
22 01-CA-22769-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1985-04-19T00:00:00                        
23 01-CA-22869-001 ULP 0 0   1989-01-23T00:00:00 1991-01-22T00:00:00   1985-12-09T00:00:00                        
24 01-CA-23307-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
25 01-CA-23427-001 ULP 0 0 1989-01-09T00:00:00 1989-01-09T00:00:00 1989-01-09T00:00:00 Trans 1986-01-03T00:00:00 1989-01-09T00:00:00               10:00 a.m. Boston MA  
26 01-CA-23576-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1986-04-30T00:00:00                        
27 01-CA-23748-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
28 01-CA-24161-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
29 01-CA-24372-001 ULP 0 0   1987-05-14T00:00:00 1987-05-14T00:00:00   1987-01-09T00:00:00                 10:00 2/19/1987 MA  
30 01-CA-24390-002 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
31 01-CA-24528-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
32 01-CA-24863-001 ULP 0 0 1987-11-30T00:00:00 1988-01-25T00:00:00 1988-01-27T00:00:00 Trans 1987-10-06T00:00:00                        
33 01-CA-24863-001 ULP 0 1 1988-01-25T00:00:00                                
34 01-CA-24883-001 ULP 0 0 1987-11-30T00:00:00 1988-01-25T00:00:00 1988-01-27T00:00:00 Trans 1987-10-06T00:00:00                        
35 01-CA-24883-001 ULP 0 1 1988-01-25T00:00:00                                
36 01-CA-24921-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
37 01-CA-24967-001 ULP 0 0 1992-03-02T00:00:00       1990-09-27T00:00:00                 10:00 a.m. Boston MA  
38 01-CA-25033-001 ULP 0 0 1992-03-02T00:00:00       1988-01-29T00:00:00                 10:00 a.m. Boston MA  
39 01-CA-25237-001 ULP 0 0 1992-03-02T00:00:00       1988-06-16T00:00:00                 10:00 a.m. Boston MA  
40 01-CA-25237-002 ULP 0 0 1992-03-02T00:00:00       1988-06-16T00:00:00                 10:00 a.m. Boston MA  
41 01-CA-25341-001 ULP 0 0 1992-03-02T00:00:00       1988-06-16T00:00:00                 10:00 a.m. Boston MA  
42 01-CA-25521-001 ULP 0 0 1988-11-16T00:00:00 1991-04-02T00:00:00 1991-04-04T00:00:00   1988-07-18T00:00:00 1990-01-14T00:00:00                      
43 01-CA-25521-001 ULP 0 1 1991-04-02T00:00:00                                
44 01-CA-25599-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1988-08-17T00:00:00                        
45 01-CA-25599-001 ULP 1 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00                            
46 01-CA-25599-001 ULP 2 0   1989-01-23T00:00:00 1991-01-22T00:00:00                            
47 01-CA-25656-001 ULP 0 0 1989-11-13T00:00:00 1989-11-02T00:00:00 1989-11-15T00:00:00                            
48 01-CA-25736-001 ULP 0 0 1989-02-14T00:00:00 1989-02-14T00:00:00 1989-02-14T00:00:00   1988-09-29T00:00:00                        
49 01-CA-25805-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1988-11-18T00:00:00                        
50 01-CA-25805-001 ULP 1 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00                            
51 01-CA-25864-001 ULP 0 0 1991-04-02T00:00:00 1991-04-02T00:00:00 1991-04-04T00:00:00   1989-01-31T00:00:00                        
52 01-CA-25867-001 ULP 0 0 1992-03-02T00:00:00       1988-12-16T00:00:00                 10:00 a.m. Boston MA  
53 01-CA-25896-001 ULP 0 0 1989-01-23T00:00:00 1989-01-23T00:00:00 1991-01-22T00:00:00   1989-01-23T00:00:00                        
54 01-CA-25896-001 ULP 1 0 1989-01-23T00:00:00                                
55 01-CA-25940-001 ULP 0 0 1989-12-18T00:00:00 1990-02-20T00:00:00 1990-02-22T00:00:00   1989-09-11T00:00:00                        
56 01-CA-25940-001 ULP 0 1 1990-02-20T00:00:00                                
57 01-CA-25969-001 Compl 0 0 1998-01-06T00:00:00 1998-01-06T00:00:00 1998-01-06T00:00:00 Trans 1997-07-30T00:00:00                 10:00 a.m. Boston MA  
58 01-CA-25969-001 ULP 0 0 1989-06-21T00:00:00 1989-06-21T00:00:00 1989-08-09T00:00:00 Trans 1989-01-20T00:00:00                 10:00 a.m. Boston MA  
59 01-CA-26144-001 ULP 0 0   1989-11-02T00:00:00 1989-11-15T00:00:00                            
60 01-CA-26144-001 ULP 0 1   1989-11-02T00:00:00 1989-11-15T00:00:00                            
61 01-CA-26144-001 ULP 1 0   1989-11-02T00:00:00 1989-11-15T00:00:00                            
62 01-CA-26183-001 ULP 0 0 1989-07-17T00:00:00                                
63 01-CA-26232-001 ULP 0 0 1989-08-17T00:00:00       1989-05-23T00:00:00                        
64 01-CA-26232-001 ULP 0 1 1990-10-29T00:00:00                                
65 01-CA-26237-001 ULP 0 0 1989-08-17T00:00:00       1989-05-23T00:00:00                        
66 01-CA-26237-001 ULP 0 1 1990-10-29T00:00:00                                
67 01-CA-26270-001 ULP 0 0 1989-07-17T00:00:00                                
68 01-CA-26353-001 ULP 0 0 1989-07-17T00:00:00                                
69 01-CA-26463-001 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00 Trans                          
70 01-CA-26463-002 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00 Trans                          
71 01-CA-26463-003 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00 Trans                          
72 01-CA-26463-004 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00                            
73 01-CA-26463-005 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00 Trans                          
74 01-CA-26463-006 ULP 0 0   1990-02-06T00:00:00 1990-04-10T00:00:00 Trans                          
75 01-CA-26573-001 ULP 0 0 1990-02-28T00:00:00 1990-03-19T00:00:00 1990-06-14T00:00:00 Trans 1989-10-27T00:00:00                 10:00 a.m. Boston MA  
76 01-CA-26575-001 ULP 0 0 1989-01-29T00:00:00       1989-10-06T00:00:00                 10:00 .am. Boston MA  
77 01-CA-26744-001 ULP 0 0 1990-06-04T00:00:00 1990-06-04T00:00:00 1990-06-08T00:00:00 Trans 1989-12-26T00:00:00               100 10:00 a.m. Boston MA  
78 01-CA-26820-001 ULP 0 0 1991-10-21T00:00:00 1991-10-21T00:00:00 1991-10-21T00:00:00 Trans 1991-04-11T00:00:00               50 10:00 a.m. Boston MA  
79 01-CA-26936-001 ULP 0 0 1990-12-03T00:00:00                                
80 01-CA-27014-001 ULP 0 0 1990-07-10T00:00:00 1990-07-10T00:00:00 1990-07-10T00:00:00   1990-03-05T00:00:00                        
81 01-CA-27070-001 ULP 0 0 1990-06-12T00:00:00 1990-06-12T00:00:00 1990-06-14T00:00:00 Trans 1990-04-30T00:00:00                 TBD Boston MA  
82 01-CA-27142-001 ULP 0 0 1991-09-23T00:00:00       1991-03-22T00:00:00                 10:00 a.m. Boston MA  
83 01-CA-27321-001 Compl 0 0 1992-08-26T00:00:00                                
84 01-CA-27321-001 ULP 0 0 1990-11-28T00:00:00                                
85 01-CA-27322-001 ULP 0 0 1991-09-12T00:00:00 1991-09-12T00:00:00 1991-09-12T00:00:00                            
86 01-CA-27322-001 ULP 0 1 1991-09-12T00:00:00                                
87 01-CA-27335-001 ULP 0 0 1990-11-28T00:00:00 1993-03-29T00:00:00     1990-07-06T00:00:00                        
88 01-CA-27335-001 ULP 0 1 1991-04-15T00:00:00                                
89 01-CA-27335-001 ULP 0 2 1991-05-06T00:00:00                                
90 01-CA-27335-001 ULP 0 3 1992-09-28T00:00:00                                
91 01-CA-27335-001 ULP 0 4 1993-03-29T00:00:00                                
92 01-CA-27335-001 ULP 0 5 1993-03-10T00:00:00                                
93 01-CA-27385-001 ULP 0 0 1991-09-12T00:00:00 1991-09-12T00:00:00 1991-09-12T00:00:00                            
94 01-CA-27385-001 ULP 0 1 1991-09-12T00:00:00                                
95 01-CA-27386-001 ULP 0 0 1991-09-12T00:00:00 1991-09-12T00:00:00 1991-09-12T00:00:00                            
96 01-CA-27421-001 ULP 0 0 1991-02-11T00:00:00       1990-08-29T00:00:00                 10:00 Boston MA  
97 01-CA-27421-001 ULP 0 1 1991-08-26T00:00:00                         10:00 Boston MA  
98 01-CA-27491-001 ULP 0 0         1990-10-30T00:00:00                        
99 01-CA-27659-001 ULP 0 0 1991-08-26T00:00:00       1990-12-12T00:00:00                 10:00 Boston MA  
100 01-CA-27731-001 ULP 0 0 1991-05-28T00:00:00       1990-11-30T00:00:00                 11:00 a.m. Boston MA  

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE "c_hearing" (
    "c_case_number" text,
    "hearing_type" text,
    "action_sequence" integer,
    "recurrence" integer,
    "scheduled_hearing_date" text,
    "hearing_opened" text,
    "hearing_closed" text,
    "record_form" text,
    "date_notice_issued" text,
    "date_rescheduled_issued" text,
    "p_p_rcvd_region" text,
    "p_p_deter_source" text,
    "p_p_determination" text,
    "p_p_party" text,
    "p_p_deter_date" text,
    "hearing_days_on_record" integer,
    "length_of_transcript" integer,
    "hearing_time" text,
    "hearing_city" text,
    "hearing_state" text,
    "hearing_address" text
);