names

133 rows where place_id = 592868

✎ 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
3609203 1870540 1870540 defendant Walys John husbandman 592868 592868 Walys, John, of Mertok, husbandman 0
3639144 1907061 1907061 defendant Otys Thomas baker 592868 592868 Otys, Thomas, of Mertok, baker 1
3639703 1907226 1907226 defendant Gobyn William tailor 592868 592868 Gobyn, William, of Mertok, tailor 0
3644774 1908771 1908771 defendant Waleys John husbandman 592868 592868 Waleys, John, of Mertok, husbandman 0
3695934 1924967 1924967 defendant Walles John husbandman 592868 592868 Walles, John, of Mertok, husbandman 3
3741462 1939198 1939198 defendant Hychyn John husbandman 592868 592868 Hychyn, John, of Mertok, husbandman 1
4441338 2182227 2182227 defendant Lovegay John   592868 592868 Lovegay, John, of Mertok 0
4445455 2183533 2183533 defendant Bovy Richard   592868 592868 Bovy, Richard, of Mertok 0
4455081 2186591 2186591 defendant Curteys Robert   592868 592868 Curteys, Robert, of Mertok 0
4455091 2186592 2186592 defendant Curteys Robert   592868 592868 Curteys, Robert, of Mertok 0
4500691 2200832 2200832 defendant Baker John   592868 592868 Baker, John, of mertok 2
4503987 2201804 2201804 defendant Stacy John   592868 592868 Stacy, John, of Mertok 0
4549926 2215910 2215910 defendant Tacy John   592868 592868 Tacy, John, of Mertok 0
4555382 2217618 2217618 defendant Carleton William   592868 592868 Carleton, William, of Mertok 0
4555383 2217618 2217618 defendant Lymburgh John   592868 592868 Lymburgh, John, of Mertok 1
4556359 2217929 2217929 defendant Brome John   592868 592868 Brome, John, of Mertok 3
4558392 2218571 2218571 defendant Geffrey Robert   592868 592868 Geffrey, Robert, of Mertok 0
4558394 2218571 2218571 defendant Geffrey Walter   592868 592868 Geffrey, Walter, of Mertok 2
4558395 2218571 2218571 defendant Gele Robert   592868 592868 Gele, Robert, of Mertok 3
4558396 2218571 2218571 defendant Haukyn Richard   592868 592868 Haukyn, Richard, of Mertok 4
4558397 2218571 2218571 defendant Bruere John   592868 592868 Bruere, John, of Mertok 5
4560208 2219141 2219141 defendant Agasse John   592868 592868 Agasse, John, of Mertok 0
4575356 2223805 2223805 defendant Frount John   592868 592868 Frount, John, of Mertok 4
4581358 2225636 2225636 defendant Curteys Robert   592868 592868 Curteys, Robert, of Mertok 0
4589676 2228139 2228139 defendant Curteys Robert   592868 592868 Curteys, Robert, of Mertok 2
4608582 2233789 2233789 defendant Jones John   592868 592868 Jones, John, of Mertok 1
4608583 2233789 2233789 defendant Thacchere William   592868 592868 Thacchere, William, of Mertok 2
4608584 2233789 2233789 defendant Carleton Robert   592868 592868 Carleton, Robert, of Mertok 3
4608585 2233789 2233789 defendant Wylle John   592868 592868 Wylle, John, of Mertok 4
4608586 2233789 2233789 defendant Gele Robert   592868 592868 Gele, Robert, of Mertok 5
4608588 2233789 2233789 defendant Yorke John   592868 592868 Yorke, John, of Mertok 7
4613143 2235169 2235169 defendant Horne Thomas   592868 592868 Horne, Thomas, of Mertok 0
4627481 2239527 2239527 defendant Glovere Richard   592868 592868 Glovere, Richard, of Mertok 0
4627518 2239538 2239538 defendant Horn Thomas   592868 592868 Horn, Thomas, of Mertok 0
4651272 2246404 2246404 defendant Curteys Robert hosteler 592868 592868 Curteys, Robert, of Mertok, hosteler 0
4651877 2246523 2246523 defendant Laver Walter (legal representative) 592868 592868 Laver, Walter, of Mertok, executors of 3
4654090 2247161 2247161 defendant Lymburg Thomas tailor 592868 592868 Lymburg, Thomas, of Mertok, tailor 1
4654091 2247161 2247161 defendant Lymburgh John tailor 592868 592868 Lymburgh, John, of Mertok, tailor 2
4657724 2248302 2248302 defendant Curteys William hosteler 592868 592868 Curteys, William, of Mertok, hosteler 0
4662886 2249855 2249855 defendant Andrewe Thomas husbandman 592868 592868 Andrewe, Thomas, of Mertok, husbandman 0
4664010 2250230 2250230 defendant Carleton Robert husbandman 592868 592868 Carleton, Robert, of Mertok, husbandman 0
4668586 2255883 2255883 defendant Wabysshe Robert husbandman 592868 592868 Wabysshe, Robert, of Mertok, husbandman 5
4668587 2255883 2255883 defendant Lane Joan widow 592868 592868 Lane, Joan, of Mertok, widow 6
4670328 2256424 2256424 defendant Dolyng Willliam laborer 592868 592868 Dolyng, Willliam, of Mertok, laborer 3
4670347 2256426 2256426 defendant Dollyng William laborer 592868 592868 Dollyng, William, of Mertok, laborer 3
4670361 2256428 2256428 defendant Shepherd William husbandman 592868 592868 Shepherd, William, of Mertok, husbandman 0
4670362 2256428 2256428 defendant Bysshop John, senior baker 592868 592868 Bysshop, John, senior, of Mertok, baker 1
4670396 2256432 2256432 defendant Ponfold Richard husbandman 592868 592868 Ponfold, Richard, of Mertok, husbandman 2
4673861 2257443 2257443 defendant Coke Thomas   592868 592868 Coke, Thomas, of Mertok, apothecary 2
4686116 2261249 2261249 defendant Russheton William   592868 592868 Russheton, William, of Mertok, franklin 0
4689741 2262354 2262354 defendant Wydecombe Thomas gent 592868 592868 Wydecombe, Thomas, of Mertok, gent 1
4734384 2275923 2275923 defendant Lymburgh John tailor 592868 592868 Lymburgh, John, of Mertok, tailor 3
4761508 2283943 2283943 defendant Ousy William dyer 592868 592868 Ousy, William, of Mertok, dyer 0
4785870 2291613 2291613 defendant Onsy or Ousy William dyer 592868 592868 Onsy or Ousy, William, of Mertok, dyer 0
4787310 2292101 2292101 defendant Osy William dyer 592868 592868 Osy, William, of Mertok, dyer 0
4787709 2292225 2292225 defendant Houchyns John draper 592868 592868 Houchyns, John, of Mertok, draper 0
4787710 2292225 2292225 defendant Wille Thomas yeoman 592868 592868 Wille, Thomas, of Mertok, yeoman 1
4793967 2294242 2294242 defendant Lymburgh John husbandman 592868 592868 Lymburgh, John, of Mertok, husbandman 1
4813057 2300199 2300199 defendant Bonde William husbandman 592868 592868 Bonde, William, of Mertok, husbandman 1
4830427 2305551 2305551 defendant Prous or Prons William dyer 592868 592868 Prous or Prons, William, of Mertok, dyer 0
4857390 2313700 2313700 defendant Denbaude William fisher 592868 592868 Denbaude, William, of Mertok, fisher 0
4858828 2314138 2314138 defendant Foxdyche Henry husbandman 592868 592868 Foxdyche, Henry, of Mertok, husbandman 0
4859428 2314326 2314326 defendant Prouns William dyer 592868 592868 Prouns, William, of Mertok, dyer 2
4859429 2314326 2314326 defendant Thomelyn John husbandman 592868 592868 Thomelyn, John, of Mertok, husbandman 3
4864499 2315869 2315869 defendant Prouse William tucker 592868 592868 Prouse, William, of Mertok, tucker 0
4869450 2317414 2317414 defendant Dollyng William husbandman 592868 592868 Dollyng, William, of Mertok, husbandman 0
4900754 2326873 2326873 defendant Leye John husbandman 592868 592868 Leye, John, of Mertok, husbandman 1
4946171 2340786 2340786 defendant Patewyn John husbandman 592868 592868 Patewyn, John, of Mertok, husbandman 3
4947936 2341342 2341342 defendant Patewyn Robert husbandman 592868 592868 Patewyn, Robert, of Mertok, husbandman 1
4970406 2348094 2348094 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 1
4986485 2352886 2352886 defendant Taillour John, sen husbandman 592868 592868 Taillour, John, sen, of Mertok, husbandman 1
5013236 2360704 2360704 defendant Vicarys John husbandman 592868 592868 Vicarys, John, of Mertok, husbandman 0
5017013 2361869 2361869 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5029480 2365494 2365494 defendant Hunte Thomas chapman 592868 592868 Hunte, Thomas, of Mertok, chapman 3
5030182 2365696 2365696 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5030187 2365698 2365698 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 1
5030190 2365699 2365699 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5054646 2372967 2372967 defendant Axe Richard husbandman 592868 592868 Axe, Richard, of Mertok, husbandman 0
5067876 2376891 2376891 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5072866 2378369 2378369 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5080744 2380732 2380732 defendant Colyns John tailor 592868 592868 Colyns, John, of Mertok, tailor 3
5102854 2387253 2387253 defendant Perkyn William mercer 592868 592868 Perkyn, William, of Mertok, mercer 0
5102855 2387253 2387253 defendant Patewyn John husbandman 592868 592868 Patewyn, John, of Mertok, husbandman 1
5102856 2387253 2387253 defendant Borde John   592868 592868 Borde, John, of Mertok, laborer, single man 2
5114726 2390721 2390721 defendant Helyer Thomas tucker 592868 592868 Helyer, Thomas, of Mertok, tucker 0
5119593 2392164 2392164 defendant Geffrey Thomas   592868 592868 Geffrey, Thomas, of Mertok 0
5155760 2402846 2402846 defendant Bernard John   592868 592868 Bernard, John, of Mertok, parson of the church 0
5157491 2403322 2403322 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 1
5178354 2409376 2409376 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5212385 2419365 2419365 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 1
5220810 2421778 2421778 defendant Chamber William tailor 592868 592868 Chamber, William, of Mertok, tailor 0
5222675 2422348 2422348 defendant Beld John, senior husbandman 592868 592868 Beld, John, senior, of Mertok, husbandman 2
5222676 2422348 2422348 defendant Beld John, junior husbandman 592868 592868 Beld, John, junior, of Mertok, husbandman 3
5226372 2423383 2423383 defendant Shene John tyler 592868 592868 Shene, John, of Mertok, tyler 4
5230889 2424642 2424642 defendant Brystowe John fisher 592868 592868 Brystowe, John, of Mertok, fisher 0
5239471 2427126 2427126 defendant Daunce Thomas gent 592868 592868 Daunce, Thomas, of Mertok, gent 0
5254060 2431390 2431390 defendant Canynges Thomas husbandman 592868 592868 Canynges, Thomas, of Mertok, husbandman 0
5254061 2431390 2431390 defendant Bonde John husbandman 592868 592868 Bonde, John, of Mertok, husbandman 1
5258138 2432664 2432664 defendant Belde John, senior gent 592868 592868 Belde, John, senior, of Mertok, gent 0
5258139 2432664 2432664 defendant Belde John, junior gent 592868 592868 Belde, John, junior, of Mertok, gent 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);