names

168 rows where place_id = 592999

✎ 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
3609894 1870765 1870765 defendant Clerk John gent 592999 592999 Clerk, John, of Merton, gent 0
3664590 1914879 1914879 plaintiff (not given) William prior of Salynge 592999 592999 (Salynge, William, of Merton, prior of St Mary's Priory, 'an unsatisfactory character who incurred episcopal anger for laziness and immorality' 1
3734531 1937046 1937046 defendant Lancaster John yeoman 592999 592999 Lancaster, John, of Merton, yeoman 1
3820301 1964223 1964223 defendant Clyff John husbandman 592999 592999 Clyff, John, of Merton, husbandman 0
3846675 1972516 1972516 defendant Bradman John husbandman 592999 592999 Bradman, John, of Merton, husbandman 1
3846677 1972516 1972516 defendant Spurford Robert husbandman 592999 592999 Spurford, Robert, of Merton, husbandman 3
3871735 1980783 1980783 defendant Dekyn Roger husbandman 592999 592999 Dekyn, Roger, of Merton, husbandman 4
3973180 2015190 2015190 plaintiff Gray Thomas (legal representative) 592999 592999 Gray, Thomas, of Merton, clerk, executors of 0
4022245 2032682 2032682 defendant ap Ithell Thomas ap Rys yeoman 592999 592999 ap Ithell, Thomas ap Rys, of Merton, yeoman 1
4022246 2032682 2032682 defendant ap Ithell Hugh ap Rys yeoman 592999 592999 ap Ithell, Hugh ap Rys, of Merton, yeoman 2
4022250 2032683 2032683 defendant ap Ithell Thomas ap Rys yeoman 592999 592999 ap Ithell, Thomas ap Rys, of Merton, yeoman 1
4022251 2032683 2032683 defendant ap Ithell Hugh ap Rys yeoman 592999 592999 ap Ithell, Hugh ap Rys, of Merton, yeoman 2
4041402 2039418 2039418 plaintiff Nettleton John gent 592999 592999 Nettleton, John, of Merton, gent 0
4193126 2093163 2093163 defendant Hancok Thomas yeoman 592999 592999 Hancok, Thomas, of Merton, yeoman 1
4387916 2160589 2160589 defendant Mallory William gent 592999 592999 Mallory, William, of Merton, gent 2
4440861 2182056 2182056 defendant Huet John   592999 592999 Huet, John, of Merton 0
4441339 2182228 2182228 plaintiff Bonkyn John   592999 592999 Bonkyn, John, of Merton, parson 0
4441527 2182289 2182289 plaintiff Boukyn John   592999 592999 Boukyn, John, of Merton, parson 0
4455226 2186641 2186641 defendant Hadenham John   592999 592999 Hadenham, John, of Merton 0
4460455 2188335 2188335 defendant Osteler John   592999 592999 Osteler, John, of Merton 2
4462690 2189030 2189030 defendant Hadenham John   592999 592999 Hadenham, John, of Merton 1
4472850 2192184 2192184 defendant Dene Walter   592999 592999 Dene, Walter, of Merton 0
4485569 2196193 2196193 defendant Lovel Robert   592999 592999 Lovel, Robert, of Merton 0
4485570 2196193 2196193 defendant Fyldeforme John   592999 592999 Fyldeforme, John, of Merton 1
4512414 2204326 2204326 defendant Helyar Nicholas   592999 592999 Helyar, Nicholas, of Merton 1
4515756 2205356 2205356 defendant Heyward William   592999 592999 Heyward, William, of Merton 0
4518452 2206142 2206142 defendant atte Hacche Henry   592999 592999 atte Hacche, Henry, of Merton 3
4522441 2207358 2207358 plaintiff Grene John   592999 592999 Grene, John, of Merton 0
4538198 2212233 2212233 defendant Walker Joan   592999 592999 Walker, Joan, of Merton 2
4539294 2212547 2212547 plaintiff Wace William   592999 592999 Wace, William, of Merton 0
4555498 2217651 2217651 defendant Badkok Henry   592999 592999 Badkok, Henry, of Merton 0
4562372 2219791 2219791 defendant Rycher John, sen   592999 592999 Rycher, John, sen, of Merton 0
4563782 2220242 2220242 defendant Walker John   592999 592999 Walker, John, of Merton 1
4577066 2224338 2224338 plaintiff Byllyngey John   592999 592999 Byllyngey, John, of Merton 0
4596507 2230148 2230148 defendant atte Beare Roger   592999 592999 atte Beare, Roger, of Merton 0
4602374 2231959 2231959 defendant Talyour Henry   592999 592999 Talyour, Henry, of Merton 0
4628261 2239765 2239765 defendant Langden John   592999 592999 Langden, John, of Merton 2
4630365 2240404 2240404 defendant Tronell John   592999 592999 Tronell, John, of Merton 1
4636033 2242101 2242101 defendant Gate William   592999 592999 Gate, William, of Merton 0
4639729 2243131 2243131 defendant Childe Lawrence   592999 592999 Childe, Lawrence, of Merton 2
4641127 2243496 2243496 defendant Child Lawrence   592999 592999 Child, Lawrence, of Merton 0
4641740 2243681 2243681 defendant Algor alias Salyng John clerk & vicar 592999 592999 Algor alias Salyng, John, of Merton, clerk & vicar 0
4647265 2245255 2245255 defendant Langden John   592999 592999 Langden, John, of Merton 0
4648954 2245746 2245746 defendant Walker John   592999 592999 Walker, John, of Merton 1
4680992 2259680 2259680 defendant Walse John husbandman 592999 592999 Walse, John, of Merton, husbandman 2
4681643 2259871 2259871 plaintiff Bale John   592999 592999 (Bale, John, of Merton, parson 1
4682825 2260245 2260245 defendant Treve William   592999 592999 Treve, William, of Merton, vicar 0
4682826 2260245 2260245 defendant Base William   592999 592999 Base, William, of Merton 1
4701141 2265763 2265763 defendant Childe Laurence ostler 592999 592999 Childe, Laurence, of Merton, ostler 3
4708616 2268070 2268070 defendant Trene William clerk 592999 592999 Trene, William, of Merton, clerk 0
4708617 2268070 2268070 defendant Kyng Richard husbandman 592999 592999 Kyng, Richard, of Merton, husbandman 1
4708618 2268070 2268070 defendant Brayn Henry husbandman 592999 592999 Brayn, Henry, of Merton, husbandman 2
4708619 2268070 2268070 defendant Basy William husbandman 592999 592999 Basy, William, of Merton, husbandman 3
4732074 2275213 2275213 defendant Trene William clerk 592999 592999 Trene, William, of Merton, clerk 0
4732075 2275213 2275213 defendant Brayn Henry husbandman 592999 592999 Brayn, Henry, of Merton, husbandman 1
4732076 2275213 2275213 defendant Basy William husbandman 592999 592999 Basy, William, of Merton, husbandman 2
4732082 2275216 2275216 defendant Trene William   592999 592999 Trene, William, of Merton, vicar 0
4732083 2275216 2275216 defendant Base William husbandman 592999 592999 Base, William, of Merton, husbandman 1
4732084 2275216 2275216 defendant Wryght Thomas   592999 592999 Wryght, Thomas, of Merton 2
4732085 2275216 2275216 defendant Bryan John, sen   592999 592999 Bryan, John, sen, of Merton 3
4735216 2276162 2276162 defendant (not given) John prior of Romney 592999 592999 Romney, John, of Merton, prior of the church of the BM 0
4740664 2277787 2277787 defendant Tuchet Richard clerk 592999 592999 Tuchet, Richard, of Merton, clerk 0
4740665 2277787 2277787 defendant Tuchet Richard yeoman 592999 592999 Tuchet, Richard, of Merton, yeoman 1
4742220 2278214 2278214 defendant Bolour Roger husbandman 592999 592999 Bolour, Roger, of merton, husbandman 1
4742221 2278214 2278214 defendant Est William husbandman 592999 592999 Est, William, of Merton, husbandman 2
4742353 2278256 2278256 defendant Waleys William husbandman 592999 592999 Waleys, William, of Merton, husbandman 0
4742828 2278410 2278410 defendant Strete John gent 592999 592999 Strete, John, of Merton, gent 0
4742839 2278414 2278414 defendant Bere Henry husbandman 592999 592999 Bere, Henry, of Merton, husbandman 0
4750448 2280614 2280614 defendant Romeney John   592999 592999 Romeney, John, of Merton, prior 0
4756983 2282554 2282554 defendant Coke John husbandman 592999 592999 Coke, John, of Merton, husbandman 0
4764585 2284910 2284910 defendant Grene John husbandman 592999 592999 Grene, John, of Merton, husbandman 1
4764586 2284910 2284910 defendant Kelyng William husbandman 592999 592999 Kelyng, William, of Merton, husbandman 2
4771000 2286909 2286909 defendant Flekke John husbandman 592999 592999 Flekke, John, of Merton, husbandman 1
4781519 2290230 2290230 defendant Strete John gent 592999 592999 Strete, John, of Merton, gent 0
4782737 2290617 2290617 defendant Malewyn Alice widow 592999 592999 Malewyn, Alice, of Merton, widow 1
4783642 2290900 2290900 defendant Balgy John esq 592999 592999 Balgy, John, of Merton, esq 0
4784810 2291257 2291257 defendant Rawelyn Thomas weaver 592999 592999 Rawelyn, Thomas, of Merton, weaver 1
4791742 2293514 2293514 defendant Byllyngey John husbandman 592999 592999 Byllyngey, John, of Merton, husbandman 1
4795300 2294682 2294682 defendant Ty Roger laborer 592999 592999 Ty, Roger, of Merton, laborer 0
4800688 2296397 2296397 defendant Chace John husbandman 592999 592999 Chace, John, of Merton, husbandman 1
4810443 2299412 2299412 defendant Lyversegge Robert gent 592999 592999 Lyversegge, Robert, of Merton, gent 0
4816395 2301222 2301222 plaintiff Lyversegge Robert gent 592999 592999 Lyversegge, Robert, of Merton, gent 0
4818235 2301781 2301781 defendant Malweyn Alice widow 592999 592999 Malweyn, Alice, of Merton, widow 0
4832404 2306169 2306169 defendant Large William   592999 592999 Large, William, of Merton, parson 1
4833691 2306545 2306545 defendant Hayton Beatrice widow 592999 592999 Hayton, Beatrice, of Merton, widow 0
4835483 2307093 2307093 defendant Overton Thomas gent 592999 592999 Overton, Thomas, of Merton, gent 0
4842091 2309060 2309060 defendant Bonssell Robert husbandman 592999 592999 Bonssell, Robert, of Merton, husbandman 0
4845225 2310018 2310018 defendant Sherefeld thoasm   592999 592999 Sherefeld, thoasm, of Merton, Bucks, prior 0
4848907 2311124 2311124 defendant Hancokes Richard husbandman 592999 592999 Hancokes, Richard, of Merton, husbandman 0
4886701 2322701 2322701 defendant Soureby Ralph yeoman 592999 592999 Soureby, Ralph, of Merton, yeoman 6
4894502 2324954 2324954 defendant Lovelas William gent 592999 592999 Lovelas, William, of Merton, gent 0
4918208 2332214 2332214 plaintiff Greye William   592999 592999 Greye, William, of Merton 0
4918959 2332444 2332444 plaintiff Hay--- Beatrice (legal representative) 592999 592999 Hay---, Beatrice, of Merton, widow, executors of 0
4918961 2332444 2332444 plaintiff Lovelas William gent 592999 592999 Lovelas, William, of Merton, gent 2
4920014 2332770 2332770 defendant Goly or Goby William husbandman 592999 592999 Goly or Goby, William, of Merton, husbandman 1
4933492 2336861 2336861 defendant Somter John, senior husbandman 592999 592999 Somter, John, senior, of Merton, husbandman 1
4933493 2336861 2336861 defendant Keletrewe Richard husbandman 592999 592999 Keletrewe, Richard, of Merton, husbandman 2
4950752 2342204 2342204 defendant Page Thomas yeoman 592999 592999 Page, Thomas, of Merton, yeoman 1
4954741 2343372 2343372 defendant Badcoke John husbandman 592999 592999 Badcoke, John, of Merton, husbandman 0
4954742 2343372 2343372 defendant Walter Henry husbandman 592999 592999 Walter, Henry, of Merton, husbandman 1

Next page

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