names

24 rows where place_id = 649177

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3661905 1914013 1914013 defendant Mauncell Rhys esq 649177 649177 Mauncell, Rhys, of Cardiff & Westminster, esq 1
3905436 1992087 1992087 defendant Wylcokys Robert clerk 649177 649177 Wylcokys, Robert, of Cardiff, clerk 1
3977424 2016676 2016676 plaintiff Lewis Howell tailor 649177 649177 Lewis, Howell, of Cardiff, tailor 0
4044743 2040567 2040567 plaintiff Robert David merchant 649177 649177 Robert, David, of Cardiff, merchant 0
4044752 2040571 2040571 plaintiff Robert John Thomas mercer 649177 649177 Robert, John Thomas, of Cardiff, mercer 0
4053477 2043619 2043619 plaintiff ap Jevan Griffin tailor 649177 649177 ap Jevan, Griffin, of Cardiff, tailor 0
4064964 2047754 2047754 defendant Highwaye Thomas yeoman 649177 649177 Highwaye, Thomas, of Cardiff, yeoman 2
4090761 2056984 2056984 defendant David William cordwainer 649177 649177 David, William, of Cardiff, cordwainer 1
4096817 2059194 2059194 defendant Awler Thomas tanner 649177 649177 Awler, Thomas, of Cardiff, tanner 1
4107928 2063109 2063109 defendant ap Jevan John Robert merchant 649177 649177 ap Jevan, John Robert, of Cardiff, merchant 1
4171840 2085610 2085610 defendant ap Jevan Griffin yeoman 649177 649177 ap Jevan, Griffin, of Cardiff, yeoman 1
4187181 2091009 2091009 defendant Gebon Llewelin (legal representative) 649177 649177 Gebon, Llewelin, of Cardiff, administrator of 0
4207811 2098290 2098290 defendant ap Evan John Robert gent 649177 649177 ap Evan, John Robert, of Cardiff, gent 3
4304339 2131655 2131655 defendant Hick Alice daughter of Agnes 649177 649177 Hick, Alice, of Cardiff, spinster, daughter of Agnes 1
4363129 2151877 2151877 defendant Okewell Anthony yeoman 649177 649177 Okewell, Anthony, of Cardiff, yeoman 1
4363683 2152079 2152079 defendant Williams Morgan yeoman 649177 649177 Williams, Morgan, of Cardiff, yeoman 1
4379070 2157598 2157598 defendant Carles Richard shoemaker 649177 649177 Carles, Richard, of Cardiff, shoemaker 1
4395212 2162987 2162987 defendant Gascoigne William yeoman 649177 649177 Gascoigne, William, of Cardiff, yeoman 1
4395213 2162987 2162987 defendant Careles Richard cordwainer 649177 649177 Careles, Richard, of Cardiff, cordwainer 2
5051042 2371919 2371919 defendant Tony Thomas merchant 649177 649177 Tony, Thomas, of Cardiff, merchant 2
5051043 2371919 2371919 defendant Apreve Richard merchant 649177 649177 Apreve, Richard, of Cardiff, merchant 3
5141755 2398701 2398701 defendant Lewys David tailor & burgess 649177 649177 Lewys, David, of Cardiff, tailor & burgess 1
5176736 2408880 2408880 defendant Lewys David tailor & burgess 649177 649177 Lewys, David, of Cardiff, tailor & burgess 1
5199051 2415473 2415473 defendant Lewys David tailor & burgess 649177 649177 Lewys, David, of Cardiff, tailor & burgess 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);