names

14 rows where place_id = 672798

✎ 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
4007076 2027308 2027308 defendant Wryghte Edward gent 672798 672798 (Wryghte, Edward, of Wolverley, Worcs, gent 1
4098363 2059740 2059740 defendant Jewxe John yeoman 672798 672798 Jewxe, John, of Wolverley, Worcs, yeoman 0
4165718 2083507 2083507 defendant Jones Hugh yeoman 672798 672798 Jones, Hugh, of Wolverley, Worcs, yeoman 1
4241424 2110116 2110116 defendant Carington Anthony clerk 672798 672798 Carington, Anthony, of Wolverley, Worcs, clerk 3
4241429 2110117 2110117 defendant Carington Anthony clerk 672798 672798 Carington, Anthony, of Wolverley, Worcs, clerk 3
4310546 2133840 2133840 defendant Attwood alias Clarke Elizabeth widow 672798 672798 Attwood alias Clarke, Elizabeth, of Wolverley, Worcs, widow 0
5121490 2392718 2392718 defendant Sebryght William husbandman 672798 672798 Sebryght, William, of Wolverley, Worcs, husbandman 11
5128621 2394853 2394853 defendant Watkys Nicholas husbandman 672798 672798 Watkys, Nicholas, of Wolverley, Worcs, husbandman 0
5147808 2400502 2400502 defendant Watkys Nicholas husbandman 672798 672798 Watkys, Nicholas, of Wolverley, Worcs, husbandman 0
5157253 2403262 2403262 defendant Hondy John husbandman 672798 672798 Hondy, John, of Wolverley, Worcs, husbandman 1
5193152 2413727 2413727 defendant Hondy John husbandman 672798 672798 Hondy, John, of Wolverley, Worcs, husbandman 1
5532675 2514766 2514766 defendant Bokyngham William yeoman 672798 672798 Bokyngham, William, of Wolverley, Worcs, yeoman 0
5598395 2534381 2534381 defendant Bokyngham William yeoman 672798 672798 Bokyngham, William, of Wolverley, Worcs, yeoman 0
5602746 2535738 2535738 defendant Bukyngham William yeoman 672798 672798 Bukyngham, William, of Wolverley, Worcs, yeoman 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);