Production Setup

Vietnam National Assembly Term 16 database workspace

The app now includes a schema, a PDF extraction script, a CSV template, and verification pages for the 500 elected members listed in the official PDF.

Open members QA view Open raw JSON

1. Extract the PDF

Run the extraction script to convert the National Assembly PDF into a CSV file with 500 rows.

2. Create the table

Paste the SQL from supabase/001_create_assembly_members.sql into the Supabase SQL Editor and run it once.

3. Import the CSV

Upload data/import/assembly_members.csv into the assembly_members table using the Supabase dashboard.

4. Verify the result

Open /members and /members/json to make sure names, provinces, and positions look correct.