names

17 rows where place_id = 593070

✎ 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
3610317 1870883 1870883 defendant Colyn Richard laborer 593070 593070 Colyn, Richard, of Tillyngham, laborer 0
3855571 1975385 1975385 defendant Thymbill Gregory yeoman 593070 593070 Thymbill, Gregory, of Tillyngham, yeoman 1
4413856 2169232 2169232 defendant Chyngelford John   593070 593070 Chyngelford, John, of Tillyngham 0
4435552 2175879 2175879 defendant More Thomas atte   593070 593070 More, Thomas atte, of Tillyngham 0
4435555 2175880 2175880 defendant atte More Thomas   593070 593070 atte More, Thomas, of Tillyngham 0
4478647 2193985 2193985 defendant Camsye Richard   593070 593070 Camsye, Richard, of Tillyngham 0
4499744 2200553 2200553 plaintiff Herle Adam   593070 593070 Herle, Adam, of Tillyngham 0
4719924 2271575 2271575 defendant Dote Walter weaver 593070 593070 Dote, Walter, of Tillyngham, weaver 0
4787372 2292120 2292120 plaintiff Midlyng Adam   593070 593070 Midlyng, Adam, of Tillyngham 2
4787378 2292121 2292121 plaintiff Midlyng Adam   593070 593070 Midlyng, Adam, of Tillyngham 2
4818637 2301910 2301910 defendant Midlyng Adam gent 593070 593070 Midlyng, Adam, of Tillyngham, gent 0
4818638 2301910 2301910 defendant Midlyng Richard gent 593070 593070 Midlyng, Richard, of Tillyngham, gent 1
5023553 2363798 2363798 defendant Mynton Thomas husbandman 593070 593070 Mynton, Thomas, of Tillyngham, husbandman 1
5055150 2373115 2373115 defendant Midlyng Adam gent 593070 593070 Midlyng, Adam, of Tillyngham, gent 0
5232503 2425086 2425086 defendant Poort William husbandman 593070 593070 Poort, William, of Tillyngham, husbandman 0
5616432 2548936 2548936 defendant Taven John, senior   593070 593070 Taven, John, senior, of Tillyngham 0
5617671 2549357 2549357 defendant Camsyde John   593070 593070 Camsyde, John, of Tillyngham 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);