names

30 rows where place_id = 586663

✎ 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
3589327 1864304 1864304 defendant Wodehous Robert esq 586663 586663 (Wodehous, Robert, of Kymberley, Norf, esq 5
3661952 1914028 1914028 defendant Woodhous Thomas   586663 586663 Woodhous, Thomas, of Kymberley, Norf, knight 0
3919479 1996847 1996847 defendant Woodhous Thomas esq 586663 586663 Woodhous, Thomas, of Kymberley, Norf, esq 0
3955502 2008993 2008993 defendant Wodhouse Roger esq 586663 586663 Wodhouse, Roger, of Kymberley, Norf, esq 1
3970501 2014279 2014279 defendant Woodhowse Roger gent 586663 586663 Woodhowse, Roger, of Kymberley, Norf, gent 1
3973513 2015306 2015306 defendant Woodhouse Roger esq 586663 586663 Woodhouse, Roger, of Kymberley, Norf, or of Norwich, esq 0
3996624 2023552 2023552 defendant Woodhowse Roger esq 586663 586663 Woodhowse, Roger, of Kymberley, Norf, esq 0
4006774 2027199 2027199 defendant Woodhouse Roger esq 586663 586663 (Woodhouse, Roger, of Kymberley, Norf, esq 1
4031311 2035872 2035872 defendant Woodhowse Roger esq 586663 586663 Woodhowse, Roger, of Kymberley, Norf, esq 0
4069248 2049289 2049289 defendant Godfrey Richard husbandman 586663 586663 Godfrey, Richard, of Kymberley, Norf, husbandman 0
4095934 2058877 2058877 defendant Woodhowse John gent 586663 586663 Woodhowse, John, of Kymberley, Norf, gent 2
4342366 2144603 2144603 defendant Watson William yeoman 586663 586663 Watson, William, of Kymberley, Norf, yeoman 0
4981392 2351353 2351353 defendant Wodehous John esq 586663 586663 Wodehous, John, of Kymberley, Norf, esq 2
5114645 2390698 2390698 defendant Talmage Thomas husbandman 586663 586663 Talmage, Thomas, of Kymberley, Norf, husbandman 1
5114651 2390699 2390699 defendant Andrewe Richard husbandman 586663 586663 Andrewe, Richard, of Kymberley, Norf, husbandman 2
5270151 2436374 2436374 defendant Wodehous Edward esq 586663 586663 Wodehous, Edward, of Kymberley, Norf, esq 2
5306542 2446949 2446949 defendant Wodehom alias Wodehous Edward esq 586663 586663 Wodehom alias Wodehous, Edward, of Kymberley, Norf, esq 0
5321697 2451564 2451564 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 0
5354665 2461536 2461536 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 0
5359302 2462945 2462945 defendant Wodehowese Edward   586663 586663 Wodehowese, Edward, of Kymberley, Norf, knight 0
5401854 2475596 2475596 defendant Wodhous Edward   586663 586663 Wodhous, Edward, of Kymberley, Norf, knight 0
5401857 2475597 2475597 defendant Wodhous Edward   586663 586663 Wodhous, Edward, of Kymberley, Norf, knight 0
5401860 2475598 2475598 defendant Wodhous Edward   586663 586663 Wodhous, Edward, of Kymberley, Norf, knight 0
5401863 2475599 2475599 defendant Wodhous Edward   586663 586663 Wodhous, Edward, of Kymberley, Norf, knight 0
5404260 2476295 2476295 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 0
5412041 2478556 2478556 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 0
5417303 2480094 2480094 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 0
5426605 2482904 2482904 defendant Wodhous Edward   586663 586663 Wodhous, Edward, of Kymberley, Norf, knight 0
5434748 2485330 2485330 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf 0
5449919 2489865 2489865 defendant Wodehous Edward   586663 586663 Wodehous, Edward, of Kymberley, Norf, knight 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);