names

51 rows where place_id = 586594

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589132 1864246 1864246 defendant Waryn Thomas butcher 586594 586594 Waryn, Thomas, of Stratford at Bowe, Middx, butcher 0
3638279 1906791 1906791 defendant Nondys Stephen wheeler 586594 586594 Nondys, Stephen, of Stratford at Bowe, Middx, wheeler 2
3638289 1906793 1906793 defendant Noundy Stephen wheeler 586594 586594 Noundy, Stephen, of Stratford at Bowe, Middx, wheeler 2
3649559 1910250 1910250 defendant Hunte Robert carpenter 586594 586594 Hunte, Robert, of Stratford at Bowe, Middx, carpenter 0
3651668 1910881 1910881 defendant Noundy Stephen wheeler 586594 586594 Noundy, Stephen, of Stratford at Bowe, Middx, wheeler 0
3651677 1910884 1910884 defendant Nondye Stephen wheeler 586594 586594 Nondye, Stephen, of Stratford at Bowe, Middx, wheeler 0
3651682 1910885 1910885 defendant Parker George brewer 586594 586594 Parker, George, of Stratford at Bowe, Middx, brewer 2
3651688 1910886 1910886 defendant Parker George brewer 586594 586594 Parker, George, of Stratford at Bowe, Middx, brewer 2
3651694 1910887 1910887 defendant Noundy Stephen wheeler 586594 586594 Noundy, Stephen, of Stratford at Bowe, Middx, wheeler 2
3655336 1911927 1911927 defendant Chamberleyn Edward gent 586594 586594 (Chamberleyn, Edward, of Stratford at Bowe, Middx, gent 1
3655340 1911928 1911928 defendant Chamberleyn Edward gent 586594 586594 (Chamberleyn, Edward, of Stratford at Bowe, Middx, gent 1
3727340 1934825 1934825 defendant Samme Thomas baker 586594 586594 Samme, Thomas, of Stratford at Bowe, Middx, baker 0
3742997 1939658 1939658 defendant Samme Thomas baker 586594 586594 Samme, Thomas, of Stratford at Bowe, Middx, baker 0
3748887 1941587 1941587 defendant Cooke Richard gent 586594 586594 Cooke, Richard, of Stratford at Bowe, Middx, gent 1
3758269 1944581 1944581 defendant Anger or Auger William   586594 586594 Anger or Auger, William, of Stratford at Bowe, Middx, surgeon 1
3766116 1947054 1947054 defendant Depper John baker 586594 586594 Depper, John, of Stratford at Bowe, Middx, baker 0
3769951 1948258 1948258 defendant Ryse Alan gent 586594 586594 Ryse, Alan, of Stratford at Bowe, Middx, gent 1
3816372 1963029 1963029 defendant Knyght William baker 586594 586594 Knyght, William, of Stratford at Bowe, Middx, baker 1
3829799 1967212 1967212 defendant Lysley Richard gent 586594 586594 Lysley, Richard, of Stratford at Bowe, Middx, gent 0
3930862 2000661 2000661 defendant Foster Richard yeoman 586594 586594 Foster, Richard, of Stratford at Bowe, Middx, yeoman 2
3958664 2010105 2010105 plaintiff Ruddye Robert yeoman 586594 586594 Ruddye, Robert, of Stratford at Bowe, Middx, yeoman 0
3977370 2016654 2016654 defendant Bowyer John gent 586594 586594 Bowyer, John, of Stratford at Bowe, Middx, gent 1
3978121 2016925 2016925 defendant Cleyton Thomas grocer 586594 586594 Cleyton, Thomas, of Stratford at Bowe, Middx, grocer 1
4003684 2026084 2026084 defendant Harryson John yeoman 586594 586594 Harryson, John, of Stratford at Bowe, Middx, yeoman 2
4006477 2027094 2027094 defendant Harryson John yeoman 586594 586594 Harryson, John, of Stratford at Bowe, Middx, yeoman 2
4006841 2027225 2027225 defendant Poyntell Agnes widow 586594 586594 Poyntell, Agnes, of Stratford at Bowe, Middx, widow 0
4021582 2032446 2032446 defendant Garnett Richard yeoman 586594 586594 Garnett, Richard, of Stratford at Bowe, Middx, yeoman 1
4045361 2040795 2040795 defendant Threder John, senior baker 586594 586594 Threder, John, senior, of Stratford at Bowe, Middx, baker 0
4056887 2044844 2044844 defendant Snape William hackneyman 586594 586594 Snape, William, of Stratford at bowe, Middx, hackneyman 1
4061987 2046688 2046688 defendant Garnett Richard yeoman 586594 586594 Garnett, Richard, of Stratford at Bowe, Middx, yeoman 3
4117313 2066494 2066494 defendant Poyntell William, senior yeoman 586594 586594 Poyntell, William, senior, of Stratford at Bowe, Middx, yeoman 0
4134643 2072720 2072720 defendant White William gent 586594 586594 White, William, of Stratford at Bowe, Middx, gent 1
4178511 2087961 2087961 defendant Freman Henry yeoman 586594 586594 Freman, Henry, of Stratford at Bowe, Middx, yeoman 0
4201847 2096188 2096188 defendant Freman Henry yeoman 586594 586594 Freman, Henry, of Stratford at Bowe, Middx, yeoman 0
4205120 2097339 2097339 defendant Garland John yeoman 586594 586594 Garland, John, of Stratford at Bowe, Middx, yeoman 2
4252102 2113694 2113694 defendant Faunt Nicholas gent 586594 586594 Faunt, Nicholas, of Stratford at Bowe, Middx, gent 0
4252108 2113695 2113695 defendant Faunt Nicholas gent 586594 586594 Faunt, Nicholas, of Stratford at Bowe, Middx, gent 0
4352007 2147937 2147937 defendant Poyntell William goldsmith 586594 586594 Poyntell, William, of Stratford at Bowe, Middx, innholder, or of London, goldsmith 0
4354670 2148864 2148864 defendant Huetson John gent 586594 586594 Huetson, John, of Stratford at Bowe, Middx, gent 1
4354749 2148884 2148884 defendant Poyntell William innholder 586594 586594 Poyntell, William, of Stratford at Bowe, Middx, innholder 0
5278555 2438837 2438837 defendant Hegges Thomas yeoman 586594 586594 Hegges, Thomas, of Stratford at Bowe, Middx, yeoman 2
5437131 2486039 2486039 defendant Blythe William miller 586594 586594 Blythe, William, of Stratford at Bowe, Middx, miller 4
5451613 2490353 2490353 defendant Blythe William miller 586594 586594 Blythe, William, of Stratford at Bowe, Middx, miller 3
5463585 2494023 2494023 defendant Briggys John meller or miller 586594 586594 Briggys, John, of Stratford at Bowe, Middx, meller or miller 3
5475143 2497553 2497553 defendant Bryggys John miller 586594 586594 Bryggys, John, of Stratford at Bowe, Middx, miller 3
5475149 2497554 2497554 defendant Briggys John meller or miller 586594 586594 Briggys, John, of Stratford at Bowe, Middx, meller or miller 3
5525215 2512480 2512480 defendant Wardeley William yeoman 586594 586594 Wardeley, William, of Stratford at Bowe, Middx, yeoman 0
5525219 2512481 2512481 defendant Wardeley William yeoman 586594 586594 Wardeley, William, of Stratford at Bowe, Middx, yeoman 0
5545022 2518548 2518548 defendant Grene Edmund baker 586594 586594 Grene, Edmund, of Stratford at Bowe, Middx, baker 3
5604296 2536207 2536207 defendant Bote William baker 586594 586594 Bote, William, of Stratford at Bowe, Middx, baker 0
5604302 2536208 2536208 defendant Bote William baker 586594 586594 Bote, William, of Stratford at Bowe, Middx, baker 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);