names

82 rows where place_id = 598296

✎ 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
3631887 1904782 1904782 defendant Womwell John gent 598296 598296 Womwell, John, of Spaldyng, Lincs, gent 1
3759347 1944913 1944913 defendant Neleson John pewterer 598296 598296 Neleson, John, of Spaldyng, Lincs, pewterer 1
3808741 1960612 1960612 defendant Clarke John waterman 598296 598296 Clarke, John, of Spaldyng, Lincs, waterman 3
3854213 1974955 1974955 defendant Whyte Ralph butcher 598296 598296 Whyte, Ralph, of Spaldyng, Lincs, butcher 0
3894994 1988534 1988534 defendant Irby Ambrose clerk 598296 598296 Irby, Ambrose, of Spaldyng, Lincs, clerk 0
3900788 1990492 1990492 defendant Watson George yeoman 598296 598296 Watson, George, of Spaldyng, Lincs, yeoman 0
3918380 1996475 1996475 defendant Jery John dyer 598296 598296 Jery, John, of Spaldyng, Lincs, dyer 1
3920360 1997151 1997151 defendant Assheton James esq 598296 598296 Assheton, James, of Spaldyng, Lincs, esq 1
3920364 1997152 1997152 defendant Assheton James esq 598296 598296 Assheton, James, of Spaldyng, Lincs, esq 1
3928377 1999830 1999830 defendant Gamblen John gent 598296 598296 Gamblen, John, of Spaldyng, Lincs, gent 0
3931438 2000813 2000813 defendant Gamgeln John gent 598296 598296 Gamgeln, John, of Spaldyng, Lincs, gent 0
3949914 2007048 2007048 plaintiff Fetherston William drover 598296 598296 Fetherston, William, of Spaldyng, Lincs, drover 0
3960412 2010739 2010739 defendant Welland Thomas draper 598296 598296 Welland, Thomas, of Spaldyng, Lincs, draper 0
3976682 2016417 2016417 defendant Kedby William yeoman 598296 598296 Kedby, William, of Spaldyng, Lincs, yeoman 12
3991849 2021838 2021838 plaintiff Browne Charles gent 598296 598296 Browne, Charles, of Spaldyng, Lincs, gent 0
3991851 2021839 2021839 plaintiff Browne Charles gent 598296 598296 Browne, Charles, of Spaldyng, Lincs, gent 0
4113551 2065127 2065127 defendant Jackson Robert draper 598296 598296 Jackson, Robert, of Spaldyng, Lincs, draper 0
4113556 2065128 2065128 defendant Jackson Robert draper 598296 598296 Jackson, Robert, of Spaldyng, Lincs, draper 0
4327498 2139518 2139518 defendant Gamblyn or Gamble Mathew gent 598296 598296 Gamblyn or Gamble, Mathew, of Spaldyng, Lincs, gent 0
4683709 2260505 2260505 defendant Coupere Robert yeoman 598296 598296 Coupere, Robert, of Spaldyng, Lincs, yeoman 0
4758355 2282986 2282986 defendant Foweler John chapman 598296 598296 Foweler, John, of Spaldyng, Lincs, chapman 0
4810363 2299388 2299388 defendant Smyth Richard chapman 598296 598296 Smyth, Richard, of Spaldyng, Lincs, chapman 0
4883739 2321824 2321824 defendant Couper Robert husbandman 598296 598296 Couper, Robert, of Spaldyng, Lincs, husbandman 1
4893401 2324639 2324639 defendant Avye or Anye John husbandman 598296 598296 Avye or Anye, John, of Spaldyng, Lincs, husbandman 0
4908333 2329162 2329162 defendant Torald Thomas tanner 598296 598296 Torald, Thomas, of Spaldyng, Lincs, tanner 1
4949432 2341813 2341813 defendant Sparowe Thomas yeoman 598296 598296 Sparowe, Thomas, of Spaldyng, Lincs, yeoman 0
4950409 2342094 2342094 defendant Swan John waterman 598296 598296 Swan, John, of Spaldyng, Lincs, waterman 0
4971828 2348504 2348504 defendant Shorte Margaret widow 598296 598296 Shorte, Margaret, of Spaldyng, Lincs, widow 0
4972161 2348615 2348615 defendant Prentyse John clerk 598296 598296 Prentyse, John, of Spaldyng, Lincs, clerk 0
4985537 2352590 2352590 defendant Elwyn William chapman 598296 598296 Elwyn, William, of Spaldyng, Lincs, chapman 0
4985618 2352615 2352615 defendant Elwyn William chapman 598296 598296 Elwyn, William, of Spaldyng, Lincs, chapman 0
5006043 2358655 2358655 defendant Prowet Richard chaplain 598296 598296 Prowet, Richard, of Spaldyng, Lincs, chaplain 0
5006044 2358655 2358655 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 1
5006049 2358656 2358656 defendant Prowet Richard chaplain 598296 598296 Prowet, Richard, of Spaldyng, Lincs, chaplain 0
5006050 2358656 2358656 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 1
5014217 2361009 2361009 defendant Wyche Walter barber 598296 598296 Wyche, Walter, of Spaldyng, Lincs, barber 1
5027669 2364970 2364970 defendant Wynter John tailor 598296 598296 (Wynter, John, of Spaldyng, Lincs, tailor 1
5081780 2381050 2381050 defendant Date William chaplain 598296 598296 Date, William, of Spaldyng, Lincs, chaplain 4
5081786 2381051 2381051 defendant Date William chaplain 598296 598296 Date, William, of Spaldyng, Lincs, chaplain 4
5094625 2384839 2384839 defendant Tovey Simon yeoman 598296 598296 (Tovey, Simon, of Spaldyng, Lincs, yeoman 1
5094628 2384840 2384840 defendant Tovey Simon yeoman 598296 598296 (Tovey, Simon, of Spaldyng, Lincs, yeoman 1
5100711 2386633 2386633 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 3
5103743 2387517 2387517 defendant Sparowe Thomas yeoman 598296 598296 Sparowe, Thomas, of Spaldyng, Lincs, yeoman 0
5109500 2389207 2389207 defendant Sparowe Thomas yeoman 598296 598296 Sparowe, Thomas, of Spaldyng, Lincs, yeoman 0
5110596 2389499 2389499 defendant Smyth Simon   598296 598296 Smyth, Simon, of Spaldyng, Lincs, clax chapman 0
5113339 2390292 2390292 defendant Smyth Simon   598296 598296 Smyth, Simon, of Spaldyng, Lincs, flax chapman 3
5125836 2394042 2394042 defendant Sparough Thomas husbandman 598296 598296 Sparough, Thomas, of Spaldyng, Lincs, husbandman 0
5163935 2405190 2405190 defendant Malyn Robert yeoman 598296 598296 Malyn, Robert, of Spaldyng, Lincs, yeoman 1
5163936 2405190 2405190 defendant Bernard Henry husbandman 598296 598296 Bernard, Henry, of Spaldyng, Lincs, husbandman 2
5163964 2405199 2405199 defendant Malyn Robert yeoman 598296 598296 Malyn, Robert, of Spaldyng, Lincs, yeoman 1
5163965 2405199 2405199 defendant Bernard Henry husbandman 598296 598296 Bernard, Henry, of Spaldyng, Lincs, husbandman 2
5177399 2409086 2409086 defendant Malyn Robert yeoman 598296 598296 Malyn, Robert, of Spaldyng, Lincs, yeoman 0
5190668 2413017 2413017 defendant Purley William gent 598296 598296 Purley, William, of Spaldyng, Lincs, gent 0
5191073 2413128 2413128 defendant Haddon John husbandman 598296 598296 Haddon, John, of Spaldyng, Lincs, husbandman 3
5191679 2413303 2413303 defendant Swan William water man 598296 598296 Swan, William, of Spaldyng, Lincs, water man 0
5191681 2413304 2413304 defendant Swan William water man 598296 598296 Swan, William, of Spaldyng, Lincs, water man 0
5200414 2415883 2415883 defendant Malyn Robert yeoman 598296 598296 Malyn, Robert, of Spaldyng, Lincs, yeoman 0
5200415 2415883 2415883 defendant Bernard Henry husbandman 598296 598296 Bernard, Henry, of Spaldyng, Lincs, husbandman 1
5207178 2417839 2417839 defendant Horner Robert   598296 598296 Horner, Robert, of Spaldyng, Lincs, pyke monger 1
5207429 2417914 2417914 defendant Swan William waterman 598296 598296 Swan, William, of Spaldyng, Lincs, waterman 0
5207992 2418072 2418072 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 1
5207999 2418073 2418073 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 1
5212562 2419420 2419420 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 3
5221489 2421982 2421982 defendant Heron alias Hert John gent 598296 598296 Heron alias Hert, John, of Spaldyng, Lincs, gent 1
5229081 2424114 2424114 defendant Hovy David chapman 598296 598296 Hovy, David, of Spaldyng, Lincs, chapman 4
5229697 2424305 2424305 defendant Bawetre Richard chaplain 598296 598296 Bawetre, Richard, of Spaldyng, Lincs, chaplain 2
5229755 2424323 2424323 defendant Kede Richard merchant 598296 598296 Kede, Richard, of Spaldyng, Lincs, merchant 0
5230523 2424543 2424543 defendant Danyell Robert chapman 598296 598296 Danyell, Robert, of Spaldyng, Lincs, chapman 3
5238285 2426781 2426781 defendant Hovy Thomas yeoman 598296 598296 Hovy, Thomas, of Spaldyng, Lincs, yeoman 2
5244711 2428630 2428630 defendant Horner Robert yeoman 598296 598296 Horner, Robert, of Spaldyng, Lincs, yeoman 1
5244723 2428632 2428632 defendant Horner Robert yeoman 598296 598296 Horner, Robert, of Spaldyng, Lincs, yeoman 1
5244733 2428634 2428634 defendant Horner Robert husbandman 598296 598296 Horner, Robert, of Spaldyng, Lincs, husbandman 0
5245143 2428741 2428741 defendant Horner Robert husbandman 598296 598296 Horner, Robert, of Spaldyng, Lincs, husbandman 0
5261783 2433794 2433794 defendant Smyth Thomas yeoman 598296 598296 (Smyth, Thomas, of Spaldyng, Lincs, yeoman 3
5266863 2435387 2435387 defendant Hony or Hovy Thomas yeoman 598296 598296 Hony or Hovy, Thomas, of Spaldyng, Lincs, yeoman 0
5304035 2446211 2446211 defendant Haryson John fisher 598296 598296 Haryson, John, of Spaldyng, Lincs, fisher 1
5513715 2509142 2509142 defendant Tayllour Thomas skinner 598296 598296 Tayllour, Thomas, of Spaldyng, Lincs, skinner 2
5530175 2513943 2513943 defendant Hoode William chapman 598296 598296 Hoode, William, of Spaldyng, Lincs, chapman 1
5549680 2519950 2519950 defendant Spencer Richard gent 598296 598296 Spencer, Richard, of Spaldyng, Lincs, gent 1
5566049 2524674 2524674 defendant Taverner John taverner 598296 598296 Taverner, John, of Spaldyng, Lincs, taverner 4
5568217 2525247 2525247 defendant Warde Hugh chapman 598296 598296 Warde, Hugh, of Spaldyng, Lincs, chapman 4
5588020 2531263 2531263 defendant Taverner William mercer 598296 598296 Taverner, William, of Spaldyng, Lincs, mercer 4

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