names

19 rows where place_id = 771139

✎ 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
3703965 1927522 1927522 defendant Whyng Richard mercer 771139 771139 Whyng, Richard, of Wymbourne Mynster, mercer 0
3872955 1981168 1981168 defendant Watman John tailor 771139 771139 Watman, John, of Wymbourne Mynster, tailor 0
3912152 1994389 1994389 defendant Wellys John butcher 771139 771139 Wellys, John, of Wymbourne Mynster, butcher 0
4574994 2223700 2223700 defendant Barbour John   771139 771139 Barbour, John, of Wymbourne Minster 0
4670822 2256554 2256554 defendant Boston alias Barbour John husbandman 771139 771139 Boston alias Barbour, John, of Wymbourne, husbandman 0
4819150 2302067 2302067 defendant Hille Edmund fletcher 771139 771139 Hille, Edmund, of Wymbourne Minster, fletcher 0
4851039 2311774 2311774 defendant Helye Simon haulier 771139 771139 Helye, Simon, of Wymbourne Minster, haulier 0
4931719 2336307 2336307 defendant Gedeney John shoemaker 771139 771139 Gedeney, John, of Wymbourne Minster, shoemaker 1
5109290 2389143 2389143 defendant Fote Thomas butcher 771139 771139 Fote, Thomas, of Wymbourne Mynster, butcher 0
5148869 2400792 2400792 defendant Laurens William butcher 771139 771139 Laurens, William, of Wymbourne MInster, butcher 0
5170214 2407016 2407016 defendant Laurens William butcher 771139 771139 Laurens, William, of Wymbourne MInster, butcher 0
5179595 2409767 2409767 defendant Mayn William dyer alias touker 771139 771139 Mayn, William, of Wymbourne, Minster, dyer alias touker 0
5201961 2416341 2416341 defendant Mayn William dyer alias fuller 771139 771139 Mayn, William, of Wymbourne Minster, dyer alias fuller 0
5275854 2438009 2438009 defendant Vyne Robert yeoman 771139 771139 Vyne, Robert, of Wymbourne Minster, yeoman 0
5460378 2493045 2493045 defendant Raule Richard butcher 771139 771139 Raule, Richard, of Wymbourne Minster, butcher 0
5460380 2493046 2493046 defendant Raule Richard butcher 771139 771139 Raule, Richard, of Wymbourne Minster, butcher 0
5460382 2493047 2493047 defendant Raule Richard butcher 771139 771139 Raule, Richard, of Wymbourne Minster, butcher 0
5568544 2525350 2525350 defendant Byrdam John mercer 771139 771139 Byrdam, John, of Wymbourne Mynster, mercer 2
5571766 2526283 2526283 defendant Worsley Roger gent 771139 771139 Worsley, Roger, of Wymbourne, gent 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);