names

30 rows where case_id = 2394500

✎ 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
5127410 2394500 2394500 plaintiff Bygod Ralph knight   Bygod, Ralph, knight 0
5127411 2394500 2394500 defendant Bulmer William esq 801894 801894 Bulmer, William, of Wilton in Cleveland, esq 0
5127412 2394500 2394500 defendant Boynton Thomas esq 849750 849750 Boynton, Thomas, of Ronceby in Cleveland, esq 1
5127413 2394500 2394500 defendant (illegible) Thomas esq 849751 849751 --, Thomas, of Little Worsale, esq 2
5127414 2394500 2394500 defendant Hedlam John   849752 849752 Hedlam, John, of Nouthorp 3
5127415 2394500 2394500 defendant Eure Robert esq 849753 849753 Eure, Robert, of Wylton, Clevelan, esq 4
5127416 2394500 2394500 defendant Elys John yeoman 849754 849754 Elys, John, of Clevelan, yeoman 5
5127417 2394500 2394500 defendant Parot Walter yeoman 590357 590357 Parot, Walter, of Wilton, yeoman 6
5127418 2394500 2394500 defendant Percy John yeoman 590357 590357 Percy, John, of Wilton, yeoman 7
5127419 2394500 2394500 defendant Bertr-- John shoemaker 761129 761129 Bertr--, John, of Cleveland, shoemaker 8
5127420 2394500 2394500 defendant Becham Christopher tailor 771992 771992 Becham, Christopher, of Gisburgh, tailor 9
5127421 2394500 2394500 defendant Fletcher Richard   771992 771992 Fletcher, Richard, of Gisburgh 10
5127422 2394500 2394500 defendant Forster (illegible) yeoman 849755 849755 Forster, --, of Esyngton, Cleveland, yeoman 11
5127423 2394500 2394500 defendant Laverok Thomas     Laverok, Thomas 12
5127424 2394500 2394500 defendant another of Lythe yeoman   another, of Lythe, yeoman 13
5127425 2394500 2394500 defendant Abote Thomas   849756 849756 Abote, Thomas, of Boronby, of Lythe 14
5127426 2394500 2394500 defendant another   husbandman   another, husbandman 15
5127427 2394500 2394500 defendant Carlell William husbandman 849757 849757 Carlell, William, of Boronby, in Lythe, husbandman 16
5127428 2394500 2394500 defendant Walker (illegible) smith 699876 699876 Walker, --, of Aton in Cleveland, smith 17
5127429 2394500 2394500 defendant Bulman Gilbert yeoman   Bulman, Gilbert, yeoman 18
5127430 2394500 2394500 defendant Thomson John   779600 779600 Thomson, John, of Ronceby 19
5127431 2394500 2394500 defendant Bulman (illegible) or Ronceby, husbandman   Bulman, --, or Ronceby, husbandman 20
5127432 2394500 2394500 defendant Perto John husbandman 761129 761129 Perto, John, of Cleveland, husbandman 21
5127433 2394500 2394500 defendant Hill Robert yeoman 849758 849758 Hill, Robert, of North Lofthous in Cleveland, yeoman 22
5127434 2394500 2394500 defendant Clerk Thomas husbandman 698724 698724 Clerk, Thomas, of Bolby, husbandman 23
5127435 2394500 2394500 defendant Gibson John husbandman   Gibson, John, husbandman 24
5127436 2394500 2394500 defendant Sawer Richard   849759 849759 Sawer, Richard, of Righous by Ronceby 25
5127437 2394500 2394500 defendant Forster (illegible) husbandman 588405 588405 Forster, --, of Esyngton, husbandman 26
5127438 2394500 2394500 defendant Studerd Richard milner   Studerd, Richard, milner 27
5127439 2394500 2394500 defendant Sawer Richard sawer 849760 849760 Sawer, Richard, of Righous, sawer 28

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