names

15 rows where place_id = 654966

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3934440 2001813 2001813 defendant Bradley George butcher 654966 654966 Bradley, George, of Sturbridge, butcher 0
4069825 2049490 2049490 defendant Gregorye Leonard yeoman 654966 654966 Gregorye, Leonard, of Sturbridge, yeoman 2
4172982 2086003 2086003 defendant Harrys Richard shoemaker 654966 654966 Harrys, Richard, of Sturbridge, shoemaker 0
4176118 2087121 2087121 defendant Hassold John yeoman 654966 654966 Hassold, John, of Sturbridge, yeoman 3
4217464 2101601 2101601 defendant Burcott John carpenter 654966 654966 Burcott, John, of Sturbridge, carpenter 2
4217465 2101601 2101601 defendant Lem Robert laborer 654966 654966 Lem, Robert, of Sturbridge, laborer 3
4232681 2106936 2106936 defendant Hassold John   654966 654966 Hassold, John, of Sturbridge yeoman 2
4246349 2111757 2111757 defendant Heathe John   654966 654966 Heathe, John, of Sturbridge, yeoman, or of Sedgley, Staffs, scythe smith 0
4310503 2133826 2133826 defendant Alchurche Richard schoolmaster 654966 654966 Alchurche, Richard, of Sturbridge, schoolmaster 2
4310510 2133829 2133829 defendant Alchurch Richard schoolmaster 654966 654966 Alchurch, Richard, of Sturbridge, schoolmaster 1
4310549 2133840 2133840 defendant Smyth Owen glover 654966 654966 Smyth, Owen, of Sturbridge, glover 3
4312712 2134578 2134578 defendant Coxe William shoemaker 654966 654966 Coxe, William, of Sturbridge, shoemaker 1
4338802 2143325 2143325 defendant Staunton Richard saddler 654966 654966 Staunton, Richard, of Sturbridge, saddler 0
4344125 2145226 2145226 defendant Elcock John mercer 654966 654966 Elcock, John, of Sturbridge, or of Worcester, mercer 1
4388037 2160629 2160629 defendant Staunton Richard   654966 654966 Staunton, Richard, of Sturbridge 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);