names

15 rows where case_id = 2063029

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4107687 2063029 2063029 plaintiff Pope George attorney of the bench   Pope, George, attorney of the bench 0
4107688 2063029 2063029 defendant Cheyney Thomas gent 615397 615397 Cheyney, Thomas, of Ensham, Oxon, gent 0
4107689 2063029 2063029 defendant Pynge William yeoman 638656 638656 Pynge, William, of Blandford Forum, Dorset, yeoman 1
4107690 2063029 2063029 defendant Tucker William husbandman 695081 695081 Tucker, William, of Wotton Glanfeld, Dorset, husbandman 2
4107691 2063029 2063029 defendant Frye William yeoman 620747 620747 Frye, William, of Brewton, Soms, yeoman 3
4107692 2063029 2063029 defendant Vincent William husbandman 695082 695082 Vincent, William, of Fowntmell, Dorset, husbandman 4
4107693 2063029 2063029 defendant Hebdyche Robert husbandman 694640 694640 Hebdyche, Robert, of Pulham, Dorset, husbandman 5
4107694 2063029 2063029 defendant Rive Walter husbandman 680597 680597 Rive, Walter, of Askerswell, Dorset, husbandman 6
4107695 2063029 2063029 defendant Norman Stephen husbandman 670961 670961 Norman, Stephen, of Brewham, Soms, husbandman 7
4107696 2063029 2063029 defendant Inglysshe Peter clerk 587913 587913 Inglysshe, Peter, of Pulham, clerk 8
4107697 2063029 2063029 defendant Chard Eleanor widow 695083 695083 Chard, Eleanor, of Yetmyster, Dorset, widow 9
4107698 2063029 2063029 defendant Kene John yeoman 695084 695084 Kene, John, of Upwymborne, Dorset, yeoman 10
4107699 2063029 2063029 defendant Randulphe William yeoman 585869 585869 Randulphe, William, of London, yeoman 11
4107700 2063029 2063029 defendant Buxley Richard yeoman 585869 585869 Buxley, Richard, of London, yeoman 12
4107701 2063029 2063029 defendant Morgan Stephen yeoman 670284 670284 Morgan, Stephen, of Chettell, Dorset, 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);