names

28 rows where place_id = 601429

✎ 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
3645328 1908948 1908948 defendant Wattys Richard fuller 601429 601429 Wattys, Richard, of Okyngham, fuller 0
3645329 1908948 1908948 defendant Wattys Thomas fuller 601429 601429 Wattys, Thomas, of Okyngham, fuller 1
3653145 1911316 1911316 defendant Tutman John brasier 601429 601429 Tutman, John, of Okyngham, brasier 1
3686075 1921805 1921805 defendant Carpenter Richard laborer 601429 601429 Carpenter, Richard, of Okyngham, laborer 1
3714615 1930867 1930867 defendant Marten Henry yeoman 601429 601429 Marten, Henry, of Okyngham, yeoman 1
3735878 1937460 1937460 defendant Loke John carpenter 601429 601429 Loke, John, of Okyngham, carpenter 0
3754237 1943276 1943276 defendant Whytloke Richard husbandman 601429 601429 Whytloke, Richard, of Okyngham, husbandman 2
3771477 1948771 1948771 defendant Whytelok Richard husbandman 601429 601429 Whytelok, Richard, of Okyngham, husbandman 1
3774968 1949904 1949904 defendant Martyn William clothier 601429 601429 Martyn, William, of Okyngham, clothier 0
3774970 1949905 1949905 defendant Martyn William clothier 601429 601429 Martyn, William, of Okyngham, clothier 0
3869659 1980095 1980095 defendant Mill John draper 601429 601429 Mill, John, of Okyngham, draper 0
3887671 1986127 1986127 defendant Mynours James husbandman 601429 601429 Mynours, James, of Okyngham, husbandman 0
3905502 1992110 1992110 defendant Frith William clothier 601429 601429 Frith, William, of Okyngham, clothier 0
3911409 1994131 1994131 defendant Hethe Thomas weaver 601429 601429 Hethe, Thomas, of Okyngham, weaver 0
3911410 1994131 1994131 defendant Helyar John husbandman 601429 601429 Helyar, John, of Okyngham, husbandman 1
3911411 1994131 1994131 defendant Barton alis Dent William butcher 601429 601429 Barton alis Dent, William, of Okyngham, butcher 2
3911412 1994131 1994131 defendant Neve Thomas   601429 601429 Neve, Thomas,of Okyngham, weaver' 3
4019209 2031607 2031607 defendant Powell Robert yeoman 601429 601429 Powell, Robert, of Okyngham, yeoman 1
4096237 2058981 2058981 defendant Tyckener Henry laborer 601429 601429 Tyckener, Henry, of Okyngham, laborer 0
4096239 2058981 2058981 defendant Monge Robert laborer 601429 601429 Monge, Robert, of Okyngham, laborer 2
5482704 2499771 2499771 defendant Robyns Richard tailor 601429 601429 Robyns, Richard, of Okyngham, tailor 0
5482706 2499771 2499771 defendant Blande William fuller 601429 601429 Blande, William, of Okyngham, fuller 2
5569808 2525744 2525744 defendant Hamond John chapman 601429 601429 Hamond, John, of Okyngham, chapman 2
5584686 2530281 2530281 defendant Skerlet Robert glover 601429 601429 Skerlet, Robert, of Okyngham, glover 0
5584687 2530281 2530281 defendant Bewshere Thomas draper 601429 601429 Bewshere, Thomas, of Okyngham, draper 1
5591393 2532281 2532281 defendant Tangley Robert husbandman 601429 601429 Tangley, Robert, of Okyngham, husbandman 0
5594992 2533402 2533402 defendant Hamond John gent 601429 601429 Hamond, John, of Okyngham, gent 0
5599426 2534706 2534706 defendant Wattys Richard yeoman 601429 601429 Wattys, Richard, of Okyngham, yeoman 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);