names

19 rows where place_id = 610323

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3683004 1920797 1920797 defendant James Thomas husbandman 610323 610323 James, Thomas, of Bradforde, husbandman 3
3710651 1929651 1929651 defendant Hurman John husbandman 610323 610323 (Hurman, John, of Bradforde, husbandman 5
3904285 1991679 1991679 defendant Lokkey Nicholas clothier 610323 610323 Lokkey, Nicholas, of Bradforde, clothier 0
3968172 2013495 2013495 plaintiff Catherall or Catterall Robert gent 610323 610323 Catherall or Catterall, Robert, of Bradforde, gent 0
4019483 2031697 2031697 plaintiff Webbe Anthony yeoman 610323 610323 Webbe, Anthony, of Bradforde, yeoman 0
4067896 2048828 2048828 defendant Masters John butcher 610323 610323 Masters, John, of Bradforde, butcher 0
4067897 2048828 2048828 defendant Hancocke John butcher 610323 610323 Hancocke John, of Bradforde, butcher 1
4067898 2048828 2048828 defendant Mathewe Thomas yeoman 610323 610323 Mathewe, Thomas, of Bradforde, yeoman 2
4067899 2048828 2048828 defendant Byryngton William gent 610323 610323 Byryngton, William, of Bradforde, gent 3
4127935 2070281 2070281 defendant Rodley Thomas yeoman 610323 610323 Rodley, Thomas, of Bradforde, yeoman 3
4131553 2071603 2071603 defendant Webber William   610323 610323 Webber, William, of Bradforde, butcher, administrators of 0
4155688 2080070 2080070 defendant Drake Robert laborer 610323 610323 Drake, Robert, of Bradforde, laborer 2
4196518 2094325 2094325 defendant Geren or Gerne John gent 610323 610323 Geren or Gerne, John, of Bradforde, gent 0
4306887 2132550 2132550 defendant Thorne Robert yeoman 610323 610323 Thorne, Robert, of Bradforde, yeoman 0
4321791 2137708 2137708 defendant Martyn Thomas husbandman 610323 610323 Martyn, Thomas, of Bradforde, husbandman 1
4371831 2154988 2154988 defendant Cuddemore Robert husbandman 610323 610323 Cuddemore, Robert, of Bradforde, husbandman 0
4373587 2155622 2155622 defendant Rowsewell Augustine yeoman 610323 610323 Rowsewell, Augustine, of Bradforde, yeoman 0
4387504 2160465 2160465 defendant Bates Edward clothier 610323 610323 Bates, Edward, of Bradforde, clothier 1
4777429 2288936 2288936 defendant Tyrsall William gent 610323 610323 Tyrsall, William, of Bradforde, gent 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);