names

52 rows where place_id = 627227

✎ 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
3774949 1949896 1949896 defendant Rygeway John glover 627227 627227 Rygeway, John, of Frome Selwood, Soms, glover 0
3865987 1978857 1978857 defendant (not given) William vicar of Colyns 627227 627227 Colyns, William, of Frome Selwood, Soms, vicar of Chircham 0
3897446 1989360 1989360 defendant Leversage Robert esq 627227 627227 Leversage, Robert, of Frome Selwood, Soms, esq 0
3944640 2005223 2005223 defendant Leversage William esq 627227 627227 Leversage, William, of Frome Selwood, Soms, esq, son of Leversage, Robert, of Frome Selwood, esq 0
3965980 2012722 2012722 plaintiff Blackborowghe Peter clothier 627227 627227 Blackborowghe, Peter, of Frome Selwood, Soms, clothier 0
3975033 2015830 2015830 defendant Pryor Henry butcher 627227 627227 Pryor, Henry, of Frome Selwood, Soms, butcher 0
3978254 2016977 2016977 defendant Pryor Henry butcher 627227 627227 Pryor, Henry, of Frome Selwood, Soms, butcher 2
3978260 2016978 2016978 defendant Jurden Richard butcher 627227 627227 Jurden, Richard, of Frome Selwood, Soms, butcher 2
3978266 2016980 2016980 defendant Jurdeyn Richard butcher 627227 627227 Jurdeyn, Richard, of Frome Selwood, Soms, butcher 0
3989989 2021172 2021172 defendant Blackborowe Peter clothier 627227 627227 Blackborowe, Peter, of Frome Selwood, Soms, clothier 0
4011650 2028905 2028905 defendant Blackborowe Peter yeoman 627227 627227 Blackborowe, Peter, of Frome Selwood, Soms, yeoman 0
4035267 2037290 2037290 defendant Wympewe John chapman 627227 627227 Wympewe, John, of Frome Selwood, Soms, chapman 0
4035281 2037294 2037294 defendant Wympole John chapman 627227 627227 Wympole, John, of Frome Selwood, Soms, chapman 0
4037345 2038021 2038021 plaintiff Jurdayne Thomas tanner 627227 627227 Jurdayne, Thomas, of Frome Selwood, Soms, tanner 0
4037363 2038027 2038027 plaintiff Jurden Thomas tanner 627227 627227 Jurden, Thomas, of Frome Selwood, Soms, tanner 0
4037366 2038028 2038028 plaintiff Jurden Thomas tanner 627227 627227 Jurden, Thomas, of Frome Selwood, Soms, tanner 0
4037372 2038029 2038029 plaintiff Jurden Thomas tanner 627227 627227 Jurden, Thomas, of Frome Selwood, Soms, tanner 0
4037376 2038030 2038030 plaintiff Jurden Thomas tanner 627227 627227 Jurden, Thomas, of Frome Selwood, Soms, tanner 0
4053987 2043804 2043804 plaintiff Auley Edward shoemaker 627227 627227 Auley, Edward, of Frome Selwood, Soms, shoemaker 0
4072372 2050422 2050422 plaintiff Owborne John husbandman 627227 627227 Owborne, John, of Frome Selwood, Soms, husbandman 0
4103426 2061510 2061510 defendant Balley Robert chapman 627227 627227 Balley, Robert, of Frome Selwood, Soms, chapman 0
4147308 2077197 2077197 defendant Mawdley Thomas gent 627227 627227 Mawdley, Thomas, of Frome Selwood, Soms, gent 0
4147316 2077199 2077199 defendant Balley Robert mercer 627227 627227 Balley, Robert, of Frome Selwood, Soms, mercer 2
4161467 2082087 2082087 defendant Heliard William chapman 627227 627227 Heliard, William, of Frome Selwood, Soms, chapman 1
4162643 2082494 2082494 defendant Trevor Robert vintner 627227 627227 Trevor, Robert, of Frome Selwood, Soms, vintner 0
4169990 2084996 2084996 defendant Howse Richard yeoman 627227 627227 Howse, Richard, of Frome Selwood, Soms, yeoman 2
4169995 2084997 2084997 defendant Howse Richard yeoman 627227 627227 Howse, Richard, of Frome Selwood, Soms, yeoman 2
4191527 2092598 2092598 defendant Whetley William chapman 627227 627227 Whetley, William, of Frome Selwood, Soms, chapman 0
4201168 2095960 2095960 defendant Balley Robert chapman 627227 627227 Balley, Robert, of Frome Selwood, Soms, chapman 0
4236158 2108216 2108216 defendant Palmer William tailor 627227 627227 Palmer, William, of Frome Selwood, Soms, tailor 2
4256358 2115095 2115095 defendant Palmer William tailor 627227 627227 Palmer, William, of Frome Selwood, Soms, tailor 2
4258627 2115848 2115848 defendant Mawdley Thomas gent 627227 627227 Mawdley, Thomas, of Frome Selwood, Soms, gent 0
4280939 2123238 2123238 defendant Meryck Maurice vintner 627227 627227 Meryck, Maurice, of Frome Selwood, Soms, vintner 0
4285831 2124984 2124984 defendant Adyn Robert gent 627227 627227 Adyn, Robert, of Frome Selwood, Soms, or of Dorchester, Dorset, gent 0
4303006 2131177 2131177 defendant Corsley Richard mercer 627227 627227 Corsley, Richard, of Frome Selwood, Soms, mercer 0
4323547 2138293 2138293 defendant Waddeswore Richard yeoman 627227 627227 Waddeswore, Richard, of Frome Selwood, Soms, yeoman 2
4326259 2139148 2139148 defendant Adyn Robert gent 627227 627227 Adyn, Robert, of Frome Selwood, Soms, or of Dorchester, Dorset, gent 0
4344932 2145506 2145506 defendant Langley Thomas yeoman 627227 627227 Langley, Thomas, of Frome Selwood, Soms, yeoman 0
4397096 2163597 2163597 defendant Ballye Robert mercer 627227 627227 Ballye, Robert, of Frome Selwood, Soms, mercer 0
4404578 2166102 2166102 defendant Acourt Thomas yeoman 627227 627227 Acourt, Thomas, of Frome Selwood, Soms, yeoman 0
4409618 2167814 2167814 defendant Leuse John chapman 627227 627227 Leuse, John, of Frome Selwood, Soms, chapman 1
4559436 2218898 2218898 defendant Beche John   627227 627227 Beche, John, of Frome Selwood, Soms 2
4719139 2271334 2271334 defendant Mohun William gent 627227 627227 Mohun, William, of Frome Selwood, Soms, gent 0
4802794 2297062 2297062 defendant Tyly Nicholas husbandman 627227 627227 Tyly, Nicholas, of Frome Selwood, Soms, husbandman 0
4834017 2306645 2306645 defendant Ruddok Ralph weaver 627227 627227 Ruddok, Ralph, of Frome Selwood, Soms, weaver 0
4834021 2306646 2306646 defendant Ruddok Ralph weaver 627227 627227 Ruddok, Ralph, of Frome Selwood, Soms, weaver 0
5043692 2369734 2369734 defendant Lyversegge or Liversedge Robert esq 627227 627227 Lyversegge or Liversedge, Robert, of Frome Selwood, Soms, esq 0
5128242 2394735 2394735 defendant Stoghton John clothman 627227 627227 Stoghton, John, of Frome Selwood, Soms, clothman 3
5405693 2476703 2476703 defendant Smale John   627227 627227 Smale, John, of Frome Selwood, Soms 0
5408529 2477515 2477515 defendant Wyncote Robert yeoman 627227 627227 Wyncote, Robert, of Frome Selwood, Soms, yeoman 1
5409242 2477729 2477729 defendant Osborn Margery widow 627227 627227 Osborn, Margery, of Frome Selwood, Soms, widow 2
5470379 2496063 2496063 defendant Osbern Margery widow 627227 627227 Osbern, Margery, of Frome Selwood, Soms, widow 5

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