Overview

Dataset statistics

Number of variables27
Number of observations753
Missing cells6077
Missing cells (%)29.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory169.3 KiB
Average record size in memory230.2 B

Variable types

Categorical6
Text6
DateTime4
Unsupported6
Numeric5

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가취소일자 has 753 (100.0%) missing valuesMissing
폐업일자 has 202 (26.8%) missing valuesMissing
휴업시작일자 has 753 (100.0%) missing valuesMissing
휴업종료일자 has 753 (100.0%) missing valuesMissing
재개업일자 has 753 (100.0%) missing valuesMissing
전화번호 has 247 (32.8%) missing valuesMissing
소재지면적 has 753 (100.0%) missing valuesMissing
소재지우편번호 has 183 (24.3%) missing valuesMissing
도로명주소 has 164 (21.8%) missing valuesMissing
도로명우편번호 has 349 (46.3%) missing valuesMissing
업태구분명 has 753 (100.0%) missing valuesMissing
좌표정보(X) has 146 (19.4%) missing valuesMissing
좌표정보(Y) has 146 (19.4%) missing valuesMissing
약국영업면적 has 61 (8.1%) missing valuesMissing
지정일자 has 61 (8.1%) 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
소재지면적 is an unsupported type, check if it needs cleaning or further analysisUnsupported
업태구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
약국영업면적 has 230 (30.5%) zerosZeros

Reproduction

Analysis started2024-04-06 10:27:58.196574
Analysis finished2024-04-06 10:27:59.164733
Duration0.97 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
3070000
753 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3070000 753
100.0%

Length

2024-04-06T19:27:59.359616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:27:59.545043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3070000 753
100.0%

관리번호
Text

UNIQUE 

Distinct753
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2024-04-06T19:27:59.849619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length25
Mean length25
Min length25

Characters and Unicode

Total characters18825
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

Unique753 ?
Unique (%)100.0%

Sample

1st rowPHMD119573070034084000001
2nd rowPHMD119593070034084000001
3rd rowPHMD119603070034084000001
4th rowPHMD119603070034084000002
5th rowPHMD119623070034084000001
ValueCountFrequency (%)
phmd119573070034084000001 1
 
0.1%
phmd120103070034084000006 1
 
0.1%
phmd120103070034084000017 1
 
0.1%
phmd120093070034084000022 1
 
0.1%
phmd120093070034084000023 1
 
0.1%
phmd120093070034084000024 1
 
0.1%
phmd120103070034084000001 1
 
0.1%
phmd120103070034084000002 1
 
0.1%
phmd120103070034084000003 1
 
0.1%
phmd120103070034084000004 1
 
0.1%
Other values (743) 743
98.7%
2024-04-06T19:28:00.413022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 7219
38.3%
1 1698
 
9.0%
3 1683
 
8.9%
4 1663
 
8.8%
8 990
 
5.3%
7 968
 
5.1%
P 753
 
4.0%
H 753
 
4.0%
M 753
 
4.0%
D 753
 
4.0%
Other values (4) 1592
 
8.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 15813
84.0%
Uppercase Letter 3012
 
16.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 7219
45.7%
1 1698
 
10.7%
3 1683
 
10.6%
4 1663
 
10.5%
8 990
 
6.3%
7 968
 
6.1%
2 705
 
4.5%
9 565
 
3.6%
6 174
 
1.1%
5 148
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
P 753
25.0%
H 753
25.0%
M 753
25.0%
D 753
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 15813
84.0%
Latin 3012
 
16.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 7219
45.7%
1 1698
 
10.7%
3 1683
 
10.6%
4 1663
 
10.5%
8 990
 
6.3%
7 968
 
6.1%
2 705
 
4.5%
9 565
 
3.6%
6 174
 
1.1%
5 148
 
0.9%
Latin
ValueCountFrequency (%)
P 753
25.0%
H 753
25.0%
M 753
25.0%
D 753
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 18825
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 7219
38.3%
1 1698
 
9.0%
3 1683
 
8.9%
4 1663
 
8.8%
8 990
 
5.3%
7 968
 
5.1%
P 753
 
4.0%
H 753
 
4.0%
M 753
 
4.0%
D 753
 
4.0%
Other values (4) 1592
 
8.5%

인허가일자
Date

Distinct708
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
Minimum1957-09-19 00:00:00
Maximum2024-03-27 00:00:00
2024-04-06T19:28:00.696994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:28:00.902288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

영업상태코드
Categorical

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
3
549 
1
202 
4
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 549
72.9%
1 202
 
26.8%
4 2
 
0.3%

Length

2024-04-06T19:28:01.125552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:28:01.340332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 549
72.9%
1 202
 
26.8%
4 2
 
0.3%

영업상태명
Categorical

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
폐업
549 
영업/정상
202 
취소/말소/만료/정지/중지
 
2

Length

Max length14
Median length2
Mean length2.8366534
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 549
72.9%
영업/정상 202
 
26.8%
취소/말소/만료/정지/중지 2
 
0.3%

Length

2024-04-06T19:28:01.661575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:28:01.857419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 549
72.9%
영업/정상 202
 
