names

21 rows where case_id = 2195493

✎ 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
4483357 2195493 2195493 plaintiff (not given)   freeman of the port of Northampton   Northampton, freeman of the port of, on their own account 0
4483358 2195493 2195493 defendant Denes John   599957 599957 Denes, John, of Sprotton 0
4483359 2195493 2195493 defendant Syward John   761965 761965 Syward, John, of Hamslap 1
4483360 2195493 2195493 defendant William John   761962 761962 William, John, of Kyngesclyf, mason 2
4483361 2195493 2195493 defendant Baill John   594214 594214 Baill, John, of stoke Goldyngton 3
4483362 2195493 2195493 defendant Chaloner Hugh   586848 586848 Chaloner, Hugh, of Northampton 4
4483363 2195493 2195493 defendant Chaloner Thomas     Chaloner, Thomas 5
4483364 2195493 2195493 defendant Baker Simon   586848 586848 Baker, Simon, of Northampton 6
4483365 2195493 2195493 defendant Strynger Roger   586848 586848 Strynger, Roger, of Northampton 7
4483366 2195493 2195493 defendant Dallyng John   761967 761967 Dallyng, John, of Colyngwrogh 8
4483367 2195493 2195493 defendant atte Lake Robert   588037 588037 atte Lake, Robert, of Lichefeld 9
4483368 2195493 2195493 defendant Holwe Thomas   756729 756729 Holwe, Thomas, of Byllyng 10
4483369 2195493 2195493 defendant Gos John   761968 761968 Gos, John, of Garton Yerlee 11
4483370 2195493 2195493 defendant Keresle John     Keresle, John 12
4483371 2195493 2195493 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 13
4483372 2195493 2195493 defendant Baill of Tatenhale     Baill, of Tatenhale 14
4483373 2195493 2195493 defendant Grene Thomas tailor   Grene, Thomas, tailor 15
4483374 2195493 2195493 defendant Barcolf Nicholas   757331 757331 Barcolf, Nicholas, of Waldegrave 16
4483375 2195493 2195493 defendant Chyrye John   757331 757331 Chyrye, John, of Waldegrave 17
4483376 2195493 2195493 defendant Nicholl John     Nicholl, John 18
4483377 2195493 2195493 defendant Salman Simon   761969 761969 Salman, Simon, of Cranesle 19

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