names

16 rows where place_id = 598086

✎ 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
3631056 1904536 1904536 defendant Hunt Thomas innholder 598086 598086 Hunt, Thomas, of Fossedyke, innholder 1
3708704 1929022 1929022 defendant Gaunte Peter yeoman 598086 598086 Gaunte, Peter, of Fossedyke, yeoman 0
3758720 1944722 1944722 plaintiff Feld Thomas, senior   598086 598086 Feld, Thomas, senior, of Fossedyke 2
3758730 1944723 1944723 plaintiff Feld Thomas, senior   598086 598086 Feld, Thomas, senior, of Fossedyke 2
3758742 1944724 1944724 plaintiff Feld Thomas, senior   598086 598086 Feld, Thomas, senior, of Fossedyke 2
4523655 2207726 2207726 defendant Welby Thomas de   598086 598086 Welby, Thomas de, of Fossedyke 0
4773404 2287656 2287656 defendant Houson Richard husbandman 598086 598086 Houson, Richard, of Fossedyke, husbandman 2
4798728 2295780 2295780 defendant Houson or Honson Richard husbandman 598086 598086 Houson or Honson, Richard, of Fossedyke, husbandman 2
4838144 2307853 2307853 defendant Reynaldeson John shoemaker 598086 598086 Reynaldeson, John, of Fossedyke, shoemaker 0
4881018 2320974 2320974 defendant Aleynson Thomas husbandman 598086 598086 Aleynson, Thomas, of Fossedyke, husbandman 0
4881019 2320974 2320974 defendant Aleynson Richard husbandman 598086 598086 Aleynson, Richard, of Fossedyke, husbandman 1
4915448 2331334 2331334 defendant Adelyn William husbandman 598086 598086 Adelyn, William, of Fossedyke, husbandman 3
4991240 2354263 2354263 defendant Leke Richard esq 598086 598086 Leke, Richard, of Fossedyke, esq 4
5093653 2384540 2384540 plaintiff Pyri John   598086 598086 Pyri, John, of Fossedyke 0
5295830 2443773 2443773 defendant Pulvertoft Robert gent 598086 598086 Pulvertoft, Robert, of Fossedyke, gent 0
5430632 2484100 2484100 defendant Welby Thomas gent 598086 598086 Welby, Thomas, of Fossedyke, gent 0

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