names

74 rows where place_id = 760667

✎ 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
4472102 2191941 2191941 plaintiff Clerk Robert   760667 760667 Clerk, Robert, of Walshale 0
4472558 2192086 2192086 plaintiff Coleson William   760667 760667 Coleson, William, of Walshale 0
4501909 2201197 2201197 plaintiff Marchall William   760667 760667 Marchall, William, of Walshale 0
4506390 2202495 2202495 defendant Burbber Robert   760667 760667 Burbber, Robert, of Walshale 1
4506391 2202495 2202495 defendant Page John chaplain 760667 760667 Page, John, of Walshale, chaplain 2
4506394 2202496 2202496 defendant Grubber Robert   760667 760667 Grubber, Robert, of Walshale 1
4506395 2202496 2202496 defendant Page John chaplain 760667 760667 Page, John, of Walshale, chaplain 2
4525025 2208168 2208168 plaintiff Kyllyngworth William   760667 760667 Kyllyngworth, William, of Walshale 1
4525030 2208169 2208169 plaintiff Kyllyngworth William   760667 760667 Kyllyngworth, William, of Walshale 1
4528367 2209145 2209145 plaintiff Marchall William   760667 760667 Marchall, William, of Walshale 0
4541095 2213120 2213120 defendant atte Siche John   760667 760667 atte Siche, John, of Walshale 3
4581134 2225582 2225582 defendant Walton Warren   760667 760667 Walton, Warren, of Walshale 1
4591947 2228835 2228835 defendant Filkes John   760667 760667 Filkes, John, of Walshale 0
4594040 2229398 2229398 defendant Cole John   760667 760667 Cole, John, of Walshale 0
4602829 2232100 2232100 defendant Goselyng Richard   760667 760667 Goselyng, Richard, of Walshale 0
4602832 2232101 2232101 defendant Goselynge Richard   760667 760667 Goselynge, Richard, of Walshale 0
4624117 2238522 2238522 plaintiff Cole John   760667 760667 Cole, John, of Walshale 1
4630984 2240585 2240585 defendant Unwyn Roger   760667 760667 Unwyn, Roger, of Walshale 0
4630986 2240586 2240586 defendant Unwyn Roger   760667 760667 Unwyn, Roger, of Walshale 0
4633316 2241281 2241281 defendant Cheynye Robert   760667 760667 Cheynye, Robert, of Walshale 3
4638962 2242918 2242918 defendant Harpour John   760667 760667 Harpour, John, of Walshale 3
4638971 2242919 2242919 defendant Harpour John   760667 760667 Harpour, John, of Walshale 3
4638978 2242920 2242920 defendant Broun Thomas   760667 760667 Broun, Thomas, of Walshale, nail maker 1
4638980 2242920 2242920 defendant White alias Couper William   760667 760667 White alias Couper, William, of Walshale 3
4638985 2242921 2242921 defendant Broun Thomas nayler 760667 760667 Broun, Thomas, of Walshale, nayler 1
4638987 2242921 2242921 defendant White William cooper 760667 760667 White, William, of Walshale, cooper 3
4652486 2246729 2246729 defendant Lewe Richard husbandman 760667 760667 Lewe, Richard, of Walshale, husbandman 0
4669681 2256219 2256219 plaintiff Bowedok John   760667 760667 Bowedok, John, of Walshale 0
4669684 2256220 2256220 plaintiff Bowedok John   760667 760667 Bowedok, John, of Walshale 0
4675314 2257889 2257889 defendant atte Redehill Richard baker 760667 760667 atte Redehill, Richard, of Walshale, baker 0
4699074 2265178 2265178 defendant Shelfele Robert husbandman 760667 760667 Shelfele, Robert, of Walshale, husbandman 1
4728487 2274144 2274144 defendant Fulmere John husbandman 760667 760667 Fulmere, John, of Walshale, husbandman 0
4728488 2274144 2274144 defendant Fipson Robert husbandman 760667 760667 Fipson, Robert, of Walshale, husbandman 1
4735549 2276267 2276267 defendant Page Richard   760667 760667 Page, Richard, of Walshale, franklin 0
4748092 2279951 2279951 defendant Lydyate John chapman 760667 760667 Lydyate, John, of Walshale, chapman 1
4758086 2282901 2282901 defendant Whyte William carrier 760667 760667 Whyte, William, of Walshale, carrier 3
4787329 2292108 2292108 defendant Gunston John yeoman 760667 760667 Gunston, John, of Walshale, yeoman 0
4791556 2293451 2293451 defendant Phippeson Robert   760667 760667 Phippeson, Robert, of Walshale, "lymemaker" 0
4791557 2293451 2293451 defendant Swaynes John laborer 760667 760667 Swaynes, John, of Walshale, laborer 1
4800184 2296232 2296232 defendant Ludeyate John yeoman 760667 760667 Ludeyate, John, of Walshale, yeoman 0
4822960 2303265 2303265 plaintiff Sporyour Roger   760667 760667 Sporyour, Roger, of Walshale 0
4854933 2312897 2312897 defendant Neuford William chapman 760667 760667 Neuford, William, of Walshale, chapman 1
4918758 2332379 2332379 defendant Bailly John chapman 760667 760667 Bailly, John, of Walshale, chapman 0
4932333 2336512 2336512 defendant Dore William   760667 760667 Dore, William, of Walshale, iron worker 0
4932334 2336512 2336512 defendant Roper John tailor 760667 760667 Roper, John, of Walshale, tailor 1
4932335 2336512 2336512 defendant Lowe William butcher 760667 760667 Lowe, William, of Walshale, butcher 2
4932336 2336512 2336512 defendant Barker Richard tanner 760667 760667 Barker, Richard, of Walshale, tanner 3
4932337 2336512 2336512 defendant Balle John carpneter 760667 760667 Balle, John, of Walshale, carpneter 4
4932338 2336512 2336512 defendant Sporyour John   760667 760667 Sporyour, John, of Walshale, iron worker 5
4932339 2336512 2336512 defendant Bacon John   760667 760667 Bacon, John, of Walshale, iron worker 6
4932458 2336548 2336548 defendant Bocher John butcher 760667 760667 Bocher, John, of Walshale, butcher 0
5126646 2394268 2394268 plaintiff Brasyer John belleter or bell founder 760667 760667 Brasyer, John, of Walshale, belleter or bell founder 0
5126647 2394268 2394268 plaintiff Baly Thomas   760667 760667 Baly, Thomas, of Walshale 1
5126649 2394269 2394269 plaintiff Brasyer John belleter or bell founder 760667 760667 Brasyer, John, of Walshale, belleter or bell founder 0
5126650 2394269 2394269 plaintiff Baly Thomas   760667 760667 Baly, Thomas, of Walshale 1
5145329 2399777 2399777 plaintiff Brasyer John   760667 760667 Brasyer, John, of Walshale, bell founder 0
5145332 2399778 2399778 plaintiff Brasyer John   760667 760667 Brasyer, John, of Walshale, bell founder 0
5165803 2405742 2405742 plaintiff Brasyer John belleter or bell founder 760667 760667 Brasyer, John, of Walshale, belleter or bell founder 0
5180333 2409990 2409990 plaintiff Brasyer John   760667 760667 Brasyer, John, of Walshale, bell founder 0
5212332 2419350 2419350 plaintiff Bailly John (legal representative) 760667 760667 Bailly, John, of Walshale, executor of 0
5217570 2420879 2420879 plaintiff Flaxale Nicholas   760667 760667 Flaxale, Nicholas, of Walshale 0
5278242 2438734 2438734 defendant Kemson William yeoman 760667 760667 Kemson, William, of Walshale, yeoman 0
5301823 2445501 2445501 defendant Moford John yeoman 760667 760667 Moford, John, of Walshale, yeoman 0
5330058 2454067 2454067 defendant Taillour William yeoman 760667 760667 Taillour, William, of Walshale, yeoman 0
5366714 2465243 2465243 defendant Penny Thomas yeoman 760667 760667 Penny, Thomas, of Walshale, yeoman 0
5366716 2465244 2465244 defendant Penny Thomas yeoman 760667 760667 Penny, Thomas, of Walshale, yeoman 0
5395109 2473670 2473670 defendant Staresmore John   760667 760667 Staresmore, John, of Walshale 0
5464106 2494174 2494174 defendant Wodeward John brasier 760667 760667 Wodeward, John, of Walshale, brasier 0
5472621 2496779 2496779 defendant Cook William chapman 760667 760667 Cook, William, of Walshale, chapman 0
5475689 2497723 2497723 defendant Wodeward John brasier 760667 760667 Wodeward, John, of Walshale, brasier 0
5475690 2497723 2497723 defendant Reynold William husbandman 760667 760667 Reynold, William, of Walshale, husbandman 1
5475692 2497724 2497724 defendant Wodeward John tanner 760667 760667 Wodeward, John, of Walshale, tanner 0
5475695 2497724 2497724 defendant Reynold William husbandman 760667 760667 Reynold, William, of Walshale, husbandman 3
5626883 2552381 2552381 defendant Bubberok John chaplain 760667 760667 Bubberok, John, of Walshale, chaplain 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);