# Staged database additions - 21 June 2026

Drafted on 21 June 2026. NOTHING here has been written to your live database.
Your live PantherLIVE.json is unchanged (400 examples, 40 thinkers).

## What is here

- 47 new EXAMPLES, IDs E372 to E418, every row Status = Draft.
  - Combined import file: All-New-Examples-Draft-2026-06-21.json
  - Per-batch files (xlsx + json) also kept for reference.
- 108 PEOPLE across all three papers, IDs PP001 to PP086, every row Status = Draft.
  - Definitive file: People-Database-AllPapers-Draft-2026-06-21.json (and .xlsx)
  - Combined import file: All-People-in-Politics-Draft-2026-06-21.json
  - (The two earlier people files of 41 are now folded into this; use the all-papers file.)
- STAGED-ADDITIONS-MASTER-2026-06-21.xlsx - one workbook, two tabs, to review everything.
- A phone look-up page: PantherLive/phone/people.html (self-contained, searchable, filter by
  paper). It is NOT linked from the menu yet, so students do not see it until you surface it.

## Why it is safe

- Every example ID (E372-E418) is NEW. None exists in your live database, so importing is
  append-only and cannot change any existing row.
- Every row is Status = Draft, so after import it stays hidden as a draft until you promote it.
- The example JSON already matches your live example schema (the same 40 fields).
- people.html only reads an embedded copy of the data, not the live database.

## To merge the examples into the live database (only when ready)

1. Back up PantherLive/PantherLIVE.json and PantherLivePhone/PantherLIVE.json to Panther/Backups/.
2. Append the objects in All-New-Examples-Draft-2026-06-21.json to the "examples" array. Do not
   edit or remove any existing item.
3. Mirror the file to PantherLivePhone/PantherLIVE.json.
4. Check the new Draft rows, then set Status to Active when happy.

## People

Your live database has no people table yet (key_thinkers holds ideology theorists only).
The people set mirrors key_thinkers, so it can later become a new "people" array plus the
phone look-up page (already built). For now it is a standalone reference plus that page.

## One rule

Append by new ID only. Never let an import overwrite an existing row.