26.8%
취소/말소/만료/정지/중지 2
 
0.3%

상세영업상태코드
Categorical

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
3
549 
13
202 
24
 
2

Length

Max length2
Median length1
Mean length1.2709163
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 549
72.9%
13 202
 
26.8%
24 2
 
0.3%

Length

2024-04-06T19:28:02.082348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:28:02.429858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 549
72.9%
13 202
 
26.8%
24 2
 
0.3%

상세영업상태명
Categorical

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
폐업
549 
영업중
202 
직권폐업
 
2

Length

Max length4
Median length2
Mean length2.2735724
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 549
72.9%
영업중 202
 
26.8%
직권폐업 2
 
0.3%

Length

2024-04-06T19:28:02.641666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:28:02.901785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 549
72.9%
영업중 202
 
26.8%
직권폐업 2
 
0.3%

폐업일자
Date

MISSING 

Distinct505
Distinct (%)91.7%
Missing202
Missing (%)26.8%
Memory size6.0 KiB
Minimum1991-11-01 00:00:00
Maximum2023-12-26 00:00:00
2024-04-06T19:28:03.115771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:28:03.395457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

전화번호
Text

MISSING 

Distinct413
Distinct (%)81.6%
Missing247
Missing (%)32.8%
Memory size6.0 KiB
2024-04-06T19:28:03.829769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length10.454545
Min length8

Characters and Unicode

Total characters5290
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

Unique339 ?
Unique (%)67.0%

Sample

1st row742-8627
2nd row02-914-1461
3rd row02-926-8500
4th row02-926-8249
5th row02-913-2130
ValueCountFrequency (%)
02-909-8144 4
 
0.8%
02-762-6300 4
 
0.8%
02-911-0175 3
 
0.6%
02-943-1432 3
 
0.6%
916-0826 3
 
0.6%
02-928-4545 3
 
0.6%
02-911-4326 3
 
0.6%
02-911-0345 3
 
0.6%
926-1860 3
 
0.6%
3291-5354 3
 
0.6%
Other values (403) 474
93.7%
2024-04-06T19:28:04.576091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 901
17.0%
2 854
16.1%
0 686
13.0%
9 669
12.6%
1 407
7.7%
3 324
 
6.1%
4 318
 
6.0%
5 307
 
5.8%
6 294
 
5.6%
7 266
 
5.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4389
83.0%
Dash Punctuation 901
 
17.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 854
19.5%
0 686
15.6%
9 669
15.2%
1 407
9.3%
3 324
 
7.4%
4 318
 
7.2%
5 307
 
7.0%
6 294
 
6.7%
7 266
 
6.1%
8 264
 
6.0%
Dash Punctuation
ValueCountFrequency (%)
- 901
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5290
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 901
17.0%
2 854
16.1%
0 686
13.0%
9 669
12.6%
1 407
7.7%
3 324
 
6.1%
4 318
 
6.0%
5 307
 
5.8%
6 294
 
5.6%
7 266
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5290
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 901
17.0%
2 854
16.1%
0 686
13.0%
9 669
12.6%
1 407
7.7%
3 324
 
6.1%
4 318
 
6.0%
5 307
 
5.8%
6 294
 
5.6%
7 266
 
5.0%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

소재지우편번호
Text

MISSING 

Distinct135
Distinct (%)23.7%
Missing183
Missing (%)24.3%
Memory size6.0 KiB
2024-04-06T19:28:05.055529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0105263
Min length6

Characters and Unicode

Total characters3426
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

Unique39 ?
Unique (%)6.8%

Sample

1st row136041
2nd row136072
3rd row136072
4th row136032
5th row136846
ValueCountFrequency (%)
136130 21
 
3.7%
136826 16
 
2.8%
136800 14
 
2.5%
136833 14
 
2.5%
136035 13
 
2.3%
136865 13
 
2.3%
136845 12
 
2.1%
136871 11
 
1.9%
136858 11
 
1.9%
136131 10
 
1.8%
Other values (125) 435
76.3%
2024-04-06T19:28:05.927147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 824
24.1%
3 766
22.4%
6 665
19.4%
8 327
 
9.5%
0 309
 
9.0%
7 139
 
4.1%
4 123
 
3.6%
5 117
 
3.4%
2 100
 
2.9%
9 50
 
1.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3420
99.8%
Dash Punctuation 6
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 824
24.1%
3 766
22.4%
6 665
19.4%
8 327
 
9.6%
0 309
 
9.0%
7 139
 
4.1%
4 123
 
3.6%
5 117
 
3.4%
2 100
 
2.9%
9 50
 
1.5%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3426
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 824
24.1%
3 766
22.4%
6 665
19.4%
8 327
 
9.5%
0 309
 
9.0%
7 139
 
4.1%
4 123
 
3.6%
5 117
 
3.4%
2 100
 
2.9%
9 50
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3426
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 824
24.1%
3 766
22.4%
6 665
19.4%
8 327
 
9.5%
0 309
 
9.0%
7 139
 
4.1%
4 123
 
3.6%
5 117
 
