names

25 rows where place_id = 663200

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3967913 2013405 2013405 defendant Tanne Robert husbandman or yeoman 663200 663200 Tanne, Robert, of Old Buckenham, husbandman or yeoman 1
3973183 2015190 2015190 defendant Knevett Edmund gent 663200 663200 Knevett, Edmund, of Old Buckenham, gent 0
3988812 2020744 2020744 defendant Murrell Andrew cooper 663200 663200 Murrell, Andrew, of Old Buckenham, cooper 1
3988813 2020744 2020744 defendant Amys Richard husbandman 663200 663200 Amys, Richard, of Old Buckenham, husbandman 2
4054694 2044068 2044068 defendant Townsende Richard   663200 663200 Townsende, Richard, of Old Buckenham, brick maker 0
4064409 2047550 2047550 defendant Goodwyn Edmund gent 663200 663200 Goodwyn, Edmund, of Old Buckenham, gent 0
4191217 2092492 2092492 defendant Wenne Thomas husbandman 663200 663200 Wenne, Thomas, of Old Buckenham, husbandman 1
4191219 2092492 2092492 defendant Nunne Francis husbandman 663200 663200 Nunne, Francis, of Old Buckenham, husbandman 3
4202505 2096414 2096414 defendant Jurdan Robert clerk 663200 663200 Jurdan, Robert, of Old Buckenham, clerk 1
4213455 2100224 2100224 defendant Downes John husbandman 663200 663200 Downes, John, of Old Buckenham, husbandman 1
4214886 2100707 2100707 defendant Eldred Peter yeoman 663200 663200 Eldred, Peter, of Old Buckenham, yeoman 0
4250291 2113078 2113078 defendant Eldred Peter yeoman 663200 663200 Eldred, Peter, of Old Buckenham, yeoman 0
4253383 2114121 2114121 defendant Murton Henry yeoman 663200 663200 Murton, Henry, of Old Buckenham, yeoman 0
4259142 2116032 2116032 defendant Judd Nicholas yeoman 663200 663200 Judd, Nicholas, of Old Buckenham, yeoman 0
4259143 2116032 2116032 defendant Cooper Oliver yeoman 663200 663200 Cooper, Oliver, of Old Buckenham, yeoman 1
4259144 2116032 2116032 defendant Baker Nicholas tailor 663200 663200 Baker, Nicholas, of Old Buckenham, tailor 2
4259145 2116032 2116032 defendant Jubye Mathew husbandman 663200 663200 Jubye, Mathew, of Old Buckenham, husbandman 3
4285857 2124995 2124995 defendant Wragg Thomas husbandman 663200 663200 Wragg, Thomas, of Old Buckenham, husbandman 1
4286951 2125386 2125386 defendant Townsend James husbandman 663200 663200 Townsend, James, of Old Buckenham, husbandman 1
4313220 2134735 2134735 defendant Kyng Robert husbandman 663200 663200 Kyng, Robert, of Old Buckenham, husbandman 0
4323809 2138375 2138375 defendant Judd Nicholas gent 663200 663200 Judd, Nicholas, of Old Buckenham, gent 0
4326611 2139260 2139260 defendant Jolly William husbandman 663200 663200 Jolly, William, of Old Buckenham, husbandman 1
4326613 2139260 2139260 defendant Manbye Richard husbandman 663200 663200 Manbye, Richard, of Old Buckenham, husbandman 3
4329262 2140100 2140100 defendant Townsend Richard husbandman 663200 663200 Townsend, Richard, of Old Buckenham, husbandman 0
4388769 2160876 2160876 defendant Isbells Robert yeoman 663200 663200 Isbells, Robert, of Old Buckenham, yeoman 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);