c_board_decision
17,317 rows
Suggested facets: action_sequence, exceptions_eot_party_filing, exceptions_eot_determination, determination, transfer_order_date (date), exception_due_date (date), exceptions_eot_date_filed (date), exceptions_eot_deter_date (date), oral_arg_req (date), oral_arg_sch_date (date), exceptions_date_filed (date), decision_date (date), date_received_region (date), request_date (date), request_deter_date (date)
| c_case_number | action_sequence | recurrence | transfer_order_date | exception_due_date | exceptions_eot_date_filed | exceptions_eot_party_filing | exceptions_eot_deter_date | exceptions_eot_determination | oral_arg_req | oral_argument_req_party | oral_arg_order_date | oral_arg_sch_date | oral_arg_date | exceptions_date_filed | decision_date | date_received_region | determination | citation | request_date | request_party | request_deter_date | request_determination | motion_eot_date_filed | motion_eot_party_filing | motion_eot_deter_date | motion_eot_determination |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1989-04-05 | 1990-08-28 | WinP | |||||||||||||||||||||
| 01-CA-19224-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-19567-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-19567-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-19690-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-19690-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-19958-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-19958-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-20283-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-20283-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-20291-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-20291-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-20304-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-20304-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-20508-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-20508-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-21560-001 | 0 | 0 | 1983-04-05 | 1999-07-28 | 1990-08-28 | |||||||||||||||||||||
| 01-CA-21560-001 | 1 | 0 | 1996-08-16 | Loss | ||||||||||||||||||||||
| 01-CA-22687-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-22769-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-22869-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-23427-001 | 0 | 0 | 1986-04-10 | 1986-08-11 | 1986-08-11 | WinF | 281 NLRB No. 9 | |||||||||||||||||||
| 01-CA-23427-001 | 1 | 0 | 1989-05-02 | WinF | ||||||||||||||||||||||
| 01-CA-23576-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-24372-001 | 0 | 0 | 1987-11-18 | WinF | ||||||||||||||||||||||
| 01-CA-25521-001 | 0 | 0 | 1991-12-10 | 1991-12-09 | 1993-10-15 | Loss | ||||||||||||||||||||
| 01-CA-25599-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-25656-001 | 0 | 0 | 1990-08-30 | WinF | 1990-09-10 | CHP | 1990-09-13 | |||||||||||||||||||
| 01-CA-25736-001 | 0 | 0 | 1989-03-29 | 1989-04-26 | WinF | |||||||||||||||||||||
| 01-CA-25805-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-25864-001 | 0 | 0 | 1991-12-10 | 1991-12-09 | 1993-10-15 | Loss | ||||||||||||||||||||
| 01-CA-25896-001 | 0 | 0 | 1996-07-15 | WinF | ||||||||||||||||||||||
| 01-CA-25940-001 | 0 | 0 | 1991-07-16 | 1991-07-23 | 1992-04-27 | WinF | ||||||||||||||||||||
| 01-CA-25969-001 | 0 | 0 | 1989-11-24 | 1991-06-27 | 1991-06-30 | WinF | ||||||||||||||||||||
| 01-CA-26144-001 | 0 | 0 | 1990-08-30 | WinF | 1990-09-10 | CHP | 1990-09-13 | |||||||||||||||||||
| 01-CA-26183-001 | 0 | 0 | 1992-07-22 | 1992-08-14 | WinF | |||||||||||||||||||||
| 01-CA-26270-001 | 0 | 0 | 1992-07-22 | 1992-08-14 | WinF | |||||||||||||||||||||
| 01-CA-26353-001 | 0 | 0 | 1992-07-22 | 1992-08-14 | 1992-08-17 | WinF | ||||||||||||||||||||
| 01-CA-26463-001 | 0 | 0 | 1991-05-28 | 1991-05-28 | 1992-02-28 | WinF | ||||||||||||||||||||
| 01-CA-26463-001 | 1 | 0 | 1994-07-13 | 1995-08-18 | WinF | |||||||||||||||||||||
| 01-CA-26463-002 | 0 | 0 | 1991-05-28 | 1991-05-28 | 1992-02-28 | WinF | ||||||||||||||||||||
| 01-CA-26463-002 | 1 | 0 | 1994-07-13 | 1995-08-18 | WinF | |||||||||||||||||||||
| 01-CA-26463-003 | 0 | 0 | 1991-05-28 | 1992-02-28 | WinF | |||||||||||||||||||||
| 01-CA-26463-003 | 1 | 0 | 1994-07-13 | 1995-08-18 | WinF | |||||||||||||||||||||
| 01-CA-26463-004 | 0 | 0 | 1992-02-28 | Loss | ||||||||||||||||||||||
| 01-CA-26463-005 | 0 | 0 | 1992-02-28 | WinF | ||||||||||||||||||||||
| 01-CA-26463-006 | 0 | 0 | 1992-02-28 | Loss | ||||||||||||||||||||||
| 01-CA-26573-001 | 0 | 0 | 1991-04-26 | 1991-05-30 | 1991-12-20 | 1991-12-24 | Loss | 305 NLRB No. 125 | ||||||||||||||||||
| 01-CA-26573-001 | 0 | 1 | 1991-05-30 | |||||||||||||||||||||||
| 01-CA-26575-001 | 0 | 0 | 1990-01-05 | 1990-04-16 | WinF | 298 NLRB No. 23 | ||||||||||||||||||||
| 01-CA-26575-001 | 1 | 0 | 1993-06-02 | 1993-09-17 | WinF | 302 NLRB No. 47 | ||||||||||||||||||||
| 01-CA-26744-001 | 0 | 0 | 1993-10-29 | 1993-11-26 | 1993-12-22 | 1994-10-31 | 1994-11-01 | Loss | 315 NLRB 60 | |||||||||||||||||
| 01-CA-26820-001 | 0 | 0 | 1992-06-03 | 1992-07-01 | 1992-07-30 | 1992-07-31 | Loss | |||||||||||||||||||
| 01-CA-26936-001 | 0 | 0 | 1991-02-19 | 1991-05-30 | WinF | |||||||||||||||||||||
| 01-CA-27014-001 | 0 | 0 | 1990-09-11 | 1990-09-12 | WinF | |||||||||||||||||||||
| 01-CA-27070-001 | 0 | 0 | 1991-04-26 | 1991-05-30 | 1991-12-20 | 1991-12-24 | WinF | 305 NLRB No. 125 | ||||||||||||||||||
| 01-CA-27070-001 | 0 | 1 | 1991-05-30 | |||||||||||||||||||||||
| 01-CA-27142-001 | 0 | 0 | 1991-12-24 | 1992-03-25 | WinF | NLRB | ||||||||||||||||||||
| 01-CA-27321-001 | 0 | 0 | 1990-10-18 | 1990-12-11 | WinF | |||||||||||||||||||||
| 01-CA-27322-001 | 0 | 0 | 1991-11-20 | 1991-12-16 | 1991-11-08 | Remnd | ||||||||||||||||||||
| 01-CA-27322-001 | 1 | 0 | 1991-11-20 | 1991-12-31 | WinF | |||||||||||||||||||||
| 01-CA-27385-001 | 0 | 0 | 1991-10-09 | 1991-11-08 | 1991-11-12 | Remnd | ||||||||||||||||||||
| 01-CA-27385-001 | 1 | 0 | 1991-11-20 | 1991-12-31 | WinF | |||||||||||||||||||||
| 01-CA-27386-001 | 0 | 0 | 1991-10-09 | 1991-11-08 | 1991-11-12 | Remnd | ||||||||||||||||||||
| 01-CA-27386-001 | 1 | 0 | 1991-11-20 | 1991-12-31 | WinF | |||||||||||||||||||||
| 01-CA-27506-001 | 0 | 0 | 1991-12-23 | 1992-03-09 | 1992-03-09 | WinF | ||||||||||||||||||||
| 01-CA-27731-001 | 0 | 0 | 1991-04-25 | 1991-07-18 | WinF | |||||||||||||||||||||
| 01-CA-27800-001 | 0 | 0 | 1994-05-06 | 1994-06-02 | 1994-06-27 | WinF | ||||||||||||||||||||
| 01-CA-27879-001 | 0 | 0 | 1993-10-12 | 1993-10-28 | 1993-10-28 | WinP | ||||||||||||||||||||
| 01-CA-27908-001 | 0 | 0 | 1992-03-30 | 1992-04-30 | 1992-05-01 | WinF | 999999 | |||||||||||||||||||
| 01-CA-27953-001 | 0 | 0 | 1991-10-09 | 1991-11-08 | 1991-11-12 | Remnd | ||||||||||||||||||||
| 01-CA-27953-001 | 1 | 0 | 1991-11-20 | 1991-12-31 | WinF | |||||||||||||||||||||
| 01-CA-28250-001 | 0 | 0 | 1992-01-31 | 1992-02-01 | WinF | 306 NLRB No. 51 | ||||||||||||||||||||
| 01-CA-28264-001 | 0 | 0 | 1991-11-14 | 1992-01-10 | 1992-01-15 | Other | ||||||||||||||||||||
| 01-CA-28315-001 | 0 | 0 | 1993-03-12 | 1993-04-07 | WinF | |||||||||||||||||||||
| 01-CA-28375-001 | 0 | 0 | 1993-03-24 | 1993-05-28 | 1994-02-28 | 1994-03-02 | WinF | NLRB No. | ||||||||||||||||||
| 01-CA-28409-001 | 0 | 0 | 1993-02-22 | 1993-03-12 | 1993-04-07 | WinF | ||||||||||||||||||||
| 01-CA-28418-001 | 0 | 0 | 1992-12-01 | 1992-12-29 | 1996-08-27 | 1996-08-31 | WinF | 321 NLRB No. 178 | ||||||||||||||||||
| 01-CA-28474-001 | 0 | 0 | 1992-02-11 | 1992-03-25 | 1992-03-31 | WinF | ||||||||||||||||||||
| 01-CA-28590-001 | 0 | 0 | 1992-12-01 | 1992-12-29 | 1996-08-27 | 1996-08-31 | WinF | 321 NLRB No. 178 | ||||||||||||||||||
| 01-CA-28866-001 | 0 | 0 | 1992-06-12 | 1992-07-13 | 1992-07-15 | WinF | 307 NLRB NO.187 | |||||||||||||||||||
| 01-CA-28935-001 | 0 | 0 | 1992-05-22 | 1992-07-24 | WinF | |||||||||||||||||||||
| 01-CA-28985-001 | 0 | 0 | 1992-10-23 | 1992-12-07 | 1992-12-21 | WinF | Unknown | |||||||||||||||||||
| 01-CA-29051-001 | 0 | 0 | 1993-03-24 | 1993-05-28 | 1994-02-28 | 1994-03-02 | WinF | NLRB No. | ||||||||||||||||||
| 01-CA-29153-001 | 0 | 0 | 1992-06-24 | 1992-07-22 | WinF | 307 NLRB No. 218 | ||||||||||||||||||||
| 01-CA-29153-001 | 1 | 0 | 1993-06-02 | 1993-09-17 | WinF | 312 NLRB No. 37 | ||||||||||||||||||||
| 01-CA-29179-001 | 0 | 0 | 1994-02-08 | 1994-02-16 | 1994-10-24 | WinF | ||||||||||||||||||||
| 01-CA-29220-001 | 0 | 0 | 1992-07-27 | 1992-08-25 | 1992-08-28 | WinF | ||||||||||||||||||||
| 01-CA-29224-001 | 0 | 0 | 1994-02-08 | 1994-10-24 | WinF | |||||||||||||||||||||
| 01-CA-29252-001 | 0 | 0 | 1992-08-12 | 1992-11-30 | 1992-12-01 | WinF | 309 NLRB NO. 107 | |||||||||||||||||||
| 01-CA-29367-001 | 0 | 0 | 1992-08-11 | 1992-08-31 | 1992-09-04 | WinF | ||||||||||||||||||||
| 01-CA-29406-001 | 0 | 0 | 1993-03-03 | 1993-04-05 | WinF | |||||||||||||||||||||
| 01-CA-29414-001 | 0 | 0 | 1994-02-08 | 1994-10-24 | WinF | |||||||||||||||||||||
| 01-CA-29433-001 | 0 | 0 | 1995-04-28 | 1995-04-30 | WinF | 317 NLRB No. 32 | ||||||||||||||||||||
| 01-CA-29434-001 | 0 | 0 | 1995-04-28 | 1995-04-30 | WinF | 317 NLRB No. 32 | ||||||||||||||||||||
| 01-CA-29445-001 | 0 | 0 | 1993-06-11 | 1993-09-20 | 1993-09-22 | WinF | 312 NLRB No. 40 | |||||||||||||||||||
| 01-CA-29557-001 | 0 | 0 | 1993-06-21 | 1993-09-07 | 1993-09-10 | WinF | ||||||||||||||||||||
| 01-CA-29621-001 | 0 | 0 | 1994-06-30 | 1994-07-28 | 1994-08-19 | 1996-07-17 | 1996-07-20 | WinP | 321 NLRB 761 | |||||||||||||||||
| 01-CA-29649-001 | 0 | 0 | 1993-06-21 | 1993-09-07 | 1993-09-10 | WinF | ||||||||||||||||||||
| 01-CA-29676-001 | 0 | 0 | 1993-04-21 | 1993-05-20 | WinF |
Table schema
CREATE TABLE c_board_decision(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, transfer_order_date DATE, exception_due_date DATE, exceptions_eot_date_filed DATE, exceptions_eot_party_filing VARCHAR, exceptions_eot_deter_date DATE, exceptions_eot_determination VARCHAR, oral_arg_req DATE, oral_argument_req_party VARCHAR, oral_arg_order_date VARCHAR, oral_arg_sch_date DATE, oral_arg_date VARCHAR, exceptions_date_filed DATE, decision_date DATE, date_received_region DATE, determination VARCHAR, citation VARCHAR, request_date DATE, request_party VARCHAR, request_deter_date DATE, request_determination VARCHAR, motion_eot_date_filed VARCHAR, motion_eot_party_filing VARCHAR, motion_eot_deter_date VARCHAR, motion_eot_determination VARCHAR);