names

11 rows where place_id = 617262

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3718618 1932100 1932100 defendant Smyth Peter husbandman 617262 617262 Smyth, Peter, of Eversley, husbandman 0
3830177 1967333 1967333 defendant Lambley William yeoman 617262 617262 Lambley, William, of Eversley, yeoman 2
4043251 2040057 2040057 defendant Shepperd alias Bodham Thomas husbandman 617262 617262 Shepperd alias Bodham, Thomas, of Eversley, husbandman 0
4072310 2050399 2050399 defendant Rither Richard   617262 617262 Rither, Richard, of Eversley, "carsyman" 1
4072311 2050399 2050399 defendant Neve Nicholas   617262 617262 Neve, Nicholas, of Eversley, "carsyman" 2
4126349 2069714 2069714 defendant Soone Edward clothier 617262 617262 Soone, Edward, of Eversley, clothier 0
4126350 2069714 2069714 defendant Webbe Michael yeoman 617262 617262 Webbe, Michael, of Eversley, yeoman 1
4280342 2123027 2123027 defendant Soane Edward clothier 617262 617262 Soane, Edward, of Eversley, clothier 0
4280343 2123027 2123027 defendant Soane Richard clothier 617262 617262 Soane, Richard, of Eversley, clothier 1
4379438 2157725 2157725 defendant Wallen Richard sherman 617262 617262 Wallen, Richard, of Eversley, sherman 0
5317578 2450343 2450343 defendant Pykerygge John yeoman 617262 617262 Pykerygge, John, of Eversley, yeoman 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);