names

48 rows where place_id = 614514

✎ 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
3704068 1927559 1927559 defendant Wodegate Walter teoman 614514 614514 Wodegate, Walter, of Pensherst, teoman 0
3781022 1951797 1951797 defendant Beche Lawrence tanner 614514 614514 Beche, Lawrence, of Pensherst, tanner 0
3794832 1956255 1956255 defendant Moyse Richard miller 614514 614514 Moyse, Richard, of Pensherst, miller 0
3943171 2004732 2004732 defendant Beche Walter yeoman 614514 614514 Beche Walter, of Pensherst, yeoman 0
3943173 2004733 2004733 defendant Beche Walter yeoman 614514 614514 Beche, Walter, of Pensherst, yeoman 0
4052019 2043146 2043146 defendant Ellis James yeoman 614514 614514 Ellis, James, of Pensherst, yeoman 0
4104374 2061847 2061847 defendant Skynner Edmund yeoman 614514 614514 Skynner, Edmund, of Pensherst, yeoman 2
4497433 2199844 2199844 defendant Lad William   614514 614514 Lad, William, of Pensherst 0
4500578 2200804 2200804 plaintiff Joop Henry   614514 614514 Joop, Henry, of Pensherst 0
4509440 2203423 2203423 defendant Kyng Roger   614514 614514 Kyng, Roger, of Pensherst 0
4543460 2213843 2213843 defendant Kyng Roger   614514 614514 Kyng, Roger, of Pensherst 0
4552180 2216635 2216635 plaintiff Fabyan Alice   614514 614514 Fabyan, Alice, of Pensherst 0
4552181 2216635 2216635 defendant Hogate William   614514 614514 Hogate, William, of Pensherst 0
4600619 2231421 2231421 defendant Cridde John   614514 614514 Cridde, John, of Pensherst 0
4610221 2234280 2234280 defendant Shorham John   614514 614514 Shorham, John, of Pensherst 1
4611526 2234668 2234668 defendant Ladde William   614514 614514 Ladde, William, of Pensherst 0
4618985 2236932 2236932 defendant Aleyn Nicholas   614514 614514 Aleyn, Nicholas, of Pensherst 0
4652058 2246579 2246579 defendant Hunte Richard husbandman 614514 614514 Hunte, Richard, of Pensherst, husbandman 0
4751578 2280948 2280948 defendant Clymme Henry laborer 614514 614514 Clymme, Henry, of Pensherst, laborer 0
4785008 2291324 2291324 defendant George John husbandman 614514 614514 George, John, of Pensherst, husbandman 0
4802687 2297027 2297027 defendant Hampton Thomas shoemaker 614514 614514 Hampton, Thomas, of Pensherst, shoemaker 3
4803096 2297155 2297155 defendant Hampton John husbandman 614514 614514 Hampton, John, of Pensherst, husbandman 0
4809401 2299117 2299117 defendant Hampton John chapman 614514 614514 Hampton, John, of Pensherst, chapman 0
4814915 2300773 2300773 defendant Waleys Walter gent 614514 614514 Waleys, Walter, of Pensherst, gent 0
4861192 2314864 2314864 defendant Spayn Gerard chaplain 614514 614514 Spayn, Gerard, of Pensherst, chaplain 0
4900320 2326735 2326735 defendant Phyppe Henry laborer 614514 614514 Phyppe, Henry, of Pensherst, laborer 0
4900321 2326735 2326735 defendant Mellyng Thomas laborer 614514 614514 Mellyng, Thomas, of Pensherst, laborer 1
4905686 2328379 2328379 plaintiff Salman Robert   614514 614514 Salman, Robert, of Pensherst 0
4913147 2330609 2330609 defendant Crondewell or Croudewell Nicholas husbandman 614514 614514 Crondewell or Croudewell, Nicholas, of Pensherst, husbandman 1
4915524 2331354 2331354 plaintiff Dorkynghole Robert   614514 614514 Dorkynghole, Robert, of Pensherst 0
4915526 2331354 2331354 defendant Dorkynghole Robert   614514 614514 Dorkynghole, Robert, of Pensherst 0
4916580 2331694 2331694 defendant atte Ford John yeoman 614514 614514 atte Ford, John, of Pensherst, yeoman 0
5055638 2373259 2373259 defendant Joseph Henry laborer 614514 614514 Joseph, Henry, of Pensherst, laborer 1
5055639 2373259 2373259 defendant Maynard John husbandman 614514 614514 Maynard, John, of Pensherst, husbandman 2
5090606 2383634 2383634 defendant Durkynghole Robert (legal representative) 614514 614514 Durkynghole, Robert, of Pensherst, yeoman, executor of 0
5090607 2383634 2383634 defendant Derkyngholl or Durkynghole Walter yeoman 614514 614514 Derkyngholl or Durkynghole, Walter, of Pensherst, yeoman 1
5142157 2398827 2398827 defendant Chambre Richard yeoman 614514 614514 Chambre, Richard, of Pensherst, yeoman 0
5229846 2424348 2424348 defendant Derkyngholl Walter gent 614514 614514 Derkyngholl, Walter, of Pensherst, gent 0
5444600 2488287 2488287 defendant Dorkynghole Walter husbandman 614514 614514 Dorkynghole, Walter, of Pensherst, husbandman 0
5444603 2488288 2488288 defendant Dorlenhold Walter husbandman 614514 614514 Dorlenhold, Walter, of Pensherst, husbandman 0
5445134 2488433 2488433 defendant Crundewell John husbandman 614514 614514 Crundewell, John, of Pensherst, husbandman 0
5445135 2488433 2488433 defendant Comeregge Richard husbandman 614514 614514 Comeregge, Richard, of Pensherst, husbandman 1
5445136 2488433 2488433 defendant Crundewell Nicholas husbandman 614514 614514 Crundewell, Nicholas, of Pensherst, husbandman 2
5457348 2492099 2492099 defendant Lorkynghole Walter husbandman 614514 614514 Lorkynghole, Walter, of Pensherst, husbandman 0
5493919 2503088 2503088 defendant Rogger John laborer 614514 614514 Rogger, John, of Pensherst, laborer 0
5493924 2503089 2503089 defendant Rogger John laborer 614514 614514 together with Rogger, John, of Pensherst, laborer 1
5493928 2503090 2503090 defendant Rogger John laborer 614514 614514 Rogger, John, of Pensherst, laborer 1
5575088 2527294 2527294 defendant Josepp Henry yeoman 614514 614514 Josepp, Henry, of Pensherst, yeoman 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);