names

19 rows where case_id = 2320270

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4878662 2320270 2320270 plaintiff Throgmarton John     Throgmarton, John 0
4878663 2320270 2320270 plaintiff Rothur John     Rothur, John 1
4878664 2320270 2320270 defendant Parker John, senior yeoman 816351 816351 Parker, John, senior, of Nethewode, Herefs, yeoman 0
4878665 2320270 2320270 defendant Paker John yeoman 816352 816352 Paker, John, of Sundre, Herefs, yeoman 1
4878666 2320270 2320270 defendant Wescote John husbandman 816353 816353 Wescote, John, of Hellehale, Herefs, husbandman 2
4878667 2320270 2320270 defendant Barowe Roger husbandman 816354 816354 Barowe, Roger, of Colynton, Herefs, husbandman 3
4878668 2320270 2320270 defendant Warkeman John laborer 613845 613845 Warkeman, John, of Nethewode, laborer 4
4878669 2320270 2320270 defendant Fox William husbandman 753548 753548 Fox, William, of Sutton Sturmy, husbandman 5
4878670 2320270 2320270 defendant Brugge Richard husbandman 753548 753548 Brugge, Richard, of Sutton Sturmy, husbandman 6
4878671 2320270 2320270 defendant Wylkys Nicholas yeoman 816355 816355 Wylkys, Nicholas, of Cuyrewyard, yeoman 7
4878672 2320270 2320270 defendant Lye Roger husbandman 815000 815000 Lye, Roger, of Temedbury, husbandman 8
4878673 2320270 2320270 defendant Corveser Richard cordwainer 815000 815000 Corveser, Richard, of Temedbury, cordwainer 9
4878674 2320270 2320270 defendant Corveser John cordwainer 815000 815000 Corveser, John, of Temedbury, cordwainer 10
4878675 2320270 2320270 defendant Stenket or Steuket John husbandman 816356 816356 Stenket or Steuket, John, of Bokulton, husbandman 11
4878676 2320270 2320270 defendant Wylkes John laborer 595298 595298 Wylkes, John, of Weston, Salop, laborer 12
4878677 2320270 2320270 defendant Wolley Walter husbandman 753548 753548 Wolley, Walter, of Sutton Sturmy, husbandman 13
4878678 2320270 2320270 defendant Corveser Wulliam laborer 815000 815000 Corveser, Wulliam, of Temedbury, laborer 14
4878679 2320270 2320270 defendant Wynchester William husbandman 815000 815000 Wynchester, William, of Temedbury, husbandman 15
4878680 2320270 2320270 defendant Milward John laborer 815000 815000 Milward, John, of Temedbury, laborer 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);