names

17 rows where place_id = 613185

✎ 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
3697042 1925298 1925298 defendant Kneshall William butcher 613185 613185 Kneshall, William, of Burton, Staffs, butcher 0
3697046 1925299 1925299 defendant Kneshall William butcher 613185 613185 Kneshall, William, of Burton, Staffs, butcher 0
3775502 1950079 1950079 defendant Wylkynson Thomas butcher 613185 613185 Wylkynson, Thomas, of Burton, Staffs, butcher 2
4103681 2061594 2061594 defendant Smythe John dyer 613185 613185 Smythe, John, of Burton, Staffs, dyer 3
4151160 2078531 2078531 defendant Hawkes John mercer 613185 613185 Hawkes, John, of Burton, Staffs, mercer 0
4166212 2083683 2083683 defendant Hawkes John mercer 613185 613185 Hawkes, John, of Burton, Staffs, mercer 0
4200203 2095624 2095624 defendant Dethick William gent 613185 613185 Dethick, William, of Burton, Staffs, gent 2
4205872 2097598 2097598 defendant Robynson Nicholas draper 613185 613185 Robynson, Nicholas, of Burton, Staffs, draper 0
5083503 2381567 2381567 defendant Lyng John merchant 613185 613185 Lyng, John, of Burton, Staffs, merchant 2
5152238 2401785 2401785 defendant Peyter John yeoman 613185 613185 Peyter, John, of Burton, Staffs, yeoman 2
5170112 2406987 2406987 defendant Peyter John yeoman 613185 613185 Peyter, John, of Burton, Staffs, yeoman 2
5181366 2410294 2410294 defendant Lynge John yeoman 613185 613185 Lynge, John, of Burton, Staffs, yeoman 1
5202656 2416537 2416537 defendant Lynge John   613185 613185 Lynge, John, of Burton, Staffs 1
5313896 2449178 2449178 defendant Bowede William mercer 613185 613185 Bowede, William, of Burton, Staffs, mercer 2
5386042 2471079 2471079 defendant Hiege Margery widow 613185 613185 Hiege, Margery, of Burton, Staffs, widow 3
5398266 2474574 2474574 defendant Hieye Margery widow 613185 613185 Hieye, Margery, of Burton, Staffs, widow 3
5411396 2478368 2478368 defendant Hiege Margery widow 613185 613185 Hiege, Margery, of Burton, Staffs, widow 3

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