names

91 rows where place_id = 589669

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598370 1867120 1867120 defendant Velour Joan widow 589669 589669 Velour, Joan, of Bathe, Soms, widow 3
3617027 1872947 1872947 defendant Ricard Roger goldsmith 589669 589669 Ricard, Roger, of Bathe, Soms, goldsmith 1
3617030 1872948 1872948 defendant Rycard Roger husbandman 589669 589669 Rycard, Roger, of Bathe, Soms, husbandman 1
3624071 1875059 1875059 defendant Mylton William butcher 589669 589669 Mylton, William, of Bathe, Soms, butcher 0
3702423 1927017 1927017 defendant Wode Grace widow 589669 589669 Wode, Grace, of Bathe, Soms, widow 0
3715319 1931075 1931075 defendant Sydnam John clothman 589669 589669 Sydnam, John, of Bathe, Soms, clothman 2
3779704 1951384 1951384 defendant Vyntre Robert clothier 589669 589669 Vyntre, Robert, of Bathe, Soms, clothier 0
3783082 1952466 1952466 defendant Chepman William clothier 589669 589669 Chepman, William, of Bathe, Soms, clothier 0
3791819 1955289 1955289 defendant Mydelton John chapman 589669 589669 Mydelton, John, of Bathe, Soms, chapman 0
3791824 1955290 1955290 defendant Mydelton John chapman 589669 589669 Mydelton, John, of Bathe, Soms, chapman 0
3852101 1974253 1974253 defendant Bell William gent 589669 589669 Bell, William, of Bathe, Soms, gent 0
3919872 1996979 1996979 defendant Blakdon Hugh clothier 589669 589669 Blakdon, Hugh, of Bathe, Soms, clothier 0
3919874 1996980 1996980 defendant Blakdon Hugh clothier 589669 589669 Blakdon, Hugh, of Bathe, Soms, clothier 0
3945021 2005352 2005352 defendant Cavell William gent 589669 589669 Cavell, William, of Bathe, Soms, gent 0
3967767 2013357 2013357 defendant Cavell William gent 589669 589669 Cavell, William, of Bathe, Soms, gent 1
3980274 2017711 2017711 defendant Chapman Henry capper 589669 589669 Chapman, Henry, of Bathe, Soms, capper 0
4019512 2031708 2031708 defendant Chapman Richard alderman 589669 589669 Chapman, Richard, of Bathe, Soms, alderman 0
4166420 2083756 2083756 defendant Bushe Thomas gent 589669 589669 Bushe, Thomas, of Bathe, Soms, gent 0
4181606 2089052 2089052 defendant Pearman George gent 589669 589669 Pearman, George, of Bathe, Soms, gent 0
4192416 2092902 2092902 defendant Whyppinge alias Whybbyns William butcher 589669 589669 Whyppinge alias Whybbyns, William, of Bathe, Soms, butcher 0
4293441 2127717 2127717 defendant Chambers Robert gent 589669 589669 Chambers, Robert, of Bathe, Soms, gent 4
4320395 2137233 2137233 defendant Sherwood   gent 589669 589669 Sherwood, , of Bathe, Soms, gent 1
4472937 2192209 2192209 defendant Bath William   589669 589669 Bath, William, of Bathe, Soms 0
4651091 2246341 2246341 defendant Withycombe Richard smith 589669 589669 Withycombe, Richard, of Bathe, Soms, smith 0
4651094 2246342 2246342 defendant Wythycombe Richard smith 589669 589669 Wythycombe, Richard, of Bathe, Soms, smith 0
4683564 2260463 2260463 defendant Baret Thomas chapman 589669 589669 Baret, Thomas, of Bathe, Soms, chapman 0
4688903 2262084 2262084 defendant Tyler John tiler 589669 589669 Tyler, John, of Bathe, Soms, tiler 1
4733720 2275727 2275727 defendant Lange John draper 589669 589669 Lange, John, of Bathe, Soms, draper 0
4739817 2277529 2277529 defendant Stanfery Thomas chapman 589669 589669 Stanfery, Thomas, of Bathe, Soms, chapman 2
4785947 2291642 2291642 defendant Aylemer Thomas ticker 589669 589669 Aylemer, Thomas, of Bathe, Soms, ticker 0
4787085 2292022 2292022 defendant Eyton John husbandman 589669 589669 Eyton, John, of Bathe, Soms, husbandman 0
4821761 2302883 2302883 defendant Wutton William fuller 589669 589669 Wutton, William, of Bathe, Soms, fuller 1
4823267 2303367 2303367 defendant Staynour Robert husbandman 589669 589669 Staynour, Robert, of Bathe, Soms, husbandman 0
4860024 2314505 2314505 defendant Chaundeler Simon   589669 589669 Chaundeler, Simon, of Bathe, Soms, wax chandler 1
4873173 2318559 2318559 defendant Dode Richard weaver 589669 589669 Dode, Richard, of Bathe, Soms, weaver 4
4879952 2320644 2320644 defendant Hayne John weaver 589669 589669 Hayne, John, of Bathe, Soms, weaver 1
4880830 2320912 2320912 defendant Thyston Henry chapman 589669 589669 Thyston, Henry, of Bathe, Soms, chapman 0
4886302 2322576 2322576 defendant Gonewyn Robert husbandman 589669 589669 Gonewyn, Robert, of Bathe, Soms, husbandman 0
4891213 2323985 2323985 defendant Cotes John chapman 589669 589669 Cotes, John, of Bathe, Soms, chapman 0
4893984 2324820 2324820 defendant Heynes John weaver 589669 589669 Heynes, John, of Bathe, Soms, weaver 0
4902088 2327260 2327260 defendant Perkyns John tucker 589669 589669 Perkyns, John, of Bathe, Soms, tucker 0
4912768 2330494 2330494 plaintiff Palfrayman Thomas   589669 589669 Palfrayman, Thomas, of Bathe, Soms, servant 5
4914808 2331145 2331145 defendant Cotys John chapman 589669 589669 Cotys, John, of Bathe, Soms, chapman 0
4952085 2342590 2342590 defendant Fyssher John carpenter 589669 589669 Fyssher, John, of Bathe, Soms, carpenter 0
4965866 2346720 2346720 defendant Webbe Thomas chaplain 589669 589669 Webbe, Thomas, of Bathe, Soms, chaplain 2
5004123 2358094 2358094 defendant Abyndon William   589669 589669 Abyndon, William, of Bathe, Soms, cloth maker 1
5029484 2365495 2365495 defendant Pewe William pewterer 589669 589669 Pewe, William, of Bathe, Soms, pewterer 1
5029515 2365502 2365502 defendant Cotes John chapman 589669 589669 Cotes, John, of Bathe, Soms, chapman 1
5029519 2365503 2365503 defendant Cotes John chapman 589669 589669 Cotes, John, of Bathe, Soms, chapman 1
5031007 2365946 2365946 defendant Flechere John carpenter 589669 589669 Flechere, John, of Bathe, Soms, carpenter 2
5038147 2368044 2368044 defendant Saundrys Thomas weaver 589669 589669 Saundrys, Thomas, of Bathe, Soms, weaver 1
5045195 2370193 2370193 defendant Radisshe Ralph draper 589669 589669 Radisshe, Ralph, of Bathe, Soms, draper 3
5065975 2376347 2376347 defendant Haynes William merchant 589669 589669 Haynes, William, of Bathe, Soms, merchant 1
5065980 2376348 2376348 defendant Haynes William merchant 589669 589669 Haynes, William, of Bathe, Soms, merchant 1
5081183 2380877 2380877 defendant Haynes Roger dyer 589669 589669 Haynes, Roger, of Bathe, Soms, dyer 0
5091814 2383989 2383989 defendant Stanbroke alias Haynes Roger weaver 589669 589669 Stanbroke alias Haynes, Roger, of Bathe, Soms, weaver 0
5101044 2386718 2386718 defendant Abyndon William clothier or weaver 589669 589669 Abyndon, William, of Bathe, Soms, clothier or weaver 1
5111986 2389893 2389893 defendant Mowentayne John hosteler 589669 589669 Mowentayne, John, of Bathe, Soms, hosteler 0
5117396 2391520 2391520 defendant Abyndon William clothmaker 589669 589669 Abyndon, William, of Bathe, Soms, clothmaker 2
5185452 2411490 2411490 defendant Mounteyne John ostler 589669 589669 Mounteyne, John, of Bathe, Soms, ostler 1
5213006 2419542 2419542 defendant Voobe John clerk 589669 589669 Voobe, John, of Bathe, Soms, clerk 0
5217899 2420967 2420967 defendant Balle Robert yeoman 589669 589669 Balle, Robert, of Bathe, Soms, yeoman 0
5232931 2425215 2425215 defendant Bryce Nicholas osteler 589669 589669 Bryce, Nicholas, of Bathe, Soms, osteler 1
5242109 2427892 2427892 defendant Velour John chapman 589669 589669 Velour, John, of Bathe, Soms, chapman 1
5242119 2427896 2427896 defendant Velour John chapman 589669 589669 Velour, John, of Bathe, Soms, chapman 1
5293853 2443169 2443169 defendant Walter William chapman 589669 589669 Walter, William, of Bathe, Soms, chapman 0
5312060 2448637 2448637 defendant Stanborugh William clothier 589669 589669 Stanborugh, William, of Bathe, Soms, clothier 3
5358153 2462611 2462611 defendant Baten Robert clothman 589669 589669 Baten, Robert, of Bathe, Soms, clothman 3
5358160 2462612 2462612 defendant Baten Robert clothman 589669 589669 Baten, Robert, of Bathe, Soms, clothman 2
5432570 2484712 2484712 defendant Haynes William clothier 589669 589669 (Haynes, William, of Bathe, Soms, clothier 1
5483857 2500115 2500115 defendant Irlond Edward gent 589669 589669 Irlond, Edward, of Bathe, soms, gent 4
5485938 2500686 2500686 defendant Bele Thomas yeoman 589669 589669 Bele, Thomas, of Bathe, Soms, yeoman 0
5507177 2507150 2507150 defendant Slogge John, senior baker 589669 589669 Slogge, John, senior, of Bathe, Soms, baker 1
5516239 2509915 2509915 defendant Clerke John yeoman of the chamber 589669 589669 Clerke, John, of Bathe, Soms, yeoman of the chamber 0
5516241 2509916 2509916 defendant Clerke John yeoman of the chamber 589669 589669 Clerke, John, of Bathe, Soms, yeoman of the chamber 0
5521131 2511423 2511423 defendant Melton William butcher 589669 589669 Melton, William, of Bathe, Soms, butcher 2
5527774 2513261 2513261 defendant Tyler William clothmaker 589669 589669 Tyler, William, of Bathe, Soms, clothmaker 0
5527780 2513262 2513262 defendant Tyler William clothman 589669 589669 Tyler, William, of Bathe, Soms, clothman 0
5565527 2524514 2524514 defendant Coffyn John clothman 589669 589669 Coffyn, John, of Bathe, Soms, clothman 2
5567547 2525081 2525081 defendant Bette Lewis clothier 589669 589669 Bette, Lewis, of Bathe, Soms, clothier 0
5567549 2525082 2525082 defendant Bene Lewis clothier 589669 589669 Bene, Lewis, of Bathe, Soms, clothier 0
5570667 2525980 2525980 defendant Bettes Lewis chapman 589669 589669 Bettes, Lewis, of Bathe, Soms, chapman 1
5570673 2525981 2525981 defendant Cossyn of Coffyn John chapman 589669 589669 Cossyn of Coffyn, John, of Bathe, Soms, chapman 1
5573262 2526734 2526734 defendant Coffyn John clothier 589669 589669 Coffyn, John, of Bathe, Soms, clothier 0
5576358 2527659 2527659 defendant Coffyn John clothman 589669 589669 Coffyn, John, of Bathe, Soms, clothman 2
5592602 2532678 2532678 defendant Stayner John clothmaker 589669 589669 Stayner, John, of Bathe, Soms, clothmaker 0
5596103 2533696 2533696 defendant Tyler William clothier 589669 589669 Tyler, William, of Bathe, Soms, clothier 0
5630003 2553385 2553385 defendant Stanfery or Stansery Thomas mercer 589669 589669 Stanfery or Stansery, Thomas, of Bathe, Soms, mercer 0
5632336 2554144 2554144 defendant Oxenford William eeaver 589669 589669 Oxenford, William, of Bathe, Soms, eeaver 0
5632856 2554283 2554283 defendant Whitokesmede John dyer 589669 589669 Whitokesmede, John, of Bathe, Soms, dyer 1
5632890 2554293 2554293 defendant Wytokesmede John dyer 589669 589669 Wytokesmede, John, of Bathe, Soms, dyer 2

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