names

55 rows where place_id = 588125

✎ 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
3593456 1865586 1865586 defendant Telle Robert yeoman 588125 588125 Telle, Robert, of South Creke, yeoman 1
3636820 1906309 1906309 defendant Grene Nicholas husbandman 588125 588125 Grene, Nicholas, of South Creke, husbandman 0
3702577 1927074 1927074 defendant Ladell John carpenter 588125 588125 Ladell, John, of South Creke, carpenter 0
3702581 1927074 1927074 defendant Helyngton Richard husbandman 588125 588125 Helyngton, Richard, of South Creke, husbandman 4
3744782 1940269 1940269 plaintiff Bekham John (legal representative) 588125 588125 Bekham, John, of South Creke, executors of 0
3744785 1940270 1940270 plaintiff Bekham John (legal representative) 588125 588125 Bekham, John, of South Creke, executors of 0
3780069 1951489 1951489 defendant Peepes John yeoman 588125 588125 Peepes, John, of South Creke, yeoman 0
3791843 1955294 1955294 defendant Grene Thomas husbandman 588125 588125 Grene, Thomas, of South Creke, husbandman 0
3795981 1956606 1956606 defendant Agrene Thomas husbandman 588125 588125 Agrene, Thomas, of South Creke, husbandman 0
3822457 1964923 1964923 defendant Grene Thomas husbandman 588125 588125 Grene, Thomas, of South Creke, husbandman 0
3823604 1965281 1965281 defendant Ladell John carpenter 588125 588125 Ladell, John, of South Creke, carpenter 0
3848859 1973234 1973234 defendant Grene Thomas husbandman 588125 588125 Grene, Thomas, of South Creke, husbandman 0
3853446 1974704 1974704 defendant Deynes John husbandman 588125 588125 Deynes, John, of South Creke, husbandman 1
3855281 1975287 1975287 defendant Doynes John husbandman 588125 588125 Doynes, John, of South Creke, husbandman 0
3855283 1975287 1975287 defendant Curtes Robert   588125 588125 Curtes, Robert, of South Creke, shepherd 2
3869161 1979934 1979934 defendant Pacy Thomas husbandman 588125 588125 Pacy, Thomas, of South Creke, husbandman 1
3869162 1979934 1979934 defendant Daunce Henry husbandman 588125 588125 Daunce, Henry, of South Creke, husbandman 2
3879066 1983250 1983250 defendant Davell Robert draper 588125 588125 Davell, Robert, of South Creke, draper 0
3894009 1988212 1988212 defendant Belle Thomas husbandman 588125 588125 Belle, Thomas, of South Creke, husbandman 2
3896763 1989129 1989129 defendant Tylney Henry gent 588125 588125 Tylney, Henry, of South Creke, gent 0
3917459 1996199 1996199 defendant Lane Robert husbandman 588125 588125 Lane, Robert, of South Creke, husbandman 0
3917461 1996199 1996199 defendant Lane Thomas husbandman 588125 588125 Lane, Thomas, of South Creke, husbandman 2
3917462 1996199 1996199 defendant Secker Thomas husbandman 588125 588125 Secker, Thomas, of South Creke, husbandman 3
3917463 1996199 1996199 defendant Den Nicholas shoemaker 588125 588125 Den, Nicholas, of South Creke, shoemaker 4
3917464 1996199 1996199 defendant Wykeham John carpenter 588125 588125 Wykeham, John, of South Creke, carpenter 5
3917465 1996199 1996199 defendant Smythe Thomas husbandman 588125 588125 Smythe, Thomas, of South Creke, husbandman 6
3917466 1996199 1996199 defendant Symson William husbandman 588125 588125 Symson, William, of South Creke, husbandman 7
3917467 1996199 1996199 defendant Haylocke Thomas husbandman 588125 588125 Haylocke, Thomas, of South Creke, husbandman 8
3917468 1996199 1996199 defendant Hoker John husbandman 588125 588125 Hoker, John, of South Creke, husbandman 9
3917469 1996199 1996199 defendant Danyell Richard laborer 588125 588125 Danyell, Richard, of South Creke, laborer 10
3977003 2016524 2016524 plaintiff Lane Thomas yeoman 588125 588125 Lane, Thomas, of South Creke, yeoman 0
3991930 2021873 2021873 defendant Ulffe Thomas husbandman 588125 588125 Ulffe, Thomas, of South Creke, husbandman 0
3993091 2022280 2022280 defendant Pepys Thomas (legal representative) 588125 588125 Pepys, Thomas, of South Creke, gent, executors of 0
3993094 2022280 2022280 defendant Manser Richard gent 588125 588125 Manser, Richard, of South Creke, gent 3
3993124 2022289 2022289 defendant Cowell Robert husbandman 588125 588125 Cowell, Robert, of South Creke, husbandman 1
3993125 2022289 2022289 defendant Benwell Edmund yeoman 588125 588125 Benwell, Edmund, of South Creke, yeoman 2
4000517 2024955 2024955 defendant Lane Thomas yeoman 588125 588125 Lane, Thomas, of South Creke, yeoman 0
4004345 2026334 2026334 defendant Pepes Thomas (legal representative) 588125 588125 Pepes, Thomas, of South Creke, gent, executors of 0
4004346 2026334 2026334 defendant Manser Richard gent 588125 588125 (Manser, Richard, of South Creke, gent 1
4004347 2026334 2026334 defendant Norton Richard gent 588125 588125 Norton, Richard, of South Creke, gent 2
4010476 2028519 2028519 defendant Bourne James gent 588125 588125 Bourne, James, of South Creke, gent 2
4016935 2030758 2030758 defendant Seffowld Richard gent 588125 588125 Seffowld, Richard, of South Creke, gent 1
4068845 2049147 2049147 defendant Motte Martin husbandman 588125 588125 Motte, Martin, of South Creke, husbandman 1
4234028 2107427 2107427 defendant Iverrye Roger yeoman 588125 588125 Iverrye, Roger, of South Creke, yeoman 0
4910340 2329751 2329751 defendant Bryde John yeoman 588125 588125 Bryde, John, of south Creke, yeoman 0
4910341 2329751 2329751 defendant Sundour John yeoman 588125 588125 Sundour, John, of South Creke, yeoman 1
4910342 2329751 2329751 defendant Hard Willam yeoman 588125 588125 Hard, Willam, of South Creke, yeoman 2
4910343 2329751 2329751 defendant Sawer Willam yeoman 588125 588125 Sawer, Willam, of South Creke, yeoman 3
5379372 2469140 2469140 defendant Lambard Thomas husbandman 588125 588125 Lambard, Thomas, of South Creke, husbandman 3
5440454 2487047 2487047 defendant Brenetour John laborer 588125 588125 Brenetour, John, of South Creke, laborer 6
5510019 2507974 2507974 defendant Denys Edmund husbandman 588125 588125 Denys, Edmund, of South Creke, husbandman 2
5552437 2520767 2520767 defendant Norton William yeoman 588125 588125 Norton, William, of South Creke, yeoman 0
5552438 2520767 2520767 defendant Brenytour John smith 588125 588125 Brenytour, John, of South Creke, smith 1
5552439 2520767 2520767 defendant Skynner John laborer 588125 588125 Skynner, John, of South Creke, laborer 2
5607887 2537370 2537370 defendant Style Thomas clerk 588125 588125 Style, Thomas, of South Creke, or of Wysebech, Cams, clerk 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);