names

15 rows where place_id = 761129

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4476252 2193232 2193232 defendant Gilson Thomas smith 761129 761129 Gilson, Thomas, of Cleveland, smith 0
4524148 2207886 2207886 defendant Eseby John de   761129 761129 Eseby, John de, of Cleveland 3
4552882 2216845 2216845 defendant Daventre William   761129 761129 Daventre, William, of Cleveland 0
4560293 2219162 2219162 defendant del Clay Robert   761129 761129 del Clay, Robert, of Cleveland 19
4560295 2219162 2219162 defendant Parcour Thomas   761129 761129 Parcour, Thomas, of Cleveland 21
4560297 2219162 2219162 defendant Scathelok Roger   761129 761129 Scathelok, Roger, of Cleveland 23
4561404 2219515 2219515 defendant Gower Thomas   761129 761129 Gower, Thomas, of Cleveland 2
4561406 2219515 2219515 defendant Storme John   761129 761129 Storme, John, of Cleveland 4
4561408 2219515 2219515 defendant del Clyff William   761129 761129 del Clyff, William, of Cleveland 6
4561414 2219515 2219515 defendant Dynys John   761129 761129 Dynys, John, of Cleveland 12
4561435 2219515 2219515 defendant del Clay Robert   761129 761129 del Clay, Robert, of Cleveland 33
4561437 2219515 2219515 defendant Parcour Thomas   761129 761129 Parcour, Thomas, of Cleveland 35
4561439 2219515 2219515 defendant Scathelok Roger   761129 761129 Scathelok, Roger, of Cleveland 37
5127419 2394500 2394500 defendant Bertr-- John shoemaker 761129 761129 Bertr--, John, of Cleveland, shoemaker 8
5127432 2394500 2394500 defendant Perto John husbandman 761129 761129 Perto, John, of Cleveland, husbandman 21

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