names

39 rows where place_id = 660202

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3955531 2009004 2009004 defendant Jordayn John butcher 660202 660202 Jordayn, John, of Frome, Soms, butcher 0
3990761 2021452 2021452 defendant Catcote William gent 660202 660202 Catcote, William, of Frome, Soms, or of Brygemerston, Wilts, gent 0
4311999 2134331 2134331 defendant Hurbecke Robert clothier 660202 660202 Hurbecke, Robert, of Frome, Soms, clothier 3
4388869 2160908 2160908 defendant Saunders Robert tailor 660202 660202 Saunders, Robert, of Frome, Soms, tailor 0
4572836 2223042 2223042 defendant Raaf William   660202 660202 Raaf, William, of Frome, Soms 0
4654607 2247322 2247322 defendant Wodelond John carpenter 660202 660202 Wodelond, John, of Frome, Soms, carpenter 3
4674324 2257576 2257576 defendant Osborne Richard yeoman 660202 660202 (Osborne, Richard, of Frome, Soms, yeoman 4
4674331 2257577 2257577 defendant Osberne Richard yeoman 660202 660202 (Osberne, Richard, of Frome, Soms, yeoman 4
4675393 2257913 2257913 defendant Saundres John weaver 660202 660202 Saundres, John, of Frome, Soms, weaver 2
4684885 2260867 2260867 defendant Splot John fuller 660202 660202 (Splot, John, of Frome, Soms, fuller 2
4694973 2263919 2263919 defendant Bayworth John clerk 660202 660202 Bayworth, John, of Frome, Soms, clerk 5
4700753 2265636 2265636 defendant Cable William dyer 660202 660202 Cable, William, of Frome, Soms, dyer 1
4704245 2266703 2266703 defendant Geye William butcher 660202 660202 Geye, William, of Frome, Soms, butcher 2
4706610 2267447 2267447 defendant Gylot John yeoman 660202 660202 Gylot, John, of Frome, Soms, yeoman 0
4712284 2269155 2269155 defendant Alym John de yeoman 660202 660202 Alym, John de, of Frome, Soms, yeoman 2
4730804 2274835 2274835 defendant Craas Robert husbandman 660202 660202 Craas, Robert, of Frome, Soms, husbandman 2
4763072 2284433 2284433 defendant Paye Robert husbandman 660202 660202 Paye, Robert, of Frome, Soms, husbandman 1
4778877 2289367 2289367 defendant Bythewode John tucker 660202 660202 Bythewode, John, of Frome, Soms, tucker 0
4801040 2296514 2296514 defendant Stere William cordwainer 660202 660202 Stere, William, of Frome, Soms, cordwainer 1
4814745 2300728 2300728 defendant Saundres Thomas husbandman 660202 660202 Saundres, Thomas, of Frome, Soms, husbandman 0
4844439 2309773 2309773 defendant Roche Richard fuller 660202 660202 Roche, Richard, of Frome, Soms, fuller 0
4882463 2321425 2321425 defendant Cadell Philip peddler 660202 660202 Cadell, Philip, of Frome, Soms, peddler 2
4942028 2339489 2339489 defendant Saunders Stephen draper 660202 660202 Saunders, Stephen, of Frome, Soms, draper 0
4948831 2341616 2341616 defendant Roche Richard chapman 660202 660202 Roche, Richard, of Frome, Soms, chapman 2
4971981 2348559 2348559 defendant Twyneo Henry gent 660202 660202 Twyneo, Henry, of Frome, Soms, gent 0
4971983 2348560 2348560 defendant Twyneo Henry gent 660202 660202 Twyneo, Henry, of Frome, Soms, gent 0
4983546 2351994 2351994 defendant Payn William weaver 660202 660202 Payn, William, of Frome, Soms, weaver 2
4985079 2352465 2352465 defendant Twyneho William gent 660202 660202 (Twyneho, William, of Frome, soms, gent 1
4985084 2352466 2352466 defendant Twyneho William gent 660202 660202 (Twyneho, William, of Frome, Soms, gent 1
4994772 2355293 2355293 defendant Twyneho William gent 660202 660202 (Twyneho, William, of Frome, Soms, gent 1
4994844 2355311 2355311 defendant Roche Richard fuller 660202 660202 Roche, Richard, of Frome, Soms, fuller 0
5013639 2360831 2360831 defendant Twyneho William gent 660202 660202 (Twyneho, William, of Frome, Soms, gent 1
5021983 2363321 2363321 defendant Touker Walter tucker 660202 660202 Touker, Walter, of Frome, Soms, tucker 1
5034841 2367045 2367045 defendant Fent alias Forbour Robert clothmaker 660202 660202 Fent alias Forbour, Robert, of Frome, Soms, clothmaker 1
5365664 2464926 2464926 defendant Wyncote Robert mercer & writer 660202 660202 Wyncote, Robert, of Frome, Soms, mercer & writer 3
5553362 2521024 2521024 defendant Drover William baker 660202 660202 Drover, William, of Frome, Soms, baker 0
5553366 2521024 2521024 defendant Mede John baker 660202 660202 Mede, John, of Frome, Soms, baker 4
5625011 2551755 2551755 defendant Gyles John yeoman 660202 660202 Gyles, John, of Frome, Soms, yeoman 1
5633442 2554455 2554455 defendant Twydeho Henry draper 660202 660202 Twydeho, Henry, of Frome, Soms, draper 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);