names

18 rows where case_id = 2375892

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5064370 2375892 2375892 plaintiff Langham Gregory     Langham, Gregory 0
5064371 2375892 2375892 defendant Bogays Thomas yeoman 842113 842113 Bogays, Thomas, of Edwarston, yeoman 0
5064372 2375892 2375892 defendant Terry Peter merchant 586134 586134 Terry, Peter, of Ipswich, merchant 1
5064373 2375892 2375892 defendant Freman Edmund yeoman 585947 585947 Freman, Edmund, of Hadley, yeoman 2
5064374 2375892 2375892 defendant Witherald William yeoman 586505 586505 Witherald, William, of Brokford, yeoman 3
5064375 2375892 2375892 defendant Mateshale Andrew yeoman 842114 842114 Mateshale, Andrew, of Buklesham, yeoman 4
5064376 2375892 2375892 defendant Intebarough John yeoman 586134 586134 Intebarough, John, of Ipswich, yeoman 5
5064377 2375892 2375892 defendant Brymmouth John yeoman 638472 638472 Brymmouth, John, of Beklys, yeoman 6
5064378 2375892 2375892 defendant Lygote Robert shopman 611193 611193 Lygote, Robert, of Donewich, shopman 7
5064379 2375892 2375892 defendant Blythe Roger yeoman 586134 586134 Blythe, Roger, of Ipswich, yeoman 8
5064380 2375892 2375892 defendant Weylond John yeoman 771570 771570 Weylond, John, of Groundesburgh, yeoman 9
5064381 2375892 2375892 defendant Skarp John vintner 586180 586180 Skarp, John, of Bury St Edmunds, vintner 10
5064382 2375892 2375892 defendant Shoppe Andrew, senior yeoman 796418 796418 Shoppe, Andrew, senior, of Monks Illey, yeoman 11
5064383 2375892 2375892 defendant Mors John yeoman 599776 599776 Mors, John, of Shotley, yeoman 12
5064384 2375892 2375892 defendant Terre Geoffrey merchant 586134 586134 Terre, Geoffrey, of Ipswich, merchant 13
5064385 2375892 2375892 defendant Rendelesham John, junior yeoman 589592 589592 Rendelesham, John, junior, of Rendelesham, yeoman 14
5064386 2375892 2375892 defendant Rycher Robert yeoman 589127 589127 Rycher, Robert, of Walton, yeoman 15
5064387 2375892 2375892 defendant Wygmore John   586134 586134 Wygmore, John, of Ipswich, servant 16

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