names

13 rows where case_id = 2548999

✎ 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
5616612 2548999 2548999 plaintiff Howome Robert de   586067 586067 Howome, Robert de, of York 0
5616613 2548999 2548999 defendant Strousall John   594543 594543 Strousall, John, of Tikhill 0
5616614 2548999 2548999 defendant Marschall Adam   906229 906229 Marschall, Adam, of Mikelhawe 1
5616615 2548999 2548999 defendant Lyghtfote William   620148 620148 Lyghtfote, William, of Skypton in Craven 2
5616616 2548999 2548999 defendant Smyth John   615257 615257 Smyth, John, of Richemond 3
5616617 2548999 2548999 defendant Cokka John   596911 596911 Cokka, John, of Richmond 4
5616618 2548999 2548999 defendant Man John chaplain 615257 615257 Man, John, of Richemond, chaplain 5
5616619 2548999 2548999 defendant Litster Randolf   629423 629423 Litster, Randolf, of Burghbrigge 6
5616620 2548999 2548999 defendant Letster George   587028 587028 Letster, George, of Whitby 7
5616621 2548999 2548999 defendant Litster Henry   611861 611861 Litster, Henry, of Helmyslay 8
5616622 2548999 2548999 defendant Bluman Thomas   755684 755684 Bluman, Thomas, of Kirkeby in Lonesdale 9
5616623 2548999 2548999 defendant Marschall William   906230 906230 Marschall, William, of Bishops Wilton 10
5616624 2548999 2548999 defendant Stromondgate William   753729 753729 Stromondgate, William, of Kirkeby in Kendale 11

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