Open hermands opened 9 years ago
Please reconcile the most common 'tube_types': (see file /home/local/AMC/hermands/working/Hodgkin/TESTS/01202015/tube_types.txt)
INFO on those with count 50: sqlite> select TubeTypesInstances., count() as count, min(date(date)) as start_date, max(date(date)) as end_date from TubeTypesInstances inner join TubeCases using(tube_type_instance) group by tube_type_instance having count > 50 order by tube_type; tube_type_instance|tube_type|Antigens|count|start_date|end_date 1206|ADDON|CD10;CD19;CD20;CD38;CD45;CD5;CD64;Kappa;Lambda|54|2006-04-05|2009-01-26 514|Add on|CD19;CD20;CD3;CD45;CD56;CD7|88|2006-08-16|2011-04-29 73|Addon 2|CD19;CD20;CD38;CD43;CD45;CD5;Kappa;Lambda;PE-Texas|70|2008-12-04|2014-12-09 9|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58;PE-Texas;Pacific|6748|2011-07-15|2015-01-09 59|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58;PE-Texas|2501|2008-11-20|2014-09-24 1096|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58|1938|2005-11-19|2008-11-20 1427|B Cell|CD10;CD19;CD20;CD38;CD45;CD5;CD95;Kappa;Lambda|236|2006-04-25|2006-06-14 4|B Cells New|CD10;CD19;CD20;CD38;CD45;CD5;Kappa;Lambda;PE-Texas|34526|2008-10-23|2015-01-09 746|B Cells-comped|CD10;CD19;CD20;CD38;CD45;CD5;Kappa;Lambda|18234|2006-02-11|2013-08-17 11|BAL COUNT|7AAD;GLY;PE-Texas;Pacific;SYTO|1496|2011-07-15|2015-01-08 424|BAL COUNT|7AAD;GLY;PE-Texas;SYTO|236|2010-02-02|2011-07-11 414|BAL Count|7AAD;GlyA;PE-Texas;Syto16|154|2010-02-23|2011-07-15 24|Bcl-2 addon|Bcl-2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|348|2009-09-11|2015-01-07 126|Bcl2|Bcl2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|258|2006-06-26|2012-06-24 212|Bone Marrow WBC|CD16;CD33;CD38;CD45;CD71;PE-Texas|1716|2011-01-14|2012-01-17 2087|CART|CD10;CD20;CD22;CD24;CD34;CD38;CD45;CD66b;PE-Texas|369|2014-03-11|2015-01-07 16|CLL TUBE|CD19;CD200;CD23;CD5;FMC7;Pacific|1371|2011-07-13|2015-01-08 81|CLL TUBE|CD19;CD200;CD23;CD5;FMC7|295|2011-01-03|2014-03-26 2081|Expanded Myeloma|CD138;CD20;CD38;CD40;CD45;PE-Texas|139|2008-04-25|2009-01-10 10|Hodgkin|CD15;CD20;CD30;CD40;CD45;CD5;CD64;CD71;CD95|886|2006-10-07|2014-12-26 75|KIR|CD158a;CD158b;CD158e;CD3;CD45;CD7;PE-Texas|160|2009-04-03|2014-12-24 1124|KIR|CD158a;CD158b;CD158e;CD3;CD45;CD7|89|2005-12-01|2009-02-27 19|MASTO rpt|CD117;CD2;CD25;CD45;PE-Texas;Pacific|381|2011-12-20|2014-12-31 137|MASTOCYTOSIS|CD117;CD2;CD25;CD33;CD34;CD38;CD45;HLA-DR;PE-Texas|240|2006-01-05|2012-05-18 2|Myeloid 1|CD117;CD13;CD15;CD19;CD33;CD34;CD38;CD45;CD71;HLA-DR|34701|2005-11-17|2015-01-09 1|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD38;CD4;CD45;CD64;HLA-DR|31496|2006-07-15|2015-01-09 1098|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD36;CD38;CD45;CD64;HLA-DR|475|2005-11-17|2006-02-15 1401|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD38;CD45;CD64;HLA-DR|1170|2006-02-09|2008-03-15 8|Myeloid 4|CD33;CD34;CD38;CD45;CD5;CD56;CD7;PE-Texas;Pacific|8507|2011-07-13|2015-01-08 58|Myeloid 4|CD33;CD34;CD38;CD45;CD5;CD56;CD7;PE-Texas|10400|2006-06-14|2014-09-24 6|NEW PNH RBC|CD59;GlyA;PE-Texas;Pacific|857|2011-07-14|2014-12-31 5|NEW PNH WBC|CD14;CD15;CD24;CD45;CD64;FLAER;PE-Texas|1048|2011-01-04|2014-12-31 64|NEWb|CD10;CD13+33;CD19;CD34;CD45;CD9;PE-Texas;Pacific|195|2011-07-28|2015-01-09 18|Neg MASTO rpt|CD117;CD45;PE-Texas;Pacific|374|2011-12-21|2014-12-31 25|Other B cell|CD103;CD11c;CD19;CD25;CD45;PE-Texas|1205|2005-11-17|2015-01-09 908|PNH|CD14;CD33;CD45;CD66b;PE-Texas|1340|2005-11-18|2010-07-28 119|PNH RBC|CD59;GlyA;PE-Texas|158|2010-05-06|2012-07-08 7|Plasma Cell NEW|CD138;CD19;CD38;CD45;CD56;DAPI;PE-Texas;cyto|7092|2008-12-12|2015-01-08 1100|Plasma Cell NEW|CD19;CD38;CD45;CD56;DAPI;PE-Texas;cyto|3980|2005-11-18|2009-03-03 17|T Beta|A;CD3;CD4;CD5;CD56;CD7;CD8;HLA-DR|323|2005-12-13|2015-01-09 1097|T Cell|CD2;CD3;CD34;CD4;CD45;CD5;CD56;CD7;CD8|10464|2005-11-17|2009-01-20 3|T Cells New|CD2;CD3;CD30;CD34;CD4;CD45;CD5;CD56;CD7;CD8|27407|2007-11-28|2015-01-09 633|T-ALL 2|CD16;CD3;CD34;CD4;CD45;CD48;CD5;CD56;CD7;CD8|1277|2013-01-31|2015-01-08 14|T4|CD16;CD3;CD38;CD45;CD5;CD56;CD7;PE-Texas;cCD3|2204|2007-12-21|2015-01-08 966|WBC|CD34;CD45;CD71;DRAQ5;PE-Texas|792|2005-11-17|2010-05-20 1099|WBC|CD34;CD45;CD71;PE-Texas|3664|2005-11-18|2008-02-15 1055|addon|CD10;CD19;CD20;CD38;CD40;CD45;CD5;Kappa;Lambda|1217|2005-11-17|2014-09-23 360|bcl2|BCL-2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|66|2011-08-26|2015-01-07 13|cMPO neg|CD34;CD45;NEG|247|2008-04-30|2015-01-06 12|cMPO po|CD34;CD45;cCD3;cCD79a;cMPO|257|2008-04-30|2015-01-06 1095|hodgkin|CD15;CD19;CD20;CD30;CD40;CD45;CD5;CD64;CD71;CD95|150|2005-11-21|2008-06-16
Please reconcile the most common 'tube_types': (see file /home/local/AMC/hermands/working/Hodgkin/TESTS/01202015/tube_types.txt)
INFO on those with count 50: sqlite> select TubeTypesInstances., count() as count, min(date(date)) as start_date, max(date(date)) as end_date from TubeTypesInstances inner join TubeCases using(tube_type_instance) group by tube_type_instance having count > 50 order by tube_type; tube_type_instance|tube_type|Antigens|count|start_date|end_date 1206|ADDON|CD10;CD19;CD20;CD38;CD45;CD5;CD64;Kappa;Lambda|54|2006-04-05|2009-01-26 514|Add on|CD19;CD20;CD3;CD45;CD56;CD7|88|2006-08-16|2011-04-29 73|Addon 2|CD19;CD20;CD38;CD43;CD45;CD5;Kappa;Lambda;PE-Texas|70|2008-12-04|2014-12-09 9|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58;PE-Texas;Pacific|6748|2011-07-15|2015-01-09 59|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58;PE-Texas|2501|2008-11-20|2014-09-24 1096|B ALL MRD|CD10;CD19;CD20;CD34;CD38;CD45;CD58|1938|2005-11-19|2008-11-20 1427|B Cell|CD10;CD19;CD20;CD38;CD45;CD5;CD95;Kappa;Lambda|236|2006-04-25|2006-06-14 4|B Cells New|CD10;CD19;CD20;CD38;CD45;CD5;Kappa;Lambda;PE-Texas|34526|2008-10-23|2015-01-09 746|B Cells-comped|CD10;CD19;CD20;CD38;CD45;CD5;Kappa;Lambda|18234|2006-02-11|2013-08-17 11|BAL COUNT|7AAD;GLY;PE-Texas;Pacific;SYTO|1496|2011-07-15|2015-01-08 424|BAL COUNT|7AAD;GLY;PE-Texas;SYTO|236|2010-02-02|2011-07-11 414|BAL Count|7AAD;GlyA;PE-Texas;Syto16|154|2010-02-23|2011-07-15 24|Bcl-2 addon|Bcl-2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|348|2009-09-11|2015-01-07 126|Bcl2|Bcl2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|258|2006-06-26|2012-06-24 212|Bone Marrow WBC|CD16;CD33;CD38;CD45;CD71;PE-Texas|1716|2011-01-14|2012-01-17 2087|CART|CD10;CD20;CD22;CD24;CD34;CD38;CD45;CD66b;PE-Texas|369|2014-03-11|2015-01-07 16|CLL TUBE|CD19;CD200;CD23;CD5;FMC7;Pacific|1371|2011-07-13|2015-01-08 81|CLL TUBE|CD19;CD200;CD23;CD5;FMC7|295|2011-01-03|2014-03-26 2081|Expanded Myeloma|CD138;CD20;CD38;CD40;CD45;PE-Texas|139|2008-04-25|2009-01-10 10|Hodgkin|CD15;CD20;CD30;CD40;CD45;CD5;CD64;CD71;CD95|886|2006-10-07|2014-12-26 75|KIR|CD158a;CD158b;CD158e;CD3;CD45;CD7;PE-Texas|160|2009-04-03|2014-12-24 1124|KIR|CD158a;CD158b;CD158e;CD3;CD45;CD7|89|2005-12-01|2009-02-27 19|MASTO rpt|CD117;CD2;CD25;CD45;PE-Texas;Pacific|381|2011-12-20|2014-12-31 137|MASTOCYTOSIS|CD117;CD2;CD25;CD33;CD34;CD38;CD45;HLA-DR;PE-Texas|240|2006-01-05|2012-05-18 2|Myeloid 1|CD117;CD13;CD15;CD19;CD33;CD34;CD38;CD45;CD71;HLA-DR|34701|2005-11-17|2015-01-09 1|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD38;CD4;CD45;CD64;HLA-DR|31496|2006-07-15|2015-01-09 1098|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD36;CD38;CD45;CD64;HLA-DR|475|2005-11-17|2006-02-15 1401|Myeloid 2|CD123;CD13;CD14;CD16;CD34;CD38;CD45;CD64;HLA-DR|1170|2006-02-09|2008-03-15 8|Myeloid 4|CD33;CD34;CD38;CD45;CD5;CD56;CD7;PE-Texas;Pacific|8507|2011-07-13|2015-01-08 58|Myeloid 4|CD33;CD34;CD38;CD45;CD5;CD56;CD7;PE-Texas|10400|2006-06-14|2014-09-24 6|NEW PNH RBC|CD59;GlyA;PE-Texas;Pacific|857|2011-07-14|2014-12-31 5|NEW PNH WBC|CD14;CD15;CD24;CD45;CD64;FLAER;PE-Texas|1048|2011-01-04|2014-12-31 64|NEWb|CD10;CD13+33;CD19;CD34;CD45;CD9;PE-Texas;Pacific|195|2011-07-28|2015-01-09 18|Neg MASTO rpt|CD117;CD45;PE-Texas;Pacific|374|2011-12-21|2014-12-31 25|Other B cell|CD103;CD11c;CD19;CD25;CD45;PE-Texas|1205|2005-11-17|2015-01-09 908|PNH|CD14;CD33;CD45;CD66b;PE-Texas|1340|2005-11-18|2010-07-28 119|PNH RBC|CD59;GlyA;PE-Texas|158|2010-05-06|2012-07-08 7|Plasma Cell NEW|CD138;CD19;CD38;CD45;CD56;DAPI;PE-Texas;cyto|7092|2008-12-12|2015-01-08 1100|Plasma Cell NEW|CD19;CD38;CD45;CD56;DAPI;PE-Texas;cyto|3980|2005-11-18|2009-03-03 17|T Beta|A;CD3;CD4;CD5;CD56;CD7;CD8;HLA-DR|323|2005-12-13|2015-01-09 1097|T Cell|CD2;CD3;CD34;CD4;CD45;CD5;CD56;CD7;CD8|10464|2005-11-17|2009-01-20 3|T Cells New|CD2;CD3;CD30;CD34;CD4;CD45;CD5;CD56;CD7;CD8|27407|2007-11-28|2015-01-09 633|T-ALL 2|CD16;CD3;CD34;CD4;CD45;CD48;CD5;CD56;CD7;CD8|1277|2013-01-31|2015-01-08 14|T4|CD16;CD3;CD38;CD45;CD5;CD56;CD7;PE-Texas;cCD3|2204|2007-12-21|2015-01-08 966|WBC|CD34;CD45;CD71;DRAQ5;PE-Texas|792|2005-11-17|2010-05-20 1099|WBC|CD34;CD45;CD71;PE-Texas|3664|2005-11-18|2008-02-15 1055|addon|CD10;CD19;CD20;CD38;CD40;CD45;CD5;Kappa;Lambda|1217|2005-11-17|2014-09-23 360|bcl2|BCL-2;CD10;CD19;CD20;CD38;CD45;CD5;PE-Texas|66|2011-08-26|2015-01-07 13|cMPO neg|CD34;CD45;NEG|247|2008-04-30|2015-01-06 12|cMPO po|CD34;CD45;cCD3;cCD79a;cMPO|257|2008-04-30|2015-01-06 1095|hodgkin|CD15;CD19;CD20;CD30;CD40;CD45;CD5;CD64;CD71;CD95|150|2005-11-21|2008-06-16