names

39 rows where place_id = 688967

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4078243 2052521 2052521 defendant Cogan John clothier 688967 688967 Cogan, John, of Ilminster, clothier 0
4290932 2126817 2126817 defendant Rossiter John clothier 688967 688967 Rossiter, John, of Ilminster, clothier 0
4290934 2126818 2126818 defendant Clarke Walter husbandman 688967 688967 Clarke, Walter, of Ilminster, or of Horton, husbandman 0
4290940 2126821 2126821 defendant Hawle William gent 688967 688967 Hawle, William, of Ilminster, gent 0
4306791 2132515 2132515 defendant Peeke Roger husbandman 688967 688967 Peeke, Roger, of Ilminster, husbandman 0
4306792 2132515 2132515 defendant Dale William husbandman 688967 688967 Dale, William, of Ilminster, husbandman 1
4332964 2141311 2141311 defendant Clarke Walter husbandman 688967 688967 Clarke, Walter, of Ilminster, or of Horton, husbandman 0
4332965 2141311 2141311 defendant Rossiter John clothier 688967 688967 Rossiter, John, of Ilminster, clothier 1
4332966 2141311 2141311 defendant Hart Nicholas   688967 688967 Hart, Nicholas, of Ilminster, woollen draper 2
4374770 2156031 2156031 defendant Morgan John wheeler 688967 688967 Morgan, John, of Ilminster, wheeler 2
4379676 2157828 2157828 defendant Rossyter John clothier 688967 688967 Rossyter, John, of Ilminster, clothier 0
4385362 2159796 2159796 defendant Humfrey Thomas wheeler 688967 688967 Humfrey, Thomas, of Ilminster, husbandman, or of West Lambrooke, Kingsbury, wheeler 0
4542174 2213444 2213444 defendant Jaye John   688967 688967 Jaye, John, of Ilminster 0
4644165 2244387 2244387 defendant Bole Thomas   688967 688967 Bole, Thomas, of Ilminster 4
4667190 2255471 2255471 defendant Osguddes John yeoman 688967 688967 Osguddes, John, of Ilminster, yeoman 0
4692121 2263065 2263065 defendant Osbodde John yeoman 688967 688967 Osbodde, John, of Ilminster, yeoman 0
4712598 2269259 2269259 defendant Mantell Walter husbandman 688967 688967 Mantell, Walter, of Ilminster, husbandman 0
4715109 2270051 2270051 defendant Pole John husbandman 688967 688967 Pole, John, of Ilminster, husbandman 0
4726672 2273612 2273612 defendant Dylyngton Maud   688967 688967 Dylyngton, Maud, of Ilminster, widow, formerly wife of Richard 0
4730523 2274745 2274745 defendant Dyer Richard dyer 688967 688967 Dyer, Richard, of Ilminster, dyer 0
4754650 2281836 2281836 defendant Dyllyngton Maud widow 688967 688967 Dyllyngton, Maud, of Ilminster, widow 1
4754698 2281851 2281851 defendant Dybyngton Maud   688967 688967 Dybyngton, Maud, of Ilminster, widow, formerly wife of Richard 0
4760022 2283472 2283472 defendant Yevan John   688967 688967 Yevan, John, of Ilminster, vicar 1
4769794 2286526 2286526 defendant Repe Henry butcher 688967 688967 Repe, Henry, of Ilminster, butcher 0
4776083 2288517 2288517 plaintiff Yevan John   688967 688967 Yevan, John, of Ilminster, vicar 0
4834141 2306687 2306687 plaintiff Copthorn alias Dyer Ralph (legal representative) 688967 688967 Copthorn alias Dyer, Ralph, of Ilminster, executors of 0
4835246 2307025 2307025 plaintiff Deigher Richard (legal representative) 688967 688967 Deigher, Richard, of Ilminster, dyer, executors of 0
4835252 2307025 2307025 defendant Sele John weaver 688967 688967 Sele, John, of Ilminster, weaver 3
4835325 2307044 2307044 defendant Badeston Thomas dyer 688967 688967 Badeston, Thomas, of Ilminster, dyer 2
4845020 2309958 2309958 defendant Byllyngton or Dyllyngton Maud widow 688967 688967 Byllyngton or Dyllyngton, Maud, of Ilminster, widow 0
5001302 2357261 2357261 defendant Thressher William butcher 688967 688967 Thressher, William, of Ilminster, butcher 0
5008839 2359476 2359476 defendant Dyer William dyer 688967 688967 Dyer, William, of Ilminster, dyer 0
5149714 2401048 2401048 defendant Marke Robert clerk 688967 688967 Marke, Robert, of Ilminster, clerk 0
5149716 2401049 2401049 defendant Marke Robert clerk 688967 688967 Marke, Robert, of Ilminster, clerk 0
5152349 2401819 2401819 defendant Denbaude Thomas (legal representative) 688967 688967 Denbaude, Thomas, of Ilminster, executors of 0
5161824 2404566 2404566 defendant Coke Henry   688967 688967 Coke, Henry, of Ilminster, mill ward 0
5210358 2418762 2418762 defendant Coke Henry   688967 688967 Coke, Henry, of Ilminster, mill ward 0
5423364 2481948 2481948 defendant Hylle William husbandman 688967 688967 Hylle, William, of Ilminster, husbandman 0
5423368 2481949 2481949 defendant Hylle William husbandman 688967 688967 Hylle, William, of Ilminster, husbandman 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);