names

24 rows where place_id = 667745

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3986277 2019841 2019841 defendant ap Watkyn Thomas yeoman 667745 667745 ap Watkyn, Thomas, of Norton, Radnor, yeoman 1
3999728 2024663 2024663 defendant Morrys John clerk 667745 667745 Morrys, John, of Norton, Radnor, clerk 0
4005934 2026896 2026896 defendant Watkyns Thomas gent 667745 667745 Watkyns, Thomas, of Norton, Radnor, gent 0
4005938 2026897 2026897 defendant Watkyns Thomas gent 667745 667745 Watkyns, Thomas, of Norton, Radnor, gent 0
4043847 2040250 2040250 defendant Watkyns Thomas gent 667745 667745 Watkyns, Thomas, of Norton, Radnor, gent 0
4043851 2040251 2040251 defendant Watkyns Thomas gent 667745 667745 Watkyns, Thomas, of Norton, Radnor, gent 0
4050756 2042707 2042707 defendant Ympton William yeoman 667745 667745 Ympton, William, of Norton, Radnor, yeoman 1
4050760 2042708 2042708 defendant Ympton William yeoman 667745 667745 Ympton, William, of Norton, Radnor, yeoman 1
4051370 2042910 2042910 defendant ap Watkyn Jevan gent 667745 667745 ap Watkyn, Jevan, of Norton, Radnor, gent 0
4072673 2050526 2050526 defendant Don William, junior gent 667745 667745 Don, William, junior, of Norton, Radnor, gent 7
4077276 2052155 2052155 defendant Donne or Doune William, junior husbandman 667745 667745 Donne or Doune, William, junior, of Norton, Radnor, husbandman 0
4102906 2061331 2061331 defendant ap Howell Roger clerk 667745 667745 ap Howell, Roger, of Norton, Radnor, clerk 4
4106616 2062657 2062657 defendant Don William yeoman 667745 667745 Don, William, of Norton, Radnor, yeoman 2
4158491 2081041 2081041 defendant Partridge Thomas yeoman 667745 667745 Partridge, Thomas, of Norton, Radnor, yeoman 0
4245091 2111343 2111343 defendant Partridge Miles yeoman 667745 667745 Partridge, Miles, of Norton, Radnor, yeoman 0
4297442 2129190 2129190 defendant Ireland John yeoman 667745 667745 Ireland, John, of Norton, Radnor, yeoman 1
4301861 2130775 2130775 defendant Ireland John yeoman 667745 667745 Ireland, John, of Norton, Radnor, yeoman 0
4316836 2136006 2136006 defendant Estopp Richard yeoman 667745 667745 Estopp, Richard, of Norton, Radnor, yeoman 3
4329855 2140286 2140286 defendant Estoppe Richard yeoman 667745 667745 Estoppe, Richard, of Norton, Radnor, yeoman 3
4329897 2140298 2140298 defendant Weaver Richard weaver 667745 667745 Weaver, Richard, of Norton, Radnor, weaver 3
4330366 2140458 2140458 defendant Ireland John yeoman 667745 667745 Ireland, John, of Norton, Radnor, yeoman 1
4402811 2165525 2165525 defendant Bache Lewis yeoman 667745 667745 Bache, Lewis, of Norton, Radnor, yeoman 0
4406174 2166630 2166630 defendant Goughe alias Watkyns Thomas yeoman 667745 667745 Goughe alias Watkyns, Thomas, of Norton, Radnor, yeoman 0
4406175 2166630 2166630 defendant Clymsonne Peter husbandman 667745 667745 Clymsonne, Peter, of Norton, Radnor, 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);