names

49 rows where place_id = 592006

✎ 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
3606286 1869634 1869634 defendant Braunche Richard husbandman 592006 592006 Braunche, Richard, of Brokedyssh, husbandman 1
3674879 1918172 1918172 plaintiff Gryse William esq 592006 592006 Gryse, William, of Brokedyssh, esq 0
4592370 2228964 2228964 defendant Smyth William   592006 592006 Smyth, William, of Brokedyssh 0
4592374 2228966 2228966 defendant Smyth William   592006 592006 Smyth, William, of Brokedyssh 0
4602569 2232023 2232023 defendant Ole Henry   592006 592006 Ole, Henry, of Brokedyssh 4
4609271 2234003 2234003 defendant Peddere Robert   592006 592006 Peddere, Robert, of Brokedyssh 3
4617913 2236605 2236605 defendant Waryn Peter tailor 592006 592006 Waryn, Peter, of Brokedyssh, tailor 0
4657782 2248318 2248318 defendant Brokedyssh Robert pedder 592006 592006 Brokedyssh, Robert, of Brokedyssh, pedder 2
4672727 2257114 2257114 plaintiff Colyn William   592006 592006 Colyn, William, of Brokedyssh 0
4676919 2258398 2258398 defendant Trowan John   592006 592006 Trowan, John, of Brokedyssh 0
4693022 2263327 2263327 defendant Barwere John   592006 592006 Barwere, John, of Brokedyssh, shoe maker 0
4702189 2266094 2266094 defendant Trowan John   592006 592006 Trowan, John, of Brokedyssh 0
4702191 2266095 2266095 defendant Trowan John   592006 592006 Trowan, John, of Brokedyssh 0
4702200 2266096 2266096 defendant Grice Margaret   592006 592006 Grice, Margaret, of Brokedyssh 7
4705468 2267077 2267077 defendant Andrewe Henry yeoman 592006 592006 Andrewe, Henry, of Brokedyssh, yeoman 0
4714017 2269711 2269711 defendant Orewell Walter butcher 592006 592006 Orewell, Walter, of Brokedyssh, butcher 0
4719224 2271362 2271362 defendant Colyn Stephen   592006 592006 Colyn, Stephen, of Brokedyssh, tallow chandler 0
4754133 2281671 2281671 defendant Hogman Nicholas yeoman 592006 592006 Hogman, Nicholas, of Brokedyssh, yeoman 1
4797056 2295245 2295245 defendant Howard John pedder 592006 592006 Howard, John, of Brokedyssh, pedder 0
4798990 2295857 2295857 defendant Colyn Stephen husbandman 592006 592006 Colyn, Stephen, of Brokedyssh, husbandman 0
4812756 2300104 2300104 defendant Ferrour John mercer 592006 592006 Ferrour, John, of Brokedyssh, mercer 0
4845086 2309979 2309979 defendant Seman Simon   592006 592006 Seman, Simon, of Brokedyssh, pedlar 1
4866302 2316428 2316428 defendant Howard Robert yeoman 592006 592006 Howard, Robert, of Brokedyssh, yeoman 0
4874381 2318929 2318929 defendant Warde John pedder 592006 592006 Warde, John, of Brokedyssh, pedder 0
4905772 2328407 2328407 plaintiff Howard Robert   592006 592006 Howard, Robert, of Brokedyssh 0
4905774 2328407 2328407 defendant Goldyngham John yeoman 592006 592006 Goldyngham, John, of Brokedyssh, yeoman 1
4979241 2350749 2350749 defendant Howard Robert fisherman 592006 592006 Howard, Robert, of Brokedyssh, fisherman 0
4989705 2353836 2353836 defendant Howard John husbandman 592006 592006 Howard, John, of Brokedyssh, husbandman 7
4996146 2355705 2355705 plaintiff Grys William gent 592006 592006 Grys, William, of Brokedyssh, gent 0
5093971 2384635 2384635 defendant Scot Walter husbandman 592006 592006 Scot, Walter, of Brokedyssh, husbandman 0
5105655 2388102 2388102 defendant Skut Walter yeoman 592006 592006 Skut, Walter, of Brokedyssh, yeoman 9
5122112 2392888 2392888 defendant Grys Robert gent 592006 592006 Grys, Robert, of Brokedyssh, gent 0
5135633 2396932 2396932 defendant Cobell or Covell John yeoman 592006 592006 Cobell or Covell, John, of Brokedyssh, yeoman 3
5175386 2408491 2408491 defendant Grys William gent 592006 592006 Grys, William, of Brokedyssh, gent 0
5232828 2425185 2425185 defendant Skute Walter husbandman 592006 592006 Skute, Walter, of Brokedyssh, husbandman 1
5234676 2425729 2425729 defendant Skutt Walter yeoman 592006 592006 Skutt, Walter, of Brokedyssh, yeoman 3
5234677 2425729 2425729 defendant Dir- William yeoman 592006 592006 Dir-, William, of Brokedyssh, yeoman 4
5253255 2431116 2431116 defendant Wytham John husbandman 592006 592006 Wytham, John, of Brokedyssh, husbandman 0
5260104 2433283 2433283 defendant Byrd Thomas husbandman 592006 592006 Byrd, Thomas, of Brokedyssh, husbandman 0
5263684 2434392 2434392 defendant Corbowe John yeoman 592006 592006 Corbowe, John, of Brokedyssh, yeoman 0
5273809 2437416 2437416 defendant (illegible) William husbandman 592006 592006 ---, William, of Brokedyssh, husbandman 8
5282268 2439873 2439873 defendant Elwyn John husbadman 592006 592006 Elwyn, John, of Brokedyssh, husbadman 3
5303496 2446041 2446041 defendant Wytham John butcher 592006 592006 Wytham, John, of Brokedyssh, butcher 0
5316266 2449951 2449951 defendant Gryce William (legal representative) 592006 592006 Gryce, William, of Brokedyssh, gent, executrix of 0
5316267 2449951 2449951 defendant Gryce Margaret widow 592006 592006 Gryce, Margaret, of Brokedyssh, widow 1
5372457 2466981 2466981 defendant Howard William yeoman 592006 592006 Howard, William, of Brokedyssh, yeoman 0
5515267 2509620 2509620 defendant Eryes or Gryes Robert (legal representative) 592006 592006 Eryes or Gryes, Robert, of Brokedyssh, gent, executors of 0
5515268 2509620 2509620 defendant Eryes or Gryes Elizabeth widow 592006 592006 (Eryes or Gryes, Elizabeth, of Brokedyssh, widow 1
5515270 2509620 2509620 defendant Fleccher John clerk 592006 592006 Fleccher, John, of Brokedyssh, clerk 3

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);