names

61 rows where place_id = 591302

✎ 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
3604007 1868919 1868919 defendant Ploughmaker Elizabeth widow 591302 591302 Ploughmaker, Elizabeth, of Cirencestre, widow 1
3606997 1869853 1869853 plaintiff Pratte Thomas (legal representative) 591302 591302 Pratte, Thomas, of Cirencestre, executrix of 0
3696758 1925211 1925211 defendant Tynbury Baldwin yeoman 591302 591302 Tynbury, Baldwin, of Cirencestre, yeoman 0
3696759 1925211 1925211 defendant Rogers David baker 591302 591302 Rogers, David, of Cirencestre, baker 1
3747189 1941040 1941040 defendant Wynard Henry laborer 591302 591302 Wynard, Henry, of Cirencestre, laborer 0
3773188 1949321 1949321 defendant Vynor Richard innholder 591302 591302 Vynor, Richard, of Cirencestre, innholder 0
3779155 1951204 1951204 plaintiff Dune Thomas   591302 591302 Dune, Thomas, of Cirencestre 0
3779156 1951204 1951204 defendant Vele Walter clerk 591302 591302 Vele, Walter, of Cirencestre, clerk 0
3779157 1951204 1951204 defendant John William clerk 591302 591302 John, William, of Cirencestre, clerk 1
3779158 1951204 1951204 defendant Lynne John clerk 591302 591302 Lynne, John, of Cirencestre, clerk 2
3786068 1953433 1953433 defendant North John yeoman 591302 591302 North, John, of Cirencestre, yeoman 0
3823200 1965169 1965169 plaintiff Tolle Elizabeth widow 591302 591302 Tolle, Elizabeth, of Cirencestre, widow 0
3860704 1977073 1977073 defendant Pyrton William weaver 591302 591302 Pyrton, William, of Cirencestre, weaver 1
3860705 1977073 1977073 defendant Eten John waxman 591302 591302 Eten, John, of Cirencestre, waxman 2
3875929 1982203 1982203 defendant Done Thomas tailor 591302 591302 Done, Thomas, of Cirencestre, tailor 1
3880101 1983600 1983600 defendant Donne Thomas tailor 591302 591302 Donne, Thomas, of Cirencestre, tailor 0
3886103 1985602 1985602 defendant Stylle William yeoman 591302 591302 Stylle, William, of Cirencestre, yeoman 2
3892120 1987617 1987617 defendant Scole or Ecole John weaver 591302 591302 Scole or Ecole, John, of Cirencestre, weaver 0
3892121 1987617 1987617 defendant Webbe Richard shoemaker 591302 591302 Webbe, Richard, of Cirencestre, shoemaker 1
4462535 2188980 2188980 plaintiff Tannere William   591302 591302 Tannere, William, of Cirencestre 0
4470356 2191376 2191376 defendant Russell Robert   591302 591302 Russell, Robert, of Cirencestre 0
4471961 2191898 2191898 defendant Shethere John   591302 591302 Shethere, John, of Cirencestre 1
4471962 2191898 2191898 defendant Barbour John   591302 591302 Barbour, John, of Cirencestre 2
4471963 2191898 2191898 defendant Webbe Henry   591302 591302 Webbe, Henry, of Cirencestre 3
4567172 2221294 2221294 defendant Halle Richard   591302 591302 Halle, Richard, of Cirencestre 1
4567173 2221294 2221294 defendant Clerk John   591302 591302 Clerk, John, of Cirencestre 2
4629326 2240104 2240104 defendant Thryft John   591302 591302 Thryft, John, of Cirencestre 0
4668201 2255765 2255765 defendant Hoper John chapman 591302 591302 Hoper, John, of Cirencestre, chapman 0
4668722 2255932 2255932 defendant Tyrell John glover 591302 591302 Tyrell, John, of Cirencestre, glover 0
4668982 2256003 2256003 defendant Norton John sadler 591302 591302 Norton, John, of Cirencestre, sadler 0
4668983 2256003 2256003 defendant Sadeler Robert sadler 591302 591302 Sadeler, Robert, of Cirencestre, sadler 1
4669796 2256254 2256254 defendant Chesturtone John gent 591302 591302 Chesturtone, John, of Cirencestre, gent 0
4671081 2256621 2256621 defendant Sadlere Robert sadler 591302 591302 Sadlere, Robert, of Cirencestre, sadler 1
4671082 2256621 2256621 defendant Sadler James sadler 591302 591302 Sadler, James, of Cirencestre, sadler 2
4676448 2258246 2258246 plaintiff Glovare William   591302 591302 Glovare, William, of Cirencestre 0
4676450 2258246 2258246 defendant Wyot Thomas butcher 591302 591302 Wyot, Thomas, of Cirencestre, butcher 1
4681966 2259975 2259975 defendant Derlyng Thomas chapman 591302 591302 Derlyng, Thomas, of Cirencestre, chapman 0
4681968 2259975 2259975 defendant Rumpyn Henry butcher 591302 591302 Rumpyn, Henry, of Cirencestre, butcher 2
4686644 2261433 2261433 defendant Lovekyn John tanner 591302 591302 Lovekyn, John, of Cirencestre, tanner 1
4688285 2261904 2261904 defendant Draper William chapman 591302 591302 Draper, William, of Cirencestre, chapman 1
4688286 2261904 2261904 defendant Draper John chapman 591302 591302 Draper, John, of Cirencestre, chapman 2
4690205 2262494 2262494 plaintiff Welyfed John   591302 591302 Welyfed, John, of Cirencestre 0
4690207 2262494 2262494 defendant Hawardyn Thomas glover 591302 591302 Hawardyn, Thomas, of Cirencestre, glover 1
4819611 2302205 2302205 plaintiff Pipard Thomas   591302 591302 Pipard, Thomas, of Cirencestre, mason, on his own account 0
4894605 2324985 2324985 defendant Smale William baker 591302 591302 Smale, William, of Cirencestre, baker 0
4906738 2328692 2328692 defendant Radewey Thomas   591302 591302 Radewey, Thomas, of Cirencestre, bailiff 0
4906741 2328692 2328692 defendant Osteler David   591302 591302 Osteler, David, of Cirencestre, bailiff 3
4968901 2347662 2347662 defendant Morys Richard tailor 591302 591302 Morys, Richard, of Cirencestre, tailor 0
4974385 2349302 2349302 plaintiff Maschall or Mascald Thomas (legal representative) 591302 591302 Maschall or Mascald, Thomas, of Cirencestre, mason, executor of 0
4974391 2349303 2349303 defendant Baker Philip baker 591302 591302 Baker, Philip, of Cirencestre, baker 0
4974394 2349303 2349303 defendant Steneyate Richard weaver 591302 591302 Steneyate, Richard, of Cirencestre, weaver 3
4977295 2350166 2350166 defendant Straunge John cordwainer 591302 591302 Straunge, John, of Cirencestre, cordwainer 0
4978514 2350523 2350523 defendant Stertup Richard yeoman 591302 591302 Stertup, Richard, of Cirencestre, yeoman 0
4980702 2351165 2351165 defendant Lyde John fisher 591302 591302 Lyde, John, of Cirencestre, fisher 1
5079168 2380257 2380257 defendant Fanton John weaver 591302 591302 Fanton, John, of Cirencestre, weaver 0
5094185 2384704 2384704 defendant Wynston John weaver 591302 591302 Wynston, John, of Cirencestre, weaver 0
5237385 2426519 2426519 plaintiff Gairstang Henry (legal representative) 591302 591302 Gairstang, Henry, of Cirencestre, executors of 0
5251227 2430486 2430486 defendant Elmes John chapman 591302 591302 Elmes, John, of Cirencestre, chapman 2
5518900 2510749 2510749 defendant Sutton John yeoman 591302 591302 Sutton, John, of Cirencestre, yeoman 0
5580433 2528965 2528965 defendant Clowe Margaret widow 591302 591302 Clowe, Margaret, of Cirencestre, widow 1
5583333 2529858 2529858 defendant Reve Henry   591302 591302 Reve, Henry, of Cirencestre, parish clerk 1

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