c_master

516,355 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ region ctype docket suffix file_date close_date date_last_action county state industry complainant joint_complainant respondent joint_respondent number_employed allegations number_discrim situation number_of_charges type_charge number_allegations status formal_action_control machine_control proceeding_control fact_advice type_refusal fact_appeal code_date_ro_disp date_ro_disp method_disposition collyer_deferral date_collyer_began date_collyer_end code_date_closed stage_close method_close reason_remedy_close status_barg_close solic_stages_investig contact_witness date_re_advice_received date_action_on_advice date_appeal_received date_action_on_appeal hearing_held_code decision_made_code chips_close_flag chips_close_date related_case key_case_reg key_case_type key_case_docket key_case_suffix chips_amended_code sub_key_case_reg sub_key_case_type sub_key_case_docket sub_key_case_suffix formal_setl transferred_case_reg transferred_case_type transferred_case_docket transferred_case_suffix filed_calendar_year closed_calendar_year filed_fiscal_year closed_fiscal_year
1 1 1 CA 7643 1 5/7/71 0:00:00 12/31/85 0:00:00 7/1/71 0:00:00 025 20 805 2451 N 0000 N 00100 25 0001 5 001 1 3 12 6 E 2 7/1/71 0:00:00 4     3.0 6 5 16 4.0           N 1971 1985 1971 1986
2 2 1 CA 7837 1 8/30/71 0:00:00 12/31/85 0:00:00 11/4/71 0:00:00 025 20 805 2451 N 0000 N 00060 33 0000 5 001 1 2 12 6 E 2 11/4/71 0:00:00 4     3.0 6 5 16 4.0           N 1971 1985 1971 1986
3 3 1 CA 7903 1 10/7/71 0:00:00 12/31/85 0:00:00 12/3/71 0:00:00 025 20 805 2451 N 0000 N 00060 9 0001 5 001 1 2 12 6 E 2 12/3/71 0:00:00 4     3.0 6 5 16 4.0           N 1971 1985 1972 1986
4 4 1 CA 8742 1 12/18/72 0:00:00 9/24/86 0:00:00 2/5/73 0:00:00 027 20 171 4233 N 0000 N 00002 41 0001 5 001 1 3 12 6 E 2 2/5/73 0:00:00 4     3.0 8 4 97             N 1972 1986 1973 1986
5 5 1 CA 10237 1 11/11/74 0:00:00 6/20/84 0:00:00 8/14/75 0:00:00 025 20 701 2473 N 0000 N 00018 9 0001 5 001 1 2 20 6 D 2 12/24/74 0:00:00 4     3.0 1 2 10             N N 1974 1984 1975 1984
6 6 1 CA 10348 1 1/2/75 0:00:00 8/8/86 0:00:00 3/6/75 0:00:00 007 38 417 4233 N 0000 N 00037 41 0001 5 001 1 3 12 6 E 2 3/6/75 0:00:00 4     3.0 8 4 97             N 1975 1986 1975 1986
7 7 1 CA 10379 1 1/13/75 0:00:00 6/20/84 0:00:00 8/14/75 0:00:00 025 20 701 2473 N 0000 N 00080 1 0000 5 001 1 1 20 6 D 2 5/20/75 0:00:00 4     3.0 1 2 01             N N 1975 1984 1975 1984
8 8 1 CA 10381 1 1/14/75 0:00:00 6/20/84 0:00:00 8/14/75 0:00:00 003 38 701 1061 N 0000 N 00080 9 0001 5 001 1 2 20 6 D 2 5/20/75 0:00:00 4     3.0 1 2 01             N N 1975 1984 1975 1984
9 9 1 CA 10522 1 3/20/75 0:00:00 6/20/84 0:00:00 8/14/75 0:00:00 003 38 701 1061 N 0000 N 00080 41 0001 5 001 1 3 20 6 D 2 5/20/75 0:00:00 4     3.0 1 2 01             N N 1975 1984 1975 1984
10 10 1 CA 10585 1 4/10/75 0:00:00 12/5/91 0:00:00 5/23/75 0:00:00 017 20 417 8000 N 0000 N 00150 1 0000 5 001 1 1 12 6 E 2 5/23/75 0:00:00 4     3.0 4 4               N 1975 1991 1975 1992
11 11 1 CA 11061 1 9/23/75 0:00:00 9/30/86 0:00:00 8/15/84 0:00:00 025 20 816 5000 N 0000 N 00850 33 0000 5 001 1 2 02 9 B 1 0 10/11/75 0:00:00 6     2.0 6 0     7/10/84 0:00:00 8/15/84 0:00:00       N 1975 1986 1975 1986
12 12 1 CA 11491 1 3/1/76 0:00:00 5/31/88 0:00:00 8/17/77 0:00:00 025 20 521 1063 N 0000 N 00020 33 0000 5 001 1 2 12 6 E 2 8/17/77 0:00:00 4     3.0 8 6 17 4.0           N 1976 1988 1976 1988
13 13 1 CA 11524 1 3/15/76 0:00:00 12/5/85 0:00:00 4/28/76 0:00:00 005 20 401 4233 N 0000 N 00015 9 0001 5 001 1 2 12 6 E 2 4/28/76 0:00:00 4     3.0 8 6 97             N 1976 1985 1976 1986
14 14 1 CA 11628 1 4/9/76 0:00:00 6/29/87 0:00:00 9/13/85 0:00:00 017 20 569 4233 N 0000 N 00100 33 0000 5 001 1 2 18 6 E 2 5/20/76 0:00:00 4     3.0 9 4 17 3.0           N 1976 1987 1976 1987
15 15 1 CA 11684 1 4/23/76 0:00:00 12/11/85 0:00:00 2/11/77 0:00:00 009 20 317 4233 N 0000 N 00029 33 0000 5 001 1 2 21 6 D 0 6/11/76 0:00:00 6     3.0 6 4 97             N 1976 1985 1976 1986
16 16 1 CA 11733 1 4/30/76 0:00:00 11/28/84 0:00:00 10/5/76 0:00:00 005 20 801 4233 N 0000 N 00060 41 0001 5 001 1 3 12 6 E 2 10/5/76 0:00:00 4     3.0 6 4 17 4.0           N 1976 1984 1976 1985
17 17 1 CA 11760 1 5/11/76 0:00:00 8/22/90 0:00:00 8/12/80 0:00:00 011 28 417 1179 N 0000 N 00010 33 0001 5 001 1 2 01 B   C 1/21/77 0:00:00 8/12/80 0:00:00 1.0 0 1 98   6 1           N 1976 1990 1976 1990
18 18 1 CA 12015 1 7/15/76 0:00:00 8/29/84 0:00:00 2/22/83 0:00:00 025 20 372 1141 N 0000 N 12000 41 0003 5 001 1 3 62 6 K 1 2 7/24/79 0:00:00 4 C     3.0 8 4 10             N 1976 1984 1976 1984
19 19 1 CA 12030 1 7/21/76 0:00:00 12/11/85 0:00:00 2/11/77 0:00:00 009 20 317 4233 N 0000 N 00029 41 0001 5 001 1 3 12 6 E - 2 2/11/77 0:00:00 4     3.0 6 4 97             N 1976 1985 1976 1986
20 20 1 CA 12102 1 8/12/76 0:00:00 8/29/84 0:00:00 2/13/81 0:00:00 025 20 372 1141 N 0000 N 12000 9 0003 5 001 1 2 12 6 E - 2 7/24/79 0:00:00 4 C     3.0 8 4 10             N 1976 1984 1976 1984
21 21 1 CA 12137 1 8/20/76 0:00:00 8/29/84 0:00:00 2/13/81 0:00:00 025 20 372 1141 N 0000 N 12000 9 0003 5 001 1 2 12 6 E - 2 7/24/79 0:00:00 4     3.0 8 4 10             N 1976 1984 1976 1984
22 22 1 CA 12264 1 9/29/76 0:00:00 4/4/85 0:00:00 10/26/82 0:00:00 017 20 289 1245 N 0000 N 00004 41 0001 5 001 1 3 18 6 E 2 12/20/76 0:00:00 4     3.0 7 4 10             N 1976 1985 1976 1985
23 23 1 CA 12325 1 10/14/76 0:00:00 4/16/87 0:00:00 2/20/86 0:00:00 021 20 808 2451 N 0000 N 00025 1 0000 5 001 1 1 62 7 K 2 1/5/77 0:00:00 4     3.0 8 4 01             N 1976 1987 1977 1987
24 24 1 CA 12326 1 10/14/76 0:00:00 4/16/87 0:00:00 1/5/77 0:00:00 021 20 808 2451 N 0000 N 00025 1 0000 5 001 1 1 12 6 E 2 1/5/77 0:00:00 4     3.0 8 4 01             N 1976 1987 1977 1987
25 25 1 CA 12370 1 10/22/76 0:00:00 4/4/85 0:00:00 10/26/82 0:00:00 017 20 289 1245 N 0000 N 00004 9 0001 5 001 1 2 18 6 E - 2 12/20/76 0:00:00 4     3.0 7 4 10             N 1976 1985 1977 1985
26 26 1 CA 12507 1 12/7/76 0:00:00 12/11/85 0:00:00 5/12/77 0:00:00 025 20 816 1232 N 0000 N 00050 9 0001 5 001 1 2 12 6 E 1 2 5/12/77 0:00:00 4     3.0 6 4 97             N 1976 1985 1977 1986
27 27 1 CA 12508 1 12/7/76 0:00:00 7/23/86 0:00:00 7/25/79 0:00:00 025 20 317 1061 N 0000 N 00010 41 0001 5 001 1 3 20 6 D 2 1/20/77 0:00:00 4     3.0 1 2 01             N N 1976 1986 1977 1986
28 28 1 CA 12643 1 1/21/77 0:00:00 11/20/87 0:00:00 4/24/87 0:00:00 025 20 354 1141 N 0000 N 00022 41 0001 5 001 1 3 30 8 D 2 3/15/77 0:00:00 4     3.0 8 4 17 9.0           N 1977 1987 1977 1988
29 29 1 CA 12715 1 2/7/77 0:00:00 9/24/91 0:00:00 3/21/77 0:00:00 009 18 753 1141 N 0000 N 00010 41 0001 5 001 1 3 12 6 E 2 3/21/77 0:00:00 4     3.0 6 6 01             N 1977 1991 1977 1991
30 30 1 CA 12812 1 3/3/77 0:00:00 11/20/87 0:00:00 4/18/77 0:00:00 025 20 317 1141 N 0000 N 00010 57 0001 5 001 1 4 12 6 E 2 4/18/77 0:00:00 4     3.0 8 4 17 9.0           N 1977 1987 1977 1988
31 31 1 CA 12838 1 3/7/77 0:00:00 12/26/85 0:00:00 7/18/77 0:00:00 025 20 806 8000 N 0000 N 10000 17 0000 5 001 1 2 20 6 D 2 1 2 4/28/77 0:00:00 4     3.0 1 2 10             N N 1977 1985 1977 1986
32 32 1 CA 12958 1 4/5/77 0:00:00 6/29/87 0:00:00 8/1/86 0:00:00 017 20 569 1223 N 0000 N 00100 9 0012 5 001 1 2 18 R E 1 2 5/19/77 0:00:00 4     3.0 8 4 17 3.0 7/30/82 0:00:00 8/10/82 0:00:00       N 1977 1987 1977 1987
33 33 1 CA 12975 1 4/1/77 0:00:00 4/29/86 0:00:00 6/28/85 0:00:00 025 18 262 1187 N 0000 N 00350 33 0000 5 001 1 1 18 6 E 1 1 1 2 1/23/79 0:00:00 4     3.0 8 4 01   1/13/84 0:00:00 5/24/84 0:00:00       O 1977 1986 1977 1986
34 34 1 CA 12978 1 4/1/77 0:00:00 4/29/86 0:00:00 6/28/85 0:00:00 025 18 262 1141 N 0000 N 00340 33 0000 5 001 1 1 18 6 E - 1 1 2 1/23/79 0:00:00 4     3.0 8 4 01   1/13/84 0:00:00 5/24/84 0:00:00       O 1977 1986 1977 1986
35 35 1 CA 13014 1 4/20/77 0:00:00 12/12/84 0:00:00 1/6/83 0:00:00 007 38 801 5000 N 0000 N 00200 9 0001 5 001 1 2 60 8 K 2 6/7/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
36 36 1 CA 13016 1 4/20/77 0:00:00 5/31/88 0:00:00 6/30/81 0:00:00 025 20 317 4233 N 0000 N 00024 41 0001 5 001 1 3 18 6 E - 2 5/24/77 0:00:00 4     3.0 8 6 17 4.0           N 1977 1988 1977 1988
37 37 1 CA 13017 1 4/20/77 0:00:00 5/31/88 0:00:00 6/30/81 0:00:00 025 20 317 8000 N 0000 N 00024 9 0001 5 001 1 2 18 6 E - 2 5/24/77 0:00:00 4     3.0 8 6 01             N 1977 1988 1977 1988
38 38 1 CA 13018 1 4/20/77 0:00:00 5/31/88 0:00:00 6/30/81 0:00:00 025 20 317 4233 N 0000 N 00024 41 0001 5 001 1 3 18 6 E - 2 5/24/77 0:00:00 4     3.0 8 6 17 4.0           Y 1977 1988 1977 1988
39 39 1 CA 13019 1 4/20/77 0:00:00 12/26/85 0:00:00 7/18/77 0:00:00 025 20 806 8000 N 0000 N 10000 17 0000 5 001 1 2 20 6 D - 2 1 2 6/7/77 0:00:00 4     3.0 1 2 10             N N 1977 1985 1977 1986
40 40 1 CA 13057 1 4/29/77 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00200 9 0001 5 001 1 2 18 6 E - 2 6/7/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
41 41 1 CA 13167 1 5/26/77 0:00:00 2/22/85 0:00:00 7/17/80 0:00:00 025 44 514 5000 N 0000 N 00040 9 0006 5 001 1 2 60 8 K 2 7/15/77 0:00:00 4     3.0 7 6 97             N 1977 1985 1977 1985
42 42 1 CA 13208 1 6/6/77 0:00:00 12/13/83 0:00:00 8/26/83 0:00:00 061 31 221 2322 N N 0D500 40 0001 5 001 1 2 02 8 B 1 0 11/11/77 0:00:00 6     3.0 6 4 16 4.0 8/1/83 0:00:00 8/26/83 0:00:00       O 1977 1983 1977 1984
43 43 1 CA 13230 1 6/10/77 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00250 9 0001 5 001 1 2 18 6 E - 2 7/14/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
44 44 1 CA 13282 1 6/22/77 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00250 9 0001 5 001 1 2 18 6 E - 2 7/14/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
45 45 1 CA 13425 1 7/28/77 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00250 9 0001 5 001 1 2 18 6 E - 2 9/23/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
46 46 1 CA 13458 1 8/8/77 0:00:00 1/13/87 0:00:00 6/9/78 0:00:00 021 20 808 2451 N 0000 N 00025 1 0000 5 001 1 1 20 6 D 2 3/9/78 0:00:00 4     3.0 1 2 01             N N 1977 1987 1977 1987
47 47 1 CA 13486 1 8/16/77 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00200 9 0001 5 001 1 2 18 6 E - 2 9/23/77 0:00:00 4     3.0 6 4 10             N 1977 1984 1977 1985
48 48 1 CA 13497 1 8/18/77 0:00:00 11/20/87 0:00:00 10/18/77 0:00:00 025 20 317 1141 N 0000 N 00058 57 0001 5 001 1 4 12 6 E 2 10/18/77 0:00:00 4     3.0 8 4 17 9.0           N 1977 1987 1977 1988
49 49 1 CA 13578 1 9/2/77 0:00:00 1/13/87 0:00:00 6/9/78 0:00:00 021 20 808 2451 N 0000 N 00025 1 0000 5 001 1 1 20 6 D 2 3/9/78 0:00:00 4     3.0 1 2 01             N N 1977 1987 1977 1987
50 50 1 CA 13586 1 9/6/77 0:00:00 1/13/86 0:00:00 11/28/77 0:00:00 009 20 546 4233 N 0000 N 00050 9 0001 5 001 1 2 12 6 E 2 11/28/77 0:00:00 4     3.0 1 2 10             N 1977 1986 1977 1986
51 51 1 CA 13587 1 9/6/77 0:00:00 1/13/86 0:00:00 11/9/77 0:00:00 009 20 546 4233 N 0000 N 00050 1 0000 5 001 1 1 12 6 E 2 11/9/77 0:00:00 4     3.0 1 2 10             N 1977 1986 1977 1986
52 52 1 CA 13588 1 9/6/77 0:00:00 1/13/86 0:00:00 12/29/77 0:00:00 009 20 546 4233 N 0000 N 00050 17 0000 5 001 1 2 12 6 E - 2 12/29/77 0:00:00 4     3.0 1 2 10             N 1977 1986 1977 1986
53 53 1 CA 13743 1 10/17/77 0:00:00 1/13/86 0:00:00 12/29/77 0:00:00 009 20 546 4233 N 0000 N 00050 1 0000 5 001 1 1 12 6 E - 2 11/9/77 0:00:00 4     3.0 1 2 10             N 1977 1986 1978 1986
54 54 1 CA 13753 1 10/18/77 0:00:00 1/29/86 0:00:00 12/22/81 0:00:00 025 20 806 8000 N 0000 N 10000 17 0000 5 001 1 2 20 6 D 1 3 1 2 7/7/78 0:00:00 4     3.0 1 2 01             N N 1977 1986 1978 1986
55 55 1 CA 13868 1 11/17/77 0:00:00 1/13/86 0:00:00 12/29/77 0:00:00 009 20 546 4233 N 0000 N 00050 57 0001 5 001 1 4 12 6 E - 2 12/29/77 0:00:00 4     3.0 1 2 10             N 1977 1986 1978 1986
56 56 1 CA 13882 1 11/21/77 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 367 4541 N 0000 N 00165 9 0000 5 001 1 2 18 6 E 2 1/5/78 0:00:00 4     3.0 8 4 17 2.0           Y 1977 1985 1978 1985
57 57 1 CA 13913 1 12/1/77 0:00:00 11/20/87 0:00:00 1/12/78 0:00:00 025 20 317 1141 N 0000 N 00058 33 0000 5 001 1 2 12 6 E 2 1/12/78 0:00:00 4     3.0 8 4 17 9.0           N 1977 1987 1978 1988
58 58 1 CA 13985 1 12/27/77 0:00:00 1/29/86 0:00:00 12/22/81 0:00:00 025 20 806 8000 N 0000 N 10000 17 0000 5 001 1 2 20 6 D 1 3 1 2 7/7/78 0:00:00 4     3.0 1 2 01             N N 1977 1986 1978 1986
59 59 1 CA 14050 1 1/16/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 391 5000 N 0000 N 00300 9 0003 5 001 1 2 18 6 E 2 5/3/78 0:00:00 4     3.0 5 4 01             N 1978 1986 1978 1986
60 60 1 CA 14053 1 1/17/78 0:00:00 1/29/86 0:00:00 12/22/81 0:00:00 025 20 806 8000 N 0000 N 10000 17 0000 5 001 1 2 20 6 D 1 1 2 7/7/78 0:00:00 4     3.0 1 2 01             N N 1978 1986 1978 1986
61 61 1 CA 14071 1 1/27/78 0:00:00 1/13/86 0:00:00 1/27/78 0:00:00 009 20 546 4233 N 0000 N 00050 9 0001 5 001 1 2 20 D 1 1/13/86 0:00:00 2     3.0 0 2 10             N 1978 1986 1978 1986
62 62 1 CA 14085 1 1/31/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 391 5000 N 0000 N 00300 9 0004 5 001 1 2 18 6 E - 2 5/3/78 0:00:00 4     3.0 5 4 01             N 1978 1986 1978 1986
63 63 1 CA 14086 1 1/17/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 396 7000 N 0000 N 00300 9 0001 5 001 1 22 18 6 E - 2 5/3/78 0:00:00 4     3.0 5 4 01             O 1978 1986 1978 1986
64 64 1 CA 14204 1 3/8/78 0:00:00 11/12/85 0:00:00 9/23/80 0:00:00 013 20 251 2355 N 0000 N 00030 41 0001 5 001 1 3 20 6 D 2 4/27/79 0:00:00 4     3.0 1 2 01             N N 1978 1985 1978 1986
65 65 1 CA 14224 1 3/13/78 0:00:00 12/8/87 0:00:00 9/15/78 0:00:00 025 20 301 2452 N 0000 N 00080 9 0003 5 001 1 2 12 6 E 2 4/19/78 0:00:00 4     3.0 8 5 16 9.0           N 1978 1987 1978 1988
66 66 1 CA 14273 1 3/16/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 396 5000 N 0000 N 00300 1 0000 5 001 1 21 18 6 E - 2 5/3/78 0:00:00 4     3.0 5 4 01             O 1978 1986 1978 1986
67 67 1 CA 14274 1 3/24/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 391 5000 N 0000 N 00300 33 0000 5 001 1 2 18 6 E - 2 5/3/78 0:00:00 4     3.0 5 4 01             N 1978 1986 1978 1986
68 68 1 CA 14347 1 4/12/78 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 367 4541 N 0000 N 00165 9 0001 5 001 1 2 18 6 E - 2 10/19/78 0:00:00 4     3.0 8 4 17 2.0           N 1978 1985 1978 1985
69 69 1 CA 14383 1 4/21/78 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 367 4541 N 0000 N 00175 9 0001 5 001 1 2 18 6 E - 2 10/19/78 0:00:00 4     3.0 8 4 17 2.0           N 1978 1985 1978 1985
70 70 1 CA 14433 1 5/1/78 0:00:00 8/14/84 0:00:00 8/11/83 0:00:00 025 20 116 2342 N 0000 N 00200 9 0001 5 001 1 2 20 D 1 3 1 0 1/18/80 0:00:00 2     3.0 0 2 0.0           N N 1978 1984 1978 1984
71 71 1 CA 14443 1 5/3/78 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 317 4541 N 0000 N 00165 9 0001 5 001 1 2 18 6 E - 2 10/19/78 0:00:00 4     3.0 8 4 17 2.0           N 1978 1985 1978 1985
72 72 1 CA 14475 1 5/12/78 0:00:00 12/8/87 0:00:00 9/15/78 0:00:00 025 20 306 2452 N 0000 N 00080 9 0001 5 001 1 2 12 6 E - 2 6/29/78 0:00:00 4     3.0 8 5 16 9.0           N 1978 1987 1978 1988
73 73 1 CA 14495 1 5/17/78 0:00:00 12/28/83 0:00:00 6/30/82 0:00:00 005 20 216 8000 N 0000 N ----- 9 0001 1 002 1 2 18 6 E 2 6/29/78 0:00:00 4     3.0 8 4 97             N 1978 1983 1978 1984
74 74 1 CA 14495 2 5/17/78 0:00:00 12/28/83 0:00:00 6/30/82 0:00:00 005 20 216 8000 N 0000 N 00130 9 0001 4 1 2 18 6 E - 2 6/29/78 0:00:00 4     3.0 8 4 97             1 01 CA 14495 001 N 1978 1983 1978 1984
75 75 1 CA 14526 1 5/24/78 0:00:00 12/28/83 0:00:00 6/30/82 0:00:00 005 20 216 8000 N 0000 N 00130 9 0001 5 001 1 2 18 6 E - 2 6/29/78 0:00:00 4     3.0 8 4 97             N 1978 1983 1978 1984
76 76 1 CA 14600 1 6/1/78 0:00:00 8/26/86 0:00:00 5/6/83 0:00:00 007 38 396 5000 N 0000 N 00300 41 ---- 5 001 1 32 18 6 E - 2 5/3/78 0:00:00 4     3.0 5 4 01             O 1978 1986 1978 1986
77 77 1 CA 14619 1 6/14/78 0:00:00 1/13/86 0:00:00 6/14/78 0:00:00 009 20 546 4233 N 0000 N 00002 57 0001 5 001 1 4 20 D 1 1/13/86 0:00:00 2     3.0 0 2 10             N 1978 1986 1978 1986
78 78 1 CA 14624 1 6/14/78 0:00:00 5/30/86 0:00:00 9/15/78 0:00:00 017 20 301 4233 N 0000 N 00050 41 0001 5 001 1 3 12 6 E 1 2 9/15/78 0:00:00 4     3.0 6 4 97             N 1978 1986 1978 1986
79 79 1 CA 14700 1 7/11/78 0:00:00 12/8/87 0:00:00 9/15/78 0:00:00 025 20 301 2452 N 0000 N 00080 45 0003 5 001 1 4 12 6 E - 2 9/15/78 0:00:00 4     3.0 8 5 16 9.0           N 1978 1987 1978 1988
80 80 1 CA 14728 1 7/20/78 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 367 4541 N 0000 N 00175 9 0001 5 001 1 2 18 6 E - 2 10/19/78 0:00:00 4     3.0 8 4 17 2.0           N 1978 1985 1978 1985
81 81 1 CA 14748 1 7/26/78 0:00:00 11/30/83 0:00:00 8/10/83 0:00:00 025 20 301 8000 N 0000 N 00130 9 0001 5 001 1 2 26 6 D 2 7/30/78 0:00:00 4     3.0 8 4 10             N 1978 1983 1978 1984
82 82 1 CA 14788 1 8/4/78 0:00:00 12/8/87 0:00:00 9/15/78 0:00:00 025 20 301 2452 N 0000 N 00080 9 0003 5 001 1 2 12 6 E - 2 9/15/78 0:00:00 4     3.0 8 5 16 9.0           N 1978 1987 1978 1988
83 83 1 CA 14925 1 9/6/78 0:00:00 4/4/85 0:00:00 11/30/82 0:00:00 025 20 367 4541 N 0000 N 00165 41 0001 5 001 1 3 18 6 E - 2 10/19/78 0:00:00 4     3.0 8 4 17 2.0           N 1978 1985 1978 1985
84 84 1 CA 14998 1 9/27/78 0:00:00 12/12/84 0:00:00 5/5/80 0:00:00 007 38 801 5000 N 0000 N 00200 9 0001 5 001 1 2 18 6 E - 2 11/1/78 0:00:00 4     3.0 6 4 10             N 1978 1984 1978 1985
85 85 1 CA 15141 1 10/27/78 0:00:00 6/30/86 0:00:00 10/10/79 0:00:00 009 20 271 1245 N 0000 N 00060 9 0001 5 001 1 2 20 P D 2 7/31/79 0:00:00 4     3.0 1 2 97             N N 1978 1986 1979 1986
86 86 1 CA 15206 1 11/14/78 0:00:00 8/18/86 0:00:00 3/18/82 0:00:00 007 38 391 5000 N 0000 N 00350 17 0001 5 001 1 2 26 7 D 0 12/27/78 0:00:00 4     3.0 5 4 17 2.0           N 1978 1986 1979 1986
87 87 1 CA 15416 1 12/29/78 0:00:00 12/15/83 0:00:00 5/3/79 0:00:00 025 20 317 2583 N 0000 N 45000 33 0000 5 001 1 2 12 6 E 2 5/3/79 0:00:00 4     3.0 1 3 97   6 1           Y 1978 1983 1979 1984
88 88 1 CA 15433 1 1/5/79 0:00:00 6/30/86 0:00:00 10/10/79 0:00:00 009 20 271 1245 N 0000 N 00060 9 0001 5 001 1 2 20 P D 2 7/31/79 0:00:00 4     3.0 1 2 97             N N 1979 1986 1979 1986
89 89 1 CA 15489 1 1/18/79 0:00:00 8/18/86 0:00:00 1/18/79 0:00:00 007 38 391 1023 N 0000 N 00300 25 0001 5 001 1 3 92 7 N - 0 5/18/79 0:00:00 4     3.0 5 4 17 2.0           N 1979 1986 1979 1986
90 90 1 CA 15560 1 2/2/79 0:00:00 2/29/84 0:00:00 4/20/83 0:00:00 003 6 363 1141 N 0000 N 00320 41 0008 5 001 1 30 R D 9 2 8/30/79 0:00:00 4 D 3/22/79 0:00:00 8/30/79 0:00:00 3.0 8 4 17 9.0 3 1           O 1979 1984 1979 1984
91 91 1 CA 15846 1 3/28/79 0:00:00 2/25/93 0:00:00 12/1/87 0:00:00 013 20 401 4233 N 0000 N 00070 9 0001 5 001 1 2 22 P D 2 4/30/79 0:00:00 4     3.0 7 4 01             N 1979 1993 1979 1993
92 92 1 CA 15902 1 4/9/79 0:00:00 2/25/93 0:00:00 12/1/87 0:00:00 017 20 401 4233 N 0000 N 00800 9 0001 5 001 1 2 22 P D - 2 5/15/79 0:00:00 4     3.0 7 4 01             N 1979 1993 1979 1993
93 93 1 CA 15904 1 4/9/79 0:00:00 7/1/86 0:00:00 4/24/79 0:00:00 025 20 806 1063 N 0000 N 00045 1 0000 5 001 1 1 12 6 E 2 4/24/79 0:00:00 4     1.0 1 1 66   3 1           N 1979 1986 1979 1986
94 94 1 CA 15922 1 5/1/81 0:00:00 4/20/85 0:00:00 1/12/83 0:00:00 025 20 517 1241 N 0000 N 00250 1 0000 5 001 1 1 20 P D 2 3/16/81 0:00:00 4     3.0 1 2 0.0           Y N 1981 1985 1981 1985
95 95 1 CA 16026 1 5/3/79 0:00:00 2/25/93 0:00:00 12/1/87 0:00:00 017 20 401 4233 N 0000 N 00500 9 0001 5 001 1 2 22 P D - 2 5/31/79 0:00:00 4     3.0 7 4 01             N 1979 1993 1979 1993
96 96 1 CA 16082 1 5/16/79 0:00:00 12/3/85 0:00:00 12/8/81 0:00:00 009 18 806 8000 N 0000 N 00150 1 0000 5 001 1 1 26 6 D 2 5/21/79 0:00:00 4     3.0 2 2 10             Y 1979 1985 1979 1986
97 97 1 CA 16142 1 5/30/79 0:00:00 2/24/84 0:00:00 1/7/83 0:00:00 013 20 508 2342 N 0000 N 00300 1 0000 5 001 1 1 62 8 K 2 7/9/79 0:00:00 4     3.0 8 4 17 2.0           N 1979 1984 1979 1984
98 98 1 CA 16152 1 6/4/79 0:00:00 8/29/84 0:00:00 2/13/81 0:00:00 025 20 372 1141 N 0000 N 20000 1 0000 5 001 1 1 12 6 E - 2 7/24/79 0:00:00 4     3.0 8 4 10             N 1979 1984 1979 1984
99 99 1 CA 16163 1 6/6/79 0:00:00 8/18/86 0:00:00 6/6/79 0:00:00 007 38 391 1023 N 0000 N 00350 33 0000 5 001 1 2 92 7 N - 0 7/11/79 0:00:00 6     3.0 5 4 17 3.0           N 1979 1986 1979 1986
100 100 1 CA 16183 1 6/8/79 0:00:00 2/24/84 0:00:00 7/9/79 0:00:00 013 20 508 2342 N 0000 N 00300 9 0001 5 001 1 2 12 6 E 2 7/9/79 0:00:00 4     3.0 8 4 17 2.0           N 1979 1984 1979 1984

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_master" (
"region" INTEGER,
  "ctype" TEXT,
  "docket" INTEGER,
  "suffix" INTEGER,
  "file_date" TEXT,
  "close_date" TEXT,
  "date_last_action" TEXT,
  "county" TEXT,
  "state" INTEGER,
  "industry" TEXT,
  "complainant" INTEGER,
  "joint_complainant" TEXT,
  "respondent" TEXT,
  "joint_respondent" TEXT,
  "number_employed" TEXT,
  "allegations" INTEGER,
  "number_discrim" TEXT,
  "situation" INTEGER,
  "number_of_charges" TEXT,
  "type_charge" TEXT,
  "number_allegations" TEXT,
  "status" TEXT,
  "formal_action_control" TEXT,
  "machine_control" TEXT,
  "proceeding_control" TEXT,
  "fact_advice" TEXT,
  "type_refusal" TEXT,
  "fact_appeal" TEXT,
  "code_date_ro_disp" TEXT,
  "date_ro_disp" TEXT,
  "method_disposition" TEXT,
  "collyer_deferral" TEXT,
  "date_collyer_began" TEXT,
  "date_collyer_end" TEXT,
  "code_date_closed" REAL,
  "stage_close" TEXT,
  "method_close" TEXT,
  "reason_remedy_close" TEXT,
  "status_barg_close" REAL,
  "solic_stages_investig" TEXT,
  "contact_witness" TEXT,
  "date_re_advice_received" TEXT,
  "date_action_on_advice" TEXT,
  "date_appeal_received" TEXT,
  "date_action_on_appeal" TEXT,
  "hearing_held_code" TEXT,
  "decision_made_code" TEXT,
  "chips_close_flag" TEXT,
  "chips_close_date" TEXT,
  "related_case" TEXT,
  "key_case_reg" TEXT,
  "key_case_type" TEXT,
  "key_case_docket" TEXT,
  "key_case_suffix" TEXT,
  "chips_amended_code" TEXT,
  "sub_key_case_reg" TEXT,
  "sub_key_case_type" TEXT,
  "sub_key_case_docket" TEXT,
  "sub_key_case_suffix" TEXT,
  "formal_setl" TEXT,
  "transferred_case_reg" TEXT,
  "transferred_case_type" TEXT,
  "transferred_case_docket" TEXT,
  "transferred_case_suffix" TEXT,
  "filed_calendar_year" INTEGER,
  "closed_calendar_year" INTEGER,
  "filed_fiscal_year" INTEGER,
  "closed_fiscal_year" INTEGER
);