names

65 rows where place_id = 610741

✎ 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
3684962 1921431 1921431 defendant Shyre Richard husbandman 610741 610741 Shyre, Richard, of Fownehope, husbandman 0
3690855 1923304 1923304 defendant Kydley Thomas husbandman 610741 610741 Kydley, Thomas, of Fownehope, husbandman 0
3758849 1944756 1944756 defendant Baker Edward husbandman 610741 610741 Baker, Edward, of Fownehope, husbandman 0
3758850 1944756 1944756 defendant Shere Richard husbandman 610741 610741 Shere, Richard, of Fownehope, husbandman 1
3807805 1960325 1960325 defendant Tayllour Thomas husbandman 610741 610741 Tayllour, Thomas, of Fownehope, husbandman 0
3807806 1960325 1960325 defendant Whelar John husbandman 610741 610741 Whelar, John, of Fownehope, husbandman 1
3889363 1986673 1986673 defendant Cola Richard yeoman 610741 610741 Cola, Richard, of Fownehope, yeoman 0
3895110 1988575 1988575 defendant ap Guilliam John gent 610741 610741 ap Guilliam, John, of Fownehope, gent 0
3898060 1989560 1989560 defendant Cole Richard husbandman 610741 610741 Cole, Richard, of Fownehope, husbandman 1
3951449 2007568 2007568 defendant Kydley Richard husbandman 610741 610741 Kydley, Richard, of Fownehope, husbandman 0
3951450 2007568 2007568 defendant Kydley John husbandman 610741 610741 Kydley, John, of Fownehope, husbandman 1
3951451 2007568 2007568 defendant Havard William husbandman 610741 610741 Havard, William, of Fownehope, husbandman 2
3951452 2007568 2007568 defendant Havard John, junior husbandman 610741 610741 Havard, John, junior, of Fownehope, husbandman 3
3951453 2007568 2007568 defendant Jeffreys Thomas husbandman 610741 610741 Jeffreys, Thomas, of Fownehope, husbandman 4
3951454 2007568 2007568 defendant Jenkyns John husbandman 610741 610741 Jenkyns, John, of Fownehope, husbandman 5
3951455 2007568 2007568 defendant Lawrence William husbandman 610741 610741 Lawrence, William, of Fownehope, husbandman 6
3951456 2007568 2007568 defendant Rowly Francis husbandman 610741 610741 Rowly, Francis, of Fownehope, husbandman 7
3951457 2007568 2007568 defendant Masser Edward husbandman 610741 610741 Masser, Edward, of Fownehope, husbandman 8
3951458 2007568 2007568 defendant Turnor Thomas husbandman 610741 610741 Turnor, Thomas, of Fownehope, husbandman 9
3958325 2009988 2009988 defendant Norman John husbandman 610741 610741 Norman, John, of Fownehope, husbandman 0
3958326 2009988 2009988 defendant Alford John husbandman 610741 610741 Alford, John, of Fownehope, husbandman 1
3958327 2009988 2009988 defendant Lewys John laborer 610741 610741 Lewys, John, of Fownehope, laborer 2
3958328 2009988 2009988 defendant Brace John husbandman 610741 610741 Brace, John, of Fownehope, husbandman 3
3958329 2009988 2009988 defendant Norman John, junior husbandman 610741 610741 Norman, John, junior, of Fownehope, husbandman 4
3958330 2009988 2009988 defendant Homes Elizabeth spinster 610741 610741 Homes, Elizabeth, of Fownehope, spinster 5
3958331 2009988 2009988 defendant Homes AGnes spinster 610741 610741 Homes, AGnes, of Fownehope, spinster 6
3958353 2009994 2009994 defendant Norman John yeoman 610741 610741 Norman, John, of Fownehope, yeoman 0
3958354 2009994 2009994 defendant Alforde John husbandman 610741 610741 Alforde, John, of Fownehope, husbandman 1
3958355 2009994 2009994 defendant Brace john husbandman 610741 610741 Brace, john, of Fownehope, husbandman 2
3969177 2013828 2013828 defendant Norman John husbandman 610741 610741 Norman, John, of Fownehope, husbandman 1
3969178 2013828 2013828 defendant Alforde John yeoman 610741 610741 Alforde, John, of Fownehope, yeoman 2
3981109 2018001 2018001 defendant Shere Richard, junior husbandman 610741 610741 Shere, Richard, junior, of Fownehope, husbandman 0
3987699 2020349 2020349 defendant Gryffyth William laborer 610741 610741 Gryffyth, William, of Fownehope, laborer 1
4005915 2026887 2026887 defendant ap David William weaver 610741 610741 ap David, William, of Fownehope, weaver 0
4019619 2031743 2031743 defendant Gryffyth Joan widow 610741 610741 Gryffyth, Joan, of Fownehope, widow 0
4019620 2031743 2031743 defendant Gryffyth William tailor 610741 610741 Gryffyth, William, of Fownehope, tailor 1
4019621 2031743 2031743 defendant Noblett Thomas butcher 610741 610741 Noblett, Thomas, of Fownehope, butcher 2
4019622 2031743 2031743 defendant Noblett John laborer 610741 610741 Noblett, John, of Fownehope, laborer 3
4034189 2036892 2036892 defendant Robert John miller 610741 610741 Robert, John, of Fownehope, miller 0
4035110 2037235 2037235 defendant Morse William husbandman 610741 610741 Morse, William, of Fownehope, husbandman 1
4036485 2037735 2037735 defendant Hodg Thomas husbandman 610741 610741 Hodg, Thomas, of Fownehope, husbandman 1
4036489 2037736 2037736 defendant Hodge Thomas husbandman 610741 610741 Hodge, Thomas, of Fownehope, husbandman 1
4046342 2041137 2041137 defendant Barnard Humphrey (legal representative) 610741 610741 Barnard, Humphrey, of Fownehope, yeoman, executors of 0
4046343 2041137 2041137 defendant Kyrwood Walter yeoman 610741 610741 (Kyrwood, Walter, of Fownehope, yeoman 1
4050640 2042660 2042660 defendant Gruffyth Joan widow 610741 610741 Gruffyth, Joan, of Fownehope, widow 0
4050641 2042660 2042660 defendant Gruffith William tailor 610741 610741 Gruffith, William, of Fownehope, tailor 1
4050642 2042660 2042660 defendant Noblett Thomas butcher 610741 610741 Noblett, Thomas, of Fownehope, butcher 2
4050643 2042660 2042660 defendant Nobbett John laborer 610741 610741 Nobbett, John, of Fownehope, laborer 3
4050645 2042661 2042661 defendant Gryffythe Joan widow 610741 610741 Gryffythe, Joan, of Fownehope, widow 0
4050646 2042661 2042661 defendant Gruffythe William tailor 610741 610741 Gruffythe, William, of Fownehope, tailor 1
4050647 2042661 2042661 defendant Gryffythe Joan spinster 610741 610741 Gryffythe, Joan, of Fownehope, spinster 2
4073570 2050835 2050835 defendant Mercer Thomas husbandman 610741 610741 Mercer, Thomas, of Fownehope, husbandman 2
4081462 2053679 2053679 defendant Rogers Thomas husbandman 610741 610741 Rogers, Thomas, of Fownehope, husbandman 1
4110431 2063994 2063994 defendant Lawrence Roger, senior yeoman 610741 610741 Lawrence, Roger, senior, of Fownehope, yeoman 0
4110432 2063994 2063994 defendant More William yeoman 610741 610741 More, William, of Fownehope, yeoman 1
4110433 2063994 2063994 defendant Rogers Thomas husbandman 610741 610741 Rogers, Thomas, of Fownehope, husbandman 2
4116601 2066228 2066228 defendant Marser Thomas husbandman 610741 610741 Marser, Thomas, of Fownehope, husbandman 0
4220436 2102650 2102650 defendant Tompkyns John yeoman 610741 610741 Tompkyns, John, of Fownehope, yeoman 2
4241360 2110095 2110095 defendant Goughe John yeoman 610741 610741 Goughe, John, of Fownehope, yeoman 1
4253514 2114164 2114164 defendant Tucker Richard miller 610741 610741 Tucker, Richard, of Fownehope, miller 0
4253518 2114165 2114165 defendant Tucker Richard miller 610741 610741 Tucker, Richard, of Fownehope, miller 0
4292562 2127400 2127400 defendant Pewdras Richard husbandman 610741 610741 Pewdras, Richard, of Fownehope, husbandman 2
4299999 2130096 2130096 defendant Kydeley John yeoman 610741 610741 Kydeley, John, of Fownehope, yeoman 1
4304111 2131571 2131571 defendant Scudamore William gent 610741 610741 Scudamore, William, of Fownehope, gent 2
4389112 2160987 2160987 defendant Hodges John husbandman 610741 610741 Hodges, John, of Fownehope, husbandman 2

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