names

11 rows where place_id = 600773

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642453 1908083 1908083 defendant Chester Roger husbandman 600773 600773 Chester, Roger, of Woburne, husbandman 0
3809580 1960883 1960883 defendant Turney William warrener 600773 600773 Turney, William, of Woburne, warrener 0
3809581 1960883 1960883 defendant Hoggys Thomas laborer 600773 600773 Hoggys, Thomas, of Woburne, laborer 1
3809582 1960883 1960883 defendant Wolson Robert laborer 600773 600773 Wolson, Robert, of Woburne, laborer 2
3809718 1960928 1960928 defendant Hoggys Thomas laborer 600773 600773 Hoggys, Thomas, of Woburne, laborer 1
3809719 1960928 1960928 defendant Wolson Robert laborer 600773 600773 Wolson, Robert, of Woburne, laborer 2
3909835 1993594 1993594 defendant Potter John butcher 600773 600773 Potter, John, of Woburne, butcher 15
4042845 2039916 2039916 defendant Ellyott alias Fork Richard yeoman 600773 600773 Ellyott alias Fork, Richard, of Woburne, yeoman 0
4043061 2039985 2039985 defendant Ellyott alias Fork Richard yeoman 600773 600773 Ellyott alias Fork, Richard, of Woburne, yeoman 0
4130942 2071379 2071379 defendant Boule John yeoman 600773 600773 Boule, John, of Woburne, yeoman 0
4892392 2324359 2324359 defendant Typerton Nicholas butcher 600773 600773 Typerton, Nicholas, of Woburne, butcher 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);