names

19 rows where case_id = 2000272

✎ 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
3929680 2000272 2000272 plaintiff Carwardyne John (legal representative)   Carwardyne, John, executors of 0
3929681 2000272 2000272 plaintiff Garnans William gent, nephew of Testator   (Garnans, William, gent, nephew of Testator 1
3929682 2000272 2000272 plaintiff Carwardyne John eldest son of Testator   Carwardyne, John, eldest son of Testator 2
3929683 2000272 2000272 plaintiff Carwardyne Thomas second son of Testator   Carwardyne, Thomas, second son of Testator 3
3929684 2000272 2000272 defendant Morrys Richard husbandman 589505 589505 Morrys, Richard, of Kyngeston, husbandman 0
3929685 2000272 2000272 defendant Appoplyn Thomas husbandman 589505 589505 Appoplyn, Thomas, of Kyngeston, husbandman 1
3929686 2000272 2000272 defendant Day John husbandman 589505 589505 Day, John, of Kyngeston, husbandman 2
3929687 2000272 2000272 defendant Duppa Henry husbandman 589505 589505 Duppa, Henry, of Kyngeston, husbandman 3
3929688 2000272 2000272 defendant Beale William yeoman 592031 592031 Beale, William, of Madley, yeoman 4
3929689 2000272 2000272 defendant ap Rice Roger husbandman 592031 592031 ap Rice, Roger, of Madley, husbandman 5
3929690 2000272 2000272 defendant Carwardyen John ofo Madley, husbandman   Carwardyen, John, ofo Madley, husbandman 6
3929691 2000272 2000272 defendant Pantwall John husbandman 611150 611150 Pantwall, John, of Cublynton, husbandman 7
3929692 2000272 2000272 defendant Seyborne John husbandman 592031 592031 Seyborne, John, of Madley, husbandman 8
3929693 2000272 2000272 defendant Pytt Thomas yeoman 589505 589505 Pytt, Thomas, of Kyngeston, yeoman 9
3929694 2000272 2000272 defendant Penry Richard husbandman 653757 653757 Penry, Richard, of Coldewall, husbandman 10
3929695 2000272 2000272 defendant Penry John husbandman 653758 653758 Penry, John, of Byggesty, husbandman 11
3929696 2000272 2000272 defendant ap Jenour Walter husbandman 592031 592031 ap Jenour, Walter, of Madley, husbandman 12
3929697 2000272 2000272 defendant ap Rosser Richard husbandman 592031 592031 ap Rosser, Richard, of Madley, husbandman 13
3929698 2000272 2000272 defendant Treharen David husbandman   Treharen, David, husbandman 14

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