Skip to content

Data Profile: adrc

Generated: 2025-11-24 19:33:07.505084 Schema: raw.adrc Total Rows: 1,639,343 Columns: 107 Completeness: 77.30%

Source Files

File Rows Size
20251105000515_adrc_6120.csv 1,639,343 2963.4 MB
Total 1,639,343 2963.4 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 CLIENT integer INTEGER No 0.00% 0
2 ADDRNUMBER string VARCHAR(15) No 0.00% 0
3 DATE_FROM string VARCHAR(12) No 0.00% 0
4 NATION string VARCHAR(1) Yes 100.00% 0
5 DATE_TO integer INTEGER No 0.00% 0
6 TITLE string VARCHAR(6) No 0.00% 0
7 NAME1 string VARCHAR(60) No 0.00% 0
8 NAME2 string VARCHAR(60) No 0.00% 0
9 NAME3 string VARCHAR(60) No 0.00% 0
10 NAME4 string VARCHAR(60) No 0.00% 0
11 NAME_TEXT string VARCHAR(75) No 0.00% 0
12 NAME_CO string VARCHAR(60) No 0.00% 0
13 CITY1 string VARCHAR(60) No 0.00% 0
14 CITY2 string VARCHAR(60) No 0.00% 0
15 CITY_CODE string VARCHAR(18) No 0.00% 0
16 CITYP_CODE string VARCHAR(12) No 0.00% 0
17 HOME_CITY string VARCHAR(60) No 0.00% 0
18 CITYH_CODE string VARCHAR(18) No 0.00% 0
19 CHCKSTATUS string VARCHAR(1) Yes 9.12% 0
20 REGIOGROUP string VARCHAR(12) No 0.00% 0
21 POST_CODE1 string VARCHAR(15) No 0.00% 0
22 POST_CODE2 string VARCHAR(15) No 0.00% 0
23 POST_CODE3 string VARCHAR(15) No 0.00% 0
24 PCODE1_EXT string VARCHAR(15) No 0.00% 0
25 PCODE2_EXT string VARCHAR(15) No 0.00% 0
26 PCODE3_EXT string VARCHAR(15) No 0.00% 0
27 PO_BOX string VARCHAR(15) No 0.00% 0
28 DONT_USE_P string VARCHAR(6) No 0.00% 0
29 PO_BOX_NUM string VARCHAR(1) Yes 98.35% 0
30 PO_BOX_LOC string VARCHAR(60) No 0.00% 0
31 CITY_CODE2 string VARCHAR(18) No 0.00% 0
32 PO_BOX_REG string VARCHAR(4) Yes 99.80% 0
33 PO_BOX_CTY string VARCHAR(4) Yes 100.00% 0
34 POSTALAREA string VARCHAR(22) No 0.00% 0
35 TRANSPZONE string VARCHAR(15) No 0.00% 0
36 STREET string VARCHAR(90) No 0.00% 0
37 DONT_USE_S string VARCHAR(6) No 0.00% 0
38 STREETCODE string VARCHAR(18) No 0.00% 0
39 STREETABBR string VARCHAR(3) Yes 37.05% 0
40 HOUSE_NUM1 string VARCHAR(15) No 0.00% 0
41 HOUSE_NUM2 string VARCHAR(15) No 0.00% 0
42 HOUSE_NUM3 string VARCHAR(15) No 0.00% 0
43 STR_SUPPL1 string VARCHAR(60) No 0.00% 0
44 STR_SUPPL2 string VARCHAR(60) No 0.00% 0
45 STR_SUPPL3 string VARCHAR(60) No 0.00% 0
46 LOCATION string VARCHAR(60) No 0.00% 0
47 BUILDING string VARCHAR(30) No 0.00% 0
48 FLOOR string VARCHAR(15) No 0.00% 0
49 ROOMNUMBER string VARCHAR(15) No 0.00% 0
50 COUNTRY string VARCHAR(4) Yes 0.51% 0
51 LANGU string VARCHAR(1) Yes 0.31% 0
52 REGION string VARCHAR(4) Yes 4.50% 0
53 ADDR_GROUP string VARCHAR(6) No 0.00% 0
54 FLAGGROUPS string VARCHAR(1) Yes 100.00% 0
55 PERS_ADDR string VARCHAR(1) Yes 96.52% 0
56 SORT1 string VARCHAR(30) No 0.00% 0
57 SORT2 string VARCHAR(30) No 0.00% 0
58 SORT_PHN string VARCHAR(30) No 0.00% 0
59 DEFLT_COMM string VARCHAR(4) Yes 92.74% 0
60 TEL_NUMBER string VARCHAR(45) No 0.00% 0
61 TEL_EXTENS string VARCHAR(15) No 0.00% 0
62 FAX_NUMBER string VARCHAR(45) No 0.00% 0
63 FAX_EXTENS string VARCHAR(15) No 0.00% 0
64 FLAGCOMM2 string VARCHAR(1) Yes 83.14% 0
65 FLAGCOMM3 string VARCHAR(1) Yes 96.19% 0
66 FLAGCOMM4 string VARCHAR(1) Yes 100.00% 0
67 FLAGCOMM5 string VARCHAR(1) Yes 100.00% 0
68 FLAGCOMM6 string VARCHAR(1) Yes 92.16% 0
69 FLAGCOMM7 string VARCHAR(1) Yes 100.00% 0
70 FLAGCOMM8 string VARCHAR(1) Yes 100.00% 0
71 FLAGCOMM9 string VARCHAR(1) Yes 100.00% 0
72 FLAGCOMM10 string VARCHAR(1) Yes 100.00% 0
73 FLAGCOMM11 string VARCHAR(1) Yes 100.00% 0
74 FLAGCOMM12 string VARCHAR(1) Yes 99.93% 0
75 FLAGCOMM13 string VARCHAR(1) Yes 100.00% 0
76 ADDRORIGIN string VARCHAR(6) No 0.00% 0
77 MC_NAME1 string VARCHAR(37) No 0.00% 0
78 MC_CITY1 string VARCHAR(37) No 0.00% 0
79 MC_STREET string VARCHAR(37) No 0.00% 0
80 EXTENSION1 string VARCHAR(60) No 0.00% 0
81 EXTENSION2 string VARCHAR(60) No 0.00% 0
82 TIME_ZONE string VARCHAR(9) No 0.00% 0
83 TAXJURCODE string VARCHAR(22) No 0.00% 0
84 ADDRESS_ID string VARCHAR(15) No 0.00% 0
85 LANGU_CREA string VARCHAR(1) Yes 18.58% 0
86 ADRC_UUID string VARCHAR(48) No 0.00% 0
87 UUID_BELATED string VARCHAR(1) Yes 100.00% 0
88 ID_CATEGORY string VARCHAR(1) Yes 100.00% 0
89 ADRC_ERR_STATUS string VARCHAR(1) Yes 100.00% 0
90 PO_BOX_LOBBY string VARCHAR(60) No 0.00% 0
91 DELI_SERV_TYPE string VARCHAR(6) No 0.00% 0
92 DELI_SERV_NUMBER string VARCHAR(15) No 0.00% 0
93 COUNTY_CODE string VARCHAR(12) No 0.00% 0
94 COUNTY string VARCHAR(60) No 0.00% 0
95 TOWNSHIP_CODE string VARCHAR(12) No 0.00% 0
96 TOWNSHIP string VARCHAR(60) No 0.00% 0
97 MC_COUNTY string VARCHAR(37) No 0.00% 0
98 MC_TOWNSHIP string VARCHAR(37) No 0.00% 0
99 XPCPT string VARCHAR(1) Yes 100.00% 0
100 _DATAAGING string VARCHAR(12) No 0.00% 0
101 /SAPCE/IURU_PRO string VARCHAR(7) No 0.00% 0
102 /SAPCE/IUL string VARCHAR(30) No 0.00% 0
103 /SAPCE/IUTR_CONC string VARCHAR(12) No 0.00% 0
104 /SAPCE/IUTR_TWSC string VARCHAR(12) No 0.00% 0
105 /SAPCE/IUTR_MUVC string VARCHAR(12) No 0.00% 0
106 DUNS string VARCHAR(13) No 0.00% 0
107 DUNSP4 string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. CLIENT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

