names

8 rows where place_id = 669313

✎ 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
3992762 2022163 2022163 defendant Johnson William laborer 669313 669313 Johnson, William, of Mongeham, laborer 0
4572441 2222920 2222920 defendant Kendale Richard   669313 669313 Kendale, Richard, of Mongeham 2
4650879 2246279 2246279 defendant Marchall Thomas   669313 669313 Marchall, Thomas, of Mongeham 0
4650886 2246279 2246279 defendant Mundekyn John   669313 669313 Mundekyn, John, of Mongeham 7
4669731 2256235 2256235 defendant Yonge Hugh   669313 669313 Yonge, Hugh, of Mongeham, franklin 2
5044189 2369891 2369891 defendant Ossey John husbandman 669313 669313 Ossey, John, of Mongeham, husbandman 0
5300047 2444979 2444979 defendant Trenham Robert husbandman 669313 669313 Trenham, Robert, of Mongeham, husbandman 0
5322257 2451725 2451725 defendant Trendham John husbandman 669313 669313 Trendham, John, of Mongeham, 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);