names

18 rows where case_id = 2336035

✎ 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
4930784 2336035 2336035 plaintiff Turton Richard     Turton, Richard 0
4930785 2336035 2336035 defendant Greve Thomas   768700 768700 Greve, Thomas, of Hunshelf 0
4930786 2336035 2336035 defendant Greve Nicholas   768700 768700 Greve, Nicholas, of Hunshelf 1
4930787 2336035 2336035 defendant Walker John   823845 823845 Walker, John, of Hunsthelf 2
4930788 2336035 2336035 defendant Walker Richard   823846 823846 Walker, Richard, of Waldyrchelf 3
4930789 2336035 2336035 defendant Wordylworth William   641372 641372 Wordylworth, William, of Penyston 4
4930790 2336035 2336035 defendant Wordylworth John   641372 641372 Wordylworth, John, of Penyston 5
4930791 2336035 2336035 defendant Wordelworth John husbandman 592530 592530 Wordelworth, John, of Thurleston, husbandman 6
4930792 2336035 2336035 defendant Ryche William, senior   592530 592530 Ryche, William, senior, of Thurleston 7
4930793 2336035 2336035 defendant Riche William, junior   592530 592530 Riche, William, junior, of Thurleston 8
4930794 2336035 2336035 defendant Rycher John, junior laborer 592530 592530 Rycher, John, junior, of Thurleston, laborer 9
4930795 2336035 2336035 defendant Hattyrslay Richard laborer 823847 823847 Hattyrslay, Richard, of Langset, laborer 10
4930796 2336035 2336035 defendant Dyghton William   823848 823848 Dyghton, William, of Dalton by Heton 11
4930797 2336035 2336035 defendant Dyghton Robert   662814 662814 Dyghton, Robert, of Wollay 12
4930798 2336035 2336035 defendant Dyghton John   823849 823849 Dyghton, John, of Hegholand, mesne parson 13
4930799 2336035 2336035 defendant Byrton Richard   809189 809189 Byrton, Richard, of Swalwell 14
4930800 2336035 2336035 defendant Warde Hugh   823850 823850 Warde, Hugh, of Wyrsburgh 15
4930801 2336035 2336035 defendant each a yeoman unless given otherwise     each a yeoman, unless given otherwise 16

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