100

2. ADDRNUMBER

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

0000397311, 0000223134, 0000220246, 0000581001, 0000211574

3. DATE_FROM

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

00010101

4. NATION

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

5. DATE_TO

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

99991231

6. TITLE

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

    , 0002, 0001, 0004, 0005

7. NAME1

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Irniger                                 , GR Apparate                             , Liegenschaften Stadt Zürich             , Huber

8. NAME2

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Peter                                   , Hans                                    , Walter                                  , Thomas

9. NAME3

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Dr.                                     , Dr. med.                                , Prof. Dr.                               , Dr. iur.

10. NAME4

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Architekturbüro                         , Architekt                               , und Mitbeteiligte                       , Liegenschaftenverwaltung

11. NAME_TEXT

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                                  , Frau + Herr Hess Otto M. + Elvira                 , M + L Martinelli Lanfranchi Partner AG            , Frau und Herr Neuenburger-Nötzli                  , Frau und Herr Pineroli Esther + Nello

12. NAME_CO

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , UBS AG                                  , ImmoBaden AG                            , Ascher Ben-Shmuel                       , c/o RA Dr. Konrad Butz

13. CITY1

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

Zürich                                  ,                                         , Winterthur                              , Stäfa                                   , Meilen

14. CITY2

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , S1                                      , Nein                                    , NEIN                                    , Madrid

