names

44 rows where place_id = 765434

✎ 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
4517127 2205759 2205759 defendant atte Harwe John   765434 765434 atte Harwe, John, of Bishop's Hatfeld 2
4588666 2227831 2227831 plaintiff Kynnesbern Thomas   765434 765434 Kynnesbern, Thomas, of Bishop's Hatfeld 0
4595005 2229695 2229695 defendant Grous Nicholas   765434 765434 Grous, Nicholas, of Bishop's Hatfeld 0
4717876 2270932 2270932 plaintiff Asshe William   765434 765434 Asshe, William, of Bishop's Hatfeld 0
4717877 2270932 2270932 defendant Fysshe John   765434 765434 Fysshe, John, of Bishop's Hatfeld, franklin 0
4814159 2300531 2300531 defendant Wrottyng William husbandman 765434 765434 Wrottyng, William, of Bishop's Hatfeld, husbandman 0
4908021 2329067 2329067 defendant Neweman Nicholas smith 765434 765434 Neweman, Nicholas, of Bishop's Hatfeld, smith 0
4908026 2329068 2329068 defendant Neweman Nicholas smith 765434 765434 Neweman, Nicholas, of Bishop's Hatfeld, smith 0
4923921 2333920 2333920 defendant Yonge Thomas yeoman 765434 765434 Yonge, Thomas, of Bishop's Hatfeld, yeoman 0
4997787 2356194 2356194 defendant Yonge Thomas husbandman 765434 765434 Yonge, Thomas, of Bishop's Hatfeld, husbandman 0
4998228 2356339 2356339 defendant Fabe John husbandman 765434 765434 Fabe, John, of Bishop's Hatfeld, husbandman 0
5040214 2368672 2368672 defendant Elnore William milner 765434 765434 Elnore, William, of Bishop's Hatfeld, milner 1
5045439 2370265 2370265 defendant Walton Philip husbandman 765434 765434 Walton, Philip, of Bishop's Hatfeld, husbandman 1
5299765 2444900 2444900 defendant Mery Thomas yeoman 765434 765434 Mery, Thomas, of Bishop's Hatfeld, yeoman 0
5387625 2471528 2471528 defendant Bond Thomas yeoman 765434 765434 Bond, Thomas, of Bishop's Hatfeld, yeoman 1
5400804 2475294 2475294 defendant Kebyll Thomas yeoman 765434 765434 Kebyll, Thomas, of Bishop's Hatfeld, yeoman 0
5400805 2475294 2475294 defendant Kebyll Roger yeoman 765434 765434 Kebyll, Roger, of Bishop's Hatfeld, yeoman 1
5405547 2476664 2476664 defendant Bonde Thomas yeoman 765434 765434 Bonde, Thomas, of Bishop's Hatfeld, yeoman 1
5410714 2478150 2478150 defendant Beauchamp Richard yeoman 765434 765434 Beauchamp, Richard, of Bishop's Hatfeld, yeoman 1
5412908 2478809 2478809 defendant Roger John   765434 765434 Roger, John, of Bishop's Hatfeld, inn holder 0
5412909 2478809 2478809 defendant Batell Robert yeoman 765434 765434 Batell, Robert, of Bishop's Hatfeld, yeoman 1
5412910 2478809 2478809 defendant Peion William husbandman 765434 765434 Peion, William, of Bishop's Hatfeld, husbandman 2
5412911 2478809 2478809 defendant Kesete William husbandman 765434 765434 Kesete, William, of Bishop's Hatfeld, husbandman 3
5413233 2478884 2478884 defendant Bond Thomas   765434 765434 Bond, Thomas, of Bishop's Hatfeld 1
5413818 2479058 2479058 defendant Kebyll Thomas yeoman 765434 765434 Kebyll, Thomas, of Bishop's Hatfeld, yeoman 0
5413819 2479058 2479058 defendant Kebyll Roger yeoman 765434 765434 Kebyll, Roger, of Bishop's Hatfeld, yeoman 1
5417878 2480275 2480275 defendant Howe Thomas butcher 765434 765434 Howe, Thomas, of Bishop's Hatfeld, butcher 0
5417881 2480275 2480275 defendant Laman John tanner 765434 765434 Laman, John, of Bishop's Hatfeld, tanner 3
5418611 2480491 2480491 defendant Sonder Nicholas husbandman 765434 765434 Sonder, Nicholas, of Bishop's Hatfeld, husbandman 0
5418612 2480491 2480491 defendant Loke John husbandman 765434 765434 Loke, John, of Bishop's Hatfeld, husbandman 1
5418613 2480491 2480491 defendant Felde Philip porter 765434 765434 Felde, Philip, of Bishop's Hatfeld, porter 2
5423066 2481853 2481853 defendant Beauchamp Richard yeoman 765434 765434 Beauchamp, Richard, of Bishop's Hatfeld, yeoman 1
5423069 2481854 2481854 defendant Beauchamp Richard yeoman 765434 765434 Beauchamp, Richard, of Bishop's Hatfeld, yeoman 1
5428772 2483520 2483520 defendant Wilkyns John laborer 765434 765434 Wilkyns, John, of Bishop's Hatfeld, laborer 1
5429201 2483662 2483662 defendant Kebyll Thomas yeoman 765434 765434 Kebyll, Thomas, of Bishop's Hatfeld, yeoman 0
5429202 2483662 2483662 defendant Kebyll Roger yeoman 765434 765434 Kebyll, Roger, of Bishop's Hatfeld, yeoman 1
5445531 2488560 2488560 defendant Bassyngborn Thomas esq 765434 765434 Bassyngborn, Thomas, of Bishop's Hatfeld, esq 0
5445860 2488650 2488650 defendant Roggers John   765434 765434 Roggers, John, of Bishop's Hatfeld, inn holder 0
5446029 2488697 2488697 defendant Wylkyns John laborer 765434 765434 Wylkyns, John, of Bishop's Hatfeld, laborer 0
5446034 2488699 2488699 defendant Wylkyne John laborer 765434 765434 Wylkyne, John, of Bishop's Hatfeld, laborer 0
5450889 2490153 2490153 defendant Bygge John husbandman 765434 765434 Bygge, John, of Bishop's Hatfeld, husbandman 0
5457739 2492211 2492211 defendant Rogers John innholder 765434 765434 Rogers, John, of Bishop's Hatfeld, innholder 1
5458576 2492458 2492458 defendant Rogers John innholder 765434 765434 Rogers, John, of Bishop's Hatfeld, innholder 0
5470216 2496007 2496007 defendant Rogers John innholder 765434 765434 Rogers, John, of Bishop's Hatfeld, innholder 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);