names

28 rows where case_id = 2405922

✎ 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
5166478 2405922 2405922 plaintiff Bygod Ralph knight   Bygod, Ralph, knight 0
5166479 2405922 2405922 defendant Bulmer William esq 855360 855360 Bulmer, William, of Wilton, in Cleveland, esq 0
5166480 2405922 2405922 defendant Boynton Thomas esq 855361 855361 Boynton, Thomas, of Rouceby in Cleveland, esq 1
5166481 2405922 2405922 defendant Pudsay Thomas esq 849751 849751 Pudsay, Thomas, of Little Worsale, esq 2
5166482 2405922 2405922 defendant Hedlam John gent 855362 855362 Hedlam, John, of Nonthorp, gent 3
5166483 2405922 2405922 defendant Eure Robert esq 801894 801894 Eure, Robert, of Wilton in Cleveland, esq 4
5166484 2405922 2405922 defendant Elys John yeoman 855360 855360 Elys, John, of Wilton, in Cleveland, yeoman 5
5166485 2405922 2405922 defendant Parot Walter yeoman 855360 855360 Parot, Walter, of Wilton, in Cleveland, yeoman 6
5166486 2405922 2405922 defendant Percy John yeoman 590357 590357 Percy, John, of Wilton, yeoman 7
5166487 2405922 2405922 defendant Bertram John shoemaker 855363 855363 Bertram, John, of Gisbourgh, in Cleveland, shoemaker 8
5166488 2405922 2405922 defendant Becham Christopher tailor 763754 763754 Becham, Christopher, of Gysburgh, tailor 9
5166489 2405922 2405922 defendant Fleccher Richard   771992 771992 Fleccher, Richard, of Gisburgh, arrow maker 10
5166490 2405922 2405922 defendant Forster John yeoman 855365 855365 Forster, John, of Esyngton, in Cleveland, yeoman 11
5166491 2405922 2405922 defendant Laverok Thomas yeoman 855366 855366 Laverok, Thomas, of Borouby in Lythe, yeoman 12
5166492 2405922 2405922 defendant Avote Thomas husbandman 855366 855366 Avote, Thomas, of Borouby in Lythe, husbandman 13
5166493 2405922 2405922 defendant Carlell William husbandman 855366 855366 Carlell, William, of Borouby in Lythe, husbandman 14
5166494 2405922 2405922 defendant Walker Richard smith 855151 855151 Walker, Richard, of Aton, in Cleveland, smith 15
5166495 2405922 2405922 defendant Bulman Gilbert yeoman 855367 855367 Bulman, Gilbert, of Rouceby, in Cleveland, yeoman 16
5166496 2405922 2405922 defendant Thomson John husbandman 754283 754283 Thomson, John, of Rouceby, husbandman 17
5166497 2405922 2405922 defendant Bulman William husbandman 754283 754283 Bulman, William, of Rouceby, husbandman 18
5166498 2405922 2405922 defendant Perot John husbandman 855368 855368 Perot, John, of South Lofthous, in Cleveland, husbandman 19
5166499 2405922 2405922 defendant Hill Robert yeoman 789264 789264 Hill, Robert, of North Lofthous, yeoman 20
5166500 2405922 2405922 defendant Clerk Thomas husbandman 698724 698724 Clerk, Thomas, of Bolby, husbandman 21
5166501 2405922 2405922 defendant Gibson John   855369 855369 Gibson, John, of Rouceby, husbandan 22
5166502 2405922 2405922 defendant Sawer Richard sawyer 855370 855370 Sawer, Richard, of Righous by Rouceby, sawyer 23
5166503 2405922 2405922 defendant Forster John husbandman 855371 855371 Forster, John, of Esyngton in Cleveland, husbandman 24
5166504 2405922 2405922 defendant Studerd Richard miller 792503 792503 Studerd, Richard, of Scalyng, miller 25
5166505 2405922 2405922 defendant Sawer Richard sawer 849760 849760 Sawer, Richard, of Righous, sawer 26

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