=== REGION DATA ANALYSIS ===

provinces      : 34 rows
regencies      : 1031 rows
districts      : 14437 rows
villages       : [MISSING]

Total Profiles: 2427

Missing Data Breakdown:
Province ID    : 1671 filled (68.9%) | 756 empty
Regency ID     : 1665 filled (68.6%) | 762 empty
District ID    : 1587 filled (65.4%) | 840 empty
Other Prov     : 16 filled (0.7%) | 2411 empty
Other Reg      : 16 filled (0.7%) | 2411 empty
Other Dist     : 54 filled (2.2%) | 2373 empty

Sample Data (First 5 with any region info):
ID: 010ZVZ | P: 31 () | R: 3171 ()
ID: 01RB8R | P: 61 () | R: 6110 ()
ID: 01WOK3 | P: 36 () | R: 3602 ()
ID: 01YCJ2 | P: 31 () | R: 3173 ()
ID: 022HSV | P: 36 () | R: 3604 ()

Checking Relationship Integrity (Province)...
Profiles with Province ID but no matching Province record: 35

Checking 'additional_data' JSON...
Profiles with 'provinsi/kabupaten' text in JSON: 2

=== END ANALYSIS ===