names

48 rows where place_id = 601087

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643797 1908488 1908488 defendant ap Henry alias Morgan David husbandman 601087 601087 ap Henry alias Morgan, David, of Dore, husbandman 1
3643798 1908488 1908488 defendant ap Henry David husbandman 601087 601087 ap Henry, David, of Dore, husbandman 2
3674227 1917978 1917978 defendant Thomas Richard husbandman 601087 601087 Thomas, Richard, of Dore, husbandman 2
3685982 1921774 1921774 defendant Veyne Geoffrey yeoman 601087 601087 Veyne, Geoffrey, of Dore, yeoman 1
3702524 1927057 1927057 defendant Smyth Richard husbandman 601087 601087 Smyth, Richard, of Dore, husbandman 0
3702525 1927057 1927057 defendant ap Henry David ap Madocke husbandman 601087 601087 ap Henry, David ap Madocke, of Dore, husbandman 1
3708570 1928981 1928981 defendant ap David Richard husbandman 601087 601087 ap David, Richard, of Dore, husbandman 1
3708571 1928981 1928981 defendant Madocke David husbandman 601087 601087 Madocke, David, of Dore, husbandman 2
3774999 1949916 1949916 defendant ap Rychard Thomas yeoman 601087 601087 ap Rychard, Thomas, of Dore, yeoman 0
3776031 1950249 1950249 defendant Snell John husbandman 601087 601087 Snell, John, of Dore, husbandman 0
3776032 1950249 1950249 defendant A Chamber John tanner 601087 601087 A Chamber, John, of Dore, tanner 1
3776033 1950249 1950249 defendant Rawlynson Richard ironmonger 601087 601087 Rawlynson, Richard, of Dore, ironmonger 2
3776034 1950249 1950249 defendant Barker John gent 601087 601087 Barker, John, of Dore, gent 3
3776036 1950250 1950250 defendant Barker John   601087 601087 Barker, John, of Dore 0
3776037 1950250 1950250 defendant Snell John husbandman 601087 601087 Snell, John, of Dore, husbandman 1
3776038 1950250 1950250 defendant Achamber John tanner 601087 601087 Achamber, John, of Dore, tanner 2
3776039 1950250 1950250 defendant Rawlynson Richard oronmonger 601087 601087 Rawlynson, Richard, of Dore, oronmonger 3
3844871 1971939 1971939 defendant ap Rychard Thomas yeoman 601087 601087 ap Rychard, Thomas, of Dore, yeoman 0
3899125 1989916 1989916 defendant ap Henry Richard husbandman 601087 601087 ap Henry, Richard, of Dore, husbandman 0
3899126 1989916 1989916 defendant ap Henry John husbandman 601087 601087 ap Henry, John, of Dore, husbandman 1
3899128 1989917 1989917 defendant ap Henry Richard husbandman 601087 601087 ap Henry, Richard, of Dore, husbandman 0
3899129 1989917 1989917 defendant ap Henry John husbandman 601087 601087 ap Henry, John, of Dore, husbandman 1
3899130 1989917 1989917 defendant Page Edward laborer 601087 601087 Page, Edward, of Dore, laborer 2
3909142 1993355 1993355 defendant Smyth Richard husbandman 601087 601087 Smyth, Richard, of Dore, husbandman 1
3909143 1993355 1993355 defendant Bulcote Robert husbandman 601087 601087 Bulcote, Robert, of Dore, husbandman 2
3909144 1993355 1993355 defendant ap Morgan Thomas tanner 601087 601087 ap Morgan, Thomas, of Dore, tanner 3
3909145 1993355 1993355 defendant Arthyr John ap David husbandman 601087 601087 Arthyr, John ap David, of Dore, husbandman 4
3912614 1994551 1994551 defendant Tewe Thomas husbandman 601087 601087 Tewe, Thomas, of Dore, husbandman 0
3941551 2004187 2004187 defendant Barowe Thomas yeoman 601087 601087 Barowe, Thomas, of Dore, yeoman 0
3941552 2004187 2004187 defendant Barowe Richard yeoman 601087 601087 Barowe, Richard, of Dore, yeoman 1
3941553 2004187 2004187 defendant Williams Thomas yeoman 601087 601087 Williams, Thomas, of Dore, yeoman 2
3943451 2004825 2004825 defendant Tewe Thomas Philip yeoman 601087 601087 Tewe, Thomas Philip, of Dore, yeoman 0
3943501 2004844 2004844 defendant ap David Walter ap John yeoman 601087 601087 ap David, Walter ap John, of Dore, yeoman 0
3943505 2004845 2004845 defendant ap David Walter ap John yeoman 601087 601087 ap David, Walter ap John, of Dore, yeoman 0
3943509 2004846 2004846 defendant Sicill John gent 601087 601087 Sicill, John, of Dore, gent 0
3964168 2012076 2012076 defendant Brewer William ap Richard husbandman or yeoman 601087 601087 Brewer, William ap Richard, of Dore, husbandman or yeoman 0
4001597 2025350 2025350 defendant Sare Margaret widow 601087 601087 Sare, Margaret, of Dore, widow 0
4001598 2025350 2025350 defendant Sare Merick husbandman 601087 601087 Sare, Merick, of Dore, husbandman 1
4014478 2029903 2029903 defendant ap Thomas Thomas yeoman 601087 601087 ap Thomas, Thomas, of Dore, yeoman 1
4040311 2039041 2039041 plaintiff Meredith Rees   601087 601087 Meredith, Rees, of Dore, mason 0
4063198 2047135 2047135 defendant Sare John carpenter 601087 601087 Sare, John, of Dore, carpenter 1
4063199 2047135 2047135 defendant Gillam Thomas laborer 601087 601087 Gillam, Thomas, of Dore, laborer 2
4063203 2047135 2047135 defendant Philip William laborer 601087 601087 Philip, William, of Dore, laborer 6
4170973 2085328 2085328 defendant Bulle William laborer 601087 601087 Bulle, William, of Dore, laborer 0
5522569 2511882 2511882 defendant Veyne Geoffrey yeoman 601087 601087 Veyne, Geoffrey, of Dore, yeoman 0
5551389 2520441 2520441 defendant Colcombe John husbandman 601087 601087 Colcombe, John, of Dore, husbandman 1
5566747 2524870 2524870 defendant Hergest Henry yeoman 601087 601087 Hergest, Henry, of Dore, yeoman 3
5590592 2532027 2532027 defendant Veyne John yeoman 601087 601087 Veyne, John, of Dore, yeoman 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);