names

15 rows where place_id = 630011

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3792005 1955350 1955350 defendant Gryffyth Hugh gent 630011 630011 Gryffyth, Hugh, of Radnor, gent 3
3897081 1989244 1989244 defendant Bell Stephen gent 630011 630011 Bell, Stephen, of Radnor, gent 0
3902016 1990903 1990903 defendant Davyes John clerk 630011 630011 Davyes, John, of Radnor, clerk 0
3902017 1990903 1990903 defendant Knyll John husbandman 630011 630011 Knyll, John, of Radnor, husbandman 1
3932844 2001276 2001276 defendant Lewys Richard gent 630011 630011 Lewys, Richard, of Radnors, gent 38
3938954 2003361 2003361 defendant Luntley John yeoman 630011 630011 Luntley, John, of Radnor, Radnors, yeoman 0
3938955 2003361 2003361 defendant Luntley Philip yeoman 630011 630011 Luntley, Philip, of Radnor, yeoman 1
4008520 2027813 2027813 defendant Jones Hugh (legal representative) 630011 630011 Jones, Hugh, of Radnor, husbandman, executors of 5
4008529 2027814 2027814 defendant Jones Hugh (legal representative) 630011 630011 Jones, Hugh, of Radnor, husbandman, executors of 5
4159538 2081405 2081405 defendant Myles John yeoman 630011 630011 Myles, John, of Radnor, yeoman 0
4159634 2081438 2081438 defendant Myles John yeoman 630011 630011 Myles, John, of Radnor, yeoman 0
4176631 2087300 2087300 defendant Hobby George gent 630011 630011 Hobby, George, of Radnor, gent 1
4218238 2101882 2101882 defendant Davies Hugh yeoman 630011 630011 Davies, Hugh, of Radnor, yeoman 3
4227474 2105090 2105090 defendant Davies Hugh yeoman 630011 630011 Davies, Hugh, of Radnor, yeoman 3
4330926 2140643 2140643 defendant Gytto John yeoman 630011 630011 Gytto, John, of Radnor, yeoman 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);