r_closed_case

53,740 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number action_sequence closing_date closing_stage closing_method date_file_archives date_file_to_records date_file_destroyed
1 1 01-AC-00093 0 2000-02-09T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Dismissal Dismi      
2 2 01-AC-00094 0 2001-08-23T00:00:00 After Regional Director Decision Issued ARDD Dismissal Dismi      
3 3 01-AC-00095 0 2001-10-10T00:00:00 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
4 4 01-AC-00096 0 2002-06-12T00:00:00 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
5 5 01-AC-00097 0 2003-11-05T00:00:00 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
6 6 01-AC-00098 0 2008-05-09T00:00:00 After Regional Director Decision Issued ARDD Dismissal Dismi      
7 7 01-AC-00099 0 2009-02-04T00:00:00 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
8 8 01-AC-00100 0 2009-08-24T00:00:00 Before Issuance of Notice of Hearing BfrNH Dismissal Dismi      
9 9 01-AC-00101 0 2010-12-31T00:00:00 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
10 10 01-AC-00102 0 2010-12-31T00:00:00 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
11 11 01-RC-19536 0 2002-05-10T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
12 12 01-RC-19910 0 2003-11-14T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
13 13 01-RC-19926 0 1999-11-12T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
14 14 01-RC-19980 0 1999-08-16T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
15 15 01-RC-20080 0 2000-01-11T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
16 16 01-RC-20106 0 2003-11-21T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
17 17 01-RC-20292 0 1999-10-01T00:00:00 After Board Decision Issued ABD Certification of Representative Rep      
18 18 01-RC-20309 0 2000-02-23T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
19 19 01-RC-20310 0 2000-02-23T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
20 20 01-RC-20360 0 2003-12-16T00:00:00 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
21 21 01-RC-20460 0 2003-11-05T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
22 22 01-RC-20463 0 1999-10-27T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
23 23 01-RC-20467 0 2001-01-10T00:00:00 After Board Decision Issued ABD Withdrawal With      
24 24 01-RC-20508 0 1999-10-28T00:00:00 After Board Decision Issued ABD Certification of Results Resul      
25 25 01-RC-20538 0 2003-11-10T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
26 26 01-RC-20574 0 2000-01-03T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
27 27 01-RC-20600 0 2002-05-10T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
28 28 01-RC-20622 0 2003-11-17T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
29 29 01-RC-20626 0 2005-01-06T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
30 30 01-RC-20634 0 2005-01-06T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
31 31 01-RC-20649 0 1999-09-14T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Dismissal Dismi      
32 32 01-RC-20761 0 2001-03-01T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
33 33 01-RC-20804 0 1999-11-17T00:00:00 After Board Decision Issued ABD Certification of Representative Rep      
34 34 01-RC-20815 0 2001-03-23T00:00:00 After Board Decision Issued ABD Certification of Results Resul      
35 35 01-RC-20826 0 2002-05-17T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
36 36 01-RC-20869 0 1999-01-08T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
37 37 01-RC-20880 0 2002-05-20T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
38 38 01-RC-20890 0 1999-01-25T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
39 39 01-RC-20897 0 1999-04-12T00:00:00 After Board Decision Issued ABD Certification of Results Resul      
40 40 01-RC-20905 0 1999-01-12T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
41 41 01-RC-20906 0 1999-03-01T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
42 42 01-RC-20910 0 1999-01-27T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
43 43 01-RC-20912 0 1999-01-12T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
44 44 01-RC-20914 0 1999-02-02T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
45 45 01-RC-20915 0 1999-02-02T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
46 46 01-RC-20916 0 2003-11-06T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
47 47 01-RC-20921 0 1999-01-26T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
48 48 01-RC-20922 0 2000-01-07T00:00:00 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
49 49 01-RC-20923 0 1999-04-07T00:00:00 After Board Decision Issued ABD Certification of Results Resul      
50 50 01-RC-20924 0 1999-10-28T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
51 51 01-RC-20925 0 1999-01-22T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
52 52 01-RC-20927 0 1999-02-01T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
53 53 01-RC-20935 0 1999-07-09T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
54 54 01-RC-20936 0 1999-01-08T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
55 55 01-RC-20937 0 1999-01-09T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
56 56 01-RC-20938 0 1999-01-25T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
57 57 01-RC-20939 0 1999-01-19T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
58 58 01-RC-20940 0 1999-03-12T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
59 59 01-RC-20941 0 1999-04-16T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
60 60 01-RC-20942 0 1999-01-25T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
61 61 01-RC-20943 0 1999-01-13T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
62 62 01-RC-20944 0 1999-02-01T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
63 63 01-RC-20945 0 1999-02-08T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
64 64 01-RC-20946 0 1999-02-01T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
65 65 01-RC-20947 0 1999-03-31T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
66 66 01-RC-20948 0 1999-02-26T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
67 67 01-RC-20949 0 1999-02-26T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
68 68 01-RC-20950 0 1999-02-19T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
69 69 01-RC-20952 0 1999-02-19T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
70 70 01-RC-20953 0 1999-02-01T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
71 71 01-RC-20955 0 1999-02-08T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
72 72 01-RC-20956 0 1999-02-02T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
73 73 01-RC-20957 0 1999-02-23T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
74 74 01-RC-20958 0 1999-03-09T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
75 75 01-RC-20959 0 1999-02-19T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
76 76 01-RC-20960 0 1999-03-24T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
77 77 01-RC-20961 0 1999-02-22T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
78 78 01-RC-20962 0 1999-03-03T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
79 79 01-RC-20963 0 1999-03-01T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
80 80 01-RC-20964 0 1999-03-08T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
81 81 01-RC-20965 0 1999-03-03T00:00:00          
82 82 01-RC-20966 0 1999-08-04T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
83 83 01-RC-20968 0 1999-04-12T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
84 84 01-RC-20969 0 1999-04-27T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      
85 85 01-RC-20970 0 1999-04-16T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
86 86 01-RC-20971 0 1999-08-03T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
87 87 01-RC-20972 0 1999-04-16T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
88 88 01-RC-20973 0 1999-04-05T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
89 89 01-RC-20974 0 1999-03-24T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
90 90 01-RC-20975 0 1999-04-05T00:00:00 After Regional Director Decision Issued ARDD Dismissal Dismi      
91 91 01-RC-20976 0 1999-04-12T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
92 92 01-RC-20977 0 1999-04-19T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
93 93 01-RC-20978 0 1999-04-17T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
94 94 01-RC-20979 0 1999-05-05T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
95 95 01-RC-20980 0 1999-10-04T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
96 96 01-RC-20981 0 1999-04-26T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
97 97 01-RC-20982 0 1999-04-26T00:00:00 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
98 98 01-RC-20983 0 1999-05-28T00:00:00 After Regional Director Decision Issued ARDD Certification of Representative Rep      
99 99 01-RC-20984 0 2006-10-17T00:00:00 After Regional Director Decision Issued ARDD Withdrawal With      
100 100 01-RC-20985 0 1999-06-11T00:00:00 After Regional Director Decision Issued ARDD Certification of Results Resul      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_closed_case" (
    "r_case_number" text,
    "action_sequence" integer,
    "closing_date" text,
    "closing_stage" text,
    "closing_method" text,
    "date_file_archives" text,
    "date_file_to_records" text,
    "date_file_destroyed" text,
    FOREIGN KEY (r_case_number) REFERENCES r_case (r_case_number),
    FOREIGN KEY ([closing_stage]) REFERENCES[l_r_closing_stage] ([closing_stage]),
    FOREIGN KEY ([closing_method]) REFERENCES[l_r_closing_method] ([closing_method])
);