names

23 rows where place_id = 632108

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3804676 1959403 1959403 plaintiff Soly Oliver chaplain 632108 632108 Soly, Oliver, of Wyllesdon, chaplain 0
3814480 1962444 1962444 plaintiff Worme William yeoman 632108 632108 Worme, William, of Wyllesdon, yeoman 1
3814645 1962491 1962491 plaintiff Worme William yeoman 632108 632108 Worme, William, of Wyllesdon, yeoman 1
4198830 2095147 2095147 defendant Herytage John yeoman 632108 632108 Herytage, John, of Wyllesdon, yeoman 1
4738550 2277149 2277149 defendant Maweneby William   632108 632108 Maweneby, William, of Wyllesdon, vicar 0
4738551 2277149 2277149 defendant Roberd John husbandman 632108 632108 Roberd, John, of Wyllesdon, husbandman 1
4827375 2304610 2304610 defendant atte Wode John   632108 632108 atte Wode, John, of Wyllesdon 0
4861776 2315056 2315056 defendant Kyngewode John   632108 632108 Kyngewode, John, of Wyllesdon 0
4875594 2319324 2319324 defendant Steven John husbandman 632108 632108 Steven, John, of Wyllesdon, husbandman 0
4890746 2323856 2323856 defendant Robert John husbandman 632108 632108 Robert, John, of Wyllesdon, or of Nansedon, husbandman 0
4922775 2333536 2333536 plaintiff (not given) John vicar of Lychefeld 632108 632108 Lychefeld, John, of Wyllesdon, vicar of St Mary's 0
5000285 2356960 2356960 plaintiff Lychefeld John   632108 632108 Lychefeld, John, of Wyllesdon, vicar 0
5028511 2365215 2365215 defendant atte Nelme or atte Neline William husbandman 632108 632108 atte Nelme or atte Neline, William, of Wyllesdon, husbandman 0
5033365 2366638 2366638 defendant Robert John husbandman 632108 632108 Robert, John, of Wyllesdon, husbandman 0
5127136 2394412 2394412 defendant atte Wode Thomas husbandman 632108 632108 atte Wode, Thomas, of Wyllesdon, husbandman 3
5184625 2411250 2411250 defendant Emmner Henry husbandman 632108 632108 Emmner, Henry, of Wyllesdon, husbandman 3
5343874 2458271 2458271 defendant Blakeney John clerk 632108 632108 Blakeney, John, of Wyllesdon, clerk 0
5386985 2471343 2471343 defendant Page William   632108 632108 Page, William, of Wyllesdon 0
5398589 2474656 2474656 defendant Byndford John husbandman 632108 632108 Byndford, John, of Wyllesdon, husbandman 0
5399628 2474976 2474976 defendant Carley John yeoman 632108 632108 Carley, John, of Wyllesdon, yeoman 2
5399629 2474976 2474976 defendant Wakerell Thomas husbandman 632108 632108 Wakerell, Thomas, of Wyllesdon, husbandman 3
5496302 2503796 2503796 plaintiff Hyll John husbandman 632108 632108 Hyll, John, of Wyllesdon, husbandman 0
5510780 2508214 2508214 plaintiff Hill John husbandman 632108 632108 Hill, John, of Wyllesdon, husbandman 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);