names

17 rows where case_id = 2548840

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5616125 2548840 2548840 plaintiff Hede John   587151 587151 Hede, John, of Flete, formerly sheriff of Lincoln 0
5616126 2548840 2548840 defendant Plummton Thomas     Plummton, Thomas 0
5616127 2548840 2548840 defendant Spaldeford Richard     Spaldeford, Richard 1
5616128 2548840 2548840 defendant Claworth Thomas     Claworth, Thomas 2
5616129 2548840 2548840 defendant Daynill Ralph     Daynill, Ralph 3
5616130 2548840 2548840 defendant Bouceby Robert   759246 759246 Bouceby, Robert, of East Loghton 4
5616131 2548840 2548840 defendant Grey William   765074 765074 Grey, William, of Goudeby 5
5616132 2548840 2548840 defendant Warde Robert chaplain   Warde, Robert, chaplain 6
5616133 2548840 2548840 defendant Male Alexander   759686 759686 Male, Alexander, of Quaplade 7
5616134 2548840 2548840 defendant Wyvelesey Alexander de     Wyvelesey, Alexander de 8
5616135 2548840 2548840 defendant Oundell John de   756923 756923 Oundell, John de, of Billesfeld 9
5616136 2548840 2548840 defendant Myme John de     Myme, John de 10
5616137 2548840 2548840 defendant Gelle Robert Alexander 906174 906174 Gelle, Robert, of Gra-ham, Hunnyng, Alexander 11
5616138 2548840 2548840 defendant Chosell Thomas de   586286 586286 Chosell, Thomas de, of Boston 12
5616139 2548840 2548840 defendant Emery Thomas   586286 586286 Emery, Thomas, of Boston 13
5616140 2548840 2548840 defendant Lycla John de     Lycla, John de 14
5616141 2548840 2548840 defendant Clerk John   814593 814593 Clerk, John, of Welbourn 15

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