names

147 rows where place_id = 592519

✎ 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
3588609 1864081 1864081 defendant Mylys Thomas husbandman 592519 592519 Mylys, Thomas, of Wyke, Leomynster, husbandman 3
3607946 1870134 1870134 defendant Ken John esq 592519 592519 Ken, John, of Wyke, esq 0
3668311 1916037 1916037 defendant Smyth Robert yeoman 592519 592519 Smyth, Robert, of Wyke, yeoman 0
3711151 1929800 1929800 defendant Warman William husbandman 592519 592519 Warman, William, of Wyke, husbandman 0
3714606 1930864 1930864 defendant Ball William laborer 592519 592519 Ball, William, of Wyke, laborer 0
3721111 1932899 1932899 defendant Dun John husbandman 592519 592519 Dun, John, of Wyke, husbandman 0
3740076 1938751 1938751 defendant Pyle Richard husbandman 592519 592519 Pyle, Richard, of Wyke, husbandman 1
3778246 1950905 1950905 defendant Hardyng William husbandman 592519 592519 Hardyng, William, of Wyke, husbandman 1
3800328 1958019 1958019 defendant Orchard Thomas husbandman 592519 592519 Orchard, Thomas, of Wyke, husbandman 0
3815241 1962683 1962683 defendant Alee Thomas, senior husbandman 592519 592519 Alee, Thomas, senior, of Wyke, husbandman 0
3815242 1962683 1962683 defendant Alee Thomas, junior husbandman 592519 592519 Alee, Thomas, junior, of Wyke, husbandman 1
3834506 1968736 1968736 plaintiff Nevell William esq 592519 592519 Nevell, William, of Wyke, esq 0
3888095 1986274 1986274 defendant Lovell alias Tyler Robert tiler 592519 592519 Lovell alias Tyler, Robert, of Wyke, tiler 0
3910913 1993972 1993972 defendant Byrtt William husbandman 592519 592519 Byrtt, William, of Wyke, husbandman 0
3923402 1998133 1998133 defendant Blake John husbandman 592519 592519 Blake, John, of Wyke, husbandman 0
4059894 2045935 2045935 defendant Wyswall William yeoman 592519 592519 Wyswall, William, of Wyke, yeoman 0
4069439 2049352 2049352 plaintiff Littilhales Ralph gent 592519 592519 Littilhales, Ralph, of Wyke, gent 0
4095629 2058766 2058766 defendant Farmore John yeoman 592519 592519 Farmore, John, of Wyke, yeoman 0
4103000 2061363 2061363 plaintiff Lyttlehales John   592519 592519 Lyttlehales, John, of Wyke, yeoman, administrators of 0
4141473 2075179 2075179 defendant Borne William gent 592519 592519 (Borne, William, of Wyke, gent 1
4199808 2095484 2095484 defendant Bamburghe William   592519 592519 Bamburghe, William, of Wyke gent 0
4213948 2100400 2100400 defendant Farnold Robert yeoman 592519 592519 Farnold, Robert, of Wyke, yeoman 0
4213949 2100400 2100400 defendant Gregory John, junior husbandman 592519 592519 Gregory, John, junior, of Wyke, husbandman 1
4219563 2102345 2102345 defendant Farnold Robert yeoman 592519 592519 Farnold, Robert, of Wyke, yeoman 0
4219564 2102345 2102345 defendant Gregory John, junior husbandman 592519 592519 Gregory, John, junior, of Wyke, husbandman 1
4224643 2104094 2104094 defendant Morse William husbabdman 592519 592519 Morse, William, of Wyke, husbabdman 1
4241830 2110257 2110257 defendant Ames Roger husbandman 592519 592519 Ames, Roger, of Wyke Champflower, husbandman 0
4434734 2175628 2175628 defendant Taunton William de   592519 592519 Taunton, William de, of Wyke, parson 0
4435559 2175881 2175881 defendant Taunton William de   592519 592519 (Taunton, William de, of Wyke, parson 1
4439375 2181582 2181582 defendant Chapman John   592519 592519 Chapman, John, of Wyke 3
4447424 2184107 2184107 defendant Panes John   592519 592519 Panes, John, of Wyke 0
4447623 2184176 2184176 defendant Panes John   592519 592519 Panes, John, of Wyke 0
4449718 2184860 2184860 defendant Webbe Robert   592519 592519 Webbe, Robert, of Wyke 0
4457022 2187209 2187209 plaintiff Panes John   592519 592519 Panes, John, of Wyke 0
4465498 2189876 2189876 plaintiff Worthe Richard (legal representative) 592519 592519 Worthe, Richard, of Wyke, executors of 0
4547285 2215085 2215085 defendant Newell John   592519 592519 Newell, John, of Wyke 2
4550889 2216212 2216212 defendant Ricard John   592519 592519 Ricard, John, of Wyke 0
4555728 2217726 2217726 plaintiff Heyne Thomas   592519 592519 Heyne, Thomas, of Wyke 0
4564386 2220429 2220429 defendant Burn_ John   592519 592519 Burn_, John, of Wyke 1
4573378 2223206 2223206 defendant Knap John   592519 592519 Knap, John, of Wyke 0
4573381 2223207 2223207 defendant Knap John   592519 592519 Knap, John, of Wyke 0
4586528 2227195 2227195 plaintiff Heyne Thomas   592519 592519 Heyne, Thomas, of Wyke 0
4593074 2229141 2229141 defendant Wyke Richard, sen   592519 592519 Wyke, Richard, sen, of Wyke 0
4598370 2230730 2230730 plaintiff Combe John   592519 592519 Combe, John, of Wyke 2
4598375 2230731 2230731 plaintiff Combe John   592519 592519 Combe, John, of Wyke 2
4600202 2231291 2231291 defendant Wardrobe John   592519 592519 Wardrobe, John, of Wyke 0
4609593 2234098 2234098 defendant Webbe John   592519 592519 Webbe, John, of Wyke 0
4611316 2234604 2234604 plaintiff Holeway John   592519 592519 Holeway, John, of Wyke 1
4617685 2236531 2236531 defendant Webbe John   592519 592519 Webbe, John, of Wyke 12
4617973 2236628 2236628 defendant Bonde Robert   592519 592519 Bonde, Robert, of Wyke 0
4629291 2240097 2240097 defendant Pellare Thomas   592519 592519 Pellare, Thomas, of Wyke 0
4631876 2240853 2240853 defendant Apsele John   592519 592519 Apsele, John, of Wyke 2
4631880 2240854 2240854 defendant Apsele John   592519 592519 Apsele, John, of Wyke 2
4663056 2249910 2249910 defendant Gurmund Geoffrey husbandman 592519 592519 Gurmund, Geoffrey, of Wyke, husbandman 0
4669456 2256151 2256151 defendant Broun John husbandman 592519 592519 Broun, John, of Wyke, husbandman 4
4670376 2256430 2256430 defendant Corset John husbandman 592519 592519 Corset, John, of Wyke, husbandman 0
4678373 2258844 2258844 defendant Goundenham John esq 592519 592519 Goundenham, John, of Wyke, esq 0
4684681 2260809 2260809 defendant Priket Robert husbandman 592519 592519 Priket, Robert, of Wyke, husbandman 2
4695352 2264027 2264027 defendant Smert John   592519 592519 Smert, John, of Wyke 3
4695353 2264027 2264027 defendant atte Richard Water   592519 592519 atte Richard, Water, of Wyke 4
4702816 2266280 2266280 defendant Loveney William esq 592519 592519 Loveney, William, of Wyke, esq 0
4710988 2268793 2268793 defendant Baker John baker 592519 592519 Baker, John, of Wyke, baker 3
4721697 2272121 2272121 defendant Michell John husbandman 592519 592519 Michell, John, of Wyke, husbandman 1
4728455 2274132 2274132 defendant Moward William husbandman 592519 592519 Moward, William, of Wyke, husbandman 0
4735086 2276123 2276123 plaintiff Smyth John   592519 592519 Smyth, John, of Wyke 0
4758597 2283068 2283068 defendant Wodhulle John, sen husbandman 592519 592519 Wodhulle, John, sen, of Wyke, husbandman 0
4766419 2285489 2285489 defendant Chipppyngdale John husbandman 592519 592519 Chipppyngdale, John, of Wyke, husbandman 0
4775383 2288297 2288297 defendant Wodeman John husbandman 592519 592519 Wodeman, John, of Wyke, husbandman 0
4782653 2290588 2290588 defendant Otes John slater 592519 592519 Otes, John, of Wyke, slater 1
4786259 2291744 2291744 defendant Dodyngton John husbandman 592519 592519 Dodyngton, John, of Wyke, husbandman 3
4793807 2294183 2294183 defendant Scotte Thomas yeoman 592519 592519 Scotte, Thomas, of Wyke, yeoman 0
4801798 2296744 2296744 defendant Wodeman John husbandman 592519 592519 Wodeman, John, of Wyke, husbandman 0
4811270 2299633 2299633 defendant Hokkeday William husbandman 592519 592519 Hokkeday, William, of Wyke St German, husbandman 0
4813572 2300352 2300352 defendant Cook John husbandman 592519 592519 Cook, John, of Wyke, husbandman 0
4826286 2304256 2304256 defendant Hayward John husbandman 592519 592519 Hayward, John, of Wyke, husbandman 0
4846901 2310540 2310540 defendant Scot Thomas husbandman 592519 592519 Scot, Thomas, of Wyke, husbandman 0
4848629 2311045 2311045 defendant Somerset Gilbert husbandman 592519 592519 Somerset, Gilbert, of Wyke, husbandman 0
4850071 2311482 2311482 defendant Jocy Peter husbandman 592519 592519 Jocy, Peter, of Wyke, husbandman 2
4852011 2312061 2312061 defendant Burry John husbandman 592519 592519 Burry, John, of Wyke, husbandman 4
4874750 2319045 2319045 defendant Patenmaker Walter husbandman 592519 592519 Patenmaker, Walter, of Wyke, husbandman 0
4878151 2320119 2320119 defendant Mychell Nicholas husbandman 592519 592519 Mychell, Nicholas, of Wyke, husbandman 0
4905438 2328294 2328294 defendant Mychell John husbandman 592519 592519 Mychell, John, of Wyke, husbandman 0
4909021 2329364 2329364 defendant Nicoll Robert laborer 592519 592519 Nicoll, Robert, of Wyke, laborer 0
4909024 2329365 2329365 defendant Nicoll Robert laborer 592519 592519 Nicoll, Robert, of Wyke, laborer 0
4909027 2329366 2329366 defendant Tutte William husbandman 592519 592519 Tutte, William, of Wyke, husbandman 0
4909028 2329366 2329366 defendant Croucheman John husbandman 592519 592519 Croucheman, John, of Wyke, husbandman 1
4909029 2329366 2329366 defendant Heyward John husbandman 592519 592519 Heyward, John, of Wyke, husbandman 2
4922803 2333546 2333546 defendant Wyke John husbandman 592519 592519 Wyke, John, of Wyke, husbandman 0
4922805 2333546 2333546 defendant Wyke Thomas   592519 592519 Wyke, Thomas, of Wyke, groom 2
4922806 2333546 2333546 defendant Wyke Edith widow 592519 592519 Wyke, Edith, of Wyke, widow 3
4931900 2336362 2336362 defendant Nele William husbandman 592519 592519 Nele, William, of Wyke, husbandman 0
4931903 2336363 2336363 defendant Nele William husbandman 592519 592519 Nele, William, of Wyke, husbandman 0
4935901 2337620 2337620 defendant Hank or Hauk John clerk 592519 592519 Hank or Hauk, John, of Wyke, clerk 1
4951072 2342300 2342300 defendant House John husbandman 592519 592519 House, John, of Wyke, husbandman 0
4970171 2348028 2348028 defendant Adams John husbandman 592519 592519 Adams, John, of Wyke, husbandman 3
4987206 2353121 2353121 defendant Henxstrigge John   592519 592519 Henxstrigge, John, of Wyke, groom 2
5003714 2357978 2357978 defendant Hyedon John tailor 592519 592519 Hyedon, John, of Wyke St German, tailor 5
5018951 2362433 2362433 defendant Chapman John husbandman 592519 592519 Chapman, John, of Wyke, husbandman 0
5030241 2365713 2365713 defendant Hyedon John tailor 592519 592519 Hyedon, John, of Wyke St German, tailor 4
5037770 2367922 2367922 defendant Brandon John husbandman 592519 592519 (Brandon, John, of Wyke, husbandman 1

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