names

14 rows where place_id = 757461

✎ 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
4423928 2172335 2172335 defendant London Thomas de   757461 757461 London, Thomas de, of Pertenhale, parson 0
4446161 2183709 2183709 defendant Parmentere de le Ho William   757461 757461 Parmentere de le Ho, William, of Pertenhale 1
4458821 2187807 2187807 plaintiff Reymeston Thomas   757461 757461 Reymeston, Thomas, of Pertenhale 0
4458826 2187808 2187808 plaintiff Reymeston Thomas   757461 757461 Reymeston, Thomas, of Pertenhale 0
4458827 2187808 2187808 plaintiff Webster Richard   757461 757461 Webster, Richard, of Pertenhale 1
4757894 2282845 2282845 plaintiff Broun Thomas husbandman 757461 757461 Broun, Thomas, of Pertenhale, husbandman 0
4822853 2303233 2303233 plaintiff Spede Walter shoemaker 757461 757461 Spede, Walter, of Pertenhale, shoemaker, on his own account 0
4822855 2303233 2303233 defendant Somnour John, junior husbandman 757461 757461 Somnour, John, junior, of Pertenhale, husbandman 1
4863173 2315460 2315460 defendant Browen Thomas husbandman 757461 757461 Browen, Thomas, of Pertenhale, husbandman 0
4864901 2315997 2315997 defendant Stratton William husbandman 757461 757461 Stratton, William, of Pertenhale, husbandman 0
5177158 2409013 2409013 defendant Upchirche John husbandman 757461 757461 Upchirche, John, of Pertenhale, husbandman 1
5199931 2415732 2415732 defendant Upchirche John husbandman 757461 757461 Upchirche, John, of Pertenhale, husbandman 1
5199934 2415733 2415733 defendant Upchirche John husbandman 757461 757461 Upchirche, John, of Pertenhale, husbandman 1
5199937 2415734 2415734 defendant Upchirche John husbandman 757461 757461 Upchirche, John, of Pertenhale, 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);