names

37 rows where place_id = 588884

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595896 1866351 1866351 defendant Aure John yeoman 588884 588884 Aure, John, of Aure, yeoman 1
3595897 1866351 1866351 defendant Tysyn or Tyfyn Richard yeoman 588884 588884 Tysyn or Tyfyn, Richard, of Aure, yeoman 2
3595900 1866352 1866352 defendant Aure John yeoman 588884 588884 Aure, John, of Aure, yeoman 1
3595901 1866352 1866352 defendant Tysyn Richard yeoman 588884 588884 Tysyn, Richard, of Aure, yeoman 2
3611586 1871290 1871290 defendant Aure John husbandman 588884 588884 Aure, John, of Aure, husbandman 0
3611587 1871290 1871290 defendant Hopkyns William husbandman 588884 588884 Hopkyns, William, of Aure, husbandman 1
3611589 1871290 1871290 defendant Aure Henry laborer 588884 588884 Aure, Henry, of Aure, laborer 3
3611590 1871290 1871290 defendant Aure Christopher laborer 588884 588884 Aure, Christopher, of Aure, laborer 4
3644880 1908810 1908810 defendant Hopkyns Walter yeoman 588884 588884 Hopkyns, Walter, of Aure, yeoman 0
3644881 1908810 1908810 defendant Hopkyns Edmund yeoman 588884 588884 Hopkyns, Edmund, of Aure, yeoman 1
3771967 1948925 1948925 defendant Pyrton Thomas laborer 588884 588884 Pyrton, Thomas, of Aure, laborer 1
3783586 1952624 1952624 defendant A Dene William yeoman 588884 588884 A Dene, William, of Aure, yeoman 0
3783587 1952624 1952624 defendant Reynolle William yeoman 588884 588884 Reynolle, William, of Aure, yeoman 1
4228560 2105472 2105472 defendant Tyler William husbandman 588884 588884 Tyler, William, of Aure, husbandman 0
4557621 2218317 2218317 defendant Smyth Thomas   588884 588884 Smyth, Thomas, of Aure 0
4619153 2236986 2236986 defendant Walker William   588884 588884 Walker, William, of Aure 0
4725834 2273367 2273367 defendant Steymore Roger husbandman 588884 588884 Steymore, Roger, of Aure, husbandman 0
4778819 2289348 2289348 defendant Heydon John yeoman 588884 588884 Heydon, John, of Aure, yeoman 4
4899898 2326605 2326605 defendant Netherton Richard gent 588884 588884 Netherton, Richard, of Aure, gent 1
4899899 2326605 2326605 defendant Box Thomas husbandman 588884 588884 Box, Thomas, of Aure, husbandman 2
4950335 2342070 2342070 defendant Cade Thomas husbandman 588884 588884 Cade, Thomas, of Aure, husbandman 0
5024106 2363958 2363958 defendant de Aure Thomas husbandman 588884 588884 de Aure, Thomas, of Aure, husbandman 0
5029668 2365547 2365547 defendant Verneye John yeoman 588884 588884 Verneye, John, of Aure, yeoman 0
5064464 2375911 2375911 defendant Addurley John chaplain 588884 588884 Addurley, John, of Aure, chaplain 1
5066698 2376568 2376568 defendant Tyfyn or Tysyn John, senior yeoman 588884 588884 Tyfyn or Tysyn, John, senior, of Aure, yeoman 0
5066700 2376568 2376568 defendant Lawys William husbandman 588884 588884 Lawys, William, of Aure, husbandman 2
5066702 2376569 2376569 defendant Tysyn or Tyfyn John, senior yeoman 588884 588884 Tysyn or Tyfyn, John, senior, of Aure, yeoman 0
5066704 2376569 2376569 defendant Lawys William husbandman 588884 588884 Lawys, William, of Aure, husbandman 2
5091439 2383881 2383881 defendant Tysyn or Tyfyn John, senior yeoman 588884 588884 Tysyn or Tyfyn, John, senior, of Aure, yeoman 0
5091441 2383881 2383881 defendant Lawyn William husbandman 588884 588884 Lawyn, William, of Aure, husbandman 2
5156416 2403029 2403029 defendant Tysyn John, sen yeoman 588884 588884 Tysyn, John, sen, of Aure, yeoman 0
5156418 2403029 2403029 defendant Lawys William husbandman 588884 588884 Lawys, William, of Aure, husbandman 2
5192258 2413472 2413472 defendant Tysyn John, sen yeoman 588884 588884 Tysyn, John, sen, of Aure, yeoman 0
5192260 2413472 2413472 defendant Lawys William husbandman 588884 588884 Lawys, William, of Aure, husbandman 2
5336769 2456063 2456063 defendant Trepet Thomas husbandman 588884 588884 Trepet, Thomas, of Aure, husbandman 4
5336770 2456063 2456063 defendant Trepet Robert husbandman 588884 588884 Trepet, Robert, of Aure, husbandman 5
5526286 2512801 2512801 defendant Tripet Robert husbandman 588884 588884 Tripet, Robert, of Aure, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);