names

57 rows where place_id = 598840

✎ 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
3634280 1905520 1905520 defendant Taillour Richard laborer 598840 598840 Taillour, Richard, of Clifford, laborer 0
3634281 1905520 1905520 defendant Lely John laborer 598840 598840 Lely, John, of Clifford, laborer 1
3634282 1905520 1905520 defendant Taillour Alice widow 598840 598840 Taillour, Alice, of Clifford, widow 2
3677742 1919087 1919087 defendant Boswell John husbandman 598840 598840 Boswell, John, of Clifford, husbandman 2
4097512 2059437 2059437 defendant Dylwyn Thomas yeoman 598840 598840 Dylwyn, Thomas, of Clifford, yeoman 1
4142584 2075575 2075575 defendant ap Owen Walter husbandman 598840 598840 ap Owen, Walter, of Clifford, husbandman 0
4159547 2081407 2081407 defendant Whytney James gent 598840 598840 Whytney, James, of Clifford, gent 1
4193626 2093338 2093338 defendant Lewes David yeoman 598840 598840 Lewes, David, of Clifford, yeoman 1
4193627 2093338 2093338 defendant Hughe Lewis John yeoman 598840 598840 Hughe, Lewis John, of Clifford, yeoman 2
4222836 2103479 2103479 defendant Hill Randolph gent 598840 598840 Hill, Randolph, of Clifford, gent 0
4222837 2103479 2103479 defendant Renne John Jevan Howell yeoman 598840 598840 Renne, John Jevan Howell, of Clifford, yeoman 1
4223038 2103548 2103548 defendant Lewes Eustace yeoman 598840 598840 Lewes, Eustace, of Clifford, or of Bettus, Clyrowe, Radnor, yeoman 0
4239904 2109591 2109591 defendant Hill Randolph gent 598840 598840 Hill, Randolph, of Clifford, gent 0
4239905 2109591 2109591 defendant Renne John Jevan Howell yeoman 598840 598840 Renne, John Jevan Howell, of Clifford, yeoman 1
4240114 2109665 2109665 defendant verghe Thomas Alice widow 598840 598840 verghe Thomas, Alice, of Clifford, widow 0
4240115 2109665 2109665 defendant Lewes Eustace yeoman 598840 598840 Lewes, Eustace, of Clifford, or of Bettus, Clirowe, Radnor, yeoman 1
4244474 2111130 2111130 defendant Hill Ralph or of Llanvairbryn, yeoman 598840 598840 Hill Ralph, of Clifford, or of Llanvairbryn, yeoman 1
4247991 2112315 2112315 defendant Nicholas John yeoman 598840 598840 Nicholas, John, of Clifford, yeoman 0
4289473 2126294 2126294 defendant Hill Randolph yeoman 598840 598840 Hill, Randolph, of Clifford, yeoman 0
4296674 2128910 2128910 defendant Hughe Lewis John yeoman 598840 598840 Hughe, Lewis John, of Clifford, yeoman 0
4300807 2130386 2130386 defendant ap Jevan Geoffrey yeoman 598840 598840 ap Jevan, Geoffrey, of Clifford, yeoman 0
4304394 2131673 2131673 defendant Griffith Thomas smith 598840 598840 Griffith, Thomas, of Clifford, smith 0
4317732 2136315 2136315 defendant Bullocke Eustace yeoman 598840 598840 Bullocke, Eustace, of Clifford, yeoman 0
4326156 2139117 2139117 defendant Poulton Francis yeoman 598840 598840 Poulton, Francis, of Clifford, yeoman 1
4377642 2157079 2157079 defendant Hill Randolph yeoman 598840 598840 Hill, Randolph, of Clifford, yeoman 0
4383106 2159067 2159067 defendant Whit Thomas yeoman 598840 598840 Whit, Thomas, of Clifford, yeoman 0
4383107 2159067 2159067 defendant Dylwyn Thomas yeoman 598840 598840 Dylwyn, Thomas, of Clifford, yeoman 1
4383108 2159067 2159067 defendant Aprosser Howell yeoman 598840 598840 Aprosser, Howell, of Clifford, yeoman 2
4383109 2159067 2159067 defendant Parry William yeoman 598840 598840 Parry, William, of Clifford, yeoman 3
4386180 2160058 2160058 defendant Hill Randolph gent 598840 598840 Hill, Randolph, of Clifford, gent 0
4386181 2160058 2160058 defendant Hill William gent 598840 598840 Hill, William, of Clifford, gent 1
4387333 2160411 2160411 defendant Myle Thomas husbandman 598840 598840 Myle, Thomas, of Clifford, husbandman 0
4394517 2162762 2162762 defendant Lewys John yeoman 598840 598840 Lewys, John, of Clifford, yeoman 0
4394518 2162762 2162762 defendant Brace Evan yeoman 598840 598840 Brace, Evan, of Clifford, yeoman 1
4394520 2162762 2162762 defendant Baker Robert yeoman 598840 598840 Baker, Robert, of Clifford, yeoman 3
4396965 2163555 2163555 defendant Dylwyn Thomas yeoman 598840 598840 Dylwyn, Thomas, of Clifford, yeoman 0
4396966 2163555 2163555 defendant White Thomas husbandman 598840 598840 White, Thomas, of Clifford, husbandman 1
4396967 2163555 2163555 defendant Prosser Howell husbandman 598840 598840 Prosser, Howell, of Clifford, husbandman 2
4396969 2163556 2163556 defendant Dylwyn Thomas yeoman 598840 598840 Dylwyn, Thomas, of Clifford, yeoman 0
4396970 2163556 2163556 defendant White Thomas husbandman 598840 598840 White, Thomas, of Clifford, husbandman 1
4396971 2163556 2163556 defendant Prosser Howell husbandman 598840 598840 Prosser, Howell, of Clifford, husbandman 2
4397888 2163870 2163870 defendant ap John Thomas husbandman 598840 598840 ap John, Thomas, of Clifford, husbandman 0
4398076 2163937 2163937 defendant Parry William yeoman 598840 598840 Parry, William, of Clifford, yeoman 0
4398077 2163937 2163937 defendant Dylwyn Thomas yeoman 598840 598840 Dylwyn, Thomas, of Clifford, yeoman 1
4398078 2163937 2163937 defendant ap John Katherine widow 598840 598840 ap John, Katherine, of Clifford, widow 2
4403454 2165727 2165727 defendant Gustaunce Jane widow 598840 598840 Gustaunce, Jane, of Clifford, widow 0
4409212 2167680 2167680 defendant Owen Thomas yeoman 598840 598840 Owen, Thomas, of Clifford, yeoman 1
4411580 2168465 2168465 defendant George Simon yeoman 598840 598840 George, Simon, of Clifford, yeoman 0
4411857 2168558 2168558 defendant Prichard David William yeoman 598840 598840 Prichard, David William, of Clifford, or of Lanvair Bryn, yeoman 0
4411858 2168558 2168558 defendant ap Jenkyn Robert Thomas yeoman 598840 598840 ap Jenkyn, Robert Thomas, of Clifford, or of Lanvair Bryn, yeoman 1
4442066 2182442 2182442 defendant Gabbes Richard   598840 598840 Gabbes, Richard, of Clifford 0
4477224 2193546 2193546 defendant Smyth William   598840 598840 Smyth, William, of Clifford, son of Richard 0
4477225 2193546 2193546 defendant Richardson John   598840 598840 Richardson, John, of Clifford 1
4477226 2193546 2193546 defendant Malyk Robert   598840 598840 Malyk, Robert, of Clifford 2
4480090 2194433 2194433 defendant Mikilthwayt John   598840 598840 Mikilthwayt, John, of Clifford 1
4568444 2221703 2221703 defendant Shephird John   598840 598840 Shephird, John, of Clifford 0
4615914 2235974 2235974 defendant Flesshewer Thomas   598840 598840 Flesshewer, Thomas, of Clifford 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);