names

26 rows where place_id = 653640

✎ 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
3929306 2000147 2000147 defendant Henrye Thomas chapman 653640 653640 Henrye, Thomas, of Norwich, Norf, chapman 1
3931056 2000706 2000706 defendant Humfrey Robert gent 653640 653640 Humfrey, Robert, of Norwich, Norf, gent 0
3939419 2003488 2003488 defendant Benyamyn John draper 653640 653640 Benyamyn, John, of Norwich, Norf, draper 0
4676056 2258123 2258123 defendant Virly John chaplain 653640 653640 Virly, John, of Norwich, Norf, chaplain 0
4676059 2258124 2258124 defendant Virly John chaplain 653640 653640 Virly, John, of Norwich, Norf, chaplain 0
4676512 2258270 2258270 defendant Deuyrose Richard stainer 653640 653640 Deuyrose, Richard, of Norwich, Norf, stainer 0
4689039 2262130 2262130 defendant Gerebrigge Thomas   653640 653640 Gerebrigge, Thomas, of Norwich, Norf, knight 0
4712786 2269312 2269312 defendant Sturmeer Henry gent 653640 653640 Sturmeer, Henry, of Norwich, Norf, gent 3
4712815 2269317 2269317 defendant Sturmer Henry gent 653640 653640 Sturmer, Henry, of Norwich, Norf, gent 3
4715426 2270161 2270161 defendant Eton William gent 653640 653640 Eton, William, of Norwich, Norf, gent 1
4736174 2276449 2276449 defendant Wymeston John blexster or bleacher of cloth 653640 653640 Wymeston, John, of Norwich, Norf, blexster or bleacher of cloth 2
4736182 2276450 2276450 defendant Wymeston John bleacher of cloth 653640 653640 Wymeston, John, of Norwich, Norf, bleacher of cloth 4
4812948 2300162 2300162 defendant Clether Thomas mercer 653640 653640 Clether, Thomas, of Norwich, Norf, mercer 0
4814229 2300554 2300554 defendant Wygenhale Stephen   653640 653640 Wygenhale, Stephen, of Norwich, Norf, furbour 0
4822104 2302992 2302992 defendant Baldewyn John loder 653640 653640 Baldewyn, John, of Norwich, Norf, loder 0
4912339 2330361 2330361 defendant Burnegele John esq 653640 653640 Burnegele, John, of Norwich, Norf, esq 0
5003180 2357832 2357832 defendant Hoghton Robert gent 653640 653640 Hoghton, Robert, of norwich, Norf, gent 2
5008078 2359248 2359248 defendant Sturmere Henry gent 653640 653640 Sturmere, Henry, of Norwich, Norf, gent 1
5045575 2370307 2370307 defendant Norwich William, junior gent 653640 653640 Norwich, William, junior, of Norwich, Norf, gent 1
5130983 2395544 2395544 defendant Hermer Robert   653640 653640 Hermer, Robert, of Norwich, Norf, tallow chandler 2
5147947 2400544 2400544 defendant Sturmer Richard chaplain 653640 653640 Sturmer, Richard, of Norwich, Norf, chaplain 0
5147950 2400545 2400545 defendant Sturmer Richard chaplain 653640 653640 Sturmer, Richard, of Norwich, Norf, chaplain 0
5182884 2410743 2410743 defendant Sturmer Richard chaplain 653640 653640 Sturmer, Richard, of Norwich, Norf, chaplain 0
5268191 2435821 2435821 defendant Staley Edmund   653640 653640 Staley, Edmund, of Norwich, Norf, tallow chandler or taloughlough chaundeler 0
5415017 2479425 2479425 defendant Roos Richard esq 653640 653640 Roos, Richard, of Norwich, Norf, esq 0
5431065 2484229 2484229 defendant Roos Richard esq 653640 653640 Roos, Richard, of Norwich, Norf, esq 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);