names

23 rows where place_id = 646986

✎ 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
3893817 1988153 1988153 defendant Markys John tucker 646986 646986 Markys, John, of Ilmyster, Soms, tucker 0
3932304 2001108 2001108 defendant Shyrwod George chapman 646986 646986 Shyrwod, George, of Ilmyster, Soms, chapman 0
3994390 2022747 2022747 defendant Syddenham George gent 646986 646986 Syddenham, George, of Ilmyster, Soms, gent 0
4000362 2024896 2024896 defendant Greynfyld Henry gent 646986 646986 Greynfyld, Henry, of Ilmyster, Soms, gent 0
4026580 2034158 2034158 defendant Coxe John clothier 646986 646986 Coxe, John, of Ilmyster, Soms, clothier 1
4026585 2034159 2034159 defendant Coxe John clothier 646986 646986 Coxe, John, of Ilmyster, Soms, clothier 1
4039809 2038852 2038852 defendant Coxe John clothier 646986 646986 Coxe, John, of Ilmyster, Soms, clothier 0
4042695 2039863 2039863 defendant Rosseter John, junior weaver 646986 646986 Rosseter, John, junior, of Ilmyster, Soms, weaver 0
4059020 2045622 2045622 defendant Cary John husbandman 646986 646986 Cary, John, of Ilmyster, Soms, husbandman 0
4060429 2046131 2046131 defendant Charde John yeoman 646986 646986 Charde, John, of Ilmyster, Soms, or of Burteporte, Dorset, yeoman 0
4181837 2089127 2089127 defendant Collyns William   646986 646986 Collyns, William, of Ilmyster, Soms, linen draper 0
4228328 2105389 2105389 defendant Godbeare John clothier 646986 646986 Godbeare, John, of Ilmyster, Soms, clothier 0
4243214 2110723 2110723 defendant Hubball James gent 646986 646986 Hubball, James, of Ilmyster, Soms, gent 0
4243218 2110724 2110724 defendant Hubball James gent 646986 646986 Hubball, James, of Ilmyster, Soms, gent 0
4267592 2118793 2118793 defendant Hellyer Thomas tailor 646986 646986 Hellyer, Thomas, of Ilmyster, Soms, tailor 0
4359138 2150432 2150432 defendant Armestronge Leonard tailor 646986 646986 Armestronge, Leonard, of Ilmyster, Soms, tailor 0
4858348 2313982 2313982 defendant Mayn Richard dyer 646986 646986 Mayn, Richard, of Ilmyster, Soms, dyer 1
5115355 2390918 2390918 defendant Brode Thomas tucker 646986 646986 Brode, Thomas, of Ilmyster, Soms, tucker 2
5160109 2404056 2404056 defendant Symon John   646986 646986 Symon, John, of Ilmyster, Soms, glove maker 2
5213640 2419723 2419723 defendant Gardener Roger husbandman 646986 646986 Gardener, Roger, of Ilmyster, Soms, husbandman 2
5346342 2459001 2459001 defendant Parker Henry glover 646986 646986 Parker, Henry, of Ilmyster, Soms, glover 0
5486289 2500788 2500788 defendant Balde John mercer 646986 646986 Balde, John, of Ilmyster, Soms, mercer 0
5576894 2527818 2527818 defendant Ragdall Stephen merchant 646986 646986 Ragdall, Stephen, of Ilmyster, Soms, merchant 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);