names

23 rows where place_id = 597143

✎ 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
3627457 1903443 1903443 defendant Langley John esq 597143 597143 Langley, John, of Sandwyche, Kent, esq 1
3646597 1909340 1909340 defendant Boll Henry beer brewer 597143 597143 Boll, Henry, of Sandwyche, Kent, beer brewer 0
3843769 1971584 1971584 defendant Eliard Edward mercer 597143 597143 Eliard, Edward, of Sandwyche, Kent, mercer 1
3860041 1976855 1976855 defendant Parfoote Richard chapman 597143 597143 Parfoote, Richard, of Sandwyche, Kent, chapman 3
3906338 1992406 1992406 defendant Craske Stephen merchant 597143 597143 Craske, Stephen, of Sandwyche, Kent, merchant 0
3907674 1992858 1992858 plaintiff Peeke Nicholas   597143 597143 Peeke, Nicholas, of Sandwyche, Kent 0
3908417 1993111 1993111 defendant Wodd Lawrence ironmonger 597143 597143 Wodd, Lawrence, of Sandwyche, Kent, ironmonger 1
3908422 1993112 1993112 defendant Wodd Lawrence ironmonger 597143 597143 Wodd, Lawrence, of Sandwyche, Kent, ironmonger 1
3920252 1997110 1997110 plaintiff Mathewe William   597143 597143 Mathewe, William, of Sandwyche, Kent 0
3920772 1997294 1997294 defendant Paule Mark yeoman 597143 597143 Paule, Mark, of Sandwyche, Kent, yeoman 0
3920775 1997295 1997295 defendant Paule Mark yeoman 597143 597143 Paule, Mark, of Sandwyche, Kent, yeoman 0
3920778 1997296 1997296 defendant Paule Mark yeoman 597143 597143 Paule, Mark, of Sandwyche, Kent, yeoman 0
3935798 2002280 2002280 defendant Gowre Thomas clothier 597143 597143 Gowre, Thomas, of Sandwyche, Kent, clothier 0
3941826 2004279 2004279 defendant Warde Joan   597143 597143 (Warde, Joan, of Sandwyche, Kent, widow, & wife of Testator 1
3946074 2005702 2005702 defendant Alldy Adam gent 597143 597143 Alldy, Adam, of Sandwyche, Kent, or of Tyxson, Rutland, gent 1
3981206 2018039 2018039 plaintiff Pyham John yeoman 597143 597143 Pyham, John, of Sandwyche, Kent, yeoman 0
4059539 2045805 2045805 defendant Evers William merchant 597143 597143 Evers, William, of Sandwyche, Kent, merchant 0
4131872 2071712 2071712 defendant Pynnocke Jerome chapman 597143 597143 Pynnocke, Jerome, of Sandwyche, Kent, chapman 2
4153705 2079392 2079392 defendant Lee Robert gent 597143 597143 Lee, Robert, of Sandwyche, Kent, gent 0
4228554 2105469 2105469 defendant Aldey Charles gent 597143 597143 Aldey, Charles, of Sandwyche, Kent, gent 0
4327951 2139671 2139671 defendant Woode Richard innkeeper 597143 597143 Woode, Richard, of Sandwyche, Kent, innkeeper 0
4956146 2343799 2343799 plaintiff Taverner John   597143 597143 Taverner, John, of Sandwyche, Kent, "shepman" 2
5254701 2431585 2431585 defendant Boucher Thomas mariner 597143 597143 Boucher, Thomas, of Sandwyche, Kent, mariner 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);