names

51 rows where place_id = 591104

✎ 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
3603342 1868719 1868719 defendant Rede Richard husbandman 591104 591104 Rede, Richard, of Runhale, husbandman 1
3683880 1921093 1921093 defendant Dowghty Robert (legal representative) 591104 591104 Dowghty, Robert, of Runhale, husbandman, executors of 0
3710518 1929612 1929612 defendant Dey Robert husbandman 591104 591104 Dey, Robert, of Runhale, husbandman 0
3719523 1932370 1932370 defendant Peytt Robert husbandman 591104 591104 Peytt, Robert, of Runhale, husbandman 2
3740683 1938948 1938948 defendant Grene John husbandman 591104 591104 Grene, John, of Runhale, husbandman 3
4495490 2199270 2199270 defendant Frary John   591104 591104 Frary, John, of Runhale 0
4554164 2217227 2217227 defendant Frary John   591104 591104 Frary, John, of Runhale 1
4583663 2226307 2226307 defendant Fraunsham John (legal representative) 591104 591104 Fraunsham, John, of Runhale, executrix of 0
4760179 2283532 2283532 defendant Estwate John yeoman 591104 591104 Estwate, John, of Runhale, yeoman 2
4881286 2321051 2321051 defendant Lowes William husbandman 591104 591104 Lowes, William, of Runhale, husbandman 0
4888116 2323088 2323088 defendant Fidemond Thomas husbandman 591104 591104 Fidemond, Thomas, of Runhale, husbandman 1
4972213 2348633 2348633 defendant Fedymond Thomas   591104 591104 Fedymond, Thomas, of Runhale, wright 1
4974176 2349233 2349233 defendant Chapman William yeoman 591104 591104 Chapman, William, of Runhale, yeoman 4
4984119 2352182 2352182 defendant Den Ralph diker 591104 591104 Den, Ralph, of Runhale, diker 0
5001760 2357410 2357410 defendant Fetyll John yeoman 591104 591104 Fetyll, John, of Runhale, yeoman 0
5036058 2367401 2367401 plaintiff Tyllys William   591104 591104 Tyllys, William, of Runhale 0
5037186 2367742 2367742 defendant Write Thomas yeoman 591104 591104 Write, Thomas, of Runhale, yeoman 3
5065655 2376256 2376256 defendant Kempe Robert husbandman 591104 591104 Kempe, Robert, of Runhale, husbandman 3
5095964 2385248 2385248 defendant Skrevener John clerk 591104 591104 Skrevener, John, of Runhale, clerk 5
5122114 2392888 2392888 defendant Wagecok John yeoman 591104 591104 Wagecok, John, of Runhale, yeoman 2
5122227 2392922 2392922 plaintiff Tyllis William gent 591104 591104 Tyllis, William, of Runhale, gent 0
5208086 2418096 2418096 defendant Buston Gregory husbandman 591104 591104 Buston, Gregory, of Runhale, husbandman 4
5276021 2438061 2438061 plaintiff Tilles Robert gent 591104 591104 Tilles, Robert, of Runhale, gent 0
5289596 2441957 2441957 defendant Wechecok John husbandman 591104 591104 Wechecok, John, of Runhale, husbandman 0
5290790 2442311 2442311 defendant atte Asshe Alexander carpenter 591104 591104 atte Asshe, Alexander, of Runhale, carpenter 2
5294554 2443384 2443384 defendant Wychecok John husbandman 591104 591104 Wychecok, John, of Runhale, husbandman 1
5295028 2443536 2443536 plaintiff Tillys Robert gent 591104 591104 Tillys, Robert, of Runhale, gent 0
5295429 2443656 2443656 plaintiff Tyllys Robert gent 591104 591104 Tyllys, Robert, of Runhale, gent 0
5303172 2445941 2445941 defendant Ston John husbandman 591104 591104 Ston, John, of Runhale, husbandman 0
5303173 2445941 2445941 defendant Wethercok John husbandman 591104 591104 Wethercok, John, of Runhale, husbandman 1
5305234 2446569 2446569 defendant Wechecok John husbandman 591104 591104 Wechecok, John, of Runhale, husbandman 1
5310932 2448303 2448303 defendant Lawes John, sen husbandman 591104 591104 Lawes, John, sen, of Runhale, husbandman 0
5310933 2448303 2448303 defendant Lavet William husbandman 591104 591104 Lavet, William, of Runhale, husbandman 1
5321029 2451384 2451384 defendant Tyllys Robert gent 591104 591104 Tyllys, Robert, of Runhale, gent 0
5321030 2451384 2451384 defendant Wetchecok John husbandman 591104 591104 Wetchecok, John, of Runhale, husbandman 1
5321486 2451518 2451518 defendant atte Essh Alexander yeoman 591104 591104 atte Essh, Alexander, of Runhale, yeoman 1
5323225 2452028 2452028 defendant atte Essh Alexander yeoman 591104 591104 atte Essh, Alexander, of Runhale, yeoman 0
5323226 2452028 2452028 defendant Tyllys Robert gent 591104 591104 Tyllys, Robert, of Runhale, gent 1
5339956 2457066 2457066 defendant Wechecok John husbandman 591104 591104 Wechecok, John, of Runhale, husbandman 0
5342043 2457703 2457703 defendant atte Asshe Simon clerk 591104 591104 atte Asshe, Simon, of Runhale, clerk 0
5348257 2459597 2459597 defendant Wechecok John yeoman 591104 591104 Wechecok, John, of Runhale, yeoman 8
5358118 2462603 2462603 defendant Tyll Robert gent 591104 591104 Tyll, Robert, of Runhale, gent 0
5358120 2462604 2462604 defendant Tyll Robert gent 591104 591104 Tyll, Robert, of Runhale, gent 0
5373990 2467462 2467462 defendant Lawes Thomas husbandman 591104 591104 Lawes, Thomas, of Runhale, husbandman 3
5399290 2474869 2474869 defendant Wethecok John husbandman 591104 591104 Wethecok, John, of Runhale, husbandman 8
5403685 2476124 2476124 defendant Lawes Thomas husbandman 591104 591104 Lawes, Thomas, of Runhale, husbandman 1
5403690 2476125 2476125 defendant Lawes Thomas husbandman 591104 591104 Lawes, Thomas, of Runhale, husbandman 1
5412297 2478623 2478623 defendant Wechecok (illegible) husbandman 591104 591104 Wechecok, _, of Runhale, husbandman 8
5416792 2479937 2479937 defendant Lawes Thomas husbandman 591104 591104 Lawes, Thomas, of Runhale, husbandman 1
5564114 2524121 2524121 defendant Tyllys William gent 591104 591104 Tyllys, William, of Runhale, gent, son of Tyllys, Robert, of Runhale, gent 0
5578932 2528479 2528479 defendant Tyllys William   591104 591104 Tyllys, William, of Runhale, gent, son of Tyllys, Robert 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);