names

51 rows where place_id = 586315

✎ 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
3588415 1864025 1864025 defendant Kechell William husbandman 586315 586315 Kechell, William, of Hese, husbandman 1
3601058 1867998 1867998 defendant Kyng John husbandman 586315 586315 Kyng, John, of Hese, husbandman 1
3612803 1871655 1871655 defendant Co- John butcher 586315 586315 Co-, John, of Hese, butcher 0
3639738 1907236 1907236 defendant Stanys Roger husbandman 586315 586315 Stanys, Roger, of Hese, husbandman 3
3648490 1909926 1909926 defendant Normavyle John gent 586315 586315 Normavyle, John, of Hese, gent 0
3785730 1953327 1953327 plaintiff Osbourn John (legal representative) 586315 586315 Osbourn, John, of Hese, executors of 0
3785732 1953327 1953327 plaintiff Dary John   586315 586315 Dary, John, of Hese 2
4491253 2197952 2197952 defendant Chartesey William   586315 586315 Chartesey, William, of Hese, parson 4
4495834 2199379 2199379 plaintiff Cherteseye William (legal representative) 586315 586315 Cherteseye, William, of Hese, parson, executor of 0
4602586 2232027 2232027 defendant Redyng John   586315 586315 Redyng, John, of Hese 4
4717626 2270849 2270849 defendant Culverhous Thomas   586315 586315 Culverhous, Thomas, of Hese, bailiff 0
4791239 2293357 2293357 defendant Bedill John collier 586315 586315 Bedill, John, of Hese, collier 1
4795731 2294815 2294815 defendant Shotte John husbandman 586315 586315 Shotte, John, of Hese, husbandman 0
4893417 2324644 2324644 defendant Cok John, senior husbandman 586315 586315 Cok, John, senior, of Hese, husbandman 0
4893418 2324644 2324644 defendant Cok John, junior carpenter 586315 586315 Cok, John, junior, of Hese, carpenter 1
4936232 2337731 2337731 defendant Cok John carpenter 586315 586315 Cok, John, of Hese, carpenter 0
5002695 2357701 2357701 defendant Pote Richard husbandman 586315 586315 Pote, Richard, of Hese, husbandman 0
5014833 2361214 2361214 defendant Combe John husbandman 586315 586315 Combe, John, of Hese, husbandman 2
5056860 2373627 2373627 defendant Squery John gent 586315 586315 Squery, John, of Hese, gent 0
5062439 2375331 2375331 defendant Godfray John husbandman 586315 586315 Godfray, John, of Hese, husbandman 0
5092347 2384140 2384140 defendant Stanes John   586315 586315 Stanes, John, of Hese, husbandman, administrators of 1
5092348 2384140 2384140 defendant Stanes Walter yeoman 586315 586315 (Stanes, Walter, of Hese, yeoman 2
5092349 2384140 2384140 defendant Stanes Alice widow 586315 586315 Stanes, Alice, of Hese, widow 3
5153609 2402207 2402207 defendant Wodeman William husbandman 586315 586315 Wodeman, William, of Hese, husbandman 1
5171829 2407479 2407479 defendant Yonge Thomas Middx, husbandman 586315 586315 Yonge Thomas, of Hese, Middx, husbandman 1
5257068 2432341 2432341 defendant Hyde William grasier 586315 586315 Hyde, William, of Hese, grasier 0
5266069 2435139 2435139 defendant Hyde William husbandman 586315 586315 Hyde, William, of Hese, husbandman 0
5291017 2442374 2442374 defendant Rudlond John pulter 586315 586315 Rudlond, John, of Hese, pulter 0
5311134 2448360 2448360 defendant Longe Peter husbandman 586315 586315 (Longe, Peter, of Hese, husbandman 1
5324222 2452333 2452333 defendant Argast John yeoman 586315 586315 Argast, John, of Hese, yeoman 1
5333289 2455029 2455029 defendant Baker John husbandman 586315 586315 Baker, John, of Hese, husbandman 0
5333290 2455029 2455029 defendant Garard John husbandman 586315 586315 Garard, John, of Hese, husbandman 1
5333291 2455029 2455029 defendant Alayn Richard husbandman 586315 586315 Alayn, Richard, of Hese, husbandman 2
5333292 2455029 2455029 defendant Alayn William husbandman 586315 586315 Alayn, William, of Hese, husbandman 3
5333293 2455029 2455029 defendant Rotland William husbandman 586315 586315 Rotland, William, of Hese, husbandman 4
5335165 2455586 2455586 defendant Hylle John husbandman 586315 586315 Hylle, John, of Hese, husbandman 1
5345383 2458729 2458729 defendant Wodegate William husbandman 586315 586315 Wodegate, William, of Hese, husbandman 0
5362141 2463825 2463825 defendant Shot Thomas husbandman 586315 586315 Shot, Thomas, of Hese, husbandman 0
5362143 2463825 2463825 defendant Kechyll John husbandman 586315 586315 Kechyll, John, of Hese, husbandman 2
5372996 2467145 2467145 defendant Stephyns William husbandman 586315 586315 Stephyns, William, of Hese, husbandman 2
5438999 2486585 2486585 defendant Monfeld Robert husbandman 586315 586315 Monfeld, Robert, of Hese, husbandman 3
5439011 2486587 2486587 defendant Monfeld Robert husbandman 586315 586315 Monfeld, Robert, of Hese, husbandman 3
5452900 2490746 2490746 defendant Monfeld Robert husbandman 586315 586315 Monfeld, Robert, of Hese, husbandman 2
5452905 2490747 2490747 defendant Monfeld Robert husbandman 586315 586315 Monfeld, Robert, of Hese, husbandman 2
5463568 2494019 2494019 plaintiff Shotte Thomas   586315 586315 Shotte, Thomas, of Hese 0
5493099 2502846 2502846 defendant Frenshe John husbandman 586315 586315 Frenshe, John, of Hese, husbandman 0
5502693 2505760 2505760 defendant Aynescompe John husbandman 586315 586315 Aynescompe, John, of Hese, husbandman 0
5502695 2505761 2505761 defendant Aynescompe John husbandman 586315 586315 Aynescompe, John, of Hese, husbandman 0
5519354 2510900 2510900 defendant Wyker John laborer 586315 586315 Wyker, John, of Hese, laborer 2
5627902 2552697 2552697 defendant Smyth Stephen husbandman 586315 586315 Smyth, Stephen, of Hese, husbandman 1
5627903 2552697 2552697 defendant Cokke John husbandman 586315 586315 Cokke, John, of Hese, husbandman 2

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