names

15 rows where place_id = 594385

✎ 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
3615885 1872607 1872607 plaintiff Coveney William yeoman 594385 594385 Coveney, William, of West Farley, yeoman 0
3717868 1931890 1931890 defendant Eden William gent 594385 594385 Eden, William, of West Farley, gent 0
3717869 1931890 1931890 defendant Eden Robert gent 594385 594385 Eden, Robert, of West Farley, gent 1
3717870 1931890 1931890 defendant Eden Jasper gent 594385 594385 Eden, Jasper, of West Farley, gent 2
3726018 1934412 1934412 defendant Eden William gent 594385 594385 Eden, William, of West Farley, gent 0
3726019 1934412 1934412 defendant Eden Robert gent 594385 594385 Eden, Robert, of West Farley, gent 1
3726020 1934412 1934412 defendant Eden Jasper gent 594385 594385 Eden, Jasper, of West Farley, gent 2
3764649 1946605 1946605 defendant Coveney John yeoman 594385 594385 Coveney, John, of West Farley, yeoman 0
3766788 1947275 1947275 defendant Coveney John yeoman 594385 594385 Coveney, John, of West Farley, yeoman 0
3993948 2022586 2022586 defendant Jenner John miller 594385 594385 Jenner, John, of West Farley, miller 0
4401999 2165261 2165261 defendant Waters John tailor 594385 594385 Waters, John, of West Farley, tailor 1
5106130 2388230 2388230 plaintiff Coveney Richard yeoman 594385 594385 Coveney, Richard, of West Farley, yeoman 0
5318392 2450595 2450595 defendant Borden Thomas husbandman 594385 594385 Borden, Thomas, of West Farley, husbandman 2
5503408 2505974 2505974 defendant Buntflowere Thomas husbandman 594385 594385 Buntflowere, Thomas, of West Farley, husbandman 0
5561659 2523398 2523398 plaintiff Vidian Richard   594385 594385 Vidian, Richard, of West Farley 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);