names

63 rows where place_id = 757422

✎ 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
4414561 2169457 2169457 defendant Honyman Alice kinsman & heir to Philip Agward 757422 757422 Honyman, Alice, of Bereford, formerly wife of Gilbert who vouched Agward, Robert, kinsman & heir to Philip Agward 0
4418061 2170530 2170530 defendant Cronke John le   757422 757422 Cronke, John le, of Bereford, son of Stephen 0
4445762 2183615 2183615 plaintiff Cursum William   757422 757422 Cursum, William, of Bereford 0
4445767 2183617 2183617 plaintiff Curszon William   757422 757422 Curszon, William, of Bereford 1
4455222 2186639 2186639 defendant Saltere Thomas   757422 757422 Saltere, Thomas, of Bereford 0
4477213 2193541 2193541 defendant Lambard Richard   757422 757422 Lambard, Richard, of Bereford 3
4487915 2196942 2196942 plaintiff Spycer Robert   757422 757422 Spycer, Robert, of Bereford, on his own account 0
4515640 2205315 2205315 defendant Bryan Walter   757422 757422 Bryan, Walter, of Bereford 1
4545739 2214596 2214596 defendant Shawe Thomas   757422 757422 Shawe, Thomas, of Bereford 0
4559017 2218780 2218780 defendant Dounham John   757422 757422 Dounham, John, of Bereford 0
4571336 2222619 2222619 defendant Malyn Thomas   757422 757422 Malyn, Thomas, of Bereford 0
4588562 2227795 2227795 defendant Bocher Walter   757422 757422 Bocher, Walter, of Bereford 0
4596298 2230093 2230093 defendant Kybbull William   757422 757422 Kybbull, William, of Bereford 0
4601304 2231645 2231645 plaintiff Veysy John   757422 757422 Veysy, John, of Bereford, son of Robert 0
4601305 2231645 2231645 defendant Sotyll William   757422 757422 Sotyll, William, of Bereford 0
4601306 2231645 2231645 defendant Bocher Walter   757422 757422 together with Bocher, Walter, of Bereford 1
4614855 2235651 2235651 defendant Geffrays William   757422 757422 Geffrays, William, of Bereford 0
4632676 2241105 2241105 defendant Hore John   757422 757422 Hore, John, of Bereford 0
4643534 2244209 2244209 defendant Blok John   757422 757422 Blok, John, of Bereford 0
4667027 2255419 2255419 defendant Shawe Thomas husbandman 757422 757422 Shawe, Thomas, of Bereford, husbandman 0
4674785 2257728 2257728 defendant Drake Thomas   757422 757422 Drake, Thomas, of Bereford, vicar 0
4688004 2261818 2261818 defendant More Robert maltman 757422 757422 More, Robert, of Bereford, maltman 0
4691398 2262834 2262834 defendant Underwode Thomas husbandman 757422 757422 Underwode, Thomas, of Bereford, husbandman 0
4698199 2264922 2264922 defendant Crenker Stephen gent 757422 757422 Crenker, Stephen, of Bereford, gent 0
4698200 2264922 2264922 defendant Blok John husbandman 757422 757422 Blok, John, of Bereford, husbandman 1
4698201 2264922 2264922 defendant Kyng William husbandman 757422 757422 Kyng, William, of Bereford, husbandman 2
4698834 2265115 2265115 defendant Veysy John husbandman 757422 757422 Veysy, John, of Bereford, husbandman 0
4723407 2272631 2272631 defendant Veysy John husbandman 757422 757422 Veysy, John, of Bereford, husbandman 0
4727643 2273887 2273887 plaintiff Hille John   757422 757422 Hille, John, of Bereford 0
4732045 2275202 2275202 defendant Sever William husbandman 757422 757422 Sever, William, of Bereford, husbandman 0
4738729 2277200 2277200 defendant Wynrysshe Thomas   757422 757422 Wynrysshe, Thomas, of Bereford, wool man 0
4739178 2277347 2277347 defendant Wynrysshe Thomas woolman 757422 757422 Wynrysshe, Thomas, of Bereford, woolman 0
4739680 2277485 2277485 defendant Pygot John husbandman 757422 757422 Pygot, John, of Bereford, husbandman 0
4739681 2277485 2277485 defendant Fysshere Henry husbandman 757422 757422 Fysshere, Henry, of Bereford, husbandman 1
4739682 2277485 2277485 defendant Kybbyll William husbandman 757422 757422 Kybbyll, William, of Bereford, husbandman 2
4765679 2285260 2285260 defendant More John husbandman 757422 757422 More, John, of Bereford, husbandman 0
4770680 2286811 2286811 plaintiff Reynold John   757422 757422 Reynold, John, of Bereford, parson & clerk 0
4798559 2295728 2295728 defendant More Robert   757422 757422 More, Robert, of Bereford, knight 0
4839401 2308244 2308244 defendant Derham Thomas tailor 757422 757422 Derham, Thomas, of Bereford, tailor 1
4842841 2309302 2309302 defendant Dawe Richard husbandman 757422 757422 Dawe, Richard, of Bereford, husbandman 0
4842842 2309302 2309302 defendant Dawe Hugh laborer 757422 757422 Dawe, Hugh, of Bereford, laborer 1
4858601 2314064 2314064 defendant Quarell Michael husbandman 757422 757422 Quarell, Michael, of Bereford, husbandman 4
4861465 2314956 2314956 defendant Becher Thomas husbandman 757422 757422 Becher, Thomas, of Bereford, husbandman 2
4868655 2317170 2317170 defendant Pycott Thomas husbandman 757422 757422 Pycott, Thomas, of Bereford, husbandman 0
4868656 2317170 2317170 defendant Kyng William husbandman 757422 757422 Kyng, William, of Bereford, husbandman 1
4954131 2343203 2343203 defendant Carpenter George husbandman 757422 757422 Carpenter, George, of Bereford, husbandman 0
5072469 2378252 2378252 defendant Wotton John butcher 757422 757422 Wotton, John, of Bereford, butcher 0
5072470 2378252 2378252 defendant Fyssher John husbandman 757422 757422 Fyssher, John, of Bereford, husbandman 1
5072471 2378252 2378252 defendant Fyssher Walter husbandman 757422 757422 Fyssher, Walter, of Bereford, husbandman 2
5072472 2378252 2378252 defendant Aungewyn John husbandman 757422 757422 Aungewyn, John, of Bereford, husbandman 3
5072473 2378252 2378252 defendant Spryng Thomas husbandman 757422 757422 Spryng, Thomas, of Bereford, husbandman 4
5072474 2378252 2378252 defendant Byworthe John husbandman 757422 757422 Byworthe, John, of Bereford, husbandman 5
5072475 2378252 2378252 defendant Quarell Thomas husbandman 757422 757422 Quarell, Thomas, of Bereford, husbandman 6
5079564 2380376 2380376 defendant White Thomas husbandman 757422 757422 White, Thomas, of Bereford, husbandman 1
5080130 2380543 2380543 defendant Lane Robert husbandman 757422 757422 Lane, Robert, of Bereford, husbandman 4
5097812 2385786 2385786 defendant Lane Robert husbandman 757422 757422 Lane, Robert, of Bereford, husbandman 1
5145153 2399725 2399725 defendant Bretvyle William gent 757422 757422 Bretvyle, William, of Bereford, gent 2
5145159 2399727 2399727 defendant Bretvyle William gent 757422 757422 Bretvyle, William, of Bereford, gent 2
5165724 2405719 2405719 defendant Bretvyle William gent 757422 757422 Bretvyle, William, of Bereford, gent 2
5180122 2409927 2409927 defendant Bretvyle William gent 757422 757422 Bretvyle, William, of Bereford, gent 2
5616890 2549092 2549092 plaintiff Jowe William   757422 757422 Jowe, William, of Bereford, administrators of 0
5616891 2549092 2549092 plaintiff Palmere John   757422 757422 (Palmere, John, of Bereford 1
5635975 2555203 2555203 defendant Boreman Thomas husbandman 757422 757422 Boreman, Thomas, of Bereford, 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);