names

159 rows where place_id = 604337

✎ 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
3653885 1911480 1911480 plaintiff (not given) Thomas prior of -- 604337 604337 --, Thomas, of Durham, prior of the Monastery of St Cuthbert 0
3657697 1912657 1912657 defendant Fern Robert chapman 604337 604337 Fern, Robert, of Durham, chapman 3
3726317 1934501 1934501 defendant Clerke John gent 604337 604337 (Clerke, John, of Durham, gent 1
3799370 1957724 1957724 defendant Meggeley William walker 604337 604337 Meggeley, William, of Durham, walker 1
3799371 1957724 1957724 defendant Meggeley John walker 604337 604337 Meggeley, John, of Durham, walker 2
3821868 1964728 1964728 plaintiff Skoyn Christopher   604337 604337 Skoyn, Christopher, of Durham, mason 0
3821870 1964729 1964729 plaintiff Skoyn Christopher   604337 604337 Skoyn, Christopher, of Durham, mason 0
3859232 1976580 1976580 defendant Person Henry draper 604337 604337 Person, Henry, of Durham, draper 0
3879244 1983309 1983309 defendant Rychardson Cuthbert gent 604337 604337 Rychardson, Cuthbert, of Durham, gent 0
3931780 2000933 2000933 plaintiff Eden William (legal representative) 604337 604337 Eden, William, of Durham, mercer, executors of 0
3935318 2002126 2002126 defendant Carre Joan widow 604337 604337 Carre, Joan, of Durham, widow 1
3956934 2009492 2009492 defendant Rackett John, junior gent 604337 604337 Rackett, John, junior, of Durham, gent 0
3976668 2016416 2016416 defendant Wall John merchant 604337 604337 Wall, John, of Durham, merchant 2
3978387 2017026 2017026 defendant Harper William chapman 604337 604337 Harper, William, of Durham, chapman 0
3982578 2018542 2018542 defendant Thyrkeld Robert gent 604337 604337 Thyrkeld, Robert, of Durham, or of London, gent 2
3984734 2019297 2019297 plaintiff Chaytor Christopher   604337 604337 Chaytor, Christopher, of Durham, notary publics 1
3991915 2021867 2021867 plaintiff Browne Thomas barber 604337 604337 Browne, Thomas, of Durham, barber 0
3993638 2022470 2022470 plaintiff Chaytor Christopher esq 604337 604337 Chaytor, Christopher, of Durham, esq 0
3993641 2022471 2022471 plaintiff Chaytor Christopher esq 604337 604337 Chaytor, Christopher, of Durham, esq 0
3999710 2024658 2024658 defendant Clyff George   604337 604337 Clyff, George, of Durham, clerk, prebendary of Durham Cathedral 0
3999712 2024659 2024659 defendant Clyff George   604337 604337 Clyff, George, of Durham, clerk, prebendary of Durham Cathedral 0
4009384 2028122 2028122 defendant Wood Robert chapman 604337 604337 Wood, Robert, of Durham, chapman 2
4009389 2028123 2028123 defendant Wall Richard chapman 604337 604337 Wall, Richard, of Durham, chapman 2
4017247 2030875 2030875 plaintiff Teast or Teste Christopher husbandman 604337 604337 Teast or Teste, Christopher, of Durham, husbandman 0
4038344 2038354 2038354 defendant Wrighte Christopher chapman 604337 604337 Wrighte, Christopher, of Durham, chapman 0
4086787 2055562 2055562 defendant Bunny Francis clerk 604337 604337 Bunny, Francis, of Durham, clerk 0
4086789 2055563 2055563 defendant Bunnye Francis clerk 604337 604337 Bunnye, Francis, of Durham, clerk 0
4091955 2057420 2057420 defendant Rackett John (legal representative) 604337 604337 Rackett, John, of Durham, gent, executrix of 0
4091956 2057420 2057420 defendant Rackett Elizabeth widow 604337 604337 Rackett, Elizabeth, of Durham, widow 1
4156499 2080349 2080349 defendant Cuthbert George yeoman 604337 604337 Cuthbert, George, of Durham, yeoman 1
4254174 2114390 2114390 defendant Richardson John   604337 604337 Richardson, John, of Durham, gent, attorney 0
4267056 2118622 2118622 defendant Richardson Thomas merchant 604337 604337 Richardson, Thomas, of Durham, or of Newcastle on Tyne, merchant 1
4267057 2118622 2118622 defendant Richardson John   604337 604337 Richardson, John, of Durham, attorney 2
4267584 2118790 2118790 defendant Wallis Oswald dyer 604337 604337 Wallis, Oswald, of Durham, dyer 0
4267585 2118790 2118790 defendant Dearman alias Deareham Nicholas gent 604337 604337 Dearman alias Deareham, Nicholas, of Durham, gent 1
4318821 2136698 2136698 defendant Constable Michael esq 604337 604337 Constable, Michael, of Durham, esq 0
4319760 2137023 2137023 defendant Hutton Robert clerk 604337 604337 Hutton, Robert, of Durham, clerk 0
4322257 2137859 2137859 defendant Wall John merchant 604337 604337 Wall, John, of Durham, merchant 1
4322258 2137859 2137859 defendant Wall Henry   604337 604337 Wall, Henry, of Durham, yeoman, his son 2
4322425 2137912 2137912 defendant Glover Christopher yeoman 604337 604337 Glover, Christopher, of Durham, yeoman 2
4322501 2137936 2137936 defendant Barnes Emanuel   604337 604337 Barnes, Emanuel, of Durham, Doctor of Theology 0
4322503 2137937 2137937 defendant Barnes John gent 604337 604337 Barnes, John, of Durham, gent 0
4325939 2139050 2139050 defendant Tailboys William, junior gent 604337 604337 Tailboys, William, junior, of Durham, gent 1
4330224 2140412 2140412 defendant Wrighte Margaret, senior widow 604337 604337 Wrighte, Margaret, senior, of Durham, widow 1
4332631 2141201 2141201 defendant Heth Edward gent 604337 604337 Heth, Edward, of Durham, gent 0
4337304 2142779 2142779 defendant Rogerson Richard yeoman 604337 604337 Rogerson, Richard, of Durham, yeoman 1
4350881 2147562 2147562 defendant Stowte Thomas yeoman 604337 604337 Stowte, Thomas, of Durham, yeoman 0
4374212 2155849 2155849 defendant Whitfild Robert draper 604337 604337 Whitfild, Robert, of Durham, chapman, draper 0
4374213 2155849 2155849 defendant Hopper Hugh draper 604337 604337 Hopper, Hugh, of Durham, chapman, draper 1
4384100 2159379 2159379 defendant Barnes John esq 604337 604337 Barnes, John, of Durham, esq 0
4386739 2160240 2160240 defendant Rogers Richard   604337 604337 Rogers, Richard, of Durham, "gresman" 1
4404027 2165917 2165917 defendant Heyton Richard saltpeterman 604337 604337 Heyton, Richard, of Durham, saltpeterman 2
4411027 2168274 2168274 defendant Law James gent 604337 604337 Law, James, of Durham, gent 0
4411551 2168455 2168455 defendant Bussy John gent 604337 604337 Bussy, John, of Durham, gent 0
4421569 2171643 2171643 plaintiff Coxside Robert merchant 604337 604337 Coxside, Robert, of Durham, merchant 0
4472351 2192024 2192024 defendant Holm William   604337 604337 Holm, William, of Durham 0
4472456 2192055 2192055 defendant Holm William   604337 604337 Holm, William, of Durham 0
4480994 2194731 2194731 defendant Holme William de mercer 604337 604337 Holme, William de, of Durham, mercer 0
4508922 2203267 2203267 plaintiff Armurer John   604337 604337 Armurer, John, of Durham 0
4518051 2206020 2206020 defendant Kellowe Robert   604337 604337 Kellowe, Robert, of Durham, son of William 1
4521826 2207161 2207161 defendant Fordam John   604337 604337 Fordam, John, of Durham, formerly bishop 0
4527211 2208791 2208791 plaintiff Lewyn John (legal representative) 604337 604337 Lewyn, John, of Durham, executrix of 0
4535338 2211323 2211323 defendant Brynome John   604337 604337 Brynome, John, of Durham, parson of St Nicholas' church 0
4542006 2213392 2213392 defendant Taillour Edward   604337 604337 Taillour, Edward, of Durham 0
4542007 2213392 2213392 defendant Appilton John de   604337 604337 Appilton, John de, of Durham 1
4559676 2218981 2218981 defendant Arnold Richard   604337 604337 Arnold, Richard, of Durham 1
4560984 2219388 2219388 defendant Holme William   604337 604337 Holme, William, of Durham 1
4579109 2224949 2224949 defendant Cok Thomas   604337 604337 Cok, Thomas, of Durham 1
4581521 2225673 2225673 plaintiff Weston Thomas de master & archdeacon 604337 604337 (Weston, Thomas de, of Durham, master & archdeacon 1
4581536 2225674 2225674 plaintiff Weston Thomas de master & archdeacon 604337 604337 (Weston, Thomas de, of Durham, master & archdeacon 1
4582332 2225916 2225916 defendant Monyour Richard   604337 604337 Monyour, Richard, of Durham 2
4605194 2232791 2232791 defendant Holme William   604337 604337 Holme, William, of Durham 1
4616515 2236160 2236160 defendant Quarrom William   604337 604337 Quarrom, William, of Durham 4
4621959 2237846 2237846 defendant Huntere William   604337 604337 Huntere, William, of Durham 0
4625032 2238794 2238794 defendant Holme William   604337 604337 Holme, William, of Durham 1
4632967 2241182 2241182 defendant Elyson John   604337 604337 Elyson, John, of Durham 0
4635215 2241854 2241854 defendant Tesedale Henry   604337 604337 Tesedale, Henry, of Durham 2
4641547 2243626 2243626 defendant Quarrom William   604337 604337 Quarrom, William, of Durham 1
4649253 2245835 2245835 defendant Holme William   604337 604337 Holme, William, of Durham 0
4653202 2246937 2246937 defendant Merley Richard gent 604337 604337 Merley, Richard, of Durham, gent 1
4656999 2248080 2248080 defendant Heworth Robert gent 604337 604337 Heworth, Robert, of Durham, gent 2
4678225 2258798 2258798 defendant Steel William yeoman 604337 604337 Steel, William, of Durham, yeoman 1
4685523 2261066 2261066 plaintiff Ryhale Thomas clerk 604337 604337 Ryhale, Thomas, of Durham, clerk 0
4705220 2267003 2267003 defendant Frende John tanner 604337 604337 Frende, John, of Durham, tanner 1
4741272 2277944 2277944 defendant Aldynchelys William spicer 604337 604337 Aldynchelys, William, of Durham, spicer 1
4741273 2277944 2277944 defendant Palman William smith 604337 604337 Palman, William, of Durham, smith 2
4741274 2277944 2277944 defendant Rapar Thomas tailor 604337 604337 Rapar, Thomas, of Durham, tailor 3
4744409 2278887 2278887 defendant Hunter William clerk 604337 604337 Hunter, William, of Durham, clerk 5
4745968 2279323 2279323 defendant West John husbandman 604337 604337 West, John, of Durham, husbandman 1
4757394 2282684 2282684 defendant Henryson Thomas dyer 604337 604337 Henryson, Thomas, of Durham, dyer 1
4764312 2284834 2284834 plaintiff Hayford Nicholas (legal representative) 604337 604337 Hayford, Nicholas, of Durham, burgess, executors of 0
4779480 2289560 2289560 defendant Raper William dyer 604337 604337 Raper, William, of Durham, dyer 0
4786496 2291820 2291820 defendant Wollston Robert clerk 604337 604337 Wollston, Robert, of Durham, clerk 0
4789128 2292653 2292653 defendant Marsshall Thomas mercer 604337 604337 Marsshall, Thomas, of Durham, mercer 0
4789129 2292653 2292653 defendant Dighton John butcher 604337 604337 Dighton, John, of Durham, butcher 1
4789233 2292691 2292691 defendant Symondsete John husbandman 604337 604337 Symondsete, John, of Durham, husbandman 1
4800803 2296441 2296441 defendant Broun William brasier 604337 604337 Broun, William, of Durham, brasier 1
4818793 2301963 2301963 defendant Hendelay Thomas yeoman 604337 604337 Hendelay, Thomas, of Durham, yeoman 0
4857910 2313839 2313839 defendant Baker William dyer 604337 604337 Baker, William, of Durham, dyer 3
4869556 2317442 2317442 defendant Ulthwayt William yeoman 604337 604337 Ulthwayt, William, of Durham, yeoman 6

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