Skip to content

Data Profile: sap_verbrauchsstelle

Generated: 2025-11-27 00:26:19.883532 Schema: raw_results.sap_verbrauchsstelle Total Rows: 73,268 Columns: 7 Completeness: 100.00%

Source Files

File Rows Size
sap_verbrauchsstelle.csv 73,268 5.3 MB
Total 73,268 5.3 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 OBJECTID integer INTEGER No 0.00% 0
2 recz integer INTEGER No 0.00% 0
3 vstelle integer INTEGER No 0.00% 0
4 loevm string VARCHAR(6) No 0.00% 0
5 haus string VARCHAR(31) No 0.00% 0
6 vbsart string VARCHAR(9) No 0.00% 0
7 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

73216, 73223, 73226, 73229, 73251

2. recz

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

73216, 73223, 73226, 73229, 73251

3. vstelle

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

2312723, 2312728, 2312481, 2312488, 2312494

4. loevm

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

NULL, X

5. haus

Type: string → VARCHAR(31)
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 21
Avg Length 0.0
Buffered Length 31 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

Z/0001.01915.0085, Z/0001.01923.0004, Z/0001.01928.0008, Z/0001.01927.0014, Z/0001.01944.0036

6. vbsart

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

MFH, NULL, EFH, BG, RB

7. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 73,268
Non-null 73,268 (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: 73,268 - Parse Success: 73,268 / 73,268

Sample Values: 

2025-11-02 00:00:00

PostgreSQL DDL

See sap_verbrauchsstelle_schema.sql

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