names

116 rows where place_id = 589593

✎ 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
3598097 1867034 1867034 defendant Elys John yeoman 589593 589593 Elys, John, of Swyneshed, yeoman 0
3598098 1867034 1867034 defendant Carter John husbandman 589593 589593 Carter, John, of Swyneshed, husbandman 1
3598099 1867034 1867034 defendant Jaye Roger husbandman 589593 589593 Jaye, Roger, of Swyneshed, husbandman 2
3611116 1871151 1871151 defendant Ratsey John husbandman 589593 589593 Ratsey, John, of Swyneshed, husbandman 2
3619135 1873588 1873588 defendant Hunte Thomas husbandman 589593 589593 Hunte, Thomas, of Swyneshed, husbandman 0
3791540 1955193 1955193 defendant Knyght John laborer 589593 589593 Knyght, John, of Swyneshed, laborer 0
3794660 1956206 1956206 defendant Alger Richard husbandman 589593 589593 Alger, Richard, of Swyneshed, husbandman 0
3799295 1957696 1957696 defendant Halle Thomas yeoman 589593 589593 Halle, Thomas, of Swyneshed, yeoman 0
3865122 1978537 1978537 defendant Carter Richard   589593 589593 Carter, Richard, of Swyneshed, millwright 1
3907345 1992746 1992746 defendant Langstropp Martin butcher 589593 589593 Langstropp, Martin, of Swyneshed, butcher 0
3907347 1992746 1992746 defendant Carter Richard   589593 589593 Carter, Richard, of Swyneshed, millwright 2
3919407 1996821 1996821 defendant May Henry salter 589593 589593 May, Henry, of Swyneshed, salter 0
3948450 2006520 2006520 defendant Marchaunte John yeoman 589593 589593 Marchaunte, John, of Swyneshed, yeoman 0
3951879 2007718 2007718 defendant Whytlame Edward weaver 589593 589593 Whytlame, Edward, of Swyneshed, weaver 0
3963224 2011740 2011740 defendant Browen Robert laborer 589593 589593 Browen, Robert, of Swyneshed, laborer 0
4038983 2038563 2038563 plaintiff Lockton John esq 589593 589593 Lockton, John, of Swyneshed, esq 0
4038985 2038564 2038564 plaintiff Lockton John esq 589593 589593 Lockton, John, of Swyneshed, esq 0
4057820 2045181 2045181 defendant Marchaunt Thomas yeoman 589593 589593 Marchaunt, Thomas, of Swyneshed, yeoman 0
4263323 2117398 2117398 defendant Childe Henry yeoman 589593 589593 Childe, Henry, of Swyneshed, yeoman 0
4456137 2186942 2186942 defendant Bonde William   589593 589593 Bonde, William, of Swyneshed 6
4469109 2191005 2191005 defendant Warde John   589593 589593 Warde, John, of Swyneshed 3
4474342 2192628 2192628 defendant Fengrayne John   589593 589593 Fengrayne, John, of Swyneshed 0
4478791 2194036 2194036 defendant Wace William   589593 589593 Wace, William, of Swyneshed 0
4492585 2198383 2198383 defendant Bardeney Richard   589593 589593 Bardeney, Richard, of Swyneshed 0
4497064 2199744 2199744 defendant Hagworthngham Roger   589593 589593 Hagworthngham, Roger, of Swyneshed 2
4497067 2199744 2199744 defendant Garner William   589593 589593 Garner, William, of Swyneshed 5
4499956 2200624 2200624 defendant Bakster William   589593 589593 Bakster, William, of Swyneshed 2
4501016 2200919 2200919 defendant Fengreyen John   589593 589593 Fengreyen, John, of Swyneshed, junior 3
4501990 2201219 2201219 defendant Prepp Lambert   589593 589593 Prepp, Lambert, of Swyneshed 2
4515178 2205165 2205165 plaintiff Chaumbre Thomas   589593 589593 Chaumbre, Thomas, of Swyneshed 0
4535713 2211451 2211451 plaintiff Smyth William   589593 589593 Smyth, William, of Swyneshed 0
4543800 2213956 2213956 defendant Jay John   589593 589593 Jay, John, of Swyneshed 0
4544235 2214114 2214114 plaintiff Barlyman William   589593 589593 Barlyman, William, of Swyneshed 0
4544236 2214114 2214114 defendant Bryse John   589593 589593 Bryse, John, of Swyneshed 0
4549380 2215749 2215749 defendant Appulby Robert laborer 589593 589593 Appulby, Robert, of Swyneshed, laborer 1
4552983 2216877 2216877 defendant Terry John   589593 589593 Terry, John, of Swyneshed 4
4552985 2216877 2216877 defendant Garnar William   589593 589593 Garnar, William, of Swyneshed 6
4555716 2217721 2217721 defendant Pays Thomas laborer 589593 589593 Pays, Thomas, of Swyneshed, laborer 0
4555915 2217788 2217788 defendant Baxter William   589593 589593 Baxter, William, of Swyneshed 0
4557675 2218335 2218335 defendant Smyth Henry   589593 589593 Smyth, Henry, of Swyneshed 0
4561545 2219546 2219546 defendant Roper Alan   589593 589593 Roper, Alan, of Swyneshed 0
4561547 2219547 2219547 defendant Stratour Robert   589593 589593 Stratour, Robert, of Swyneshed 0
4566356 2221048 2221048 defendant Fengrayne John   589593 589593 Fengrayne, John, of Swyneshed 0
4583534 2226273 2226273 defendant Saver or Saner William   589593 589593 Saver or Saner, William, of Swyneshed 1
4583535 2226273 2226273 defendant Terry John   589593 589593 Terry, John, of Swyneshed, son of John 2
4597810 2230569 2230569 defendant Fengrayne John   589593 589593 Fengrayne, John, of Swyneshed 0
4621305 2237653 2237653 plaintiff Kyrnell William   589593 589593 Kyrnell, William, of Swyneshed 0
4638228 2242725 2242725 defendant Heryng Robert   589593 589593 Heryng, Robert, of Swyneshed 2
4660470 2249101 2249101 defendant Terry Thomas husbandman 589593 589593 Terry, Thomas, of Swyneshed, husbandman 0
4669689 2256221 2256221 defendant Peny Richard husbandman 589593 589593 Peny, Richard, of Swyneshed, husbandman 0
4706205 2267318 2267318 defendant Molle William turner 589593 589593 Molle, William, of Swyneshed, turner 1
4720414 2271719 2271719 defendant Blont Alan laborer 589593 589593 Blont, Alan, of Swyneshed, laborer 0
4740176 2277641 2277641 defendant Neuton William husbandman 589593 589593 Neuton, William, of Swyneshed, husbandman 5
4791084 2293309 2293309 defendant Browe John husbandman 589593 589593 Browe, John, of Swyneshed, husbandman 3
4793593 2294107 2294107 defendant Stronge Robert pedder 589593 589593 Stronge, Robert, of Swyneshed, pedder 0
4803505 2297284 2297284 defendant Bolle John gent 589593 589593 Bolle, John, of Swyneshed, gent 0
4804833 2297712 2297712 defendant Lombecas Ecmund husbandman 589593 589593 Lombecas, Ecmund, of Swyneshed, husbandman 1
4814369 2300603 2300603 defendant Jay William husbandman 589593 589593 Jay, William, of Swyneshed, husbandman 0
4820404 2302453 2302453 defendant Broune Thomas husbandman 589593 589593 Broune, Thomas, of Swyneshed, husbandman 0
4825559 2304033 2304033 defendant Loke Roger   589593 589593 Loke, Roger, of Swyneshed, mason 9
4837055 2307547 2307547 defendant Bolle John husbandman 589593 589593 Bolle, John, of Swyneshed, husbandman 1
4851487 2311908 2311908 defendant Casson Lambert husbandman 589593 589593 Casson, Lambert, of Swyneshed, husbandman 9
4900711 2326861 2326861 defendant Mayns Roger husbandman 589593 589593 Mayns, Roger, of Swyneshed, husbandman 1
4907881 2329024 2329024 defendant Mayns John husbandman 589593 589593 Mayns, John, of Swyneshed, husbandman 3
4940358 2339007 2339007 defendant Hoton Robert yeoman 589593 589593 Hoton, Robert, of Swyneshed, yeoman 0
4964596 2346316 2346316 defendant Flete John husbandman 589593 589593 Flete, John, of Swyneshed, husbandman 5
4965625 2346638 2346638 defendant Bolle Godfrey gent 589593 589593 Bolle, Godfrey, of Swyneshed, gent 0
4965626 2346638 2346638 defendant Hoton Robert yeoman 589593 589593 Hoton, Robert, of Swyneshed, yeoman 1
4966335 2346865 2346865 defendant Holand Thomas esq 589593 589593 Holand, Thomas, of Swyneshed, esq 0
5018672 2362349 2362349 defendant Lynde Simon husbandman 589593 589593 Lynde, Simon, of Swyneshed, husbandman 6
5018916 2362419 2362419 defendant Hoton Robert yeoman 589593 589593 Hoton, Robert, of Swyneshed, yeoman 0
5018917 2362419 2362419 defendant Bolles Godfrey gent 589593 589593 together with Bolles, Godfrey, of Swyneshed, gent 1
5035227 2367166 2367166 defendant Smyth Robert, senior husbandman 589593 589593 Smyth, Robert, senior, of Swyneshed, husbandman 0
5067686 2376828 2376828 defendant Peryn John husbandman 589593 589593 Peryn, John, of Swyneshed, husbandman 0
5102800 2387236 2387236 defendant Bolle Margaret widow 589593 589593 Bolle, Margaret, of Swyneshed, widow 0
5102802 2387237 2387237 defendant Bolle William gent 589593 589593 Bolle, William, of Swyneshed, gent 0
5193111 2413715 2413715 plaintiff Overton William gent 589593 589593 Overton, William, of Swyneshed, gent 0
5193113 2413716 2413716 plaintiff Overton William gent 589593 589593 Overton, William, of Swyneshed, gent 0
5215452 2420244 2420244 defendant Elyce John butcher 589593 589593 Elyce, John, of Swyneshed, butcher 10
5223576 2422582 2422582 defendant Bocher alias Cowethorn Thomas butcher 589593 589593 Bocher alias Cowethorn, Thomas, of Swyneshed, butcher 1
5227392 2423639 2423639 defendant Wace Richard husbandman 589593 589593 Wace, Richard, of Swyneshed, husbandman 0
5227393 2423639 2423639 defendant Perysson Richard laborer 589593 589593 Perysson, Richard, of Swyneshed, laborer 1
5239552 2427154 2427154 defendant Storer John husbandman 589593 589593 Storer, John, of Swyneshed, husbandman 0
5247382 2429391 2429391 defendant Holand Thomas   589593 589593 Holand, Thomas, of Swyneshed, knight 0
5259093 2432960 2432960 defendant Bennet Richard, junior husbandman 589593 589593 Bennet, Richard, junior, of Swyneshed, husbandman 1
5267310 2435539 2435539 defendant Baxster William husbandman 589593 589593 Baxster, William, of Swyneshed, husbandman 0
5284415 2440458 2440458 plaintiff Donham William   589593 589593 (Donham, William, of Swyneshed 1
5315611 2449734 2449734 defendant Wolmer Richard gent 589593 589593 Wolmer, Richard, of Swyneshed, gent 2
5324822 2452503 2452503 defendant Garard Stephen husbandman 589593 589593 Garard, Stephen, of Swyneshed, husbandman 0
5324825 2452503 2452503 defendant Webster William husbandman 589593 589593 Webster, William, of Swyneshed, husbandman 3
5324826 2452503 2452503 defendant Tomson John husbandman 589593 589593 Tomson, John, of Swyneshed, husbandman 4
5324827 2452503 2452503 defendant Laurenson William yeoman 589593 589593 Laurenson, William, of Swyneshed, yeoman 5
5324828 2452503 2452503 defendant Thyrkels Henry husbandman 589593 589593 Thyrkels, Henry, of Swyneshed, husbandman 6
5324833 2452503 2452503 defendant Bardney Thomas (legal representative) 589593 589593 Bardney, Thomas, of Swyneshed, husbandman, executors of 11
5324834 2452503 2452503 defendant Bardney Stephen husbandman 589593 589593 (Bardney, Stephen, of Swyneshed, husbandman 12
5324835 2452503 2452503 defendant Bardney Henry husbandman 589593 589593 Bardney, Henry, of Swyneshed, husbandman 13
5324836 2452503 2452503 defendant Bardney Nicholas mercer 589593 589593 Bardney, Nicholas, of Swyneshed, mercer 14
5327022 2453160 2453160 defendant Grantham Richard merchant 589593 589593 Grantham, Richard, of Swyneshed, merchant 0
5337128 2456181 2456181 defendant Overton William gent 589593 589593 Overton, William, of Swyneshed, gent 0
5337129 2456181 2456181 defendant Benson William laborer 589593 589593 Benson, William, of Swyneshed, laborer 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);