names

31 rows where place_id = 614456

✎ 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
3703757 1927454 1927454 defendant Brigge William innholder 614456 614456 Brigge, William, of Kighley, innholder 0
3727178 1934773 1934773 plaintiff Wadsworthe John (legal representative) 614456 614456 Wadsworthe, John, of Kighley, executors of 0
3796600 1956810 1956810 defendant Lacook Thomas yeoman 614456 614456 Lacook, Thomas, of Kighley, yeoman 0
4071123 2049977 2049977 defendant Sugden John clothier 614456 614456 Sugden, John, of Kighley, clothier 1
4092361 2057570 2057570 defendant Butterfeld William clothier 614456 614456 Butterfeld, William, of Kighley, clothier 0
4092362 2057570 2057570 defendant Sugden John, junior husbandman 614456 614456 Sugden, John, junior, of Kighley, husbandman 1
4092365 2057571 2057571 defendant Sugden Thomas clothier 614456 614456 Sugden, Thomas, of Kighley, clothier 1
4092368 2057572 2057572 defendant Watson Thomas yeoman 614456 614456 Watson, Thomas, of Kighley, yeoman 1
4092370 2057573 2057573 defendant Sugden John, senior sherman 614456 614456 Sugden, John, senior, of Kighley, sherman 0
4092371 2057573 2057573 defendant Sugden Edward   614456 614456 Sugden, Edward, of Kighley 1
4159285 2081318 2081318 defendant Hall Miles laborer 614456 614456 Hall, Miles, of Kighley, laborer 1
4222269 2103279 2103279 defendant Shackleton Richard clothier 614456 614456 Shackleton, Richard, of Kighley, clothier 3
4271825 2120152 2120152 defendant Royd Robert husbandman 614456 614456 Royd, Robert, of Kighley, husbandman 2
4289038 2126137 2126137 defendant Paslewe John clothier 614456 614456 Paslewe, John, of Kighley, clothier 0
4289052 2126142 2126142 defendant Paslewe John clothier 614456 614456 Paslewe, John, of Kighley, clothier 0
4310040 2133669 2133669 defendant Bethomley Thomas yeoman 614456 614456 Bethomley, Thomas, of Kighley, yeoman 2
4353429 2148422 2148422 defendant Butler Robert clothier 614456 614456 Butler, Robert, of Kighley, clothier 0
4405449 2166402 2166402 defendant Paslewe Edmund husbandman 614456 614456 Paslewe, Edmund, of Kighley, husbandman 0
4405450 2166402 2166402 defendant More John husbandman 614456 614456 More, John, of Kighley, husbandman 1
4405451 2166402 2166402 defendant Midgley William husbandman 614456 614456 Midgley, William, of Kighley, husbandman 2
4407183 2166966 2166966 defendant Exley John blacksmith 614456 614456 Exley, John, of Kighley, yeoman, blacksmith 0
4865453 2316159 2316159 defendant Kighley Hugh gent 614456 614456 Kighley, Hugh, of Kighley, gent 4
5382502 2470053 2470053 defendant Underwode John, senior yeoman 614456 614456 Underwode, John, senior, of Kighley, yeoman 0
5389604 2472088 2472088 defendant Underwode John, senior yeoman 614456 614456 Underwode, John, senior, of Kighley, yeoman 0
5389605 2472088 2472088 defendant Brige John yeoman 614456 614456 Brige, John, of Kighley, yeoman 1
5389606 2472088 2472088 defendant Bynnys John husbandman 614456 614456 Bynnys, John, of Kighley, husbandman 2
5402347 2475744 2475744 defendant Brige John yeoman 614456 614456 Brige, John, of Kighley, yeoman 1
5402452 2475771 2475771 defendant Brige John yeoman 614456 614456 Brige, John, of Kighley, yeoman 1
5402453 2475771 2475771 defendant Dymmys John husbandman 614456 614456 Dymmys, John, of Kighley, husbandman 2
5431972 2484532 2484532 defendant Shay William yeoman 614456 614456 Shay, William, of Kighley, yeoman 1
5581008 2529132 2529132 defendant Hudson Robert yeroman 614456 614456 Hudson, Robert, of Kighley, yeroman 1

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