c_formal3

6,603 rows

✎ View and edit SQL

Suggested facets: consol_type, consol_code, update_control, type_ref, date_pet_answ_filed, date_ref_pet_answ, date_ca_opinion, type_disposition, ca_no, type_decree, control_case, code_date_brief_filed, cf3_date (date), date_last_action (date), date_ref_app_ct (date), date_pet_answ_filed (date), date_ref_pet_answ (date), date_ca_opinion (date), date_brief_filed (date), date_ca_decree (date)

case_number cf3_date date_last_action consol_type consol_code update_control date_ref_app_ct type_ref date_pet_answ_filed date_ref_pet_answ date_ca_opinion date_brief_filed type_disposition ca_no date_ca_decree type_decree control_case card_control code_date_brief_filed
01-CA-022977-001 1990-10-10 1991-07-15 1 E 3 1990-10-10 2       1991-07-15 2   1991-07-15 6   4 1
01-CA-023094-001 1988-10-06 1989-06-20     3 1988-10-06 2       1989-06-20 2         4 1
01-CA-023208-001 1987-02-20 1987-03-24     4 1987-02-20 8             1987-03-24 8   4  
01-CA-023325-001 1986-06-26 1987-04-21     4 1986-06-26 2       1986-12-22 3 1 1987-04-21     4 0
01-CA-023395-001 1990-10-10 1991-07-15 1 E 3 1990-10-10 2       1991-07-15 2   1991-07-15 6   4 1
01-CA-023472-001 1987-10-05 1987-10-05     1 1987-10-05 2                   4  
01-CA-023549-001 1987-11-27 1987-11-27 1 A 1 1987-11-27 2                   4  
01-CA-023594-001 1987-11-27 1987-11-27 1 E 1 1987-11-27 2                   4  
01-CA-023817-001 1988-02-03 1988-02-03 1 A 1 1988-02-03 2                   4  
01-CA-023839-001 1988-02-03 1988-02-03 1 E 1 1988-02-03 2                   4  
01-CA-023906-001 1987-11-27 1988-09-12 1 A 4 1987-11-27 2       1988-06-01 3 1 1988-09-12 2   4 0
01-CA-023953-001 1987-12-14 1988-07-13 1 A 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
01-CA-023966-001 1987-12-14 1988-07-13 1 E 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
01-CA-023967-001 1988-01-07 1988-01-07     1 1988-01-07 2                   4  
01-CA-023980-001 1988-01-07 1988-01-07     1 1988-01-07 2                   4  
01-CA-023996-001 1988-02-03 1988-02-03 1 E 1 1988-02-03 2                   4  
01-CA-024152-001 1987-12-14 1988-07-13 1 E 4 1987-12-14 4       1988-04-14 3 3 1988-07-13 2   4 0
01-CA-024178-001 1987-11-27 1988-09-12 1 E 4 1987-11-27 2       1988-06-01 3 1 1988-09-12 2   4 0
01-CA-024311-001 1987-07-17 1987-09-30     4 1987-07-17 8             1987-09-30     4  
01-CA-024421-001 1988-05-06 1990-07-31     3 1988-05-06 2       1990-07-31 2         4 1
01-CA-024543-001 1988-09-23 1989-09-22 1 J 4 1988-09-23 2       1989-01-19 3 1 1989-09-22 5   4 0
01-CA-024571-001 1988-01-14 1988-11-08     4 1988-01-14 2       1988-08-05 3 1 1988-11-08 2   4 0
01-CA-024705-001 1989-10-04 1989-12-01     3 1989-10-04 2       1989-12-01 2         4 1
01-CA-024958-001 1990-09-12 1991-02-28     3 1990-09-12 2       1991-02-28 2         4 1
01-CA-024992-001 1990-12-04 1991-06-12     3 1990-12-04 2       1991-06-12 2         4 1
01-CA-024992-001 1993-01-25 1993-02-24     3 1993-01-25 8       1993-02-24 2   1993-02-24 1   4 1
01-CA-025070-001 1988-11-28 1988-11-28     1 1988-11-28 2                   4  
01-CA-025192-001 1988-12-05 1988-12-05     1 1988-12-05 2                   4  
01-CA-025221-001 1995-06-05 1995-08-07     3 1995-06-05 2       1995-08-07 2         4 1
01-CA-025327-001 1989-06-20 1990-04-16     4 1989-06-20 2       1989-10-19 3   1990-04-16 2   4 0
01-CA-025375-001 1991-03-14 1991-10-15     3 1991-03-14 1       1991-10-15 2   1991-10-15 8   4 1
01-CA-025405-001 1989-02-03 1990-04-23     4 1989-02-03 2       1989-10-20 3   1990-04-23 2   4 0
01-CA-025698-001 1991-04-16 1992-03-19     4 1991-04-16 4       1991-11-07 3   1992-03-19 5   4 0
01-CA-025736-001 1990-09-12 1991-04-08     3 1990-09-12 1       1991-04-08 2   1991-04-08 8   4 1
01-CA-025737-001 1992-04-20 1992-08-12     3 1992-04-20 1       1992-08-12 2   1992-08-12 8   4 1
01-CA-025779-001 1989-12-27 1990-03-27     3 1989-12-27 1       1990-03-27 2   1990-03-27 8   4 1
01-CA-025940-001 1992-06-11 1993-02-22     4 1992-06-11 4       1992-08-24 3   1993-02-22 4   4 0
01-CA-025980-001 1989-09-25 1990-06-28     4 1989-09-25 4       1990-02-12 3   1990-06-28 2   4 0
01-CA-026069-001 1992-10-29 1993-11-17 1 N 4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
01-CA-026203-001 1989-12-06 1990-11-26     4 1989-12-06 2       1990-06-19 3   1990-11-26 2   4 0
01-CA-026214-001 1992-10-29 1993-11-17     4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
01-CA-026372-001 1991-05-03 1991-07-12     3 1991-05-03 2       1991-07-12 2         4 1
01-CA-026403-001 1990-01-05 1990-05-11     3 1990-01-05 1       1990-05-11 2   1990-05-11 8   4 1
01-CA-026403-001 1991-05-30 1991-12-17     3 1991-05-30 1       1991-12-17 2   1991-12-17 8   4 1
01-CA-026515-001 1990-05-16 1990-10-22     3 1990-05-16 1       1990-10-22 2   1990-10-22 8   4 1
01-CA-026641-001 1990-11-02 1991-04-24     4 1990-11-02 4       1991-01-30 3   1991-04-24 2   4 0
01-CA-026660-001 1992-08-24 1994-06-24 1 Q 6 1992-08-24 4       1993-01-13 3   1994-06-24 7 0 4 0
01-CA-026852-001 1991-05-14 1992-01-09 1 J 3 1991-05-14 1       1992-01-09 2   1992-01-09 8   4 1
01-CA-026919-001 1992-10-29 1993-11-17 1 Q 4 1992-10-29 4       1993-03-22 3   1993-11-17 2   4 0
01-CA-026936-001 1991-07-23 1992-04-23     3 1991-07-23 1       1992-04-23 2   1992-04-23 8   4 1
01-CA-026963-001 1990-12-04 1991-10-15     3 1990-12-04 1       1991-10-15 2   1991-10-15 8   4 1
01-CA-027007-001 1992-04-20 1993-06-08     3 1992-04-20 2       1993-06-08 2   1993-06-08 7   4 1
01-CA-027007-001 1993-06-28 1993-08-26     3 1993-06-28 8       1993-08-26 2   1993-08-26 1   4 1
01-CA-027051-001 1993-08-30 1993-08-30 1 J 1 1993-08-30 2                   4  
01-CA-027095-001 1991-07-23 1992-04-01     3 1991-07-23 1       1992-04-01 2   1992-04-01 8   4 1
01-CA-027142-001 1992-07-06 1992-10-09     3 1992-07-06 1       1992-10-09 2   1992-10-09 8   4 1
01-CA-027159-001 1991-05-14 1992-01-09 1 Q 3 1991-05-14 1       1992-01-09 2   1992-01-09 8   4 1
01-CA-027201-001 1991-06-07 1992-04-23     3 1991-06-07 1       1992-04-23 2   1992-04-23 8   4 1
01-CA-027207-001 1993-08-30 1993-08-30 1 Q 1 1993-08-30 2                   4  
01-CA-027321-001 1991-01-31 1991-10-30     3 1991-01-31 1       1991-10-30 2   1991-10-30 8   4 1
01-CA-027321-001 1992-07-28 1992-11-13     3 1992-07-28 1       1992-11-13 2   1992-11-13 8   4 1
01-CA-027506-001 1992-06-05 1992-11-05     3 1992-06-05 1       1992-11-05 2   1992-11-05 8   4 1
01-CA-027506-001 1995-06-30 1995-07-26     3 1995-06-30 8       1995-07-26 2   1995-07-26 1   4 1
01-CA-027619-001 1992-07-24 1993-05-17     3 1992-07-24 2       1993-05-17 2   1993-05-17 7   4 1
01-CA-027730-001 1991-07-23 1992-04-01     3 1991-07-23 1       1992-04-01 2   1992-04-01 8   4 1
01-CA-027731-001 1991-09-10 1992-05-26     3 1991-09-10 1       1992-05-26 2   1992-05-26 8   4 1
01-CA-027731-001 1993-06-28 1993-08-25     3 1993-06-28 8       1993-08-25 2   1993-08-25 1   4 1
01-CA-027784-001 1992-06-09 1992-11-15     3 1992-06-09 1       1992-11-15 2   1992-11-15 8   4 1
01-CA-027825-001 1993-06-02 1993-08-03     3 1993-06-02 1       1993-08-03 2   1993-08-03 8   4 1
01-CA-027967-001 1992-08-11 1992-11-18 1 Q 3 1992-08-11 1       1992-11-18 2   1992-11-18 8   4 1
01-CA-028046-001 1992-08-25 1992-11-16     3 1992-08-25 1       1992-11-16 2   1992-11-16 8   4 1
01-CA-028114-001 1992-10-01 1992-12-09     3 1992-10-01 1       1992-12-09 2   1992-12-09 8   4 1
01-CA-028224-001 1992-04-06 1992-09-09     3 1992-04-06 1       1992-09-09 2   1992-09-09 8   4 1
01-CA-028412-001 1992-06-05 1992-11-09     3 1992-06-05 1       1992-11-09 2   1992-11-09 8   4 1
01-CA-028424-001 1993-05-19 1993-12-17     4 1993-05-19 4       1993-08-09 3   1993-12-17 2   4 0
01-CA-028456-001 1992-02-28 1992-07-16     3 1992-02-28 2       1992-07-16 3         4 0
01-CA-028474-001 1992-06-09 1992-10-26     3 1992-06-09 1       1992-10-26 2   1992-10-26 8   4 1
01-CA-028534-001 1994-01-06 1994-06-27     4 1994-01-06 4       1994-04-06 3   1994-06-27 2   4 0
01-CA-028989-001 1992-10-13 1992-12-02     3 1992-10-13 1       1992-12-02 2   1992-12-02 8   4 1
01-CA-029075-001 1992-11-04 1993-01-25     3 1992-11-04 1       1993-01-25 2   1993-01-25 8   4 1
01-CA-029075-001 1993-09-21 1993-11-04     3 1993-09-21 1       1993-11-04 2   1993-11-04 8   4 1
01-CA-029181-001 1993-12-21 1994-03-17     3 1993-12-21 1       1994-03-17 2   1994-03-17 8   4 1
01-CA-029219-001 1992-11-09 1992-12-17     3 1992-11-09 1       1992-12-17 2   1992-12-17 8   4 1
01-CA-029367-001 1992-11-10 1993-01-07     3 1992-11-10 1       1993-01-07 2   1993-01-07 8   4 1
01-CA-029406-001 1993-07-08 1993-09-15     3 1993-07-08 1       1993-09-15 2   1993-09-15 8   4 1
01-CA-029531-001 1993-03-08 1993-05-04     3 1993-03-08 1       1993-05-04 2   1993-05-04 8   4 1
01-CA-029676-001 1993-07-27 1993-09-21     3 1993-07-27 1       1993-09-21 2   1993-09-21 8   4 1
01-CA-029701-001 1995-05-22 1996-04-26     4 1995-05-22 2       1995-12-05 3   1996-04-26 2   4 0
01-CA-029732-001 1993-03-25 1993-05-19     3 1993-03-25 1       1993-05-19 2   1993-05-19 8   4 1
01-CA-029781-001 1994-01-03 1994-06-07     3 1994-01-03 2       1994-06-07 2   1994-06-07 7   4 1
01-CA-029946-001 1995-08-09 1997-04-01 1 J 3 1995-08-09 2       1997-04-01 2         4 1
01-CA-030261-001 1993-08-31 1993-10-27     3 1993-08-31 1       1993-10-27 2   1993-10-27 8   4 1
01-CA-030290-001 1993-11-24 1994-01-21 1 J 3 1993-11-24 1       1994-01-21 2   1994-01-21 8   4 1
01-CA-030347-001 1994-03-07 1994-05-04     3 1994-03-07 1       1994-05-04 2   1994-05-04 8   4 1
01-CA-030373-001 1993-11-24 1994-01-21 1 N 3 1993-11-24 1       1994-01-21 2   1994-01-21 8   4 1
01-CA-030472-001 1994-01-27 1994-04-14 1 J 3 1994-01-27 1       1994-04-14 2   1994-04-14 8   4 1
01-CA-030539-001 1994-01-27 1994-04-28     3 1994-01-27 1       1994-04-28 2   1994-04-28 8   4 1
01-CA-030547-001 1994-02-15 1994-04-28     3 1994-02-15 1       1994-04-28 2   1994-04-28 8   4 1
01-CA-030615-001 1994-01-06 1994-10-12     4 1994-01-06 4       1994-05-19 3   1994-10-12 2   4 0
01-CA-030708-001 1994-01-27 1994-04-14 1 N 3 1994-01-27 1       1994-04-14 2   1994-04-14 8   4 1

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE c_formal3(case_number VARCHAR, cf3_date DATE, date_last_action DATE, consol_type VARCHAR, consol_code VARCHAR, update_control VARCHAR, date_ref_app_ct DATE, type_ref VARCHAR, date_pet_answ_filed DATE, date_ref_pet_answ DATE, date_ca_opinion DATE, date_brief_filed DATE, type_disposition BIGINT, ca_no VARCHAR, date_ca_decree DATE, type_decree BIGINT, control_case BIGINT, card_control VARCHAR, code_date_brief_filed BIGINT);