r_case_case_group
2,283 rows
Suggested facets: sequence, lead, date_case_added (date), date_case_removed (date)
| r_case_group_id | r_case_number | sequence | date_case_added | lead | date_case_removed |
|---|---|---|---|---|---|
| 01-36243.048696 | 01-RC-20914 | 1 | 1998-10-22 | N | |
| 01-36243.048696 | 01-RC-20915 | 1 | 1998-10-22 | Y | |
| 01-36413.796173 | 01-RC-21067 | 1 | 1999-09-03 | Y | |
| 01-36413.796173 | 01-RC-21068 | 1 | 1999-09-03 | N | |
| 01-36423.799427 | 01-RC-21070 | 1 | 1999-09-20 | Y | |
| 01-36423.799427 | 01-RC-21079 | 1 | 1999-09-20 | N | |
| 01-36423.799427 | 01-RC-21080 | 1 | 1999-09-20 | N | |
| 01-36434.969759 | 01-RC-21085 | 1 | 1999-10-01 | N | |
| 01-36434.969759 | 01-RC-21086 | 1 | 1999-10-01 | Y | |
| 01-36446.722429 | 01-UC-00744 | 1 | 1999-10-13 | Y | |
| 01-36446.722429 | 01-UC-00745 | 1 | 1999-10-13 | N | |
| 01-36462.722038 | 01-RC-21075 | 1 | 1999-10-29 | Y | |
| 01-36462.722038 | 01-RC-21076 | 1 | 1999-10-29 | N | |
| 01-36613.471371 | 01-RC-21102 | 1 | 2000-03-28 | N | 2000-06-06 |
| 01-36629.409265 | 01-RC-21111 | 1 | 2000-04-11 | Y | |
| 01-36873.411272 | 01-RC-21198 | 1 | 2000-12-13 | N | 2001-10-15 |
| 01-36916.401925 | 01-RC-21301 | 1 | 2001-01-25 | Y | |
| 01-36916.401925 | 01-RC-21302 | 1 | 2001-01-25 | N | |
| 01-36972.579500 | 01-UC-00767 | 1 | 2001-03-21 | Y | |
| 01-36972.579500 | 01-UC-00772 | 1 | 2001-03-21 | N | |
| 01-36977.421884 | 01-RC-21213 | 1 | 2001-03-27 | N | 2001-05-11 |
| 01-36992.547186 | 01-UC-00770 | 1 | 2001-04-11 | N | 2005-10-19 |
| 01-36992.547186 | 01-UC-00771 | 1 | 2001-04-11 | N | 2005-10-19 |
| 01-37008.591652 | 01-RC-21240 | 1 | 2001-04-27 | Y | |
| 01-37008.591652 | 01-RC-21241 | 1 | 2001-04-27 | N | |
| 01-37018.477890 | 01-RC-21350 | 1 | 2001-05-07 | Y | |
| 01-37018.477890 | 01-RC-21358 | 1 | 2001-05-07 | N | |
| 01-37239.401249 | 01-RC-21446 | 1 | 2001-12-14 | Y | |
| 01-37239.401249 | 01-RC-21448 | 1 | 2001-12-14 | N | |
| 01-37301.343651 | 01-RC-21467 | 1 | 2002-02-14 | N | 2002-02-15 |
| 01-37301.343651 | 01-RC-21468 | 1 | 2002-02-14 | N | 2002-02-15 |
| 01-37316.342562 | 01-UC-00785 | 1 | 2002-03-01 | Y | |
| 01-37316.342562 | 01-UC-00786 | 1 | 2002-03-01 | N | |
| 01-37323.436866 | 01-RC-21404 | 1 | 2002-03-08 | N | |
| 01-37328.467727 | 01-RC-21243 | 1 | 2002-01-14 | N | 2002-01-15 |
| 01-37462.368905 | 01-UC-00796 | 1 | 2002-07-23 | Y | |
| 01-37462.368905 | 01-UC-00797 | 1 | 2002-07-23 | N | |
| 01-37476.357976 | 01-UC-00792 | 1 | 2002-08-08 | N | |
| 01-37476.357976 | 01-UC-00793 | 1 | 2002-08-08 | Y | |
| 01-37568.383227 | 01-UC-00799 | 1 | 2002-11-08 | Y | |
| 01-37568.383227 | 01-UC-00802 | 1 | 2002-11-08 | N | |
| 01-37711.442178 | 01-RC-21615 | 1 | 2003-03-31 | Y | |
| 01-37711.442178 | 01-RC-21616 | 1 | 2003-03-31 | N | |
| 01-37711.628681 | 01-RC-21516 | 1 | 2003-05-05 | N | |
| 01-37795.478677 | 01-RC-21649 | 1 | 2003-06-23 | Y | |
| 01-37795.478677 | 01-RC-21650 | 1 | 2003-06-23 | N | |
| 01-37956.654249 | 01-RM-01263 | 1 | 2003-11-26 | Y | |
| 01-37956.654249 | 01-UC-00815 | 1 | 2003-11-26 | N | |
| 01-38001.693208 | 01-RC-21685 | 1 | 2004-01-15 | N | |
| 01-38002.349295 | 01-RC-21653 | 1 | 2003-12-15 | N | |
| 01-38077.386266 | 01-RD-02034 | 1 | 2004-03-24 | Y | |
| 01-38077.386266 | 01-UD-00278 | 1 | 2004-03-24 | N | |
| 01-38163.638410 | 01-RC-21749 | 1 | 2004-07-01 | N | |
| 01-38306.421056 | 01-RM-01269 | 1 | 2004-11-12 | Y | |
| 01-38306.421056 | 01-RM-01270 | 1 | 2004-11-12 | N | |
| 01-38306.421056 | 01-RM-01271 | 1 | 2004-11-12 | N | |
| 01-38306.421056 | 01-RM-01272 | 1 | 2004-11-12 | N | |
| 01-38306.421056 | 01-RM-01273 | 1 | 2004-11-12 | N | |
| 01-38359.469056 | 01-RC-21862 | 1 | 2005-01-07 | Y | |
| 01-38359.469056 | 01-RC-21863 | 1 | 2005-01-07 | N | |
| 01-38359.469056 | 01-RC-21864 | 1 | 2005-01-07 | N | |
| 01-38362.408157 | 01-RD-02045 | 1 | 2005-01-10 | Y | |
| 01-38362.408157 | 01-UD-00279 | 1 | 2005-01-10 | N | |
| 01-38366.575206 | 01-RD-02003 | 1 | 2005-01-06 | N | 2005-04-28 |
| 01-38366.575206 | 01-RD-02049 | 1 | 2005-01-06 | N | 2005-04-28 |
| 01-38366.575206 | 01-RM-01268 | 1 | 2005-01-06 | N | 2005-04-28 |
| 01-38475.592861 | 01-RD-02003 | 1 | 2005-04-29 | N | 2005-06-12 |
| 01-38475.592861 | 01-RD-02049 | 1 | 2005-04-29 | N | 2005-06-12 |
| 01-38475.592861 | 01-RM-01268 | 1 | 2005-04-29 | N | 2005-06-12 |
| 01-38511.392977 | 01-RC-21923 | 1 | 2005-06-08 | Y | |
| 01-38511.392977 | 01-RC-21924 | 1 | 2005-06-08 | N | |
| 01-38520.397169 | 01-RC-21928 | 1 | 2005-06-17 | Y | |
| 01-38520.397169 | 01-RC-21929 | 1 | 2005-06-17 | N | |
| 01-38804.608445 | 01-UC-00839 | 1 | 2006-03-06 | Y | |
| 01-38804.608445 | 01-UC-00841 | 1 | 2006-03-06 | N | |
| 01-38911.665730 | 01-RC-22034 | 1 | 2006-07-13 | Y | |
| 01-38911.665730 | 01-RC-22035 | 1 | 2006-07-13 | N | |
| 01-38958.659668 | 01-RC-22008 | 1 | 2006-09-29 | N | 2006-12-05 |
| 01-39224.651319 | 01-RC-22087 | 1 | 2007-05-18 | Y | |
| 01-39224.651319 | 01-RC-22092 | 1 | 2007-05-18 | N | |
| 01-39449.547775 | 01-RC-22168 | 1 | 2007-12-27 | N | |
| 01-39449.547775 | 01-RC-22169 | 1 | 2007-12-27 | N | |
| 01-39449.547775 | 01-RC-22170 | 1 | 2007-12-27 | Y | |
| 01-39449.658321 | 01-RC-22171 | 1 | 2007-12-28 | N | |
| 01-39449.658321 | 01-RC-22172 | 1 | 2007-12-28 | N | |
| 01-39449.658321 | 01-RC-22173 | 1 | 2007-12-28 | N | |
| 01-39449.658321 | 01-RC-22174 | 1 | 2007-12-28 | Y | |
| 01-39569.481016 | 01-UC-00866 | 1 | 2008-04-28 | Y | |
| 01-39569.481016 | 01-UC-00867 | 1 | 2008-04-28 | N | |
| 01-40262.456732 | 01-RC-22433 | 1 | 2010-03-25 | Y | |
| 01-40262.456732 | 01-RC-22434 | 1 | 2010-03-25 | N | |
| 01-40262.456732 | 01-RC-22435 | 1 | 2010-03-25 | N | |
| 01-40262.456732 | 01-RC-22436 | 1 | 2010-03-25 | N | |
| 01-40644.369269 | 01-RC-22535 | 1 | 2011-04-08 | Y | |
| 01-40644.369269 | 01-UC-00885 | 1 | 2011-04-08 | N | |
| 02-36656.640677 | 02-RC-22142 | 1 | 1999-10-14 | N | |
| 02-36656.640677 | 02-RD-01440 | 1 | 1999-10-14 | Y | |
| 02-36663.399311 | 02-RC-22219 | 1 | 2000-05-04 | Y | |
| 02-36663.399311 | 02-RC-22220 | 1 | 2000-05-04 | N | |
| 02-36802.562311 | 02-UD-00337 | 1 | 2000-10-03 | Y |
Table schema
CREATE TABLE r_case_case_group(r_case_group_id VARCHAR, r_case_number VARCHAR, "sequence" BIGINT, date_case_added DATE, lead VARCHAR, date_case_removed DATE, FOREIGN KEY (r_case_group_id) REFERENCES r_case_group(r_case_group_id));