names

51 rows where place_id = 601723

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646713 1909372 1909372 defendant Marche Robert tailor 601723 601723 Marche, Robert, of Trunche, tailor 8
3670423 1916706 1916706 plaintiff Brownyng Thomas   601723 601723 Brownyng, Thomas, of Trunche 0
3686638 1921974 1921974 plaintiff Brownyng Thomas   601723 601723 Brownyng, Thomas, of Trunche 0
3686640 1921975 1921975 plaintiff Brownyng Thomas   601723 601723 Brownyng, Thomas, of Trunche 0
3696179 1925025 1925025 defendant Newton William yeoman 601723 601723 Newton, William, of Trunche, yeoman 1
3919236 1996763 1996763 defendant Skottowe William   601723 601723 Skottowe, William, of Trunche, worsted weaver 1
3980296 2017720 2017720 defendant Legate William husbandman 601723 601723 Legate, William, of Trunche, husbandman 0
4008562 2027827 2027827 defendant Howe Robert yeoman 601723 601723 Howe, Robert, of Trunche, yeoman 0
4026344 2034067 2034067 defendant Kempe John butcher 601723 601723 Kempe, John, of Trunche, butcher 2
4026352 2034068 2034068 defendant Cooke Robert thatcher 601723 601723 Cooke, Robert, of Trunche, thatcher 1
4033694 2036700 2036700 defendant Howse John yeoman 601723 601723 Howse, John, of Trunche, yeoman 1
4033698 2036701 2036701 defendant Howse John yeoman 601723 601723 Howse, John, of Trunche, yeoman 1
4075955 2051698 2051698 defendant Bakon Martin yeoman 601723 601723 Bakon, Martin, of Trunche, yeoman 2
4096126 2058942 2058942 defendant Heywarde Nicholas gent 601723 601723 Heywarde, Nicholas, of Trunche, gent 0
4136614 2073439 2073439 defendant Crosse Richard tailor 601723 601723 Crosse, Richard, of Trunche, tailor 1
4185680 2090495 2090495 defendant Haward Nicholas gent 601723 601723 Haward, Nicholas, of Trunche, gent 0
4225507 2104385 2104385 defendant Purgall William cordwainer 601723 601723 Purgall, William, of Trunche, cordwainer 0
4324118 2138472 2138472 defendant Bates Christopher yeoman 601723 601723 Bates, Christopher, of Trunche, yeoman 2
4327017 2139367 2139367 defendant Bates Christopher yeoman 601723 601723 Bates, Christopher, of Trunche, yeoman 0
4717137 2270687 2270687 defendant Wates Adam husbandman 601723 601723 Wates, Adam, of Trunche, husbandman 1
4968667 2347597 2347597 defendant Herman Waren yeoman 601723 601723 Herman, Waren, of Trunche, yeoman 0
4968668 2347597 2347597 defendant Stannard Thomas yeoman 601723 601723 Stannard, Thomas, of Trunche, yeoman 1
5078413 2380041 2380041 defendant Brounnyng Walter yeoman 601723 601723 Brounnyng, Walter, of Trunche, yeoman 1
5085356 2382111 2382111 defendant Martyns Nicholas husbandman 601723 601723 Martyns, Nicholas, of Trunche, husbandman 0
5096647 2385453 2385453 defendant Gigson Nicholas husbandman 601723 601723 Gigson, Nicholas, of Trunche, husbandman 0
5116031 2391117 2391117 defendant Hornyngtoft John husbandman 601723 601723 Hornyngtoft, John, of Trunche, husbandman 0
5126588 2394251 2394251 defendant Neuman Peter clerk 601723 601723 Neuman, Peter, of Trunche, clerk 0
5151201 2401494 2401494 defendant Hornyngtoft John husbandman 601723 601723 Hornyngtoft, John, of Trunche, husbandman 0
5187948 2412183 2412183 defendant Hornyngtoft John yeoman 601723 601723 Hornyngtoft, John, of Trunche, yeoman 0
5206213 2417551 2417551 defendant Hornyngtoft John yeoman 601723 601723 Hornyngtoft, John, of Trunche, yeoman 0
5244001 2428433 2428433 defendant Gryme Simon husbandman 601723 601723 Gryme, Simon, of Trunche, husbandman 1
5244002 2428433 2428433 defendant Fene Thomas husbanman 601723 601723 Fene, Thomas, of Trunche, husbanman 2
5299610 2444858 2444858 plaintiff Gryme Thomas   601723 601723 Gryme, Thomas, of Trunche 2
5370598 2466391 2466391 plaintiff Gryme Thomas   601723 601723 Gryme, Thomas, of Trunche 0
5402935 2475920 2475920 defendant Hornyngtofr John (legal representative) 601723 601723 Hornyngtofr, John, of Trunche, yeoman, executors of 1
5402936 2475920 2475920 defendant Hornyngtoft Robert yeoman 601723 601723 Hornyngtoft, Robert, of Trunche, yeoman 2
5415913 2479692 2479692 defendant Hornyngtoft Robert yeoman 601723 601723 Hornyngtoft, Robert, of Trunche, yeoman 2
5565809 2524596 2524596 defendant Hornyngtoft Robert (legal representative) 601723 601723 Hornyngtoft, Robert, of Trunche, husbandman, executor of Hornyngtoft, John, of Trunche, yeoman, executors of 0
5566124 2524689 2524689 defendant Howes Richard (legal representative) 601723 601723 Howes, Richard, of Trunche, husbandman, executor of Howes, Henry, of Paston, husbandman, executor of 0
5566126 2524689 2524689 defendant Howes Margaret widow 601723 601723 Howes, Margaret, of Trunche, widow 2
5566128 2524690 2524690 defendant Howes Richard (legal representative) 601723 601723 Howes, Richard, of Trunche, husbandman, executor of Howes, Henry, of Paston, husbandman, executor of 0
5566129 2524690 2524690 defendant Howes Margaret widow 601723 601723 (Howes, Margaret, of Trunche, widow 1
5566130 2524690 2524690 defendant Symondys Thomas husbandman 601723 601723 Symondys, Thomas, of Trunche, husbandman 2
5566137 2524692 2524692 defendant Howes Richard (legal representative) 601723 601723 Howes, Richard, of Trunche, husbandman, executor of Howes, Henry, of Paston, husbandman, executors of 0
5566138 2524692 2524692 defendant Howes Margaret widow 601723 601723 (Howes, Margaret, of Trunche, widow 1
5566139 2524692 2524692 defendant Symondes Thomas husbandman 601723 601723 Symondes, Thomas, of Trunche, husbandman 2
5573790 2526900 2526900 defendant Symondys Thomas husbandman 601723 601723 Symondys, Thomas, of Trunche, husbandman 0
5580734 2529054 2529054 defendant Hornyngtoft Robert (legal representative) 601723 601723 Hornyngtoft, Robert, of Trunche, husbandman, executor of Hornyngtoft, John, of Trunche, yeoman, executors of 0
5580735 2529054 2529054 defendant Newton William husbandman 601723 601723 (Newton, William, of Trunche, husbandman 1
5588727 2531486 2531486 defendant Symondys Thomas yeoman 601723 601723 Symondys, Thomas, of Trunche, yeoman 0
5588730 2531487 2531487 defendant Symondys Thomas yeoman 601723 601723 Symondys, Thomas, of Trunche, yeoman 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);