names

35 rows where place_id = 619125

✎ 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
3728251 1935094 1935094 defendant Edward John yeoman 619125 619125 Edward, John, of Oswester, yeoman 10
3823821 1965338 1965338 defendant Lloid Edward gent 619125 619125 Lloid, Edward, of Oswester, gent 1
3823822 1965338 1965338 defendant ap Meredith Jenn Lloid gent 619125 619125 ap Meredith, Jenn Lloid, of Oswester, gent 2
3823823 1965338 1965338 defendant ap Meredith Thomas gent 619125 619125 ap Meredith, Thomas, of Oswester, gent 3
3823834 1965339 1965339 defendant ap Mered John Lloid gent 619125 619125 ap Mered, John Lloid, of Oswester, gent 1
3823835 1965339 1965339 defendant Lloid Edward gent 619125 619125 Lloid, Edward, of Oswester, gent 2
3823836 1965339 1965339 defendant Lloid David ap Thomas gent 619125 619125 Lloid, David ap Thomas, of Oswester, gent 3
3823837 1965339 1965339 defendant Tobert William gent 619125 619125 Tobert, William, of Oswester, gent 4
3823846 1965340 1965340 defendant Lloid Robert gent 619125 619125 Lloid, Robert, of Oswester, gent 1
3823847 1965340 1965340 defendant Lloid John gent 619125 619125 Lloid, John, of Oswester, gent 2
3823848 1965340 1965340 defendant Lloid Edward gent 619125 619125 Lloid, Edward, of Oswester, gent 3
3823849 1965340 1965340 defendant ap Rice Richard Vichan gent 619125 619125 ap Rice, Richard Vichan, of Oswester, gent 4
3823850 1965340 1965340 defendant Irlond Randolph gent 619125 619125 Irlond, Randolph, of Oswester, gent 5
3823851 1965340 1965340 defendant Vichun John ap David mercer 619125 619125 Vichun, John ap David, of Oswester, mercer 6
3823852 1965340 1965340 defendant Swynerton Richard sherman 619125 619125 Swynerton, Richard, of Oswester, sherman 7
3823853 1965340 1965340 defendant ap Gru Lewis weaver 619125 619125 ap Gru, Lewis, of Oswester, weaver 8
3823872 1965342 1965342 defendant Trevour William gent 619125 619125 Trevour, William, of Oswester, gent 1
3823873 1965342 1965342 defendant ap Guttyn John ap David gent 619125 619125 ap Guttyn, John ap David, of Oswester, gent 2
3823874 1965342 1965342 defendant ap William John ap Mered yeoman 619125 619125 ap William, John ap Mered, of Oswester, yeoman 3
3823875 1965342 1965342 defendant ap William Richardn ap Mered yeoman 619125 619125 ap William, Richardn ap Mered, of Oswester, yeoman 4
3857298 1975916 1975916 defendant ap Meredeth Edward mercer 619125 619125 ap Meredeth, Edward, of Oswester, mercer 2
3873234 1981264 1981264 defendant ap Thomas Meredyth gent 619125 619125 ap Thomas, Meredyth, of Oswester, gent 2
3882008 1984242 1984242 defendant Lee Hugh glover 619125 619125 Lee, Hugh, of Oswester, glover 1
3909802 1993586 1993586 defendant Morys Thomas glover 619125 619125 Morys, Thomas, of Oswester, glover 2
3915395 1995516 1995516 defendant Draper Thomas yeoman 619125 619125 Draper, Thomas, of Oswester, yeoman 5
3960091 2010630 2010630 plaintiff Stanney John draper 619125 619125 Stanney, John, of Oswester, draper 0
3960093 2010631 2010631 plaintiff Stanney John draper 619125 619125 Stanney, John, of Oswester, draper 0
3960095 2010631 2010631 defendant vergh John Eleanor widow of Roger ap Thomas alias Gor 619125 619125 vergh John, Eleanor, of Oswester, widow of Roger ap Thomas alias Gor 1
4083074 2054241 2054241 defendant Vaughan John ap Howell shoemaker 619125 619125 Vaughan, John ap Howell, of Oswester, shoemaker 0
4083075 2054241 2054241 defendant George Edward ap Richard yeoman 619125 619125 George, Edward ap Richard, of Oswester, yeoman 1
4100144 2060384 2060384 defendant ap David Thomas weaver 619125 619125 ap David, Thomas, of Oswester, yeoman, weaver 0
4100145 2060384 2060384 defendant ap Robert Thomas   619125 619125 ap Robert, Thomas, of Oswester, yeoman, linen draper 1
4152368 2078938 2078938 defendant Edward John gent 619125 619125 Edward, John, of Oswester, gent 0
4221053 2102858 2102858 defendant Meredith Hugh Salop, gent 619125 619125 Meredith Hugh, of Oswester, Salop, gent 0
4223119 2103575 2103575 defendant Vaughan John Lloyd   619125 619125 Vaughan, John Lloyd, of Oswester Draper 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);