names

19 rows where case_id = 2186268

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4454002 2186268 2186268 plaintiff Lomynour Henry   585936 585936 Lomynour, Henry, of Norwich 0
4454003 2186268 2186268 defendant Baxtere Adam   586819 586819 Baxtere, Adam, of Worsted 0
4454004 2186268 2186268 defendant Wax William   586439 586439 Wax, William, of Fretenham 1
4454005 2186268 2186268 defendant Lyngstede Edmund     Lyngstede, Edmund 2
4454006 2186268 2186268 defendant atte Fen Thomas   589679 589679 atte Fen, Thomas, of Knapton 3
4454007 2186268 2186268 defendant Brayd John   757870 757870 Brayd, John, of Bliclyng 4
4454008 2186268 2186268 defendant Andrewes John   758454 758454 Andrewes, John, of Mostwyk 5
4454009 2186268 2186268 defendant Pour Thomas   587913 587913 Pour, Thomas, of Pulham 6
4454010 2186268 2186268 defendant Ankersmyth John   596683 596683 Ankersmyth, John, of Berton 7
4454011 2186268 2186268 defendant Kyng John   589927 589927 Kyng, John, of Paston 8
4454012 2186268 2186268 defendant Ingham William de   588126 588126 Ingham, William de, of North Walsham 9
4454013 2186268 2186268 defendant Smyth John   757841 757841 Smyth, John, of Monton 10
4454014 2186268 2186268 defendant Sigwat Thomas   588126 588126 Sigwat, Thomas, of North Walsham 11
4454015 2186268 2186268 defendant Sigwat Alice     Alice, his wife 12
4454016 2186268 2186268 defendant Hert Paganus   587449 587449 Hert, Paganus, of Felmyngham 13
4454017 2186268 2186268 defendant Whaplode Thomas   587166 587166 Whaplode, Thomas, of Salle 14
4454018 2186268 2186268 defendant Cart Robert   588126 588126 Cart, Robert, of North Walsham 15
4454019 2186268 2186268 defendant Byl John   590106 590106 Byl, John, of South Walsham 16
4454020 2186268 2186268 defendant Draper William of Lyng     Draper, William of Lyng 17

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