names

23 rows where place_id = 597973

✎ 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
3630592 1904397 1904397 defendant Myddylton Thomas yeoman 597973 597973 Myddylton, Thomas, of Lychfeld, yeoman 1
3756852 1944116 1944116 defendant Clerke William   597973 597973 Clerke, William, of Lychfeld, tallow chandler 0
3791357 1955133 1955133 defendant Parkes John tanner 597973 597973 Parkes, John, of Lychfeld, tanner 0
3828645 1966838 1966838 plaintiff Rocheforth Thomas   597973 597973 Rocheforth, Thomas, of Lychfeld 1
3885792 1985500 1985500 defendant Mogge Thomas yeoman 597973 597973 Mogge, Thomas, of Lychfeld, yeoman 2
3895753 1988788 1988788 defendant Tyler Peter butcher 597973 597973 Tyler, Peter, of Lychfeld, butcher 0
3929874 2000333 2000333 defendant Handcocke Edmund vintner 597973 597973 Handcocke, Edmund, of Lychfeld, vintner 0
4635812 2242044 2242044 defendant Admanston Richard de clerk 597973 597973 Admanston, Richard de, of Lychfeld, clerk 0
4817695 2301620 2301620 defendant Pykstoke John yeoman 597973 597973 Pykstoke, John, of Lychfeld, yeoman 0
4817782 2301644 2301644 defendant Bynhore Robert chaplain 597973 597973 Bynhore, Robert, of Lychfeld, chaplain 2
4872018 2318218 2318218 defendant Strangulford John mercer 597973 597973 Strangulford, John, of Lychfeld, mercer 1
4872044 2318219 2318219 defendant Strangulford John mercer 597973 597973 Strangulford, John, of Lychfeld, mercer 7
4899854 2326591 2326591 plaintiff Verney John   597973 597973 Verney, John, of Lychfeld 0
4969319 2347783 2347783 defendant Kyrkeby William yeoman 597973 597973 Kyrkeby, William, of Lychfeld, yeoman 2
5078797 2380146 2380146 defendant Huchones Robert dyer 597973 597973 Huchones, Robert, of Lychfeld, dyer 0
5198102 2415190 2415190 defendant Stikbuk Thomas chaplain 597973 597973 Stikbuk, Thomas, of Lychfeld, chaplain 0
5312179 2448676 2448676 defendant Wyllys Roger clerk 597973 597973 Wyllys, Roger, of Lychfeld, clerk 0
5336927 2456113 2456113 defendant Nevenson alias Welker Mathew fuller or yeoman 597973 597973 Nevenson alias Welker, Mathew, of Lychfeld, fuller or yeoman 0
5401423 2475472 2475472 defendant Whitlawe Richard tailor 597973 597973 Whitlawe, Richard, of Lychfeld, tailor 1
5414413 2479249 2479249 defendant Swyfte Thomas mercer 597973 597973 Swyfte, Thomas, of Lychfeld, mercer 0
5430218 2483977 2483977 defendant Whitlawe Richard tailor 597973 597973 Whitlawe, Richard, of Lychfeld, tailor 1
5430221 2483978 2483978 defendant Whytlawe Richard tailor 597973 597973 Whytlawe, Richard, of Lychfeld, tailor 1
5453291 2490867 2490867 defendant Colt Thomas   597973 597973 Colt, Thomas, of Lychfeld 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);