r_case_case_group
2,283 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | r_case_group_id | r_case_number | sequence | date_case_added | lead | date_case_removed |
|---|---|---|---|---|---|---|---|
| 1 | 1 | 01-36243.048696 | 01-RC-20914 | 1 | 1998-10-22T00:00:00 | N | |
| 2 | 2 | 01-36243.048696 | 01-RC-20915 | 1 | 1998-10-22T00:00:00 | Y | |
| 3 | 3 | 01-36413.796173 | 01-RC-21067 | 1 | 1999-09-03T00:00:00 | Y | |
| 4 | 4 | 01-36413.796173 | 01-RC-21068 | 1 | 1999-09-03T00:00:00 | N | |
| 5 | 5 | 01-36423.799427 | 01-RC-21070 | 1 | 1999-09-20T00:00:00 | Y | |
| 6 | 6 | 01-36423.799427 | 01-RC-21079 | 1 | 1999-09-20T00:00:00 | N | |
| 7 | 7 | 01-36423.799427 | 01-RC-21080 | 1 | 1999-09-20T00:00:00 | N | |
| 8 | 8 | 01-36434.969759 | 01-RC-21085 | 1 | 1999-10-01T00:00:00 | N | |
| 9 | 9 | 01-36434.969759 | 01-RC-21086 | 1 | 1999-10-01T00:00:00 | Y | |
| 10 | 10 | 01-36446.722429 | 01-UC-00744 | 1 | 1999-10-13T00:00:00 | Y | |
| 11 | 11 | 01-36446.722429 | 01-UC-00745 | 1 | 1999-10-13T00:00:00 | N | |
| 12 | 12 | 01-36462.722038 | 01-RC-21075 | 1 | 1999-10-29T00:00:00 | Y | |
| 13 | 13 | 01-36462.722038 | 01-RC-21076 | 1 | 1999-10-29T00:00:00 | N | |
| 14 | 14 | 01-36613.471371 | 01-RC-21102 | 1 | 2000-03-28T00:00:00 | N | 2000-06-06T00:00:00 |
| 15 | 15 | 01-36629.409265 | 01-RC-21111 | 1 | 2000-04-11T00:00:00 | Y | |
| 16 | 16 | 01-36873.411272 | 01-RC-21198 | 1 | 2000-12-13T00:00:00 | N | 2001-10-15T00:00:00 |
| 17 | 17 | 01-36916.401925 | 01-RC-21301 | 1 | 2001-01-25T00:00:00 | Y | |
| 18 | 18 | 01-36916.401925 | 01-RC-21302 | 1 | 2001-01-25T00:00:00 | N | |
| 19 | 19 | 01-36972.579500 | 01-UC-00767 | 1 | 2001-03-21T00:00:00 | Y | |
| 20 | 20 | 01-36972.579500 | 01-UC-00772 | 1 | 2001-03-21T00:00:00 | N | |
| 21 | 21 | 01-36977.421884 | 01-RC-21213 | 1 | 2001-03-27T00:00:00 | N | 2001-05-11T00:00:00 |
| 22 | 22 | 01-36992.547186 | 01-UC-00770 | 1 | 2001-04-11T00:00:00 | N | 2005-10-19T00:00:00 |
| 23 | 23 | 01-36992.547186 | 01-UC-00771 | 1 | 2001-04-11T00:00:00 | N | 2005-10-19T00:00:00 |
| 24 | 24 | 01-37008.591652 | 01-RC-21240 | 1 | 2001-04-27T00:00:00 | Y | |
| 25 | 25 | 01-37008.591652 | 01-RC-21241 | 1 | 2001-04-27T00:00:00 | N | |
| 26 | 26 | 01-37018.477890 | 01-RC-21350 | 1 | 2001-05-07T00:00:00 | Y | |
| 27 | 27 | 01-37018.477890 | 01-RC-21358 | 1 | 2001-05-07T00:00:00 | N | |
| 28 | 28 | 01-37239.401249 | 01-RC-21446 | 1 | 2001-12-14T00:00:00 | Y | |
| 29 | 29 | 01-37239.401249 | 01-RC-21448 | 1 | 2001-12-14T00:00:00 | N | |
| 30 | 30 | 01-37301.343651 | 01-RC-21467 | 1 | 2002-02-14T00:00:00 | N | 2002-02-15T00:00:00 |
| 31 | 31 | 01-37301.343651 | 01-RC-21468 | 1 | 2002-02-14T00:00:00 | N | 2002-02-15T00:00:00 |
| 32 | 32 | 01-37316.342562 | 01-UC-00785 | 1 | 2002-03-01T00:00:00 | Y | |
| 33 | 33 | 01-37316.342562 | 01-UC-00786 | 1 | 2002-03-01T00:00:00 | N | |
| 34 | 34 | 01-37323.436866 | 01-RC-21404 | 1 | 2002-03-08T00:00:00 | N | |
| 35 | 35 | 01-37328.467727 | 01-RC-21243 | 1 | 2002-01-14T00:00:00 | N | 2002-01-15T00:00:00 |
| 36 | 36 | 01-37462.368905 | 01-UC-00796 | 1 | 2002-07-23T00:00:00 | Y | |
| 37 | 37 | 01-37462.368905 | 01-UC-00797 | 1 | 2002-07-23T00:00:00 | N | |
| 38 | 38 | 01-37476.357976 | 01-UC-00792 | 1 | 2002-08-08T00:00:00 | N | |
| 39 | 39 | 01-37476.357976 | 01-UC-00793 | 1 | 2002-08-08T00:00:00 | Y | |
| 40 | 40 | 01-37568.383227 | 01-UC-00799 | 1 | 2002-11-08T00:00:00 | Y | |
| 41 | 41 | 01-37568.383227 | 01-UC-00802 | 1 | 2002-11-08T00:00:00 | N | |
| 42 | 42 | 01-37711.442178 | 01-RC-21615 | 1 | 2003-03-31T00:00:00 | Y | |
| 43 | 43 | 01-37711.442178 | 01-RC-21616 | 1 | 2003-03-31T00:00:00 | N | |
| 44 | 44 | 01-37711.628681 | 01-RC-21516 | 1 | 2003-05-05T00:00:00 | N | |
| 45 | 45 | 01-37795.478677 | 01-RC-21649 | 1 | 2003-06-23T00:00:00 | Y | |
| 46 | 46 | 01-37795.478677 | 01-RC-21650 | 1 | 2003-06-23T00:00:00 | N | |
| 47 | 47 | 01-37956.654249 | 01-RM-01263 | 1 | 2003-11-26T00:00:00 | Y | |
| 48 | 48 | 01-37956.654249 | 01-UC-00815 | 1 | 2003-11-26T00:00:00 | N | |
| 49 | 49 | 01-38001.693208 | 01-RC-21685 | 1 | 2004-01-15T00:00:00 | N | |
| 50 | 50 | 01-38002.349295 | 01-RC-21653 | 1 | 2003-12-15T00:00:00 | N | |
| 51 | 51 | 01-38077.386266 | 01-RD-02034 | 1 | 2004-03-24T00:00:00 | Y | |
| 52 | 52 | 01-38077.386266 | 01-UD-00278 | 1 | 2004-03-24T00:00:00 | N | |
| 53 | 53 | 01-38163.638410 | 01-RC-21749 | 1 | 2004-07-01T00:00:00 | N | |
| 54 | 54 | 01-38306.421056 | 01-RM-01269 | 1 | 2004-11-12T00:00:00 | Y | |
| 55 | 55 | 01-38306.421056 | 01-RM-01270 | 1 | 2004-11-12T00:00:00 | N | |
| 56 | 56 | 01-38306.421056 | 01-RM-01271 | 1 | 2004-11-12T00:00:00 | N | |
| 57 | 57 | 01-38306.421056 | 01-RM-01272 | 1 | 2004-11-12T00:00:00 | N | |
| 58 | 58 | 01-38306.421056 | 01-RM-01273 | 1 | 2004-11-12T00:00:00 | N | |
| 59 | 59 | 01-38359.469056 | 01-RC-21862 | 1 | 2005-01-07T00:00:00 | Y | |
| 60 | 60 | 01-38359.469056 | 01-RC-21863 | 1 | 2005-01-07T00:00:00 | N | |
| 61 | 61 | 01-38359.469056 | 01-RC-21864 | 1 | 2005-01-07T00:00:00 | N | |
| 62 | 62 | 01-38362.408157 | 01-RD-02045 | 1 | 2005-01-10T00:00:00 | Y | |
| 63 | 63 | 01-38362.408157 | 01-UD-00279 | 1 | 2005-01-10T00:00:00 | N | |
| 64 | 64 | 01-38366.575206 | 01-RD-02003 | 1 | 2005-01-06T00:00:00 | N | 2005-04-28T00:00:00 |
| 65 | 65 | 01-38366.575206 | 01-RD-02049 | 1 | 2005-01-06T00:00:00 | N | 2005-04-28T00:00:00 |
| 66 | 66 | 01-38366.575206 | 01-RM-01268 | 1 | 2005-01-06T00:00:00 | N | 2005-04-28T00:00:00 |
| 67 | 67 | 01-38475.592861 | 01-RD-02003 | 1 | 2005-04-29T00:00:00 | N | 2005-06-12T00:00:00 |
| 68 | 68 | 01-38475.592861 | 01-RD-02049 | 1 | 2005-04-29T00:00:00 | N | 2005-06-12T00:00:00 |
| 69 | 69 | 01-38475.592861 | 01-RM-01268 | 1 | 2005-04-29T00:00:00 | N | 2005-06-12T00:00:00 |
| 70 | 70 | 01-38511.392977 | 01-RC-21923 | 1 | 2005-06-08T00:00:00 | Y | |
| 71 | 71 | 01-38511.392977 | 01-RC-21924 | 1 | 2005-06-08T00:00:00 | N | |
| 72 | 72 | 01-38520.397169 | 01-RC-21928 | 1 | 2005-06-17T00:00:00 | Y | |
| 73 | 73 | 01-38520.397169 | 01-RC-21929 | 1 | 2005-06-17T00:00:00 | N | |
| 74 | 74 | 01-38804.608445 | 01-UC-00839 | 1 | 2006-03-06T00:00:00 | Y | |
| 75 | 75 | 01-38804.608445 | 01-UC-00841 | 1 | 2006-03-06T00:00:00 | N | |
| 76 | 76 | 01-38911.665730 | 01-RC-22034 | 1 | 2006-07-13T00:00:00 | Y | |
| 77 | 77 | 01-38911.665730 | 01-RC-22035 | 1 | 2006-07-13T00:00:00 | N | |
| 78 | 78 | 01-38958.659668 | 01-RC-22008 | 1 | 2006-09-29T00:00:00 | N | 2006-12-05T00:00:00 |
| 79 | 79 | 01-39224.651319 | 01-RC-22087 | 1 | 2007-05-18T00:00:00 | Y | |
| 80 | 80 | 01-39224.651319 | 01-RC-22092 | 1 | 2007-05-18T00:00:00 | N | |
| 81 | 81 | 01-39449.547775 | 01-RC-22168 | 1 | 2007-12-27T00:00:00 | N | |
| 82 | 82 | 01-39449.547775 | 01-RC-22169 | 1 | 2007-12-27T00:00:00 | N | |
| 83 | 83 | 01-39449.547775 | 01-RC-22170 | 1 | 2007-12-27T00:00:00 | Y | |
| 84 | 84 | 01-39449.658321 | 01-RC-22171 | 1 | 2007-12-28T00:00:00 | N | |
| 85 | 85 | 01-39449.658321 | 01-RC-22172 | 1 | 2007-12-28T00:00:00 | N | |
| 86 | 86 | 01-39449.658321 | 01-RC-22173 | 1 | 2007-12-28T00:00:00 | N | |
| 87 | 87 | 01-39449.658321 | 01-RC-22174 | 1 | 2007-12-28T00:00:00 | Y | |
| 88 | 88 | 01-39569.481016 | 01-UC-00866 | 1 | 2008-04-28T00:00:00 | Y | |
| 89 | 89 | 01-39569.481016 | 01-UC-00867 | 1 | 2008-04-28T00:00:00 | N | |
| 90 | 90 | 01-40262.456732 | 01-RC-22433 | 1 | 2010-03-25T00:00:00 | Y | |
| 91 | 91 | 01-40262.456732 | 01-RC-22434 | 1 | 2010-03-25T00:00:00 | N | |
| 92 | 92 | 01-40262.456732 | 01-RC-22435 | 1 | 2010-03-25T00:00:00 | N | |
| 93 | 93 | 01-40262.456732 | 01-RC-22436 | 1 | 2010-03-25T00:00:00 | N | |
| 94 | 94 | 01-40644.369269 | 01-RC-22535 | 1 | 2011-04-08T00:00:00 | Y | |
| 95 | 95 | 01-40644.369269 | 01-UC-00885 | 1 | 2011-04-08T00:00:00 | N | |
| 96 | 96 | 02-36656.640677 | 02-RC-22142 | 1 | 1999-10-14T00:00:00 | N | |
| 97 | 97 | 02-36656.640677 | 02-RD-01440 | 1 | 1999-10-14T00:00:00 | Y | |
| 98 | 98 | 02-36663.399311 | 02-RC-22219 | 1 | 2000-05-04T00:00:00 | Y | |
| 99 | 99 | 02-36663.399311 | 02-RC-22220 | 1 | 2000-05-04T00:00:00 | N | |
| 100 | 100 | 02-36802.562311 | 02-UD-00337 | 1 | 2000-10-03T00:00:00 | Y |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "r_case_case_group" (
"r_case_group_id" text,
"r_case_number" text,
"sequence" integer,
"date_case_added" text,
"lead" text,
"date_case_removed" text,
FOREIGN KEY (r_case_group_id) REFERENCES r_case_group (r_case_group_id)
);