names

7 rows where place_id = 597990

✎ 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
3630673 1904421 1904421 defendant Stoughton Thomas husbandman 597990 597990 Stoughton, Thomas, of Roxton, Beds, husbandman 1
4044791 2040589 2040589 plaintiff Robynson John   597990 597990 Robynson, John, of Roxton, Beds 0
4074253 2051090 2051090 defendant Clement John carpenter 597990 597990 Clement, John, of Roxton, Beds, carpenter 0
4120253 2067525 2067525 defendant Clement John yeoman 597990 597990 Clement, John, of Roxton, Beds, yeoman 2
5083670 2381616 2381616 defendant Richard William husbandman 597990 597990 Richard, William, of Roxton, Beds, husbandman 10
5371161 2466566 2466566 defendant Chyler Richard husbandman 597990 597990 Chyler, Richard, of Roxton, Beds, husbandman 3
5371162 2466566 2466566 defendant Rychard Thomas husbandman 597990 597990 Rychard, Thomas, of Roxton, Beds, 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);