Overview

Dataset statistics

Number of variables27
Number of observations2322
Missing cells19781
Missing cells (%)31.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory517.1 KiB
Average record size in memory228.1 B

Variable types

Categorical6
Text6
DateTime6
Unsupported4
Numeric5

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),약국영업면적,지정일자
Author중구
URLhttps://data.seoul.go.kr/dataList/OA-16311/S/1/datasetView.do

Alerts

개방자치단체코드 has constant value ""Constant
휴업시작일자 has constant value ""Constant
휴업종료일자 has constant value ""Constant
영업상태코드 is highly imbalanced (80.4%)Imbalance
영업상태명 is highly imbalanced (80.4%)Imbalance
상세영업상태코드 is highly imbalanced (80.4%)Imbalance
상세영업상태명 is highly imbalanced (80.4%)Imbalance
데이터갱신구분 is highly imbalanced (62.7%)Imbalance
인허가취소일자 has 2322 (100.0%) missing valuesMissing
폐업일자 has 173 (7.5%) missing valuesMissing
휴업시작일자 has 2321 (> 99.9%) missing valuesMissing
휴업종료일자 has 2321 (> 99.9%) missing valuesMissing
재개업일자 has 2322 (100.0%) missing valuesMissing
전화번호 has 1686 (72.6%) missing valuesMissing
소재지면적 has 2322 (100.0%) missing valuesMissing
소재지우편번호 has 181 (7.8%) missing valuesMissing
도로명주소 has 683 (29.4%) missing valuesMissing
도로명우편번호 has 1945 (83.8%) missing valuesMissing
업태구분명 has 2322 (100.0%) missing valuesMissing
좌표정보(X) has 520 (22.4%) missing valuesMissing
좌표정보(Y) has 520 (22.4%) missing valuesMissing
약국영업면적 has 70 (3.0%) missing valuesMissing
지정일자 has 70 (3.0%) missing valuesMissing
관리번호 has unique valuesUnique
최종수정일자 has unique valuesUnique
인허가취소일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
재개업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
소재지면적 is an unsupported type, check if it needs cleaning or further analysisUnsupported
업태구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-21 17:22:22.540445
Analysis finished2024-04-21 17:22:23.886971
Duration1.35 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
3010000
2322 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3010000
2nd row3010000
3rd row3010000
4th row3010000
5th row3010000

Common Values

ValueCountFrequency (%)
3010000 2322
100.0%

Length

2024-04-22T02:22:24.067746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:24.347720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3010000 2322
100.0%

관리번호
Text

UNIQUE 

Distinct2322
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
2024-04-22T02:22:25.007745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length25
Mean length25
Min length25

Characters and Unicode

Total characters58050
Distinct characters14
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2322 ?
Unique (%)100.0%

Sample

1st rowPHMD119203010033084000001
2nd rowPHMD119513010033084000001
3rd rowPHMD119593010033084000001
4th rowPHMD119593010033084000002
5th rowPHMD119593010033084000003
ValueCountFrequency (%)
phmd119203010033084000001 1
 
< 0.1%
phmd119933010033084000035 1
 
< 0.1%
phmd119893010033084000034 1
 
< 0.1%
phmd119893010033084000025 1
 
< 0.1%
phmd119893010033084000019 1
 
< 0.1%
phmd119893010033084000020 1
 
< 0.1%
phmd119893010033084000021 1
 
< 0.1%
phmd119893010033084000022 1
 
< 0.1%
phmd119893010033084000023 1
 
< 0.1%
phmd119893010033084000024 1
 
< 0.1%
Other values (2312) 2312
99.6%
2024-04-22T02:22:26.103903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 20166
34.7%
1 7808
 
13.5%
3 7645
 
13.2%
8 3789
 
6.5%
4 2919
 
5.0%
9 2666
 
4.6%
P 2322
 
4.0%
H 2322
 
4.0%
M 2322
 
4.0%
D 2322
 
4.0%
Other values (4) 3769
 
6.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 48762
84.0%
Uppercase Letter 9288
 
16.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 20166
41.4%
1 7808
 
16.0%
3 7645
 
15.7%
8 3789
 
7.8%
4 2919
 
6.0%
9 2666
 
5.5%
2 1255
 
2.6%
7 1228
 
2.5%
6 688
 
1.4%
5 598
 
1.2%
Uppercase Letter
ValueCountFrequency (%)
P 2322
25.0%
H 2322
25.0%
M 2322
25.0%
D 2322
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 48762
84.0%
Latin 9288
 
16.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 20166
41.4%
1 7808
 
16.0%
3 7645
 
15.7%
8 3789
 
7.8%
4 2919
 
6.0%
9 2666
 
5.5%
2 1255
 
2.6%
7 1228
 
2.5%
6 688
 
1.4%
5 598
 
1.2%
Latin
ValueCountFrequency (%)
P 2322
25.0%
H 2322
25.0%
M 2322
25.0%
D 2322
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 58050
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 20166
34.7%
1 7808
 
13.5%
3 7645
 
13.2%
8 3789
 
6.5%
4 2919
 
5.0%
9 2666
 
4.6%
P 2322
 
4.0%
H 2322
 
4.0%
M 2322
 
4.0%
D 2322
 
4.0%
Other values (4) 3769
 
6.5%
Distinct1975
Distinct (%)85.1%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
Minimum1920-10-13 00:00:00
Maximum2023-12-11 00:00:00
2024-04-22T02:22:26.337477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:26.576450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2322
Missing (%)100.0%
Memory size20.5 KiB

