names

19 rows where place_id = 789716

✎ 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
4714789 2269959 2269959 defendant Scot Thomas laborer 789716 789716 Scot, Thomas, of Kyngesbyre, laborer 0
4714791 2269960 2269960 defendant Langelond Walter weaver 789716 789716 Langelond, Walter, of Kyngesbyre, weaver 0
4799643 2296071 2296071 defendant Baker Thomas   789716 789716 Baker, Thomas, of Kyngesbyre 0
4808828 2298927 2298927 defendant Frome Thomas gent 789716 789716 Frome, Thomas, of Kyngesbyre, gent 0
4829510 2305269 2305269 defendant Turbevyle William gent 789716 789716 Turbevyle, William, of Kyngesbyre, gent 0
4829511 2305269 2305269 defendant Renne Walter yeoman 789716 789716 Renne, Walter, of Kyngesbyre, yeoman 1
4832000 2306039 2306039 defendant Turbevyle William gent 789716 789716 Turbevyle, William, of Kyngesbyre, gent 0
4832001 2306039 2306039 defendant Hayward William   789716 789716 Hayward, William, of Kyngesbyre, hay ward 1
4930751 2336027 2336027 defendant Bacheler Roger husbandman 789716 789716 Bacheler, Roger, of Kyngesbyre, husbandman 0
4930752 2336027 2336027 defendant Botter John husbandman 789716 789716 Botter, John, of Kyngesbyre, husbandman 1
5013214 2360698 2360698 defendant Shaftesbury William husbandman 789716 789716 Shaftesbury, William, of Kyngesbyre, husbandman 0
5050204 2371682 2371682 defendant Haye Walter husbandman 789716 789716 Haye, Walter, of Kyngesbyre, husbandman 3
5050205 2371682 2371682 defendant Cornehok Nicholas laborer 789716 789716 Cornehok, Nicholas, of Kyngesbyre, laborer 4
5088471 2383005 2383005 defendant Turburvyle John esq 789716 789716 Turburvyle, John, of Kyngesbyre, esq 0
5088473 2383006 2383006 defendant Turburvyle John esq 789716 789716 Turburvyle, John, of Kyngesbyre, esq 0
5170741 2407164 2407164 defendant Turbervyle Richard gent 789716 789716 together with Turbervyle, Richard, of Kyngesbyre, gent 4
5170743 2407165 2407165 defendant Turbervyle Richard gent 789716 789716 Turbervyle, Richard, of Kyngesbyre, gent 0
5201256 2416122 2416122 defendant Turburvyle Richard gent 789716 789716 Turburvyle, Richard, of Kyngesbyre, gent 0
5626361 2552211 2552211 defendant Cole Andrew   789716 789716 Cole, Andrew, of Kyngesbyre, holy water clerk 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);