names

56 rows where place_id = 603682

✎ 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
3655383 1911943 1911943 defendant Stuppeny Richard, junior yeoman 603682 603682 Stuppeny, Richard, junior, of Romney, yeoman 1
3722694 1933364 1933364 defendant Stuppeny Richard yeoman 603682 603682 Stuppeny, Richard, of Romney, yeoman 0
3755613 1943714 1943714 defendant Kyrkland Leonard husbandman 603682 603682 Kyrkland, Leonard, of Romney, husbandman 0
3773586 1949451 1949451 defendant Kyrkland Lawrence husbandman 603682 603682 Kyrkland, Lawrence, of Romney, husbandman 0
3807732 1960306 1960306 defendant Stopeney Richard yeoman 603682 603682 Stopeney, Richard, of Romney, yeoman 0
4223156 2103588 2103588 defendant Joell Henry yeoman 603682 603682 Joell, Henry, of Romney, yeoman 1
4466392 2190154 2190154 plaintiff Adam Stephen   603682 603682 Adam, Stephen, of Romney 0
4474667 2192739 2192739 defendant Spycer John   603682 603682 Spycer, John, of Romney 4
4479583 2194276 2194276 plaintiff Ive John   603682 603682 Ive, John, of Romney 0
4481422 2194882 2194882 plaintiff Lucas John (legal representative) 603682 603682 Lucas, John, of Romney, executrix of 0
4521791 2207149 2207149 defendant Smyth Henry (legal representative) 603682 603682 Smyth, Henry, of Romney, administrator of 0
4530392 2209795 2209795 defendant atte Crouche William   603682 603682 atte Crouche, William, of Romney 0
4535093 2211257 2211257 plaintiff Sherte John   603682 603682 Sherte, John, of Romney 0
4549148 2215671 2215671 defendant Chanewe William   603682 603682 Chanewe, William, of Romney 1
4560808 2219337 2219337 plaintiff Oby Nicholas clerk 603682 603682 Oby, Nicholas, of Romney, clerk 0
4586044 2227058 2227058 defendant Lauryn Lawrence   603682 603682 Lauryn, Lawrence, of Romney 0
4590866 2228493 2228493 defendant Couper John spicer 603682 603682 Couper, John, of Romney, spicer 2
4640851 2243424 2243424 defendant Couper John spicer 603682 603682 Couper, John, of Romney, spicer 0
4647932 2245464 2245464 plaintiff Turnour John   603682 603682 Turnour, John, of Romney 1
4669059 2256028 2256028 defendant Gregory William repier 603682 603682 Gregory, William, of Romney, repier 3
4681444 2259814 2259814 defendant Sherte John gent 603682 603682 Sherte, John, of Romney, gent 6
4685022 2260913 2260913 plaintiff Robesle Thomas   603682 603682 Robesle, Thomas, of Romney 0
4691675 2262929 2262929 defendant Noble William carter 603682 603682 Noble, William, of Romney, carter 0
4691676 2262929 2262929 defendant Courthose John carter 603682 603682 Courthose, John, of Romney, carter 1
4691677 2262929 2262929 defendant Cristofre Robert laborer 603682 603682 Cristofre, Robert, of Romney, laborer 2
4705800 2267185 2267185 defendant Gillyng John   603682 603682 Gillyng, John, of Romney, administrators of 5
4711431 2268904 2268904 defendant Holyngbroke William gent 603682 603682 Holyngbroke, William, of Romney, gent 0
4711437 2268905 2268905 defendant Mersshere Robert   603682 603682 Mersshere, Robert, of Romney, teghelere or tile maker 0
4711865 2269041 2269041 defendant Goldhord John laborer 603682 603682 Goldhord, John, of Romney, laborer 0
4712654 2269273 2269273 defendant Fenell Robert draper 603682 603682 Fenell, Robert, of Romney, draper 4
4738589 2277158 2277158 defendant Borghersyle Thomas   603682 603682 Borghersyle, Thomas, of Romney 0
4749272 2280268 2280268 defendant Adam John gent 603682 603682 Adam, John, of Romney, gent 0
4754810 2281884 2281884 defendant Horne John hosteller 603682 603682 Horne, John, of Romney, hosteller 0
4756036 2282270 2282270 defendant Brokelond Edmund   603682 603682 Brokelond, Edmund, of Romney, inland fish seller 0
4756037 2282270 2282270 defendant Peres John tailor 603682 603682 Peres, John, of Romney, tailor 1
4756038 2282270 2282270 defendant Hervystoke Walter tailor 603682 603682 Hervystoke, Walter, of Romney, tailor 2
4756039 2282270 2282270 defendant Skynner Richard skinner 603682 603682 Skynner, Richard, of Romney, skinner 3
4756041 2282270 2282270 defendant Baghden John   603682 603682 Baghden, John, of Romney, ship wright 5
4759737 2283389 2283389 plaintiff Clyderowe Richard   603682 603682 Clyderowe, Richard, of Romney 6
4765673 2285257 2285257 defendant Poudere John butcher 603682 603682 Poudere, John, of Romney, butcher 0
4781884 2290349 2290349 plaintiff Cliderowe Richard   603682 603682 Cliderowe, Richard, of Romney 6
4781892 2290350 2290350 plaintiff Cliderowe Richard   603682 603682 Cliderowe, Richard, of Romney 6
4806014 2298091 2298091 plaintiff Bykendon John   603682 603682 Bykendon, John, of Romney, shipwright, on his own account 0
5025916 2364473 2364473 defendant Tolkyn Thomas laborer 603682 603682 Tolkyn, Thomas, of Romney, laborer 5
5133863 2396398 2396398 defendant Joseph John yeoman 603682 603682 Joseph, John, of Romney, yeoman 0
5136674 2397250 2397250 plaintiff Page John   603682 603682 Page, John, of Romney 0
5153917 2402303 2402303 defendant Joseph John gent 603682 603682 Joseph, John, of Romney, gent 0
5171028 2407250 2407250 defendant Joseph John gent 603682 603682 Joseph, John, of Romney, gent 0
5206436 2417613 2417613 defendant Hoode William laborer 603682 603682 Hoode, William, of Romney, laborer 2
5357629 2462457 2462457 defendant Baker Stephen yeoman 603682 603682 Baker, Stephen, of Romney, yeoman 0
5357631 2462458 2462458 defendant Baker Stephen yeoman 603682 603682 Baker, Stephen, of Romney, yeoman 0
5364648 2464603 2464603 defendant Usbarn Thomas yeoman 603682 603682 Usbarn, Thomas, of Romney, yeoman 0
5452081 2490504 2490504 defendant Sydley Thomas draper 603682 603682 Sydley, Thomas, of Romney, draper 1
5475595 2497699 2497699 defendant Sydley Thomas draper 603682 603682 Sydley, Thomas, of Romney, draper 0
5627092 2552440 2552440 defendant Fenell Robert   603682 603682 Fenell, Robert, of Romney 0
5627093 2552440 2552440 defendant Galewey Richard   603682 603682 Galewey, Richard, of Romney 1

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