names

16 rows where place_id = 618012

✎ 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
3722420 1933272 1933272 defendant Sotyll Robert gent 618012 618012 Sotyll, Robert, of North Dighton, gent 0
3939246 2003430 2003430 defendant Duffeld Robert husbandman 618012 618012 Duffeld, Robert, of North Dighton, husbandman 0
4166279 2083700 2083700 defendant Snawdon Christopher smith 618012 618012 Snawdon, Christopher, of North Dighton, smith 0
4269982 2119543 2119543 defendant Sutton Arthur gent 618012 618012 Sutton, Arthur, of North Dighton, gent 2
4988508 2353522 2353522 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
4988509 2353522 2353522 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
4988510 2353522 2353522 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
4988511 2353522 2353522 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11
4995475 2355488 2355488 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
4995476 2355488 2355488 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
4995477 2355488 2355488 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
4995478 2355488 2355488 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11
5005502 2358511 2358511 defendant Smyth John smith 618012 618012 Smyth, John, of North Dighton, smith 8
5005503 2358511 2358511 defendant Smyth Richard husbandman 618012 618012 Smyth, Richard, of North Dighton, husbandman 9
5005504 2358511 2358511 defendant Wright John husbandman 618012 618012 Wright, John, of North Dighton, husbandman 10
5005505 2358511 2358511 defendant Jenaker William husbandman 618012 618012 Jenaker, William, of North Dighton, husbandman 11

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