names

23 rows where place_id = 604412

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657915 1912726 1912726 defendant Gigler Thomas yeoman 604412 604412 Gigler, Thomas, of Great Massyngham, yeoman 0
3666098 1915341 1915341 defendant Jary Richard butcher 604412 604412 Jary, Richard, of Great Massyngham, butcher 0
3927779 1999629 1999629 defendant Smyth John yeoman 604412 604412 Smyth, John, of Great Massyngham, yeoman 2
3929843 2000321 2000321 defendant Barker alias Smyth John husbandman 604412 604412 Barker alias Smyth, John, of Great Massyngham, husbandman 0
3932205 2001076 2001076 defendant Barker alias Smyth John yeoman 604412 604412 Barker alias Smyth, John, of Great Massyngham, yeoman 0
3941238 2004073 2004073 defendant Prest Agnes widow 604412 604412 Prest, Agnes, of Great Massyngham, widow 4
3941988 2004329 2004329 defendant Jekler Thomas yeoman 604412 604412 Jekler, Thomas, of Great Massyngham, yeoman 0
4422739 2171968 2171968 plaintiff Feltham John de   604412 604412 (Feltham, John de, of Great Massyngham, parson of All Saints church 1
4487591 2196837 2196837 defendant Willys John   604412 604412 Willys, John, of Great Massyngham 1
4525731 2208349 2208349 defendant Heed John baker 604412 604412 Heed, John, of Great Massyngham, baker 0
4650376 2246133 2246133 plaintiff Willes John   604412 604412 Willes, John, of Great Massyngham 0
4650379 2246134 2246134 plaintiff Willes John   604412 604412 Willes, John, of Great Massyngham 0
4696525 2264389 2264389 defendant Willys John husbandman 604412 604412 Willys, John, of Great Massyngham, husbandman 2
4716516 2270486 2270486 plaintiff Willys John   604412 604412 Willys, John, of Great Massyngham 0
4737754 2276912 2276912 defendant Walbot Mathew thatcher 604412 604412 Walbot, Mathew, of Great Massyngham, thatcher 0
4737755 2276912 2276912 defendant Egleton Richard laborer 604412 604412 Egleton, Richard, of Great Massyngham, laborer 1
4822589 2303141 2303141 defendant Lambard John yeoman 604412 604412 Lambard, John, of Great Massyngham, yeoman 1
4822590 2303141 2303141 defendant Hook John laborer 604412 604412 Hook, John, of Great Massyngham, laborer 2
4849894 2311439 2311439 plaintiff Suker Thomas   604412 604412 Suker, Thomas, of Great Massyngham 0
5146911 2400238 2400238 defendant Tolle Henry yeoman 604412 604412 (Tolle, Henry, of Great Massyngham, yeoman 1
5385418 2470906 2470906 defendant Mayhewe Henry husbandman 604412 604412 Mayhewe, Henry, of Great Massyngham, husbandman 10
5397558 2474374 2474374 defendant Mayhewe Henry husbandman 604412 604412 Mayhewe, Henry, of Great Massyngham, husbandman 10
5621954 2550780 2550780 plaintiff Thorplond William de   604412 604412 Thorplond, William de, of Great Massyngham 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);