names

34 rows where case_id = 1873653

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619435 1873653 1873653 plaintiff Huby Amrmaduke abbot of Fountains Abbey   Huby, Amrmaduke, abbot of Fountains Abbey 0
3619436 1873653 1873653 defendant Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
3619437 1873653 1873653 defendant Topham William walker 588774 588774 Topham, William, of Willesthorp, walker 1
3619438 1873653 1873653 defendant Laweson William yeoman 588774 588774 Laweson, William, of Willesthorp, yeoman 2
3619439 1873653 1873653 defendant Topham Robert yeoman 588774 588774 Topham, Robert, of Willesthorp, yeoman 3
3619440 1873653 1873653 defendant Spynke John laborer 588774 588774 Spynke, John, of Willesthorp, laborer 4
3619441 1873653 1873653 defendant Thurstane Robert fisher 588774 588774 Thurstane, Robert, of Willesthorp, fisher 5
3619442 1873653 1873653 defendant Johnson William yeoman 588774 588774 Johnson, William, of Willesthorp, yeoman 6
3619443 1873653 1873653 defendant Scott Anthony   588774 588774 Scott, Anthony, of Willesthorp, cook 7
3619444 1873653 1873653 defendant Nelson John laborer 588774 588774 Nelson, John, of Willesthorp, laborer 8
3619445 1873653 1873653 defendant Nelson Ralph laborer 588774 588774 Nelson, Ralph, of Willesthorp, laborer 9
3619446 1873653 1873653 defendant Spynke Thomas yeoman 588774 588774 Spynke, Thomas, of Willesthorp, yeoman 10
3619447 1873653 1873653 defendant Gibson William yeoman 588774 588774 Gibson, William, of Willesthorp, yeoman 11
3619448 1873653 1873653 defendant Beke Richard yeoman 588774 588774 Beke, Richard, of Willesthorp, yeoman 12
3619449 1873653 1873653 defendant Rychardson Brian tailor 588774 588774 Rychardson, Brian, of Willesthorp, tailor 13
3619450 1873653 1873653 defendant Topham Henry yeoman 588774 588774 Topham, Henry, of Willesthorp, yeoman 14
3619451 1873653 1873653 defendant Laweson Thomas yeoman 588774 588774 Laweson, Thomas, of Willesthorp, yeoman 15
3619452 1873653 1873653 defendant Laweson Miles yeoman 595214 595214 Laweson, Miles, of More Monkton, yeoman: Proktour, Roger, of More Monkton, yeoman 16
3619453 1873653 1873653 defendant Bateson John miller 595214 595214 Bateson, John, of More Monkton, miller 17
3619454 1873653 1873653 defendant Halys Robert tailor 595215 595215 Halys, Robert, of Tokwyth, tailor 18
3619455 1873653 1873653 defendant Eland Henry husbandman 595215 595215 Eland, Henry, of Tokwyth, husbandman 19
3619456 1873653 1873653 defendant Bolton Thomas laborer 595215 595215 Bolton, Thomas, of Tokwyth, laborer 20
3619457 1873653 1873653 defendant Thomlynson William husbandman 595215 595215 Thomlynson, William, of Tokwyth, husbandman 21
3619458 1873653 1873653 defendant Hunsyngore William laborer 595215 595215 Hunsyngore, William, of Tokwyth, laborer 22
3619459 1873653 1873653 defendant Smyth John     Smyth, John 23
3619460 1873653 1873653 defendant Abbay Thomas     Abbay, Thomas 24
3619461 1873653 1873653 defendant Wrey John     Wrey, John 25
3619462 1873653 1873653 defendant Hunter John     Hunter, John 26
3619463 1873653 1873653 defendant Stag Miles     Stag, Miles 27
3619464 1873653 1873653 defendant Ketilwell Robert     Ketilwell, Robert 28
3619465 1873653 1873653 defendant Eys or Gys Robert     Eys or Gys, Robert 29
3619466 1873653 1873653 defendant Coke Thomas     Coke, Thomas 30
3619467 1873653 1873653 defendant Leyke Richard     Leyke, Richard 31
3619468 1873653 1873653 defendant Herryson Richard     Herryson, Richard 32

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