names

16 rows where case_id = 2222854

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4572220 2222854 2222854 plaintiff Arundell John knight   Arundell, John, knight 0
4572221 2222854 2222854 defendant Trewerys Peter     Trewerys, Peter 0
4572222 2222854 2222854 defendant Bavy John     Bavy, John 1
4572223 2222854 2222854 defendant Hony John     Hony, John 2
4572224 2222854 2222854 defendant Nicol Lawrence son of Margaret   Nicol, Lawrence, son of Margaret 3
4572225 2222854 2222854 defendant Mapedaas Thomas   770880 770880 Mapedaas, Thomas, of Poltarowe 4
4572226 2222854 2222854 defendant Vyhen John   770881 770881 Vyhen, John, of Bossythyowe 5
4572227 2222854 2222854 defendant Nawynter Thomas     Nawynter, Thomas 6
4572228 2222854 2222854 defendant Cornowe Gregory     Cornowe, Gregory 7
4572229 2222854 2222854 defendant Huchyn John   770882 770882 Huchyn, John, of Brougolewe 8
4572230 2222854 2222854 defendant Knokyn William     Knokyn, William 9
4572231 2222854 2222854 defendant Trenowyth John     Trenowyth, John 10
4572232 2222854 2222854 defendant Colyn John     Colyn, John 11
4572233 2222854 2222854 defendant Bonnek John     Bonnek, John 12
4572234 2222854 2222854 defendant Philip Thomas     Philip, Thomas 13
4572235 2222854 2222854 defendant Penwytheryk John     Penwytheryk, John 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);