names

47 rows where place_id = 620332

✎ 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
3735055 1937203 1937203 defendant Moleyns Thomas, junior gent 620332 620332 Moleyns, Thomas, junior, of Bridport, Dorset, gent 0
4287346 2125530 2125530 defendant Howper Humphrey   620332 620332 Howper, Humphrey, of Bridport, Dorset, wine drawer 0
4339527 2143593 2143593 defendant Moone Gilbert chapman 620332 620332 Moone, Gilbert, of Bridport, Dorset, chapman 0
4387366 2160421 2160421 defendant Russell Richard gent 620332 620332 Russell, Richard, of Bridport, Dorset, or of Inner Temple, gent 0
4402301 2165353 2165353 defendant Moone Morgan gent 620332 620332 Moone, Morgan, of Bridport, Dorset, gent 2
4660920 2249240 2249240 defendant Hasard Adam draper 620332 620332 Hasard, Adam, of Bridport, Dorset, draper 0
4695940 2264216 2264216 defendant Neweton Thomas carrier 620332 620332 Neweton, Thomas, of Bridport, Dorset, carrier 0
4701176 2265773 2265773 defendant Broun Roger draper 620332 620332 Broun, Roger, of Bridport, Dorset, draper 0
4701193 2265775 2265775 defendant Broun Roger draper 620332 620332 Broun, Roger, of Bridport, Dorset, draper 0
4760397 2283605 2283605 defendant atte Forde Simon merchant 620332 620332 atte Forde, Simon, of Bridport, Dorset, merchant 0
4760401 2283606 2283606 defendant atte Forde Simon merchant 620332 620332 atte Forde, Simon, of Bridport, Dorset, merchant 0
4761526 2283947 2283947 defendant Draper Adam draper 620332 620332 Draper, Adam, of Bridport, Dorset, draper 1
4767719 2285885 2285885 defendant Morton William tailor 620332 620332 Morton, William, of Bridport, Dorset, tailor 1
4768758 2286206 2286206 defendant Hore William yeoman 620332 620332 (Hore, William, of Bridport, Dorset, yeoman 1
4769761 2286514 2286514 defendant Whittok William chaplain 620332 620332 (Whittok, William, of Bridport, Dorset, chaplain 1
4771175 2286967 2286967 defendant Hoddesfeld William husbandman 620332 620332 Hoddesfeld, William, of Bridport, Dorset, husbandman 0
4845129 2309989 2309989 defendant Hore Robert (legal representative) 620332 620332 Hore, Robert, of Bridport, Dorset, chapman, administrator of 0
4847262 2310644 2310644 defendant Mountfort William merchant 620332 620332 Mountfort, William, of Bridport, Dorset, merchant 0
4865474 2316167 2316167 defendant Mountford William merchant 620332 620332 Mountford, William, of Bridport, Dorset, merchant 0
4969763 2347903 2347903 defendant Hous William pewterer 620332 620332 Hous, William, of Bridport, Dorset, pewterer 0
4973348 2348967 2348967 defendant Helyer John clerk 620332 620332 Helyer, John, of Bridport, Dorset, clerk 2
4980987 2351246 2351246 plaintiff Sterre John chapman 620332 620332 Sterre, John, of Bridport, Dorset, chapman 0
4990047 2353933 2353933 defendant Helyer John clerk 620332 620332 Helyer, John, of Bridport, Dorset, clerk 0
4991028 2354205 2354205 defendant Boleyn John husbandman 620332 620332 Boleyn, John, of Bridport, Dorset, husbandman 3
5000323 2356967 2356967 defendant Boleyn John chapman 620332 620332 Boleyn, John, of Bridport, Dorset, chapman 3
5006397 2358770 2358770 defendant Bowley Christine widow 620332 620332 (Bowley, Christine, of Bridport, Dorset, widow 1
5018173 2362202 2362202 defendant Boule Nicholas chapman 620332 620332 Boule, Nicholas, of Bridport, Dorset, chapman 3
5023041 2363647 2363647 defendant Helier John clerk 620332 620332 Helier, John, of Bridport, Dorset, clerk 2
5031409 2366044 2366044 defendant Santon or Sauton William carrier 620332 620332 Santon or Sauton, William, of Bridport, Dorset, carrier 2
5031413 2366045 2366045 defendant Bonley or Bouley Nicholas chapman 620332 620332 Bonley or Bouley, Nicholas, of Bridport, Dorset, chapman 1
5031415 2366045 2366045 defendant Bonley or Bouley William (legal representative) 620332 620332 Bonley or Bouley, William, of Bridport, Dorset, executrix of 3
5062061 2375211 2375211 defendant Boweley Nicholas chapman 620332 620332 (Boweley, Nicholas, of Bridport, Dorset, chapman 2
5092798 2384272 2384272 defendant Boleyn John merchant 620332 620332 Boleyn, John, of Bridport, Dorset, merchant 0
5106405 2388312 2388312 defendant Russell Robert yeoman 620332 620332 Russell, Robert, of Bridport, Dorset, yeoman 7
5118270 2391777 2391777 defendant Russell Robert yeoman 620332 620332 Russell, Robert, of Bridport, Dorset, yeoman 21
5121371 2392682 2392682 defendant Charde Thomas dyer 620332 620332 Charde, Thomas, of Bridport, Dorset, dyer 1
5121374 2392683 2392683 defendant Charde Thomas dyer 620332 620332 Charde, Thomas, of Bridport, Dorset, dyer 1
5153441 2402161 2402161 defendant Tynner Richard dyer 620332 620332 Tynner, Richard, of Bridport, Dorset, dyer 0
5171654 2407430 2407430 defendant Bytelsygate William merchant 620332 620332 Bytelsygate, William, of Bridport, Dorset, merchant 3
5188896 2412488 2412488 defendant Tynner Richard   620332 620332 Tynner, Richard, of Bridport, Dorset 0
5190316 2412912 2412912 defendant Bytelysgate John (legal representative) 620332 620332 Bytelysgate, John, of Bridport, Dorset, merchant, executors of 0
5206287 2417574 2417574 defendant Tynnere Richard dyer 620332 620332 Tynnere, Richard, of Bridport, Dorset, dyer 0
5207399 2417905 2417905 defendant Spyne John chaplain 620332 620332 Spyne, John, of Bridport, Dorset, chaplain 1
5336668 2456037 2456037 defendant Chetour William chapman 620332 620332 Chetour, William, of Bridport, Dorset, chapman 3
5358636 2462763 2462763 defendant Spencer Robert   620332 620332 Spencer, Robert, of Bridport, Dorset, knight 0
5358647 2462766 2462766 defendant Spencer Robert   620332 620332 Spencer, Robert, of Bridport, Dorset, knight 0
5408607 2477539 2477539 defendant Spenser Robert esq 620332 620332 Spenser, Robert, of Bridport, Dorset, esq 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);