names

81 rows where place_id = 586366

✎ 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
3588532 1864057 1864057 defendant ap Rys William yeoman 586366 586366 ap Rys, William, of Ilmyster, yeoman 0
3640293 1907399 1907399 defendant Helyer Richard weaver 586366 586366 Helyer, Richard, of Ilmyster, weaver 0
3671084 1916924 1916924 defendant Dunster Thomas weaver 586366 586366 Dunster, Thomas, of Ilmyster, weaver 2
3674292 1918004 1918004 defendant Gaylard John, junior husbandman 586366 586366 Gaylard, John, junior, of Ilmyster, husbandman 0
3683037 1920807 1920807 defendant Denbawde Robert innholder 586366 586366 Denbawde, Robert, of Ilmyster, innholder 0
3691881 1923620 1923620 defendant Ivery John innholder 586366 586366 Ivery, John, of Ilmyster, innholder 0
3704185 1927606 1927606 defendant Sorte John baker 586366 586366 Sorte, John, of Ilmyster, baker 2
3788129 1954082 1954082 defendant Lambell John mercer 586366 586366 Lambell, John, of Ilmyster, mercer 0
3835341 1968991 1968991 defendant Grey John glover 586366 586366 Grey, John, of Ilmyster, glover 4
3850555 1973763 1973763 defendant Assheton John husbandman 586366 586366 Assheton, John, of Ilmyster, husbandman 0
3852487 1974385 1974385 defendant Robbyns alias Miller Thomas husbandman 586366 586366 Robbyns alias Miller, Thomas, of Ilmyster, husbandman 0
3852488 1974385 1974385 defendant Evans John husbandman 586366 586366 Evans, John, of Ilmyster, husbandman 1
3852489 1974385 1974385 defendant Croket Robert husbandman 586366 586366 Croket, Robert, of Ilmyster, husbandman 2
3929474 2000204 2000204 defendant Greynggyld Henry yeoman 586366 586366 Greynggyld, Henry, of Ilmyster, yeoman 0
3935424 2002159 2002159 defendant Sydenham George gent 586366 586366 Sydenham, George, of Ilmyster, gent 0
3937935 2003020 2003020 defendant Wylmott Richard fuller of cloth 586366 586366 Wylmott, Richard, of Ilmyster, fuller of cloth 1
3980234 2017696 2017696 defendant Coxe Richard, senior yeoman 586366 586366 Coxe, Richard, senior, of Ilmyster, yeoman 0
3980235 2017696 2017696 defendant Coxe Richard, junior yeoman 586366 586366 Coxe, Richard, junior, of Ilmyster, yeoman 1
3995470 2023124 2023124 defendant Hawker John husbandman 586366 586366 Hawker, John, of Ilmyster, husbandman 0
4009772 2028266 2028266 defendant Ewen Thomas husbandman 586366 586366 Ewen, Thomas, of Ilmyster, husbandman 0
4009774 2028267 2028267 defendant Grenefeld Henry gent 586366 586366 Grenefeld, Henry, of Ilmyster, gent 0
4043204 2040039 2040039 defendant Greynfeld Edward yeoman 586366 586366 Greynfeld, Edward, of Ilmyster, yeoman 1
4060601 2046193 2046193 defendant Fairchild William clerk 586366 586366 Fairchild, William, of Ilmyster, clerk 0
4062988 2047066 2047066 defendant Hawker John yeoman 586366 586366 Hawker, John, of Ilmyster, yeoman 0
4069297 2049303 2049303 defendant Troughte John tailor 586366 586366 Troughte, John, of Ilmyster, tailor 0
4073636 2050862 2050862 defendant Armestrynge John husbandman 586366 586366 Armestrynge, John, of Ilmyster, husbandman 0
4073637 2050862 2050862 defendant Webbe William husbandman 586366 586366 Webbe, William, of Ilmyster, husbandman 1
4092051 2057452 2057452 defendant White John butcher 586366 586366 White, John, of Ilmyster, butcher 0
4156494 2080347 2080347 defendant Grenefeld Edward gent 586366 586366 Grenefeld, Edward, of Ilmyster, gent 0
4171412 2085464 2085464 defendant Fairchilde William clerk 586366 586366 Fairchilde, William, of Ilmyster, clerk 0
4175297 2086828 2086828 defendant Lambert alias Rickard John yeoman 586366 586366 Lambert alias Rickard, John, of Ilmyster, yeoman 0
4175298 2086828 2086828 defendant Symes Robert fisher 586366 586366 Symes, Robert, of Ilmyster, fisher 1
4317840 2136351 2136351 defendant Fyle Thomas tanner 586366 586366 Fyle, Thomas, of Ilmyster, tanner 1
4381885 2158623 2158623 defendant Bonfild John gent 586366 586366 Bonfild, John, of Ilmyster , gent 1
4818462 2301854 2301854 defendant Dillyngton Matilda widow 586366 586366 Dillyngton, Matilda, of Ilmyster, widow 0
4819555 2302193 2302193 defendant Imberley John harper 586366 586366 Imberley, John, of Ilmyster, harper 3
5084453 2381862 2381862 defendant Pomerey John chapman 586366 586366 Pomerey, John, of Ilmyster, chapman 2
5084457 2381863 2381863 defendant Pomerey John chapman 586366 586366 Pomerey, John, of Ilmyster, chapman 2
5226274 2423349 2423349 defendant Macy Henry glover 586366 586366 Macy, Henry, of Ilmyster, glover 0
5232314 2425030 2425030 defendant Ymberley John husbandman 586366 586366 Ymberley, John, of Ilmyster, husbandman 3
5264883 2434777 2434777 defendant Wysman James chapman 586366 586366 Wysman, James, of Ilmyster, chapman 0
5264884 2434777 2434777 defendant Redberd William husbandman 586366 586366 Redberd, William, of Ilmyster, husbandman 1
5264885 2434777 2434777 defendant Stykker John husbandman 586366 586366 Stykker, John, of Ilmyster, husbandman 2
5264886 2434777 2434777 defendant Raley John weaver 586366 586366 Raley, John, of Ilmyster, weaver 3
5264887 2434777 2434777 defendant Lyly Henry chapman 586366 586366 Lyly, Henry, of Ilmyster, chapman 4
5264888 2434777 2434777 defendant Sodbury Thomas smith 586366 586366 Sodbury, Thomas, of Ilmyster, smith 5
5264889 2434777 2434777 defendant Lambell John yeoman 586366 586366 Lambell, John, of Ilmyster, yeoman 6
5264890 2434777 2434777 defendant Warmyster William glover 586366 586366 Warmyster, William, of Ilmyster, glover 7
5264891 2434777 2434777 defendant Marke William dyer 586366 586366 Marke, William, of Ilmyster, dyer 8
5264892 2434777 2434777 defendant Rugge Henry carpenter 586366 586366 Rugge, Henry, of Ilmyster, carpenter 9
5264893 2434777 2434777 defendant Thorne Thomas hosier 586366 586366 Thorne, Thomas, of Ilmyster, hosier 10
5264894 2434777 2434777 defendant Exceter John cordwainer 586366 586366 Exceter, John, of Ilmyster, cordwainer 11
5264895 2434777 2434777 defendant Godelonde John smith 586366 586366 Godelonde, John, of Ilmyster, smith 12
5313750 2449139 2449139 defendant Stykker John husbandman 586366 586366 Stykker, John, of Ilmyster, husbandman 0
5319974 2451060 2451060 defendant Balwyn William   586366 586366 Balwyn, William, of Ilmyster, mason 0
5354625 2461522 2461522 defendant Forshey William yeoman 586366 586366 Forshey, William, of Ilmyster, yeoman 1
5449420 2489713 2489713 defendant Swayn John yeoman 586366 586366 Swayn, John, of Ilmyster, yeoman 0
5472993 2496878 2496878 defendant Swayne John yeoman 586366 586366 Swayne, John, of Ilmyster, yeoman 0
5480314 2499095 2499095 defendant Launce John barber 586366 586366 Launce, John, of Ilmyster, barber 2
5486290 2500788 2500788 defendant Thorne John husbandman 586366 586366 Thorne, John, of Ilmyster, husbandman 1
5493403 2502940 2502940 defendant Exeter John cordwainer 586366 586366 Exeter, John, of Ilmyster, cordwainer 0
5493404 2502940 2502940 defendant Copstake John cordwainer 586366 586366 Copstake, John, of Ilmyster, cordwainer 1
5493405 2502940 2502940 defendant Copstake Miles tailor 586366 586366 Copstake, Miles, of Ilmyster, tailor 2
5493406 2502940 2502940 defendant Copstake Christopher tailor 586366 586366 togehter with Copstake, Christopher, of Ilmyster, tailor 3
5516436 2509972 2509972 defendant Bale John mercer 586366 586366 Bale, John, of Ilmyster, mercer 0
5516437 2509972 2509972 defendant Lambell John mercer 586366 586366 Lambell, John, of Ilmyster, mercer 1
5516438 2509972 2509972 defendant Spycer John spicer 586366 586366 Spycer, John, of Ilmyster, spicer 2
5516439 2509972 2509972 defendant Whytyngdale Thomas baker 586366 586366 Whytyngdale, Thomas, of Ilmyster, baker 3
5516440 2509972 2509972 defendant Stacy John cordwainer 586366 586366 Stacy, John, of Ilmyster, cordwainer 4
5516441 2509972 2509972 defendant Wilmot John tucker 586366 586366 Wilmot, John, of Ilmyster, tucker 5
5516442 2509972 2509972 defendant Cabbell John weaver 586366 586366 Cabbell, John, of Ilmyster, weaver 6
5516445 2509973 2509973 defendant Copstake Christopher tailor 586366 586366 Copstake, Christopher, of Ilmyster, tailor 0
5516446 2509973 2509973 defendant Preston Simon tucker 586366 586366 Preston, Simon, of Ilmyster, tucker 1
5516447 2509973 2509973 defendant Michell John   586366 586366 Michell, John, of Ilmyster, groom 2
5516448 2509973 2509973 defendant Castelyn John brewer 586366 586366 Castelyn, John, of Ilmyster, brewer 3
5516450 2509974 2509974 defendant Copstake Christopher tailor 586366 586366 Copstake, Christopher, of Ilmyster, tailor 0
5516451 2509974 2509974 defendant Preston Simon tucker 586366 586366 Preston, Simon, of Ilmyster, tucker 1
5516452 2509974 2509974 defendant Michell John   586366 586366 Michell, John, of Ilmyster, groom 2
5516453 2509974 2509974 defendant Castelyn John brewer 586366 586366 Castelyn, John, of Ilmyster, brewer 3
5585163 2530428 2530428 defendant Dunstar Thomas weaver 586366 586366 Dunstar, Thomas, of Ilmyster, weaver 0
5594124 2533140 2533140 plaintiff Bale John mercer 586366 586366 Bale, John, of Ilmyster, mercer 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);