names

17 rows where case_id = 2487005

✎ 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
5440311 2487005 2487005 plaintiff Wolman Thomas gent 585936 585936 Wolman, Thomas, of Norwich, gent, on his own account 0
5440312 2487005 2487005 defendant Dukworth Ellis yeoman 589398 589398 Dukworth, Ellis, of Blofeld, yeoman 0
5440313 2487005 2487005 defendant Purke Thomas yeoman 887705 887705 Purke, Thomas, of Wodbastewyk, yeoman 1
5440314 2487005 2487005 defendant Amys Richard yeoman 589045 589045 Amys, Richard, of Possewyk, yeoman 2
5440315 2487005 2487005 defendant Southed Thomas baker 586940 586940 Southed, Thomas, of Baldeswell, baker 3
5440316 2487005 2487005 defendant Sprotte Adam husbandman 762804 762804 Sprotte, Adam, of Great Plumsted, husbandman 4
5440317 2487005 2487005 defendant Castellacre Robert grainer 585936 585936 Castellacre, Robert, of Norwich, grainer 5
5440318 2487005 2487005 defendant Cok John   585936 585936 Cok, John, of Norwich, coverlet weaver 6
5440319 2487005 2487005 defendant Cokkys John smith 587166 587166 Cokkys, John, of Salle, smith 7
5440320 2487005 2487005 defendant Carter John husbandman 591070 591070 Carter, John, of Refham, husbandman 8
5440321 2487005 2487005 defendant Reed Robert husbandman 595471 595471 Reed, Robert, of Whitwell, husbandman 9
5440322 2487005 2487005 defendant Plumbe Thomas husbandman 587836 587836 Plumbe, Thomas, of Folsham, husbandman 10
5440323 2487005 2487005 defendant Farwell William yeoman 588849 588849 Farwell, William, of North Tudenham, yeoman 11
5440324 2487005 2487005 defendant Erle Robert husbandman 870217 870217 Erle, Robert, of Carleton Forowe, husbandman 12
5440325 2487005 2487005 defendant Pedder John woolman 615449 615449 Pedder, John, of Waterden, woolman 13
5440326 2487005 2487005 defendant Asshman Richard grocer 585936 585936 Asshman, Richard, of Norwich, grocer 14
5440327 2487005 2487005 defendant Est Peter yeoman 620357 620357 Est, Peter, of Wychyngham St Mary, yeoman 15

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