names

35 rows where place_id = 619453

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3729960 1935622 1935622 defendant Smyth Thomas   619453 619453 Smyth, Thomas, of Hopton, Suff, wheel wright 3
3730003 1935629 1935629 defendant Stokkyng John, senior husbandman 619453 619453 Stokkyng, John, senior, of Hopton, Suff, husbandman 0
3771318 1948720 1948720 defendant Prest Robert husbandman 619453 619453 (Prest, Robert, of Hopton, Suff, husbandman 2
3808433 1960515 1960515 defendant Gower John mercer 619453 619453 Gower, John, of Hopton, Suff, mercer 0
3876364 1982341 1982341 plaintiff Gowre John mercer 619453 619453 Gowre, John, of Hopton, Suff, mercer 0
3929739 2000285 2000285 defendant Taylyor Robert tailor 619453 619453 Taylyor, Robert, of Hopton, Suff, tailor 1
3930509 2000545 2000545 defendant Taylour Robert tailor 619453 619453 Taylour, Robert, of Hopton, Suff, tailor 1
4018577 2031376 2031376 defendant Twynne Richard clerk 619453 619453 Twynne, Richard, of Hopton, Suff, clerk 0
4049016 2042092 2042092 defendant Hern Peter yeoman 619453 619453 Hern, Peter, of Hopton, Suff, yeoman 0
4085040 2054929 2054929 defendant Brownynge Robert gent 619453 619453 Brownynge, Robert, of Hopton, Suff, gent 0
4176355 2087206 2087206 defendant Twynne Richard clerk 619453 619453 Twynne, Richard, of Hopton, Suff, clerk 3
4276789 2121814 2121814 defendant Baxter John tailor 619453 619453 Baxter, John, of Hopton, Suff, tailor 2
4327654 2139569 2139569 defendant Gylbert Robert gent 619453 619453 Gylbert, Robert, of Hopton, Suff, gent 0
4393139 2162311 2162311 defendant Cotes John carpenter 619453 619453 Cotes, John, of Hopton, Suff, carpenter 2
4659436 2248812 2248812 defendant Inges William gent 619453 619453 Inges, William, of Hopton, Suff, gent 0
4676852 2258380 2258380 defendant Birlyngham William laborer 619453 619453 Birlyngham, William, of Hopton, Suff, laborer 0
4683146 2260344 2260344 defendant Enges William de husbandman 619453 619453 Enges, William de, of Hopton, Suff, husbandman 0
4683148 2260345 2260345 defendant Buges William de husbandman 619453 619453 Buges, William de, of Hopton, Suff, husbandman 0
4695596 2264108 2264108 defendant Enges William gent 619453 619453 Enges, William, of Hopton, Suff, gent 0
4742894 2278430 2278430 defendant Inges William yeoman 619453 619453 Inges, William, of Hopton, Suff, franklin, Bekytonne, Rose, of Lodne, widow: Cok, Roger, of Hardle, yeoman 1
4761676 2283996 2283996 defendant Inges William gent 619453 619453 Inges, William, of Hopton, Suff, gent 0
4776008 2288496 2288496 defendant Inges William gent 619453 619453 Inges, William, of Hopton, Suff, gent 1
4785134 2291363 2291363 defendant Ingges William gent 619453 619453 Ingges, William, of Hopton, Suff, gent 0
4851230 2311833 2311833 defendant Inges William gent 619453 619453 Inges, William, of Hopton, Suff, gent 0
4893898 2324793 2324793 defendant Ynges William gent 619453 619453 Ynges, William, of Hopton, Suff, gent 0
5048335 2371136 2371136 defendant Stywardesson William husbandman 619453 619453 Stywardesson, William, of Hopton, Suff, husbandman 0
5083450 2381547 2381547 defendant Bee Edmund husbandman 619453 619453 Bee, Edmund, of Hopton, Suff, husbandman 1
5233415 2425363 2425363 defendant Guges Robert gent 619453 619453 Guges, Robert, of Hopton, Suff, gent 0
5239509 2427139 2427139 defendant Ingys Robert gent 619453 619453 Ingys, Robert, of Hopton, Suff, gent 0
5281808 2439752 2439752 defendant Parker Simon (legal representative) 619453 619453 Parker, Simon, of Hopton, Suff, husbandman, executors of 0
5287150 2441256 2441256 defendant Laderer Richard smith 619453 619453 Laderer, Richard, of Hopton, Suff, smith 1
5303214 2445955 2445955 defendant Hopper Richard husbandman 619453 619453 Hopper, Richard, of Hopton, Suff, husbandman 2
5306965 2447079 2447079 defendant Borom Henry chaplain 619453 619453 Borom, Henry, of Hopton, Suff, chaplain 2
5444045 2488134 2488134 defendant Cawyn John husbandman 619453 619453 Cawyn, John, of Hopton, Suff, husbandman 2
5548669 2519653 2519653 defendant Parker John butcher 619453 619453 Parker, John, of Hopton, Suff, butcher 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);