names

27 rows where place_id = 595402

✎ 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
3620331 1873940 1873940 defendant Parker William tailor 595402 595402 Parker, William, of Russhall, tailor 1
3688316 1922501 1922501 defendant Wade Humphrey husbandman 595402 595402 Wade, Humphrey, of Russhall, husbandman 1
3688319 1922502 1922502 defendant Wade Humphrey husbandman 595402 595402 Wade, Humphrey, of Russhall, husbandman 1
3699083 1925920 1925920 defendant Worsey Henry husbandman 595402 595402 Worsey, Henry, of Russhall, husbandman 0
3699084 1925920 1925920 defendant Myllys Henry laborer 595402 595402 Myllys, Henry, of Russhall, laborer 1
3699085 1925920 1925920 defendant Hawarden Henry laborer 595402 595402 Hawarden, Henry, of Russhall, laborer 2
3831942 1967887 1967887 defendant Jenyns Henry smith 595402 595402 Jenyns, Henry, of Russhall, smith 0
3831943 1967887 1967887 defendant Wakeley Richard weaver 595402 595402 Wakeley, Richard, of Russhall, weaver 1
3831944 1967887 1967887 defendant Pulton Humphrey laborer 595402 595402 Pulton, Humphrey, of Russhall, laborer 2
3836729 1969388 1969388 defendant Harryson John husbandman 595402 595402 Harryson, John, of Russhall, husbandman 2
3882156 1984290 1984290 defendant Bratte Richard clerk 595402 595402 Bratte, Richard, of Russhall, clerk 3
3882158 1984291 1984291 defendant Bratte Richard clerk 595402 595402 Bratte, Richard, of Russhall, clerk 0
3909862 1993605 1993605 defendant Bratte Richard clerk 595402 595402 Bratte, Richard, of Russhall, clerk 0
3923696 1998236 1998236 defendant Bratte Richard clerk 595402 595402 Bratte, Richard, of Russhall, clerk 0
3932559 2001177 2001177 defendant Johnson John yeoman 595402 595402 Johnson, John, of Russhall, yeoman 0
3955537 2009006 2009006 defendant Shepard John miller 595402 595402 Shepard, John, of Russhall, miller 2
3970088 2014137 2014137 plaintiff Curtys John yeoman 595402 595402 Curtys, John, of Russhall, yeoman 0
3970093 2014139 2014139 plaintiff Curtyse John   595402 595402 Curtyse, John, of Russhall 0
3980067 2017633 2017633 defendant Curteys John yeoman 595402 595402 Curteys, John, of Russhall, yeoman 0
3982319 2018450 2018450 defendant Hawkes Richard gent 595402 595402 Hawkes, Richard, of Russhall, gent 0
4029650 2035242 2035242 defendant Harryson Thomas husbandman 595402 595402 Harryson, Thomas, of Russhall, husbandman 0
4034766 2037114 2037114 plaintiff Hawke Richard gent 595402 595402 Hawke, Richard, of Russhall, gent 0
4039416 2038723 2038723 defendant Oker Katherine widow 595402 595402 Oker, Katherine, of Russhall, widow 0
4077423 2052213 2052213 defendant Hawkes Richard gent 595402 595402 Hawkes, Richard, of Russhall, gent 1
4274890 2121166 2121166 defendant Chadwell Walter husbandman 595402 595402 Chadwell, Walter, of Russhall, husbandman 0
4275465 2121357 2121357 defendant Pacyent Henry tucker 595402 595402 Pacyent, Henry, of Russhall, tucker 1
4946241 2340810 2340810 defendant Wydesey John carter 595402 595402 Wydesey, John, of Russhall, carter 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);