3.4%
2 100
 
2.9%
9 50
 
1.5%

지번주소
Text

Distinct658
Distinct (%)87.4%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2024-04-06T19:28:06.473932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length61
Median length49
Mean length25.366534
Min length17

Characters and Unicode

Total characters19101
Distinct characters196
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique584 ?
Unique (%)77.6%

Sample

1st row서울특별시 성북구 삼선동1가 22번지 2호 1층
2nd row서울특별시 성북구 안암동2가 139번지
3rd row서울특별시 성북구 안암동2가 81번지
4th row서울특별시 성북구 동소문동2가 92번지
5th row서울특별시 성북구 정릉동 199번지 2호
ValueCountFrequency (%)
서울특별시 752
 
19.5%
성북구 752
 
19.5%
1호 69
 
1.8%
1층 66
 
1.7%
정릉동 55
 
1.4%
종암동 53
 
1.4%
하월곡동 53
 
1.4%
석관동 50
 
1.3%
길음동 48
 
1.2%
장위동 45
 
1.2%
Other values (722) 1923
49.7%
2024-04-06T19:28:07.307837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3146
 
16.5%
1 1019
 
5.3%
동 898
 
4.7%
성 769
 
4.0%
북 761
 
4.0%
서 754
 
3.9%
구 754
 
3.9%
시 753
 
3.9%
울 752
 
3.9%
별 752
 
3.9%
Other values (186) 8743
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11798
61.8%
Decimal Number 3946
 
20.7%
Space Separator 3146
 
16.5%
Dash Punctuation 104
 
0.5%
Close Punctuation 35
 
0.2%
Open Punctuation 35
 
0.2%
Uppercase Letter 18
 
0.1%
Other Punctuation 17
 
0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 898
 
7.6%
성 769
 
6.5%
북 761
 
6.5%
서 754
 
6.4%
구 754
 
6.4%
시 753
 
6.4%
울 752
 
6.4%
별 752
 
6.4%
특 752
 
6.4%
지 678
 
5.7%
Other values (165) 4175
35.4%
Decimal Number
ValueCountFrequency (%)
1 1019
25.8%
2 599
15.2%
3 406
 
10.3%
4 326
 
8.3%
0 325
 
8.2%
6 308
 
7.8%
5 276
 
7.0%
7 274
 
6.9%
8 255
 
6.5%
9 158
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
B 15
83.3%
A 1
 
5.6%
K 1
 
5.6%
S 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
, 14
82.4%
. 3
 
17.6%
Space Separator
ValueCountFrequency (%)
3146
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 104
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11798
61.8%
Common 7285
38.1%
Latin 18
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 898
 
7.6%
성 769
 
6.5%
북 761
 
6.5%
서 754
 
6.4%
구 754
 
6.4%
시 753
 
6.4%
울 752
 
6.4%
별 752
 
6.4%
특 752
 
6.4%
지 678
 
5.7%
Other values (165) 4175
35.4%
Common
ValueCountFrequency (%)
3146
43.2%
1 1019
 
14.0%
2 599
 
8.2%
3 406
 
5.6%
4 326
 
4.5%
0 325
 
4.5%
6 308
 
4.2%
5 276
 
3.8%
7 274
 
3.8%
8 255
 
3.5%
Other values (7) 351
 
4.8%
Latin
ValueCountFrequency (%)
B 15
83.3%
A 1
 
5.6%
K 1
 
5.6%
S 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11797
61.8%
ASCII 7303
38.2%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3146
43.1%
1 1019
 
14.0%
2 599
 
8.2%
3 406
 
5.6%
4 326
 
4.5%
0 325
 
4.5%
6 308
 
4.2%
5 276
 
3.8%
7 274
 
3.8%
8 255
 
3.5%
Other values (11) 369
 
5.1%
Hangul
ValueCountFrequency (%)
동 898
 
7.6%
성 769
 
6.5%
북 761
 
6.5%
서 754
 
6.4%
구 754
 
6.4%
시 753
 
6.4%
울 752
 
6.4%
별 752
 
6.4%
특 752
 
6.4%
지 678
 
5.7%
Other values (164) 4174
35.4%
Compat Jamo
ValueCountFrequency (%)
ㅏ 1
100.0%

도로명주소
Text

MISSING 

Distinct514
Distinct (%)87.3%
Missing164
Missing (%)21.8%
Memory size6.0 KiB
2024-04-06T19:28:07.879732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length49
Mean length29.560272
Min length21

Characters and Unicode

Total characters17411
Distinct characters211
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

Unique458 ?
Unique (%)77.8%

Sample

1st row서울특별시 성북구 삼선교로 4, 1층 (삼선동1가)
2nd row서울특별시 성북구 인촌로11길 24 (안암동2가)
3rd row서울특별시 성북구 동소문로6길 14-3 (동소문동2가)
4th row서울특별시 성북구 정릉로27길 62 (정릉동)
5th row서울특별시 성북구 아리랑로 117-7 (정릉동)
ValueCountFrequency (%)
서울특별시 589
 
17.4%
성북구 589
 
17.4%
1층 124
 
