names

21 rows where place_id = 627321

✎ 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
3768838 1947900 1947900 defendant Trencher John   627321 627321 Trencher, John, of Chacombe, "rowman" 0
3775600 1950114 1950114 defendant Gaywod Thomas husbandman 627321 627321 Gaywod, Thomas, of Chacombe, husbandman 0
3998375 2024158 2024158 defendant Wapowle John husbandman 627321 627321 Wapowle, John, of Chacombe, husbandman 1
4560308 2219163 2219163 plaintiff Mach_ John   627321 627321 Mach_, John, of Chacombe, formerly chaplain in the same chantry 1
4681473 2259820 2259820 defendant Befferey Thomas husbandman 627321 627321 Befferey, Thomas, of Chacombe, husbandman 1
4681474 2259820 2259820 defendant Stevenes William husbandman 627321 627321 Stevenes, William, of Chacombe, husbandman 2
4791235 2293356 2293356 defendant Smyth Thomas butcher 627321 627321 Smyth, Thomas, of Chacombe, butcher 6
4910477 2329790 2329790 defendant Molle Thomas husbandman 627321 627321 Molle, Thomas, of Chacombe, husbandman 1
4910479 2329790 2329790 defendant Palgfreyman Thomas   627321 627321 Palgfreyman, Thomas, of Chacombe, servant 3
5389819 2472151 2472151 defendant Hide John husbandman 627321 627321 Hide, John, of Chacombe, husbandman 1
5389853 2472160 2472160 defendant (not given) Robert prior of Alcetur 627321 627321 Alcetur, Robert, of Chacombe, prior of St Peter, Nhants 0
5402625 2475825 2475825 defendant Hide John husbandman 627321 627321 Hide, John, of Chacombe, husbandman 1
5415546 2479591 2479591 defendant Hide John husbandman 627321 627321 Hide, John, of Chacombe, husbandman 0
5431899 2484509 2484509 defendant Hyde William yeoman 627321 627321 Hyde, William, of Chacombe, yeoman 1
5448133 2489331 2489331 defendant Hyde William   627321 627321 Hyde, William, of Chacombe 1
5448139 2489333 2489333 defendant Hyde William yeoman 627321 627321 Hyde, William, of Chacombe, yeoman 1
5448143 2489334 2489334 defendant Hyde William yeoman 627321 627321 Hyde, William, of Chacombe, yeoman 1
5559747 2522810 2522810 defendant Garner Richard husbandman 627321 627321 Garner, Richard, of Chacombe, husbandman 0
5559748 2522810 2522810 defendant Tayllour Robert husbandman 627321 627321 Tayllour, Robert, of Chacombe, husbandman 1
5559749 2522810 2522810 defendant Broun Richard husbandman 627321 627321 Broun, Richard, of Chacombe, husbandman 2
5559750 2522810 2522810 defendant Copland John husbandman 627321 627321 Copland, John, of Chacombe, husbandman 3

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