names

91 rows where place_id = 611223

✎ 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
3687449 1922254 1922254 plaintiff Clerk John   611223 611223 Clerk, John, of Weymouth 0
3687450 1922254 1922254 defendant Hawkyns William mariner 611223 611223 Hawkyns, William, of Weymouth, mariner 0
3687494 1922268 1922268 plaintiff Clerke John   611223 611223 Clerke, John, of Weymouth 0
3718424 1932040 1932040 defendant Favell alias Clerke John merchant 611223 611223 Favell alias Clerke, John, of Weymouth, merchant 1
3718428 1932041 1932041 defendant Favell alias Clerke John merchant 611223 611223 Favell alias Clerke, John, of Weymouth, merchant 1
3811776 1961582 1961582 defendant Hawkyns William mariner 611223 611223 Hawkyns, William, of Weymouth, mariner 0
3847639 1972831 1972831 defendant Gregory John yeoman 611223 611223 Gregory, John, of Weymouth, yeoman 1
4004430 2026364 2026364 plaintiff James alias Randall Robert merchant 611223 611223 James alias Randall, Robert, of Weymouth, merchant 0
4007655 2027525 2027525 plaintiff Martyn William merchant 611223 611223 Martyn, William, of Weymouth, merchant 0
4050704 2042686 2042686 plaintiff Welborne George   611223 611223 Welborne, George, of Weymouth 0
4117003 2066383 2066383 defendant Tuttey Geofrey yeoman 611223 611223 Tuttey, Geofrey, of Weymouth, yeoman 0
4255828 2114924 2114924 defendant Martyn John yeoman 611223 611223 Martyn, John, of Weymouth, yeoman 0
4443093 2182801 2182801 defendant Sipon John   611223 611223 Sipon, John, of Weymouth 1
4477126 2193506 2193506 defendant Russel William merchant 611223 611223 Russel, William, of Weymouth, merchant 1
4495986 2199422 2199422 defendant Elyot John   611223 611223 Elyot, John, of Weymouth 0
4495990 2199423 2199423 defendant Tylye William   611223 611223 Tylye, William, of Weymouth 0
4497706 2199926 2199926 defendant Rose William   611223 611223 Rose, William, of Weymouth 0
4521755 2207135 2207135 defendant Eliot John   611223 611223 Eliot, John, of Weymouth 0
4534975 2211219 2211219 defendant Wayte John carpenter 611223 611223 Wayte, John, of Weymouth, carpenter 1
4543906 2213997 2213997 plaintiff Baker John mariner 611223 611223 Baker, John, of Weymouth, mariner 0
4548656 2215524 2215524 plaintiff Clerk William   611223 611223 Clerk, William, of Weymouth 0
4548658 2215524 2215524 defendant London Richard   611223 611223 London, Richard, of Weymouth 1
4548661 2215525 2215525 plaintiff Clerk William   611223 611223 Clerk, William, of Weymouth 0
4560168 2219125 2219125 defendant Haukyn Thomas   611223 611223 Haukyn, Thomas, of Weymouth 1
4565059 2220641 2220641 defendant Skynner Edward   611223 611223 Skynner, Edward, of Weymouth 1
4578226 2224686 2224686 defendant Cok John, sen   611223 611223 Cok, John, sen, of Weymouth 0
4579699 2225137 2225137 defendant Cole Thomas   611223 611223 Cole, Thomas, of Weymouth 0
4580957 2225519 2225519 defendant Wyet Ralph   611223 611223 Wyet, Ralph, of Weymouth 0
4601936 2231830 2231830 defendant Bassyngborne John   611223 611223 Bassyngborne, John, of Weymouth 0
4619876 2237196 2237196 defendant Tyly William   611223 611223 Tyly, William, of Weymouth 1
4635146 2241837 2241837 plaintiff Wysth William   611223 611223 Wysth, William, of Weymouth 0
4653568 2247050 2247050 defendant Milward John   611223 611223 Milward, John, of Weymouth, millward 1
4659125 2248726 2248726 defendant Cole Thomas (legal representative) 611223 611223 Cole, Thomas, of Weymouth, executors of 1
4665125 2250573 2250573 defendant Payn Thomas shipman 611223 611223 Payn, Thomas, of Weymouth, shipman 0
4665126 2250573 2250573 defendant Baker William husbandman 611223 611223 Baker, William, of Weymouth, husbandman 1
4682117 2260026 2260026 defendant Abbot John, junior vintner 611223 611223 Abbot, John, junior, of Weymouth, vintner 1
4691635 2262917 2262917 defendant Hille Richard shipman 611223 611223 Hille, Richard, of Weymouth, shipman 0
4695697 2264135 2264135 plaintiff Penne John   611223 611223 Penne, John, of Weymouth 1
4703677 2266530 2266530 defendant Abbot John merchant 611223 611223 Abbot, John, of Weymouth, merchant 0
4710986 2268793 2268793 defendant Blaunchard Richard baker 611223 611223 Blaunchard, Richard, of Weymouth, baker 1
4721480 2272049 2272049 defendant Dower John, sen shipman 611223 611223 Dower, John, sen, of Weymouth, shipman 0
4770830 2286857 2286857 defendant Gowre John shipman 611223 611223 Gowre, John, of Weymouth, shipman 1
4784481 2291151 2291151 defendant Abbot John chapman 611223 611223 Abbot, John, of Weymouth, or of Melcombe, Dorset, chapman 0
4790519 2293128 2293128 defendant Gylote James chapman 611223 611223 Gylote, James, of Weymouth, chapman 1
4795645 2294789 2294789 defendant Gowre John shipman 611223 611223 Gowre, John, of Weymouth, shipman 1
4821249 2302726 2302726 defendant Large Bertram merchant 611223 611223 Large, Bertram, of Weymouth, merchant 4
4827263 2304577 2304577 plaintiff Wyet William merchant 611223 611223 Wyet, William, of Weymouth, merchant, on his own account 0
4829174 2305166 2305166 defendant Vyncent William tailor 611223 611223 Vyncent, William, of Weymouth, tailor 0
4856977 2313562 2313562 defendant Snellyng Richard draper 611223 611223 Snellyng, Richard, of Weymouth, draper 0
4867206 2316704 2316704 defendant Wyot William chapman 611223 611223 Wyot, William, of Weymouth, chapman 0
4961237 2345327 2345327 defendant Pyres Thomas husbandman 611223 611223 Pyres, Thomas, of Weymouth, husbandman 0
4994748 2355286 2355286 defendant Tregilde William chapman 611223 611223 Tregilde, William, of Weymouth, chapman 1
4995508 2355496 2355496 defendant Abbot Nicholas merchant 611223 611223 Abbot, Nicholas, of Weymouth, merchant 1
5022298 2363415 2363415 defendant Carre Nicholas merchant 611223 611223 Carre, Nicholas, of Weymouth, merchant 0
5022299 2363415 2363415 defendant Abbot John merchant 611223 611223 Abbot, John, of Weymouth, merchant 1
5022995 2363636 2363636 defendant Abbot Nicholas merchant 611223 611223 Abbot, Nicholas, of Weymouth, merchant 0
5028809 2365301 2365301 defendant Abbot John merchant 611223 611223 Abbot, John, of Weymouth, merchant 0
5030097 2365674 2365674 defendant Martyn John merchant 611223 611223 Martyn, John, of Weymouth, merchant 3
5030098 2365674 2365674 defendant Serla John gent 611223 611223 Serla, John, of Weymouth, gent 4
5032178 2366290 2366290 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5032182 2366291 2366291 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5043681 2369730 2369730 defendant Abbot Nicholas merchant 611223 611223 Abbot, Nicholas, of Weymouth, merchant 0
5050786 2371859 2371859 defendant Jamez Ralph merchant 611223 611223 Jamez, Ralph, of Weymouth, merchant 0
5069922 2377498 2377498 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5069929 2377499 2377499 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5069932 2377500 2377500 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5081818 2381057 2381057 defendant Porteryne Nicholas merchant 611223 611223 Porteryne, Nicholas, of Weymouth, or of Lantewigh, Glamorgan, merchant 1
5081819 2381057 2381057 defendant Martyn John merchant 611223 611223 Martyn, John, of Weymouth, merchant 2
5094517 2384804 2384804 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5094519 2384805 2384805 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5094521 2384806 2384806 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5094523 2384807 2384807 plaintiff Russell Henry   611223 611223 Russell, Henry, of Weymouth 0
5119194 2392042 2392042 defendant Clerk John merchant 611223 611223 Clerk, John, of Weymouth, merchant 0
5144778 2399627 2399627 defendant Martyn John yeoman 611223 611223 Martyn, John, of Weymouth, yeoman 1
5170897 2407213 2407213 defendant Woulle Henry merchant 611223 611223 Woulle, Henry, of Weymouth, merchant 0
5178642 2409467 2409467 defendant Vyke John merchant 611223 611223 Vyke, John, of Weymouth, merchant 2
5181854 2410438 2410438 defendant Gayte John merchant 611223 611223 Gayte, John, of Weymouth, merchant 0
5192025 2413396 2413396 defendant Lacy Peter mariner 611223 611223 Lacy, Peter, of Weymouth, mariner 1
5203115 2416672 2416672 defendant Gayte John merchant 611223 611223 Gayte, John, of Weymouth, merchant 0
5222250 2422214 2422214 defendant Bryce Nicholas pewterer 611223 611223 Bryce, Nicholas, of Weymouth, pewterer 1
5230746 2424600 2424600 defendant Martyn John merchant 611223 611223 Martyn, John, of Weymouth, merchant 3
5371848 2466779 2466779 defendant Gesypp Henry merchant 611223 611223 Gesypp, Henry, of Weymouth, merchant 0
5378708 2468925 2468925 defendant Jesop Henry yeoman 611223 611223 Jesop, Henry, of Weymouth, yeoman 0
5593486 2532947 2532947 defendant Harvyst Richard fisher 611223 611223 Harvyst, Richard, of Weymouth, fisher 0
5603993 2536117 2536117 defendant Knot Hugh slater 611223 611223 Knot, Hugh, of Weymouth, slater 0
5625742 2551993 2551993 defendant Wydeford John merchant 611223 611223 Wydeford, John, of Weymouth, merchant 0
5625743 2551993 2551993 defendant Shorham Nicholas shipman 611223 611223 Shorham, Nicholas, of Weymouth, shipman 1
5626669 2552314 2552314 defendant James John merchant 611223 611223 James, John, of Weymouth, merchant 0
5626815 2552357 2552357 defendant Trygyldy William mercer 611223 611223 Trygyldy, William, of Weymouth, mercer 0
5627171 2552462 2552462 defendant Goolde alias Bakere William merchant 611223 611223 Goolde alias Bakere, William, of Weymouth, merchant 4
5632287 2554128 2554128 defendant Walissh John husbandman 611223 611223 Walissh, John, of Weymouth, husbandman 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);