names

24 rows where place_id = 631607

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3801601 1958400 1958400 defendant Wescott Richard husbandman 631607 631607 Wescott, Richard, of Braye, husbandman 1
4052022 2043148 2043148 plaintiff Wybarne Thomas gent 631607 631607 Wybarne, Thomas, of Braye, gent 0
4076718 2051960 2051960 plaintiff Slye William yeoman 631607 631607 Slye, William, of Braye, yeoman 0
4078828 2052725 2052725 defendant Avelyn Joyce widow 631607 631607 Avelyn, Joyce, of Braye, widow 0
4195678 2094043 2094043 defendant Sharpe John yeoman 631607 631607 Sharpe, John, of Braye, yeoman 1
4195679 2094043 2094043 defendant Martyn Henry yeoman 631607 631607 Martyn, Henry, of Braye, yeoman 2
4305929 2132212 2132212 defendant Wescott John yeoman 631607 631607 Wescott, John, of Braye, yeoman 0
4305930 2132212 2132212 defendant Moore Richard yeoman 631607 631607 Moore, Richard, of Braye, yeoman 1
4305932 2132212 2132212 defendant Buck John miller 631607 631607 Buck, John, of Braye, miller 3
4392093 2161982 2161982 defendant Haythorne Thomas yeoman 631607 631607 Haythorne, Thomas, of Braye, yeoman 3
4415802 2169832 2169832 plaintiff Jordan William   631607 631607 Jordan, William, of Braye, son of William 0
4597916 2230606 2230606 plaintiff Smyth Peter   631607 631607 Smyth, Peter, of Braye 0
4653004 2246871 2246871 defendant Wade Stephen husbandman 631607 631607 Wade, Stephen, of Braye, husbandman 0
4669274 2256098 2256098 defendant Wade Stephen butcher 631607 631607 Wade, Stephen, of Braye, butcher 0
4679635 2259248 2259248 defendant Hurleye Henry husbandman 631607 631607 Hurleye, Henry, of Braye, husbandman 1
4682193 2260053 2260053 defendant Martyn Richard skinner & gent 631607 631607 Martyn, Richard, of Braye, skinner & gent 0
4725129 2273157 2273157 plaintiff Foxle Thomas esq 631607 631607 Foxle, Thomas, of Braye, esq 0
4725756 2273343 2273343 plaintiff Gilmyn Peter   631607 631607 Gilmyn, Peter, of Braye 0
4837792 2307754 2307754 defendant Wyldynges Richard husbandman 631607 631607 Wyldynges, Richard, of Braye, husbandman 0
5223341 2422521 2422521 defendant Fowler Robert gent 631607 631607 Fowler, Robert, of Braye, gent 0
5223342 2422521 2422521 defendant Chambour Richard husbandman 631607 631607 Chambour, Richard, of Braye, husbandman 1
5223343 2422521 2422521 defendant West Robert husbandman 631607 631607 West, Robert, of Braye, husbandman 2
5223344 2422521 2422521 defendant Kembere William husbandman 631607 631607 Kembere, William, of Braye, husbandman 3
5245222 2428757 2428757 defendant Hayward Thomas husbandman 631607 631607 Hayward, Thomas, of Braye, 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);