names

23 rows where place_id = 658873

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3950156 2007137 2007137 plaintiff Foxe Stephen Yeoman of the Guard 658873 658873 Foxe, Stephen, of Hitchyn, Herts, Yeoman of the Guard 0
3993485 2022413 2022413 plaintiff Chambers James tanner 658873 658873 Chambers, James, of Hitchyn, Herts, tanner 0
3999625 2024630 2024630 defendant Frenche Thomas chapman or mercer 658873 658873 Frenche, Thomas, of Hitchyn, Herts, chapman or mercer 2
4003948 2026182 2026182 plaintiff Hurste Edward yeoman 658873 658873 Hurste, Edward, of Hitchyn, Herts, yeoman 0
4037926 2038214 2038214 plaintiff Kympton John yeoman 658873 658873 Kympton, John, of Hitchyn, Herts, yeoman 0
4037929 2038215 2038215 plaintiff Kympton John yeoman 658873 658873 Kympton, John, of Hitchyn, Herts, yeoman 0
4044073 2040332 2040332 defendant Kempton John mercer 658873 658873 Kempton, John, of Hitchyn, Herts, mercer 2
4049869 2042384 2042384 plaintiff Wake Thomas tailor 658873 658873 Wake, Thomas, of Hitchyn, Herts, tailor 0
4080510 2053343 2053343 plaintiff Warren Simon maltman 658873 658873 Warren, Simon, of Hitchyn, Herts, maltman 0
4086270 2055363 2055363 defendant Kympton John chapman 658873 658873 Kympton, John, of Hitchyn, Herts, chapman 0
4149516 2077957 2077957 defendant Leyll Roger, senior maltster 658873 658873 Leyll, Roger, senior, of Hitchyn, Herts, maltster 0
4189520 2091834 2091834 defendant Hutchinson John yeoman 658873 658873 Hutchinson, John, of Hitchyn, Herts, blacksmith, yeoman 0
4203698 2096851 2096851 defendant Copcote Thomas chapman 658873 658873 Copcote, Thomas, of Hitchyn, Herts, chapman 2
4223596 2103740 2103740 defendant Moncke William draper 658873 658873 Moncke, William, of Hitchyn, Herts, draper 0
4230426 2106135 2106135 defendant Moncke William, senior draper 658873 658873 Moncke, William, senior, of Hitchyn, Herts, draper 0
4230432 2106136 2106136 defendant Moncke William draper 658873 658873 Moncke, William, of Hitchyn, Herts, draper 2
4261246 2116726 2116726 defendant Moncke William draper 658873 658873 Moncke, William, of Hitchyn, Herts, draper 2
4261248 2116727 2116727 defendant Moncke William, senior draper 658873 658873 Moncke, William, senior, of Hitchyn, Herts, draper 0
4313145 2134713 2134713 defendant Franche Richard chapman 658873 658873 Franche, Richard, of Hitchyn, Herts, chapman 0
4381758 2158578 2158578 defendant Munck William, senior chapman 658873 658873 Munck, William, senior, of Hitchyn, Herts, chapman 0
4921336 2333185 2333185 defendant Bunker John smith 658873 658873 Bunker, John, of Hitchyn, Herts, smith 2
4921342 2333186 2333186 defendant Bunker John smith 658873 658873 Bunker, John, of Hitchyn, Herts, smith 2
5056963 2373660 2373660 defendant Mattok Nicholas merchant 658873 658873 Mattok, Nicholas, of Hitchyn, Herts, merchant 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);