names

25 rows where case_id = 2237719

✎ 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
4621493 2237719 2237719 plaintiff Langelond Joan     Langelond, Joan 0
4621494 2237719 2237719 defendant Talgerrek Peter     Talgerrek, Peter 0
4621495 2237719 2237719 defendant Ceny William   775286 775286 Ceny, William, of Talgarrek 1
4621496 2237719 2237719 defendant Farsy John   775287 775287 Farsy, John, of Carugwynnek 2
4621497 2237719 2237719 defendant Hikkealy Reginald son of John   Hikkealy, Reginald, son of John 3
4621498 2237719 2237719 defendant Swetyng John   775288 775288 Swetyng, John, of Trevolhan 4
4621499 2237719 2237719 defendant Bettou John   775288 775288 Bettou, John, of Trevolhan 5
4621500 2237719 2237719 defendant Colyn John   775288 775288 Colyn, John, of Trevolhan 6
4621501 2237719 2237719 defendant Slade Pastus     Slade, Pastus 7
4621502 2237719 2237719 defendant Maryn John   775289 775289 Maryn, John, of Grandpond 8
4621503 2237719 2237719 defendant Treflyen Odo son of Hugh   Treflyen, Odo, son of Hugh 9
4621504 2237719 2237719 defendant Nanstelen Nicholas     Nanstelen, Nicholas 10
4621505 2237719 2237719 defendant Jakkeraubyn Thomas     Jakkeraubyn, Thomas 11
4621506 2237719 2237719 defendant Hykke Thomas   775290 775290 Hykke, Thomas, of Resugou 12
4621507 2237719 2237719 defendant Andreu John   775291 775291 Andreu, John, of Nanscelen 13
4621508 2237719 2237719 defendant Glaas Henry     Glaas, Henry 14
4621509 2237719 2237719 defendant Glaas Richard     Glaas, Richard 15
4621510 2237719 2237719 defendant Tregher Reginald   595682 595682 Tregher, Reginald, of St Probus 16
4621511 2237719 2237719 defendant Molfre John     Molfre, John 17
4621512 2237719 2237719 defendant Pytte John     Pytte, John 18
4621513 2237719 2237719 defendant Noel John   775292 775292 Noel, John, of Trewyns 19
4621514 2237719 2237719 defendant Penhall Reginald     Penhall, Reginald 20
4621515 2237719 2237719 defendant Pennans Lucy de     Pennans, Lucy de 21
4621516 2237719 2237719 defendant Meleder Richard de     Meleder, Richard de 22
4621517 2237719 2237719 defendant Pennant Pastus de     Pennant, Pastus de 23

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