names

22 rows where place_id = 586821

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589734 1864428 1864428 defendant Wylly Richard gent 586821 586821 Wylly, Richard, of Monmouth, March of Wales, gent 0
3608161 1870206 1870206 defendant Morgan Thomas   586821 586821 Morgan, Thomas, of March of Wales, knight 0
3614448 1872168 1872168 plaintiff Morys John yeoman 586821 586821 Morys, John, of March of Wales, yeoman 1
3639211 1907077 1907077 defendant Parys John chapman 586821 586821 Parys, John, of Monmouth, March of Wales, chapman 2
3668248 1916015 1916015 plaintiff ap Rees John   586821 586821 ap Rees, John, of March of Wales 0
3721707 1933072 1933072 defendant Jones Thomas   586821 586821 Jones, Thomas, of Monmouth, March of Wales 0
3729392 1935441 1935441 defendant Harverd Walter esq 586821 586821 Harverd, Walter, of Monmouth, March of Wales, esq 0
3729397 1935442 1935442 defendant Herberd Walter esq 586821 586821 Herberd, Walter, of Monmouth, March of Wales, esq 0
3772447 1949071 1949071 defendant ap Rethergh John yeoman 586821 586821 ap Rethergh, John, of Carmarthen, March of Wales, yeoman 0
3792004 1955350 1955350 defendant Holl Henry gent 586821 586821 Holl, Henry, of Radnor, March of Wales, gent 2
3806823 1960038 1960038 defendant Knyght William husbandman 586821 586821 Knyght, William, of March of Wales, husbandman 2
3831026 1967587 1967587 defendant Parcyvall John   586821 586821 Parcyvall, John, of Monmouth, March of Wales 1
3842135 1971091 1971091 defendant Hoskyns Thomas mercer 586821 586821 Hoskyns, Thomas, of Monmouth, March of Wales, mercer 0
3882690 1984477 1984477 defendant Reynold Fulk mercer 586821 586821 Reynold, Fulk, of Denbigh, March of Wales, mercer 0
5076088 2379347 2379347 defendant Jubbe Thomas chapman 586821 586821 Jubbe, Thomas, of Monmouth, March of Wales, chapman 3
5082406 2381236 2381236 defendant Prese John yeoman 586821 586821 Prese, John, of Brecon, March of Wales, yeoman 2
5082411 2381237 2381237 defendant Prese John yeoman 586821 586821 Prese, John, of Brecon, March of Wales, yeoman 2
5314764 2449456 2449456 defendant Thomas Walter   586821 586821 Thomas, Walter, of Monmouth, March of Wales, gent, constable of Monmouth Castle 0
5498217 2504421 2504421 defendant Litelton William   586821 586821 Litelton, William, of Monmouth, March of Wales, knight 0
5562811 2523712 2523712 defendant Goldsmyth Thomas chapman 586821 586821 Goldsmyth, Thomas, of Monmouth, March of Wales, chapman 3
5562815 2523713 2523713 defendant Percyvale John chapman 586821 586821 Percyvale, John, of Monmouth, March of Wales, chapman 1
5625817 2552022 2552022 defendant Moton Henry esq 586821 586821 Moton, Henry, of Monmouth, March of Wales, esq 0

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);