names

66 rows where place_id = 758055

✎ 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
4151398 2078612 2078612 defendant Hassard Robert   758055 758055 Hassard, Robert, of Brideport, yeoman, his son 1
4388683 2160848 2160848 defendant Waye Stephen yeoman 758055 758055 Waye, Stephen, of Brideport, or of Poorstocke, yeoman 0
4450809 2185218 2185218 plaintiff Hayward John   758055 758055 Hayward, John, of Brideport 0
4477845 2193739 2193739 defendant Shepwyke John chaplain 758055 758055 Shepwyke, John, of Brideport, chaplain 0
4487016 2196662 2196662 plaintiff Seymour John   758055 758055 Seymour, John, of Brideport 0
4501930 2201204 2201204 plaintiff Marchell William   758055 758055 Marchell, William, of Brideport 0
4501931 2201204 2201204 defendant Russell Joan   758055 758055 Russell, Joan, of Brideport 0
4504758 2202030 2202030 plaintiff Saymour John   758055 758055 Saymour, John, of Brideport 0
4505347 2202202 2202202 plaintiff Sore John   758055 758055 Sore, John, of Brideport, burgess 0
4508938 2203272 2203272 defendant Beymynstre Thomas   758055 758055 Beymynstre, Thomas, of Brideport 2
4510180 2203670 2203670 plaintiff Barbour Nicholas   758055 758055 Barbour, Nicholas, of Brideport 0
4519713 2206521 2206521 defendant Aungere Richard   758055 758055 Aungere, Richard, of Brideport 0
4519714 2206521 2206521 defendant Kene John   758055 758055 Kene, John, of Brideport 1
4532494 2210431 2210431 plaintiff Proteys John (legal representative) 758055 758055 Proteys, John, of Brideport, executors of 0
4542864 2213658 2213658 defendant Chelke Nicholas barber 758055 758055 Chelke, Nicholas, of Brideport, barber 0
4549689 2215836 2215836 plaintiff Couk John (legal representative) 758055 758055 Couk, John, of Brideport, executors of 0
4550013 2215940 2215940 plaintiff Cronke John (legal representative) 758055 758055 Cronke, John, of Brideport, executors of 0
4550018 2215941 2215941 plaintiff Cronke John (legal representative) 758055 758055 Cronke, John, of Brideport, executors of 0
4562755 2219910 2219910 plaintiff Proteys John (legal representative) 758055 758055 Proteys, John, of Brideport, executors of 0
4563823 2220254 2220254 defendant atte Forde Simon   758055 758055 atte Forde, Simon, of Brideport 0
4569497 2222045 2222045 defendant Bemynstre Thomas   758055 758055 Bemynstre, Thomas, of Brideport 0
4588549 2227789 2227789 plaintiff Knyght John   758055 758055 Knyght, John, of Brideport 0
4591828 2228799 2228799 plaintiff Mountfort William   758055 758055 Mountfort, William, of Brideport 0
4595903 2229975 2229975 plaintiff Rogers John   758055 758055 Rogers, John, of Brideport 0
4611093 2234534 2234534 defendant Power Nicholas   758055 758055 Power, Nicholas, of Brideport 0
4614213 2235458 2235458 plaintiff Draper Gilbert   758055 758055 Draper, Gilbert, of Brideport 0
4624099 2238516 2238516 plaintiff Mountfort William   758055 758055 Mountfort, William, of Brideport 0
4627495 2239532 2239532 plaintiff Rogger John   758055 758055 Rogger, John, of Brideport 0
4628126 2239726 2239726 defendant Golhop Robert   758055 758055 Golhop, Robert, of Brideport 0
4665726 2250754 2250754 plaintiff Hore William   758055 758055 Hore, William, of Brideport 0
4674157 2257523 2257523 defendant Draper Adam draper 758055 758055 Draper, Adam, of Brideport, draper 0
4674191 2257535 2257535 defendant Draper Adam draper 758055 758055 Draper, Adam, of Brideport, draper 2
4682189 2260052 2260052 plaintiff Muntfort William   758055 758055 Muntfort, William, of Brideport, on his own account 0
4685078 2260933 2260933 defendant atte Forde Simon merchant 758055 758055 atte Forde, Simon, of Brideport, merchant 0
4768319 2286063 2286063 plaintiff Mountfort William   758055 758055 Mountfort, William, of Brideport 0
4782814 2290642 2290642 defendant atte Forde Simon merchant 758055 758055 atte Forde, Simon, of Brideport, merchant 0
4782816 2290643 2290643 defendant atte Forde Simon merchant 758055 758055 atte Forde, Simon, of Brideport, merchant 0
4792844 2293851 2293851 defendant Stampe John (legal representative) 758055 758055 Stampe, John, of Brideport, executor of 3
4799401 2295992 2295992 defendant Carberd Robert husbandman 758055 758055 Carberd, Robert, of Brideport, groom, Baker, Thomas, of Bridport, husbandman 3
4804794 2297699 2297699 defendant Bere John fisher 758055 758055 Bere, John, of Brideport, fisher 2
4817747 2301636 2301636 plaintiff Mountfort William merchant 758055 758055 Mountfort, William, of Brideport, merchant, on his own account 0
4817750 2301637 2301637 plaintiff Mountfort William merchant 758055 758055 Mountfort, William, of Brideport, merchant, on his own account 0
4817756 2301638 2301638 plaintiff Mountfort William merchant 758055 758055 Mountfort, William, of Brideport, merchant, on his own account 0
4825091 2303889 2303889 defendant Mountfort William merchant 758055 758055 Mountfort, William, of Brideport, merchant 0
4825096 2303891 2303891 defendant Helyer John clerk 758055 758055 Helyer, John, of Brideport, clerk 0
4858451 2314017 2314017 plaintiff Broun Roger   758055 758055 Broun, Roger, of Brideport 0
4875036 2319141 2319141 plaintiff Rogger or Rogers John merchant 758055 758055 Rogger or Rogers, John, of Brideport, merchant 0
4879057 2320379 2320379 defendant atte Forde Simon husbandman 758055 758055 atte Forde, Simon, of Brideport, husbandman 0
4879059 2320380 2320380 defendant Goldsmyth Richard   758055 758055 Goldsmyth, Richard, of Brideport, "scoser" 0
4884787 2322143 2322143 defendant Milleward John husbandman 758055 758055 Milleward, John, of Brideport, husbandman 0
4891223 2323989 2323989 defendant Fleccher Nicholas roper 758055 758055 Fleccher, Nicholas, of Brideport, roper 0
4897976 2326034 2326034 defendant Bonamy John clerk 758055 758055 Bonamy, John, of Brideport, clerk 0
4989052 2353664 2353664 plaintiff Broune Roger   758055 758055 Broune, Roger, of Brideport 0
5001932 2357465 2357465 plaintiff Mountford William (legal representative) 758055 758055 Mountford, William, of Brideport, merchant, executors of 0
5013978 2360945 2360945 defendant Mankeswyll John husbandman 758055 758055 Mankeswyll, John, of Brideport, husbandman 0
5035829 2367336 2367336 defendant Helyer John clerk 758055 758055 Helyer, John, of Brideport, clerk 3
5131005 2395552 2395552 defendant Blankepayn John fisher 758055 758055 Blankepayn, John, of Brideport, fisher 1
5144889 2399653 2399653 defendant Styklan Thomas (legal representative) 758055 758055 Styklan, Thomas, of Brideport, merchant, executor of 0
5150502 2401283 2401283 defendant Blankepayn John fisherman 758055 758055 Blankepayn, John, of Brideport, fisherman 1
5151085 2401460 2401460 defendant Bittisgate John merchant 758055 758055 Bittisgate, John, of Brideport, merchant 0
5171653 2407430 2407430 defendant Bytelysgate John merchant 758055 758055 Bytelysgate, John, of Brideport, merchant 2
5171655 2407430 2407430 defendant Byrge John laborer 758055 758055 Byrge, John, of Brideport, laborer 4
5190318 2412912 2412912 defendant Bytelysgate John merchant 758055 758055 Bytelysgate, John, of Brideport, merchant 2
5252827 2430997 2430997 defendant Biddysgate John merchant 758055 758055 Biddysgate, John, of Brideport, merchant 2
5371847 2466779 2466779 plaintiff Hyllyng John   758055 758055 Hyllyng, John, of Brideport 0
5618481 2549604 2549604 defendant Dyere Peter   758055 758055 Dyere, Peter, of Brideport 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);