names

10 rows where place_id = 630394

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3794122 1956030 1956030 defendant Godard Thomas husbandman 630394 630394 Godard, Thomas, of Cleyhydon, husbandman 0
3863150 1977878 1977878 defendant Aleyn Richard clerk 630394 630394 Aleyn, Richard, of Cleyhydon, clerk 1
3875266 1981967 1981967 defendant Alyn Richard clerk 630394 630394 Alyn, Richard, of Cleyhydon, clerk 0
3922240 1997748 1997748 defendant Browne John husbandman 630394 630394 Browne, John, of Cleyhydon, husbandman 0
4000948 2025109 2025109 defendant Browne Henry, junior yeoman 630394 630394 Browne, Henry, junior, of Cleyhydon, yeoman 0
4016575 2030633 2030633 defendant Austyn John husbandman 630394 630394 Austyn, John, of Cleyhydon, husbandman 0
4016576 2030633 2030633 defendant Sherbroke Richard husbandman 630394 630394 Sherbroke, Richard, of Cleyhydon, husbandman 1
4150714 2078390 2078390 defendant Whytehorne John husbandman 630394 630394 Whytehorne, John, of Cleyhydon, husbandman 0
4199983 2095543 2095543 defendant Pytcher Robert   630394 630394 Pytcher Robert, of Cleyhydon 1
4199984 2095543 2095543 defendant Awstrynge John husbandman 630394 630394 Awstrynge, John, of Cleyhydon, husbandman 2

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