names

12 rows where place_id = 699018

✎ 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
4126932 2069925 2069925 defendant Whyte John husbandman 699018 699018 Whyte, John, of Oterhampton, husbandman 2
4150525 2078316 2078316 defendant Whyte John husbandman 699018 699018 Whyte, John, of Oterhampton, husbandman 2
4491526 2198036 2198036 plaintiff Willyng Hugh   699018 699018 Willyng, Hugh, of Oterhampton, parson 0
4812944 2300161 2300161 defendant Hatherigge Thomas husbandman 699018 699018 Hatherigge, Thomas, of Oterhampton, husbandman 1
5209852 2418614 2418614 defendant Nicolas John laborer 699018 699018 Nicolas, John, of Oterhampton, laborer 10
5209853 2418614 2418614 defendant Walsheman Thomas husbandman 699018 699018 Walsheman, Thomas, of Oterhampton, husbandman 11
5490989 2502205 2502205 defendant Pylcorne John husbandman 699018 699018 Pylcorne, John, of Oterhampton, husbandman 1
5584984 2530380 2530380 defendant Smyth John husbandman 699018 699018 Smyth, John, of Oterhampton, husbandman 1
5587302 2531054 2531054 defendant Peyntour John husbandman 699018 699018 Peyntour, John, of Oterhampton, husbandman 0
5587303 2531054 2531054 defendant Smyth John husbandman 699018 699018 Smyth, John, of Oterhampton, husbandman 1
5633841 2554578 2554578 defendant Gelhampton William husbandman 699018 699018 Gelhampton, William, of Oterhampton, husbandman 0
5633849 2554579 2554579 defendant Gelhampton William husbandman 699018 699018 Gelhampton, William, of Oterhampton, 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);