names

73 rows where place_id = 754521

✎ 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
4291538 2127047 2127047 defendant Key John gent 754521 754521 Key, John, of Berkshire, or of London, gent 0
4300822 2130392 2130392 defendant Meysey Thomas gent 754521 754521 Meysey, Thomas, of Berkshire, or of Shackenhurst, Worcs, gent 0
4420846 2171416 2171416 defendant Bisshop William   754521 754521 Bisshop, William, of Berkshire 3
4486495 2196485 2196485 defendant Saddet Henry   754521 754521 Saddet, Henry, of Berkshire 0
4486539 2196501 2196501 defendant Gentelecorse Nicholas   754521 754521 Gentelecorse, Nicholas, of Berkshire 0
4488867 2197235 2197235 defendant Drewe Richard   754521 754521 Drewe, Richard, of Berkshire 0
4492248 2198257 2198257 defendant Whitehors Ralph   754521 754521 Whitehors, Ralph, of Berkshire, knight 0
4496535 2199591 2199591 plaintiff Coventre William   754521 754521 Coventre, William, of Berkshire 0
4496969 2199718 2199718 defendant Piers John   754521 754521 Piers, John, of Berkshire 4
4496980 2199719 2199719 defendant Piers John   754521 754521 Piers, John, of Berkshire 4
4512889 2204463 2204463 plaintiff Braundyssh John fishmonger 754521 754521 Braundyssh, John, of Berkshire, fishmonger 0
4512892 2204464 2204464 plaintiff Braundyssh John fishmonger 754521 754521 Braundyssh, John, of Berkshire, fishmonger 0
4517491 2205866 2205866 defendant Armurer Thomas   754521 754521 Armurer, Thomas, of Berkshire 1
4517494 2205867 2205867 defendant Ar_rer Thomas   754521 754521 Ar_rer, Thomas, of Berkshire 0
4530073 2209693 2209693 defendant Rustwold Thomas   754521 754521 Rustwold, Thomas, of Berkshire 5
4539961 2212766 2212766 defendant Restweld Thomas   754521 754521 Restweld, Thomas, of Berkshire 0
4546140 2214740 2214740 defendant Wyke Robert   754521 754521 Wyke, Robert, of Berkshire 0
4546879 2214954 2214954 defendant Laurence Thomas   754521 754521 Laurence, Thomas, of Berkshire 0
4550516 2216104 2216104 defendant Bodenham Nicholas   754521 754521 Bodenham, Nicholas, of Berkshire 1
4550523 2216105 2216105 defendant Bodenham Nicholas   754521 754521 Bodenham, Nicholas, of Berkshire 1
4551063 2216275 2216275 defendant Delamare Robert esq 754521 754521 Delamare, Robert, of Berkshire, esq 0
4558635 2218654 2218654 defendant Delamare Robert esq 754521 754521 Delamare, Robert, of Berkshire, esq 1
4570128 2222229 2222229 defendant Daunvers William esq 754521 754521 Daunvers, William, of Berkshire, esq 3
4570134 2222230 2222230 defendant Daunvers William esq 754521 754521 Daunvers, William, of Berkshire, esq 3
4570159 2222239 2222239 defendant Havelyn Robert   754521 754521 Havelyn, Robert, of Berkshire 0
4570299 2222284 2222284 defendant Webbe William   754521 754521 Webbe, William, of Berkshire 1
4580445 2225370 2225370 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4580452 2225372 2225372 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 1
4581653 2225709 2225709 defendant Rothewell Thomas esq 754521 754521 Rothewell, Thomas, of Berkshire, esq 5
4581661 2225710 2225710 defendant Rothewell Thomas esq 754521 754521 Rothewell, Thomas, of Berkshire, esq 5
4590068 2228255 2228255 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4590130 2228278 2228278 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4590140 2228281 2228281 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4590142 2228282 2228282 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4590698 2228445 2228445 defendant Restwold Thomas   754521 754521 Restwold, Thomas, of Berkshire 3
4609439 2234053 2234053 defendant Coventre William   754521 754521 Coventre, William, of Berkshire 0
4615607 2235881 2235881 defendant Kirton John   754521 754521 Kirton, John, of Berkshire 2
4615616 2235883 2235883 defendant Kirton John   754521 754521 Kirton, John, of Berkshire 2
4627899 2239656 2239656 defendant Fraunce John   754521 754521 Fraunce, John, of Berkshire 3
4627905 2239657 2239657 defendant Fraunce John   754521 754521 Fraunce, John, of Berkshire 3
4632329 2240998 2240998 defendant Bodman Robert   754521 754521 Bodman, Robert, of Berkshire 4
4640106 2243225 2243225 defendant Dalamare Robert esq 754521 754521 Dalamare, Robert, of Berkshire, esq 0
4640112 2243226 2243226 defendant Delamare Robert esq 754521 754521 Delamare, Robert, of Berkshire, esq 0
4642342 2243881 2243881 defendant Ailleward Nicholas   754521 754521 Ailleward, Nicholas, of Berkshire 0
4642346 2243882 2243882 defendant Aylleward Nicholas   754521 754521 Aylleward, Nicholas, of Berkshire 0
4644456 2244465 2244465 defendant Pynman Robert   754521 754521 Pynman, Robert, of Berkshire 7
4644463 2244466 2244466 defendant Pynman Robert   754521 754521 Pynman, Robert, of Berkshire 5
4705075 2266960 2266960 plaintiff Keybok John   754521 754521 Keybok, John, of Berkshire 0
4732080 2275215 2275215 defendant Gowe Robert   754521 754521 Gowe, Robert, of Berkshire, clerk, & chancellor of Lichfield cathedral 0
4732918 2275473 2275473 defendant Cokerell Thomas gent 754521 754521 Cokerell, Thomas, of Berkshire, gent 0
4773855 2287803 2287803 defendant Morville Walter (legal representative) 754521 754521 Morville, Walter, of Berkshire, yeoman, executors of 0
4775195 2288236 2288236 plaintiff Whaddon Nicholas esq 754521 754521 Whaddon, Nicholas, of Berkshire, esq 0
4838483 2307952 2307952 plaintiff Golafre John esq 754521 754521 Golafre, John, of Berkshire, esq 0
4844705 2309861 2309861 plaintiff Newere John clerk 754521 754521 Newere, John, of Berkshire, clerk 0
4844707 2309862 2309862 plaintiff Newers John clerk 754521 754521 Newers, John, of Berkshire, clerk 0
4847967 2310843 2310843 plaintiff Sampford John clerk 754521 754521 Sampford, John, of Berkshire, clerk 0
5035301 2367186 2367186 defendant Newers John (legal representative) 754521 754521 Newers, John, of Berkshire, clerk, executor of 0
5126815 2394317 2394317 plaintiff Brocas William esq & sheriff 754521 754521 Brocas, William, of Berkshire, esq & sheriff 0
5129329 2395063 2395063 defendant Wormestall Thomas baker 754521 754521 Wormestall, Thomas, of Berkshire, baker 7
5271288 2436697 2436697 defendant Wey Roger yeoman 754521 754521 Wey, Roger, of Berkshire, yeoman 1
5271534 2436768 2436768 defendant Carpenter Richard chapman 754521 754521 Carpenter, Richard, of Berkshire, chapman 4
5274920 2437750 2437750 defendant Yate Robert husbandman 754521 754521 Yate, Robert, of Berkshire, husbandman 1
5275871 2438013 2438013 defendant Skidmore Philip chapman 754521 754521 Skidmore, Philip, of Berkshire, chapman 2
5327981 2453437 2453437 defendant Bocher John courser 754521 754521 Bocher, John, of Berkshire, courser 0
5390689 2472401 2472401 defendant Makeney Henry esq 754521 754521 Makeney, Henry, of Berkshire, esq 1
5404942 2476491 2476491 defendant Kyng Thomas   754521 754521 Kyng, Thomas, of Berkshire, esquire for the Body of the late King Edward 0
5413744 2479038 2479038 defendant Medford Luke weaver 754521 754521 Medford, Luke, of Berkshire, weaver 0
5415890 2479686 2479686 defendant Walton Thomas gent 754521 754521 Walton, Thomas, of Berkshire, gent 1
5450397 2490006 2490006 defendant Soper Thomas   754521 754521 Soper, Thomas, of Berkshire 0
5611526 2547336 2547336 defendant Cok Peter   754521 754521 Cok, Peter, of Berkshire, knight 5
5622622 2551004 2551004 defendant Gulden John   754521 754521 Gulden, John, of Berkshire 0
5633537 2554486 2554486 defendant Parker John, senior   754521 754521 Parker, John, senior, of Berkshire 0
5633538 2554486 2554486 defendant Parker John, junior   754521 754521 Parker, John, junior, of Berkshire 1

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