names

23 rows where place_id = 653412

✎ 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
3928480 1999864 1999864 defendant Donston John merchant 653412 653412 Donston, John, of King's Lynn, Norf, merchant 0
3928693 1999934 1999934 defendant Mackandar Thomas merchant 653412 653412 Mackandar, Thomas, of King's Lynn, Norf, merchant 1
3931164 2000720 2000720 defendant Mowthe Robert merchant 653412 653412 Mowthe, Robert, of King's Lynn, Norf, merchant 0
3931201 2000725 2000725 defendant Ryveley George merchant 653412 653412 Ryveley, George, of King's Lynn, Norf, merchant 1
3931591 2000862 2000862 defendant Walden George merchant 653412 653412 Walden, George, of King's Lynn, Norf, merchant 0
3932483 2001154 2001154 defendant Dawuny alias Dawney John mercer 653412 653412 Dawuny alias Dawney, John, of King's Lynn, Norf, mercer 0
3933721 2001572 2001572 defendant Mountfortt Clement merchant 653412 653412 Mountfortt, Clement, of King's Lynn, Norf, merchant 0
3933764 2001588 2001588 defendant Walden Silvester chapman 653412 653412 Walden, Silvester, of King's Lynn, Norf, chapman 0
3934483 2001829 2001829 defendant Bolden Francis   653412 653412 Bolden, Francis, of King's Lynn, Norf 0
3934767 2001925 2001925 defendant Sympson William yeoman 653412 653412 Sympson, William, of King's Lynn, Norf, yeoman 0
3934936 2001988 2001988 defendant Stottyng John yeoman 653412 653412 Stottyng, John, of King's Lynn, Norf, yeoman 0
3939514 2003519 2003519 defendant Ryveley George   653412 653412 Ryveley, George, of King's Lynn, Norf, fish monger 3
3939641 2003565 2003565 defendant Pace Robert merchant 653412 653412 Pace, Robert, of King's Lynn, Norf, merchant 0
3940375 2003801 2003801 defendant Bowllden Francis chapman 653412 653412 Bowllden, Francis, of King's Lynn, Norf, chapman 1
3941094 2004024 2004024 defendant Welby Francis merchant 653412 653412 Welby, Francis, of King's Lynn, Norf, merchant 0
3941376 2004124 2004124 defendant Reveley George merchant 653412 653412 Reveley, George, of King's Lynn, Norf, merchant 0
5039402 2368430 2368430 defendant Boston John roper 653412 653412 Boston, John, of King's Lynn, Norf, roper 2
5368381 2465726 2465726 defendant Codyngton John merchant 653412 653412 Codyngton, John, of King's Lynn, Norf, merchant 0
5369452 2466036 2466036 defendant Halyday Agnes widow 653412 653412 Halyday, Agnes, of King's Lynn, Norf, widow 1
5372102 2466869 2466869 defendant Thorysby Robert gent 653412 653412 Thorysby, Robert, of King's Lynn, Norf, gent 0
5378507 2468863 2468863 defendant Curle Henry chaplain 653412 653412 Curle, Henry, of King's Lynn, Norf, chaplain 1
5378509 2468864 2468864 defendant Curle Henry chaplain 653412 653412 Curle, Henry, of King's Lynn, Norf, chaplain 0
5378882 2468982 2468982 defendant Medowe John vintner & burgess 653412 653412 Medowe, John, of King's Lynn, Norf, vintner & burgess 3

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