3.7%
장위동 75
 
2.2%
동소문로 69
 
2.0%
정릉동 67
 
2.0%
하월곡동 65
 
1.9%
길음동 65
 
1.9%
종암동 42
 
1.2%
석관동 41
 
1.2%
Other values (604) 1665
49.1%
2024-04-06T19:28:08.769380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2810
 
16.1%
동 829
 
4.8%
1 685
 
3.9%
북 616
 
3.5%
성 616
 
3.5%
( 607
 
3.5%
) 607
 
3.5%
서 597
 
3.4%
시 592
 
3.4%
울 590
 
3.4%
Other values (201) 8862
50.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10438
60.0%
Space Separator 2810
 
16.1%
Decimal Number 2479
 
14.2%
Open Punctuation 607
 
3.5%
Close Punctuation 607
 
3.5%
Other Punctuation 384
 
2.2%
Dash Punctuation 67
 
0.4%
Uppercase Letter 16
 
0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 829
 
7.9%
북 616
 
5.9%
성 616
 
5.9%
서 597
 
5.7%
시 592
 
5.7%
울 590
 
5.7%
구 589
 
5.6%
로 589
 
5.6%
별 589
 
5.6%
특 589
 
5.6%
Other values (179) 4242
40.6%
Decimal Number
ValueCountFrequency (%)
1 685
27.6%
2 312
12.6%
4 248
 
10.0%
3 247
 
10.0%
0 218
 
8.8%
5 207
 
8.4%
6 184
 
7.4%
7 144
 
5.8%
8 138
 
5.6%
9 96
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
B 11
68.8%
A 3
 
18.8%
K 1
 
6.2%
S 1
 
6.2%
Other Punctuation
ValueCountFrequency (%)
, 381
99.2%
. 3
 
0.8%
Space Separator
ValueCountFrequency (%)
2810
100.0%
Open Punctuation
ValueCountFrequency (%)
( 607
100.0%
Close Punctuation
ValueCountFrequency (%)
) 607
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 67
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10438
60.0%
Common 6956
40.0%
Latin 17
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 829
 
7.9%
북 616
 
5.9%
성 616
 
5.9%
서 597
 
5.7%
시 592
 
5.7%
울 590
 
5.7%
구 589
 
5.6%
로 589
 
5.6%
별 589
 
5.6%
특 589
 
5.6%
Other values (179) 4242
40.6%
Common
ValueCountFrequency (%)
2810
40.4%
1 685
 
9.8%
( 607
 
8.7%
) 607
 
8.7%
, 381
 
5.5%
2 312
 
4.5%
4 248
 
3.6%
3 247
 
3.6%
0 218
 
3.1%
5 207
 
3.0%
Other values (7) 634
 
9.1%
Latin
ValueCountFrequency (%)
B 11
64.7%
A 3
 
17.6%
e 1
 
5.9%
K 1
 
5.9%
S 1
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10438
60.0%
ASCII 6973
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2810
40.3%
1 685
 
9.8%
( 607
 
8.7%
) 607
 
8.7%
, 381
 
5.5%
2 312
 
4.5%
4 248
 
3.6%
3 247
 
3.5%
0 218
 
3.1%
5 207
 
3.0%
Other values (12) 651
 
9.3%
Hangul
ValueCountFrequency (%)
동 829
 
7.9%
북 616
 
5.9%
성 616
 
5.9%
서 597
 
5.7%
시 592
 
5.7%
울 590
 
5.7%
구 589
 
5.6%
로 589
 
5.6%
별 589
 
5.6%
특 589
 
5.6%
Other values (179) 4242
40.6%

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

MISSING 

Distinct157
Distinct (%)38.9%
Missing349
Missing (%)46.3%
Infinite0
Infinite (%)0.0%
Mean25293.824
Minimum2701
Maximum136877
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.7 KiB
2024-04-06T19:28:09.187290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2701
5-th percentile2714.15
Q12750.75
median2802.5
Q32856
95-th percentile136817.85
Maximum136877
Range134176
Interquartile range (IQR)105.25

Descriptive statistics

Standard deviation50096.594
Coefficient of variation (CV)1.980586
Kurtosis1.173022
Mean25293.824
Median Absolute Deviation (MAD)53.5
Skewness1.7796544
Sum10218705
Variance2.5096687 × 109
MonotonicityNot monotonic
2024-04-06T19:28:09.530483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2751 17
 
2.3%
2845 11
 
1.5%
2860 11
 
1.5%
2737 8
 
1.1%
2833 8
 
1.1%
2781 7
 
0.9%
2787 7
 
0.9%
2725 7
 
0.9%
2830 7
 
0.9%
2829 6
 
0.8%
Other values (147) 315
41.8%
(Missing) 349
46.3%
ValueCountFrequency (%)
2701 5
0.7%
2702 1
 
0.1%
2709 5
0.7%
2710 5
0.7%
2711 3
0.4%
2714 2
 
0.3%
2715 2
 
0.3%
2716 1
 
0.1%
2717 3
0.4%
2718 5
0.7%
ValueCountFrequency (%)
136877 1
 
