names

28 rows where place_id = 642966

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3871234 1980633 1980633 defendant ap John Philip   642966 642966 ap John, Philip, of Oswestre, Salop, "friser" 0
3871238 1980634 1980634 defendant Vaughan John mercer 642966 642966 Vaughan, John, of Oswestre, Salop, mercer 0
3880917 1983889 1983889 defendant Philip David sherman 642966 642966 Philip, David, of Oswestre, Salop, sherman 0
3884691 1985154 1985154 defendant Stanney Thomas mercer 642966 642966 Stanney, Thomas, of Oswestre, Salop, mercer 1
3892537 1987749 1987749 defendant ap Rys John gent 642966 642966 ap Rys, John, of Oswestre, Salop, gent 0
3901660 1990784 1990784 defendant Meredith Edward chapman 642966 642966 Meredith, Edward, of Oswestre, Salop, chapman 0
3909800 1993586 1993586 defendant Kelam Thomas yeoman 642966 642966 Kelam, Thomas, of Oswestre, Salop, yeoman 0
3916616 1995932 1995932 defendant Draper Thomas   642966 642966 Draper, Thomas, of Oswestre, Salop, draper, son of Draper, John 0
3916621 1995933 1995933 defendant ap Rice John ap Thomas chapman 642966 642966 ap Rice, John ap Thomas, of Oswestre, Salop, chapman 0
3916626 1995934 1995934 defendant Draper Thomas   642966 642966 Draper, Thomas, of Oswestre, Salop, draper, son of Draper, John 0
3920835 1997313 1997313 defendant Lloyd Robert ap Evan gent 642966 642966 Lloyd, Robert ap Evan, of Oswestre, Salop, gent 0
3960092 2010630 2010630 defendant ap Rice Thomas gent 642966 642966 ap Rice, Thomas, of Oswestre, Salop, gent 0
3965280 2012473 2012473 plaintiff Barre Katherine daughter of Edward Draper 642966 642966 Katherine his wife, daughter of Edward Draper, of Oswestre, Salop, sister of John Draper, and sister of Richard Draper 1
3965896 2012690 2012690 defendant Lloyd Thomas yeoman 642966 642966 Lloyd, Thomas, of Oswestre, Salop, yeoman 0
3978608 2017094 2017094 defendant Edwardes John mercer 642966 642966 Edwardes, John, of Oswestre, Salop, mercer 0
3981903 2018287 2018287 defendant Jones Richard, senior gent 642966 642966 Jones, Richard, senior, of Oswestre, Salop, gent 0
3989403 2020949 2020949 defendant ap Meredeth John Wynne gent 642966 642966 ap Meredeth, John Wynne, of Oswestre, Salop, gent 0
3989407 2020950 2020950 defendant Edward John gent 642966 642966 Edward, John, of Oswestre, Salop, gent 0
4008255 2027720 2027720 defendant Muxton John Gowgh yeoman 642966 642966 Muxton, John Gowgh, of Oswestre, Salop, yeoman 2
4010595 2028564 2028564 defendant Jones Jevan gent 642966 642966 Jones, Jevan, of Oswestre, Salop, gent 8
4027077 2034329 2034329 defendant ap Robert Thomas baker 642966 642966 ap Robert, Thomas, of Oswestre, Salop, baker 0
4040304 2039039 2039039 defendant Edward John gent 642966 642966 Edward, John, of Oswestre, Salop, gent 0
4080199 2053229 2053229 defendant ap Edward Evan glover 642966 642966 ap Edward, Evan, of Oswestre, Salop, glover 0
4408535 2167441 2167441 defendant ap Richard Alexander smith 642966 642966 ap Richard, Alexander, of Oswestre, Salop, smith 0
4409617 2167814 2167814 defendant Lloyd John chapman 642966 642966 Lloyd, John, of Oswestre, Salop, chapman 0
4786393 2291786 2291786 defendant Vaughan John merchant 642966 642966 Vaughan, John, of Oswestre, Salop, merchant 3
5555461 2521600 2521600 defendant Pygot Richard grasier 642966 642966 Pygot, Richard, of Oswestre, Salop, grasier 2
5555466 2521601 2521601 defendant Pygot Richard frasier 642966 642966 Pygot, Richard, of Oswestre, Salop, frasier 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);