names

31 rows where place_id = 756182

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4434935 2175687 2175687 defendant Groundy Richard merchant 756182 756182 Groundy, Richard, of Berkeley, Gloucs, merchant 0
4675369 2257906 2257906 plaintiff fitz Nicoll Thomas   756182 756182 fitz Nicoll, Thomas, of Berkeley, Gloucs, knight 0
4685584 2261085 2261085 defendant fitz Nicholl Thomas   756182 756182 fitz Nicholl, Thomas, of Berkeley, Gloucs, knight 0
4685586 2261086 2261086 defendant fitz Nicoll Thomas   756182 756182 fitz Nicoll, Thomas, of Berkeley, Gloucs, knight 0
4688963 2262103 2262103 defendant fitz Nicoll Thomas   756182 756182 fitz Nicoll, Thomas, of Berkeley, Gloucs, knight 0
4689063 2262139 2262139 defendant fitz Nicoll Thomas   756182 756182 fitz Nicoll, Thomas, of Berkeley, Gloucs, knight 0
4727465 2273833 2273833 defendant Cromp Henry mariner 756182 756182 Cromp, Henry, of Berkeley, Gloucs, mariner 2
4759567 2283334 2283334 defendant Russell Thomas husbandman 756182 756182 Russell, Thomas, of Berkeley, Gloucs, husbandman 0
4811925 2299843 2299843 defendant Heynes John husbandman 756182 756182 Heynes, John, of Berkeley, Gloucs, husbandman 4
4819955 2302318 2302318 defendant Berkeley James   756182 756182 Berkeley, James, of Berkeley, Gloucs, knight 0
4821777 2302889 2302889 defendant Venables Richard gent 756182 756182 Venables, Richard, of Berkeley, Gloucs, gent 1
4823364 2303395 2303395 defendant Venables Richard gent 756182 756182 Venables, Richard, of Berkeley, Gloucs, gent 1
4834262 2306726 2306726 defendant Berkeley James   756182 756182 Berkeley, James, of Berkeley, Gloucs, knight 0
4854054 2312677 2312677 defendant Donell William yeoman 756182 756182 Donell, William, of Berkeley, Gloucs, yeoman 1
4917288 2331916 2331916 defendant Berkerley James   756182 756182 Berkerley, James, of Berkeley, Gloucs, knight 0
4931418 2336205 2336205 defendant Grevell John   756182 756182 Grevell, John, of Berkeley, Gloucs 0
4931442 2336213 2336213 defendant Grevell John gent 756182 756182 Grevell, John, of Berkeley, Gloucs, gent 0
4989015 2353650 2353650 defendant Berkele William   756182 756182 Berkele, William, of Berkeley, Gloucs, knight 0
4991214 2354257 2354257 plaintiff Clyfford Thomas merchant 756182 756182 Clyfford, Thomas, of Berkeley, Gloucs, merchant 0
4997109 2355988 2355988 defendant Brown David chapman 756182 756182 Brown, David, of Berkeley, Gloucs, chapman 4
5001769 2357413 2357413 defendant Brouderer Richard yeoman 756182 756182 Brouderer, Richard, of Berkeley, Gloucs, yeoman 0
5001771 2357414 2357414 defendant Brouderer Richard yeoman 756182 756182 Brouderer, Richard, of Berkeley, Gloucs, yeoman 0
5008873 2359488 2359488 defendant Berkeley William   756182 756182 Berkeley, William, of Berkeley, Gloucs, knight 0
5044366 2369948 2369948 defendant Clyfford Thomas merchant 756182 756182 Clyfford, Thomas, of Berkeley, Gloucs, merchant 0
5051503 2372065 2372065 defendant Clyfford Thomas merchant 756182 756182 Clyfford, Thomas, of Berkeley, Gloucs, merchant 0
5126523 2394233 2394233 defendant Warde Edmund husbandman 756182 756182 Warde, Edmund, of Berkeley, Gloucs, husbandman 1
5165762 2405729 2405729 defendant Warde Edmund husbandman 756182 756182 Warde, Edmund, of Berkeley, Gloucs, husbandman 4
5180212 2409951 2409951 defendant Warde Edmund husbandman 756182 756182 Warde, Edmund, of Berkeley, Gloucs, husbandman 4
5185453 2411490 2411490 defendant Dyer John dyer 756182 756182 Dyer, John, of Berkeley, Gloucs, dyer 2
5423285 2481926 2481926 defendant Hoper Peter chapman 756182 756182 Hoper, Peter, of Berkeley, Gloucs, chapman 1
5453149 2490825 2490825 defendant Hoper (illegible) chapman 756182 756182 Hoper, _, of Berkeley, Gloucs, chapman 1

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