영업상태코드
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
3
2148 
1
 
172
4
 
1
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row3
2nd row3
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 2148
92.5%
1 172
 
7.4%
4 1
 
< 0.1%
2 1
 
< 0.1%

Length

2024-04-22T02:22:26.801727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:26.963442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 2148
92.5%
1 172
 
7.4%
4 1
 
< 0.1%
2 1
 
< 0.1%

영업상태명
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
폐업
2148 
영업/정상
 
172
취소/말소/만료/정지/중지
 
1
휴업
 
1

Length

Max length14
Median length2
Mean length2.2273902
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row폐업
2nd row폐업
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 2148
92.5%
영업/정상 172
 
7.4%
취소/말소/만료/정지/중지 1
 
< 0.1%
휴업 1
 
< 0.1%

Length

2024-04-22T02:22:27.149647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:27.321848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 2148
92.5%
영업/정상 172
 
7.4%
취소/말소/만료/정지/중지 1
 
< 0.1%
휴업 1
 
< 0.1%

상세영업상태코드
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
3
2148 
13
 
172
24
 
1
2
 
1

Length

Max length2
Median length1
Mean length1.0745047
Min length1

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row3
2nd row3
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 2148
92.5%
13 172
 
7.4%
24 1
 
< 0.1%
2 1
 
< 0.1%

Length

2024-04-22T02:22:27.506043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:27.674583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 2148
92.5%
13 172
 
7.4%
24 1
 
< 0.1%
2 1
 
< 0.1%

상세영업상태명
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
폐업
2148 
영업중
 
172
직권폐업
 
1
휴업
 
1

Length

Max length4
Median length2
Mean length2.0749354
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row폐업
2nd row폐업
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 2148
92.5%
영업중 172
 
7.4%
직권폐업 1
 
< 0.1%
휴업 1
 
< 0.1%

Length

2024-04-22T02:22:27.874452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:28.061292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 2148
92.5%
영업중 172
 
7.4%
직권폐업 1
 
< 0.1%
휴업 1
 
< 0.1%

폐업일자
Date

MISSING 

Distinct1867
Distinct (%)86.9%
Missing173
Missing (%)7.5%
Memory size18.3 KiB
Minimum1973-07-20 00:00:00
Maximum2024-04-05 00:00:00
2024-04-22T02:22:28.250523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:28.495312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

휴업시작일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing2321
Missing (%)> 99.9%
Memory size18.3 KiB
Minimum2023-09-25 00:00:00
Maximum2023-09-25 00:00:00
2024-04-22T02:22:28.694528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:28.850007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

휴업종료일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing2321
Missing (%)> 99.9%
Memory size18.3 KiB
Minimum2024-09-25 00:00:00
Maximum2024-09-25 00:00:00
2024-04-22T02:22:29.005064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:29.160845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2322
Missing (%)100.0%
Memory size20.5 KiB

전화번호
Text

MISSING 

Distinct497
Distinct (%)78.1%
Missing1686
Missing (%)72.6%
Memory size18.3 KiB
2024-04-22T02:22:29.928395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length10.355346
Min length8

Characters and Unicode

Total characters6586
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique391 ?
Unique (%)61.5%

Sample

1st row02-2279-0489
2nd row02-2252-0457
3rd row02-2272-5953
4th row02-755-0049
5th row02-392-3881
ValueCountFrequency (%)
02-2235-4524 5
 
0.8%
273-9781 4
 
0.6%
02-2268-4582 4
 
0.6%
02-2266-6968 4
 
0.6%
2236-7582 3
 
0.5%
02-3789-9800 3
 
0.5%
02-2253-2917 3
 
0.5%
235-5625 3
 
0.5%
2253-9359 3
 
0.5%
275-5091 3
 
0.5%
Other values (487) 601
94.5%
2024-04-22T02:22:31.226556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 1397
21.2%
- 1003
15.2%
0 730
11.1%
7 658
10.0%
3 627
9.5%
5 494
 
7.5%
6 409
 
6.2%
8 406
 
6.2%
9 338
 
5.1%
1 281
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5583
84.8%
Dash Punctuation 1003
 
15.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 1397
25.0%
0 730
13.1%
7 658
11.8%
3 627
11.2%
5 494
 
8.8%
6 409
 
7.3%
8 406
 
7.3%
9 338
 
6.1%
1 281
 
5.0%
4 243
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 1003
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 6586
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 1397
21.2%
- 1003
15.2%
0 730
11.1%
7 658
10.0%
3 627
9.5%
5 494
 
7.5%
6 409
 
6.2%
8 406
 
6.2%
9 338
 
5.1%
1 281
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6586
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 1397
21.2%
- 1003
15.2%
0 730
11.1%
7 658
10.0%
3 627
9.5%
5 494
 
7.5%
6 409
 
6.2%
8 406
 
6.2%
9 338
 
5.1%
1 281
 
4.3%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2322
Missing (%)100.0%
Memory size20.5 KiB

소재지우편번호
Text

MISSING 

Distinct144
Distinct (%)6.7%
Missing181
Missing (%)7.8%
Memory size18.3 KiB
2024-04-22T02:22:32.196279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0023354
Min length6

Characters and Unicode

Total characters12851
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique47 ?
Unique (%)2.2%

Sample

1st row100300
2nd row100194
3rd row100850
4th row100451
5th row100197
ValueCountFrequency (%)
100450 330
 
