names

11 rows where place_id = 730221

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4212543 2099927 2099927 defendant Forest John yeoman 730221 730221 Forest, John, of Leighe, Wymborne Mynster, yeoman 0
4257717 2115555 2115555 defendant Conwey Richard yeoman 730221 730221 Conwey, Richard, of Leighe, or of Oversole, Staffs, yeoman 0
4287225 2125489 2125489 defendant Smythe alias Crispe William husbandman 730221 730221 Smythe alias Crispe, William, of Leighe, husbandman 0
4301345 2130589 2130589 defendant Taylor George Soms, yeoman, servant of Ursula Sidenham, of Leighe, widow 730221 730221 Taylor George, of Leighe, Soms, yeoman, servant of Ursula Sidenham, of Leighe, widow 2
4305750 2132149 2132149 defendant Cottington Edward gent 730221 730221 Cottington, Edward, of Leighe, gent 0
4305751 2132149 2132149 defendant Raynes John gent 730221 730221 Raynes, John, of Leighe, gent 1
4319581 2136959 2136959 defendant Foster Michael gent 730221 730221 Foster, Michael, of Leighe, gent 0
4376742 2156750 2156750 defendant Cruste Christopher yeoman 730221 730221 Cruste, Christopher, of Leighe, yeoman 0
4390376 2161404 2161404 defendant Cruse Christopher yeoman 730221 730221 Cruse, Christopher, of Leighe, yeoman 0
4396399 2163370 2163370 defendant Kinge Richard yeoman 730221 730221 Kinge, Richard, of Leighe, Wymborne, Minster, yeoman 0
4405740 2166489 2166489 defendant Bodnam Edward husbandman 730221 730221 Bodnam, Edward, of Leighe, husbandman 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);