names

16 rows where place_id = 788599

✎ 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
4708681 2268089 2268089 defendant atte Gappe Alexander merchant 788599 788599 atte Gappe, Alexander, of Great Yarmouth, Norfolk, merchant 1
4716744 2270559 2270559 defendant Beclys John chapman 788599 788599 Beclys, John, of Great Yarmouth, Norfolk, chapman 0
4717891 2270936 2270936 defendant Barbour William barber 788599 788599 Barbour, William, of Great Yarmouth, Norfolk, barber 0
4762190 2284154 2284154 defendant Savage Peter merchant 788599 788599 Savage, Peter, of Great Yarmouth, Norfolk, merchant 0
4762385 2284218 2284218 defendant Elys Robert   788599 788599 Elys, Robert, of Great Yarmouth, Norfolk, burgess 0
4838846 2308080 2308080 defendant Johnson Henry cooper 788599 788599 Johnson, Henry, of Great Yarmouth, Norfolk, cooper 0
4844959 2309943 2309943 defendant Pierson John   788599 788599 Pierson, John, of Great Yarmouth, Norfolk, burgess & yeoman 0
4992407 2354615 2354615 defendant Widewill John merchant 788599 788599 Widewill, John, of Great Yarmouth, Norfolk, merchant 1
5184838 2411314 2411314 defendant Iryng Thomas merchant 788599 788599 Iryng, Thomas, of Great Yarmouth, Norfolk, merchant 0
5188299 2412288 2412288 defendant Noune or Nonne John merchant & burgess 788599 788599 Noune or Nonne, John, of Great Yarmouth, Norfolk, merchant & burgess 0
5201554 2416213 2416213 defendant Busshop Robert husbandman 788599 788599 Busshop, Robert, of Great Yarmouth, Norfolk, husbandman 0
5204551 2417081 2417081 defendant Fuller John merchant 788599 788599 Fuller, John, of Great Yarmouth, Norfolk, merchant 0
5204562 2417083 2417083 defendant Iryng Thomas merchant 788599 788599 Iryng, Thomas, of Great Yarmouth, Norfolk, merchant 0
5205987 2417483 2417483 defendant Bonde John chandler 788599 788599 Bonde, John, of Great Yarmouth, Norfolk, chandler 0
5210222 2418717 2418717 defendant Bunne Richard mariner & burgess 788599 788599 Bunne, Richard, of Great Yarmouth, Norfolk, mariner & burgess 0
5451975 2490472 2490472 defendant Taseburgh Robert   788599 788599 Taseburgh, Robert, of Great Yarmouth, Norfolk, burgess & merchant 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);