names

86 rows where place_id = 713738

✎ 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
4200515 2095741 2095741 defendant Higgenson Thomas yeoman 713738 713738 Higgenson, Thomas, of Berkeswell, yeoman 2
4483636 2195572 2195572 plaintiff Oldenhale William   713738 713738 Oldenhale, William, of Berkeswell 0
4487392 2196766 2196766 defendant Wroxhale John   713738 713738 Wroxhale, John, of Berkeswell 2
4493793 2198752 2198752 defendant Whaburleye John   713738 713738 Whaburleye, John, of Berkeswell, son of Richard 0
4506813 2202598 2202598 defendant Miles Robert   713738 713738 Miles, Robert, of Berkeswell 0
4551890 2216539 2216539 defendant Shirwode Robert   713738 713738 Shirwode, Robert, of Berkeswell 3
4551891 2216539 2216539 defendant Myle John   713738 713738 Myle, John, of Berkeswell 4
4558516 2218614 2218614 defendant Myle John   713738 713738 Myle, John, of Berkeswell 0
4558517 2218614 2218614 defendant Ranys Richard   713738 713738 Ranys, Richard, of Berkeswell, servant of John 1
4692721 2263233 2263233 defendant Phelippes John chapman 713738 713738 Phelippes, John, of Berkeswell, chapman 1
4697746 2264789 2264789 defendant Kendale William husbandman 713738 713738 Kendale, William, of Berkeswell, husbandman 0
4697747 2264789 2264789 defendant Kendale Simon husbandman 713738 713738 Kendale, Simon, of Berkeswell, husbandman 1
4697748 2264789 2264789 defendant Kendale Alice widow 713738 713738 Kendale, Alice, of Berkeswell, widow 2
4721456 2272044 2272044 plaintiff Caytewayte John   713738 713738 Caytewayte, John, of Berkeswell 0
4815066 2300825 2300825 defendant Fox Thomas parker 713738 713738 Fox, Thomas, of Berkeswell, parker 0
4853804 2312601 2312601 defendant Myles John laborer 713738 713738 Myles, John, of Berkeswell, laborer 2
4867772 2316889 2316889 defendant Holt John husbandman 713738 713738 Holt, John, of Berkeswell, husbandman 4
4922326 2333394 2333394 defendant Bysshop John   713738 713738 Bysshop, John, of Berkeswell 20
4922327 2333394 2333394 defendant Bysshop William   713738 713738 Bysshop, William, of Berkeswell 21
4922328 2333394 2333394 defendant Middelton Thomas   713738 713738 Middelton, Thomas, of Berkeswell 22
4922330 2333394 2333394 defendant Middelton William   713738 713738 Middelton, William, of Berkeswell 24
4922331 2333394 2333394 defendant Middelton Christiane widow 713738 713738 Middelton, Christiane, of Berkeswell, widow 25
4922332 2333394 2333394 defendant Miles John   713738 713738 Miles, John, of Berkeswell 26
4936177 2337715 2337715 defendant Deye William husbandman 713738 713738 Deye, William, of Berkeswell, husbandman 1
4941960 2339470 2339470 defendant Starky alias Castell Stephen chaplain 713738 713738 Starky alias Castell, Stephen, of Berkeswell, chaplain 0
4943038 2339799 2339799 plaintiff Fox Thomas yeoman 713738 713738 Fox, Thomas, of Berkeswell, yeoman 1
4943039 2339799 2339799 plaintiff Staunton William husbandman 713738 713738 Staunton, William, of Berkeswell, husbandman 2
4943040 2339799 2339799 plaintiff Garaunde Yevan dyker 713738 713738 Garaunde, Yevan, of Berkeswell, dyker 3
4943041 2339799 2339799 defendant Hervy Robert husbandman 713738 713738 Hervy, Robert, of Berkeswell, husbandman 0
4943043 2339799 2339799 defendant Harreys John husbandman 713738 713738 Harreys, John, of Berkeswell, husbandman 2
4943044 2339799 2339799 defendant Bysshoppe William husbandman 713738 713738 Bysshoppe, William, of Berkeswell, husbandman 3
4943045 2339799 2339799 defendant Slogh John husbandman 713738 713738 Slogh, John, of Berkeswell, husbandman 4
4943046 2339799 2339799 defendant Hervy Richard husbandman 713738 713738 Hervy, Richard, of Berkeswell, husbandman 5
4954787 2343389 2343389 defendant Ichyngton Benedict laborer 713738 713738 Ichyngton, Benedict, of Berkeswell, laborer 0
4957700 2344275 2344275 defendant Alred John husbandman 713738 713738 Alred, John, of Berkeswell, husbandman 0
4957701 2344275 2344275 defendant Hervy Robert husbandman 713738 713738 Hervy, Robert, of Berkeswell, husbandman 1
4963691 2346051 2346051 defendant Raves William husbandman 713738 713738 Raves, William, of Berkeswell, husbandman 1
5004201 2358119 2358119 defendant Defford William chapman 713738 713738 Defford, William, of Berkeswell, chapman 0
5114429 2390617 2390617 defendant Dye William husbandman 713738 713738 Dye, William, of Berkeswell, husbandman 2
5135964 2397031 2397031 defendant Clapam Richard yeoman 713738 713738 Clapam, Richard, of Berkeswell, yeoman 2
5135966 2397031 2397031 defendant Blasebroke James yeoman 713738 713738 Blasebroke, James, of Berkeswell, yeoman 4
5135969 2397031 2397031 defendant Smyth Thomas yeoman 713738 713738 Smyth, Thomas, of Berkeswell, yeoman 7
5135970 2397031 2397031 defendant Walker John yeoman 713738 713738 Walker, John, of Berkeswell, yeoman 8
5139958 2398168 2398168 defendant Mountfort Simon esq 713738 713738 Mountfort, Simon, of Berkeswell, esq 0
5146009 2399955 2399955 defendant Mountfort Simon esq 713738 713738 Mountfort, Simon, of Berkeswell, esq 0
5156241 2402986 2402986 defendant Clapam Richard yeoman 713738 713738 Clapam, Richard, of Berkeswell, yeoman 0
5156243 2402986 2402986 defendant Glasebroke James yeoman 713738 713738 Glasebroke, James, of Berkeswell, yeoman 2
5156246 2402986 2402986 defendant Smyth Thomas yeoman 713738 713738 Smyth, Thomas, of Berkeswell, yeoman 5
5156247 2402986 2402986 defendant Walker John yeoman 713738 713738 Walker, John, of Berkeswell, yeoman 6
5156251 2402987 2402987 defendant Clapam Richrd yeoman 713738 713738 Clapam, Richrd, of Berkeswell, yeoman 0
5156253 2402987 2402987 defendant Glasebroke James yeoman 713738 713738 Glasebroke, James, of Berkeswell, yeoman 2
5156256 2402987 2402987 defendant Smyth Thomas yeoman 713738 713738 Smyth, Thomas, of Berkeswell, yeoman 5
5156257 2402987 2402987 defendant Walker John yeoman 713738 713738 Walker, John, of Berkeswell, yeoman 6
5156263 2402988 2402988 defendant Blapam Richard yeoman 713738 713738 together with Blapam, Richard, of Berkeswell, yeoman 2
5156265 2402988 2402988 defendant Glasebroke James yeoman 713738 713738 Glasebroke, James, of Berkeswell, yeoman 4
5156269 2402988 2402988 defendant Walker John yeoman 713738 713738 Walker, John, of Berkeswell, yeoman 8
5217165 2420756 2420756 defendant Walker William yeoman 713738 713738 Walker, William, of Berkeswell, yeoman 0
5217168 2420757 2420757 defendant Walker William yeoman 713738 713738 Walker, William, of Berkeswell, yeoman 0
5221068 2421865 2421865 defendant Caytellayte Robert husbandman 713738 713738 Caytellayte, Robert, of Berkeswell, husbandman 0
5221069 2421865 2421865 defendant Tryncokkes John husbandman 713738 713738 Tryncokkes, John, of Berkeswell, husbandman 1
5221071 2421866 2421866 defendant Caytewayte Robert husbandman 713738 713738 Caytewayte, Robert, of Berkeswell, husbandman 0
5221072 2421866 2421866 defendant Tryncokkes John husbandman 713738 713738 Tryncokkes, John, of Berkeswell, husbandman 1
5236062 2426130 2426130 defendant Averey John yeoman 713738 713738 Averey, John, of Berkeswell, yeoman 3
5295952 2443805 2443805 defendant Averey John husbandman 713738 713738 Averey, John, of Berkeswell, husbandman 0
5376822 2468344 2468344 defendant Bradshawe Thomas yeoman 713738 713738 Bradshawe, Thomas, of Berkeswell, yeoman 0
5376824 2468345 2468345 defendant Bradshawe Thomas yeoman 713738 713738 Bradshawe, Thomas, of Berkeswell, yeoman 0
5390780 2472428 2472428 defendant Andrey William collier 713738 713738 Andrey, William, of Berkeswell, collier 1
5394353 2473452 2473452 defendant Wodyll Thomas   713738 713738 Wodyll, Thomas, of Berkeswell, esquire 0
5407567 2477233 2477233 defendant Wodyll Thomas esq 713738 713738 Wodyll, Thomas, of Berkeswell, esq 0
5453416 2490911 2490911 defendant Wodyll Thomas esq 713738 713738 Wodyll, Thomas, of Berkeswell, esq 0
5455540 2491566 2491566 defendant Botham William yeoman 713738 713738 Botham, William, of Berkeswell, yeoman 2
5465340 2494540 2494540 defendant Wodyll Thomas esq 713738 713738 Wodyll, Thomas, of Berkeswell, esq 0
5467286 2495163 2495163 defendant Becham William yeoman 713738 713738 Becham, William, of Berkeswell, yeoman 2
5476831 2498074 2498074 defendant Wodyll Thomas esq 713738 713738 Wodyll, Thomas, of Berkeswell, esq 0
5478568 2498618 2498618 defendant Becham William yeoman 713738 713738 Becham, William, of Berkeswell, yeoman 3
5482141 2499599 2499599 defendant Adnet alias Smyth Richard butcher 713738 713738 Adnet alias Smyth, Richard, of Berkeswell, husbandman, or of Kelyngworth, butcher 0
5497594 2504223 2504223 defendant Beaucham William husbandman 713738 713738 Beaucham, William, of Berkeswell, husbandman 0
5497595 2504223 2504223 defendant Beaucham Robert husbandman 713738 713738 Beaucham, Robert, of Berkeswell, husbandman 1
5497596 2504223 2504223 defendant Beaucham John husbandman 713738 713738 Beaucham, John, of Berkeswell, husbandman 2
5497597 2504223 2504223 defendant Wade Thomas husbandman 713738 713738 Wade, Thomas, of Berkeswell, husbandman 3
5502212 2505617 2505617 defendant Averey William laborer 713738 713738 Averey, William, of Berkeswell, laborer 1
5505466 2506627 2506627 defendant Myles Richard butcher 713738 713738 Myles, Richard, of Berkeswell, butcher 0
5505467 2506627 2506627 defendant Bradnoke John laborer 713738 713738 Bradnoke, John, of Berkeswell, laborer 1
5505468 2506627 2506627 defendant Carre John laborer 713738 713738 Carre, John, of Berkeswell, laborer 2
5628479 2552877 2552877 defendant Alrede William husbandman 713738 713738 Alrede, William, of Berkeswell, husbandman 0
5630669 2553598 2553598 defendant Eldnale Robert husbandman 713738 713738 Eldnale, Robert, of Berkeswell, 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);