names

68 rows where place_id = 599971

✎ 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
3631822 1904760 1904760 plaintiff Hackwyll Geoffrey (legal representative) 599971 599971 Hackwyll, Geoffrey, of Totton, merchant, executors of 0
3639118 1907056 1907056 defendant Williams John yeoman 599971 599971 Williams, John, of Totton, yeoman 3
3639126 1907057 1907057 defendant Terry John husbandman 599971 599971 Terry, John, of Totton, husbandman 5
3639133 1907058 1907058 defendant Terry John husbandman 599971 599971 Terry, John, of Totton, husbandman 5
3640777 1907561 1907561 plaintiff Ayleward Walter   599971 599971 Ayleward, Walter, of Totton 0
3773434 1949403 1949403 defendant Ley Henry weaver 599971 599971 Ley, Henry, of Totton, weaver 1
3782585 1952295 1952295 defendant Bocher Henry butcher 599971 599971 Bocher, Henry, of Totton, butcher 2
3845826 1972248 1972248 plaintiff French William merchant 599971 599971 French, William, of Totton, merchant 0
3891926 1987552 1987552 defendant Rumsey William husbandman 599971 599971 Rumsey, William, of Totton, husbandman 4
3891933 1987553 1987553 defendant Rumsey William husbandman 599971 599971 Rumsey, William, of Totton, husbandman 5
4162257 2082359 2082359 defendant Myddelton John yeoman 599971 599971 Myddelton, John, of Totton, yeoman 0
4213900 2100382 2100382 defendant Lunde William husbandman 599971 599971 Lunde, William, of Totton, husbandman 0
4450873 2185239 2185239 plaintiff Helier John   599971 599971 Helier, John, of Totton 0
4450874 2185239 2185239 defendant Helier William   599971 599971 Helier, William, of Totton 0
4455540 2186738 2186738 defendant Crokere Roger   599971 599971 Crokere, Roger, of Totton 0
4455545 2186739 2186739 defendant Crokere Roger   599971 599971 Crokere, Roger, of Totton 0
4459365 2187981 2187981 plaintiff Russell John   599971 599971 Russell, John, of Totton 0
4480197 2194465 2194465 defendant Gugon Henry   599971 599971 Gugon, Henry, of Totton 2
4509522 2203447 2203447 defendant Jakeman Richard   599971 599971 Jakeman, Richard, of Totton 0
4509524 2203448 2203448 defendant Jakeman Richard   599971 599971 Jakeman, Richard, of Totton 0
4528272 2209120 2209120 defendant Stokes John   599971 599971 Stokes, John, of Totton 2
4538453 2212313 2212313 defendant Aillemere John   599971 599971 Aillemere, John, of Totton 1
4596375 2230118 2230118 plaintiff Russell John (legal representative) 599971 599971 Russell, John, of Totton, executors of 0
4596379 2230119 2230119 plaintiff Russell John (legal representative) 599971 599971 Russell, John, of Totton, executors of 0
4600628 2231423 2231423 defendant Deghere Nicholas   599971 599971 Deghere, Nicholas, of Totton 0
4629494 2240153 2240153 plaintiff Southam John   599971 599971 Southam, John, of Totton, prior 0
4657931 2248366 2248366 defendant Beallelegh Stephen husbandman 599971 599971 Beallelegh, Stephen, of Totton, husbandman 0
4685692 2261115 2261115 defendant Symondes John mercer 599971 599971 Symondes, John, of Totton, mercer 0
4697383 2264667 2264667 defendant Dybylle John carpenter 599971 599971 (Dybylle, John, of Totton, carpenter 1
4714545 2269879 2269879 defendant Usshe John yeoman 599971 599971 Usshe, John, of Totton, yeoman 2
4714546 2269879 2269879 defendant Piers Stephen merchant 599971 599971 Piers, Stephen, of Totton, merchant 3
4720662 2271796 2271796 defendant Mark Patrick crokker or potter 599971 599971 Mark, Patrick, of Totton, crokker or potter 0
4727193 2273766 2273766 defendant Pille Thomas husbandman 599971 599971 Pille, Thomas, of Totton, husbandman 2
4735148 2276140 2276140 defendant Midderhill Robert merchant 599971 599971 Midderhill, Robert, of Totton, merchant 0
4841932 2309011 2309011 defendant Morgan Richard merchant 599971 599971 Morgan, Richard, of Totton, merchant 0
4846709 2310477 2310477 plaintiff Perkyn John   599971 599971 Perkyn, John, of Totton 1
4846710 2310477 2310477 defendant Nicoll Walter tanner 599971 599971 Nicoll, Walter, of Totton, tanner 0
4850375 2311572 2311572 defendant Bocher John butcher 599971 599971 Bocher, John, of Totton, butcher 2
4872694 2318411 2318411 defendant Norwych Richard dyer 599971 599971 Norwych, Richard, of Totton, dyer 1
4876564 2319635 2319635 defendant Iryssh John baker 599971 599971 Iryssh, John, of Totton, baker 0
4878447 2320203 2320203 defendant Degher William (legal representative) 599971 599971 Degher, William, of Totton, executors of 0
4878448 2320203 2320203 defendant Drake John husbandman 599971 599971 (Drake, John, of Totton, husbandman 1
4878449 2320203 2320203 defendant Pascowe John weaver 599971 599971 Pascowe, John, of Totton, weaver 2
4878450 2320203 2320203 defendant Degher Cecily widow 599971 599971 Degher, Cecily, of Totton, widow 3
4879467 2320507 2320507 defendant Serle Walter butcher 599971 599971 Serle, Walter, of Totton, butcher 2
4893098 2324559 2324559 defendant Fismark John   599971 599971 Fismark, John, of Totton, franklin 0
4898212 2326101 2326101 defendant Byldok Stephen smith 599971 599971 Byldok, Stephen, of Totton, smith 0
4898217 2326103 2326103 defendant Armurer Benedict husbandman 599971 599971 Armurer, Benedict, of Totton, husbandman 0
4900173 2326680 2326680 defendant Fyfmark John   599971 599971 Fyfmark, John, of Totton, franklin 0
4921229 2333155 2333155 defendant Hardyng Willam husbandman 599971 599971 Hardyng, Willam, of Totton, husbandman 0
4921230 2333155 2333155 defendant Hardyng John   599971 599971 Hardyng, John, of Totton, servant 1
5009125 2359551 2359551 defendant Bythewater William merchant 599971 599971 Bythewater, William, of Totton, merchant 0
5009332 2359619 2359619 defendant Warner William yeoman 599971 599971 Warner, William, of Totton, yeoman 4
5019401 2362557 2362557 defendant Hamelyn Thomas sherman 599971 599971 Hamelyn, Thomas, of Totton, sherman 0
5019402 2362557 2362557 defendant Thomas John tailor 599971 599971 Thomas, John, of Totton, tailor 1
5046233 2370502 2370502 defendant Hamelyn John butcher 599971 599971 Hamelyn, John, of Totton, butcher 2
5123774 2393413 2393413 defendant Mee Richard husbandman 599971 599971 Mee, Richard, of Totton, husbandman 3
5152057 2401739 2401739 plaintiff (not given) William prior of Harry 599971 599971 Harry, William, of Totton, prior of the house & church of the BVM 0
5169978 2406954 2406954 plaintiff (not given) William prior of Harry 599971 599971 Harry, William, of Totton, prior of the house & church of the BM 0
5187271 2412004 2412004 plaintiff (not given) William prior of Harry 599971 599971 Harry, William, of Totton, prior of the house & church of the BM 0
5231902 2424904 2424904 plaintiff Boughton Robert   599971 599971 Boughton, Robert, of Totton 0
5331857 2454608 2454608 defendant Cosyn William sherman 599971 599971 Cosyn, William, of Totton, sherman 0
5470315 2496043 2496043 defendant (not given) William prior of Harry 599971 599971 Harry, William, of Totton, prior of the house & church of the BM 0
5470317 2496044 2496044 defendant (not given) William prior of Harry 599971 599971 Harry, William, of Totton, prior of the house & church of the BM 0
5548468 2519589 2519589 defendant Willyams John yeoman 599971 599971 Willyams, John, of Totton, yeoman 0
5549003 2519743 2519743 defendant Hacker John smith 599971 599971 Hacker, John, of Totton, smith 0
5553638 2521101 2521101 defendant Williams John yeoman 599971 599971 Williams, John, of Totton, yeoman 0
5626650 2552308 2552308 plaintiff Moun or Mohun John   599971 599971 Moun or Mohun, John, of Totton 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);