names

33 rows where place_id = 590233

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600317 1867745 1867745 defendant Langdon John gent 590233 590233 Langdon, John, of South Pederwyn, gent 1
3659354 1913185 1913185 defendant Bennowe John laborer 590233 590233 Bennowe, John, of South Pederwyn, laborer 7
3680629 1920021 1920021 plaintiff Gydde William, junior   590233 590233 Gydde, William, junior, of South Pederwyn 8
3718828 1932169 1932169 defendant Cecily John husbandman 590233 590233 Cecily, John, of South Pederwyn, husbandman 0
3729098 1935351 1935351 defendant Blygh William yeoman 590233 590233 Blygh, William, of South Pederwyn, yeoman 0
3747206 1941043 1941043 plaintiff Downe Richard gent 590233 590233 Downe, Richard, of South Pederwyn, gent 0
3747486 1941129 1941129 defendant Lenne John yeoman 590233 590233 Lenne, John, of South Pederwyn, yeoman 0
3760275 1945217 1945217 defendant Wyllyam Peter   590233 590233 Wyllyam, Peter, of South Pederwyn, groom 1
3760276 1945217 1945217 defendant Wadeland William miller 590233 590233 Wadeland, William, of South Pederwyn, miller 2
3779519 1951317 1951317 defendant Lenne John yeoman 590233 590233 Lenne, John, of South Pederwyn, yeoman 0
3809389 1960819 1960819 defendant Lenne John yeoman 590233 590233 Lenne, John, of South Pederwyn, yeoman 0
3816993 1963223 1963223 defendant Oger William husbandman 590233 590233 Oger, William, of South Pederwyn, husbandman 0
3817507 1963383 1963383 defendant Blyghe William gent 590233 590233 Blyghe, William, of South Pederwyn, gent 2
3817508 1963383 1963383 defendant Blyghe Walter yeoman 590233 590233 Blyghe, Walter, of South Pederwyn, yeoman 3
3843433 1971483 1971483 defendant Blygh William gent 590233 590233 Blygh, William, of South Pederwyn, gent 0
3851656 1974105 1974105 defendant Sawdy William husbandman 590233 590233 Sawdy, William, of South Pederwyn, husbandman 0
3851657 1974105 1974105 defendant Gedy William husbandman 590233 590233 Gedy, William, of South Pederwyn, husbandman 1
3851658 1974105 1974105 defendant Notell William husbandman 590233 590233 Notell, William, of South Pederwyn, husbandman 2
3851659 1974105 1974105 defendant Peke John husbandman 590233 590233 Peke, John, of South Pederwyn, husbandman 3
3878463 1983041 1983041 defendant William Peter husbandman 590233 590233 William, Peter, of South Pederwyn, husbandman 7
3896365 1988990 1988990 defendant Holman William husbandman 590233 590233 Holman, William, of South Pederwyn, husbandman 0
3896366 1988990 1988990 defendant Holman John laborer 590233 590233 Holman, John, of South Pederwyn, laborer 1
3896367 1988990 1988990 defendant Parkyn Joan spinster 590233 590233 Parkyn, Joan, of South Pederwyn, spinster 2
3913580 1994881 1994881 defendant Woger William husbandman 590233 590233 Woger, William, of South Pederwyn, husbandman 5
3950702 2007319 2007319 defendant Boley John laborer 590233 590233 Boley, John, of South Pederwyn, laborer 0
3950703 2007319 2007319 defendant Cabell George laborer 590233 590233 Cabell, George, of South Pederwyn, laborer 1
3950704 2007319 2007319 defendant Boley Robert laborer 590233 590233 Boley, Robert, of South Pederwyn, laborer 2
4193200 2093191 2093191 defendant Bligh Leonard (legal representative) 590233 590233 Bligh, Leonard, of South Pederwyn, gent or yeoman, executors of 0
4705703 2267157 2267157 defendant Baudyn Roger husbandman 590233 590233 Baudyn, Roger, of South Pederwyn, husbandman 4
4705711 2267158 2267158 defendant Baudyn Roger husbandman 590233 590233 Baudyn, Roger, of South Pederwyn, husbandman 4
4879472 2320509 2320509 defendant Doune Thomas husbandman 590233 590233 Doune, Thomas, of South Pederwyn, husbandman 1
4879954 2320645 2320645 defendant Stephene Stephen husbandman 590233 590233 Stephene, Stephen, of South Pederwyn, husbandman 0
5589916 2531831 2531831 defendant Stephen Henry husbandman 590233 590233 Stephen, Henry, of South Pederwyn, husbandman 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);