names

16 rows where place_id = 658748

✎ 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
3949642 2006950 2006950 defendant Symonde Henry clerk 658748 658748 Symonde, Henry, of Earsham, Norf, clerk 0
4025079 2033629 2033629 defendant Stannowe Nicholas yeoman 658748 658748 Stannowe, Nicholas, of Earsham, Norf, or of Laxfyld, Suff, yeoman 0
4025084 2033630 2033630 defendant Stannowe Nicholas yeoman 658748 658748 Stannowe, Nicholas, of Earsham, Norf, or of Laxfyld, Suff, yeoman 0
4195788 2094078 2094078 defendant Sparke William tanner 658748 658748 Sparke, William, of Earsham, Norf, tanner 0
4246488 2111803 2111803 defendant Sparke William yeoman 658748 658748 Sparke, William, of Earsham, Norf, yeoman 0
4248675 2112543 2112543 defendant Codd Thomas gent 658748 658748 (Codd, Thomas, of Earsham, Norf, gent 1
4259260 2116073 2116073 defendant Warde John tanner 658748 658748 Warde, John, of Earsham, Norf, tanner 2
4274507 2121030 2121030 defendant Warde John tanner 658748 658748 Warde, John, of Earsham, Norf, tanner 0
4279205 2122660 2122660 defendant Shinglewood Thomas yeoman 658748 658748 Shinglewood, Thomas, of Earsham, Norf, yeoman 0
4325952 2139054 2139054 defendant Leighton Henry miller 658748 658748 Leighton, Henry, of Earsham, Norf, miller 1
4327287 2139452 2139452 defendant Storrey Richard baker 658748 658748 Storrey, Richard, of Earsham, Norf, baker 1
4349592 2147117 2147117 defendant Harcock William yeoman 658748 658748 Harcock, William, of Earsham, Norf, yeoman 3
4356441 2149481 2149481 defendant Taylor Henry yeoman 658748 658748 Taylor, Henry, of Earsham, Norf, yeoman 3
4385567 2159857 2159857 defendant Goodinge Henry pedder 658748 658748 Goodinge, Henry, of Earsham, Norf, pedder 1
4404354 2166026 2166026 defendant Shiglewoode Thomas husbandman 658748 658748 Shiglewoode, Thomas, of Earsham, Norf, husbandman 2
4408308 2167350 2167350 defendant Shinglewoode Thomas husbandman 658748 658748 Shinglewoode, Thomas, of Earsham, Norf, 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);