names

12 rows where place_id = 588391

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594334 1865860 1865860 defendant Mounteyn Richard esq 588391 588391 Mounteyn, Richard, of Snetysham, Norf, esq 0
3594337 1865861 1865861 defendant Mounteyn Richard esq 588391 588391 Mounteyn, Richard, of Snetysham, Norf, esq 0
3694212 1924391 1924391 defendant Russell Henry gent 588391 588391 Russell, Henry, of Snetysham, Norf, gent 10
5255989 2431997 2431997 defendant Mannyng Thomas husbandman 588391 588391 Mannyng, Thomas, of Snetysham, Norf, husbandman 0
5255991 2431998 2431998 defendant Mannyng Thomas husbandman 588391 588391 Mannyng, Thomas, of Snetysham, Norf, husbandman 0
5315926 2449838 2449838 defendant Walsham Thomas husbandman 588391 588391 Walsham, Thomas, of Snetysham, Norf, husbandman 3
5408870 2477612 2477612 defendant Dowesyng Nicholas gent & notary 588391 588391 Dowesyng, Nicholas, of Snetysham, Norf, gent & notary 4
5419275 2480691 2480691 defendant Lowe John yeoman 588391 588391 Lowe, John, of Snetysham, Norf, yeoman 4
5422207 2481589 2481589 defendant Dowesyng Nicholas gent 588391 588391 Dowesyng, Nicholas, of Snetysham, Norf, gent 4
5437514 2486159 2486159 defendant Lowe John yeoman 588391 588391 Lowe, John, of Snetysham, Norf, yeoman 4
5437520 2486160 2486160 defendant Lowe John yeoman 588391 588391 Lowe, John, of Snetysham, Norf, yeoman 4
5441816 2487480 2487480 defendant Dowesyng Nicholas gent & notary 588391 588391 Dowesyng, Nicholas, of Snetysham, Norf, gent & notary 4

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