0.1%
136872 1
 
0.1%
136871 1
 
0.1%
136865 1
 
0.1%
136863 3
0.4%
136858 1
 
0.1%
136849 1
 
0.1%
136846 2
0.3%
136845 1
 
0.1%
136843 1
 
0.1%

사업장명
Text

Distinct542
Distinct (%)72.0%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2024-04-06T19:28:10.028608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length4
Mean length4.7131474
Min length3

Characters and Unicode

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

Unique

Unique409 ?
Unique (%)54.3%

Sample

1st row삼선교약국
2nd row청록약국
3rd row경일사약국
4th row삼원약국
5th row양지약국
ValueCountFrequency (%)
신중앙약국 7
 
0.9%
이화약국 5
 
0.7%
세계로약국 5
 
0.7%
현약국 5
 
0.7%
월곡보건약국 5
 
0.7%
한양약국 4
 
0.5%
용한약국 4
 
0.5%
신삼성약국 4
 
0.5%
동부약국 4
 
0.5%
나약국 4
 
0.5%
Other values (536) 713
93.8%
2024-04-06T19:28:10.929610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 759
21.4%
국 757
21.3%
성 61
 
1.7%
리 61
 
1.7%
신 49
 
1.4%
새 43
 
1.2%
온 43
 
1.2%
누 43
 
1.2%
한 43
 
1.2%
정 37
 
1.0%
Other values (272) 1653
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3520
99.2%
Decimal Number 15
 
0.4%
Space Separator 7
 
0.2%
Uppercase Letter 3
 
0.1%
Dash Punctuation 2
 
0.1%
Lowercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 759
21.6%
국 757
21.5%
성 61
 
1.7%
리 61
 
1.7%
신 49
 
1.4%
새 43
 
1.2%
온 43
 
1.2%
누 43
 
1.2%
한 43
 
1.2%
정 37
 
1.1%
Other values (263) 1624
46.1%
Decimal Number
ValueCountFrequency (%)
3 5
33.3%
6 3
20.0%
5 3
20.0%
1 2
 
13.3%
2 2
 
13.3%
Space Separator
ValueCountFrequency (%)
7
100.0%
Uppercase Letter
ValueCountFrequency (%)
W 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3520
99.2%
Common 24
 
0.7%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 759
21.6%
국 757
21.5%
성 61
 
1.7%
리 61
 
1.7%
신 49
 
1.4%
새 43
 
1.2%
온 43
 
1.2%
누 43
 
1.2%
한 43
 
1.2%
정 37
 
1.1%
Other values (263) 1624
46.1%
Common
ValueCountFrequency (%)
7
29.2%
3 5
20.8%
6 3
12.5%
5 3
12.5%
- 2
 
8.3%
1 2
 
8.3%
2 2
 
8.3%
Latin
ValueCountFrequency (%)
W 3
60.0%
e 2
40.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3520
99.2%
ASCII 29
 
0.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 759
21.6%
국 757
21.5%
성 61
 
1.7%
리 61
 
1.7%
신 49
 
1.4%
새 43
 
1.2%
온 43
 
1.2%
누 43
 
1.2%
한 43
 
1.2%
정 37
 
1.1%
Other values (263) 1624
46.1%
ASCII
ValueCountFrequency (%)
7
24.1%
3 5
17.2%
W 3
10.3%
6 3
10.3%
5 3
10.3%
- 2
 
6.9%
e 2
 
6.9%
1 2
 
6.9%
2 2
 
6.9%

최종수정일자
Date

UNIQUE 

Distinct753
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
Minimum2008-12-24 17:10:11
Maximum2024-04-04 16:50:37
2024-04-06T19:28:11.200293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:28:11.499551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
I
518 
U
235 

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 518
68.8%
U 235
31.2%

Length

2024-04-06T19:28:11.707252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:28:11.864565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 518
68.8%
u 235
31.2%

데이터갱신일자
Date

Distinct120
Distinct (%)15.9%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
Minimum2018-08-31 23:59:59
Maximum2023-12-04 00:06:00
2024-04-06T19:28:12.424475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:28:12.726137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing753
Missing (%)100.0%
Memory size6.7 KiB

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

MISSING 

Distinct398
Distinct (%)65.6%
Missing146
Missing (%)19.4%
Infinite0
Infinite (%)0.0%
Mean202469.57
Minimum199488.83
Maximum205996.72
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.7 KiB
2024-04-06T19:28:12.965541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum199488.83
5-th percentile200594.47
Q1201334.96
median202109.51
Q3203399.92
95-th percentile205313.03
Maximum205996.72
Range6507.8889
Interquartile range (IQR)2064.9652

Descriptive statistics

Standard deviation1475.1841
Coefficient of variation (CV)0.007285955
Kurtosis-0.6744108
Mean202469.57
Median Absolute Deviation (MAD)1000.0433
Skewness0.52650047
Sum1.2289903 × 108
Variance2176168.3
MonotonicityNot monotonic
2024-04-06T19:28:13.259362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201964.531844396 8
 
1.1%
202029.981799661 7
 
0.9%
202016.771411158 7
 
