names

15 rows where case_id = 2083109

✎ 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
4164531 2083109 2083109 plaintiff Vaughan Francis esq   Vaughan, Francis, esq 0
4164532 2083109 2083109 defendant Knowle Richard husbandman 663038 663038 Knowle, Richard, of Bradnor, husbandman 0
4164533 2083109 2083109 defendant Meredithe Richard yeoman 664141 664141 Meredithe, Richard, of Kington, yeoman 1
4164534 2083109 2083109 defendant Staundrett or Scaundrett Richard yeoman 664141 664141 Staundrett or Scaundrett, Richard, of Kington, yeoman 2
4164535 2083109 2083109 defendant Hewood Richard yeoman 664141 664141 Hewood, Richard, of Kington, yeoman 3
4164536 2083109 2083109 defendant Heywood Richard yeoman 664141 664141 Heywood, Richard, of Kington, yeoman 4
4164537 2083109 2083109 defendant Bulcott Richard yeoman 675520 675520 Bulcott, Richard, of Hergest, yeoman 5
4164538 2083109 2083109 defendant Staundrett or Scaundrett Rice dyer 593772 593772 together with Staundrett or Scaundrett, Rice, of Kyngton, dyer 6
4164539 2083109 2083109 defendant Tayler Thomas husbandman 664141 664141 Tayler, Thomas, of Kington, husbandman 7
4164540 2083109 2083109 defendant Powell John yeoman 664141 664141 Powell, John, of Kington, yeoman 8
4164541 2083109 2083109 defendant Burgwyn Jevan   664141 664141 Burgwyn, Jevan, of Kington 9
4164542 2083109 2083109 defendant Powell Richard yeoman 664141 664141 Powell, Richard, of Kington, yeoman 10
4164543 2083109 2083109 defendant Lewes Thomas husbandman 593772 593772 Lewes, Thomas, of Kyngton, husbandman 11
4164544 2083109 2083109 defendant Williams Thomas shoemaker 593772 593772 Williams, Thomas, of Kyngton, shoemaker 12
4164545 2083109 2083109 defendant Turner John yeoman 664141 664141 Turner, John, of Kington, yeoman 13

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