names

15 rows where case_id = 2195496

✎ 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
4483384 2195496 2195496 plaintiff (not given)   freemen of the port of Northampton   Northampton, freemen of the port of 0
4483385 2195496 2195496 defendant Syward John   761965 761965 Syward, John, of Hamslap 0
4483386 2195496 2195496 defendant William John     William, John 1
4483387 2195496 2195496 defendant Mason Rogerl of Kyngesclyf mercer   Mason, Rogerl of Kyngesclyf, mercer 2
4483388 2195496 2195496 defendant Baill John   594214 594214 Baill, John, of Stoke Goldyngton 3
4483389 2195496 2195496 defendant Chaloner Hugh   586848 586848 Chaloner, Hugh, of Northampton 4
4483390 2195496 2195496 defendant Chaloner Thomas     Chaloner, Thomas 5
4483391 2195496 2195496 defendant Baker Simon   586848 586848 Baker, Simon, of Northampton 6
4483392 2195496 2195496 defendant Stryngger Roger   586848 586848 Stryngger, Roger, of Northampton 7
4483393 2195496 2195496 defendant Dallyng John   761970 761970 Dallyng, John, of Colyngtregh 8
4483394 2195496 2195496 defendant atte Lake Robert   588037 588037 atte Lake, Robert, of Lichefeld 9
4483395 2195496 2195496 defendant Holwell Thomas   756729 756729 Holwell, Thomas, of Byllyng 10
4483396 2195496 2195496 defendant Goo John   761971 761971 Goo, John, of Barton Herles 11
4483397 2195496 2195496 defendant Keresle John     Keresle, John 12
4483398 2195496 2195496 defendant Bate Robert   599957 599957 Bate, Robert, of Sprotton 13

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