0.9%
203502.004139568 6
 
0.8%
201514.982796105 6
 
0.8%
200824.604254737 5
 
0.7%
201775.145663087 5
 
0.7%
203391.822778429 5
 
0.7%
205432.075000019 5
 
0.7%
205623.293707894 5
 
0.7%
Other values (388) 548
72.8%
(Missing) 146
 
19.4%
ValueCountFrequency (%)
199488.829016125 1
0.1%
199770.664453766 1
0.1%
199894.977167748 1
0.1%
199899.462073472 1
0.1%
199938.181251301 1
0.1%
199965.131621295 1
0.1%
200142.840558768 1
0.1%
200185.64871915 1
0.1%
200217.631104755 1
0.1%
200249.839707373 1
0.1%
ValueCountFrequency (%)
205996.717928956 1
 
0.1%
205683.367579911 1
 
0.1%
205638.858277791 2
 
0.3%
205633.913753653 1
 
0.1%
205625.468058174 1
 
0.1%
205623.293707894 5
0.7%
205601.885623333 1
 
0.1%
205508.074015164 1
 
0.1%
205494.938891359 1
 
0.1%
205451.739726761 2
 
0.3%

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

MISSING 

Distinct398
Distinct (%)65.6%
Missing146
Missing (%)19.4%
Infinite0
Infinite (%)0.0%
Mean455530.01
Minimum452958.92
Maximum457844.35
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.7 KiB
2024-04-06T19:28:13.559819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum452958.92
5-th percentile453695.24
Q1454532.44
median455782.11
Q3456399.15
95-th percentile457158.1
Maximum457844.35
Range4885.4312
Interquartile range (IQR)1866.7047

Descriptive statistics

Standard deviation1111.6243
Coefficient of variation (CV)0.0024402877
Kurtosis-0.91654439
Mean455530.01
Median Absolute Deviation (MAD)722.45547
Skewness-0.3894902
Sum2.7650671 × 108
Variance1235708.5
MonotonicityNot monotonic
2024-04-06T19:28:13.833846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
455825.760930114 8
 
1.1%
455605.716911266 7
 
0.9%
453854.347296253 7
 
0.9%
455500.568972657 6
 
0.8%
456137.084315817 6
 
0.8%
456284.330878228 5
 
0.7%
456029.568294901 5
 
0.7%
455590.997554483 5
 
0.7%
456876.255526188 5
 
0.7%
456797.0609748 5
 
0.7%
Other values (388) 548
72.8%
(Missing) 146
 
19.4%
ValueCountFrequency (%)
452958.916836799 1
 
0.1%
453026.691758481 3
0.4%
453075.215104012 1
 
0.1%
453087.42655617 1
 
0.1%
453228.537532712 3
0.4%
453269.45204751 1
 
0.1%
453340.61122764 1
 
0.1%
453346.258315658 1
 
0.1%
453397.525621696 1
 
0.1%
453407.74355038 1
 
0.1%
ValueCountFrequency (%)
457844.348010616 1
0.1%
457792.876809056 1
0.1%
457581.254031821 1
0.1%
457527.065931978 1
0.1%
457517.785910379 1
0.1%
457504.686411143 1
0.1%
457424.675484944 1
0.1%
457400.468735946 1
0.1%
457360.617372111 1
0.1%
457346.65044866 1
0.1%

약국영업면적
Real number (ℝ)

MISSING  ZEROS 

Distinct345
Distinct (%)49.9%
Missing61
Missing (%)8.1%
Infinite0
Infinite (%)0.0%
Mean25.542847
Minimum0
Maximum187.54
Zeros230
Zeros (%)30.5%
Negative0
Negative (%)0.0%
Memory size6.7 KiB
2024-04-06T19:28:14.072295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median23.4
Q337.405
95-th percentile70.5075
Maximum187.54
Range187.54
Interquartile range (IQR)37.405

Descriptive statistics

Standard deviation25.961632
Coefficient of variation (CV)1.0163954
Kurtosis3.924735
Mean25.542847
Median Absolute Deviation (MAD)23.3
Skewness1.4956541
Sum17675.65
Variance674.00633
MonotonicityNot monotonic
2024-04-06T19:28:14.301961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 230
30.5%
25.3 6
 
0.8%
36.0 5
 
0.7%
52.2 5
 
0.7%
27.0 4
 
0.5%
21.42 4
 
0.5%
16.2 4
 
0.5%
15.1 4
 
0.5%
22.9 4
 
0.5%
43.9 4
 
0.5%
Other values (335) 422
56.0%
(Missing) 61
 
8.1%
ValueCountFrequency (%)
0.0 230
30.5%
10.14 1
 
0.1%
11.19 1
 
0.1%
11.49 1
 
0.1%
12.0 1
 
0.1%
13.11 1
 
0.1%
13.9 1
 
0.1%
14.56 1
 
0.1%
14.8 1
 
0.1%
15.0 2
 
0.3%
ValueCountFrequency (%)
187.54 1
0.1%
143.6 1
0.1%
132.2 1
0.1%
131.0 1
0.1%
128.1 1
0.1%
125.22 1
0.1%
123.55 1
0.1%
112.7 1
0.1%
107.68 2
0.3%
105.27 1
0.1%

