names

13 rows where case_id = 2043548

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4053259 2043548 2043548 plaintiff Amyas Thomas gent, attorney of the bench   Amyas, Thomas, gent, attorney of the bench 0
4053260 2043548 2043548 defendant Chamberleyne John gent 666532 666532 Chamberleyne, John, of Parva Ellyngham, gent 0
4053261 2043548 2043548 defendant Hast Thomas gent 586365 586365 Hast, Thomas, of Wymondham, gent 1
4053262 2043548 2043548 defendant Leke William butcher 613621 613621 Leke, William, of Barneham Brome, butcher 2
4053263 2043548 2043548 defendant Shymynge John clerk 666846 666846 Shymynge, John, of Hackforth, clerk 3
4053264 2043548 2043548 defendant Aldreed Edmund laborer 588220 588220 Aldreed, Edmund, of Wesenham, laborer 4
4053265 2043548 2043548 defendant West John husbandman 586365 586365 West, John, of Wymondham, husbandman 5
4053266 2043548 2043548 defendant Cullyor Edmund husbandman 586365 586365 Cullyor, Edmund, of Wymondham, husbandman 6
4053267 2043548 2043548 defendant Scottyng John yeoman 603960 603960 Scottyng, John, of Kings Lynne, yeoman 7
4053268 2043548 2043548 defendant Marys William husbandman 589109 589109 Marys, William, of Alburgh, husbandman 8
4053269 2043548 2043548 defendant Lyngey Walter tailor 586678 586678 Lyngey, Walter, of Hardyngham, tailor 9
4053270 2043548 2043548 defendant Dynne John husbandman 586396 586396 Dynne, John, of Yaxham, husbandman 10
4053271 2043548 2043548 defendant Crane William laborer 622734 622734 Crane, William, of Dereham, laborer 11

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