names

16 rows where case_id = 2229261

✎ 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
4593543 2229261 2229261 plaintiff Paynell Simon servant of Geoffrey Paynell   Paynell, Simon, servant of Geoffrey Paynell 0
4593544 2229261 2229261 defendant Casterton Richard   674467 674467 Casterton, Richard, of Humby 0
4593545 2229261 2229261 defendant Hull Roger     Hull, Roger 1
4593546 2229261 2229261 defendant Casterton Andrew servant of Richard Casterton   Casterton, Andrew, servant of Richard Casterton 2
4593547 2229261 2229261 defendant Casterton Alan servant of Richard   Casterton, Alan, servant of Richard 3
4593548 2229261 2229261 defendant Pynchebek Thomas     Pynchebek, Thomas 4
4593549 2229261 2229261 defendant Botiler William     Botiler, William 5
4593550 2229261 2229261 defendant Hers William   674467 674467 Hers, William, of Humby 6
4593551 2229261 2229261 defendant Lounsby Roger   593077 593077 Lounsby, Roger, of Somerby 7
4593552 2229261 2229261 defendant Hull Richard     Hull, Richard 8
4593553 2229261 2229261 defendant Hagas John     Hagas, John 9
4593554 2229261 2229261 defendant Pynder Nicholas   686712 686712 Pynder, Nicholas, of Roppesley 10
4593555 2229261 2229261 defendant smyth Robert fo Roppesley   smyth, Robert, fo Roppesley 11
4593556 2229261 2229261 defendant Smyth William   686712 686712 Smyth, William, of Roppesley 12
4593557 2229261 2229261 defendant Bayhard John   674467 674467 Bayhard, John, of Humby 13
4593558 2229261 2229261 defendant Scot John   674467 674467 Scot, John, of Humby 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);