names

88 rows where place_id = 586843

✎ 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
3589783 1864445 1864445 defendant Redyng Humphrey gent 586843 586843 Redyng, Humphrey, of Wyche, gent 0
3589784 1864445 1864445 defendant Wythe Richard yeoman 586843 586843 Wythe, Richard, of Wyche, yeoman 1
3589785 1864445 1864445 defendant Wythe Thomas yeoman 586843 586843 Wythe, Thomas, of Wyche, yeoman 2
3589787 1864446 1864446 defendant Redyng Humphrey gent 586843 586843 Redyng, Humphrey, of Wyche, gent 0
3589788 1864446 1864446 defendant Wythe Thomas yeoman 586843 586843 Wythe, Thomas, of Wyche, yeoman 1
3616791 1872881 1872881 defendant Neweport George gent 586843 586843 Neweport, George, of Wyche, gent 0
3616792 1872881 1872881 defendant Walsshe Thomas yeoman 586843 586843 Walsshe, Thomas, of Wyche, yeoman 1
3636265 1906132 1906132 defendant Curtes Roger butcher 586843 586843 Curtes, Roger, of Wyche, butcher 3
3720464 1932683 1932683 defendant Harres John husbandman 586843 586843 Harres, John, of Wyche, husbandman 0
3720465 1932683 1932683 defendant Harrys Richard husbandman 586843 586843 Harrys, Richard, of Wyche, husbandman 1
3829010 1966957 1966957 defendant Rudyng Thomas gent 586843 586843 Rudyng, Thomas, of Wyche, gent 3
4423981 2172354 2172354 defendant Aleyn John   586843 586843 Aleyn, John, of Wyche, son of John 0
4424173 2172410 2172410 defendant Leche John le   586843 586843 Leche, John le, of Wyche 0
4478395 2193917 2193917 defendant Froxmere John   586843 586843 Froxmere, John, of Wyche 0
4478396 2193917 2193917 defendant Austyn Thomas   586843 586843 Austyn, Thomas, of Wyche 1
4491909 2198154 2198154 defendant Wawe John   586843 586843 Wawe, John, of Wyche 0
4542734 2213614 2213614 defendant Whelere John butcher 586843 586843 Whelere, John, of Wyche, butcher 2
4545881 2214643 2214643 plaintiff Botiller Wililam   586843 586843 Botiller, Wililam, of Wyche 0
4545884 2214644 2214644 plaintiff Botiller William   586843 586843 Botiller, William, of Wyche 0
4546722 2214900 2214900 defendant Botillere John   586843 586843 Botillere, John, of Wyche 2
4552207 2216643 2216643 defendant Glome_ Nicholas   586843 586843 Glome_, Nicholas, of Wyche 2
4564001 2220314 2220314 defendant Austyn Thomas   586843 586843 Austyn, Thomas, of Wyche 0
4577397 2224446 2224446 defendant Banard Richard, sen   586843 586843 Banard, Richard, sen, of Wyche 0
4603724 2232351 2232351 plaintiff Wybbe Elizabeth   586843 586843 Wybbe, Elizabeth, of Wyche 0
4604904 2232700 2232700 defendant Gonell Thomas   586843 586843 Gonell, Thomas, of Wyche 4
4604905 2232700 2232700 defendant Clent William   586843 586843 Clent, William, of Wyche 5
4606102 2233022 2233022 defendant Walker Baldwin   586843 586843 Walker, Baldwin, of Wyche 4
4606109 2233023 2233023 defendant Walker Baldwin   586843 586843 Walker, Baldwin, of Wyche 4
4608602 2233795 2233795 plaintiff Braas John   586843 586843 Braas, John, of Wyche 0
4608604 2233796 2233796 plaintiff Braas John   586843 586843 Braas, John, of Wyche 0
4630030 2240310 2240310 defendant Bake William   586843 586843 Bake, William, of Wyche 0
4634624 2241679 2241679 plaintiff Braas John esq 586843 586843 (Braas, John, of Wyche, esq 1
4634625 2241679 2241679 plaintiff Whitenhurst Thomas   586843 586843 Whitenhurst, Thomas, of Wyche, parson of St Andrew's church 2
4634635 2241680 2241680 plaintiff Braas John esq 586843 586843 (Braas, John, of Wyche, esq 1
4634636 2241680 2241680 plaintiff Whitenhurst Thomas   586843 586843 Whitenhurst, Thomas, of Wyche, parson of the church of St Andrew 2
4637362 2242483 2242483 defendant Boteller William   586843 586843 Boteller, William, of Wyche, Worcs not identical with Boteller, William of Andevere, Southampton, former servant of Thomas Skelton, knight 0
4683031 2260306 2260306 defendant Weler William (legal representative) 586843 586843 Weler, William, of Wyche, executrix of 1
4734004 2275821 2275821 defendant Louche William gent 586843 586843 Louche, William, of Wyche, gent 0
4734445 2275942 2275942 defendant Fenyll Walter   586843 586843 Fenyll, Walter, of Wyche, pedlar 1
4747809 2279866 2279866 plaintiff Lenche John   586843 586843 Lenche, John, of Wyche, on his own account 0
4779688 2289635 2289635 defendant Alcestre John plumber 586843 586843 Alcestre, John, of Wyche, plumber 0
4782523 2290543 2290543 defendant Glover Nicholas glover 586843 586843 Glover, Nicholas, of Wyche, glover 0
4782525 2290543 2290543 defendant Smyth William smith 586843 586843 Smyth, William, of Wyche, smith 2
4801195 2296557 2296557 defendant Froxemere William, junior gent 586843 586843 Froxemere, William, junior, of Wyche, gent 0
4801197 2296558 2296558 defendant Clent Thomas gent 586843 586843 Clent, Thomas, of Wyche, gent 0
4801311 2296600 2296600 defendant Egge Peter yeoman 586843 586843 Egge, Peter, of Wyche, yeoman 0
4801315 2296601 2296601 defendant Egge Peter yeoman 586843 586843 Egge, Peter, of Wyche, yeoman 0
4802876 2297088 2297088 defendant Kendale Thomas mercer 586843 586843 Kendale, Thomas, of Wyche, mercer 0
4817541 2301577 2301577 defendant Brase Elizabeth widow 586843 586843 Brase, Elizabeth, of Wyche, widow 1
4827875 2304773 2304773 defendant Wheler John butcher 586843 586843 Wheler, John, of Wyche, butcher 0
4861237 2314881 2314881 defendant Bladon John yeoman 586843 586843 Bladon, John, of Wyche, yeoman 0
4861239 2314881 2314881 defendant Jerveys Agnes widow 586843 586843 Jerveys, Agnes, of Wyche, widow 2
4872720 2318418 2318418 defendant Beo John clerk 586843 586843 Beo, John, of Wyche, clerk 0
4873644 2318696 2318696 defendant Swaynsey John butcher 586843 586843 Swaynsey, John, of Wyche, butcher 1
4881728 2321182 2321182 defendant Oswestre John laborer 586843 586843 Oswestre, John, of Wyche, laborer 9
4922153 2333342 2333342 plaintiff Lenche John   586843 586843 Lenche, John, of Wyche 0
4938016 2338262 2338262 defendant Wheler John husbandman 586843 586843 Wheler, John, of Wyche, husbandman 1
4938019 2338263 2338263 defendant Horton Richard husbandman 586843 586843 Horton, Richard, of Wyche, husbandman 1
4959930 2344931 2344931 defendant Elwyn Thomas baker 586843 586843 Elwyn, Thomas, of Wyche, baker 0
4964865 2346407 2346407 plaintiff Coly Thomas clerk 586843 586843 Coly, Thomas, of Wyche, clerk 0
4964866 2346407 2346407 defendant Chaloner Henry weaver 586843 586843 Chaloner, Henry, of Wyche, weaver 0
4983602 2352016 2352016 defendant Bagot Edward yeoman 586843 586843 Bagot, Edward, of Wyche, yeoman 0
4987687 2353280 2353280 plaintiff Bladon John   586843 586843 Bladon, John, of Wyche 0
5032924 2366517 2366517 defendant Page John smith 586843 586843 Page, John, of Wyche, smith 0
5041557 2369077 2369077 defendant Gey William husbandman 586843 586843 Gey, William, of Wyche, husbandman 0
5060608 2374752 2374752 defendant Heche John yeoman 586843 586843 Heche, John, of Wyche, yeoman 1
5060611 2374753 2374753 defendant Heche John   586843 586843 Heche, John, of Wyche, yeoman, bailiff of Wyche 1
5060618 2374754 2374754 defendant Hethe John yeoman and bailiff 586843 586843 Hethe, John, of Wyche, yeoman and bailiff 1
5121492 2392718 2392718 defendant Thomson Richrd gent 586843 586843 Thomson, Richrd, of Wyche, gent 13
5135266 2396813 2396813 defendant Burnyngell Isabel widow 586843 586843 Burnyngell, Isabel, of Wyche, widow 0
5179069 2409607 2409607 defendant Wheler John butcher 586843 586843 Wheler, John, of Wyche, butcher 0
5198708 2415375 2415375 defendant Dragon Thomas husbandman 586843 586843 Dragon, Thomas, of Wyche, husbandman 1
5198709 2415375 2415375 defendant Borowe Robert tailor 586843 586843 Borowe, Robert, of Wyche, tailor 2
5210737 2418872 2418872 defendant Dragon Thomas husbandman 586843 586843 Dragon, Thomas, of Wyche, husbandman 1
5210738 2418872 2418872 defendant Borowe Robert tailor 586843 586843 Borowe, Robert, of Wyche, tailor 2
5249168 2429878 2429878 plaintiff Tommesson Richard   586843 586843 Tommesson, Richard, of Wyche 0
5254338 2431487 2431487 defendant Wynter William gent 586843 586843 Wynter, William, of Wyche, gent 0
5272789 2437118 2437118 defendant Gay John gent 586843 586843 Gay, John, of Wyche, gent 0
5309052 2447744 2447744 defendant _nnar_ R_ clerk 586843 586843 _nnar_, R_, of Wyche, clerk 0
5309053 2447744 2447744 defendant Home Thomas yeoman 586843 586843 Home, Thomas, of Wyche, yeoman 1
5312183 2448678 2448678 defendant Gay John gent 586843 586843 Gay, John, of Wyche, gent 0
5347985 2459511 2459511 defendant Walker John yeoman 586843 586843 Walker, John, of Wyche, yeoman 0
5497784 2504278 2504278 defendant Home Thomas husbandman 586843 586843 (Home, Thomas, of Wyche, husbandman 1
5532974 2514856 2514856 plaintiff Walker Thomas (legal representative) 586843 586843 Walker, Thomas, of Wyche, executrix of 0
5585186 2530436 2530436 defendant Hawxe William weaver 586843 586843 Hawxe, William, of Wyche, weaver 0
5611559 2547349 2547349 plaintiff Braas Hugh   586843 586843 Braas, Hugh, of Wyche 0
5613956 2548135 2548135 defendant Austyn William   586843 586843 Austyn, William, of Wyche 0
5618649 2549670 2549670 defendant Dragon Thomas   586843 586843 Dragon, Thomas, of Wyche 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);