CREATE TABLE rhino_symptom_viro /* from Aimee's 08mar24 report score charts and shed/sero results */ ( subject_id INTEGER, score INTEGER, /* Score: Asx 0 Mild 1 Ramp 2 Abrupt 3 */ shed BOOLEAN, /* TinyInt 0 is false 1 is true */ seroconv BOOLEAN ); subject,score,shed,seroconv 02,0,0,0 08,0,0,0 13,0,0,0 18,0,0,0 12,0,1,0 14,0,0,1 17,0,1,1 05,0,1,1 01,1,1,1 09,1,1,1 11,1,1,1 19,1,1,1 10,1,0,0 07,2,1,1 15,2,1,1 16,2,1,0 04,2,1,0 06,2,1,0 20,3,1,1 03,3,1,1