15.4%
100095 95
 
4.4%
100440 86
 
4.0%
100102 59
 
2.8%
100193 59
 
2.8%
100330 57
 
2.7%
100300 48
 
2.2%
100032 47
 
2.2%
100094 47
 
2.2%
100060 44
 
2.1%
Other values (134) 1269
59.3%
2024-04-22T02:22:33.522509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 5909
46.0%
1 3121
24.3%
4 823
 
6.4%
3 622
 
4.8%
2 614
 
4.8%
5 613
 
4.8%
9 474
 
3.7%
8 279
 
2.2%
7 199
 
1.5%
6 192
 
1.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 12846
> 99.9%
Dash Punctuation 5
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5909
46.0%
1 3121
24.3%
4 823
 
6.4%
3 622
 
4.8%
2 614
 
4.8%
5 613
 
4.8%
9 474
 
3.7%
8 279
 
2.2%
7 199
 
1.5%
6 192
 
1.5%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 12851
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 5909
46.0%
1 3121
24.3%
4 823
 
6.4%
3 622
 
4.8%
2 614
 
4.8%
5 613
 
4.8%
9 474
 
3.7%
8 279
 
2.2%
7 199
 
1.5%
6 192
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 12851
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 5909
46.0%
1 3121
24.3%
4 823
 
6.4%
3 622
 
4.8%
2 614
 
4.8%
5 613
 
4.8%
9 474
 
3.7%
8 279
 
2.2%
7 199
 
1.5%
6 192
 
1.5%
Distinct1209
Distinct (%)52.1%
Missing3
Missing (%)0.1%
Memory size18.3 KiB
2024-04-22T02:22:34.646613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length41
Mean length21.963346
Min length12

Characters and Unicode

Total characters50933
Distinct characters262
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique783 ?
Unique (%)33.8%

Sample

1st row서울특별시 중구 초동 21번지 9호
2nd row서울특별시 중구 을지로4가 162번지 8호
3rd row서울특별시 중구 을지로6가 17번지 5호
4th row서울특별시 중구 신당1동 319번지
5th row서울특별시 중구 을지로7가 58번지 1호
ValueCountFrequency (%)
서울특별시 2319
20.4%
중구 2317
20.3%
신당동 402
 
3.5%
1호 306
 
2.7%
2호 160
 
1.4%
3호 139
 
1.2%
남대문로5가 107
 
0.9%
황학동 106
 
0.9%
5호 71
 
0.6%
4호 69
 
0.6%
Other values (887) 5395
47.4%
2024-04-22T02:22:36.203542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9087
17.8%
2496
 
4.9%
2377
 
4.7%
2357
 
4.6%
2334
 
4.6%
2330
 
4.6%
2326
 
4.6%
2322
 
4.6%
2321
 
4.6%
1 2256
 
4.4%
Other values (252) 20727
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 31744
62.3%
Decimal Number 9855
 
19.3%
Space Separator 9087
 
17.8%
Dash Punctuation 116
 
0.2%
Uppercase Letter 53
 
0.1%
Other Punctuation 50
 
0.1%
Lowercase Letter 21
 
< 0.1%
Open Punctuation 3
 
< 0.1%
Close Punctuation 3
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2496
 
7.9%
2377
 
7.5%
2357
 
7.4%
2334
 
7.4%
2330
 
7.3%
2326
 
7.3%
2322
 
7.3%
2321
 
7.3%
2169
 
6.8%
1753
 
5.5%
Other values (208) 8959
28.2%
Uppercase Letter
ValueCountFrequency (%)
Y 7
13.2%
J 6
11.3%
N 5
9.4%
A 5
9.4%
T 5
9.4%
C 5
9.4%
K 4
7.5%
B 3
 
5.7%
P 2
 
3.8%
E 2
 
3.8%
Other values (7) 9
17.0%
Decimal Number
ValueCountFrequency (%)
1 2256
22.9%
2 1639
16.6%
3 1193
12.1%
5 921
9.3%
4 815
 
8.3%
6 663
 
6.7%
0 652
 
6.6%
7 651
 
6.6%
8 583
 
5.9%
9 482
 
4.9%
Lowercase Letter
ValueCountFrequency (%)
e 5
23.8%
t 3
14.3%
i 3
14.3%
r 2
 
9.5%
n 2
 
9.5%
a 2
 
9.5%
s 2
 
9.5%
c 1
 
4.8%
l 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 38
76.0%
. 11
 
22.0%
& 1
 
2.0%
Space Separator
ValueCountFrequency (%)
9087
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 116
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 31744
62.3%
Common 19115
37.5%
Latin 74
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2496
 
7.9%
2377
 
7.5%
2357
 
7.4%
2334
 
7.4%
2330
 
7.3%
2326
 
7.3%
2322
 
7.3%
2321
 
7.3%
2169
 
6.8%
1753
 
5.5%
Other values (208) 8959
28.2%
Latin
ValueCountFrequency (%)
Y 7
 
9.5%
J 6
 
8.1%
N 5
 
6.8%
A 5
 
6.8%
e 5
 
6.8%
T 5
 
6.8%
C 5
 
6.8%
K 4
 
5.4%
t 3
 
4.1%
i 3
 
4.1%
Other values (16) 26
35.1%
Common
ValueCountFrequency (%)
9087
47.5%
1 2256
 
11.8%
2 1639
 
8.6%
3 1193
 
6.2%
5 921
 
4.8%
4 815
 
4.3%
6 663
 
