names

22 rows where place_id = 602282

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593288 1865532 1865532 defendant Molle Hugh (legal representative) 602282 602282 Molle, Hugh, of Staffs, gent, executors of 1
3649285 1910165 1910165 defendant Sterton John drover 602282 602282 Sterton, John, of Staffs, drover 0
3946263 2005769 2005769 defendant Pattrick William butcher 602282 602282 Pattrick, William, of Staffs, butcher 0
3963045 2011673 2011673 plaintiff Woodward Gregory drover 602282 602282 Woodward, Gregory, of Staffs, drover 0
3979991 2017606 2017606 defendant Cumberforde Thomas esq 602282 602282 Cumberforde, Thomas, of Staffs, esq 0
4007748 2027555 2027555 defendant Draycott Philip gent 602282 602282 Draycott, Philip, of Mason Rydware, Staffs, gent 1
4038023 2038244 2038244 defendant Fletcher Thomas husbandman 602282 602282 Fletcher, Thomas, of Staffs, husbandman 2
4108478 2063288 2063288 defendant Godwyn Edward chapman 602282 602282 Godwyn, Edward, of Abbot Bromley, Staffs, chapman 0
4115590 2065860 2065860 defendant Chambers William mercer 602282 602282 Chambers, William, of Abbot Bromley, Staffs, mercer 1
4193561 2093316 2093316 defendant Bowes Richard gent 602282 602282 Bowes, Richard, of Staffs, gent 1
4317926 2136381 2136381 defendant Bank Robert cutler 602282 602282 Bank, Robert, of Staffs, cutler 0
4516871 2205679 2205679 defendant Pentryth John   602282 602282 Pentryth, John, of Staffs 4
4657181 2248131 2248131 defendant Bodylle John esq 602282 602282 Bodylle, John, of Staffs, or of London, esq 4
4657187 2248132 2248132 defendant Bodylle John esq 602282 602282 Bodylle, John, of Staffs, or of London, esq 4
4945505 2340573 2340573 defendant Chyrke Lawrence drover 602282 602282 Chyrke, Lawrence, of Staffs, drover 2
4954391 2343280 2343280 defendant Harle Richard husbandman 602282 602282 Harle, Richard, of Staffs, husbandman 2
4958994 2344657 2344657 defendant Swanne John chaplain 602282 602282 Swanne, John, of Staffs, chaplain 0
4973706 2349088 2349088 defendant Arblaster Thomas esq 602282 602282 Arblaster, Thomas, of Staffs, or of London, esq 0
4973810 2349123 2349123 defendant Arblaster Edmund esq 602282 602282 Arblaster, Edmund, of Staffs, or of Newenton, Surrey, esq 0
5016421 2361695 2361695 plaintiff Mosley Richard gent 602282 602282 Mosley, Richard, of Staffs, gent 1
5090447 2383585 2383585 plaintiff Maryot John merchant 602282 602282 Maryot, John, of Staffs, merchant 0
5238649 2426898 2426898 defendant Pulesdon John barker 602282 602282 Pulesdon, John, of Abbot Bromley, Staffs, barker 2

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