names

28 rows where place_id = 609590

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671309 1917000 1917000 defendant Pylkyngton Thomas   609590 609590 Pylkyngton, Thomas, of Hyklyng. husbandman 1
3679211 1919567 1919567 defendant Walyssh Thomas mercer 609590 609590 Walyssh, Thomas, of Hyklyng, mercer 0
3702441 1927024 1927024 defendant Rede Robert husbandman 609590 609590 Rede, Robert, of Hyklyng, husbandman 0
3708674 1929012 1929012 defendant Chyrche Robert yeoman 609590 609590 Chyrche, Robert, of Hyklyng, yeoman 2
3710515 1929611 1929611 defendant Lans or Laus Thomas butcher 609590 609590 Lans or Laus, Thomas, of Hyklyng, butcher 1
3716127 1931333 1931333 defendant Rede Robert husbandman 609590 609590 Rede, Robert, of Hyklyng, husbandman 0
3756687 1944067 1944067 defendant Hande Thomas clerk 609590 609590 Hande, Thomas, of Hyklyng, clerk 0
3779727 1951392 1951392 defendant Spede Henry husbandman 609590 609590 Spede, Henry, of Hyklyng, husbandman 0
3810134 1961058 1961058 defendant Harman John husbandman 609590 609590 Harman, John, of Hyklyng, husbandman 0
3813920 1962262 1962262 defendant Walysshe Thomas mercer 609590 609590 Walysshe, Thomas, of Hyklyng, mercer 1
3821397 1964587 1964587 defendant Harman John husbandman 609590 609590 Harman, John, of Hyklyng, husbandman 0
3825841 1965931 1965931 plaintiff Aleyn Robert   609590 609590 Aleyn, Robert, of Hyklyng 0
3861168 1977211 1977211 defendant Halle Richard husbandman 609590 609590 Halle, Richard, of Hyklyng, husbandman 4
3863414 1977957 1977957 defendant Tayler Richard husbandman 609590 609590 Tayler, Richard, of Hyklyng, husbandman 0
3870217 1980286 1980286 defendant Harman John husbandman 609590 609590 Harman, John, of Hyklyng, husbandman 1
3883992 1984915 1984915 defendant Mores John   609590 609590 Mores, John, of Hyklyng, woollen weaver 1
3898621 1989747 1989747 defendant Bugg alias Yorke Thomas husbandman 609590 609590 Bugg alias Yorke, Thomas, of Hyklyng, husbandman 1
3898626 1989748 1989748 defendant Bugg alias Yorke Thomas husbandman 609590 609590 Bugg alias Yorke, Thomas, of Hyklyng, husbandman 1
3939746 2003597 2003597 defendant Woodhowse Thomas   609590 609590 Woodhowse, Thomas, of Hyklyng, knight 2
3939911 2003647 2003647 defendant Woodhouse thomas   609590 609590 Woodhouse, thomas, of Hyklyng, knight 2
4547834 2215260 2215260 defendant Roys John mercer 609590 609590 Roys, John, of Hyklyng, mercer 3
4892767 2324462 2324462 defendant Harry John, senior husbandman 609590 609590 Harry, John, senior, of Hyklyng, husbandman 4
4997573 2356127 2356127 plaintiff Hokham Roger   609590 609590 Hokham, Roger, of Hyklyng, prior 0
5362026 2463788 2463788 defendant atte Chyrche Thomas   609590 609590 atte Chyrche, Thomas, of Hyklyng, shipwright 0
5443447 2487954 2487954 defendant Pallyng Thomas   609590 609590 Pallyng, Thomas, of Hyklyng 0
5478483 2498593 2498593 defendant Hendy James husbandman 609590 609590 Hendy, James, of Hyklyng, husbandman 0
5478485 2498594 2498594 defendant Hendy James yeoman 609590 609590 Hendy, James, of Hyklyng, yeoman 0
5513455 2509054 2509054 defendant Massyngham Thomas laborer 609590 609590 Massyngham, Thomas, of Hyklyng, laborer 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);