home / cats / r_closed_case

r_closed_case

53,740 rows

✎ View and edit SQL

Suggested facets: action_sequence, closing_stage, closing_method, closing_date (date), date_file_archives (date), date_file_to_records (date), date_file_destroyed (date)

r_case_number action_sequence closing_date closing_stage closing_method date_file_archives date_file_to_records date_file_destroyed
01-AC-00093 0 2000-02-09 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Dismissal Dismi      
01-AC-00094 0 2001-08-23 After Regional Director Decision Issued ARDD Dismissal Dismi      
01-AC-00095 0 2001-10-10 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
01-AC-00096 0 2002-06-12 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
01-AC-00097 0 2003-11-05 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
01-AC-00098 0 2008-05-09 After Regional Director Decision Issued ARDD Dismissal Dismi      
01-AC-00099 0 2009-02-04 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
01-AC-00100 0 2009-08-24 Before Issuance of Notice of Hearing BfrNH Dismissal Dismi      
01-AC-00101 0 2010-12-31 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
01-AC-00102 0 2010-12-31 Before Issuance of Notice of Hearing BfrNH Amended Certification AmCrt      
01-RC-19536 0 2002-05-10 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-19910 0 2003-11-14 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-19926 0 1999-11-12 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-19980 0 1999-08-16 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20080 0 2000-01-11 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20106 0 2003-11-21 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20292 0 1999-10-01 After Board Decision Issued ABD Certification of Representative Rep      
01-RC-20309 0 2000-02-23 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20310 0 2000-02-23 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20360 0 2003-12-16 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
01-RC-20460 0 2003-11-05 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20463 0 1999-10-27 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20467 0 2001-01-10 After Board Decision Issued ABD Withdrawal With      
01-RC-20508 0 1999-10-28 After Board Decision Issued ABD Certification of Results Resul      
01-RC-20538 0 2003-11-10 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20574 0 2000-01-03 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20600 0 2002-05-10 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20622 0 2003-11-17 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20626 0 2005-01-06 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20634 0 2005-01-06 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20649 0 1999-09-14 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Dismissal Dismi      
01-RC-20761 0 2001-03-01 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20804 0 1999-11-17 After Board Decision Issued ABD Certification of Representative Rep      
01-RC-20815 0 2001-03-23 After Board Decision Issued ABD Certification of Results Resul      
01-RC-20826 0 2002-05-17 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20869 0 1999-01-08 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20880 0 2002-05-20 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20890 0 1999-01-25 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20897 0 1999-04-12 After Board Decision Issued ABD Certification of Results Resul      
01-RC-20905 0 1999-01-12 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20906 0 1999-03-01 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20910 0 1999-01-27 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20912 0 1999-01-12 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20914 0 1999-02-02 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20915 0 1999-02-02 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20916 0 2003-11-06 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20921 0 1999-01-26 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20922 0 2000-01-07 Before Issuance of Notice of Hearing BfrNH Withdrawal With      
01-RC-20923 0 1999-04-07 After Board Decision Issued ABD Certification of Results Resul      
01-RC-20924 0 1999-10-28 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20925 0 1999-01-22 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20927 0 1999-02-01 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20935 0 1999-07-09 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20936 0 1999-01-08 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20937 0 1999-01-09 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20938 0 1999-01-25 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20939 0 1999-01-19 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20940 0 1999-03-12 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20941 0 1999-04-16 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20942 0 1999-01-25 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20943 0 1999-01-13 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20944 0 1999-02-01 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20945 0 1999-02-08 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20946 0 1999-02-01 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20947 0 1999-03-31 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20948 0 1999-02-26 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20949 0 1999-02-26 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20950 0 1999-02-19 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20952 0 1999-02-19 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20953 0 1999-02-01 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20955 0 1999-02-08 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20956 0 1999-02-02 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20957 0 1999-02-23 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20958 0 1999-03-09 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20959 0 1999-02-19 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20960 0 1999-03-24 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20961 0 1999-02-22 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20962 0 1999-03-03 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20963 0 1999-03-01 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20964 0 1999-03-08 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20965 0 1999-03-03          
01-RC-20966 0 1999-08-04 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20968 0 1999-04-12 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20969 0 1999-04-27 After Regional Director Decision Issued ARDD Certification of Results Resul      
01-RC-20970 0 1999-04-16 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20971 0 1999-08-03 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20972 0 1999-04-16 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20973 0 1999-04-05 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20974 0 1999-03-24 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20975 0 1999-04-05 After Regional Director Decision Issued ARDD Dismissal Dismi      
01-RC-20976 0 1999-04-12 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20977 0 1999-04-19 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20978 0 1999-04-17 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20979 0 1999-05-05 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Results Resul      
01-RC-20980 0 1999-10-04 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Withdrawal With      
01-RC-20981 0 1999-04-26 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20982 0 1999-04-26 After Not of Hrg Issued, Bfor Hrg Closed ANBHC Certification of Representative Rep      
01-RC-20983 0 1999-05-28 After Regional Director Decision Issued ARDD Certification of Representative Rep      
01-RC-20984 0 2006-10-17 After Regional Director Decision Issued ARDD Withdrawal With      
01-RC-20985 0 1999-06-11 After Regional Director Decision Issued ARDD Certification of Results Resul      

Next page

Download this data

CSV · JSON

Table schema
CREATE TABLE r_closed_case(r_case_number VARCHAR, action_sequence BIGINT, closing_date DATE, closing_stage VARCHAR, closing_method VARCHAR, date_file_archives DATE, date_file_to_records DATE, date_file_destroyed DATE, FOREIGN KEY (closing_method) REFERENCES l_r_closing_method(closing_method), FOREIGN KEY (closing_stage) REFERENCES l_r_closing_stage(closing_stage), FOREIGN KEY (r_case_number) REFERENCES r_case(r_case_number));

Queries took 1.2ms

A project of Forest Gregg. Read about project updates on Notes on Labor Data.