names

12 rows where case_id = 2219790

✎ 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
4562359 2219790 2219790 plaintiff Port Fremundus de la   586848 586848 Port, Fremundus de la, of Northampton 0
4562360 2219790 2219790 defendant Sekford Nicholas   754637 754637 Sekford, Nicholas, of Briklesworth 0
4562361 2219790 2219790 defendant Druwell Stephen   590061 590061 Druwell, Stephen, of Barton 1
4562362 2219790 2219790 defendant Raven John   586344 586344 Raven, John, of Burton 2
4562363 2219790 2219790 defendant Peek Henry   586779 586779 Peek, Henry, of Brampton 3
4562364 2219790 2219790 defendant Jemes Walter   590061 590061 Jemes, Walter, of Barton 4
4562365 2219790 2219790 defendant Draper Robert   587367 587367 Draper, Robert, of Rothewell 5
4562366 2219790 2219790 defendant Norman Geoffrey   769860 769860 Norman, Geoffrey, of Braddene 6
4562367 2219790 2219790 defendant Shethere John   587367 587367 Shethere, John, of Rothewell 7
4562368 2219790 2219790 defendant Hayward Robert   586779 586779 Hayward, Robert, of Brampton 8
4562369 2219790 2219790 defendant Gamel William chaplain   Gamel, William, chaplain 9
4562370 2219790 2219790 defendant Trusselove John baker 587510 587510 Trusselove, John, of Toucestre, baker 10

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