names

16 rows where case_id = 2495738

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5469261 2495738 2495738 plaintiff Danne William     Danne, William, on his own account 0
5469262 2495738 2495738 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5469263 2495738 2495738 defendant N_ Richard husbandman 586418 586418 N_, Richard, of Garboldesham, husbandman 1
5469264 2495738 2495738 defendant Pycher Edward   586157 586157 Pycher, Edward, of Mateshale 2
5469265 2495738 2495738 defendant Lenman John   890771 890771 Lenman, John, of Elsyngglover 3
5469266 2495738 2495738 defendant Langtoft Nicholas draper 587172 587172 Langtoft, Nicholas, of East Derham, draper 4
5469267 2495738 2495738 defendant Keton Robert yeoman 590844 590844 Keton, Robert, of Lyng, yeoman 5
5469268 2495738 2495738 defendant Harowe John   585936 585936 Harowe, John, of Norwich, tallow chandler 6
5469269 2495738 2495738 defendant Saweton Richard yeoman 586940 586940 Saweton, Richard, of Baldeswell, yeoman 7
5469270 2495738 2495738 defendant Warner John yeoman 586940 586940 Warner, John, of Baldeswell, yeoman 8
5469271 2495738 2495738 defendant Cok Thomas yeoman 604275 604275 Cok, Thomas, of Gasthorp, yeoman 9
5469272 2495738 2495738 defendant Ketelston Thomas yeoman 592166 592166 Ketelston, Thomas, of Myleham, yeoman 10
5469273 2495738 2495738 defendant Chyncheball of Feltwell yeoman   Chyncheball, of Feltwell, yeoman 11
5469274 2495738 2495738 defendant Salter John (legal representative)   Salter, John, executor of 12
5469275 2495738 2495738 defendant Salter Walter yeoman 890772 890772 Salter, Walter, of Totyngton by Elsyng, yeoman 13
5469276 2495738 2495738 defendant Frankersh Luke yeoman 585869 585869 Frankersh, Luke, of London, yeoman 14

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