names

8 rows where place_id = 592048

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606392 1869666 1869666 defendant Braunche Richard husbandman 592048 592048 Braunche, Richard, of Brokdyssh, husbandman 1
3776855 1950500 1950500 defendant Gryce William gent 592048 592048 Gryce, William, of Brokdyssh, gent 0
3776856 1950500 1950500 defendant Gryce Anthony gent 592048 592048 Gryce, Anthony, of Brokdyssh, gent 1
5007831 2359182 2359182 defendant Pope John butcher 592048 592048 Pope, John, of Brokdyssh, butcher 4
5155880 2402881 2402881 defendant Colell John yeoman 592048 592048 Colell, John, of Brokdyssh, yeoman 3
5160641 2404208 2404208 defendant Grys William gent 592048 592048 Grys, William, of Brokdyssh, gent 0
5223724 2422623 2422623 defendant Wytham John husbandman 592048 592048 Wytham, John, of Brokdyssh, husbandman 4
5223730 2422624 2422624 defendant Wytham John husbandman 592048 592048 Wytham, John, of Brokdyssh, husbandman 4

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);