names

13 rows where case_id = 2227365

✎ 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
4587069 2227365 2227365 plaintiff Horne Cecilia     Horne, Cecilia 0
4587070 2227365 2227365 defendant Louth John thatcher 772272 772272 Louth, John, of South Langton, thatcher 0
4587071 2227365 2227365 defendant Gylyot Richard weaver 645846 645846 Gylyot, Richard, of Westeryngton, weaver 1
4587072 2227365 2227365 defendant Kychen Richard     Kychen, Richard 2
4587073 2227365 2227365 defendant Kychen John   589133 589133 Kychen, John, of Marton 3
4587074 2227365 2227365 defendant Sadeler William   606788 606788 Sadeler, William, of Horncastle 4
4587075 2227365 2227365 defendant Donyngton Richard shoemaker 606788 606788 Donyngton, Richard, of Horncastle, shoemaker 5
4587076 2227365 2227365 defendant Strenger William   606788 606788 Strenger, William, of Horncastle 6
4587077 2227365 2227365 defendant Wadster Richard   606788 606788 Wadster, Richard, of Horncastle 7
4587078 2227365 2227365 defendant Lorymer Gregory   606788 606788 Lorymer, Gregory, of Horncastle 8
4587079 2227365 2227365 defendant Brous John jun, of Horncastle   Brous, John, jun, of Horncastle 9
4587080 2227365 2227365 defendant Whith John shoemaker 606788 606788 Whith, John, of Horncastle, shoemaker 10
4587081 2227365 2227365 defendant Warde Robert shoemaker 606788 606788 Warde, Robert, of Horncastle, shoemaker 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);