names

50 rows where place_id = 618462

✎ 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
3724757 1934029 1934029 defendant Strycland Robert chaplain 618462 618462 Strycland, Robert, of Morland, chaplain 0
3766023 1947038 1947038 defendant Diconson Richard yeoman 618462 618462 Diconson, Richard, of Morland, yeoman 0
3766024 1947038 1947038 defendant Alisaunder Roland laborer 618462 618462 Alisaunder, Roland, of Morland, laborer 1
3766025 1947038 1947038 defendant Rigge Roland yeoman 618462 618462 Rigge, Roland, of Morland, yeoman 2
4377819 2157137 2157137 defendant Walker John husbandman 618462 618462 Walker, John, of Morland, husbandman 1
4446413 2183796 2183796 plaintiff del Pray John   618462 618462 del Pray, John, of Morland, vicar, on his own account 0
4446417 2183797 2183797 plaintiff del Pray John   618462 618462 del Pray, John, of Morland, vicar, on his own account 0
4464436 2189547 2189547 plaintiff del Pray John   618462 618462 del Pray, John, of Morland, vicar 4
4483870 2195652 2195652 defendant Bland Thomas de   618462 618462 Bland, Thomas de, of Morland 0
4553623 2217059 2217059 defendant Haryngton Thomas   618462 618462 Haryngton, Thomas, of Morland 2
4571191 2222558 2222558 defendant Smale Robert   618462 618462 Smale, Robert, of Morland 0
4596512 2230150 2230150 plaintiff Rychemond John de   618462 618462 Rychemond, John de, of Morland, vicar 0
4615374 2235816 2235816 defendant Hotblak Thomas   618462 618462 Hotblak, Thomas, of Morland 0
4632450 2241039 2241039 defendant Holbagman Adam   618462 618462 Holbagman, Adam, of Morland 1
4660315 2249057 2249057 defendant Bateson Peter yeoman 618462 618462 Bateson, Peter, of Morland, yeoman 0
4710208 2268543 2268543 defendant Bland William de yeoman 618462 618462 Bland, William de, of Morland, yeoman 0
4731318 2274996 2274996 defendant Haryngton Andrew husbandman 618462 618462 Haryngton, Andrew, of Morland, husbandman 0
4737292 2276782 2276782 defendant Atkynson John husbandman 618462 618462 Atkynson, John, of Morland, husbandman 1
4746396 2279442 2279442 defendant Difford Thomas, junior butcher 618462 618462 Difford, Thomas, junior, of Morland, butcher 2
4746397 2279442 2279442 defendant tostale William glover 618462 618462 tostale, William, of Morland, glover 3
4760651 2283676 2283676 defendant Hyneson or Hyveson Thomas chaplain 618462 618462 Hyneson or Hyveson, Thomas, of Morland, chaplain 0
4769641 2286482 2286482 defendant Butesson Peter husbandman 618462 618462 Butesson, Peter, of Morland, husbandman 0
4770710 2286820 2286820 defendant Symson William husbandman 618462 618462 Symson, William, of Morland, husbandman 0
4770711 2286820 2286820 defendant Symson Thomas husbandman 618462 618462 Symson, Thomas, of Morland, husbandman 1
4770712 2286820 2286820 defendant Meldon Thomas   618462 618462 Meldon, Thomas, of Morland, wright 2
4770713 2286820 2286820 defendant Huetson Thomas husbandman 618462 618462 Huetson, Thomas, of Morland, husbandman 3
4770714 2286820 2286820 defendant Bakhous William husbandman 618462 618462 Bakhous, William, of Morland, husbandman 4
4770715 2286821 2286821 plaintiff Richemond John   618462 618462 Richemond, John, of Morland, vicar 0
4795628 2294782 2294782 defendant Difford Thomas, junior husbandman 618462 618462 Difford, Thomas, junior, of Morland, husbandman 0
4816258 2301168 2301168 defendant Robynson Thomas, junior husbandman 618462 618462 with Robynson, Thomas, junior, of Morland, husbandman 4
4816262 2301169 2301169 defendant Robynson Thomas, junior husbandman 618462 618462 Robynson, Thomas, junior, of Morland, husbandman 0
4848430 2310984 2310984 defendant Symson Thomas yeoman 618462 618462 Symson, Thomas, of Morland, yeoman 0
4857884 2313831 2313831 defendant Difford Thomas flesshewer or butcher 618462 618462 Difford, Thomas, of Morland, flesshewer or butcher 2
4857885 2313831 2313831 defendant Robynson Thomas yeoman 618462 618462 Robynson, Thomas, of Morland, yeoman 3
4861432 2314946 2314946 defendant Disforth Thomas flesshewer or butcher 618462 618462 Disforth, Thomas, of Morland, flesshewer or butcher 2
4872289 2318293 2318293 defendant Raper John yeoman 618462 618462 Raper, John, of Morland, yeoman 0
4879719 2320577 2320577 defendant Robynson Thomas yeoman 618462 618462 Robynson, Thomas, of Morland, yeoman 0
4879720 2320577 2320577 defendant Atkynson Thomasd yeoman 618462 618462 Atkynson, Thomasd, of Morland, yeoman 1
4933086 2336742 2336742 defendant Atkynson Thomas yeoman 618462 618462 Atkynson, Thomas, of Morland, yeoman 0
4971973 2348555 2348555 defendant Spethyng John yeoman 618462 618462 Spethyng, John, of Morland, yeoman 1
4978924 2350654 2350654 defendant Coke John yeoman 618462 618462 Coke, John, of Morland, yeoman 3
5010056 2359810 2359810 defendant Bampton Thomas (legal representative) 618462 618462 Bampton, Thomas, of Morland, vicar, executors of 1
5043043 2369534 2369534 defendant Smyth Robert yeoman 618462 618462 Smyth, Robert, of Morland, yeoman 1
5046216 2370497 2370497 defendant Garnet Roger yeoman 618462 618462 Garnet, Roger, of Morland, yeoman 4
5081220 2380888 2380888 defendant Cook John yeoman 618462 618462 Cook, John, of Morland, yeoman 2
5596766 2533908 2533908 defendant Bakehouse John yeoman 618462 618462 Bakehouse, John, of Morland, yeoman 0
5596767 2533908 2533908 defendant Bakehouse Thomas yeoman 618462 618462 Bakehouse, Thomas, of Morland, yeoman 1
5596768 2533908 2533908 defendant Bakehouse George yeoman 618462 618462 Bakehouse, George, of Morland, yeoman 2
5626745 2552338 2552338 defendant Hotblak Thomas yeoman 618462 618462 Hotblak, Thomas, of Morland, yeoman 0
5629711 2553285 2553285 defendant Bateson Peter yeoman 618462 618462 Bateson, Peter, of Morland, yeoman 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);