names

18 rows where case_id = 2030076

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4015048 2030076 2030076 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4015049 2030076 2030076 defendant Yarham Richard yeoman 592861 592861 Yarham, Richard, of Hylderston, yeoman 0
4015050 2030076 2030076 defendant Cooke John clerk 674657 674657 Cooke, John, of Strumpshawe, clerk 1
4015051 2030076 2030076 defendant Harward Thomas gent 587387 587387 Harward, Thomas, of Boton, gent 2
4015052 2030076 2030076 defendant Tryndell Richard yeoman 591453 591453 Tryndell, Richard, of North Tuddenham, yeoman 3
4015053 2030076 2030076 defendant Peresen William yeoman 588456 588456 Peresen, William, of Yarmouth, yeoman 4
4015054 2030076 2030076 defendant Gooche Richard husbandman 623482 623482 Gooche, Richard, of Swannyngton, husbandman 5
4015055 2030076 2030076 defendant Chapman Thomas   599811 599811 Chapman, Thomas, of Great Yarmouth, boatwright 6
4015056 2030076 2030076 defendant Warde Robert husbandman 591656 591656 Warde, Robert, of Walcote, husbandman 7
4015057 2030076 2030076 defendant Shereffe Richard husbandman 674659 674659 Shereffe, Richard, of Goodale Barnyngham, husbandman 8
4015058 2030076 2030076 defendant Walter John husbandman 586386 586386 Walter, John, of Weston, husbandman 9
4015059 2030076 2030076 defendant Crede alias Taylor George thatcher 641624 641624 Crede alias Taylor, George, of Aylisham, thatcher 10
4015060 2030076 2030076 defendant Bulward Roger gent 620834 620834 Bulward, Roger, of Dallyng, gent 11
4015061 2030076 2030076 defendant Crane William husbandman 613621 613621 Crane, William, of Barneham Brome, husbandman 12
4015062 2030076 2030076 defendant Hethe John miller 674660 674660 Hethe, John, of Laryngsett, miller 13
4015063 2030076 2030076 defendant Tuddenham John husbandman 590846 590846 Tuddenham, John, of Shipdam, husbandman 14
4015064 2030076 2030076 defendant Dynne Thomas husbandman 664630 664630 Dynne, Thomas, of Carleton Fowerhoo, husbandman 15
4015065 2030076 2030076 defendant Lawes John yeoman 618231 618231 Lawes, John, of Swaffham Markett, yeoman 16

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