names

25 rows where place_id = 594259

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615325 1872437 1872437 defendant Narker Joan widow 594259 594259 Narker, Joan, of Stoke, Suff, widow 2
3623143 1874760 1874760 defendant Warner John clothmaker 594259 594259 Warner, John, of Stoke, Suff, clothmaker 0
3750980 1942233 1942233 defendant Hamond Thomasine widow 594259 594259 Hamond, Thomasine, of Stoke, Suff, widow 1
3975046 2015834 2015834 defendant Coker John shoemaker 594259 594259 Coker, John, of Stoke, Suff, shoemaker 0
4132248 2071847 2071847 defendant Talkarne Edward gent 594259 594259 Talkarne, Edward, of Stoke, Suff, gent 0
4218365 2101923 2101923 defendant Baker George clothier 594259 594259 Baker, George, of Stoke, Suff, clothier 0
4232183 2106760 2106760 defendant Deeke John yeoman 594259 594259 Deeke, John, of Stoke, Suff, yeoman 0
4237750 2108802 2108802 defendant Porter Henry yeoman 594259 594259 Porter, Henry, of Stoke, Suff, yeoman 0
4259029 2115991 2115991 defendant Porter Henry yeoman 594259 594259 Porter, Henry, of Stoke, Suff, yeoman 0
4268392 2119032 2119032 defendant Baker George clothier 594259 594259 Baker, George, of Stoke, Suff, clothier 0
4401786 2165196 2165196 defendant Dyke John yeoman 594259 594259 Dyke, John, of Stoke, Suff, yeoman 0
4675187 2257851 2257851 defendant Laurence John fuller 594259 594259 Laurence, John, of Stoke, Suff, fuller 1
4679497 2259201 2259201 defendant Fisch Henry husbandman 594259 594259 Fisch, Henry, of Stoke, Suff, husbandman 2
4696431 2264362 2264362 defendant Hunte John   594259 594259 Hunte, John, of Stoke, Suff, "synger" 2
4736157 2276443 2276443 defendant Smyth John merchant 594259 594259 Smyth, John, of Stoke, Suff, merchant 5
4803202 2297192 2297192 defendant Waltham Thomas   594259 594259 Waltham, Thomas, of Stoke, Suff, mason 2
4803547 2297297 2297297 defendant Bocher John yeoman 594259 594259 Bocher, John, of Stoke, Suff, yeoman 0
4936483 2337800 2337800 defendant Lunt John husbandman 594259 594259 Lunt, John, of Stoke, Suff, husbandman 0
5081975 2381104 2381104 defendant Walle William barker 594259 594259 Walle, William, of Stoke, Suff, barker 0
5081978 2381105 2381105 defendant Walle William barker 594259 594259 Walle, William, of Stoke, Suff, barker 0
5121427 2392698 2392698 defendant Bregge William yeoman 594259 594259 (Bregge, William, of Stoke, Suff, yeoman 3
5557711 2522208 2522208 defendant Rothwell John clerk 594259 594259 Rothwell, John, of Stoke, Suff, clerk 3
5623686 2551345 2551345 defendant Fyssche Henry barker 594259 594259 Fyssche, Henry, of Stoke, Suff, barker 1
5630931 2553685 2553685 defendant Parkere John smith 594259 594259 Parkere, John, of Stoke, Suff, smith 1
5635663 2555112 2555112 defendant Parker John gent 594259 594259 Parker, John, of Stoke, Suff, gent 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);