names

33 rows where place_id = 612025

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3691161 1923398 1923398 defendant Bowde Hugh dyer 612025 612025 Bowde, Hugh, of Lichfeld, Staffs, dyer 1
3829454 1967095 1967095 defendant Snede Ralph clerk 612025 612025 Snede, Ralph, of Lichfeld, Staffs, clerk 0
3857102 1975853 1975853 defendant Henkley William dyer 612025 612025 Henkley, William, of Lichfeld, Staffs, dyer 0
3957682 2009747 2009747 defendant Olyve John fishmonger 612025 612025 Olyve, John, of Lichfeld, Staffs, fishmonger 1
3967511 2013272 2013272 defendant Staunton Thomas gent 612025 612025 (Staunton, Thomas, of Lichfeld, Staffs, gent 1
3990540 2021368 2021368 defendant Mastergent Thomas mercer 612025 612025 Mastergent, Thomas, of Lichfeld, Staffs, mercer 0
3993120 2022288 2022288 defendant Mastergent Richard mercer 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, mercer 0
3997570 2023879 2023879 defendant Mastergent Richard mercer 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, mercer 0
3998019 2024050 2024050 defendant Mastergent Richard mercer 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, mercer 0
4001823 2025426 2025426 defendant Plomer Robert yeoman 612025 612025 Plomer, Robert, of Lichfeld, Staffs, yeoman 0
4018841 2031468 2031468 defendant Boulte Thomas clerk 612025 612025 Boulte, Thomas, of Lichfeld, Staffs, clerk 0
4026521 2034136 2034136 defendant Mastergent Richard chapman 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, chapman 0
4027309 2034415 2034415 defendant Omersley or Hamerslie William vintner 612025 612025 Omersley or Hamerslie, William, of Lichfeld, Staffs, vintner 0
4027313 2034417 2034417 defendant Margent Richard mercer 612025 612025 Margent, Richard, of Lichfeld, Staffs, mercer 0
4027315 2034418 2034418 defendant Plomer Robert chapman 612025 612025 Plomer, Robert, of Lichfeld, Staffs, chapman 0
4037247 2037986 2037986 defendant Weston James gent 612025 612025 Weston, James, of Lichfeld, Staffs, gent 0
4037250 2037987 2037987 defendant Weston James gent 612025 612025 Weston, James, of Lichfeld, Staffs, gent 0
4042337 2039742 2039742 defendant Mastergent Richard mercer 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, mercer 0
4047689 2041620 2041620 defendant Bolte Thomas   612025 612025 Bolte, Thomas, of Lichfeld, Staffs 0
4057704 2045139 2045139 defendant Davys Richard tucker 612025 612025 Davys, Richard, of Lichfeld, Staffs, tucker 0
4057710 2045142 2045142 defendant Davys William clerk 612025 612025 Davys, William, of Lichfeld, Staffs, clerk 0
4058976 2045605 2045605 defendant Baylye John gent 612025 612025 Baylye, John, of Lichfeld, Staffs, gent 0
4059408 2045757 2045757 defendant Shawcrosse James gent 612025 612025 Shawcrosse, James, of Lichfeld, Staffs, gent 0
4065660 2048006 2048006 defendant Mastergent Richard chapman 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, chapman 0
4070550 2049761 2049761 defendant Bolte Thomas   612025 612025 Bolte, Thomas, of Lichfeld, Staffs, clerk, prebendary in Lichfield Cathedral 0
4075035 2051372 2051372 defendant Mastergent Thomas mercer 612025 612025 Mastergent, Thomas, of Lichfeld, Staffs, mercer 0
4077816 2052363 2052363 defendant Mastergent Richard chapman 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, chapman 0
4077818 2052364 2052364 defendant Mastergent Richard mercer 612025 612025 Mastergent, Richard, of Lichfeld, Staffs, mercer 0
4082589 2054079 2054079 defendant Plumer Isabel widow 612025 612025 Plumer, Isabel, of Lichfeld, Staffs, widow 0
4981730 2351453 2351453 defendant Blaby John fisher 612025 612025 Blaby, John, of Lichfeld, Staffs, fisher 2
5388770 2471848 2471848 defendant Swyfte Thomas mercer 612025 612025 Swyfte, Thomas, of Lichfeld, Staffs, mercer 0
5401427 2475474 2475474 defendant Swyfte Thomas mercer 612025 612025 Swyfte, Thomas, of Lichfeld, Staffs, mercer 0
5414406 2479247 2479247 defendant Swyfte Thomas mercer 612025 612025 Swyfte, Thomas, of Lichfeld, Staffs, mercer 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);