names

128 rows where place_id = 585882

✎ 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
3587413 1863708 1863708 defendant Morys William fuller 585882 585882 Morys, William, of Wokyngham, fuller 2
3647426 1909583 1909583 defendant Stodard Robert bellfounder 585882 585882 Stodard, Robert, of Wokyngham, bellfounder 0
3656276 1912209 1912209 plaintiff Caott Stephen mercer 585882 585882 Caott, Stephen, of Wokyngham, mercer 0
3671170 1916954 1916954 defendant Trypler John smith 585882 585882 Trypler, John, of Wokyngham, smith 0
3717733 1931846 1931846 defendant Holmys Thomas (legal representative) 585882 585882 Holmys, Thomas, of Wokyngham, fuller, executors of 0
3717734 1931846 1931846 defendant Holmys Agnes widow 585882 585882 (Holmys, Agnes, of Wokyngham, widow 1
3717735 1931846 1931846 defendant Holmys Isabel spinster 585882 585882 Holmys, Isabel, of Wokyngham, spinster 2
3717736 1931846 1931846 defendant Skelton Thomas bellfounder 585882 585882 Skelton, Thomas, of Wokyngham, bellfounder 3
3887757 1986163 1986163 defendant Markes Thomas butcher 585882 585882 Markes, Thomas, of Wokyngham, butcher 0
3896295 1988972 1988972 plaintiff Tournour John (legal representative) 585882 585882 Tournour, John, of Wokyngham, executors of 0
3933328 2001444 2001444 plaintiff Gretham William mercer 585882 585882 Gretham, William, of Wokyngham, mercer 0
4217933 2101763 2101763 defendant Dawbney Clement gent 585882 585882 Dawbney, Clement, of Wokyngham, gent 0
4217934 2101763 2101763 defendant Munck William husbandman 585882 585882 Munck, William, of Wokyngham, husbandman 1
4454634 2186466 2186466 plaintiff Mapeler John   585882 585882 Mapeler, John, of Wokyngham 0
4454635 2186466 2186466 defendant Bayl Mathew   585882 585882 Bayl, Mathew, of Wokyngham 0
4467032 2190358 2190358 defendant Dyer Robert   585882 585882 Dyer, Robert, of Wokyngham 0
4467034 2190359 2190359 defendant Dyere Robert   585882 585882 Dyere, Robert, of Wokyngham 0
4468643 2190864 2190864 defendant Ladde William   585882 585882 Ladde, William, of Wokyngham 0
4501018 2200920 2200920 defendant Porter Robert   585882 585882 Porter, Robert, of Wokyngham 0
4505708 2202294 2202294 defendant atte Merssh Richard   585882 585882 atte Merssh, Richard, of Wokyngham 0
4528931 2209327 2209327 defendant Dyere Robert   585882 585882 Dyere, Robert, of Wokyngham 1
4552044 2216591 2216591 defendant Clerc Thomas   585882 585882 Clerc, Thomas, of Wokyngham 1
4568275 2221648 2221648 defendant Dyere Robert   585882 585882 Dyere, Robert, of Wokyngham 0
4568276 2221648 2221648 defendant Blakman Thomas   585882 585882 Blakman, Thomas, of Wokyngham 1
4568277 2221648 2221648 defendant Blakman William   585882 585882 Blakman, William, of Wokyngham 2
4568278 2221648 2221648 defendant Blakman Henry   585882 585882 Blakman, Henry, of Wokyngham 3
4572941 2223075 2223075 plaintiff Bailly Mathew   585882 585882 Bailly, Mathew, of Wokyngham 0
4573017 2223095 2223095 plaintiff Baker William   585882 585882 Baker, William, of wokyngham 0
4573018 2223095 2223095 defendant Bounde Richard tailor 585882 585882 Bounde, Richard, of Wokyngham, tailor 0
4608494 2233764 2233764 defendant Dier Henry   585882 585882 Dier, Henry, of Wokyngham 3
4661069 2249286 2249286 defendant Hethe Thomas skinner 585882 585882 Hethe, Thomas, of Wokyngham, skinner 1
4678805 2258975 2258975 defendant atte Mill William husbandman 585882 585882 atte Mill, William, of Wokyngham, husbandman 0
4702595 2266221 2266221 defendant Tanner Thomas tanner 585882 585882 Tanner, Thomas, of Wokyngham, tanner 0
4730710 2274802 2274802 defendant Bokhurst Henry husbandman 585882 585882 Bokhurst, Henry, of Wokyngham, husbandman 3
4730711 2274802 2274802 defendant Broun Christine widow 585882 585882 Broun, Christine, of Wokyngham, widow 4
4748157 2279971 2279971 defendant Fashakerley Simon   585882 585882 Fashakerley, Simon, of Wokyngham, bailiff 2
4785984 2291654 2291654 defendant Drover Roger farmer 585882 585882 Drover, Roger, of Wokyngham, farmer 0
4815036 2300813 2300813 defendant Stonhill Richard husbandman 585882 585882 Stonhill, Richard, of Wokyngham, husbandman 0
4876150 2319499 2319499 defendant George William tailor 585882 585882 George, William, of Wokyngham, tailor 0
5013513 2360790 2360790 defendant Chaundeler Richard husbandman 585882 585882 Chaundeler, Richard, of Wokyngham, husbandman 0
5013514 2360790 2360790 defendant Martyn John butcher 585882 585882 Martyn, John, of Wokyngham, butcher 1
5057394 2373781 2373781 defendant Honoure Stephen chapman or draper 585882 585882 Honoure, Stephen, of Wokyngham, chapman or draper 0
5064112 2375803 2375803 defendant Smewyn Henry   585882 585882 Smewyn, Henry, of Wokyngham 0
5065202 2376128 2376128 defendant Moors John yeoman 585882 585882 Moors, John, of Wokyngham, yeoman 0
5066173 2376408 2376408 defendant Honor Stephen draper 585882 585882 Honor, Stephen, of Wokyngham, draper 1
5075541 2379180 2379180 defendant Walssh William husbandman 585882 585882 Walssh, William, of Wokyngham, husbandman 0
5075543 2379181 2379181 defendant Walssh William husbandman 585882 585882 Walssh, William, of Wokyngham, husbandman 0
5076748 2379546 2379546 defendant Mason John yeoman 585882 585882 Mason, John, of Wokyngham, yeoman 0
5076749 2379546 2379546 defendant Howgham John gent 585882 585882 Howgham, John, of Wokyngham, gent 1
5076750 2379546 2379546 defendant Bullok John   585882 585882 Bullok, John, of Wokyngham, mason 2
5076751 2379546 2379546 defendant Chapman William laborer 585882 585882 Chapman, William, of Wokyngham, laborer 3
5076752 2379546 2379546 defendant Wytton Richard laborer 585882 585882 Wytton, Richard, of Wokyngham, laborer 4
5086649 2382488 2382488 defendant Sewall Thomas yeoman 585882 585882 Sewall, Thomas, of Wokyngham, yeoman 0
5086650 2382488 2382488 defendant Landen Roger   585882 585882 Landen, Roger, of Wokyngham, bell maker 1
5088442 2382995 2382995 defendant Landen Roger bellfounder 585882 585882 Landen, Roger, of Wokyngham, bellfounder 0
5088443 2382995 2382995 defendant Morys John husbandman 585882 585882 Morys, John, of Wokyngham, husbandman 1
5090453 2383587 2383587 defendant Roberdyssemanservant John   585882 585882 Roberdyssemanservant, John, of Wokyngham, servant 0
5102142 2387053 2387053 defendant Seman Robert saddler 585882 585882 Seman, Robert, of Wokyngham, saddler 0
5120575 2392447 2392447 defendant Crust Peter shoemaker 585882 585882 Crust, Peter, of Wokyngham, shoemaker 2
5126817 2394317 2394317 defendant Lynne George yeoman 585882 585882 Lynne, George, of Wokyngham, yeoman 1
5145511 2399831 2399831 defendant Lynne George yeoman 585882 585882 Lynne, George, of Wokyngham, yeoman 1
5165916 2405776 2405776 defendant Lynne George yeoman 585882 585882 Lynne, George, of Wokyngham, yeoman 1
5185543 2411522 2411522 defendant Morys Nicholas   585882 585882 Morys, Nicholas, of Wokyngham, bell maker 1
5193652 2413871 2413871 plaintiff Person John   585882 585882 Person, John, of Wokyngham, mason 0
5196054 2414593 2414593 defendant Barnes Richard tailor 585882 585882 Barnes, Richard, of Wokyngham, tailor 1
5196057 2414594 2414594 defendant Barnes Richard tailor 585882 585882 Barnes, Richard, of Wokyngham, tailor 1
5204825 2417163 2417163 defendant Morys Nicholas   585882 585882 Morys, Nicholas, of Wokyngham, bell maker 1
5209496 2418517 2418517 defendant Bernes Richarad tailor 585882 585882 Bernes, Richarad, of Wokyngham, tailor 1
5209499 2418518 2418518 defendant Barnes Richard tailor 585882 585882 Barnes, Richard, of Wokyngham, tailor 1
5209502 2418519 2418519 defendant Barnes Richard tailor 585882 585882 Barnes, Richard, of Wokyngham, tailor 1
5238281 2426780 2426780 defendant Hale William fuller 585882 585882 Hale, William, of Wokyngham, fuller 0
5274641 2437661 2437661 defendant Hatthe Richard (legal representative) 585882 585882 Hatthe, Richard, of Wokyngham, chapman, executors of 3
5302172 2445607 2445607 defendant Launden Roger   585882 585882 Launden, Roger, of Wokyngham 0
5313998 2449208 2449208 defendant Seriche John draper 585882 585882 Seriche, John, of Wokyngham, draper 0
5313999 2449208 2449208 defendant Michell John bellfounder 585882 585882 Michell, John, of Wokyngham, bellfounder 1
5328333 2453549 2453549 defendant Frith Nicholas tilemaker 585882 585882 Frith, Nicholas, of Wokyngham, tilemaker 3
5328339 2453550 2453550 defendant Frith Nicholas   585882 585882 Frith, Nicholas, of Wokyngham, tile maker 3
5358904 2462835 2462835 defendant Water John laborer 585882 585882 Water, John, of Wokyngham, laborer 0
5358906 2462835 2462835 defendant Wykys William weaver 585882 585882 Wykys, William, of Wokyngham, weaver 2
5359559 2463025 2463025 defendant Nubery John butcher 585882 585882 Nubery, John, of Wokyngham, butcher 0
5383319 2470306 2470306 defendant Milys John   585882 585882 Milys, John, of Wokyngham 0
5387192 2471406 2471406 defendant Landen Roger   585882 585882 Landen, Roger, of Wokyngham, bell founder 0
5387193 2471406 2471406 defendant Godewyn Richard shoemaker 585882 585882 Godewyn, Richard, of Wokyngham, shoemaker 1
5390483 2472340 2472340 plaintiff Michell John   585882 585882 Michell, John, of Wokyngham 0
5392719 2472984 2472984 defendant Mosse William fuller 585882 585882 Mosse, William, of Wokyngham, fuller 2
5399619 2474974 2474974 defendant Landen Roger   585882 585882 Landen, Roger, of Wokyngham, bell founder 0
5399620 2474974 2474974 defendant Goodwyn Richard   585882 585882 Goodwyn, Richard, of Wokyngham, shoe maker 1
5399622 2474975 2474975 defendant Landen Roger   585882 585882 Landen, Roger, of Wokyngham, bell founder 0
5399623 2474975 2474975 defendant Goodwyn Richard   585882 585882 Goodwyn, Richard, of Wokyngham, shoe maker 1
5404659 2476409 2476409 defendant Mylys John mercer 585882 585882 Mylys, John, of Wokyngham, mercer 0
5404708 2476425 2476425 defendant Michell John   585882 585882 Michell, John, of Wokyngham, bell founder 1
5405796 2476729 2476729 defendant Tangle Thomas husbandman 585882 585882 Tangle, Thomas, of Wokyngham, husbandman 0
5405797 2476729 2476729 defendant Mosse William fuller 585882 585882 Mosse, William, of Wokyngham, fuller 1
5412640 2478727 2478727 defendant Landon Roger   585882 585882 Landon, Roger, of Wokyngham, bell founder 0
5412641 2478727 2478727 defendant Godewyn Richard shoemaker 585882 585882 Godewyn, Richard, of Wokyngham, shoemaker 1
5416489 2479850 2479850 plaintiff Michell John   585882 585882 Michell, John, of Wokyngham 0
5416490 2479850 2479850 defendant Glover Hugh   585882 585882 Glover, Hugh, of Wokyngham, bell founder 0
5418797 2480547 2480547 defendant Tangle Thomas husbandman 585882 585882 Tangle, Thomas, of Wokyngham, husbandman 0
5418798 2480547 2480547 defendant Mosse William fuller 585882 585882 Mosse, William, of Wokyngham, fuller 1
5418801 2480548 2480548 defendant Tangle Thomas husbandman 585882 585882 Tangle, Thomas, of Wokyngham, husbandman 0

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