names

64 rows where place_id = 590550

✎ 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
3601587 1868152 1868152 defendant Welby William gent 590550 590550 Welby, William, of Multon, Lincs, gent 0
3608293 1870251 1870251 defendant Cok Richard gent 590550 590550 Cok, Richard, of Multon, Lincs, gent 0
3608295 1870252 1870252 defendant Cok Richard gent 590550 590550 Cok, Richard, of Multon, Lincs, gent 0
3608994 1870470 1870470 defendant Hyll Adam husbandman 590550 590550 Hyll, Adam, of Multon, Lincs, husbandman 0
3618879 1873515 1873515 defendant Wylly William esq 590550 590550 Wylly, William, of Multon, Lincs, esq 2
3659764 1913308 1913308 defendant Bonde William clerk 590550 590550 Bonde, William, of Multon, Lincs, clerk 0
3720787 1932791 1932791 defendant Bonde William clerk 590550 590550 Bonde, William, of Multon, Lincs, clerk 0
3885612 1985442 1985442 defendant Russell Richard clerk 590550 590550 Russell, Richard, of Multon, Lincs, clerk 0
3897935 1989516 1989516 defendant Shepard John gent 590550 590550 (Shepard, John, of Multon, Lincs, gent 1
3899402 1990015 1990015 defendant Russell Richard clerk 590550 590550 Russell, Richard, of Multon, Lincs, clerk 0
3940996 2003994 2003994 defendant Mosse Richard husbandman 590550 590550 Mosse, Richard, of Multon, Lincs, husbandman 3
4652462 2246720 2246720 defendant Heweson Gilbert chaplain 590550 590550 Heweson, Gilbert, of Multon, Lincs, chaplain 0
4670670 2256510 2256510 defendant Medewe John chapman 590550 590550 Medewe, John, of Multon, Lincs, chapman 1
4730401 2274706 2274706 defendant Modewe John, sen chapman 590550 590550 Modewe, John, sen, of Multon, Lincs, chapman 1
4744906 2279025 2279025 defendant Medewe John, senior chapman 590550 590550 Medewe, John, senior, of Multon, Lincs, chapman 0
4830351 2305525 2305525 defendant Ithon John yeoman 590550 590550 Ithon, John, of Multon, Lincs, yeoman 0
4833065 2306360 2306360 plaintiff Chaveney Robert gent 590550 590550 Chaveney, Robert, of Multon, Lincs, gent 0
4838054 2307825 2307825 defendant Broun Adam   590550 590550 Broun, Adam, of Multon, Lincs 0
4946233 2340808 2340808 defendant Michell William yeoman 590550 590550 Michell, William, of Multon, Lincs, yeoman 1
4953639 2343053 2343053 defendant Rumney John gent 590550 590550 Rumney, John, of Multon, Lincs, gent 1
5048069 2371046 2371046 defendant Broun John husbandman 590550 590550 Broun, John, of Multon, Lincs, son of William, of Broun, husbandman 1
5091687 2383958 2383958 defendant Shirbek John yeoman 590550 590550 Shirbek, John, of Multon, Lincs, yeoman 0
5121170 2392618 2392618 defendant Tolyet John merchant 590550 590550 Tolyet, John, of Multon, Lincs, merchant 0
5121172 2392619 2392619 defendant Tolyet John merchant 590550 590550 Tolyet, John, of Multon, Lincs, merchant 0
5147424 2400394 2400394 defendant Alriche Thomas   590550 590550 Alriche, Thomas, of Multon, husbandman, Lincs 0
5212227 2419315 2419315 defendant Soulhed or Sculhed John gent 590550 590550 Soulhed or Sculhed, John, of Multon, Lincs, gent 3
5233717 2425448 2425448 defendant Clerk alias Shepherd Thomas clerk 590550 590550 Clerk alias Shepherd, Thomas, of Multon, Lincs, clerk 0
5235791 2426045 2426045 defendant Clerk alias Shepherd Thomas clerk 590550 590550 Clerk alias Shepherd, Thomas, of Multon, Lincs, clerk 0
5238494 2426848 2426848 defendant Haltoft William, junior gent 590550 590550 Haltoft, William, junior, of Multon, Lincs, gent 0
5244696 2428627 2428627 defendant Andrewe John husbandman 590550 590550 Andrewe, John, of Multon, Lincs, husbandman 0
5244720 2428631 2428631 defendant Bolt John weaver 590550 590550 Bolt, John, of Multon, Lincs, weaver 4
5244734 2428634 2428634 defendant Damet John gent 590550 590550 Damet, John, of Multon, Lincs, gent 1
5245105 2428734 2428734 defendant Bolt John weaver 590550 590550 Bolt, John, of Multon, Lincs, weaver 4
5245144 2428741 2428741 defendant Damet John gent 590550 590550 Damet, John, of Multon, Lincs, gent 1
5250232 2430184 2430184 defendant Haltoft William, junior gent 590550 590550 Haltoft, William, junior, of Multon, Lincs, gent 0
5250237 2430185 2430185 defendant Haltoft William, junior gent 590550 590550 Haltoft, William, junior, of Multon, Lincs, gent 0
5250262 2430190 2430190 defendant Haltoft William, junior gent 590550 590550 Haltoft, William, junior, of Multon, Lincs, gent 0
5250267 2430191 2430191 defendant Haltoft William, junior gent 590550 590550 Haltoft, William, junior, of Multon, Lincs, gent 0
5256406 2432130 2432130 defendant Wilfay or Wilsay John husbandman 590550 590550 Wilfay or Wilsay, John, of Multon, Lincs, husbandman 1
5268496 2435906 2435906 defendant Lekeman John husbandman 590550 590550 Lekeman, John, of Multon, Lincs, husbandman 0
5272412 2437000 2437000 defendant Danet John gent 590550 590550 Danet, John, of Multon, Lincs, gent 0
5278594 2438851 2438851 defendant Leleman John husbandman 590550 590550 Leleman, John, of Multon, Lincs, husbandman 0
5279958 2439211 2439211 defendant Seriant John gent 590550 590550 Seriant, John, of Multon, Lincs, gent 1
5287155 2441258 2441258 defendant Damet John gent 590550 590550 Damet, John, of Multon, Lincs, gent 0
5312405 2448743 2448743 defendant Browne Wiliam husbandman 590550 590550 Browne, Wiliam, of Multon, Lincs, husbandman 0
5313152 2448965 2448965 defendant Gery William husbandman 590550 590550 Gery, William, of Multon, Lincs, husbandman 0
5333758 2455170 2455170 defendant Sergeaunt John gent 590550 590550 Sergeaunt, John, of Multon, Lincs, gent 0
5340899 2457349 2457349 defendant Broun William husbandman 590550 590550 Broun, William, of Multon, Lincs, husbandman 1
5341199 2457439 2457439 defendant Cok Richard gent 590550 590550 Cok, Richard, of Multon, Lincs, gent 0
5366203 2465091 2465091 defendant Wayte Robert yeoman 590550 590550 Wayte, Robert, of Multon, Lincs, yeoman 0
5427511 2483179 2483179 defendant Bygot John husbandman 590550 590550 Bygot, John, of Multon, Lincs, husbandman 0
5427513 2483180 2483180 defendant Bygot John, sen husbandman 590550 590550 Bygot, John, sen, of Multon, Lincs, husbandman 0
5444015 2488128 2488128 defendant Wayte Robert husbandman 590550 590550 Wayte, Robert, of Multon, Lincs, husbandman 0
5445257 2488475 2488475 defendant Dyge John, junior husbandman 590550 590550 Dyge, John, junior, of Multon, Lincs, husbandman 0
5471479 2496416 2496416 defendant Welby Roger gent 590550 590550 Welby, Roger, of Multon, Lincs, gent 2
5481117 2499303 2499303 defendant Begot William husbandman 590550 590550 Begot, William, of Multon, Lincs, husbandman 1
5489864 2501852 2501852 defendant Welby William gent 590550 590550 Welby, William, of Multon, Lincs, gent 1
5489866 2501853 2501853 defendant Welby William gent 590550 590550 Welby, William, of Multon, Lincs, gent 0
5495934 2503680 2503680 defendant Welby Robert chaplain 590550 590550 Welby, Robert, of Multon, Lincs, chaplain 3
5518465 2510606 2510606 defendant Brown William yeoman 590550 590550 Brown, William, of Multon, Lincs, yeoman 0
5571161 2526128 2526128 defendant Baston Robert yeoman 590550 590550 Baston, Robert, of Multon, Lincs, yeoman 0
5571165 2526130 2526130 defendant Weyt Robert yeoman 590550 590550 Weyt, Robert, of Multon, Lincs, yeoman 0
5572580 2526525 2526525 defendant Bonde William clerk 590550 590550 (Bonde, William, of Multon, Lincs, clerk 1
5588018 2531263 2531263 defendant Helle William yeoman 590550 590550 Helle, William, of Multon, Lincs, yeoman 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);