names

24 rows where place_id = 599437

✎ 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
3636782 1906293 1906293 defendant Gyll John yeoman 599437 599437 Gyll, John, of Yalmeton, yeoman 14
3649335 1910184 1910184 defendant Copleston John gent 599437 599437 Copleston, John, of Yalmeton, gent 0
3684951 1921427 1921427 defendant Elys John clerk 599437 599437 Elys, John, of Yalmeton, clerk 0
3768651 1947843 1947843 defendant Howell John laborer 599437 599437 Howell, John, of Yalmeton, laborer 1
3768652 1947843 1947843 defendant Kewys John husbandman 599437 599437 Kewys, John, of Yalmeton, husbandman 2
3799246 1957677 1957677 defendant Phelypp Geoffrey   599437 599437 Phelypp, Geoffrey, of Yalmeton, groom 3
3864085 1978171 1978171 defendant Copleston Thomas esq 599437 599437 Copleston, Thomas, of Yalmeton, esq 0
4060719 2046237 2046237 defendant Worthe John miller 599437 599437 Worthe, John, of Yalmeton, miller 0
4794375 2294385 2294385 defendant Pey Thomas yeoman 599437 599437 Pey, Thomas, of Yalmeton, yeoman 2
4801920 2296784 2296784 defendant Calman John merchant 599437 599437 Calman, John, of Yalmeton, merchant 1
4976402 2349905 2349905 defendant Mayde John tanner 599437 599437 Mayde, John, of Yalmeton, tanner 0
5155237 2402680 2402680 defendant Brokyng Robert husbandman 599437 599437 Brokyng, Robert, of Yalmeton, husbandman 1
5207072 2417806 2417806 defendant Brokyng Robert husbandman 599437 599437 Brokyng, Robert, of Yalmeton, husbandman 1
5230749 2424601 2424601 defendant Lemman Robert husbandman 599437 599437 Lemman, Robert, of Yalmeton, husbandman 0
5230752 2424602 2424602 defendant Helyer Ralph husbandman 599437 599437 Helyer, Ralph, of Yalmeton, husbandman 0
5274882 2437739 2437739 defendant Goolde Hugh yeoman 599437 599437 Goolde, Hugh, of Yalmeton, yeoman 1
5369766 2466134 2466134 defendant Prall Thomas husbandman 599437 599437 Prall, Thomas, of Yalmeton, husbandman 0
5437340 2486113 2486113 defendant Abraham John husbandman 599437 599437 Abraham, John, of Yalmeton, husbandman 0
5542981 2517925 2517925 defendant Pyttys John gent 599437 599437 Pyttys, John, of Yalmeton, gent 0
5561219 2523262 2523262 defendant Foterell John husbandman 599437 599437 Foterell, John, of Yalmeton, husbandman 0
5572878 2526619 2526619 defendant Lovet John yeoman 599437 599437 Lovet, John, of Yalmeton, yeoman 0
5582592 2529623 2529623 plaintiff Copleston John esq 599437 599437 Copleston, John, of Yalmeton, esq 7
5587863 2531214 2531214 defendant Lovet or Lonet John yeoman 599437 599437 Lovet or Lonet, John, of Yalmeton, yeoman 0
5598845 2534514 2534514 defendant Foterell John husbandman 599437 599437 Foterell, John, of Yalmeton, husbandman 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);