names

18 rows where place_id = 588342

✎ 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
3594165 1865817 1865817 defendant Stockall Christopher yeoman 588342 588342 Stockall, Christopher, of Wodstoke, yeoman 0
3660617 1913582 1913582 defendant Nowers Thomas gent 588342 588342 Nowers, Thomas, of Wodstoke, gent 0
3703940 1927514 1927514 defendant Nowers Thomas gent 588342 588342 Nowers, Thomas, of Wodstoke, or of Glympton, gent 0
3777317 1950648 1950648 defendant Lyne Richard husbandman 588342 588342 Lyne, Richard, of Wodstoke, husbandman 3
3974387 2015614 2015614 defendant Westall Jerome innholder 588342 588342 Westall, Jerome, of Wodstoke, innholder 0
3980612 2017830 2017830 plaintiff Phyllypps John glover 588342 588342 Phyllypps, John, of Wodstoke, glover 0
4602545 2232015 2232015 defendant Boker Richard   588342 588342 Boker, Richard, of Wodstoke 0
4632814 2241141 2241141 defendant Mathewe John   588342 588342 Mathewe, John, of Wodstoke 0
4826916 2304456 2304456 defendant Mundy Nicholas husbandman 588342 588342 Mundy, Nicholas, of Wodstoke, husbandman 0
4927418 2335007 2335007 defendant Maykyn Thomas gent 588342 588342 Maykyn, Thomas, of Wodstoke, gent 0
4928661 2335392 2335392 plaintiff Somerton Simon (legal representative) 588342 588342 Somerton, Simon, of Wodstoke, executors of 0
4934981 2337346 2337346 defendant Goulde John gent 588342 588342 Goulde, John, of Wodstoke, gent 0
5074888 2378995 2378995 defendant Pope William cordwainer 588342 588342 Pope, William, of Wodstoke, cordwainer 3
5353995 2461311 2461311 defendant Wyseman John chapman 588342 588342 Wyseman, John, of Wodstoke, chapman 0
5440024 2486916 2486916 defendant Heynes John yeoman 588342 588342 Heynes, John, of Wodstoke, yeoman 0
5440026 2486917 2486917 defendant Heynes John yeoman 588342 588342 Heynes, John, of Wodstoke, yeoman 0
5453539 2490951 2490951 defendant Heynes John yeoman 588342 588342 Heynes, John, of Wodstoke, yeoman 0
5532685 2514771 2514771 defendant Proudelove Thomas draper 588342 588342 Proudelove, Thomas, of Wodstoke, draper 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);