names

88 rows where place_id = 588077

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593292 1865533 1865533 defendant Gronowe William chapman 588077 588077 Gronowe, William, of Oswestre, chapman 1
3773757 1949507 1949507 plaintiff Wyn Roger   588077 588077 Wyn, Roger, of Oswestre 1
3773760 1949508 1949508 plaintiff Wyn Roger yeoman 588077 588077 Wyn, Roger, of Oswestre, yeoman 1
3823806 1965337 1965337 defendant Trevor John gent 588077 588077 Trevor, John, of Oswestre, gent 1
3823807 1965337 1965337 defendant Trevor William gent 588077 588077 Trevor, William, of Oswestre, gent 2
3823808 1965337 1965337 defendant Trevor John Dee ap Robert gent 588077 588077 Trevor, John Dee ap Robert, of Oswestre, gent 3
3823894 1965344 1965344 defendant Trevor William gent 588077 588077 Trevor, William, of Oswestre, gent 3
3823895 1965344 1965344 defendant ap Willyam Richard ap Med yeoman 588077 588077 ap Willyam, Richard ap Med, of Oswestre, yeoman 4
3871022 1980559 1980559 plaintiff ap rys John ap David mercer 588077 588077 ap rys, John ap David, of Oswestre, mercer 1
3871023 1980559 1980559 plaintiff Vycha Howel ap Gruffin gent 588077 588077 Vycha, Howel ap Gruffin, of Oswestre, gent 2
3871233 1980633 1980633 plaintiff Avenyon John mercer 588077 588077 Avenyon, John, of Oswestre, mercer 0
3871235 1980633 1980633 defendant ap David Jenn tailor 588077 588077 ap David, Jenn, of Oswestre, tailor 1
3871236 1980633 1980633 defendant ap John Morgan weaver 588077 588077 ap John, Morgan, of Oswestre, weaver 2
3871237 1980634 1980634 plaintiff Avenyon John mercer 588077 588077 Avenyon, John, of Oswestre, mercer 0
3871239 1980634 1980634 defendant ap John Philip   588077 588077 ap John, Philip, of Oswestre, "fryser" 1
3871240 1980634 1980634 defendant ap Robert Richard baker 588077 588077 ap Robert, Richard, of Oswestre, baker 2
3884688 1985154 1985154 plaintiff ap Howell Robert (legal representative) 588077 588077 ap Howell, Robert, of Oswestre, executor of 0
3884690 1985154 1985154 defendant Glover George (legal representative) 588077 588077 Glover, George, of Oswestre, executor of 0
3884705 1985159 1985159 defendant Yollyn Thomas ap Hoell ap Jenn yeoman 588077 588077 Yollyn, Thomas ap Hoell ap Jenn, of Oswestre, yeoman 1
3884707 1985160 1985160 defendant Borthman Thomas ap John drover 588077 588077 Borthman, Thomas ap John, of Oswestre, drover 0
3884708 1985161 1985161 plaintiff ap Meredyth Edward   588077 588077 ap Meredyth, Edward, of Oswestre 0
3884709 1985161 1985161 defendant ap Rychard Meredyth yeoman 588077 588077 ap Rychard, Meredyth, of Oswestre, yeoman 0
3892538 1987749 1987749 defendant Stannye David gent 588077 588077 Stannye, David, of Oswestre, gent 1
3892539 1987749 1987749 defendant Vaughan John ap David mercer 588077 588077 Vaughan, John ap David, of Oswestre, mercer 2
3892540 1987749 1987749 defendant Bladwell Richard gent 588077 588077 Bladwell, Richard, of Oswestre, gent 3
3898384 1989672 1989672 defendant Gogh William Gyttyng yeoman 588077 588077 Gogh, William Gyttyng, of Oswestre, yeoman 0
3898385 1989672 1989672 defendant ap Griffith Jenn ap Meredith yeoman 588077 588077 ap Griffith, Jenn ap Meredith, of Oswestre, yeoman 1
3898386 1989672 1989672 defendant ap Jankyn Thomas ap David   588077 588077 ap Jankyn, Thomas ap David, of Oswestre 2
3898387 1989672 1989672 defendant ap Bady Geoffrey yeoman 588077 588077 ap Bady, Geoffrey, of Oswestre, yeoman 3
3898438 1989689 1989689 defendant Lloyd John ap Richard gent 588077 588077 Lloyd, John ap Richard, of Oswestre, gent 0
3899066 1989897 1989897 defendant ap Hugh alias Vycarars John butcher 588077 588077 ap Hugh alias Vycarars, John, of Oswestre, butcher 1
3899067 1989897 1989897 defendant William Thomas ap John glover 588077 588077 William, Thomas ap John, of Oswestre, glover 2
3899068 1989897 1989897 defendant ap Thomas alias Sucar Hugh butcher 588077 588077 ap Thomas alias Sucar, Hugh, of Oswestre, butcher 3
3899069 1989897 1989897 defendant ap Hugh David Lloyd glover 588077 588077 ap Hugh, David Lloyd, of Oswestre, glover 4
3901495 1990724 1990724 defendant Egerton William shoemaker 588077 588077 Egerton, William, of Oswestre, shoemaker 0
3901496 1990724 1990724 defendant Holden Richard husbandman 588077 588077 Holden, Richard, of Oswestre, husbandman 1
3901661 1990784 1990784 defendant Johns Robert chapman 588077 588077 Johns, Robert, of Oswestre, chapman 1
3904141 1991628 1991628 defendant ap Meredith Jenn Lloyd gent 588077 588077 ap Meredith, Jenn Lloyd, of Oswestre, gent 0
3904142 1991628 1991628 defendant Kyffen Richard clerk 588077 588077 Kyffen, Richard, of Oswestre, clerk 1
3909801 1993586 1993586 defendant ap John Evan glover 588077 588077 ap John, Evan, of Oswestre, glover 1
3909810 1993590 1993590 plaintiff Stanney David   588077 588077 Stanney, David, of Oswestre 0
3912625 1994556 1994556 plaintiff ap Meredyth Edward mercer 588077 588077 ap Meredyth, Edward, of Oswestre, mercer 0
3912628 1994557 1994557 plaintiff ap Meredyth Edward mercer 588077 588077 ap Meredyth, Edward, of Oswestre, mercer 0
3919282 1996779 1996779 defendant ap John Robert mercer 588077 588077 ap John, Robert, of Oswestre, mercer 1
3919283 1996779 1996779 defendant Sayer Edward yeoman 588077 588077 Sayer, Edward, of Oswestre, yeoman 2
3919284 1996779 1996779 defendant Apybady Meredith ap Howell husbandman 588077 588077 Apybady, Meredith ap Howell, of Oswestre, husbandman 3
3923339 1998113 1998113 defendant Friesser Llewellin clothier 588077 588077 Friesser, Llewellin, of Oswestre, clothier 2
3923340 1998113 1998113 defendant Watken John ap David mercer 588077 588077 Watken, John ap David, of Oswestre, mercer 3
3925753 1998929 1998929 plaintiff Wylliam John   588077 588077 Wylliam, John, of Oswestre 0
3965281 2012473 2012473 defendant Smallman Frances   588077 588077 Smallman, Frances, of Oswestre 0
3970375 2014236 2014236 defendant ap Robart Thomas ap Richard   588077 588077 ap Robart, Thomas ap Richard, of Oswestre 0
3971330 2014531 2014531 plaintiff Edward John gent 588077 588077 Edward, John, of Oswestre, gent 0
3971356 2014540 2014540 plaintiff Edwardes John gent 588077 588077 Edwardes, John, of Oswestre, gent 0
3975340 2015942 2015942 defendant Jones Jevan glover 588077 588077 Jones, Jevan, of Oswestre, glover 0
3976652 2016410 2016410 defendant Kyffyn John (legal representative) 588077 588077 Kyffyn, John, of Oswestre, executrix of 0
3976653 2016410 2016410 defendant vergh Thomas Gwen widow 588077 588077 vergh Thomas, Gwen, of Oswestre, widow 1
3982550 2018534 2018534 defendant ap Jevan Owen laborer 588077 588077 ap Jevan, Owen, of Oswestre, laborer 0
3982551 2018534 2018534 defendant Jones Reginald yeoman 588077 588077 Jones, Reginald, of Oswestre, yeoman 1
3982552 2018534 2018534 defendant ap Tydder Robert ap Gryffyth husbandman 588077 588077 ap Tydder, Robert ap Gryffyth, of Oswestre, husbandman 2
3982553 2018534 2018534 defendant ap Howell alias Trenelegh David ap John yeoman 588077 588077 ap Howell alias Trenelegh, David ap John, of Oswestre, yeoman 3
3982572 2018541 2018541 defendant Jones Reginald yeoman 588077 588077 Jones, Reginald, of Oswestre, yeoman 1
3982574 2018541 2018541 defendant ap Howell alias Trenelegh David ap John yeoman 588077 588077 ap Howell alias Trenelegh, David ap John, of Oswestre, yeoman 3
3984952 2019376 2019376 defendant ap Jenkyn Morgan cordwainer 588077 588077 ap Jenkyn, Morgan, of Oswestre, cordwainer 2
4006600 2027138 2027138 plaintiff Trevord John   588077 588077 Trevord, John, of Oswestre 1
4030493 2035564 2035564 plaintiff Edward David mercer 588077 588077 Edward, David, of Oswestre, mercer 0
4030494 2035564 2035564 defendant ap David Jevan glover 588077 588077 ap David, Jevan, of Oswestre, glover 0
4030495 2035564 2035564 defendant Gruffyth Robert mercer 588077 588077 Gruffyth, Robert, of Oswestre, mercer 1
4030496 2035564 2035564 defendant Phellyps Thomas dyer 588077 588077 Phellyps, Thomas, of Oswestre, dyer 2
4030497 2035564 2035564 defendant Trevelegh David ap John husbandman 588077 588077 Trevelegh, David ap John, of Oswestre, husbandman 3
4040306 2039039 2039039 defendant Mugleston William ap Hugh glover 588077 588077 Mugleston, William ap Hugh, of Oswestre, glover 2
4050368 2042563 2042563 defendant James Thomas shoemaker 588077 588077 James, Thomas, of Oswestre, shoemaker 0
4076478 2051883 2051883 defendant Thomas John yeoman 588077 588077 Thomas, John, of Oswestre, yeoman 4
4080200 2053229 2053229 defendant Salter Humphrey gent 588077 588077 Salter, Humphrey, of Oswestre, gent 1
4136948 2073562 2073562 defendant Tannatt Robert gent 588077 588077 Tannatt, Robert, of Oswestre, gent 0
4136949 2073562 2073562 defendant Tannatt Richard gent 588077 588077 Tannatt, Richard, of Oswestre, gent 1
4151249 2078559 2078559 defendant Burley Robert mercer 588077 588077 Burley, Robert, of Oswestre, mercer 0
4160640 2081796 2081796 defendant Blodwell John gent 588077 588077 Blodwell, John, of Oswestre, gent 0
4160641 2081796 2081796 defendant ap Meredithe Rice ap John gent 588077 588077 ap Meredithe, Rice ap John, of Oswestre, gent 1
4161276 2082027 2082027 defendant Tannatt Robert gent 588077 588077 Tannatt, Robert, of Oswestre, gent 0
4161277 2082027 2082027 defendant Tannatt Richard gent 588077 588077 Tannatt, Richard, of Oswestre, gent 1
4357808 2149971 2149971 defendant Jones Edward draper 588077 588077 Jones, Edward, of Oswestre, draper 0
4584387 2226533 2226533 defendant Heuster Richard   588077 588077 Heuster, Richard, of Oswestre 1
4750840 2280728 2280728 defendant Vagheon John merchant 588077 588077 Vagheon, John, of Oswestre, merchant 2
4750841 2280728 2280728 defendant Tloyd John merchant 588077 588077 Tloyd, John, of Oswestre, merchant 3
4807688 2298595 2298595 defendant Bulle John   588077 588077 Bulle, John, of Oswestre, Shrops chapman 0
4889196 2323408 2323408 defendant Lloyt John gent 588077 588077 Lloyt, John, of Oswestre, gent 1
5032770 2366474 2366474 defendant Wall John chapman 588077 588077 Wall, John, of Oswestre, chapman 1
5032788 2366477 2366477 defendant Wall John chapman 588077 588077 Wall, John, of Oswestre, chapman 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);