Skip to content

Data Profile: euigrid

Generated: 2025-11-25 00:43:34.205483 Schema: raw.euigrid Total Rows: 64,704 Columns: 14 Completeness: 92.86%

Source Files

File Rows Size
20251104235914_euigrid_6120.csv 64,704 9.4 MB
Total 64,704 9.4 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 INT_UI string VARCHAR(33) No 0.00% 0
3 DATETO integer INTEGER No 0.00% 0
4 TIMETO string VARCHAR(9) No 0.00% 0
5 DATEFROM integer INTEGER No 0.00% 0
6 TIMEFROM string VARCHAR(9) No 0.00% 0
7 GRID_ID string VARCHAR(15) No 0.00% 0
8 ERDAT string VARCHAR(12) No 0.00% 0
9 ERNAM string VARCHAR(18) No 0.00% 0
10 AEDAT string VARCHAR(12) No 0.00% 0
11 AENAM string VARCHAR(18) No 0.00% 0
12 BEGRU string VARCHAR(6) No 0.00% 0
13 LOEVM string VARCHAR(1) Yes 100.00% 0
14 GRID_LEVEL string VARCHAR(10) Yes 0.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

100

2. INT_UI

Type: string → VARCHAR(33)
Nullable: No

Metric Value
Total Rows 64,704
Non-null 64,704 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 22
Avg Length 0.0
Buffered Length 33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 64,704 - Parse Success: 64,704 / 64,704

Sample Values: 

IH14SvKS0DFX08002d8yC0, FexAJhgxFiZX0000WtKzI0, lMvshVCr7{2cf2IKeTjCYW, lMvshVCr7{2de9rgMPsCYm, lMvshVCr7{2dkA}VtvUCZW

3. DATETO

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

99991231, 20110213, 20110131, 20100930, 20220831

4. TIMETO

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values: 

235959, 055959

5. DATEFROM

Type: integer → INTEGER
Nullable: No

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

Sample Values: 

19940101, 20081001, 20241001, 20250201, 20250901

6. TIMEFROM

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values: 

000000, 060000

7. GRID_ID

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values: 

EZ-02     , EZ-01     , N_RESOLOT , EGO-01    , N_COSVEGAZ

8. ERDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

20101029, 20110214, 20110201, 20101113, 20110809

9. ERNAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

MAGMIG      , JOGGI       , ZUPPIGER    , SCHEFER     , BLESS

10. AEDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values: 

00000000, 20131011, 20110809, 20111201, 20110214

11. AENAM

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values: 

            , ZUPPIGER    , BLESS       , KRUG        , ERNI

12. BEGRU

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

13. LOEVM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 64,704
Non-null 0 (0.0%)
Null 64,704 (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: 64,704 - Parse Success: 64,704 / 64,704

Sample Values: 

(no data)

14. GRID_LEVEL

Type: string → VARCHAR(10)
Nullable: Yes

Metric Value
Total Rows 64,704
Non-null 64,702 (100.0%)
Null 2 (0.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 7
Avg Length 0.0
Buffered Length 10 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 64,704 - Parse Success: 64,704 / 64,704

Sample Values: 

ND, MD, HD5, HD25/70, HD

PostgreSQL DDL

See euigrid_schema.sql

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