names

18 rows where place_id = 593568

✎ 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
3612395 1871504 1871504 defendant Jurdan Richard husbandman 593568 593568 Jurdan, Richard, of Sevenhampton, husbandman 0
3627008 1903306 1903306 defendant Warneford Thomas gent 593568 593568 Warneford, Thomas, of Sevenhampton, gent 0
3627009 1903306 1903306 defendant Lewenden William yeoman 593568 593568 Lewenden, William, of Sevenhampton, yeoman 1
3627010 1903306 1903306 defendant Barret William laborer 593568 593568 Barret, William, of Sevenhampton, laborer 2
3639246 1907085 1907085 defendant Welyer Henry husbandman 593568 593568 Welyer, Henry, of Sevenhampton, husbandman 1
3917041 1996056 1996056 defendant Bollyns John husbandman 593568 593568 Bollyns, John, of Sevenhampton, husbandman 0
4416272 2169978 2169978 defendant atte Mulne Margery   593568 593568 atte Mulne, Margery, of Sevenhampton 0
4457233 2187271 2187271 defendant Preste John   593568 593568 Preste, John, of Sevenhampton 0
4462301 2188907 2188907 defendant Dun William   593568 593568 Dun, William, of Sevenhampton 0
4502038 2201231 2201231 defendant Waryn Geoffrey   593568 593568 Waryn, Geoffrey, of Sevenhampton 0
4558393 2218571 2218571 defendant Mede John   593568 593568 Mede, John, of Sevenhampton 1
4664404 2250345 2250345 defendant Ferrour or Smith John, senior husbandman 593568 593568 Ferrour or Smith, John, senior, of Sevenhampton, husbandman 0
4664408 2250346 2250346 defendant Ferrour or Smith John, senior husbandman 593568 593568 Ferrour or Smith, John, senior, of Sevenhampton, husbandman 0
4725448 2273253 2273253 defendant Warneford Richard gent 593568 593568 Warneford, Richard, of Sevenhampton, gent 0
4744996 2279050 2279050 defendant Swayn John husbandman 593568 593568 Swayn, John, of Sevenhampton, husbandman 0
4931731 2336309 2336309 defendant Strode John husbandman 593568 593568 Strode, John, of Sevenhampton, husbandman 6
4975483 2349635 2349635 defendant Warneford Richard gent 593568 593568 together with Warneford, Richard, of Sevenhampton, gent 1
5623894 2551421 2551421 defendant Dun John husbandman 593568 593568 Dun, John, of Sevenhampton, husbandman 7

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