names

90 rows where place_id = 592154

✎ 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
3606758 1869787 1869787 defendant Smyth William yeoman 592154 592154 Smyth, William, of Southwold, Suff, yeoman 6
3619272 1873630 1873630 defendant Bisshop John   592154 592154 Bisshop, John, of Southwold, Suff, mariner, son of Bisshop, Robert 0
3633783 1905380 1905380 defendant Godell Henry merchant of the staple 592154 592154 Godell, Henry, of Southwold, Suff, merchant of the staple 0
3633785 1905381 1905381 defendant Godell Henry merchant of the staple 592154 592154 Godell, Henry, of Southwold, Suff, merchant of the staple 0
3657156 1912503 1912503 defendant Dryver Walter yeoman 592154 592154 Dryver, Walter, of Southwold, Suff, yeoman 0
3682489 1920626 1920626 defendant Goddell Henry mariner 592154 592154 Goddell, Henry, of Southwold, Suff, mariner 1
3745281 1940432 1940432 defendant Hollyes Thomas baker 592154 592154 Hollyes, Thomas, of Southwold, Suff, baker 0
3751263 1942318 1942318 defendant Hollys Thomas baker 592154 592154 Hollys, Thomas, of Southwold, Suff, baker 0
3766895 1947312 1947312 defendant Hollys Thomas baker 592154 592154 Hollys, Thomas, of Southwold, Suff, baker 0
3800213 1957987 1957987 defendant Barker Robert merchant 592154 592154 Barker, Robert, of Southwold, Suff, merchant 0
3836283 1969258 1969258 defendant Beamond Robert merchant 592154 592154 Beamond, Robert, of Southwold, Suff, merchant 0
3836289 1969259 1969259 defendant Beamond Robert merchant 592154 592154 Beamond, Robert, of Southwold, Suff, merchant 0
3852302 1974320 1974320 defendant Beamonde Robert merchant 592154 592154 Beamonde, Robert, of Southwold, Suff, merchant 0
3864619 1978363 1978363 defendant Beamond Robert merchant 592154 592154 Beamond, Robert, of Southwold, Suff, merchant 1
3868610 1979741 1979741 plaintiff Tanner Robert yeoman 592154 592154 Tanner, Robert, of Southwold, Suff, yeoman 0
3887950 1986220 1986220 plaintiff David Margaret (legal representative) 592154 592154 David, Margaret, of Southwold, Suff, "vowes", executor of 0
3900218 1990300 1990300 defendant Thompson Richard yeoman 592154 592154 Thompson, Richard, of Southwold, Suff, yeoman 0
3900222 1990301 1990301 defendant Thompson Richard yeoman 592154 592154 Thompson, Richard,of Southwold, Suff, yeoman 0
3936341 2002477 2002477 defendant Gardener John merchant 592154 592154 Gardener, John, of Southwold, Suff, merchant 1
3941822 2004278 2004278 defendant Stanton John mariner 592154 592154 Stanton, John, of Southwold, Suff, mariner 0
3955648 2009048 2009048 defendant Burman Henry merchant 592154 592154 Burman, Henry, of Southwold, Suff, merchant 0
3981761 2018235 2018235 defendant Browne Robert merchant 592154 592154 Browne, Robert, of Southwold, Suff, merchant 3
3981766 2018236 2018236 defendant Browne Robert merchant 592154 592154 Browne, Robert, of Southwold, Suff, merchant 3
4146542 2076941 2076941 defendant Holbecke Thomas mercer 592154 592154 Holbecke, Thomas, of Southwold, Suff, mercer 0
4175033 2086734 2086734 defendant Parker Edward tailor 592154 592154 Parker, Edward, of Southwold, Suff, tailor 0
4212051 2099764 2099764 defendant Holbeck Thomas merchant 592154 592154 Holbeck, Thomas, of Southwold, Suff, merchant 0
4348122 2146590 2146590 defendant Barrett Owen yeoman 592154 592154 Barrett, Owen, of Southwold, Suff, yeoman 0
4960496 2345108 2345108 defendant de Lye William mariner 592154 592154 de Lye, William, of Southwold, Suff, mariner 0
4984505 2352300 2352300 defendant Metsharp Thomas shipman 592154 592154 Metsharp, Thomas, of Southwold, Suff, shipman 3
4984510 2352301 2352301 defendant Metsharpp Thomas shipman 592154 592154 Metsharpp, Thomas, of Southwold, Suff, shipman 3
5021023 2363047 2363047 defendant Turpyn Robert yeoman 592154 592154 Turpyn, Robert, of Southwold, Suff, yeoman 0
5036776 2367632 2367632 plaintiff Waynflete John merchant 592154 592154 Waynflete, John, of Southwold, Suff, merchant 0
5056238 2373441 2373441 defendant Gardener Robert yeoman 592154 592154 Gardener, Robert, of Southwold, Suff, yeoman 2
5060307 2374656 2374656 defendant Symson Robert husbandman 592154 592154 Symson, Robert, of Southwold, Suff, husbandman 0
5067681 2376827 2376827 defendant Skylman Richard gent 592154 592154 Skylman, Richard, of Southwold, Suff, gent 1
5077036 2379630 2379630 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 0
5109959 2389341 2389341 defendant Gardener Robert cooper 592154 592154 Gardener, Robert, of Southwold, Suff, cooper 0
5112796 2390137 2390137 defendant Goddyl Henry mariner 592154 592154 Goddyl, Henry, of Southwold, Suff, mariner 0
5157525 2403331 2403331 defendant Fox John husbandman 592154 592154 Fox, John, of Southwold, Suff, husbandman 0
5158177 2403511 2403511 defendant Revet John husbandman 592154 592154 Revet, John, of Southwold, Suff, husbandman 2
5174911 2408359 2408359 defendant Gardyner Robert yeoman 592154 592154 Gardyner, Robert, of Southwold, Suff, yeoman 0
5193378 2413790 2413790 defendant Fox John husbandman 592154 592154 Fox, John, of Southwold, Suff, husbandman 0
5244784 2428644 2428644 defendant Wayneflett William merchant 592154 592154 Wayneflett, William, of Southwold, Suff, merchant 0
5251217 2430483 2430483 defendant Waynflete John gent 592154 592154 Waynflete, John, of Southwold, Suff, gent 0
5253383 2431161 2431161 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 0
5264636 2434693 2434693 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 2
5272228 2436951 2436951 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 3
5284853 2440586 2440586 defendant Waynflete William gent 592154 592154 Waynflete, William, of Southwold, Suff, gent 0
5303188 2445945 2445945 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 2
5317099 2450190 2450190 defendant Waynflete William merchant 592154 592154 Waynflete, William, of Southwold, Suff, merchant 1
5329278 2453838 2453838 defendant Waynflete William gent 592154 592154 Waynflete, William, of Southwold, Suff, gent 0
5329285 2453840 2453840 defendant Waynflete William gent 592154 592154 Waynflete, William, of Southwold, Suff, gent 0
5332393 2454753 2454753 defendant More Roger shipman 592154 592154 More, Roger, of Southwold, Suff, shipman 1
5339746 2457006 2457006 defendant Waynflete William gent 592154 592154 Waynflete, William, of Southwold, Suff, gent 0
5370015 2466208 2466208 defendant Waynflete John esq 592154 592154 Waynflete, John, of Southwold, Suff, esq 3
5376572 2468273 2468273 defendant Talman Thomas mariner 592154 592154 Talman, Thomas, of Southwold, Suff, mariner 0
5387919 2471601 2471601 defendant Gardener Richard butcher 592154 592154 Gardener, Richard, of Southwold, Suff, butcher 2
5417563 2480170 2480170 defendant goodman John shipman 592154 592154 goodman, John, of Southwold, Suff, shipman 4
5434660 2485303 2485303 defendant Heigham Robert mariner 592154 592154 Heigham, Robert, of Southwold, Suff, mariner 3
5434934 2485380 2485380 defendant Goodman John shipman 592154 592154 Goodman, John, of Southwold, Suff, shipman 0
5434955 2485383 2485383 defendant Goodman John shipman 592154 592154 Goodman, John, of Southwold, Suff, shipman 4
5435679 2485608 2485608 defendant Barsham Richard mariner 592154 592154 Barsham, Richard, of Southwold, Suff, mariner 7
5449987 2489885 2489885 defendant Heigham Robert mariner 592154 592154 Heigham, Robert, of Southwold, Suff, mariner 2
5449998 2489887 2489887 defendant Mony John mariner 592154 592154 Mony, John, of Southwold, Suff, mariner 4
5450166 2489935 2489935 defendant Goodman John shipman 592154 592154 Goodman, John, of Southwold, Suff, shipman 0
5462348 2493639 2493639 defendant Goodman John shipman 592154 592154 Goodman, John, of Southwold, Suff, shipman 0
5473679 2497095 2497095 defendant Monnyng John mariner 592154 592154 Monnyng, John, of Southwold, Suff, mariner 0
5485119 2500470 2500470 defendant Heygham Robert mariner 592154 592154 Heygham, Robert, of Southwold, Suff, mariner 2
5500148 2504997 2504997 defendant Cryspyn William beer brewer 592154 592154 Cryspyn, William, of Southwold, Suff, beer brewer 0
5500645 2505128 2505128 defendant Skylman Richard stockfishmonger 592154 592154 Skylman, Richard, of Southwold, Suff, merchant, or of London, stockfishmonger 0
5505309 2506571 2506571 defendant Waynflete John esq 592154 592154 Waynflete, John, of Southwold, Suff, esq 0
5506730 2507025 2507025 defendant Goddys John merchant 592154 592154 Goddys, John, of Southwold, Suff, merchant 0
5513701 2509139 2509139 defendant Swayn Robert baker 592154 592154 Swayn, Robert, of Southwold, Suff, baker 1
5513706 2509140 2509140 defendant Swayn Robert baker 592154 592154 Swayn, Robert, of Southwold, Suff, baker 1
5520831 2511336 2511336 defendant Skylman Richard gent 592154 592154 Skylman, Richard, of Southwold, Suff, gent 1
5528652 2513473 2513473 defendant Skylman Richard gent 592154 592154 Skylman, Richard, of Southwold, Suff, gent 0
5529599 2513758 2513758 defendant Norfold Thomas mariner 592154 592154 Norfold, Thomas, of Southwold, Suff, mariner 0
5536868 2516020 2516020 defendant Skylman Richard yeoman 592154 592154 Skylman, Richard, of Southwold, Suff, yeoman 0
5540952 2517293 2517293 defendant Parkyn John chaplain 592154 592154 Parkyn, John, of Southwold, Suff, chaplain 0
5541191 2517366 2517366 defendant Clerk Gilbert plumber 592154 592154 Clerk, Gilbert, of Southwold, Suff, plumber 0
5543777 2518159 2518159 defendant Bamond John yeoman 592154 592154 Bamond, John, of Southwold, Suff, yeoman 1
5544140 2518282 2518282 defendant Joye Richard husbandman 592154 592154 Joye, Richard, of Southwold, Suff, husbandman 0
5575192 2527329 2527329 defendant Drever Walter merchant 592154 592154 Drever, Walter, of Southwold, Suff, merchant 0
5575976 2527559 2527559 defendant Botell John yeoman 592154 592154 Botell, John, of Southwold, Suff, yeoman 3
5576005 2527563 2527563 defendant Botell John yeoman 592154 592154 Botell, John, of Southwold, Suff, yeoman 3
5578321 2528289 2528289 defendant Crane Robert mariner 592154 592154 Crane, Robert, of Southwold, Suff, mariner 0
5578325 2528290 2528290 defendant Crane Robert mariner 592154 592154 Crane, Robert, of Southwold, Suff, mariner 0
5588126 2531296 2531296 defendant Joye Richard merchant 592154 592154 Joye, Richard, of Southwold, Suff, merchant 4
5591241 2532230 2532230 defendant Botell John yeoman 592154 592154 Botell, John, of Southwold, Suff, yeoman 4
5608678 2537614 2537614 defendant Wayneflete John merchant 592154 592154 Wayneflete, John, of Southwold, suff, merchant 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);