지정일자
Real number (ℝ)

MISSING 

Distinct654
Distinct (%)94.5%
Missing61
Missing (%)8.1%
Infinite0
Infinite (%)0.0%
Mean19983551
Minimum19570919
Maximum20220106
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.7 KiB
2024-04-06T19:28:14.528671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19570919
5-th percentile19686281
Q119877904
median20030714
Q320110124
95-th percentile20181055
Maximum20220106
Range649187
Interquartile range (IQR)232219.25

Descriptive statistics

Standard deviation153704.77
Coefficient of variation (CV)0.0076915644
Kurtosis-0.69547744
Mean19983551
Median Absolute Deviation (MAD)110149.5
Skewness-0.56632302
Sum1.3828617 × 1010
Variance2.3625156 × 1010
MonotonicityNot monotonic
2024-04-06T19:28:14.709242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19681111 5
 
0.7%
20140602 3
 
0.4%
19920407 3
 
0.4%
20090708 2
 
0.3%
19761220 2
 
0.3%
20161101 2
 
0.3%
19760830 2
 
0.3%
19771110 2
 
0.3%
20120529 2
 
0.3%
19870501 2
 
0.3%
Other values (644) 667
88.6%
(Missing) 61
 
8.1%
ValueCountFrequency (%)
19570919 1
0.1%
19590703 1
0.1%
19601110 1
0.1%
19601111 1
0.1%
19620413 1
0.1%
19621026 1
0.1%
19630715 1
0.1%
19640123 1
0.1%
19640620 1
0.1%
19640725 2
0.3%
ValueCountFrequency (%)
20220106 1
0.1%
20210628 1
0.1%
20210604 1
0.1%
20210514 1
0.1%
20210407 1
0.1%
20210208 1
0.1%
20210105 1
0.1%
20201020 1
0.1%
20200603 1
0.1%
20200514 1
0.1%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)약국영업면적지정일자
03070000PHMD11957307003408400000119570919<NA>3폐업3폐업20161013<NA><NA><NA>742-8627<NA>136041서울특별시 성북구 삼선동1가 22번지 2호 1층서울특별시 성북구 삼선교로 4, 1층 (삼선동1가)2866삼선교약국2016-10-13 14:01:19I2018-08-31 23:59:59.0<NA>200497.101365453965.68647140.5419570919
13070000PHMD11959307003408400000119590703<NA>3폐업3폐업20020521<NA><NA><NA><NA><NA>136072서울특별시 성북구 안암동2가 139번지<NA><NA>청록약국2012-09-07 16:44:10I2018-08-31 23:59:59.0<NA><NA><NA>0.019590703
23070000PHMD11960307003408400000119601111<NA>3폐업3폐업19920127<NA><NA><NA><NA><NA>136072서울특별시 성북구 안암동2가 81번지서울특별시 성북구 인촌로11길 24 (안암동2가)<NA>경일사약국2012-07-24 15:47:37I2018-08-31 23:59:59.0<NA>201860.984211453898.3192490.019601111
33070000PHMD11960307003408400000219601110<NA>3폐업3폐업19930210<NA><NA><NA><NA><NA>136032서울특별시 성북구 동소문동2가 92번지서울특별시 성북구 동소문로6길 14-3 (동소문동2가)<NA>삼원약국2012-08-27 09:55:06I2018-08-31 23:59:59.0<NA>200667.948127454015.0371070.019601110
43070000PHMD11962307003408400000119620413<NA>3폐업3폐업20140121<NA><NA><NA>02-914-1461<NA>136846서울특별시 성북구 정릉동 199번지 2호서울특별시 성북구 정릉로27길 62 (정릉동)136846양지약국2014-01-21 10:18:38I2018-08-31 23:59:59.0<NA>201118.632152456019.52274417.219620413
53070000PHMD11962307003408400000219621026<NA>3폐업3폐업20110523<NA><NA><NA>02-926-8500<NA>136045서울특별시 성북구 삼선동5가197<NA><NA>태창약국2011-05-23 17:34:51I2018-08-31 23:59:59.0<NA><NA><NA>15.6819621026
63070000PHMD1196330700340840000011963-10-19<NA>1영업/정상13영업중<NA><NA><NA><NA><NA><NA>136-843서울특별시 성북구 정릉동 107번지 15호서울특별시 성북구 아리랑로 117-7 (정릉동)2820동그라미약국2023-06-05 11:42:04U2022-12-06 00:08:00.0<NA>201080.292872455574.02455<NA><NA>
73070000PHMD11963307003408400000219630715<NA>3폐업3폐업20071228<NA><NA><NA><NA><NA>136075서울특별시 성북구 안암동5가 101번지 26호서울특별시 성북구 개운사길 8 (안암동5가)<NA>안암약국2012-07-24 15:25:21I2018-08-31 23:59:59.0<NA>202545.144965453819.1750980.019630715
83070000PHMD11964307003408400000119640620<NA>3폐업3폐업20130121<NA><NA><NA>02-926-8249<NA>136091서울특별시 성북구 종암1동53-5<NA><NA>유안약국2013-01-21 11:19:50I2018-08-31 23:59:59.0<NA><NA><NA>24.519640620
93070000PHMD11964307003408400000219640725<NA>1영업/정상13영업중<NA><NA><NA><NA>02-913-2130<NA>136130서울특별시 성북구 하월곡동 51번지 23호서울특별시 성북구 화랑로5길 42 (하월곡동)2748자산약국2021-12-09 13:59:29U2021-12-11 02:40:00.0<NA>203414.120355455782.10639444.2919640725
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)약국영업면적지정일자
7433070000PHMD1202330700340840000032023-05-18<NA>1영업/정상13영업중<NA><NA><NA><NA>02-921-0365<NA><NA>서울특별시 성북구 동소문동4가 75 흥화브라운 동소문빌딩서울특별시 성북구 동소문로 43, 흥화브라운 동소문빌딩 1층 (동소문동4가)2832매일행복약국2023-05-18 15:40:45I2022-12-04 22:00:00.0<NA>200820.261138454256.676715<NA><NA>
7443070000PHMD1202330700340840000042023-06-19<NA>1영업/정상13영업중<NA><NA><NA><NA>02-929-2111<NA><NA>서울특별시 성북구 안암동2가 161-39서울특별시 성북구 고려대로17길 3, 지하1층 (안암동2가)2843가까운동문약국2023-06-19 18:21:19I2022-12-05 22:01:00.0<NA>202153.418636453798.752823<NA><NA>
7453070000PHMD1202330700340840000052023-08-02<NA>1영업/정상13영업중<NA><NA><NA><NA>02-943-5988<NA><NA>서울특별시 성북구 장위동 323 꿈의숲 아이파크서울특별시 성북구 돌곶이로40길 46, 상가1동 5호 (장위동, 꿈의숲 아이파크)2762솔약국2023-08-02 16:10:36I2022-12-08 00:04:00.0<NA>204225.83282457424.675485<NA><NA>
7463070000PHMD1202330700340840000062023-09-12<NA>1영업/정상13영업중<NA><NA><NA><NA>02-6951-2999<NA><NA>서울특별시 성북구 종암동 124-129서울특별시 성북구 종암로 147, 1층 (종암동)2802참약사패밀리약국2023-09-12 14:33:26I2022-12-08 23:04:00.0<NA>202754.103017455638.029473<NA><NA>
7473070000PHMD1202330700340840000072023-09-15<NA>1영업/정상13영업중<NA><NA><NA><NA>02-911-7111<NA><NA>서울특별시 성북구 하월곡동 46-58서울특별시 성북구 화랑로 67 (하월곡동)2751새보건약국2023-09-15 09:23:35I2022-12-08 23:07:00.0<NA>203454.045314455586.254543<NA><NA>
7483070000PHMD1202330700340840000082023-10-19<NA>1영업/정상13영업중<NA><NA><NA><NA>02-943-4113<NA><NA>서울특별시 성북구 하월곡동 88-506서울특별시 성북구 동소문로46길 19, 1층 (하월곡동)2733성북365약국2023-10-19 16:09:22I2022-10-30 22:01:00.0<NA>202554.697474456091.91569<NA><NA>
7493070000PHMD1202330700340840000092023-12-21<NA>1영업/정상13영업중<NA><NA><NA><NA>02-928-8276<NA><NA>서울특별시 성북구 안암동5가 146-4서울특별시 성북구 고려대로 88, 1층 (안암동5가)2855행복온누리약국2023-12-21 14:11:01I2022-11-01 22:03:00.0<NA>202494.147884453758.902923<NA><NA>
7503070000PHMD1202430700340840000012024-01-10<NA>1영업/정상13영업중<NA><NA><NA><NA>02-909-2870<NA><NA>서울특별시 성북구 종암동 3-1192 종암대평빌딩 102호서울특별시 성북구 종암로 110, 종암대평빌딩 1층 102호 (종암동)2797행운약국2024-01-10 11:15:56I2023-11-30 23:02:00.0<NA>202962.436871455305.889037<NA><NA>
7513070000PHMD1202430700340840000022024-03-27<NA>1영업/정상13영업중<NA><NA><NA><NA>02-929-2225<NA><NA>서울특별시 성북구 동소문동4가 75-2 부라다리빙텔서울특별시 성북구 동소문로 47, 부라다리빙텔 (동소문동4가)2832새롬약국2024-03-27 16:57:53I2023-12-02 22:09:00.0<NA>200874.06951454285.976097<NA><NA>
7523070000PHMD1202430700340840000032024-03-27<NA>1영업/정상13영업중<NA><NA><NA><NA>02-6013-3334<NA><NA>서울특별시 성북구 동소문동1가 90 김내과빌딩서울특별시 성북구 동소문로 19, 김내과빌딩 1층 (동소문동1가)2833바른약국2024-03-27 17:59:11I2023-12-02 22:09:00.0<NA>200645.918769454135.508838<NA><NA>