names

10 rows where place_id = 624327

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3757508 1944321 1944321 defendant Bateman Richard husbandman 624327 624327 Bateman, Richard, of Wrawby, husbandman 3
3932343 2001120 2001120 defendant Wyche George gent 624327 624327 Wyche, George, of Wrawby, gent 0
4072346 2050411 2050411 defendant Gyllot John butcher 624327 624327 Gyllot, John, of Wrawby, butcher 0
4078673 2052668 2052668 defendant Lambert Christopher husbandman 624327 624327 Lambert, Christopher, of Wrawby, husbandman 0
4118549 2066928 2066928 defendant Gylyet Jenetta widow 624327 624327 Gylyet, Jenetta, of Wrawby, widow 1
4282647 2123835 2123835 defendant Whittacre William yeoman 624327 624327 Whittacre, William, of Wrawby, yeoman 0
4282648 2123835 2123835 defendant Robynson John yeoman 624327 624327 Robynson, John, of Wrawby, yeoman 1
4303429 2131327 2131327 defendant Whippam Thomas husbandman 624327 624327 Whippam, Thomas, of Wrawby, husbandman 0
4374637 2155991 2155991 defendant Millner Hugh laborer 624327 624327 Millner, Hugh, of Wrawby, laborer 0
4377884 2157159 2157159 defendant Robinson John yeoman 624327 624327 Robinson, John, of Wrawby, 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);