Join related tables on location_id. Keep IDs and postal codes as text. CSV blank values correspond to JSON null and SQLite NULL. Check each table's schema and sample before loading. Reported open status and source confidence do not prove a location currently operates.