names

14 rows where case_id = 2211370

✎ 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
4535484 2211370 2211370 plaintiff Slepe William     Slepe, William 0
4535485 2211370 2211370 defendant Foxcote John     Foxcote, John 0
4535486 2211370 2211370 defendant Hauryes Richard     Hauryes, Richard 1
4535487 2211370 2211370 defendant Russell Roger     Russell, Roger 2
4535488 2211370 2211370 defendant Wall William     Wall, William 3
4535489 2211370 2211370 defendant Elyot Thomas     Elyot, Thomas 4
4535490 2211370 2211370 defendant Bakere Richard     Bakere, Richard 5
4535491 2211370 2211370 defendant Staunton John de     Staunton, John de 6
4535492 2211370 2211370 defendant Harryes William     Harryes, William 7
4535493 2211370 2211370 defendant Sutton John   767100 767100 Sutton, John, of Little Aston 8
4535494 2211370 2211370 defendant Hayteley John butcher   Hayteley, John, butcher 9
4535495 2211370 2211370 defendant Wenlok Roger vicar of the church, in   Wenlok, Roger, vicar of the church, in 10
4535496 2211370 2211370 defendant Wyke Thomas     Wyke, Thomas 11
4535497 2211370 2211370 defendant Normanton William skinner 586901 586901 Normanton, William, of Nottingham, skinner 12

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