names

10 rows where place_id = 590719

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602079 1868311 1868311 defendant Hesketh Thomas gent 590719 590719 Hesketh, Thomas, of Rufford, gent 2
3613950 1872019 1872019 plaintiff Blytun William esq 590719 590719 Blytun, William, of Rufford, or of Knesall, esq 0
4585041 2226743 2226743 defendant Athere John   590719 590719 Athere, John, of Rufford 5
4866536 2316496 2316496 defendant Tyler John   590719 590719 Tyler, John, of Rufford, tile maker 0
5090078 2383469 2383469 defendant Rownesvale John yeoman 590719 590719 Rownesvale, John, of Rufford, yeoman 1
5228380 2423907 2423907 defendant Lede John yeoman 590719 590719 Lede, John, of Rufford, yeoman 14
5228381 2423907 2423907 defendant Clogh William yeoman 590719 590719 Clogh, William, of Rufford, yeoman 15
5436284 2485789 2485789 defendant Knapton William husbandman 590719 590719 (Knapton, William, of Rufford, husbandman 1
5450993 2490189 2490189 defendant Knapton William husbandman 590719 590719 (Knapton, William, of Rufford, husbandman 1
5450997 2490190 2490190 defendant Knapton William husbandman 590719 590719 (Knapton, William, of Rufford, husbandman 1

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