chips: c_formal4: sorted by rowid

sorted by rowid

descending

Download this data as a CSV Spreadsheet (All Rows)

Link	rowid ▼	case_number	cf4_date	date_last_action	consolidation_type	consolidation_code	upate_control	date_pret_writ_cert_filed	party_filing	date_back_pay_specs	stage_back_pay_specs	date_hearing_closed	date_administrative_law_judge_dec_issued	date_board_suppl_decision	type_board_suppl_decision	card_control
1	1	01-CA-021148-001	1985-07-31	1985-07-31			G			1985-07-31						5
2	2	01-CA-021560-001	1998-03-12	1998-03-12	1	C	C	1998-03-12	2							5
3	3	01-CA-021594-001	1990-11-28	1990-11-28			G			1990-11-28						5
4	4	01-CA-021658-001	1985-07-29	1985-07-29			G			1985-07-29						5
5	5	01-CA-023214-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
6	6	01-CA-023287-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
7	7	01-CA-023341-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
8	8	01-CA-023359-001	1991-08-30	1991-08-30			G			1991-08-30						5
9	9	01-CA-023371-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
10	10	01-CA-023444-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
11	11	01-CA-023472-001	1987-10-30	1988-01-13			H					1988-01-13
12	12	01-CA-023498-001	1989-06-30	1991-07-29			I					1991-03-06	1991-07-29
13	13	01-CA-010348-001	1970-10-25	1975-01-01			J			1977-07-01	2			1978-11-01		5
14	14	01-CA-011628-001	1985-09-13	1985-09-13			G			1985-09-13						5
15	15	01-CA-011733-001	1970-10-25	1976-04-01			G			1979-01-01	1					5
16	16	01-CA-012015-001	1970-10-25										1980-11-01			5
17	17	01-CA-012137-001	1970-10-25										1980-11-01			5
18	18	01-CA-012264-001	1982-10-26	1982-10-26	1	A	G			1982-10-26						5
19	19	01-CA-012370-001	1982-10-26	1982-10-26	1	E	G			1982-10-26						5
20	20	01-CA-012958-001	1986-08-01	1986-08-01			G			1986-08-01						5
21	21	01-CA-012975-001	1985-06-28	1985-06-28	1	A	G			1985-06-28						5
22	22	01-CA-012978-001	1985-06-28	1985-06-28	1	E	G			1985-06-28						5
23	23	01-CA-013014-001	1970-10-25	1980-05-05		A	G			1980-05-05
24	24	01-CA-013016-001	1981-06-30	1981-06-30			G			1981-06-30						5
25	25	01-CA-013017-001	1981-06-30	1981-06-30			G			1981-06-30						5
26	26	01-CA-013018-001	1981-06-30	1981-06-30			G			1981-06-30						5
27	27	01-CA-013057-001	1970-10-25	1980-05-05		E	G			1980-05-05
28	28	01-CA-013167-001	1970-10-25				J			1979-04-01	2	1980-01-01	1960-03-01	1980-04-01	2
29	29	01-CA-013230-001	1970-10-25	1980-05-05		E	G			1980-05-05
30	30	01-CA-013282-001	1970-10-25	1980-05-05		E	G			1980-05-05
31	31	01-CA-013425-001	1970-10-25	1980-05-05		E	G			1980-05-05
32	32	01-CA-013486-001	1970-10-25	1980-05-05		E	G			1980-05-05
33	33	01-CA-013882-001	1982-11-30	1982-11-30	1	A	G			1982-11-30						5
34	34	01-CA-014050-001	1983-05-06	1983-05-06	5	E	G			1983-05-06						5
35	35	01-CA-014085-001	1970-10-25	1983-05-06	5	A	G			1983-05-06		1980-09-01	1960-09-01
36	36	01-CA-014086-001	1970-10-25	1983-05-06	5	E	G			1983-05-06		1980-09-01	1960-09-01
37	37	01-CA-014273-001	1983-05-06	1983-05-06	1	E	G			1983-05-06						5
38	38	01-CA-014274-001	1983-05-06	1983-05-06	1	E	G			1983-05-06						5
39	39	01-CA-014347-001	1982-11-30	1982-11-30	1	E	G			1982-11-30						5
40	40	01-CA-014383-001	1982-11-30	1982-11-30	1	E	G			1982-11-30						5
41	41	01-CA-014443-001	1982-11-30	1982-11-30	1	E	G			1982-11-30						5
42	42	01-CA-014495-001	1982-06-30	1982-06-30	1	A	G			1982-06-30						5
43	43	01-CA-014495-002	1982-06-30	1982-06-30	1	E	G			1982-06-30						5
44	44	01-CA-014526-001	1982-06-30	1982-06-30	1	E	G			1982-06-30						5
45	45	01-CA-014600-001	1983-05-06	1983-05-06	1	E	G			1983-05-06						5
46	46	01-CA-014728-001	1982-11-30	1982-11-30	1	E	G			1982-11-30						5
47	47	01-CA-014925-001	1982-11-30	1982-11-30	1	E	G			1982-11-30						5
48	48	01-CA-014998-001	1970-10-25	1980-05-05			G			1980-05-05
49	49	01-CA-015846-001	1986-04-09	1986-04-09			G			1986-04-09						5
50	50	01-CA-015902-001	1984-08-30	1984-08-30			G			1984-08-30						5
51	51	01-CA-016026-001	1984-08-30	1984-08-30			G			1984-08-30						5
52	52	01-CA-016322-001	1984-08-30	1984-08-30			G			1984-08-30						5
53	53	01-CA-016322-002	1984-08-30	1984-08-30			G			1984-08-30						5
54	54	01-CA-016548-001	1982-06-30	1982-11-01	1	A	G			1982-11-01						5
55	55	01-CA-016917-001	1982-06-30	1982-11-01	1	E	G			1982-11-01						5
56	56	01-CA-017298-001	1985-05-24	1985-05-24			G			1985-05-24						5
57	57	01-CA-017394-001	1985-02-28	1985-02-28	1	A	G			1985-02-28						5
58	58	01-CA-017534-001	1985-02-28	1985-02-28	1	E	G			1985-02-28						5
59	59	01-CA-017917-001	1986-06-30	1986-06-30			G			1986-06-30						5
60	60	01-CA-019537-001	1984-12-28	1984-12-28			G			1984-12-28						5
61	61	01-CA-019765-001	1984-12-28	1984-12-28	1	C	G			1984-12-28						5
62	62	01-CA-019783-001	1984-12-28	1984-12-28		E	G			1984-12-28						5
63	63	01-CA-019854-001	1984-12-28	1984-12-28			G			1984-12-28						5
64	64	01-CA-020237-001	1987-04-30	1987-04-30			G			1987-04-30						5
65	65	01-CA-020256-001	1987-04-30	1987-04-30			G			1987-04-30						5
66	66	01-CA-020283-001	1998-03-12	1998-03-12	1	C	C	1998-03-12	2							5
67	67	01-CA-020291-001	1998-03-12	1998-03-12	1	C	C	1998-03-12	2							5
68	68	01-CA-020304-001	1998-03-12	1998-03-12	1	C	C	1998-03-12	2							5
69	69	01-CA-020508-001	1998-03-12	1998-03-12	1	C	C	1998-03-12	2							5
70	70	01-CA-020752-001	1985-02-27	1985-02-27			G			1985-02-27						5
71	71	01-CA-021011-001	1985-07-31	1985-07-31			G			1985-07-31						5
72	72	01-CA-021031-001	1985-07-31	1985-07-31			G			1985-07-31						5
73	73	01-CA-023549-001	1988-09-29	1988-11-14	1	A	I					1988-09-29	1988-11-14			5
74	74	01-CA-023594-001	1988-09-29	1988-11-14	1	E	I					1988-09-29	1988-11-14			5
75	75	01-CA-024045-001	1988-02-23	1988-02-23			G			1988-02-23						5
76	76	01-CA-024406-001	1993-05-07	1993-05-07			G			1993-05-07						5
77	77	01-CA-024992-001	1992-09-15	1992-09-15			G			1992-09-15						5
78	78	01-CA-025016-001	1992-09-15	1992-09-15			G			1992-09-15						5
79	79	01-CA-025062-001	1992-09-15	1992-09-15			G			1992-09-15						5
80	80	01-CA-025146-001	1989-10-25	1989-10-25			G			1989-10-25						5
81	81	01-CA-025146-002	1989-10-25	1989-10-25			G			1989-10-25						5
82	82	01-CA-025146-003	1989-10-25	1989-10-25			G			1989-10-25						5
83	83	01-CA-025362-001	1989-03-31	1989-03-31			G			1989-03-31						5
84	84	01-CA-025375-001	1990-07-31	1991-05-09			I					1991-01-29	1991-05-09
85	85	01-CA-025411-001	1990-07-31	1990-07-31			G			1990-07-31						5
86	86	01-CA-025736-001	1994-02-28	1994-02-28			G			1994-02-28						5
87	87	01-CA-025737-001	1991-06-26	1991-06-26			G			1991-06-26						5
88	88	01-CA-026085-001	1990-11-30	1990-11-30			G			1990-11-30						5
89	89	01-CA-026214-001	1994-04-29	1994-04-29			G			1994-04-29						5
90	90	01-CA-026403-001	1992-03-31	1992-03-31			G			1992-03-31						5
91	91	01-CA-026547-001	1990-08-21	1990-08-21			G			1990-08-21						5
92	92	01-CA-027014-001	1991-07-31	1991-07-31			G			1991-07-31						5
93	93	01-CA-027142-001	1994-02-28	1994-02-28			G			1994-02-28						5
94	94	01-CA-027321-001	1992-01-30	1992-01-30			G			1992-01-30						5
95	95	01-CA-027506-001	1993-09-30	1993-09-30			G			1993-09-30						5
96	96	01-CA-027730-001	1993-01-29	1993-01-29			G			1993-01-29						5
97	97	01-CA-027731-001	1992-08-31	1992-08-31			G			1992-08-31						5
98	98	01-CA-027825-001	1993-09-03	1993-09-03			G			1993-09-03						5
99	99	01-CA-028009-001	1994-08-08	1994-08-08			G			1994-08-08						5
100	100	01-CA-028424-001	1994-05-31	1994-05-31			G			1994-05-31						5

CREATE TABLE "c_formal4" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf4_date] TEXT,
   [date_last_action] TEXT,
   [stage_last_action] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [upate_control] TEXT,
   [date_referred_scb] TEXT,
   [date_recom_writ_cert] INTEGER,
   [type_recom] TEXT,
   [date_pret_writ_cert_filed] TEXT,
   [party_filing] TEXT,
   [date_sc_action] TEXT,
   [sc_ruling] TEXT,
   [date_supreme_court_argue] INTEGER,
   [date_supreme_court_dec] TEXT,
   [type_supreme_court_dec] TEXT,
   [date_back_pay_specs] TEXT,
   [stage_back_pay_specs] TEXT,
   [date_hearing_closed] TEXT,
   [date_administrative_law_judge_dec_issued] TEXT,
   [date_board_suppl_decision] TEXT,
   [type_board_suppl_decision] TEXT,
   [date_ref_acb] TEXT,
   [date_suppl_ca_decree] TEXT,
   [card_control] INTEGER,
   [code_date_hearing_closed] INTEGER,
   [code_date_administrative_law_judges_decision_issued] INTEGER,
   [code_date_board_suppl_decision] INTEGER
);