규격화한 한국 메르스 확진자 정보 / Structured Korean MERS Patient Information

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		Disclaimer: I'm not responsible for any errors or mis-interpretation. This is entirely done for my own curiosity, and provided as is without any warranty. twitter.com/woohyong
2		주의: 이 자료의 정확성이나 무오류성에 대한 아무런 책임을 지지 않습니다. 제 궁금함을 충족하기 위해 만들어진 자료이며, 아무런 보증 없이 공개합니다. twitter.com/woohyong
3
4		원자료: 보건복지부 일일 보도자료 Source: Korean Ministry of Health and Welfare (referred as MOH hereafter) Press Release
5		6/19/2015	6/18/2015	6/17/2015	6/16/2015	6/15/2015	6/14/2015	6/13/2015	6/12/2015	6/11/2015 #2	6/11/2015 #1	6/10/2015	6/9/2015	6/8/2015	6/7/2015
6		최종 업데이트: 6월19일 보도자료 / Last update based Koean MOH Press Release on Jun 19.
7
8	복지부자료	복지부자료	복지부자료	복지부자료	복지부자료	복지부자료	복지부자료	계산값	복지부자료	별도 추가분류	밀접접촉 이력바탕 추산	계산값	계산값	복지부기본자료 + 별도채널 추가수집 개인추적자료	별도추적	별도추적	계산값	계산값
9	환자 ID	환자 성별	환자 나이	증상 발현 일자	확진 일자	감염장소	감염원	감염차수	감염원과 관계	감염원 관계코드	최초밀접접촉 가능일	최초밀접접촉 가능일부터 증상발현까지 잠복시간	최초밀접접촉 가능일부터 확진까지 시간	규격화되지 않은 추가 설명	최종경과	최종경과일	확진일로부터 최종경과까지 소요일	증상발현일부터 최종경과까지 소요일
10	Patient Case ID	Patient Gender	Patient Age	Symptom Developed On	Diagnosed On	Contracted Where?	Contracted From?	Degree of Separation	Relationship	Relationship Code	Earliest Possible Contracted Date	Days to show symptom	Days to be diagnosed	Non-structured Remarks (Partially from MOH and also from other media sources)	Resolution	Resolution Date	Days to resolution since being diagnosed	Days to resolution since developing symptom

