names

15 rows where place_id = 677309

✎ 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
4026357 2034069 2034069 defendant Burton John husbandman 677309 677309 Burton, John, of Letheringsett, husbandman 1
4028303 2034777 2034777 defendant Heathe John miller 677309 677309 Heathe, John, of Letheringsett, miller 0
4032161 2036172 2036172 plaintiff Fytt Thomas yeoman 677309 677309 Fytt, Thomas, of Letheringsett, yeoman 0
4193411 2093262 2093262 defendant Jary William tanner 677309 677309 Jary, William, of Letheringsett, tanner 0
4209595 2098906 2098906 defendant Michell William glover 677309 677309 Michell, William, of Letheringsett, glover 3
4216927 2101413 2101413 defendant Jarye William yeoman 677309 677309 Jarye, William, of Letheringsett, yeoman 2
4227550 2105122 2105122 defendant Buckenham John miller 677309 677309 Buckenham, John, of Letheringsett, miller 1
4227552 2105122 2105122 defendant Freman Geoffrey   677309 677309 Freman, Geoffrey, of Letheringsett, mason 3
4243134 2110695 2110695 defendant Jary William yeoman 677309 677309 Jary, William, of Letheringsett, yeoman 2
4255178 2114718 2114718 defendant Brigges George gent 677309 677309 Brigges, George, of Letheringsett, gent 2
4261474 2116802 2116802 defendant Elward Robert   677309 677309 Elward, Robert, of Letheringsett, laborer, lime burner 0
4261475 2116802 2116802 defendant Jarey Thomas husbandman 677309 677309 Jarey, Thomas, of Letheringsett, husbandman 1
4273644 2120732 2120732 defendant Alburgh George yeoman 677309 677309 Alburgh, George, of Letheringsett, yeoman 0
4283234 2124039 2124039 defendant Ussher Richard miller 677309 677309 Ussher, Richard, of Letheringsett, miller 0
4319960 2137087 2137087 defendant Jarye Thomas husbandman 677309 677309 Jarye, Thomas, of Letheringsett, 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);