names

21 rows where place_id = 605835

✎ 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
3651420 1910808 1910808 defendant Agard Richard   605835 605835 Agard, Richard, of Foston, Derbs, gent, administrators of 4
3663067 1914359 1914359 defendant Graseley John gent 605835 605835 (Graseley, John, of Foston, Derbs, gent 1
3765344 1946822 1946822 defendant Gresley James gent 605835 605835 (Gresley, James, of Foston, Derbs, gent 1
3799686 1957821 1957821 defendant Grasley James esq 605835 605835 Grasley, James, of Foston, Derbs, esq 3
3830423 1967399 1967399 defendant Greysley James gent 605835 605835 Greysley, James, of Foston, Derbs, gent 0
3943146 2004723 2004723 defendant Forde John yeoman 605835 605835 Forde, John, of Foston, Derbs, yeoman 0
4079066 2052813 2052813 defendant Agar William gent 605835 605835 Agar, William, of Foston, Derbs, gent 0
4198600 2095067 2095067 defendant Agar William esq 605835 605835 Agar, William, of Foston, Derbs, esq 1
4812258 2299950 2299950 defendant Tomlynson Henry chapman 605835 605835 Tomlynson, Henry, of Foston, Derbs, chapman 0
4848057 2310858 2310858 defendant Colshill Nicholas yeoman 605835 605835 Colshill, Nicholas, of Foston, Derbs, yeoman 0
4948223 2341418 2341418 defendant Agar Thomas yeoman 605835 605835 Agar, Thomas, of Foston, Derbs, yeoman 0
4948225 2341419 2341419 defendant Agar Thomas yeoman 605835 605835 Agar, Thomas, of Foston, Derbs, yeoman 0
4948227 2341420 2341420 defendant Agar Thomas yeoman 605835 605835 Agar, Thomas, of Foston, Derbs, yeoman 0
5247869 2429515 2429515 defendant Hilton John yeoman 605835 605835 Hilton, John, of Foston, Derbs, yeoman 4
5329076 2453777 2453777 plaintiff Agarde John gent 605835 605835 Agarde, John, of Foston, Derbs, gent 0
5329080 2453778 2453778 plaintiff Agarde John gent 605835 605835 Agarde, John, of Foston, Derbs, gent 0
5477485 2498281 2498281 plaintiff Agarde John gent 605835 605835 Agarde, John, of Foston, Derbs, gent 0
5485317 2500526 2500526 defendant Agarde Ralph gent 605835 605835 Agarde, Ralph, of Foston, Derbs, gent 1
5547993 2519445 2519445 plaintiff Agard John esq 605835 605835 Agard, John, of Foston, Derbs, esq 0
5576759 2527776 2527776 defendant Agard John esq 605835 605835 Agard, John, of Foston, Derbs, esq 1
5576764 2527777 2527777 defendant Agard John esq 605835 605835 Agard, John, of Foston, Derbs, esq 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);