names

21 rows where case_id = 2436018

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5268895 2436018 2436018 plaintiff Bromhale William   866379 866379 Bromhale, William, of Worsworth or Wirksworth 0
5268896 2436018 2436018 defendant Sacheverell Ralph esq 609330 609330 Sacheverell, Ralph, of Snyterton, esq 0
5268897 2436018 2436018 defendant Johnson William husbandman 866380 866380 Johnson, William, of Tansley, husbandman 1
5268898 2436018 2436018 defendant Johnson James husbandman 866381 866381 Johnson, James, of Thansley, husbandman 2
5268899 2436018 2436018 defendant Godbyhere John husbandman 866380 866380 Godbyhere, John, of Tansley, husbandman 3
5268900 2436018 2436018 defendant Sedon John husbandman 866380 866380 Sedon, John, of Tansley, husbandman 4
5268901 2436018 2436018 defendant Hafeld John smelter 866380 866380 Hafeld, John, of Tansley, smelter 5
5268902 2436018 2436018 defendant Robynson John husbandman 800946 800946 Robynson, John, of Wessyngton, husbandman 6
5268903 2436018 2436018 defendant Mader Thomas husbandman 866382 866382 Mader, Thomas, of Wodesetes, husbandman 7
5268904 2436018 2436018 defendant Helde Thurstan yeoman 598844 598844 Helde, Thurstan, of Matloke, yeoman 8
5268905 2436018 2436018 defendant Thomas of Matlock husbandman   Thomas, of Matlock, husbandman 9
5268906 2436018 2436018 defendant Amote Thomas laborer 598844 598844 Amote, Thomas, of Matloke, laborer 10
5268907 2436018 2436018 defendant Burton John husbandman 598844 598844 Burton, John, of Matloke, husbandman 11
5268908 2436018 2436018 defendant Hauk John yeoman 866383 866383 Hauk, John, of Wednesley, yeoman 12
5268909 2436018 2436018 defendant Hobehous Nicholas husbandman 866383 866383 Hobehous, Nicholas, of Wednesley, husbandman 13
5268910 2436018 2436018 defendant Gayte Henry yeoman 866384 866384 Gayte, Henry, of Bonshale, yeoman 14
5268911 2436018 2436018 defendant Baystowe William laborer 866385 866385 Baystowe, William, of Bonshalle, laborer 15
5268912 2436018 2436018 defendant Hayward Thurstan yeoman 866385 866385 Hayward, Thurstan, of Bonshalle, yeoman 16
5268913 2436018 2436018 defendant Rowebethum John husbandman 607460 607460 Rowebethum, John, of Ryver, husbandman 17
5268914 2436018 2436018 defendant Willer William husbandman 607460 607460 Willer, William, of Ryver, husbandman 18
5268915 2436018 2436018 defendant Cowehope Robert husbandman 607460 607460 Cowehope, Robert, of Ryver, husbandman 19

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);