Join providers to practice_locations and provider_taxonomies on npi. Keep identifiers and postal codes as text. Dates use YYYY-MM-DD. CSV blanks correspond to JSON null and SQLite NULL. Each person has one reported primary address; related rows are not additional people. Shared addresses do not prove shared ownership or employment.