names

20 rows where place_id = 606072

✎ 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
3663927 1914658 1914658 defendant Clerk Richard husbandman 606072 606072 Clerk, Richard, of Copford, husbandman 0
3826610 1966170 1966170 defendant Plomton George yeoman 606072 606072 Plomton, George, of Copford, yeoman 4
3874098 1981559 1981559 defendant Stowe John husbandman 606072 606072 Stowe, John, of Copford, husbandman 0
3909592 1993513 1993513 defendant Stowe John husbandman 606072 606072 Stowe, John, of Copford, husbandman 0
4038170 2038293 2038293 defendant Hayward Thomas husbandman 606072 606072 Hayward, Thomas, of Copford, husbandman 0
4038195 2038296 2038296 defendant Hayward Thomas husbandman 606072 606072 Hayward, Thomas, of Copford, husbandman 0
4276255 2121637 2121637 defendant Stanton Edward gent 606072 606072 Stanton, Edward, of Copford, gent 1
4280827 2123199 2123199 defendant Stanton Edward gent 606072 606072 Stanton, Edward, of Copford, gent 0
4484999 2196010 2196010 plaintiff Prest Richard   606072 606072 Prest, Richard, of Copford 0
4485000 2196010 2196010 defendant Boleyne Roger   606072 606072 Boleyne, Roger, of Copford 0
4510928 2203873 2203873 defendant Stubbecroft John chaplain 606072 606072 Stubbecroft, John, of Copford, chaplain 1
4643288 2244142 2244142 defendant Sumpter John   606072 606072 Sumpter, John, of Copford 4
4724991 2273111 2273111 defendant White Thomas laborer 606072 606072 White, Thomas, of Copford, laborer 1
4973050 2348872 2348872 defendant Peytevyn John   606072 606072 Peytevyn, John, of Copford, wheelwright 0
4998966 2356571 2356571 defendant Danyon Henry husbandman 606072 606072 Danyon, Henry, of Copford, husbandman 0
4999008 2356584 2356584 defendant Petevyn John   606072 606072 Petevyn, John, of Copford, wheel wright 0
5012997 2360635 2360635 defendant Stowe Thomas husbandman 606072 606072 Stowe, Thomas, of Copford, husbandman 0
5145393 2399798 2399798 defendant Noth Richard husbandman 606072 606072 Noth, Richard, of Copford, husbandman 0
5165856 2405756 2405756 defendant Noth Richard husbandman 606072 606072 Noth, Richard, of Copford, husbandman 0
5630646 2553590 2553590 defendant Frenche William   606072 606072 Frenche, William, of Copford, wheelwright 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);