names

50 rows where place_id = 653242

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3927740 1999616 1999616 defendant Joyn Richard husbandman 653242 653242 Joyn, Richard, of Nashe, husbandman 2
3981061 2017986 2017986 defendant Jeyne Richard husbandman 653242 653242 Jeyne, Richard, of Nashe, husbandman 3
3988521 2020638 2020638 defendant West George yeoman 653242 653242 together with West, George, of Nashe, yeoman 1
3988522 2020638 2020638 defendant Shereman Philip husbandman 653242 653242 Shereman, Philip, of Nashe, husbandman 2
3988523 2020638 2020638 defendant Watkyn Jeneta widow 653242 653242 Watkyn, Jeneta, of Nashe, widow 3
4004085 2026233 2026233 defendant Farmer Humphrey yeoman 653242 653242 Farmer, Humphrey, of Nashe, yeoman 0
4008720 2027882 2027882 defendant Harry John husbandman 653242 653242 Harry, John, of Nashe, husbandman 1
4008724 2027883 2027883 defendant Harry John husbandman 653242 653242 Harry, John, of Nashe, husbandman 1
4008728 2027884 2027884 defendant Harry John husbandman 653242 653242 Harry, John, of Nashe, husbandman 1
4012091 2029051 2029051 defendant Kettyng Philip husbandman 653242 653242 Kettyng, Philip, of Nashe, husbandman 0
4012095 2029052 2029052 defendant Kettyng Philip husbandman 653242 653242 Kettyng, Philip, of Nashe, husbandman 0
4020892 2032199 2032199 defendant Hawle Thomas husbandman 653242 653242 Hawle, Thomas, of Nashe, husbandman 1
4033102 2036489 2036489 defendant ap Jeyne Richard, junior yeoman 653242 653242 ap Jeyne, Richard, junior, of Nashe, yeoman 0
4034456 2036994 2036994 defendant Lewes William gent 653242 653242 Lewes William, of Nashe, gent 2
4034460 2036995 2036995 defendant Lewes William gent 653242 653242 Lewes, William, of Nashe, gent 2
4037521 2038082 2038082 defendant Lepett Alice widow 653242 653242 Lepett, Alice, of Nashe, widow 0
4037527 2038083 2038083 defendant Marten Thomas yeoman 653242 653242 Marten, Thomas, of Nashe, yeoman 0
4037528 2038083 2038083 defendant Marten Edmund yeoman 653242 653242 Marten, Edmund, of Nashe, yeoman 1
4048580 2041941 2041941 defendant Herbert John gent 653242 653242 Herbert, John, of Nashe, gent 3
4051877 2043092 2043092 defendant Halle Thomas husbandman 653242 653242 Halle, Thomas, of Nashe, husbandman 0
4063406 2047201 2047201 defendant John Richard yeoman 653242 653242 John, Richard, of Nashe, yeoman 3
4071253 2050024 2050024 defendant Morgan John gent 653242 653242 Morgan, John, of Nashe, gent 0
4073944 2050971 2050971 defendant James David husbandman 653242 653242 James, David, of Nashe, husbandman 1
4073945 2050971 2050971 defendant Body Thomas husbandman 653242 653242 Body, Thomas, of Nashe, husbandman 2
4096111 2058936 2058936 defendant ap Rychard John Harry gent 653242 653242 ap Rychard, John Harry, of Nashe, gent 0
4114210 2065365 2065365 defendant ap Thomas Thomas husbandman 653242 653242 ap Thomas, Thomas, of Nashe, husbandman 1
4116704 2066269 2066269 defendant Arney Philip yeoman 653242 653242 Arney, Philip, of Nashe, yeoman 0
4118955 2067061 2067061 defendant Prosser William yeoman 653242 653242 Prosser, William, of Nashe, yeoman 0
4118958 2067061 2067061 defendant Langley Richard yeoman 653242 653242 Langley, Richard, of Nashe, yeoman 3
4130427 2071195 2071195 defendant Prychard John Harry yeoman 653242 653242 Prychard, John Harry, of Nashe, yeoman 3
4135753 2073114 2073114 defendant Martyn Edmund yeoman 653242 653242 Martyn, Edmund, of Nashe, yeoman 2
4157104 2080565 2080565 defendant Posser William gent 653242 653242 Posser, William, of Nashe, gent 0
4157105 2080565 2080565 defendant Sampson John yeoman 653242 653242 Sampson, John, of Nashe, yeoman 1
4184001 2089903 2089903 defendant Marten Edmund yeoman 653242 653242 Marten, Edmund, of Nashe, yeoman 0
4191375 2092551 2092551 defendant Gryffyth William yeoman 653242 653242 Gryffyth, William, of Nashe, yeoman 0
4193829 2093409 2093409 defendant Langley Richard husbandman 653242 653242 Langley, Richard, of Nashe, husbandman 2
4193830 2093409 2093409 defendant Powell Richard husbandman 653242 653242 Powell, Richard, of Nashe, husbandman 3
4204561 2097143 2097143 defendant Martyn Edmund yeoman 653242 653242 Martyn, Edmund, of Nashe, yeoman 1
4204673 2097181 2097181 defendant Hoper Christopher yeoman 653242 653242 Hoper, Christopher, of Nashe, yeoman 4
4212931 2100052 2100052 defendant Gillam James yeoman 653242 653242 Gillam, James, of Nashe, yeoman 0
4222564 2103384 2103384 defendant David Evan yeoman 653242 653242 David, Evan, of Nashe, yeoman 1
4274538 2121039 2121039 defendant Penney William yeoman 653242 653242 Penney, William, of Nashe, yeoman 1
4282801 2123887 2123887 defendant Arney James yeoman 653242 653242 Arney, James, of Nashe, yeoman 0
4282802 2123887 2123887 defendant Smyth William yeoman 653242 653242 Smyth, William, of Nashe, yeoman 1
4282803 2123887 2123887 defendant David Jevan yeoman 653242 653242 David, Jevan, of Nashe, yeoman 2
4370297 2154435 2154435 defendant ap Jevan David husbandman 653242 653242 ap Jevan, David, of Nashe, husbandman 0
4370298 2154435 2154435 defendant Marten Thomas husbandman 653242 653242 Marten, Thomas, of Nashe, husbandman 1
4370299 2154435 2154435 defendant Powell Richard butcher 653242 653242 Powell, Richard, of Nashe, butcher 2
4371451 2154844 2154844 defendant Richard John husbandman 653242 653242 Richard, John, of Nashe, husbandman 2
4376603 2156703 2156703 defendant Tapp John yeoman 653242 653242 Tapp, John, of Nashe, yeoman 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);