names

25 rows where place_id = 647439

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3896175 1988923 1988923 defendant Jonys David gent 647439 647439 Jonys, David, of Chepstowe, Monmouth, gent 0
3910439 1993809 1993809 defendant Jonys David gent 647439 647439 Jonys, David, of Chepstowe, Monmouth, gent 0
3924276 1998427 1998427 defendant Johns David gent 647439 647439 Johns, David, of Chepstowe, Monmouth, gent 0
3985174 2019453 2019453 defendant Lewes Philip gent 647439 647439 Lewes, Philip, of Chepstowe, Monmouth, gent 1
3999719 2024661 2024661 defendant Somersett Thomas esq 647439 647439 Somersett, Thomas, of Chepstowe, Monmouth, esq 0
3999722 2024661 2024661 defendant William Jenkin yeoman 647439 647439 William, Jenkin, of Chepstowe, Monmouth, yeoman 3
4016521 2030616 2030616 plaintiff Strobrydge Richard   647439 647439 Strobrydge, Richard, of Chepstowe, Monmouth 0
4016541 2030622 2030622 plaintiff Strowbrydge Richard merchant 647439 647439 Strowbrydge, Richard, of Chepstowe, Monmouth, merchant 0
4022709 2032844 2032844 defendant Harberte Lewis   647439 647439 Harberte, Lewis, of Chepstowe, Monmouth, gebt 0
4081669 2053747 2053747 defendant Godwyn Thomas butcher 647439 647439 Godwyn, Thomas, of Chepstowe, Monmouth, butcher 0
4125945 2069560 2069560 defendant Jones Richard yeoman 647439 647439 Jones, Richard, of Chepstowe, Monmouth, yeoman 0
4130344 2071162 2071162 defendant Walter Thomas husbandman 647439 647439 (Walter, Thomas, of Chepstowe, Monmouth, husbandman 1
4130346 2071162 2071162 defendant Jeyne or Jeyney John merchant 647439 647439 Jeyne or Jeyney, John, of Chepstowe, Monmouth, merchant 3
4130691 2071288 2071288 defendant Herbert Lewis gent 647439 647439 Herbert, Lewis, of Chepstowe, Monmouth, gent 3
4140159 2074725 2074725 defendant Buriett William vintner 647439 647439 Buriett, William, of Chepstowe, Monmouth, vintner 0
4143730 2075966 2075966 defendant Herbert Lewis gent 647439 647439 Herbert, Lewis, of Chepstowe, Monmouth, gent 0
4149089 2077804 2077804 defendant Jones Richard yeoman 647439 647439 Jones, Richard, of Chepstowe, Monmouth, yeoman 0
4245666 2111531 2111531 defendant Braye Edward husbandman 647439 647439 Braye, Edward, of Chepstowe, Monmouth, husbandman 2
4250257 2113067 2113067 defendant Pynner John yeoman 647439 647439 Pynner, John, of Chepstowe, Monmouth, yeoman 0
4261058 2116664 2116664 defendant Jones Thomas tailor 647439 647439 Jones, Thomas, of Chepstowe, Monmouth, tailor 0
4264543 2117783 2117783 defendant Pynner John yeoman 647439 647439 Pynner, John, of Chepstowe, Monmouth, yeoman 0
4272252 2120289 2120289 defendant Jones Thomas tailor 647439 647439 Jones, Thomas, of Chepstowe, Monmouth, tailor 0
4272254 2120290 2120290 defendant Jones Thomas tailor 647439 647439 Jones, Thomas, of Chepstowe, Monmouth, tailor 0
4372741 2155327 2155327 defendant Jones Henry gent 647439 647439 Jones, Henry, of Chepstowe, Monmouth, gent 1
4392069 2161975 2161975 defendant Partrydge William shoemaker 647439 647439 Partrydge, William, of Chepstowe, Monmouth, shoemaker 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);