names

82 rows where place_id = 597943

✎ 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
3630482 1904366 1904366 defendant Fretchwell Nicholas gent 597943 597943 Fretchwell, Nicholas, of Wales, gent 0
3657950 1912736 1912736 defendant Thomas Thomas chapman 597943 597943 Thomas, Thomas, of Pembroke, Wales, chapman 5
3691607 1923532 1923532 plaintiff Hewet Nicholas   597943 597943 Hewet, Nicholas, of Wales 0
3691609 1923533 1923533 plaintiff Hewet Nicholas   597943 597943 Hewet, Nicholas, of Wales 0
3696491 1925130 1925130 defendant Hewet Nicholas gent 597943 597943 Hewet, Nicholas, of Wales, gent 0
3707840 1928750 1928750 defendant Spencer Henry husbandman 597943 597943 Spencer, Henry, of Wales, husbandman 0
3710587 1929634 1929634 defendant Kechyn George husbandman 597943 597943 Kechyn, George, of Wales, husbandman 0
3719018 1932223 1932223 defendant Jonys William gent 597943 597943 Jonys, William, of Monmouth, Wales, gent 1
3719021 1932224 1932224 defendant Jonys William gent 597943 597943 Jonys, William, of Monmouth, Wales, gent 1
3749193 1941673 1941673 plaintiff Hewet Nicholas   597943 597943 Hewet, Nicholas, of Wales 0
3779857 1951432 1951432 defendant Hewet Thomas gent 597943 597943 Hewet, Thomas, of Wales, gent 2
3787812 1953975 1953975 defendant Symmes John husbandman 597943 597943 Symmes, John, of Wales, husbandman 3
3810098 1961047 1961047 defendant Woogan John esq 597943 597943 Woogan, John, of Pembroke, Wales, esq 2
3832120 1967954 1967954 defendant Nayler Thomas weaver 597943 597943 Nayler, Thomas, of Wales, weaver 0
3877123 1982589 1982589 defendant Bromley Nicholas, senior laborer 597943 597943 Bromley, Nicholas, senior, of Wales, laborer 0
3877124 1982589 1982589 defendant Bromley Nicholas, junior laborer 597943 597943 Bromley, Nicholas, junior, of Wales, laborer 1
4025311 2033713 2033713 defendant Edward Hugh yeoman or mercer 597943 597943 Edward, Hugh, of Mountgomery, Wales, yeoman or mercer 1
4098144 2059664 2059664 defendant Hewett Francis gent 597943 597943 Hewett, Francis, of Wales, gent 0
4140360 2074795 2074795 defendant Hewette Francis gent 597943 597943 Hewette, Francis, of Wales, gent 2
4155230 2079922 2079922 defendant Syms John husbandman 597943 597943 Syms, John, of Wales, husbandman 0
4415325 2169688 2169688 defendant Wykeresleye Ralph de   597943 597943 Wykeresleye, Ralph de, of Wales, son of William 0
4491384 2197994 2197994 defendant Juson of Inson Robert   597943 597943 Juson of Inson, Robert, of Monmouth, Wales 0
4504967 2202094 2202094 defendant Donne John   597943 597943 Donne, John, of Wales 4
4521420 2207041 2207041 defendant Wen Philip clerk 597943 597943 Wen, Philip, of Wales, clerk 0
4552122 2216612 2216612 plaintiff Everesdon John   597943 597943 Everesdon, John, of Wales, abbot of Grace Dieu abbey 0
4586752 2227259 2227259 defendant Smyth Thomas   597943 597943 Smyth, Thomas, of Wales 0
4594893 2229657 2229657 defendant Barbour Thomas   597943 597943 Barbour, Thomas, of Wales 0
4657180 2248131 2248131 defendant Maddok John laborer 597943 597943 Maddok, John, of Wales, husbandman, or of London, laborer 3
4657186 2248132 2248132 defendant Maddok John laborer 597943 597943 Maddok, John, of Wales, husbandman, or of London, laborer 3
4667050 2255425 2255425 defendant ap Gwyllym John esq 597943 597943 ap Gwyllym, John, of Monmouth, Wales, esq 0
4667052 2255426 2255426 defendant ap Gwyllym John esq 597943 597943 ap Gwyllym, John, of Monmouth, Wales, esq 0
4706800 2267509 2267509 defendant Stote Richard   597943 597943 Stote, Richard, of Monmouth, Wales, shoe maker 3
4739000 2277287 2277287 defendant Dawes Thomas husbandman 597943 597943 Dawes, Thomas, of Wales, husbandman 3
4771110 2286947 2286947 defendant ap Gwyllym John esq 597943 597943 ap Gwyllym, John, of Monmouth, Wales, esq 0
4821473 2302801 2302801 defendant ap Guilllym John (legal representative) 597943 597943 ap Guilllym, John, of Monmouth, Wales, esq, executrix of 0
4843171 2309390 2309390 defendant Hille Edward esq 597943 597943 Hille, Edward, of Radnor, Wales, esq 4
4852936 2312341 2312341 defendant Godechilde John dyer 597943 597943 Godechilde, John, of Monmouth, Wales, dyer 1
4857967 2313860 2313860 defendant Bron Roger mariner 597943 597943 Bron, Roger, of Wales, mariner 1
4877069 2319798 2319798 defendant Terell John husbandman 597943 597943 Terell, John, of Wales, husbandman 2
4877070 2319798 2319798 defendant Rowthorp William husbandman 597943 597943 Rowthorp, William, of Wales, husbandman 3
4891301 2324006 2324006 defendant Pynder John husbandman 597943 597943 Pynder, John, of Wales, husbandman 1
4891302 2324006 2324006 defendant Shemyld John nailer 597943 597943 Shemyld, John, of Wales, nailer 2
4899404 2326453 2326453 defendant Shemyld John nailer 597943 597943 Shemyld, John, of Wales, nailer 3
4930480 2335934 2335934 defendant Maddok Thomas merchant 597943 597943 Maddok, Thomas, of Cardigan, Wales, merchant 1
4941876 2339451 2339451 defendant Wolton John esq 597943 597943 Wolton, John, of Denbigh, Wales, esq 0
5010596 2359971 2359971 defendant Nerber Thomas esq 597943 597943 Nerber, Thomas, of Wales, esq 3
5033850 2366779 2366779 defendant Elot Thomas husbandman 597943 597943 Elot, Thomas, of Wales, husbandman 2
5033851 2366779 2366779 defendant Asclay Thomas husbandman 597943 597943 Asclay, Thomas, of Wales, husbandman 3
5067820 2376877 2376877 plaintiff Parker Edmund   597943 597943 Parker, Edmund, of Wales 0
5081440 2380950 2380950 defendant Catmay John chapman 597943 597943 Catmay, John, of Monmouth, Wales, chapman 1
5135647 2396938 2396938 defendant ap Jen ap Lln John gent 597943 597943 ap Jen ap Lln, John, of Radnor, Wales, gent 0
5135653 2396939 2396939 defendant ap Howell ap Gryffyth Thomas   597943 597943 ap Howell ap Gryffyth, Thomas, of Radnor, Wales 1
5135660 2396941 2396941 defendant ap Jen ap Lln John gent 597943 597943 ap Jen ap Lln, John, of Radnor, Wales, gent 0
5168468 2406493 2406493 defendant ap Rys Gethyn Lewis gent 597943 597943 ap Rys Gethyn, Lewis, of Carmarthen, Wales, gent 3
5188123 2412241 2412241 defendant Herberd Thomas esq 597943 597943 Herberd, Thomas, of Monmouth, Wales, esq 2
5201362 2416155 2416155 defendant Pountan Richard chapman 597943 597943 Pountan, Richard, of Carmarthen, Wales, chapman 3
5205899 2417461 2417461 defendant Herberd Thomas esq 597943 597943 Herberd, Thomas, of Monmouth, Wales, esq 2
5216490 2420552 2420552 defendant Huet Nicholas yeoman 597943 597943 Huet, Nicholas, of Wales, yeoman 2
5216491 2420552 2420552 defendant Hugden Adam husbandman 597943 597943 Hugden, Adam, of Wales, husbandman 3
5216496 2420553 2420553 defendant Huet Nicholas yeoman 597943 597943 Huet, Nicholas, of Wales, yeoman 2
5216497 2420553 2420553 defendant Hugden Adam husbandman 597943 597943 Hugden, Adam, of Wales, husbandman 3
5230999 2424669 2424669 defendant Bocher Thomas drover 597943 597943 Bocher, Thomas, of Monmouth, Wales, drover 0
5231009 2424670 2424670 defendant Bocher Thomas drover 597943 597943 Bocher, Thomas, of Monmouth, Wales, drover 0
5271978 2436888 2436888 defendant Tayllour John chapman 597943 597943 Tayllour, John, of Monmouth, Wales, chapman 2
5271993 2436891 2436891 defendant Lewelyn Thomas chapman 597943 597943 Lewelyn, Thomas, of Monmouth, Wales, chapman 4
5286464 2441043 2441043 defendant Cachemayden John, junior chapman 597943 597943 Cachemayden, John, junior, of Monmouth, Wales, chapman 2
5311377 2448436 2448436 defendant Mathewe John chapman 597943 597943 Mathewe, John, of Monmouth, Wales, chapman 0
5311383 2448438 2448438 defendant Mathewe John chapman 597943 597943 Mathewe, John, of Monmouth, Wales, chapman 1
5372277 2466922 2466922 defendant Appenreth Philip yeoman 597943 597943 Appenreth, Philip, of Wales, yeoman 1
5390762 2472422 2472422 defendant Davy Mathew chapman 597943 597943 Davy, Mathew, of Wales, chapman 2
5416822 2479949 2479949 defendant Davy John chapman 597943 597943 Davy, John, of Wales, chapman 1
5441136 2487261 2487261 defendant Kenerston Roger   597943 597943 Kenerston, Roger, of Wales, knight 0
5488712 2501504 2501504 defendant Smyth John clerk 597943 597943 Smyth, John, of Mountgomery, Wales, clerk 2
5488717 2501505 2501505 defendant Smyth John clerk 597943 597943 Smyth, John, of Mountgomery, Wales, clerk 2
5494324 2503203 2503203 defendant Huet Stephen husbandman 597943 597943 Huet, Stephen, of Wales, husbandman 8
5494325 2503203 2503203 defendant Huet Joan widow 597943 597943 Huet, Joan, of Wales, widow 9
5508748 2507588 2507588 defendant Cok Lawrence chapman 597943 597943 Cok, Lawrence, of Monmouth, Wales, chapman 0
5511563 2508463 2508463 defendant Clayton Richard yeoman 597943 597943 Clayton, Richard, of Wales, yeoman 0
5511568 2508464 2508464 defendant Clayton Richard yeoman 597943 597943 Clayton, Richard, of Wales, yeoman 0
5527080 2513039 2513039 defendant Catchemade John yeoman 597943 597943 Catchemade, John, of Monmouth, Wales, yeoman 0
5554797 2521403 2521403 defendant Jenyns Edward clerk 597943 597943 Jenyns, Edward, of Monmouth, Wales, clerk 13
5606887 2537042 2537042 defendant ap Howell Richard dyer 597943 597943 ap Howell, Richard, of Monmouth, Wales, dyer 0

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