names

31 rows where place_id = 590184

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600176 1867706 1867706 defendant Eston William weaver 590184 590184 Eston, William, of Stepyng, weaver 4
3600188 1867708 1867708 defendant Yatys John yeoman 590184 590184 Yatys, John, of Stepyng, yeoman 0
3600189 1867708 1867708 defendant Ranson Hugh husbandman 590184 590184 Ranson, Hugh, of Stepyng, husbandman 1
3691153 1923396 1923396 plaintiff Heron John miller 590184 590184 Heron, John, of Stepyng, miller 1
3727197 1934778 1934778 defendant Austen William yeoman 590184 590184 Austen, William, of Stepyng, yeoman 4
3805364 1959625 1959625 defendant Grave Thomas husbandman 590184 590184 Grave, Thomas, of Stepyng, husbandman 0
3805365 1959625 1959625 defendant Scopholme Thomas husbandman 590184 590184 Scopholme, Thomas, of Stepyng, husbandman 1
3846817 1972555 1972555 plaintiff Gybson William   590184 590184 Gybson, William, of Stepyng 2
3862319 1977584 1977584 plaintiff Gybson William mercer 590184 590184 Gybson, William, of Stepyng, mercer 2
3922930 1997973 1997973 defendant Scrop William husbandman 590184 590184 Scrop, William, of Stepyng, husbandman 1
3931970 2000993 2000993 defendant Cokkeshede Thomas yeoman 590184 590184 Cokkeshede, Thomas, of Stepyng, yeoman 0
3964760 2012281 2012281 defendant Benten William husbandman 590184 590184 Benten, William, of Stepyng, husbandman 0
4048205 2041796 2041796 defendant Bate Thomas yeoman 590184 590184 Bate, Thomas, of Stepyng, yeoman 1
4458805 2187800 2187800 defendant Gunnessonne Randolf   590184 590184 Gunnessonne, Randolf, of Stepyng 0
4464533 2189574 2189574 defendant Shelford William   590184 590184 Shelford, William, of Stepyng 5
4545616 2214551 2214551 plaintiff Maryson John   590184 590184 Maryson, John, of Stepyng 1
4604736 2232649 2232649 defendant Gybson John   590184 590184 Gybson, John, of Stepyng 0
4607303 2233395 2233395 defendant Pope Oliver   590184 590184 Pope, Oliver, of Stepyng 0
4608216 2233679 2233679 defendant Mavuns John   590184 590184 Mavuns, John, of Stepyng 0
4608217 2233679 2233679 defendant Mavuns William   590184 590184 Mavuns, William, of Stepyng, son of John 1
4608516 2233771 2233771 defendant Mavinus or Maunns John   590184 590184 Mavinus or Maunns, John, of Stepyng 0
4634866 2241757 2241757 defendant Nevyll William clerk 590184 590184 Nevyll, William, of Stepyng, clerk 0
4646666 2245089 2245089 defendant atte Touneshende Thomas   590184 590184 atte Touneshende, Thomas, of Stepyng 0
4668663 2255912 2255912 defendant Pope Oliver summoner 590184 590184 Pope, Oliver, of Stepyng, summoner 0
4702519 2266200 2266200 defendant Grane John husbandman 590184 590184 Grane, John, of Stepyng, husbandman 1
4757927 2282856 2282856 defendant Warde William husbandman 590184 590184 Warde, William, of Stepyng, husbandman 0
4858518 2314039 2314039 defendant Grayve or Grayne John husbandman 590184 590184 Grayve or Grayne, John, of Stepyng, husbandman 0
4873099 2318540 2318540 defendant Fowele John husbandman 590184 590184 Fowele, John, of Stepyng, husbandman 3
5038195 2368058 2368058 defendant Brees Richard husbandman 590184 590184 Brees, Richard, of Stepyng, husbandman, son of Brese, Simon, of Stepyng, husbandman 0
5289248 2441856 2441856 defendant Rose John husbandman 590184 590184 Rose, John, of Stepyng, husbandman 11
5394757 2473566 2473566 defendant Moore Richard gent 590184 590184 Moore, Richard, of Stepyng, gent 0

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