names

16 rows where place_id = 594406

✎ 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
3615983 1872635 1872635 defendant Cole John, junior smith 594406 594406 Cole, John, junior, of Dulverton, Soms, smith 0
3659222 1913140 1913140 defendant Mershe John husbandman 594406 594406 Mershe, John, of Dulverton, Soms, husbandman 0
3879751 1983485 1983485 defendant Ford William   594406 594406 Ford, William, of Dulverton, Soms, husbandman, son of Ford, William, of Morchard Bishop 0
3943259 2004765 2004765 defendant Lane William Dorothy widow 594406 594406 Dorothy his wife, formerly Dorothy Skynner, of Dulverton, Soms, widow 2
3985169 2019451 2019451 defendant Glasse William husbandman 594406 594406 Glasse, William, of Dulverton, Soms, groom, husbandman 0
3985219 2019470 2019470 defendant Ford William, senior weaver 594406 594406 Ford, William, senior, of Dulverton, Soms, weaver 0
3985222 2019471 2019471 defendant Ford William, senior weaver 594406 594406 Ford, William, senior, of Dulverton, Soms, weaver 0
4117556 2066574 2066574 defendant Pannell William tailor 594406 594406 Pannell, William, of Dulverton, Soms, tailor 3
4301617 2130682 2130682 defendant Harte Walter clerk 594406 594406 Harte, Walter, of Dulverton, Soms, clerk 0
4409704 2167846 2167846 defendant Case Nicholas merchant 594406 594406 Case, Nicholas, of Dulverton, Soms, merchant 0
5134752 2396663 2396663 defendant Glosse John hoper 594406 594406 Glosse, John, of Dulverton, Soms, hoper 0
5134754 2396664 2396664 defendant Glosse John hoper or hoop maker 594406 594406 Glosse, John, of Dulverton, Soms, hoper or hoop maker 0
5154692 2402527 2402527 defendant Glosse John   594406 594406 Glosse, John, of Dulverton, Soms, hoop maker 0
5154694 2402528 2402528 defendant Glosse John   594406 594406 Glosse, John, of Dulverton, Soms, hoop maker 0
5315954 2449846 2449846 defendant Chilcote John husbandman 594406 594406 Chilcote, John, of Dulverton, Soms, husbandman 0
5328493 2453597 2453597 defendant Geffrey Thomas clerk 594406 594406 Geffrey, Thomas, of Dulverton, Soms, clerk 2

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