names

25 rows where place_id = 610823

✎ 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
3685396 1921586 1921586 defendant Balnet Robert husbandman 610823 610823 Balnet, Robert, of Langley Mareys, husbandman 0
3685397 1921586 1921586 defendant Style William husbandman 610823 610823 Style, William, of Langley Mareys, husbandman 1
3685398 1921586 1921586 defendant Wasshenden John husbandman 610823 610823 Wasshenden, John, of Langley Mareys, husbandman 2
4696588 2264409 2264409 defendant Clynton Joan   610823 610823 Clynton, Joan, of Langley Mareys, Bucks, gentlewoman, formerly wife of Thomas Clynton, of Kent, knight 0
4755337 2282060 2282060 defendant Smyth John husbandman 610823 610823 Smyth, John, of Langley Mareys, husbandman 0
5077858 2379865 2379865 defendant Park Robert husbandman 610823 610823 Park, Robert, of Langley Mareys, husbandman 3
5077859 2379865 2379865 defendant Park William husbandman 610823 610823 Park, William, of Langley Mareys, husbandman 4
5077860 2379865 2379865 defendant Fyssher Thomas husbandman 610823 610823 Fyssher, Thomas, of Langley Mareys, husbandman 5
5077861 2379865 2379865 defendant Sellam John husbandman 610823 610823 Sellam, John, of Langley Mareys, husbandman 6
5077862 2379865 2379865 defendant Waren John husbandman 610823 610823 Waren, John, of Langley Mareys, husbandman 7
5077863 2379865 2379865 defendant Squyer Giles husbandman 610823 610823 Squyer, Giles, of Langley Mareys, husbandman 8
5077864 2379865 2379865 defendant Maundevyle Richard husbandman 610823 610823 Maundevyle, Richard, of Langley Mareys, husbandman 9
5077865 2379865 2379865 defendant Westhorp John laborer 610823 610823 Westhorp, John, of Langley Mareys, laborer 10
5077866 2379865 2379865 defendant Rendal Richard laborer 610823 610823 Rendal, Richard, of Langley Mareys, laborer 11
5077874 2379866 2379866 defendant Park Robert husbandman 610823 610823 Park, Robert, of Langley Mareys, husbandman 2
5077875 2379866 2379866 defendant Park William husbandman 610823 610823 Park, William, of Langley Mareys, husbandman 3
5077876 2379866 2379866 defendant Fyssher Thomas husbandman 610823 610823 Fyssher, Thomas, of Langley Mareys, husbandman 4
5077877 2379866 2379866 defendant Sellam John husbandman 610823 610823 Sellam, John, of Langley Mareys, husbandman 5
5077878 2379866 2379866 defendant Waren John husbandman 610823 610823 Waren, John, of Langley Mareys, husbandman 6
5077879 2379866 2379866 defendant Squyer Giles husbandman 610823 610823 Squyer, Giles, of Langley Mareys, husbandman 7
5077880 2379866 2379866 defendant Maundevyle Richard husbandman 610823 610823 Maundevyle, Richard, of Langley Mareys, husbandman 8
5077881 2379866 2379866 defendant Westhorp John laborer 610823 610823 Westhorp, John, of Langley Mareys, laborer 9
5077882 2379866 2379866 defendant Rendal Richard laborer 610823 610823 Rendal, Richard, of Langley Mareys, laborer 10
5218039 2421012 2421012 defendant Eyre Giles husbandman 610823 610823 Eyre, Giles, of Langley Mareys, husbandman 1
5294027 2443226 2443226 defendant Norys John blacksmith 610823 610823 Norys, John, of Langley Mareys, blacksmith 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);