names

17 rows where place_id = 826217

✎ 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
4949308 2341770 2341770 defendant Titell Richard husbandman 826217 826217 Titell, Richard, of Wytton juxta Bromholm, husbandman 0
4949309 2341770 2341770 defendant Newehous William husbandman 826217 826217 Newehous, William, of Wytton juxta Bromholm, husbandman 1
4968526 2347553 2347553 defendant Frenssh John   826217 826217 Frenssh, John, of Wytton juxta Bromholm, servant 1
5024712 2364149 2364149 defendant Hardyng Geoffrey butcher 826217 826217 Hardyng, Geoffrey, of Wytton juxta Bromholm, butcher 0
5032674 2366440 2366440 defendant Hardyn Geoffrey butcher 826217 826217 Hardyn, Geoffrey, of Wytton juxta Bromholm, butcher 3
5243978 2428428 2428428 defendant Palmere William yeoman 826217 826217 Palmere, William, of Wytton juxta Bromholm, yeoman 0
5243979 2428428 2428428 defendant Hardyng Geoffrey husbandman 826217 826217 Hardyng, Geoffrey, of Wytton juxta Bromholm, husbandman 1
5280492 2439370 2439370 defendant Palmer William husbandman 826217 826217 Palmer, William, of Wytton juxta Bromholm, husbandman 1
5288338 2441610 2441610 defendant Palmer William merchant 826217 826217 Palmer, William, of Wytton juxta Bromholm, merchant 1
5290291 2442165 2442165 defendant Palmer William gent 826217 826217 Palmer, William, of Wytton juxta Bromholm, gent 1
5312990 2448915 2448915 defendant Palmer William (legal representative) 826217 826217 Palmer, William, of Wytton juxta Bromholm, merchant, executor of 4
5312991 2448915 2448915 defendant Croft William butcher 826217 826217 Croft, William, of Wytton juxta Bromholm, butcher 5
5347593 2459402 2459402 defendant Crofte William butcher 826217 826217 Crofte, William, of Wytton juxta Bromholm, butcher 2
5347594 2459402 2459402 defendant Thurkeld Richard yeoman 826217 826217 Thurkeld, Richard, of Wytton juxta Bromholm, yeoman 3
5487982 2501294 2501294 defendant Rosse Henry husbandman 826217 826217 Rosse, Henry, of Wytton juxta Bromholm, husbandman 0
5487983 2501294 2501294 defendant Mylys Richard husbandman 826217 826217 Mylys, Richard, of Wytton juxta Bromholm, husbandman 1
5506272 2506879 2506879 defendant Rosse Henry husbandman 826217 826217 Rosse, Henry, of Wytton juxta Bromholm, husbandman 9

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