names

20 rows where place_id = 614230

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3702587 1927077 1927077 defendant Hereford William gent 614230 614230 Hereford, William, of Mordyford, gent 0
3712019 1930076 1930076 defendant Wynter Margaret widow 614230 614230 Wynter, Margaret, of Mordyford, widow 2
3952328 2007885 2007885 defendant Merser Richard husbandman 614230 614230 Merser, Richard, of Mordyford, husbandman 0
3959342 2010349 2010349 defendant Marcer William laborer 614230 614230 Marcer, William, of Mordyford, laborer 0
3974618 2015687 2015687 defendant Warren Richard laborer 614230 614230 Warren, Richard, of Mordyford, laborer 0
3980049 2017626 2017626 defendant Taylor Thomas yeoman 614230 614230 Taylor, Thomas, of Mordyford, yeoman 1
4058953 2045596 2045596 defendant Lovell George husbandman 614230 614230 Lovell, George, of Mordyford, husbandman 3
4059463 2045780 2045780 defendant Lovell George husbandman 614230 614230 Lovell, George, of Mordyford, husbandman 0
4096865 2059212 2059212 defendant Lovell George husbandman 614230 614230 Lovell, George, of Mordyford, husbandman 0
4106659 2062672 2062672 defendant ap Adam George cordwainer 614230 614230 ap Adam, George, of Mordyford, cordwainer 0
4159022 2081224 2081224 defendant Lovell George husbandman 614230 614230 Lovell, George, of Mordyford, husbandman 1
4204060 2096971 2096971 defendant Lovell George yeoman 614230 614230 Lovell, George, of Mordyford, yeoman 2
4204061 2096971 2096971 defendant Mercer Thomas yeoman 614230 614230 Mercer, Thomas, of Mordyford, yeoman 3
4223177 2103595 2103595 defendant Unett Francis esq 614230 614230 Unett, Francis, of Mordyford, or of Castle Frome, esq 1
4234575 2107639 2107639 defendant Parsons Katherine widow 614230 614230 Parsons, Katherine, of Mordyford, widow 1
4234578 2107640 2107640 defendant Parsons Katherine widow 614230 614230 Parsons, Katherine, of Mordyford, widow 1
4248483 2112479 2112479 defendant Unett Francis esq 614230 614230 Unett, Francis, of Mordyford, or of Castle Frome, esq 1
4319168 2136817 2136817 defendant Davies William husbandman 614230 614230 Davies, William, of Mordyford, husbandman 2
4971362 2348363 2348363 defendant Hereford William gent 614230 614230 (Hereford, William, of Mordyford, gent 2
5127056 2394390 2394390 defendant Smyth Lewis smith 614230 614230 Smyth, Lewis, of Mordyford, smith 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);