names

87 rows where place_id = 682380

✎ 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
4049409 2042234 2042234 plaintiff Tyggyn Richard merchant 682380 682380 Tyggyn, Richard, of Brydeport, merchant 0
4433737 2175316 2175316 defendant Wydecumbe John   682380 682380 Wydecumbe, John, of Brydeport 0
4458121 2187572 2187572 plaintiff Proteys John   682380 682380 Proteys, John, of Brydeport 0
4473585 2192398 2192398 defendant Byle John   682380 682380 Byle, John, of Brydeport 0
4476662 2193361 2193361 defendant Crouke John   682380 682380 Crouke, John, of Brydeport 0
4513398 2204607 2204607 defendant Palmer John   682380 682380 Palmer, John, of Brydeport 0
4521394 2207035 2207035 defendant Deighere Richard   682380 682380 Deighere, Richard, of Brydeport 0
4540518 2212931 2212931 defendant Bemystre Thomas   682380 682380 Bemystre, Thomas, of Brydeport 0
4624001 2238486 2238486 defendant Ball William   682380 682380 Ball, William, of Brydeport 0
4634169 2241531 2241531 defendant atte Forde Simon   682380 682380 atte Forde, Simon, of Brydeport 0
4671573 2256754 2256754 defendant Curll John, senior laborer 682380 682380 with Curll, John, senior, of Brydeport, laborer 1
4671574 2256754 2256754 defendant Kyng John laborer 682380 682380 Kyng, John, of Brydeport, laborer 2
4671575 2256754 2256754 defendant Muleward John   682380 682380 Muleward, John, of Brydeport, milward 3
4671576 2256754 2256754 defendant Paule William shoemaker 682380 682380 Paule, William, of Brydeport, shoemaker 4
4673462 2257338 2257338 defendant Warde John fisher 682380 682380 Warde, John, of Brydeport, fisher 2
4678202 2258791 2258791 defendant Pryour John fisher 682380 682380 Pryour, John, of Brydeport, fisher 0
4678203 2258791 2258791 defendant Mountford William merchant 682380 682380 Mountford, William, of Brydeport, merchant 1
4682088 2260018 2260018 plaintiff Mounfort William merchant 682380 682380 Mounfort, William, of Brydeport, merchant, on his own account 0
4682109 2260025 2260025 plaintiff Mountford William merchant 682380 682380 Mountford, William, of Brydeport, merchant, on his own account 0
4684570 2260776 2260776 defendant Lombe Williamm chapman 682380 682380 Lombe, Williamm, of Brydeport, chapman 0
4690697 2262637 2262637 defendant Bastyan John laborer 682380 682380 Bastyan, John, of Brydeport, laborer 2
4703368 2266432 2266432 defendant Stamp John gent 682380 682380 Stamp, John, of Brydeport, gent 0
4736954 2276686 2276686 defendant Carberd Robert   682380 682380 Carberd, Robert, of Brydeport, groom 1
4748910 2280173 2280173 plaintiff Mountfort William merchant 682380 682380 Mountfort, William, of Brydeport, merchant, on his own account 0
4748918 2280174 2280174 plaintiff Mountfort William merchant 682380 682380 Mountfort, William, of Brydeport, merchant, on his own account 0
4748922 2280174 2280174 defendant Draper Adam husbandman 682380 682380 Draper, Adam, of Brydeport, husbandman 3
4752812 2281277 2281277 defendant Carberd Robert   682380 682380 Carberd, Robert, of Brydeport, groom 5
4752814 2281277 2281277 defendant Barbour John barber 682380 682380 Barbour, John, of Brydeport, barber 7
4778811 2289346 2289346 defendant Smyth Robert smith 682380 682380 Smyth, Robert, of Brydeport, smith 0
4779496 2289566 2289566 plaintiff Bowle Adam (legal representative) 682380 682380 Bowle, Adam, of Brydeport, executors of 0
4792837 2293850 2293850 plaintiff Mountfort William merchant 682380 682380 Mountfort, William, of Brydeport, merchant 0
4792840 2293851 2293851 plaintiff Mountfort William merchant 682380 682380 Mountfort, William, of Brydeport, merchant 0
4794575 2294443 2294443 defendant Bonevyle Robert husbandman 682380 682380 Bonevyle, Robert, of Brydeport, husbandman 5
4802795 2297062 2297062 defendant Bere John husbandman 682380 682380 Bere, John, of Brydeport, husbandman 1
4806327 2298189 2298189 defendant Tracy William gent 682380 682380 Tracy, William, of Brydeport, gent 0
4831575 2305909 2305909 plaintiff Broun Roger   682380 682380 Broun, Roger, of Brydeport 0
4858352 2313984 2313984 plaintiff Bron alias Clerk Roger   682380 682380 Bron alias Clerk, Roger, of Brydeport 0
4859003 2314196 2314196 plaintiff But John   682380 682380 But, John, of Brydeport 0
4864154 2315763 2315763 defendant Russell Nicholas husbandman 682380 682380 Russell, Nicholas, of Brydeport, husbandman 0
4874378 2318928 2318928 plaintiff Pyres John   682380 682380 Pyres, John, of Brydeport 0
4890255 2323722 2323722 plaintiff Crouk John (legal representative) 682380 682380 Crouk, John, of Brydeport, executors of 0
4912726 2330486 2330486 defendant Maukiswelle John butcher 682380 682380 Maukiswelle, John, of Brydeport, butcher 0
4917876 2332102 2332102 defendant Peny Geoffrey husbandman 682380 682380 Peny, Geoffrey, of Brydeport, husbandman 1
4937196 2338003 2338003 plaintiff Broune Roger merchant 682380 682380 Broune, Roger, of Brydeport, merchant 0
4949078 2341703 2341703 plaintiff Montfort William (legal representative) 682380 682380 Montfort, William, of Brydeport, merchant, executors of 0
4949312 2341772 2341772 plaintiff Mountford William (legal representative) 682380 682380 Mountford, William, of Brydeport, merchant, executors of 0
4956016 2343765 2343765 defendant Boleyn John, junior chapman 682380 682380 Boleyn, John, junior, of Brydeport, chapman 1
4962389 2345655 2345655 plaintiff Brome Roger   682380 682380 Brome, Roger, of Brydeport 0
4982428 2351665 2351665 defendant Boleyn John husbandman 682380 682380 Boleyn, John, of Brydeport, husbandman 0
4982429 2351665 2351665 defendant Talent William husbandman 682380 682380 Talent, William, of Brydeport, husbandman 1
4982430 2351665 2351665 defendant Carberd Robert   682380 682380 Carberd, Robert, of Brydeport, groom 2
4982431 2351665 2351665 defendant Helyer John clerk 682380 682380 Helyer, John, of Brydeport, clerk 3
5006842 2358900 2358900 defendant Halle Thomas yeoman 682380 682380 Halle, Thomas, of Brydeport, yeoman 3
5022420 2363457 2363457 defendant Nethyn John butcher 682380 682380 Nethyn, John, of Brydeport, butcher 0
5028872 2365318 2365318 plaintiff Neuton Thomas   682380 682380 Neuton, Thomas, of Brydeport 0
5030159 2365690 2365690 defendant Oure alias Gowere John husbandman 682380 682380 Oure alias Gowere, John, of Brydeport, husbandman 0
5030323 2365741 2365741 defendant Helyar John clerk 682380 682380 Helyar, John, of Brydeport, clerk 0
5043560 2369693 2369693 defendant Burgeys William   682380 682380 Burgeys, William, of Brydeport 0
5050515 2371778 2371778 defendant Clerke William husbandman 682380 682380 Clerke, William, of Brydeport, husbandman 0
5050519 2371779 2371779 defendant Helyer John clerk 682380 682380 Helyer, John, of Brydeport, clerk 0
5112463 2390032 2390032 defendant Boweley Nicholas merchant 682380 682380 Boweley, Nicholas, of Brydeport, merchant 0
5112464 2390032 2390032 defendant Boweley Christine widow 682380 682380 Boweley, Christine, of Brydeport, widow 1
5120788 2392511 2392511 defendant Hous Richard husbandman 682380 682380 Hous, Richard, of Brydeport,husbandman 0
5126349 2394188 2394188 defendant Marshall Richard (legal representative) 682380 682380 Marshall, Richard, of Brydeport, executrix of 0
5137303 2397421 2397421 defendant Benet John butcher 682380 682380 Benet, John, of Brydeport, butcher 1
5139841 2398128 2398128 plaintiff Spynay John clerk 682380 682380 Spynay, John, of Brydeport, clerk 0
5143923 2399365 2399365 plaintiff Bailly Thomas   682380 682380 Bailly, Thomas, of Brydeport 0
5143925 2399366 2399366 plaintiff Bailly Thomas   682380 682380 Bailly, Thomas, of Brydeport 0
5160792 2404253 2404253 plaintiff Spynay John clerk 682380 682380 Spynay, John, of Brydeport, clerk 0
5175471 2408515 2408515 plaintiff Spynay John clerk 682380 682380 Spynay, John, of Brydeport, clerk 0
5212714 2419467 2419467 defendant Prykprud John merchant 682380 682380 Prykprud, John, of Brydeport, merchant 0
5212716 2419467 2419467 defendant Wyllyams John merchant 682380 682380 Wyllyams, John, of Brydeport, merchant 2
5221690 2422040 2422040 defendant Bytelysgate John merchant 682380 682380 Bytelysgate, John, of Brydeport, merchant 2
5221691 2422040 2422040 defendant Bytelysgate William merchant 682380 682380 Bytelysgate, William, of Brydeport, merchant 3
5221692 2422040 2422040 defendant Byrge or Brygge John laborer 682380 682380 Byrge or Brygge, John, of Brydeport, laborer 4
5242942 2428137 2428137 defendant Sterre John mercer 682380 682380 Sterre, John, of Brydeport, mercer 0
5243870 2428400 2428400 defendant Parker John husbandman 682380 682380 Parker, John, of Brydeport, husbandman 1
5264955 2434796 2434796 plaintiff Spyvay or Spynay John clerk 682380 682380 Spyvay or Spynay, John, of Brydeport, clerk 0
5265976 2435114 2435114 defendant Tracy John gent 682380 682380 Tracy, John, of Brydeport, gent 0
5314329 2449304 2449304 defendant Knyfe Richard laborer 682380 682380 Knyfe, Richard, of Brydeport, laborer 0
5325569 2452724 2452724 defendant Battescombe Robert gent 682380 682380 Battescombe, Robert, of Brydeport, gent 2
5626670 2552315 2552315 plaintiff Mounfort William   682380 682380 Mounfort, William, of Brydeport 0
5626672 2552315 2552315 defendant Dewy Richard   682380 682380 Dewy, Richard, of Brydeport, mustard maker 1
5626704 2552326 2552326 plaintiff Mountfort William merchant 682380 682380 Mountfort, William, of Brydeport, merchant 0
5629795 2553316 2553316 plaintiff Roger John merchant 682380 682380 Roger, John, of Brydeport, merchant 0
5629801 2553319 2553319 plaintiff Rogere John   682380 682380 Rogere, John, of Brydeport 0
5630635 2553586 2553586 defendant Gybbes Adam draper 682380 682380 Gybbes, Adam, of Brydeport, draper 3

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