names

18 rows where place_id = 614202

✎ 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
3702426 1927018 1927018 defendant Hals John husbandman 614202 614202 Hals, John, of Plymtre, husbandman 1
3861202 1977222 1977222 defendant Copleston Charles esq 614202 614202 Copleston, Charles, of Plymtre, esq 0
3874431 1981677 1981677 defendant Northecott John husbandman 614202 614202 Northecott, John, of Plymtre, husbandman 0
3916228 1995813 1995813 defendant Forde Edward gent 614202 614202 Forde, Edward, of Plymtre, gent 0
3919372 1996811 1996811 defendant Tye Edward husbandman 614202 614202 Tye, Edward, of Plymtre, husbandman 0
3919769 1996951 1996951 defendant Copleston Charles gent 614202 614202 Copleston, Charles, of Plymtre, gent 0
3921212 1997446 1997446 defendant Norden John husbandman 614202 614202 Norden, John, of Plymtre, husbandman 0
3921213 1997446 1997446 defendant Godfrey Edward husbandman 614202 614202 Godfrey, Edward, of Plymtre, husbandman 1
3995744 2023224 2023224 plaintiff Crosse Robert   614202 614202 Crosse, Robert, of Plymtre 0
3995745 2023224 2023224 defendant Pounde John husbandman 614202 614202 Pounde, John, of Plymtre, husbandman 0
3995746 2023225 2023225 plaintiff Crosse Robert husbandman 614202 614202 Crosse, Robert, of Plymtre, husbandman 0
4055277 2044286 2044286 defendant Souckley Augustine esq 614202 614202 Souckley, Augustine, of Plymtre, or of Woodbere Devon, esq 0
4814375 2300605 2300605 defendant Halcat John husbandman 614202 614202 Halcat, John, of Plymtre, husbandman 1
4949363 2341787 2341787 defendant Forde John husbandman 614202 614202 Forde, John, of Plymtre, husbandman 1
5108904 2389024 2389024 defendant Oton Reginald husbandman 614202 614202 Oton, Reginald, of Plymtre, husbandman 0
5329495 2453887 2453887 defendant Smort Richard clerk 614202 614202 Smort, Richard, of Plymtre, clerk 0
5329496 2453887 2453887 defendant Trenchard Richard husbandman 614202 614202 Trenchard, Richard, of Plymtre, husbandman 1
5378511 2468865 2468865 defendant Oton John husbandman 614202 614202 Oton, John, of Plymtre, husbandman 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);