names

16 rows where place_id = 753517

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4413972 2169274 2169274 plaintiff Chaumberleyn William le   753517 753517 Chaumberleyn, William le, of Kenilworth 0
4421407 2171599 2171599 defendant Leycestre John de mercer 753517 753517 Leycestre, John de, of Kenilworth, mercer 0
4525942 2208413 2208413 defendant Webbe Robert   753517 753517 Webbe, Robert, of Kenilworth 1
4642727 2243989 2243989 defendant Newenham William   753517 753517 Newenham, William, of Kenilworth 0
4711615 2268961 2268961 defendant Smyth William smith 753517 753517 Smyth, William, of Kenilworth, smith 0
4728890 2274275 2274275 plaintiff Kydurmynster Thomas   753517 753517 Kydurmynster, Thomas, of Kenilworth, prior 0
4728893 2274275 2274275 defendant Smyth Alice widow 753517 753517 Smyth, Alice, of Kenilworth, widow 2
4728894 2274275 2274275 defendant Smyth Nicholas yeoman 753517 753517 Smyth, Nicholas, of Kenilworth, yeoman 3
4746043 2279344 2279344 defendant Broun Richard carpenter 753517 753517 Broun, Richard, of Kenilworth, carpenter 0
4765939 2285342 2285342 plaintiff Kydermynster Thomas   753517 753517 Kydermynster, Thomas, of Kenilworth, prior 0
4814847 2300753 2300753 defendant Bleubery John smethier or smith 753517 753517 Bleubery, John, of Kenilworth, smethier or smith 0
4814848 2300753 2300753 defendant Conyng Thomas husbandman 753517 753517 Conyng, Thomas, of Kenilworth, husbandman 1
4814849 2300753 2300753 defendant Happesfeld Thomas smethier 753517 753517 Happesfeld, Thomas, of Kenilworth, smethier 2
4841758 2308957 2308957 defendant Blebery John husbandman 753517 753517 Blebery, John, of Kenilworth, husbandman 1
4849134 2311204 2311204 plaintiff Spenser Henry   753517 753517 Spenser, Henry, of Kenilworth 0
4849135 2311204 2311204 plaintiff Abell Robert   753517 753517 Abell, Robert, of Kenilworth 1

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