15. CITY_CODE

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

000000000001,             , 000000000134, 000000000088, 000000000098

16. CITYP_CODE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

17. HOME_CITY

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

18. CITYH_CODE

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

19. CHCKSTATUS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,489,911 (90.9%)
Null 149,432 (9.12%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

C, D

20. REGIOGROUP

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X       ,         , K0003   , K0009   , K0007

21. POST_CODE1

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 8004      , 8003      , 8032      , 8006

22. POST_CODE2

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 8010      , 8023      , 8021      , 8022

23. POST_CODE3

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 8010      , 8052      , 3001      , 8038

24. PCODE1_EXT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

25. PCODE2_EXT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

26. PCODE3_EXT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

27. PO_BOX

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 805       , POSTFACH  , .         , 100

28. DONT_USE_P

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

29. PO_BOX_NUM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 27,035 (1.6%)
Null 1,612,308 (98.35%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

30. PO_BOX_LOC

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Zürich-Mülligen                         , Zürich                                  , Zürich Amtsstellen Kt ZH                , Feldmeilen

31. CITY_CODE2

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

            , 000000005087, 000000000001, 000000005415, 000000002141

32. PO_BOX_REG

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 3,286 (0.2%)
Null 1,636,057 (99.80%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

 Z ,  0 , X  ,  A ,  B

33. PO_BOX_CTY

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 2 (0.0%)
Null 1,639,341 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

BS

34. POSTALAREA

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

35. TRANSPZONE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 0000000001

36. STREET

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                                            , Seestrasse                                                  , Dorfstrasse                                                 , Bahnhofstrasse                                              , Badenerstrasse

37. DONT_USE_S

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

38. STREETCODE

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

            , 000000000001, 000000000008, 000000000002, 000000000007

39. STREETABBR

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,031,904 (62.9%)
Null 607,439 (37.05%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

02, 06, 01, 03, 28

40. HOUSE_NUM1

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 9999999999, 2         , 4         , 1

41. HOUSE_NUM2

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , A         , a         , B         , b

42. HOUSE_NUM3

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

43. STR_SUPPL1

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , z.Hd. Frau Corinne Aceto                , Sonnenhaldenstrasse 93                  , Uetlibergstrasse 44                     , Hadlikon

44. STR_SUPPL2

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Heizung + Warmwasser                    , Heizung                                 , Kochen                                  , Heizung ohne Warmwasser

45. STR_SUPPL3

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Postfach                                , Sellenbüren                             , 2                                       , Appartment 4 C

46. LOCATION

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , Gas                                     , Heizung + Warmwasser                    , Gasheizung                              , Heizung

47. BUILDING

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                    , Amtshaus V          , Jona-Center 2       , WFE 2               , Kreis III

48. FLOOR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , U1        , ALLG      , P         , 2L

49. ROOMNUMBER

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , 106       , 3471      , Garage    , /Bauhof

50. COUNTRY

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,630,908 (99.5%)
Null 8,435 (0.51%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

CH , DE , LI , AT , FR

51. LANGU

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,634,303 (99.7%)
Null 5,040 (0.31%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

D, F, I, E, B

52. REGION

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,565,591 (95.5%)
Null 73,752 (4.50%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

 Z , X  ,  0 ,  A , ZH

53. ADDR_GROUP

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

BP  , PM01, SD01, ME02, CAM1

54. FLAGGROUPS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

55. PERS_ADDR

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 57,108 (3.5%)
Null 1,582,235 (96.52%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

56. SORT1

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                    , GVZ                 , LÖSCHVERMERK        , LIGI                , STIFTUNG

57. SORT2

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                    , 9000032             , 8440394             , 9135255             , 9108649

58. SORT_PHN

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

59. DEFLT_COMM

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 119,063 (7.3%)
Null 1,520,280 (92.74%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

LET, INT, TEL, VIS, FAX

60. TEL_NUMBER

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                              , 043 317 22 22                 , 01 / 211 16 72                , 044 251 65 20                 , 018404136

61. TEL_EXTENS

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , MOBILE    , GESCHAEFT , PRIVAT    , G

62. FAX_NUMBER

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                              , 043 317 20 20                 , 01 / 221 04 41                , 044 397 11 12                 , 021 315 80 03

63. FAX_EXTENS

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

          , FAX       , AB 04-2003, 467       , HANDY

64. FLAGCOMM2

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 276,327 (16.9%)
Null 1,363,016 (83.14%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

65. FLAGCOMM3

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 62,518 (3.8%)
Null 1,576,825 (96.19%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

66. FLAGCOMM4

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 8 (0.0%)
Null 1,639,335 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

67. FLAGCOMM5

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 45 (0.0%)
Null 1,639,298 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

68. FLAGCOMM6

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 128,504 (7.8%)
Null 1,510,839 (92.16%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

69. FLAGCOMM7

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1 (0.0%)
Null 1,639,342 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

70. FLAGCOMM8

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

71. FLAGCOMM9

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

72. FLAGCOMM10

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

73. FLAGCOMM11

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

74. FLAGCOMM12

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,195 (0.1%)
Null 1,638,148 (99.93%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

75. FLAGCOMM13

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 8 (0.0%)
Null 1,639,335 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

X

76. ADDRORIGIN

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

77. MC_NAME1

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                         , IRNIGER                  , GR APPARATE              , GD SERVICE-ABO           , LIEGENSCHAFTEN STADT ZÜRI

78. MC_CITY1

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

ZÜRICH                   ,                          , WINTERTHUR               , STÄFA                    , MEILEN

79. MC_STREET

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                         , SEESTRASSE               , DORFSTRASSE              , BAHNHOFSTRASSE           , NORDSTRASSE

80. EXTENSION1

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , t                                       , als Ziel das Cambridge English: Advanced, 01/365 82 82

81. EXTENSION2

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , 01 216 42 67                            , 044 216 42 67                           , auf dem Weg zu einem höheren Certificate, Walter Ramseier

82. TIME_ZONE

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

CET   ,       , CST

83. TAXJURCODE

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

               , 9987

84. ADDRESS_ID

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

85. LANGU_CREA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 1,334,727 (81.4%)
Null 304,616 (18.58%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

D

86. ADRC_UUID

Type: string → VARCHAR(48)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 32
Avg Length 0.0
Buffered Length 48 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

00000000000000000000000000000000, 76E69EC3FA1B1EE9ABEE577D27C52DD4, 56D7EE08E50C2080E10080000A723C30, 76E69EC3FA1B1ED9B6A43F4EB0574813, 0050568FA7711EEA91D394EB058A638F

87. UUID_BELATED

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

88. ID_CATEGORY

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

89. ADRC_ERR_STATUS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

90. PO_BOX_LOBBY

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

                                        , 14

91. DELI_SERV_TYPE

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

92. DELI_SERV_NUMBER

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

93. COUNTY_CODE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

94. COUNTY

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

95. TOWNSHIP_CODE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

96. TOWNSHIP

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

97. MC_COUNTY

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

98. MC_TOWNSHIP

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

99. XPCPT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

100. _DATAAGING

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

00000000

101. /SAPCE/IURU_PRO

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

102. /SAPCE/IUL

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

103. /SAPCE/IUTR_CONC

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

104. /SAPCE/IUTR_TWSC

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

105. /SAPCE/IUTR_MUVC

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

106. DUNS

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 1,639,343
Non-null 1,639,343 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 9
Avg Length 0.0
Buffered Length 13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values:

107. DUNSP4

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 1,639,343
Non-null 0 (0.0%)
Null 1,639,343 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,639,343 - Parse Success: 1,639,343 / 1,639,343

Sample Values: 

(no data)

PostgreSQL DDL

See adrc_schema.sql

Generated by process-csv-to-postgres v1.0.0