Monarchs of England, Scotland and the United Kingdom
Every monarch of England and of Scotland, of Great Britain from 1707 and of the United Kingdom from 1801, with reign dates, royal house and dates of birth and death. One row per reign on each throne.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| id | Statement | string | Wikidata statement id of the term (stable row id). |
| name | Name | string | Office-holder's name. |
| entity | Wikidata | entity | Wikidata item for the person. |
| office | Office | string | The office held in this term, as named in Wikidata. |
| office_entity | Office (Wikidata) | entity | Wikidata item for the office. |
| royal_house | Royal house | string | Dynasty or royal house (Wikidata 'family', P53); several are listed when Wikidata records more than one. |
| royal_house_entity | Royal house (Wikidata) | entity | — |
| term_start | Took office | date | Start of the term, at the precision Wikidata records (day, month or year). |
| term_end | Left office | date | End of the term; blank for the incumbent or when unknown. |
| days_in_office | Days in office | integer · days | Length of the term in days, when both dates are known to the day. |
| acting | Acting | boolean | True when Wikidata marks the term as acting, interim or caretaker. |
| predecessor | Predecessor | string | Who this person replaced, as recorded on the term. |
| predecessor_entity | Predecessor (Wikidata) | entity | — |
| successor | Successor | string | Who replaced this person, as recorded on the term. |
| successor_entity | Successor (Wikidata) | entity | — |
| end_cause | End cause | string | Why the term ended (e.g. resignation, death in office), where recorded. |
| birth_date | Born | date | Date of birth. |
| death_date | Died | date | Date of death. |
| image | Portrait | image | Portrait from Wikimedia Commons. |
More in Politics & Government
Every member of the U.S. Congress since 1789
Every person who has served in the U.S. Senate or House of Representatives since the First Congress in 1789, including current members and non-voting delegates, with party, chamber, state, first and last year of service and number of terms. One row per person.
Heads of state of every country, all time
Everyone recorded in Wikidata as holding the head-of-state office of a present-day sovereign state — monarchs, presidents and their historical equivalents — with start and end dates and party. One row per term of office per country.
Countries of the world
Every present-day sovereign state with its ISO codes, capital, continent, area, population, official languages, currency, head of state and government, founding date, calling code, internet domain and flag. One row per country.
Political regime of every country since 1789 (democracy or autocracy)
Whether each country was a closed autocracy, electoral autocracy, electoral democracy or liberal democracy in each year since 1789, using the Regimes of the World classification based on V-Dem data. One row is one country in one year.
Freedom of expression, women's political empowerment and checks on government by country (V-Dem)
Four V-Dem indices for every country since 1789: freedom of expression, women's political empowerment, and judicial and legislative constraints on the executive. One row is one country in one year.
Human Rights Index by country (V-Dem)
V-Dem's Human Rights Index (civil liberties index) — expert estimates of freedom from government torture, political killings and forced labor, property rights, and freedoms of movement, religion, expression and association — for every country since 1789. One row is one country in one year.