names

20 rows where place_id = 607228

✎ 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
3668283 1916025 1916025 defendant Northorp William yeoman 607228 607228 Northorp, William, of Manyngham, yeoman 0
3680315 1919920 1919920 defendant Northorp William yeoman 607228 607228 Northorp, William, of Manyngham, yeoman 0
3836089 1969201 1969201 defendant Illyngworth John smith 607228 607228 Illyngworth, John, of Manyngham, smith 0
3836090 1969201 1969201 defendant Scoles Henry laborer 607228 607228 Scoles, Henry, of Manyngham, laborer 1
3836092 1969201 1969201 defendant Rodes Tristran laborer 607228 607228 Rodes, Tristran, of Manyngham, laborer 3
3839255 1970206 1970206 defendant Illyngworth John yeoman 607228 607228 Illyngworth, John, of Manyngham, yeoman 0
4071544 2050117 2050117 plaintiff Mydgley John clothier 607228 607228 Mydgley, John, of Manyngham, clothier 0
4127934 2070281 2070281 defendant Midgeley John yeoman 607228 607228 Midgeley, John, of Manyngham, yeoman 2
4151362 2078598 2078598 defendant Mydgley John yeoman 607228 607228 Mydgley, John, of Manyngham, yeoman 2
4725395 2273236 2273236 defendant Lyon Adam butcher 607228 607228 Lyon, Adam, of Manyngham, butcher 0
4745232 2279112 2279112 defendant Smyth John yeoman 607228 607228 Smyth, John, of Manyngham, yeoman 0
4770459 2286734 2286734 defendant Smyth John yeoman 607228 607228 Smyth, John, of Manyngham, yeoman 2
4812892 2300144 2300144 defendant Smyuth John yeoman 607228 607228 Smyuth, John, of Manyngham, yeoman 1
4854281 2312749 2312749 defendant del Grene William husbandman 607228 607228 del Grene, William, of Manyngham, husbandman 1
4854282 2312749 2312749 defendant atte Yate Geoffrey husbandman 607228 607228 atte Yate, Geoffrey, of Manyngham, husbandman 2
4854283 2312749 2312749 defendant atte Yate William husbandman 607228 607228 atte Yate, William, of Manyngham, husbandman 3
5450824 2490134 2490134 defendant Hakeworth Christopher tailor 607228 607228 Hakeworth, Christopher, of Manyngham, tailor 0
5463106 2493879 2493879 defendant Hakeworth Christopher tailor 607228 607228 Hakeworth, Christopher, of Manyngham, tailor 0
5474470 2497347 2497347 defendant Hakeworth Christopher tailor 607228 607228 Hakeworth, Christopher, of Manyngham, tailor 0
5474720 2497421 2497421 defendant H_ Christopher tailor 607228 607228 H_, Christopher, of Manyngham, tailor 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);