names

29 rows where place_id = 588411

✎ 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
3594392 1865879 1865879 defendant Irton John gent 588411 588411 Irton, John, of Irton, gent 0
3594394 1865880 1865880 defendant Irton John gent 588411 588411 Irton, John, of Irton, gent 0
3637212 1906439 1906439 defendant Irton Richard gent 588411 588411 Irton, Richard, of Irton, Cumber, gent 0
3637215 1906440 1906440 defendant Irton Richard gent 588411 588411 Irton, Richard, of Irton, Cumber, gent 0
3637218 1906441 1906441 defendant Irton Richard gent 588411 588411 Irton, Richard, of Irton, Cumber, gent 0
3689679 1922931 1922931 defendant Irton Richard esq 588411 588411 Irton, Richard, of Irton, Cumber, esq 0
3692221 1923734 1923734 defendant Willis John chaplain 588411 588411 Willis, John, of Irton, chaplain 0
3780839 1951743 1951743 defendant Hoton Ralph husbandman 588411 588411 Hoton, Ralph, of Irton, husbandman 0
3842885 1971308 1971308 defendant Irton Richard gent 588411 588411 Irton, Richard, of Irton, Cumber, gent 1
3893076 1987930 1987930 defendant Smyth Henry yeoman and leadman 588411 588411 Smyth, Henry, of Irton, yeoman and leadman 0
4321795 2137710 2137710 defendant Parke Richard yeoman 588411 588411 Parke, Richard, of Irton, yeoman 0
4321805 2137715 2137715 defendant Mawson Giles yeoman 588411 588411 Mawson, Giles, of Irton, yeoman 0
4321806 2137715 2137715 defendant Luthatt Christopher yeoman 588411 588411 Luthatt, Christopher, of Irton, yeoman 1
4536398 2211668 2211668 defendant Husbond John   588411 588411 Husbond, John, of Irton 3
4765175 2285089 2285089 plaintiff Hubyn William   588411 588411 Hubyn, William, of Irton, parson 0
4765176 2285089 2285089 defendant Rappok William yeoman 588411 588411 Rappok, William, of Irton, yeoman 0
4768308 2286058 2286058 defendant Hay Robert collier 588411 588411 Hay, Robert, of Irton, collier 2
4789530 2292796 2292796 defendant Hobson Thomas clerk 588411 588411 Hobson, Thomas, of Irton, clerk 2
4791689 2293498 2293498 defendant Bee Oliver husbandman 588411 588411 Bee, Oliver, of Irton, husbandman 1
4867682 2316862 2316862 defendant Postelthwayt William merchant 588411 588411 Postelthwayt, William, of Irton, merchant 0
4867683 2316862 2316862 defendant Postelthwayt Robert merchant 588411 588411 Postelthwayt, Robert, of Irton, merchant 1
4886741 2322709 2322709 defendant Postilthwayt Robert yeoman 588411 588411 Postilthwayt, Robert, of Irton, Cumber, yeoman 1
4886742 2322709 2322709 defendant Shyrewynd Robert yeoman 588411 588411 Shyrewynd, Robert, of Irton, yeoman 2
5220166 2421602 2421602 defendant Taillour John tailor 588411 588411 Taillour, John, of Irton, tailor 11
5496360 2503816 2503816 plaintiff Irton William gent 588411 588411 Irton, William, of Irton, gent 0
5496361 2503816 2503816 defendant Irton John esq 588411 588411 Irton, John, of Irton, Cumber, esq 0
5518500 2510617 2510617 defendant Dey John husbandman 588411 588411 Dey, John, of Irton, husbandman 9
5518501 2510617 2510617 defendant Gratton Robert husbandman 588411 588411 Gratton, Robert, of Irton, husbandman 10
5631739 2553940 2553940 defendant Ryton William husbandman 588411 588411 Ryton, William, of irton, husbandman 3

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);