US Presidents List v.2.0.0
47 Database Records
The US Presidents List is a current, structured reference to every official presidential number from George Washington through the present administration. The release distinguishes presidential ordinals from unique people, correctly linking Grover Cleveland to numbers 22 and 24 and Donald J. Trump to numbers 45 and 47. Each record includes exact term dates, party or historical ticket affiliation, vice presidents and vacancies, birth and death details, election years, accession method, and departure context. Matching UTF-8 CSV, JSON, and SQLite files are included with schema, sample, statistics, sources, and rights documentation.
Table Schema Database Field Statistics
Release structure
US Presidents List
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #749
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| presidential_number | integer | Yes | Official ordinal of the presidency. Nonconsecutive presidencies receive separate numbers. |
| person_id | text | Yes | Stable normalized identifier linking separate presidencies held by the same person. |
| full_name | text | Yes | Common full presidential name. |
| birth_date | text | Yes | Birth date in ISO 8601 format. |
| birth_state_or_country | text | Yes | Birth jurisdiction using the historical place's present-day state or country label. |
| death_date | text | No | Death date in ISO 8601 format; blank for a living person. |
| term_start | text | Yes | Date this numbered presidency began. |
| term_end | text | No | Date this numbered presidency ended; blank only for the current presidency. |
| party_at_accession | text | Yes | Party or ticket affiliation at the start of this presidency; historical coalition labels are retained. |
| vice_presidents | text | Yes | Vice presidents and explicitly identified vacancies during this presidency, in service order. |
| accession_method | text | Yes | How the person first entered this numbered presidency. |
| elected_terms | text | No | Election years won for this numbered presidency; blank when the president only succeeded to office. |
| left_office_reason | text | Yes | How this numbered presidency ended, or currently serving. |
| is_current | boolean | Yes | True only for the presidency in office at build time. |
| white_house_source | text | Yes | Official White House source family used for presidential identity and biographical reconciliation. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for US Presidents List.
presidential_numberOfficial ordinal of the presidency. Nonconsecutive presidencies receive separate numbers.
- Distinct
- 47
- Missing
- 0.0%
person_idStable normalized identifier linking separate presidencies held by the same person.
- Distinct
- 45
- Missing
- 0.0%
full_nameCommon full presidential name.
- Distinct
- 45
- Missing
- 0.0%
birth_dateBirth date in ISO 8601 format.
- Distinct
- 45
- Missing
- 0.0%
birth_state_or_countryBirth jurisdiction using the historical place's present-day state or country label.
- Distinct
- 21
- Missing
- 0.0%
death_dateDeath date in ISO 8601 format; blank for a living person.
- Distinct
- 40
- Missing
- 12.8%
term_startDate this numbered presidency began.
- Distinct
- 47
- Missing
- 0.0%
term_endDate this numbered presidency ended; blank only for the current presidency.
- Distinct
- 47
- Missing
- 2.1%
party_at_accessionParty or ticket affiliation at the start of this presidency; historical coalition labels are retained.
- Distinct
- 8
- Missing
- 0.0%
vice_presidentsVice presidents and explicitly identified vacancies during this presidency, in service order.
- Distinct
- 44
- Missing
- 0.0%
accession_methodHow the person first entered this numbered presidency.
- Distinct
- 5
- Missing
- 0.0%
elected_termsElection years won for this numbered presidency; blank when the president only succeeded to office.
- Distinct
- 43
- Missing
- 10.6%
left_office_reasonHow this numbered presidency ended, or currently serving.
- Distinct
- 5
- Missing
- 0.0%
is_currentTrue only for the presidency in office at build time.
- Distinct
- 2
- Missing
- 0.0%
white_house_sourceOfficial White House source family used for presidential identity and biographical reconciliation.
- Distinct
- 2
- Missing
- 0.0%
Records Information
Each row represents one official presidential ordinal. The primary key is presidential_number, while person_id links nonconsecutive presidencies held by the same person. This produces 47 records for 45 unique people. Dates are normalized to ISO 8601, current and living values are represented explicitly, and vice-presidential vacancies are retained rather than guessed away.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
RECENT DATA UPDATES
U.S. Jewelers and Jewelry Store Locations Database
38,557 Jewelry retail locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Pet Boarding and Kennel Locations Database
6,859 Pet boarding locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Animal Hospital Locations Database
2,990 Animal hospital locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Veterinarian Practice Locations Database
39,007 Veterinarian practice locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs