names

20 rows where place_id = 775877

✎ 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
4394801 2162848 2162848 defendant Potter Richard   775877 775877 Potter, Richard, of Kidderminster, Worcs, wire drawer 3
4627848 2239637 2239637 plaintiff Russeby Richard   775877 775877 Russeby, Richard, of Kidderminster, Worcs 0
4627850 2239638 2239638 plaintiff Russeby Richard   775877 775877 Russeby, Richard, of Kidderminster, Worcs 0
4719601 2271471 2271471 defendant Filylode Elizabeth   775877 775877 Filylode, Elizabeth, of Kidderminster, Worcs, widow, formerly wife of Giles 0
4817960 2301699 2301699 defendant Sutton alias Baker John merchant 775877 775877 Sutton alias Baker, John, of Kidderminster, Worcs, merchant 0
4828164 2304851 2304851 defendant Goldsmyth John chapman 775877 775877 Goldsmyth, John, of Kidderminster, Worcs, chapman 1
4830227 2305491 2305491 defendant Hayle Henry chapman 775877 775877 Hayle, Henry, of Kidderminster, Worcs, chapman 2
4832050 2306055 2306055 defendant Hayle Henry carrier 775877 775877 Hayle, Henry, of Kidderminster, Worcs, carrier 1
4835995 2307239 2307239 defendant Stodeley John goldsmith 775877 775877 Stodeley, John, of Kidderminster, Worcs, goldsmith 0
4915633 2331391 2331391 defendant Eggok John yeoman 775877 775877 Eggok, John, of Kidderminster, Worcs, yeoman 1
4920914 2333055 2333055 defendant Sutton alias Baker John merchant 775877 775877 Sutton alias Baker, John, of Kidderminster, Worcs, merchant 1
4985762 2352658 2352658 defendant Gylmyn John vintner 775877 775877 Gylmyn, John, of Kidderminster, Worcs, vintner 4
4985768 2352659 2352659 defendant Gylmyn John vintner 775877 775877 Gylmyn, John, of Kidderminster, Worcs, vintner 4
5155029 2402626 2402626 defendant Stafford Fulk esq 775877 775877 Stafford, Fulk, of Kidderminster, Worcs, esq 1
5171823 2407478 2407478 defendant Stafford Fulk esq 775877 775877 Stafford, Fulk, of Kidderminster, Worcs, esq 1
5190592 2412993 2412993 defendant Stafford Fulk esq 775877 775877 Stafford, Fulk, of Kidderminster, Worcs, esq 0
5190594 2412994 2412994 defendant Stafford Fulk esq 775877 775877 Stafford, Fulk, of Kidderminster, Worcs, esq 0
5422402 2481648 2481648 defendant Oliver John   775877 775877 Oliver, John, of Kidderminster, Worcs, vestment maker 1
5437427 2486140 2486140 defendant Heggys Robert chapman 775877 775877 Heggys, Robert, of Kidderminster, Worcs, chapman 0
5451827 2490424 2490424 defendant Heggys Robert chapman 775877 775877 Heggys, Robert, of Kidderminster, Worcs, chapman 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);