names

37 rows where place_id = 598568

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633117 1905169 1905169 defendant Elphek John husbandman 598568 598568 Elphek, John, of Chetynglegh, husbandman 0
3707937 1928780 1928780 defendant Pratye John husbandman 598568 598568 Pratye, John, of Chetynglegh, husbandman 0
3720678 1932757 1932757 defendant Midmore William laborer 598568 598568 Midmore, William, of Chetynglegh, laborer 0
3722524 1933304 1933304 defendant Pratye John husbandman 598568 598568 Pratye, John, of Chetynglegh, husbandman 0
3723567 1933645 1933645 defendant Pratye John yeoman 598568 598568 Pratye, John, of Chetynglegh, yeoman 0
3723568 1933645 1933645 defendant Pratye Thomas laborer 598568 598568 Pratye, Thomas, of Chetynglegh, laborer 1
3765685 1946931 1946931 defendant Assheton Simon laborer 598568 598568 Assheton, Simon, of Chetynglegh, laborer 1
3802946 1958818 1958818 plaintiff Praty John   598568 598568 Praty, John, of Chetynglegh 0
3802947 1958818 1958818 defendant Mydmore William (legal representative) 598568 598568 Mydmore, William, of Chetynglegh, chapman, executor of 0
3818481 1963679 1963679 defendant Lulham William carpenter 598568 598568 Lulham, William, of Chetynglegh, carpenter 1
3932566 2001179 2001179 defendant Frenche Richard yeoman 598568 598568 Frenche, Richard, of Chetynglegh, yeoman 0
4846121 2310293 2310293 defendant Wodefold John husbandman 598568 598568 Wodefold, John, of Chetynglegh, husbandman 2
4866204 2316401 2316401 defendant Fynch Miles husbandman 598568 598568 Fynch, Miles, of Chetynglegh, husbandman 0
4866206 2316401 2316401 defendant Trachom Robert husbandman 598568 598568 Trachom, Robert, of Chetynglegh, husbandman 2
4870524 2317754 2317754 defendant Wodefold John husbandman 598568 598568 Wodefold, John, of Chetynglegh, husbandman 1
4874905 2319095 2319095 defendant Cook John parker 598568 598568 Cook, John, of Chetynglegh, parker 0
4957983 2344356 2344356 defendant Clyfford Henry cordwainer 598568 598568 Clyfford, Henry, of Chetynglegh, cordwainer 2
4999419 2356697 2356697 defendant Croucher Thomas husbandman 598568 598568 Croucher, Thomas, of Chetynglegh, husbandman 1
5021620 2363223 2363223 defendant Croucher Thomas husbandman 598568 598568 Croucher, Thomas, of Chetynglegh, husbandman 0
5021621 2363223 2363223 defendant Croucher Robert husbandman 598568 598568 Croucher, Robert, of Chetynglegh, husbandman 1
5047269 2370805 2370805 defendant Berd John husbandman 598568 598568 Berd, John, of Chetynglegh, husbandman 1
5137772 2397559 2397559 defendant Thundyr John yeoman 598568 598568 Thundyr, John, of Chetynglegh, yeoman 0
5157985 2403460 2403460 defendant Thundyr John yeoman 598568 598568 Thundyr, John, of Chetynglegh, yeoman 0
5194401 2414092 2414092 defendant Thundyr John yeoman 598568 598568 Thundyr, John, of Chetynglegh, yeoman 0
5219230 2421347 2421347 defendant Lye William baker 598568 598568 Lye, William, of Chetynglegh, baker 1
5252088 2430763 2430763 plaintiff atte Welle John   598568 598568 atte Welle, John, of Chetynglegh 0
5358926 2462842 2462842 plaintiff Praty Thomas   598568 598568 Praty, Thomas, of Chetynglegh 0
5541016 2517316 2517316 defendant Fawekener William husbandman 598568 598568 Fawekener, William, of Chetynglegh, husbandman 0
5541017 2517316 2517316 defendant Frenshe Margaret widow 598568 598568 Frenshe, Margaret, of Chetynglegh, widow 1
5541018 2517316 2517316 defendant Frensshe John, junior husbandman 598568 598568 Frensshe, John, junior, of Chetynglegh, husbandman 2
5561046 2523200 2523200 defendant Frensshe Richard   598568 598568 Frensshe, Richard, of Chetynglegh, husbandman, administrators of 0
5561047 2523200 2523200 defendant Frensshe John, senior husbandman 598568 598568 (Frensshe, John, senior, of Chetynglegh, husbandman 1
5573800 2526903 2526903 defendant Mydmore William, senior yeoman 598568 598568 Mydmore, William, senior, of Chetynglegh, yeoman 0
5573801 2526903 2526903 defendant Mydmore William, junior laborer 598568 598568 Mydmore, William, junior, of Chetynglegh, laborer 1
5573802 2526903 2526903 defendant Mydmore Richard laborer 598568 598568 Mydmore, Richard, of Chetynglegh, laborer 2
5573804 2526904 2526904 defendant Mydmore William, senior husbandman 598568 598568 Mydmore, William, senior, of Chetynglegh, husbandman 0
5583382 2529876 2529876 plaintiff Frenche John   598568 598568 Frenche, John, of Chetynglegh, 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);