3.5%
0 652
 
3.4%
7 651
 
3.4%
8 583
 
3.0%
Other values (8) 655
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 31744
62.3%
ASCII 19189
37.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9087
47.4%
1 2256
 
11.8%
2 1639
 
8.5%
3 1193
 
6.2%
5 921
 
4.8%
4 815
 
4.2%
6 663
 
3.5%
0 652
 
3.4%
7 651
 
3.4%
8 583
 
3.0%
Other values (34) 729
 
3.8%
Hangul
ValueCountFrequency (%)
2496
 
7.9%
2377
 
7.5%
2357
 
7.4%
2334
 
7.4%
2330
 
7.3%
2326
 
7.3%
2322
 
7.3%
2321
 
7.3%
2169
 
6.8%
1753
 
5.5%
Other values (208) 8959
28.2%

도로명주소
Text

MISSING 

Distinct777
Distinct (%)47.4%
Missing683
Missing (%)29.4%
Memory size18.3 KiB
2024-04-22T02:22:37.317822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length48
Mean length25.816351
Min length20

Characters and Unicode

Total characters42313
Distinct characters272
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique467 ?
Unique (%)28.5%

Sample

1st row서울특별시 중구 마른내로 35 (초동)
2nd row서울특별시 중구 을지로30길 8 (을지로4가)
3rd row서울특별시 중구 청계천로 260-9 (을지로6가)
4th row서울특별시 중구 을지로 280-2 (을지로7가)
5th row서울특별시 중구 동호로24길 33 (장충동2가)
ValueCountFrequency (%)
서울특별시 1639
 
18.9%
중구 1639
 
18.9%
신당동 313
 
3.6%
퇴계로 137
 
1.6%
1층 102
 
1.2%
다산로 85
 
1.0%
마른내로 81
 
0.9%
을지로 72
 
0.8%
남대문로 67
 
0.8%
세종대로 65
 
0.7%
Other values (814) 4484
51.6%
2024-04-22T02:22:38.900349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7046
 
16.7%
2001
 
4.7%
1728
 
4.1%
1687
 
4.0%
1664
 
3.9%
1659
 
3.9%
1651
 
3.9%
) 1642
 
3.9%
( 1642
 
3.9%
1641
 
3.9%
Other values (262) 19952
47.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 24833
58.7%
Space Separator 7046
 
16.7%
Decimal Number 6448
 
15.2%
Close Punctuation 1642
 
3.9%
Open Punctuation 1642
 
3.9%
Other Punctuation 379
 
0.9%
Dash Punctuation 253
 
0.6%
Uppercase Letter 52
 
0.1%
Lowercase Letter 17
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2001
 
8.1%
1728
 
7.0%
1687
 
6.8%
1664
 
6.7%
1659
 
6.7%
1651
 
6.6%
1641
 
6.6%
1640
 
6.6%
1400
 
5.6%
895
 
3.6%
Other values (222) 8867
35.7%
Uppercase Letter
ValueCountFrequency (%)
B 7
13.5%
A 6
11.5%
Y 6
11.5%
N 5
9.6%
C 5
9.6%
K 4
7.7%
J 4
7.7%
T 4
7.7%
E 3
5.8%
W 3
5.8%
Other values (5) 5
9.6%
Decimal Number
ValueCountFrequency (%)
1 1600
24.8%
2 1154
17.9%
3 824
12.8%
4 561
 
8.7%
5 489
 
7.6%
6 443
 
6.9%
0 405
 
6.3%
8 356
 
5.5%
7 349
 
5.4%
9 267
 
4.1%
Lowercase Letter
ValueCountFrequency (%)
e 5
29.4%
r 2
 
11.8%
a 2
 
11.8%
s 2
 
11.8%
t 2
 
11.8%
i 1
 
5.9%
n 1
 
5.9%
l 1
 
5.9%
c 1
 
5.9%
Space Separator
ValueCountFrequency (%)
7046
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1642
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1642
100.0%
Other Punctuation
ValueCountFrequency (%)
, 379
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 253
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 24833
58.7%
Common 17411
41.1%
Latin 69
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2001
 
8.1%
1728
 
7.0%
1687
 
6.8%
1664
 
6.7%
1659
 
6.7%
1651
 
6.6%
1641
 
6.6%
1640
 
6.6%
1400
 
5.6%
895
 
3.6%
Other values (222) 8867
35.7%
Latin
ValueCountFrequency (%)
B 7
 
10.1%
A 6
 
8.7%
Y 6
 
8.7%
N 5
 
7.2%
C 5
 
7.2%
e 5
 
7.2%
K 4
 
5.8%
J 4
 
5.8%
T 4
 
5.8%
E 3
 
4.3%
Other values (14) 20
29.0%
Common
ValueCountFrequency (%)
7046
40.5%
) 1642
 
9.4%
( 1642
 
9.4%
1 1600
 
9.2%
2 1154
 
6.6%
3 824
 
4.7%
4 561
 
3.2%
5 489
 
2.8%
6 443
 
2.5%
0 405
 
2.3%
Other values (6) 1605
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 24833
58.7%
ASCII 17480
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7046
40.3%
) 1642
 
