names

16 rows where case_id = 2206872

✎ 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
4520870 2206872 2206872 plaintiff Fransham Geoffrey     Fransham, Geoffrey 0
4520871 2206872 2206872 plaintiff Fransham Joan     Joan, his wife 1
4520872 2206872 2206872 defendant Bretoun John     Bretoun, John 0
4520873 2206872 2206872 defendant Bretoun Katherine     Katherine, his wife 1
4520874 2206872 2206872 defendant Bretoun Nicholas     Bretoun, Nicholas 2
4520875 2206872 2206872 defendant Bloogate John   595078 595078 Bloogate, John, of Hawele 3
4520876 2206872 2206872 defendant Crosse Thomas     Crosse, Thomas 4
4520877 2206872 2206872 defendant Boole John   587061 587061 Boole, John, of Combes 5
4520878 2206872 2206872 defendant Fullere John     together with Fullere, John 6
4520879 2206872 2206872 defendant Sadelere Stephen   588273 588273 Sadelere, Stephen, of Stowmarket 7
4520880 2206872 2206872 defendant Sherman William   588273 588273 Sherman, William, of Stowmarket 8
4520881 2206872 2206872 defendant Skynnere Richard   586818 586818 Skynnere, Richard, of Stowemarket 9
4520882 2206872 2206872 defendant Eston William     Eston, William 10
4520883 2206872 2206872 defendant Chapeleyn John     Chapeleyn, John 11
4520884 2206872 2206872 defendant Millere John     Millere, John 12
4520885 2206872 2206872 defendant Waryn John potter   Waryn, John, potter 13

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