names

25 rows where case_id = 2310852

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4848008 2310852 2310852 plaintiff Sanell or Savell Thomas knight   Sanell or Savell, Thomas, knight 0
4848009 2310852 2310852 defendant Smyth Thomas   752971 752971 Smyth, Thomas, of Peneston 0
4848010 2310852 2310852 defendant Walton William butcher 592530 592530 Walton, William, of Thurleston, butcher 1
4848011 2310852 2310852 defendant Walton John tailor 592530 592530 Walton, John, of Thurleston, tailor 2
4848012 2310852 2310852 defendant Morehous William   592530 592530 Morehous, William, of Thurleston 3
4848013 2310852 2310852 defendant Coldwell John   707905 707905 Coldwell, John, of Holmefyrth 4
4848014 2310852 2310852 defendant Littlelwode James   793875 793875 Littlelwode, James, of Holmefryth 5
4848015 2310852 2310852 defendant Wodecok Thomas   793875 793875 Wodecok, Thomas, of Holmefryth 6
4848016 2310852 2310852 defendant Whitley Thurston   793875 793875 Whitley, Thurston, of Holmefryth 7
4848017 2310852 2310852 defendant Gaunt William   793875 793875 Gaunt, William, of Holmefryth 8
4848018 2310852 2310852 defendant Lynley Richard   793875 793875 Lynley, Richard, of Holmefryth 9
4848019 2310852 2310852 defendant Colewell John   618075 618075 Colewell, John, of Hepworth, 10
4848020 2310852 2310852 defendant Milleshawe William   618075 618075 Milleshawe, William, of Hepworth 11
4848021 2310852 2310852 defendant Rodes John   793875 793875 Rodes, John, of Holmefryth 12
4848022 2310852 2310852 defendant Diconson Richard   793875 793875 Diconson, Richard, of Holmefryth 13
4848023 2310852 2310852 defendant Lynley John   793875 793875 Lynley, John, of Holmefryth 14
4848024 2310852 2310852 defendant Riche John   793875 793875 Riche, John, of Holmefryth 15
4848025 2310852 2310852 defendant Riche John   592530 592530 Riche, John, of Thurleston 16
4848026 2310852 2310852 defendant Atkynson Thomas   793875 793875 Atkynson, Thomas, of Holmefryth 17
4848027 2310852 2310852 defendant Otes William   793875 793875 Otes, William, of Holmefryth 18
4848028 2310852 2310852 defendant Tynker Thomas   793875 793875 Tynker, Thomas, of Holmefryth 19
4848029 2310852 2310852 defendant Tynker William   793875 793875 Tynker, William, of Holmefryth 20
4848030 2310852 2310852 defendant Charleworth John   793875 793875 Charleworth, John, of Holmefryth 21
4848031 2310852 2310852 defendant Brodehed William   793875 793875 Brodehed, William, of Holmefryth 22
4848032 2310852 2310852 defendant each a husbandman except where contra-indicated     each a husbandman, except where contra-indicated 23

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