names

13 rows where place_id = 650979

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
3699893 1926194 1926194 defendant Hanson Robert   650979 650979 Hanson, Robert, of Halyfaxe, wool driver 0
3699895 1926195 1926195 defendant Hanson Robert   650979 650979 Hanson, Robert, of Halyfaxe, wool driver 0
3915041 1995386 1995386 defendant Lyster William yeoman 650979 650979 Lyster, William, of Halyfaxe, yeoman 0
3928332 1999811 1999811 defendant Mawde William yeoman 650979 650979 Mawde, William, of Halyfaxe, yeoman 0
3930058 2000397 2000397 plaintiff Clyffe Thomas clothier 650979 650979 Clyffe, Thomas, of Halyfaxe, clothier 0
3939240 2003428 2003428 plaintiff Roper John   650979 650979 Roper, John, of Halyfaxe 0
3957245 2009599 2009599 defendant Carter William clothier 650979 650979 Carter, William, of Halyfaxe, clothier 0
3973732 2015387 2015387 plaintiff Haldisworthe Peter   650979 650979 Haldisworthe, Peter, of Halyfaxe 0
3973734 2015388 2015388 plaintiff Haldysworthe Peter   650979 650979 Haldysworthe, Peter, of Halyfaxe 0
3975879 2016127 2016127 defendant Hochenson John yeoman 650979 650979 Hochenson, John, of Halyfaxe, yeoman 0
4670086 2256347 2256347 plaintiff Brodele Henry (legal representative) 650979 650979 Brodele, Henry, of Halyfaxe, draper, executors of 0
4950464 2342112 2342112 defendant Ottes John glover 650979 650979 Ottes, John, of Halyfaxe, glover 0
5237308 2426496 2426496 plaintiff Furnays Thomas   650979 650979 Furnays, Thomas, of Halyfaxe 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);