names

48 rows where place_id = 594505

✎ 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
3616375 1872759 1872759 defendant Leem Thomas yeoman 594505 594505 Leem, Thomas, of Brandon Fery, Suff, yeoman 5
3629942 1904221 1904221 defendant Smyth Edmund husbandman 594505 594505 Smyth, Edmund, of Brandon Fery, Suff, husbandman 2
3633381 1905252 1905252 defendant Leme Thomas yeoman 594505 594505 Leme, Thomas, of Brandon Fery, Suff, yeoman 1
3635421 1905875 1905875 defendant Hynde Thomas husbandman 594505 594505 Hynde, Thomas, of Brandon Fery, Suff, husbandman 0
3664114 1914727 1914727 defendant Hanslop Thomas mercer 594505 594505 Hanslop, Thomas, of Brandon Fery, Suff, mercer 0
3676672 1918743 1918743 defendant Jakson Richard yeoman 594505 594505 Jakson, Richard, of Brandon Fery, Suff, yeoman 0
3680209 1919882 1919882 defendant Hanslop Thomas mercer 594505 594505 Hanslop, Thomas, of Brandon Fery, Suff, mercer 2
3743884 1939971 1939971 defendant Turnour Richard yeoman 594505 594505 Turnour, Richard, of Brandon Fery, Suff, yeoman 0
3770399 1948418 1948418 defendant Atmer John yeoman 594505 594505 Atmer, John, of Brandon fery, Suff, yeoman 0
3787878 1953999 1953999 plaintiff Sawnder John draper 594505 594505 Sawnder, John, of Brandon Fery, Suff, draper 0
3788386 1954166 1954166 defendant Barne Ralph innholder 594505 594505 Barne, Ralph, of Brandon Fery, Suff, innholder 0
3797662 1957164 1957164 defendant Adam John innholder 594505 594505 Adam, John, of Brandon Fery, Suff, innholder 1
3868572 1979727 1979727 plaintiff Talbott Lewis gent 594505 594505 Talbott, Lewis, of Brandon Fery, Suff, gent 0
3871429 1980691 1980691 defendant at Mere John innkeeper 594505 594505 at Mere, John, of Brandon Fery, Suff, innkeeper 1
3881594 1984106 1984106 defendant atte Mere John yeoman 594505 594505 atte Mere, John, of Brandon Fery, Suff, yeoman 0
3907226 1992708 1992708 defendant Crowe John innkeeper 594505 594505 Crowe, John, of Brandon Fery, Suff, innkeeper 0
3907252 1992716 1992716 defendant Carr James clerk 594505 594505 Carr, James, of Brandon Fery, Suff, clerk 3
3912814 1994619 1994619 plaintiff Atmere John (legal representative) 594505 594505 Atmere, John, of Brandon Fery, Suff, executors of 0
4013315 2029495 2029495 defendant Crowe Robert waterman 594505 594505 Crowe, Robert, of Brandon Fery, Suff, waterman 0
4663447 2250043 2250043 defendant Smyth John smith 594505 594505 Smyth, John, of Brandon Fery, Suff, smith 0
4810120 2299317 2299317 defendant Gybon Richard   594505 594505 Gybon, Richard, of Brandon Fery, Suff, franklin 0
4810123 2299318 2299318 defendant Gybon Richard   594505 594505 Gybon, Richard, of Brandon Fery, Suff, franklin 0
4882969 2321593 2321593 defendant Vyncent Peter husbandman 594505 594505 Vyncent, Peter, of Brandon Fery, Suff, husbandman 0
4957530 2344220 2344220 defendant Fordham Thomas gent 594505 594505 Fordham, Thomas, of Brandon Fery, Suff, gent 1
4957641 2344258 2344258 defendant Fordham Thomas gent 594505 594505 Fordham, Thomas, of Brandon Fery, Suff, gent 1
4975078 2349518 2349518 defendant Fordham Thomas husbandman 594505 594505 Fordham, Thomas, of Brandon Fery, Suff, husbandman 0
4975085 2349519 2349519 defendant Fordham Thomas husbandman 594505 594505 Fordham, Thomas, of Brandon Fery, Suff, husbandman 0
4984764 2352373 2352373 defendant Lalynghith Alan husbandman 594505 594505 Lalynghith, Alan, of Brandon Fery, Suff, husbandman 1
5099430 2386265 2386265 plaintiff Whetele Roger   594505 594505 Whetele, Roger, of Brandon Fery, Suff 0
5219507 2421432 2421432 defendant Botyvaunt John fisher 594505 594505 Botyvaunt, John, of Brandon Fery, Suff, fisher 2
5229089 2424115 2424115 defendant Botevaunt Edmund husbandman 594505 594505 Botevaunt, Edmund, of Brandon Fery, Suff, husbandman 6
5282872 2440050 2440050 defendant Leme Thomas baker 594505 594505 Leme, Thomas, of Brandon Fery, Suff, baker 1
5337313 2456229 2456229 defendant Barnard John husbandman 594505 594505 Barnard, John, of Brandon Fery, Suff, husbandman 1
5358406 2462681 2462681 defendant Prowe Thomas husbandman 594505 594505 Prowe, Thomas, of Brandon Fery, Suff, husbandman 2
5425365 2482560 2482560 defendant Bernard John skinner 594505 594505 Bernard, John, of Brandon Fery, Suff, skinner 0
5475699 2497725 2497725 defendant Talawnutt Hugh yeoman 594505 594505 Talawnutt, Hugh, of Brandon Fery, Suff, yeoman 1
5481739 2499471 2499471 defendant Saunder John husbandman 594505 594505 Saunder, John, of Brandon Fery, Suff, husbandman 2
5486881 2500974 2500974 defendant Tollyn Hugh innholder 594505 594505 Tollyn, Hugh, of Brandon Fery, Suff, innholder 2
5503285 2505937 2505937 defendant George Robert yeoman 594505 594505 George, Robert, of Brandon Fery, Suff, yeoman 0
5509468 2507810 2507810 defendant Saunders John husbandman 594505 594505 Saunders, John, of Brandon Fery, Suff, husbandman 4
5519109 2510823 2510823 defendant Wagstaff alias Hardster William glover 594505 594505 Wagstaff alias Hardster, William, of Brandon Fery, Suff, glover 0
5522334 2511805 2511805 defendant Legge John yeoman 594505 594505 Legge, John, of Brandon Fery, Suff, yeoman 1
5527376 2513141 2513141 defendant Smere Richard husbandman 594505 594505 Smere, Richard, of Brandon Fery, Suff, husbandman 0
5527475 2513176 2513176 defendant Smere Richard husbandman 594505 594505 Smere, Richard, of Brandon Fery, Suff, husbandman 1
5568780 2525418 2525418 defendant Aleyn Geoffrey yeoman 594505 594505 Aleyn, Geoffrey, of Brandon Fery, Suff, yeoman 3
5591822 2532426 2532426 defendant Florey Richard innholder 594505 594505 Florey, Richard, of Brandon Fery, Suff, innholder 0
5597151 2534016 2534016 defendant Parker Hugh yeoman 594505 594505 Parker, Hugh, of Brandon Fery, Suff, yeoman 0
5598894 2534530 2534530 defendant Saunder John tailor 594505 594505 Saunder, John, of Brandon Fery, Suff, tailor 1

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);