Choose your licenseFree with a confirmed account. Download securely.
Secure checkout
Combined multi-format protected ZIP UTF-8 CSVJSONSQLiteREADMESchemaLicenseSigned manifest
US Vice Presidents List List

US Vice Presidents List v.2.0.0

50 Database Records


US Vice Presidents List catalog icon US Vice Presidents List Download
Explore the complete history of the vice presidency in one current, analysis-ready database. All 50 vice presidents are included with ordinal number, full name, party, birth and death details, exact service dates, presidents served under, succession or resignation outcome, and source links. Separate service segments preserve George Clinton and John C. Calhoun under each administration, while the SQLite release adds a normalized history of every vacancy in the office.

Table Schema Database Field Statistics

Release structure

US Vice Presidents List

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#750
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
FieldTypeRequiredDescription
ordinalintegerYesOrdinal.
nametextYesName.
full_nametextYesFull name.
partytextYesParty.
birth_datedateYesBirth date.
birth_placetextYesBirth place.
death_datedateNoDeath date.
service_startdateYesService start.
service_enddateNoService end.
end_reasontextYesEnd reason.
administrationstextYesAdministrations.
service_segmentsjsonYesService segments.
source_urltextYesSource url.
notestextNoNotes.

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for US Vice Presidents List.

50Records in this release
14Fields per record
0Duplicate records
0Rejected source rows
ordinalOrdinal.
Distinct
50
Missing
0.0%
nameName.
Distinct
50
Missing
0.0%
full_nameFull name.
Distinct
50
Missing
0.0%
partyParty.
Distinct
5
Missing
0.0%
birth_dateBirth date.
Distinct
50
Missing
0.0%
birth_placeBirth place.
Distinct
49
Missing
0.0%
death_dateDeath date.
Distinct
43
Missing
14.0%
service_startService start.
Distinct
50
Missing
0.0%
service_endService end.
Distinct
50
Missing
2.0%
end_reasonEnd reason.
Distinct
5
Missing
0.0%
administrationsAdministrations.
Distinct
42
Missing
0.0%
service_segmentsService segments.
Distinct
50
Missing
0.0%
source_urlSource url.
Distinct
1
Missing
0.0%
notesNotes.
Distinct
2
Missing
96.0%

Party

  • Republican27
  • Democratic20
  • Federalist1
  • National Republican1
  • Whig1

Service End Reason

  • Term Completed31
  • Succeeded To Presidency9
  • Died In Office7
  • Resigned2
  • Incumbent1

Records Information

Each main record represents one numbered vice president. Administration segments are embedded without duplicating the person record. The SQLite service_segments table provides one row per president-vice president relationship, and the vacancies table documents periods when the office was unoccupied. Blank death dates identify living people; a blank service end identifies the incumbent.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

Oddity Support

How can we help?

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details