11	1	M	68	5/11/2015	5/20/2015	Saudi사우디 (추정)	unknown	1	unknown	I 최초감염자	unknown			Travel history 4/18~29 Bahrain, 4/29~30 UAE, 4/30~5/1 Bahrain, 5/1~2 KSA, 5/2 Bahrain, 5/2~3 Qatar
12	2	F	63	5/19/2015	5/20/2015	Home가정 (추정)	1	2	spouse	F 환자가족	5/11/2015	8	9	Cured and discharged; Korea CDC genome sequencing source.	Recovered Discharged	6/5/2015	16	17
13	3	M	75	5/20/2015	5/21/2015	B평택성모	1	2	shared inpatient room	S 주변환자	5/15/2015	5	6		Deceased	6/4/2015	14	15
14	4	F	46	5/25/2015	5/26/2015	B평택성모	1	2	family of patient 3	F 환자가족	5/15/2015	10	11		Recovered Discharged	6/16/2015	21	22
15	5	M	50	5/25/2015	5/26/2015	C지역의원	1	2	health professional	P 의료인력	5/17/2015	8	9	Treated patient 1 on May 17. Cured and discharged.	Recovered Discharged	6/8/2015	13	14
16	6	M	71	5/24/2015	5/28/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	9	13		Deceased	6/1/2015	4	8
17	7	F	28	5/26/2015	5/28/2015	B평택성모	1	2	health professional	P 의료인력	5/15/2015	11	13		Recovered Discharged	6/11/2015	14	16
18	8	F	46	5/23/2015	5/29/2015	A지역의원	1	2	health professional	P 의료인력	5/12/2015	11	17	Treated patient 1 on May 12, 14, and 15	Recovered Discharged	6/14/2015	16	22
19	9	M	56	5/27/2015	5/29/2015	B평택성모	1	2	shared inpatient floor	S 주변환자	5/15/2015	12	14		Recovered Discharged	6/15/2015	17	19
20	10	M	44	5/19/2015	5/29/2015	B평택성모	1	2	family of patient 3	F 환자가족	5/16/2015	3	13	Exposed on May 16. Went to China via Hong Kong on May 26. Diagnosed by China CDC
21	11	F	79	5/20/2015	5/29/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	5	14	During May 15-17
22	12	F	49	5/21/2015	5/29/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	6	14	During May 15-17	Recovered Discharged	6/16/2015	18	26
23	13	M	49	5/21/2015	5/29/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	6	14	During May 15-17	Recovered Discharged	6/11/2015	13	21
24	14	M	35	5/21/2015	5/30/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	6	15	During May 15-17
25	15	M	35	5/22/2015	5/30/2015	B평택성모	1	2	son of one of patients above	F 환자가족	5/15/2015	7	15	During May 15-17
26	16	M	40	5/20/2015	5/31/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	5	16	During May 15-17
27	17	M	45	5/22/2015	5/31/2015	B평택성모	1	2	son of one of the patients above	F 환자가족	5/15/2015	7	16	During May 15-16	Recovered Discharged	6/12/2015	12	21
28	18	F	77	5/20/2015	5/31/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	5	16	During May 15-16	Recovered Discharged	6/9/2015	9	20
29	19	M	60	5/28/2015	6/1/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/16/2015	12	16	Caregiver, During May 16-17	Recovered Discharged	6/12/2015	11	15
30	20	M	40	5/23/2015	6/1/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	8	17	During May 15-17	Recovered Discharged	6/13/2015	12	21
31	21	F	59	5/23/2015	6/1/2015	B평택성모	1	2	shared inpatient ward	C 간병인	5/15/2015	8	17	Caregiver, During May 15-17
32	22	F	39	5/27/2015	6/1/2015	B평택성모	1	2	shared inpatient ward	C 간병인	5/15/2015	12	17	Caregiver, During May 15-17
33	23	M	73	5/31/2015	6/1/2015	E건양대	16	3	shared inpatient room	S 주변환자	5/28/2015	3	4	During May 28-30	Deceased	6/12/2015	11	12
34	24	M	78	5/31/2015	6/1/2015	E건양대	16	3	shared inpatient room	S 주변환자	5/28/2015	3	4	During May 28-30	Deceased	6/12/2015	11	12
35	25	F	57	5/25/2015	6/1/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	10	17	During May 15-17, Deceased	Deceased	6/1/2015	0	7
36	26	M	43	5/21/2015	6/2/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	6	18	Caregiver, During May 15-17	Recovered Discharged	6/18/2015	16	28
37	27	M	55	6/1/2015	6/2/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	17	18	During May 15-17	Recovered Discharged	6/14/2015	12	13
38	28	M	58	5/29/2015	6/2/2015	B평택성모	1'	3	shared inpatient ward	F 환자가족	5/15/2015	14	18	Spouse, During May 15-17	Deceased	6/14/2015	12	16
39	29	F	77	5/24/2015	6/2/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	9	18	During May 15-17
40	30	M	60	5/30/2015	6/2/2015	F대청	16	3	shared inpatient room	S 주변환자	5/22/2015	8	11	During May 22-28
41	31	M	69	6/1/2015	6/4/2015	E건양대	16	3	shared inpatient room	S 주변환자	5/28/2015	4	7	During May 28-30	Deceased	6/17/2015	13	16
42	32	M	54	5/23/2015	6/4/2015	B평택성모	1	2	shared inpatient ward	V 방문자	5/15/2015	8	20	Visitor, On May 15	Recovered Discharged	6/18/2015	14	26
43	33	M	47	5/21/2015	6/4/2015	B평택성모	1	2	shared inpatient ward	V 방문자	5/15/2015	6	20	Visitor, On May 15	Recovered Discharged	6/14/2015	10	24
44	34	F	25	5/20/2015	6/4/2015	B평택성모	1	2	health professional	P 의료인력	5/15/2015	5	20	During May 15-17	Recovered Discharged	6/10/2015	6	21
45	35	M	38	5/30/2015	6/4/2015	D삼성서울	14	3	health professional	P 의료인력	5/27/2015	3	8	On May 27, at ER
46	36	M	82	6/1/2015	6/4/2015	E건양대	16	3	shared inpatient room	S 주변환자	5/28/2015	4	7	On May 28, Deceased	Deceased	6/3/2015	-1	2
47	37	M	45	6/4/2015	6/5/2015	B평택성모	1	2	shared inpatient ward	S 주변환자	5/15/2015	20	21	During May 14-27, and also with patients #9, #11, #12, #14	Recovered Discharged	6/11/2015	6	7
48	38	M	49	5/26/2015	6/5/2015	F대청	16	3	shared inpatient room	S 주변환자	5/22/2015	4	14	During May 14-31	Deceased	6/15/2015	10	20
49	39	M	62	6/2/2015	6/5/2015	B평택성모	1'	3	shared inpatient ward	S 주변환자	5/20/2015	13	16	During May 20-28, with patients #9, #11, #12, #14	Recovered Discharged	6/18/2015	13	16
50	40	M	24	5/22/2015	6/5/2015	B평택성모	1'	3	shared inpatient room	S 주변환자	5/22/2015	0	14	During May 22-28, with patients #9 and #14	Recovered Discharged	6/17/2015	12	26
51	41	F	70	6/4/2015	6/5/2015	D삼성서울	14	3	er visit	S 주변환자	5/27/2015	8	9	On May 27	Recovered Discharged	6/14/2015	9	10
52	42	F	54	5/25/2015	6/5/2015	B평택성모	1'	3	other floor patient	S 주변환자	5/19/2015	6	17	During May 19-20	Deceased	6/17/2015	12	23
53	43	F	24	5/29/2015	6/6/2015	B평택성모	1'	3	health professional	P 의료인력	5/15/2015	14	22	Other floor
54	44	F	51	6/1/2015	6/6/2015	B평택성모	1'	3	other floor patient	S 주변환자	5/18/2015	14	19	During May 18-28	Recovered Discharged	6/17/2015	11	16
55	45	M	65	6/1/2015	6/6/2015	E건양대	16	3	shared inpatient ward	S 주변환자	5/28/2015	4	9	During May 28-30
56	46	M	56	6/1/2015	6/6/2015	D삼성서울	14	3	er patient	F 환자가족	5/27/2015	5	10	On May 27
57	47	F	68	6/2/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	6	10	On May 27	Deceased	6/9/2015	3	7
58	48	M	39	5/31/2015	6/6/2015	D삼성서울	14	3	shared inpatient room	C 간병인	5/28/2015	3	9	Caregiver, On May 28
59	49	M	75	5/31/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	4	10	On May 27
60	50	F	81	5/30/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	3	10	On May 27
61	51	F	72	6/2/2015	6/6/2015	B평택성모	1	2	same hospital	S 주변환자	5/15/2015	18	22	During May 12-21	Deceased	6/12/2015	6	10
62	52	F	54	5/31/2015	6/6/2015	B평택성모	1'	3	same hospital	S 주변환자	5/23/2015	8	14	During May 23-28
63	53	M	51	5/29/2015	6/6/2015	B평택성모	1'	3	same hospital	S 주변환자	5/26/2015	3	11	During May 26-28
64	54	F	64	6/3/2015	6/6/2015	F대청	16	3	shared inpatient room	C 간병인	5/22/2015	12	15	Caregiver, During May 22-28
65	55	M	36	5/30/2015	6/6/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015	3	10	During May 26-28
66	56	M	45	6/2/2015	6/6/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015	6	10	During May 26-Jun 1	Recovered Discharged	6/15/2015	9	13
67	57	M	57	6/3/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	7	10	On May 27	Recovered Discharged	6/18/2015	12	15
68	58	M	55	6/2/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	6	10	On May 27
69	59	M	44	6/5/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	9	10	On May 27	Recovered Discharged	6/17/2015	11	12
70	60	F	37	6/1/2015	6/6/2015	D삼성서울	14	3	health professional	P 의료인력	5/27/2015	5	10	On May 27
71	61	M	55	6/2/2015	6/6/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015	6	10	During May 27-28
72	62	M	32	5/31/2015	6/6/2015	D삼성서울	14	3	health professional	P 의료인력	5/27/2015	4	10	During May 27-28, Originally announed as a caregiver, then revealed as a M.D. at Samsung Seoul Hospital on Jun 15, much later than the patient has been diagnosed and announced.	Recovered Discharged	6/17/2015	11	17
73	63	F	58	6/3/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/28/2015	6	9	During May 28-29
74	64	M	75	6/4/2015	6/6/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015	8	10	During May 27-29	Deceased	6/5/2015	-1	1
75	65	F	55	n/a	6/7/2015	D삼성서울	14	3	er extended stay	E 체류자	5/27/2015		11	On May 27, Extended Stay (체류)
76	66	F	42	n/a	6/7/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015		11	During May 27-30
77	67	M	16	n/a	6/7/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015		11	ER inpatient on May 27, then remained in the hospital
78	68	F	55	n/a	6/7/2015	D삼성서울	14	3	er visitor	V 방문자	5/27/2015		11	On May 27, Visitor (방문)
79	69	M	57	n/a	6/7/2015	D삼성서울	14	3	er extended stay	E 체류자	5/27/2015		11	On May 27, Extended Stay (체류)
80	70	M	59	n/a	6/7/2015	D삼성서울	14	3	er extended stay	E 체류자	5/27/2015		11	During May 27-28, Extended Stay (체류)	Recovered Discharged	6/18/2015	11
81	71	F	40	n/a	6/7/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015		11	On May 27	Recovered Discharged	6/17/2015	10
82	72	M	56	n/a	6/7/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015		11	On May 27
83	73	F	65	n/a	6/7/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015		11	On May 27
84	74	M	71	n/a	6/7/2015	D삼성서울	14	3	er extended stay	E 체류자	5/27/2015		11	On May 27. Extended Stay (체류)
85	75	F	63	n/a	6/7/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015		11	During May 25-28
86	76	F	75	n/a	6/7/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015		11	During May 27-28; Then visited Institution O during Jun 5~6.	Deceased	6/9/2015	2
87	77	M	63	n/a	6/7/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015		11	During May 27-28	Deceased	6/17/2015	10
88	78	F	41	6/2/2015	6/7/2015	D삼성서울	14	3	health professional	P 의료인력	5/27/2015	6	11	During May 27-28
89	79	F	24	n/a	6/7/2015	D삼성서울	14	3	health professional	P 의료인력	5/27/2015		11	During May 27-29
90	80	M	35	n/a	6/7/2015	D삼성서울	14	3	er inpatient	S 주변환자	5/27/2015		11	During May 27-29
91	81	M	62	n/a	6/7/2015	D삼성서울	14	3	er extended stay	E 체류자	5/27/2015		11	On May 28, Extended Stay (체류)	Deceased	6/14/2015	7
92	82	F	83	n/a	6/7/2015	E건양대	16	3	shared inpatient room	F 환자가족	5/28/2015		10	May 28-30, Caregiver	Deceased	6/17/2015	10
93	83	M	65	n/a	6/7/2015	E건양대	16	3	shared inpatient ward	S 주변환자	5/28/2015		10	May 28-30	Deceased	6/11/2015	4
94	84	M	80	n/a	6/7/2015	F대청	16	3	shared inpatient ward	S 주변환자	5/25/2015		13	May 25-28	Deceased	6/8/2015	1
95	85	F	66	n/a	6/7/2015	F대청	16	3	shared inpatient room	C 간병인	5/25/2015		13	May 25-28, Caregiver
96	86	F	76	n/a	6/7/2015	F대청	16	3	shared inpatient ward	S 주변환자	5/25/2015		13	May 25-28
97	87	F	78	n/a	6/7/2015	F대청	16	3	shared inpatient ward	S 주변환자	5/25/2015		13	May 25-28
98	88	M	47	n/a	6/8/2015	G여의도성모	6	3	shared inpatient room	F 환자가족	5/28/2015		11	On May 28	Recovered Discharged	6/15/2015	7
99	89	M	59	n/a	6/8/2015	D삼성서울	14	3	er extended stay	E 체류자	5/28/2015		11	On May 28
100	90	M	62	n/a	6/8/2015	D삼성서울	14	3	er patient	S 주변환자	5/27/2015		12	On May 27 - Diagnosed by Daejon Institute of Public Health and Environment (referred as IPHE hereafter). Deceased on Jun 9.	Deceased	6/10/2015	2