names

45 rows where place_id = 598123

✎ 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
3631206 1904585 1904585 defendant Snodman John summoner 598123 598123 Snodman, John, of Pulbergh, summoner 3
3660286 1913478 1913478 defendant Maleberey Geoffrey tailor 598123 598123 Maleberey, Geoffrey, of Pulbergh, tailor 0
3694976 1924640 1924640 defendant Clerk Edward husbandman 598123 598123 Clerk, Edward, of Pulbergh, husbandman 1
3742521 1939534 1939534 defendant Ouley or Onley Thomas esq 598123 598123 Ouley or Onley, Thomas, of Pulbergh, esq 0
3872867 1981141 1981141 plaintiff Broker Robert husbandman 598123 598123 Broker, Robert, of Pulbergh, husbandman 0
4470541 2191432 2191432 defendant Brounesbery John   598123 598123 Brounesbery, John, of Pulbergh 1
4631603 2240773 2240773 defendant Brounesbery Richard   598123 598123 Brounesbery, Richard, of Pulbergh 0
4666721 2255319 2255319 defendant Payn Richard brasier 598123 598123 Payn, Richard, of Pulbergh, brasier 0
4670748 2256528 2256528 defendant Spycer Robert husbandman 598123 598123 Spycer, Robert, of Pulbergh, husbandman 1
4689581 2262299 2262299 defendant Codmere John husbandman 598123 598123 Codmere, John, of Pulbergh, husbandman 0
4691631 2262915 2262915 defendant Payn Richard   598123 598123 Payn, Richard, of Pulbergh, brass worker 0
4706581 2267437 2267437 defendant Walshe Thomas weaver 598123 598123 Walshe, Thomas, of Pulbergh, weaver 0
4715086 2270046 2270046 defendant Harlyng Thomas clerk 598123 598123 Harlyng, Thomas, of Pulbergh, clerk 1
4723969 2272796 2272796 defendant Walsshe Thomas weaver 598123 598123 Walsshe, Thomas, of Pulbergh, weaver 0
4777280 2288883 2288883 defendant atte Stapele Richard husbandman 598123 598123 atte Stapele, Richard, of Pulbergh, husbandman 1
4877474 2319912 2319912 defendant att Stapull Richard husbandman 598123 598123 att Stapull, Richard, of Pulbergh, husbandman 0
4884163 2321955 2321955 defendant Lyle Robert gent 598123 598123 Lyle, Robert, of Pulbergh, gent 0
4895257 2325175 2325175 defendant atte Mille John fuller 598123 598123 atte Mille, John, of Pulbergh, fuller 0
4895258 2325175 2325175 defendant atte Mille Richard fuller 598123 598123 together with atte Mille, Richard, of Pulbergh, fuller 1
5028065 2365086 2365086 defendant Bovelyd or Bouelyd Richard husbandman 598123 598123 Bovelyd or Bouelyd, Richard, of Pulbergh, husbandman 1
5028066 2365086 2365086 defendant Umfray Nicholas husbandman 598123 598123 Umfray, Nicholas, of Pulbergh, husbandman 2
5068590 2377096 2377096 defendant Puttok John gent 598123 598123 Puttok, John, of Pulbergh, gent 1
5105919 2388171 2388171 defendant Scot John   598123 598123 Scot, John, of Pulbergh, "cornleder" 0
5118690 2391897 2391897 defendant atte Hill Thomas, junior husbandman 598123 598123 atte Hill, Thomas, junior, of Pulbergh, husbandman 3
5145878 2399923 2399923 defendant Grene Patrick clerk & parson 598123 598123 Grene, Patrick, of Pulbergh, clerk & parson 0
5166209 2405842 2405842 defendant Grene Patrick   598123 598123 Grene, Patrick, of Pulbergh, parson & clerk 0
5180947 2410167 2410167 defendant Grene Patrick clerk & parson 598123 598123 Grene, Patrick, of Pulbergh, clerk & parson 0
5202628 2416533 2416533 defendant Grene Patrick   598123 598123 Grene, Patrick, of Pulbergh, parson 0
5255434 2431819 2431819 defendant Holme John laborer 598123 598123 Holme, John, of Pulbergh, laborer 0
5265815 2435061 2435061 defendant Lysle John esq 598123 598123 Lysle, John, of Pulbergh, esq 0
5265817 2435061 2435061 defendant Howeles John laborer 598123 598123 Howeles, John, of Pulbergh, laborer 2
5265818 2435061 2435061 defendant Harmode Robert laborer 598123 598123 Harmode, Robert, of Pulbergh, laborer 3
5283796 2440301 2440301 defendant Clerk Richard laborer 598123 598123 Clerk, Richard, of Pulbergh, laborer 6
5289683 2441985 2441985 defendant Humfrey Richard husbandman 598123 598123 Humfrey, Richard, of Pulbergh, husbandman 0
5291425 2442495 2442495 defendant Snodenham Richard husbandman 598123 598123 Snodenham, Richard, of Pulbergh, husbandman 0
5295676 2443729 2443729 defendant Berwyk Thomas yeoman 598123 598123 Berwyk, Thomas, of Pulbergh, yeoman 0
5310381 2448139 2448139 defendant Berwyk Thomas   598123 598123 Berwyk, Thomas, of Pulbergh, court holder 0
5334575 2455408 2455408 defendant Clerke Richard husbandman 598123 598123 Clerke, Richard, of Pulbergh, husbandman 14
5334576 2455408 2455408 defendant Underwode Thomas husbandman 598123 598123 Underwode, Thomas, of Pulbergh, husbandman 15
5334577 2455408 2455408 defendant Mascall Thomas husbandman 598123 598123 Mascall, Thomas, of Pulbergh, husbandman 16
5373075 2467171 2467171 defendant at Myll Joan widow 598123 598123 at Myll, Joan, of Pulbergh, widow 0
5471243 2496336 2496336 defendant Boghyer Thomas butcher 598123 598123 Boghyer, Thomas, of Pulbergh, butcher 0
5505650 2506687 2506687 plaintiff Brasiare Richard (legal representative) 598123 598123 Brasiare, Richard, of Pulbergh, executor of 0
5542819 2517875 2517875 defendant Lane John miller 598123 598123 Lane, John, of Pulbergh, miller 1
5612006 2547485 2547485 defendant Vyncent John   598123 598123 Vyncent, John, of Pulbergh, parson 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);