names

11 rows where place_id = 587078

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590393 1864637 1864637 defendant Jowlle Edward yeoman 587078 587078 Jowlle, Edward, of Weddesbury, Staffs, yeoman 0
3590395 1864638 1864638 defendant Jowlle Edward yeoman 587078 587078 Jowlle, Edward, of Weddesbury, Staffs, yeoman 0
3590397 1864639 1864639 defendant Jowlle Edward yeoman 587078 587078 Jowlle, Edward, of Weddesbury, Staffs, yeoman 0
3806197 1959862 1959862 defendant Wirisdale John laborer 587078 587078 Wirisdale, John, of Weddesbury, Staffs, laborer 11
3806216 1959863 1959863 defendant Wirisdale John laborer 587078 587078 Wirisdale, John, of Weddesbury, Staffs, laborer 11
4071894 2050248 2050248 defendant Cokayn William esq 587078 587078 Cokayn, William, of Weddesbury, Staffs, esq 0
4665691 2250740 2250740 defendant Hunt Richard clerk 587078 587078 Hunt, Richard, of Weddesbury, Staffs, clerk 1
4722507 2272356 2272356 defendant Brereley Thomas husbandman 587078 587078 Brereley, Thomas, of Weddesbury, Staffs, husbandman 2
5272931 2437156 2437156 defendant Burton Henry butcher 587078 587078 Burton, Henry, of Weddesbury, Staffs, butcher 2
5301696 2445464 2445464 defendant Nyghtyngale Richard smith 587078 587078 Nyghtyngale, Richard, of Weddesbury, Staffs, smith 0
5340895 2457348 2457348 defendant Hopkys Richard yeoman 587078 587078 Hopkys, Richard, of Weddesbury, Staffs, yeoman 4

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);