9.4%
( 1642
 
9.4%
1 1600
 
9.2%
2 1154
 
6.6%
3 824
 
4.7%
4 561
 
3.2%
5 489
 
2.8%
6 443
 
2.5%
0 405
 
2.3%
Other values (30) 1674
 
9.6%
Hangul
ValueCountFrequency (%)
2001
 
8.1%
1728
 
7.0%
1687
 
6.8%
1664
 
6.7%
1659
 
6.7%
1651
 
6.6%
1641
 
6.6%
1640
 
6.6%
1400
 
5.6%
895
 
3.6%
Other values (222) 8867
35.7%

도로명우편번호
Real number (ℝ)

MISSING 

Distinct137
Distinct (%)36.3%
Missing1945
Missing (%)83.8%
Infinite0
Infinite (%)0.0%
Mean25192.788
Minimum4500
Maximum100998
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.5 KiB
2024-04-22T02:22:39.149748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4500
5-th percentile4513.8
Q14536
median4573
Q34619
95-th percentile100837.6
Maximum100998
Range96498
Interquartile range (IQR)83

Descriptive statistics

Standard deviation39491.824
Coefficient of variation (CV)1.5675845
Kurtosis-0.05669002
Mean25192.788
Median Absolute Deviation (MAD)39
Skewness1.394114
Sum9497681
Variance1.5596042 × 109
MonotonicityNot monotonic
2024-04-22T02:22:39.404627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4534 12
 
0.5%
4597 12
 
0.5%
4619 12
 
0.5%
4529 10
 
0.4%
4598 8
 
0.3%
4552 8
 
0.3%
4536 8
 
0.3%
4535 7
 
0.3%
4563 7
 
0.3%
100130 7
 
0.3%
Other values (127) 286
 
12.3%
(Missing) 1945
83.8%
ValueCountFrequency (%)
4500 1
 
< 0.1%
4501 1
 
< 0.1%
4503 3
0.1%
4506 1
 
< 0.1%
4507 1
 
< 0.1%
4509 1
 
< 0.1%
4510 1
 
< 0.1%
4511 1
 
< 0.1%
4512 3
0.1%
4513 6
0.3%
ValueCountFrequency (%)
100998 1
 
< 0.1%
100896 1
 
< 0.1%
100879 1
 
< 0.1%
100874 2
 
0.1%
100863 1
 
< 0.1%
100856 5
0.2%
100851 1
 
< 0.1%
100841 6
0.3%
100840 1
 
< 0.1%
100837 1
 
< 0.1%
Distinct1127
Distinct (%)48.5%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
2024-04-22T02:22:40.443922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length4
Mean length4.3682171
Min length2

Characters and Unicode

Total characters10143
Distinct characters335
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique618 ?
Unique (%)26.6%

Sample

1st row자보약국
2nd row신화약국
3rd row평안약국
4th row순심약국
5th row대림약국
ValueCountFrequency (%)
유한약국 11
 
0.5%
평화약국 11
 
0.5%
현대약국 11
 
0.5%
흥인약국 9
 
0.4%
영빈약국 9
 
0.4%
시장약국 9
 
0.4%
성인약국 9
 
0.4%
보영약국 9
 
0.4%
세림약국 8
 
0.3%
명일약국 8
 
0.3%
Other values (1121) 2234
96.0%
2024-04-22T02:22:41.688470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2332
23.0%
2327
22.9%
194
 
1.9%
167
 
1.6%
160
 
1.6%
159
 
1.6%
142
 
1.4%
118
 
1.2%
104
 
1.0%
102
 
1.0%
Other values (325) 4338
42.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10123
99.8%
Decimal Number 14
 
0.1%
Space Separator 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2332
23.0%
2327
23.0%
194
 
1.9%
167
 
1.6%
160
 
1.6%
159
 
1.6%
142
 
1.4%
118
 
1.2%
104
 
1.0%
102
 
1.0%
Other values (318) 4318
42.7%
Decimal Number
ValueCountFrequency (%)
8 4
28.6%
5 3
21.4%
1 3
21.4%
3 2
14.3%
9 1
 
7.1%
2 1
 
7.1%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10123
99.8%
Common 20
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2332
23.0%
2327
23.0%
194
 
1.9%
167
 
1.6%
160
 
1.6%
159
 
1.6%
142
 
1.4%
118
 
1.2%
104
 
1.0%
102
 
1.0%
Other values (318) 4318
42.7%
Common
ValueCountFrequency (%)
6
30.0%
8 4
20.0%
5 3
15.0%
1 3
15.0%
3 2
 
10.0%
9 1
 
5.0%
2 1
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10123
99.8%
ASCII 20
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2332
23.0%
2327
23.0%
194
 
1.9%
167
 
1.6%
160
 
1.6%
159
 
1.6%
142
 
1.4%
118
 
1.2%
104
 
1.0%
102
 
1.0%
Other values (318) 4318
42.7%
ASCII
ValueCountFrequency (%)
6
30.0%
8 4
20.0%
5 3
15.0%
1 3
15.0%
3 2
 
10.0%
9 1
 
5.0%
2 1
 
5.0%

최종수정일자
Date

UNIQUE 

Distinct2322
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
Minimum2008-12-18 16:13:32
Maximum2024-04-05 14:00:58
2024-04-22T02:22:41.920408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:42.158031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
I
2155 
U
 
167

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowI
2nd rowI
3rd rowI
4th rowI
5th rowI

Common Values

ValueCountFrequency (%)
I 2155
92.8%
U 167
 
7.2%

Length

2024-04-22T02:22:42.367201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T02:22:42.519338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 2155
92.8%
u 167
 
7.2%
Distinct131
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size18.3 KiB
Minimum2018-08-31 23:59:59
Maximum2023-12-04 00:07:00
2024-04-22T02:22:42.918158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T02:22:43.157826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2322
Missing (%)100.0%
Memory size20.5 KiB

좌표정보(X)
Real number (ℝ)

MISSING 

Distinct701
Distinct (%)38.9%
Missing520
Missing (%)22.4%
Infinite0
Infinite (%)0.0%
Mean199473.87
Minimum196644.81
Maximum202185.73
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.5 KiB
2024-04-22T02:22:43.395869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum196644.81
5-th percentile197517.16
Q1198274.18
median199405.96
Q3200703.63
95-th percentile201641.36
Maximum202185.73
Range5540.9129
Interquartile range (IQR)2429.4408

Descriptive statistics

Standard deviation1346.4716
Coefficient of variation (CV)0.006750115
Kurtosis-1.1096444
Mean199473.87
Median Absolute Deviation (MAD)1204.8561
Skewness0.049805485
Sum3.5945192 × 108
Variance1812985.7
MonotonicityNot monotonic
2024-04-22T02:22:43.632817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
198259.65357739 14
 
0.6%
201933.988731333 12
 
0.5%
199405.958288457 11
 
0.5%
201019.635759926 11
 
0.5%
199322.300353889 10
 
0.4%
197477.060775895 10
 
0.4%
200149.661350411 10
 
0.4%
199067.419469273 10
 
0.4%
200882.345436367 9
 
0.4%
199930.819233449 9
 
0.4%
Other values (691) 1696
73.0%
(Missing) 520
 
22.4%
ValueCountFrequency (%)
196644.812780271 4
0.2%
196673.180526741 2
0.1%
196689.378204656 1
 
< 0.1%
196691.269917831 1
 
< 0.1%
196728.303922071 1
 
< 0.1%
196776.214503258 1
 
< 0.1%
196825.420456629 1
 
< 0.1%
196864.942838297 1
 
< 0.1%
196932.374785243 1
 
< 0.1%
196944.331847873 2
0.1%
ValueCountFrequency (%)
202185.725696826 3
 
0.1%
202131.747052459 1
 
< 0.1%
202069.665572698 2
 
0.1%
201993.235429752 2
 
0.1%
201978.359014791 2
 
0.1%
201961.944800437 3
 
0.1%
201947.084297972 1
 
< 0.1%
201933.988731333 12
0.5%
201929.950414626 3
 
0.1%
201901.862341835 1
 
< 0.1%

좌표정보(Y)
Real number (ℝ)

MISSING 

Distinct701
Distinct (%)38.9%
Missing520
Missing (%)22.4%
Infinite0
Infinite (%)0.0%
Mean451175.18
Minimum449582.54
Maximum452076.82
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.5 KiB
2024-04-22T02:22:43.882307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum449582.54
5-th percentile450258.35
Q1450903.11
median451255.23
Q3451515.43
95-th percentile451834.24
Maximum452076.82
Range2494.2831
Interquartile range (IQR)612.32383

Descriptive statistics

Standard deviation468.99413
Coefficient of variation (CV)0.0010394945
Kurtosis0.3996884
Mean451175.18
Median Absolute Deviation (MAD)298.71808
Skewness-0.78235964
Sum8.1301767 × 108
Variance219955.5
MonotonicityNot monotonic
2024-04-22T02:22:44.138523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
451392.198218657 14
 
0.6%
451520.369730546 12
 
0.5%
451386.260791895 11
 
0.5%
451893.540333685 11
 
0.5%
451289.124934594 10
 
0.4%
450610.74637891 10
 
0.4%
451742.650390416 10
 
0.4%
451106.903130898 10
 
0.4%
451362.969247199 9
 
0.4%
451834.24429159 9
 
0.4%
Other values (691) 1696
73.0%
(Missing) 520
 
22.4%
ValueCountFrequency (%)
449582.535532427 2
 
0.1%
449638.824308081 5
0.2%
449687.143213423 5
0.2%
449748.354142254 7
0.3%
449877.44410054 1
 
< 0.1%
449927.503073754 2
 
0.1%
449939.260432874 1
 
< 0.1%
449939.35498896 2
 
0.1%
449947.401377686 5
0.2%
449969.087862846 1
 
< 0.1%
ValueCountFrequency (%)
452076.818664092 2
 
0.1%
452008.928365747 6
0.3%
452005.950500534 2
 
0.1%
451979.752939172 1
 
< 0.1%
451958.495584927 4
0.2%
451947.558842413 1
 
< 0.1%
451913.043931275 4
0.2%
451908.357632586 1
 
< 0.1%
451906.158530262 3
0.1%
451905.89864981 4
0.2%

약국영업면적
Real number (ℝ)

MISSING 

Distinct1025
Distinct (%)45.5%
Missing70
Missing (%)3.0%
Infinite0
Infinite (%)0.0%
Mean25.411563
Minimum0
Maximum180.3
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size20.5 KiB
2024-04-22T02:22:44.387058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile15.36
Q117.3975
median21.2
Q327.4925
95-th percentile50
Maximum180.3
Range180.3
Interquartile range (IQR)10.095

Descriptive statistics

Standard deviation15.258879
Coefficient of variation (CV)0.60046991
Kurtosis27.286898
Mean25.411563
Median Absolute Deviation (MAD)4.4
Skewness4.3243711
Sum57226.84
Variance232.83339
MonotonicityNot monotonic
2024-04-22T02:22:44.641451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
16.2 15
 
0.6%
16.8 14
 
0.6%
19.2 13
 
0.6%
25.2 13
 
0.6%
18.0 12
 
0.5%
15.6 12
 
0.5%
17.6 12
 
0.5%
27.0 12
 
0.5%
19.8 12
 
0.5%
20.4 12
 
0.5%
Other values (1015) 2125
91.5%
(Missing) 70
 
3.0%
ValueCountFrequency (%)
0.0 1
< 0.1%
2.61 1
< 0.1%
5.25 1
< 0.1%
5.4 1
< 0.1%
5.42 1
< 0.1%
5.46 1
< 0.1%
5.51 1
< 0.1%
5.67 1
< 0.1%
6.2 1
< 0.1%
6.28 1
< 0.1%
ValueCountFrequency (%)
180.3 1
< 0.1%
165.05 1
< 0.1%
158.52 1
< 0.1%
158.19 1
< 0.1%
147.0 2
0.1%
146.32 1
< 0.1%
140.2 2
0.1%
133.65 2
0.1%
117.0 1
< 0.1%
115.6 2
0.1%

지정일자
Real number (ℝ)

MISSING 

Distinct1913
Distinct (%)84.9%
Missing70
Missing (%)3.0%
Infinite0
Infinite (%)0.0%
Mean19870427
Minimum19201013
Maximum20220318
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.5 KiB
2024-04-22T02:22:44.910113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19201013
5-th percentile19730776
Q119790120
median19840413
Q319920903
95-th percentile20130425
Maximum20220318
Range1019305
Interquartile range (IQR)130783.25

Descriptive statistics

Standard deviation121425.86
Coefficient of variation (CV)0.006110883
Kurtosis0.72424108
Mean19870427
Median Absolute Deviation (MAD)60290.5
Skewness0.85606322
Sum4.4748202 × 1010
Variance1.4744238 × 1010
MonotonicityNot monotonic
2024-04-22T02:22:45.171803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19651220 5
 
0.2%
19751210 5
 
0.2%
19821008 5
 
0.2%
19770413 4
 
0.2%
19801120 4
 
0.2%
19821023 4
 
0.2%
19910704 4
 
0.2%
19760128 4
 
0.2%
19850720 3
 
0.1%
19970421 3
 
0.1%
Other values (1903) 2211
95.2%
(Missing) 70
 
3.0%
ValueCountFrequency (%)
19201013 1
< 0.1%
19511201 1
< 0.1%
19590325 2
0.1%
19590723 1
< 0.1%
19591027 1
< 0.1%
19591119 1
< 0.1%
19600513 1
< 0.1%
19610214 1
< 0.1%
19610712 1
< 0.1%
19630430 1
< 0.1%
ValueCountFrequency (%)
20220318 1
< 0.1%
20220215 1
< 0.1%
20210128 1
< 0.1%
20200901 1
< 0.1%
20200831 1
< 0.1%
20200807 1
< 0.1%
20200703 1
< 0.1%
20200701 1
< 0.1%
20200423 1
< 0.1%
20200324 1
< 0.1%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)약국영업면적지정일자
03010000PHMD11920301003308400000119201013<NA>3폐업3폐업19830319<NA><NA><NA><NA><NA>100300서울특별시 중구 초동 21번지 9호서울특별시 중구 마른내로 35 (초동)100796자보약국2009-02-11 12:58:23I2018-08-31 23:59:59.0<NA>199206.279674451385.56529925.3819201013
13010000PHMD11951301003308400000119511201<NA>3폐업3폐업19760507<NA><NA><NA><NA><NA>100194서울특별시 중구 을지로4가 162번지 8호서울특별시 중구 을지로30길 8 (을지로4가)<NA>신화약국2009-02-17 11:26:27I2018-08-31 23:59:59.0<NA>199918.33291451563.75191327.219511201
23010000PHMD11959301003308400000119590325<NA>3폐업3폐업20180405<NA><NA><NA>02-2279-0489<NA>100850서울특별시 중구 을지로6가 17번지 5호서울특별시 중구 청계천로 260-9 (을지로6가)4563평안약국2018-04-05 20:38:51I2018-08-31 23:59:59.0<NA>200522.803909451872.39288523.719590325
33010000PHMD11959301003308400000219591119<NA>3폐업3폐업19790719<NA><NA><NA><NA><NA>100451서울특별시 중구 신당1동 319번지<NA><NA>순심약국2009-02-18 10:56:02I2018-08-31 23:59:59.0<NA><NA><NA>17.3219591119
43010000PHMD11959301003308400000319591027<NA>3폐업3폐업19841111<NA><NA><NA><NA><NA>100197서울특별시 중구 을지로7가 58번지 1호서울특별시 중구 을지로 280-2 (을지로7가)<NA>대림약국2009-02-19 09:34:28I2018-08-31 23:59:59.0<NA>200730.296204451454.33871616.1519591027
53010000PHMD11959301003308400000419590723<NA>3폐업3폐업20060331<NA><NA><NA><NA><NA>100392서울특별시 중구 장충동2가 25번지 3호서울특별시 중구 동호로24길 33 (장충동2가)<NA>청명약국2009-02-19 09:35:32I2018-08-31 23:59:59.0<NA>200390.645124450940.78565121.2819590723
63010000PHMD11959301003308400000519590325<NA>3폐업3폐업19820420<NA><NA><NA><NA><NA>100320서울특별시 중구 방산동 79번지 1호서울특별시 중구 동호로 376 (방산동)<NA>보영약국2009-02-19 09:39:31I2018-08-31 23:59:59.0<NA>200149.66135451742.6503924.019590325
73010000PHMD11960301003308400000119600513<NA>3폐업3폐업19850720<NA><NA><NA><NA><NA>100281서울특별시 중구 인현동1가 91번지<NA><NA>동해약국2009-02-19 09:33:09I2018-08-31 23:59:59.0<NA><NA><NA>39.619600513
83010000PHMD11961301003308400000119610712<NA>3폐업3폐업19790608<NA><NA><NA><NA><NA>100192서울특별시 중구 을지로2가 101번지 44호서울특별시 중구 삼일대로12길 14 (을지로2가)<NA>미풍약국2009-02-19 09:28:14I2018-08-31 23:59:59.0<NA>198921.416211451595.57919919.1419610712
93010000PHMD11961301003308400000219610214<NA>3폐업3폐업20000829<NA><NA><NA><NA><NA>100400서울특별시 중구 쌍림동 248번지 1호서울특별시 중구 장충단로 197 (쌍림동)<NA>수정약국2009-02-19 09:30:02I2018-08-31 23:59:59.0<NA>200489.718495451129.28440778.219610214
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)약국영업면적지정일자
23123010000PHMD1202330100330840000042023-05-01<NA>1영업/정상13영업중<NA><NA><NA><NA>02-6954-2010<NA><NA>서울특별시 중구 필동1가 43-1서울특별시 중구 충무로 3, 225,226,227호 (필동1가)4554충무약국2023-09-13 10:56:38U2022-12-08 23:05:00.0<NA>199297.87659451025.516575<NA><NA>
23133010000PHMD1202330100330840000052023-05-03<NA>1영업/정상13영업중<NA><NA><NA><NA>02-6953-7635<NA><NA>서울특별시 중구 신당동 855 신당 파인힐 하나유보라서울특별시 중구 왕십리로 407, B2-05-02호 (신당동, 신당 파인힐 하나유보라)4580곰돌이약국2024-03-14 14:25:12U2023-12-02 23:06:00.0<NA>202131.747052451330.482879<NA><NA>
23143010000PHMD1202330100330840000062023-05-10<NA>1영업/정상13영업중<NA><NA><NA><NA>02-6260-2070<NA><NA>서울특별시 중구 남대문로2가 9-1서울특별시 중구 남대문로 84, 7층 (남대문로2가)4534명동스타약국2023-05-19 17:30:32U2022-12-04 22:01:00.0<NA>198401.701306451374.312213<NA><NA>
23153010000PHMD1202330100330840000072023-06-21<NA>1영업/정상13영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 중구 명동2가 1-1 명동성당서울특별시 중구 명동길 74, 카톨릭회관 신관 B113호 (명동2가)45371898광장약국2023-09-13 10:40:21U2022-12-08 23:05:00.0<NA>198781.021275451197.800113<NA><NA>
23163010000PHMD1202330100330840000082023-07-17<NA>1영업/정상13영업중<NA><NA><NA><NA>02-2232-9110<NA><NA>서울특별시 중구 신당동 295-27 신흥빌딩서울특별시 중구 다산로 185, 신흥빌딩 102호 (신당동)4608우리약국2024-03-14 14:23:38U2023-12-02 23:06:00.0<NA>201114.378396450876.543088<NA><NA>
23173010000PHMD1202330100330840000092023-07-19<NA>1영업/정상13영업중<NA><NA><NA><NA>02-2256-2278<NA><NA>서울특별시 중구 신당동 372-3서울특별시 중구 동호로 171, 1층 (신당동)4596약수스타약국2023-11-09 10:13:19U2022-10-31 23:01:00.0<NA>200931.446401450131.890199<NA><NA>
23183010000PHMD1202330100330840000102023-08-07<NA>1영업/정상13영업중<NA><NA><NA><NA>02-318-3758<NA><NA>서울특별시 중구 태평로2가 344-3서울특별시 중구 세종대로 83, 1층 (태평로2가)4514덕수궁돌담약국2023-08-07 11:20:40I2022-12-08 00:09:00.0<NA>197853.608483451267.165258<NA><NA>
23193010000PHMD1202330100330840000112023-08-28<NA>1영업/정상13영업중<NA><NA><NA><NA>02-3789-9800<NA><NA>서울특별시 중구 충무로2가 63-6서울특별시 중구 명동8가길 20, 1,2층 (충무로2가)4537아이약국2023-08-28 11:33:59I2022-12-07 21:00:00.0<NA>198708.130951451041.773245<NA><NA>
23203010000PHMD1202330100330840000122023-11-01<NA>1영업/정상13영업중<NA><NA><NA><NA>02-3706-7204<NA><NA>서울특별시 중구 을지로4가 323 을지트윈타워서울특별시 중구 을지로 170, 을지트윈타워 1층 107호 (을지로4가)4548을지약국2023-11-01 13:01:15I2022-11-01 00:03:00.0<NA>199693.302714451535.867323<NA><NA>
23213010000PHMD1202330100330840000132023-12-11<NA>1영업/정상13영업중<NA><NA><NA><NA>02-733-0885<NA><NA>서울특별시 중구 충정로1가 51-6 동양빌딩서울특별시 중구 새문안로 32, 동양빌딩 1층 (충정로1가)4516정동길권약국2023-12-12 10:23:07I2022-11-01 23:04:00.0<NA>197203.769022451744.572695<NA><NA>