names

13 rows where place_id = 607703

✎ 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
3670487 1916730 1916730 defendant Percy John gent 607703 607703 Percy, John, of Whytby, gent 1
3838283 1969890 1969890 defendant Busshell George merchant 607703 607703 Busshell, George, of Whytby, merchant 0
3969229 2013848 2013848 plaintiff Conyers Francis gent 607703 607703 Conyers, Francis, of Whytby, gent 0
3969231 2013849 2013849 plaintiff Conyers Francis gent 607703 607703 Conyers, Francis, of Whytby, gent 0
4026245 2034036 2034036 plaintiff Busshell Robert merchant 607703 607703 Busshell, Robert, of Whytby, merchant 0
4026248 2034037 2034037 plaintiff Busshell Robert merchant 607703 607703 Busshell, Robert, of Whytby, merchant 0
4812056 2299883 2299883 defendant Gowere William gent 607703 607703 Gowere, William, of Whytby, gent 0
4856248 2313325 2313325 defendant Nessefeld Henry esq 607703 607703 (Nessefeld, Henry, of Whytby, esq 1
4865907 2316307 2316307 defendant Ake Henry merchant 607703 607703 Ake, Henry, of Whytby, merchant 0
5236472 2426256 2426256 defendant Andrewe Robert mariner 607703 607703 Andrewe, Robert, of Whytby, mariner 0
5292485 2442799 2442799 defendant Swan Guy shipman 607703 607703 Swan, Guy, of Whytby, shipman 5
5444214 2488178 2488178 defendant Layns Robert   607703 607703 Layns, Robert, of Whytby 0
5536276 2515835 2515835 defendant Fare William gent 607703 607703 Fare, William, of Whytby, 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);