names

60 rows where place_id = 598222

✎ 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
3631626 1904706 1904706 defendant Frene John husbandman 598222 598222 Frene, John, of Chorleton, husbandman 1
3653796 1911446 1911446 defendant Bigge Peter husbandman 598222 598222 Bigge, Peter, of Chorleton, husbandman 0
3653797 1911446 1911446 defendant Smyth Richard husbandman 598222 598222 Smyth, Richard, of Chorleton, husbandman 1
3747248 1941060 1941060 defendant Hall Thomas husbandman 598222 598222 Hall, Thomas, of Chorleton, husbandman 0
3747250 1941061 1941061 defendant Hall Thomas husbandman 598222 598222 Hall, Thomas, of Chorleton, husbandman 0
3797356 1957060 1957060 defendant Cokk Robert husbandman 598222 598222 Cokk, Robert, of Chorleton, husbandman 9
3811873 1961618 1961618 defendant Steveson William husbandman 598222 598222 Steveson, William, of Chorleton, husbandman 1
3811874 1961618 1961618 defendant Burne Richard husbandman 598222 598222 Burne, Richard, of Chorleton, husbandman 2
3869765 1980130 1980130 defendant Godfray Richard husbandman 598222 598222 Godfray, Richard, of Chorleton, husbandman 0
3901052 1990579 1990579 defendant Stenson William husbandman 598222 598222 Stenson, William, of Chorleton, husbandman 2
3901615 1990767 1990767 defendant Ewan William husbandman 598222 598222 Ewan, William, of Chorleton, husbandman 0
3907891 1992928 1992928 defendant Rede Richard husbandman 598222 598222 Rede, Richard, of Chorleton, husbandman 1
3907892 1992928 1992928 defendant Palmer William husbandman 598222 598222 Palmer, William, of Chorleton, husbandman 2
3907893 1992928 1992928 defendant Plumtre John husbandman 598222 598222 Plumtre, John, of Chorleton, husbandman 3
4153780 2079421 2079421 defendant Turnor Humphrey husbandman 598222 598222 together with Turnor, Humphrey, of Chorleton, husbandman 3
4174456 2086534 2086534 defendant Ford William laborer 598222 598222 Ford, William, of Chorleton, laborer 1
4194279 2093546 2093546 defendant Flyntt William shoemaker 598222 598222 Flyntt, William, of Chorleton, shoemaker 0
4418190 2170569 2170569 defendant Chapman William   598222 598222 Chapman, William, of Chorleton 0
4441629 2182318 2182318 plaintiff Brackele John   598222 598222 Brackele, John, of Chorleton upon Otmoor, wool monger 0
4686697 2261451 2261451 defendant Balcok Richard   598222 598222 Balcok, Richard, of Chorleton 0
4746011 2279336 2279336 defendant Tony John husbandman 598222 598222 Tony, John, of Chorleton, husbandman 0
4766867 2285629 2285629 defendant Wylkyns William miller 598222 598222 Wylkyns, William, of Chorleton, miller 0
4766868 2285629 2285629 defendant Wylkyns Thomas weaver 598222 598222 Wylkyns, Thomas, of Chorleton, weaver 1
4791229 2293356 2293356 defendant Wilkyns William miller 598222 598222 Wilkyns, William, of Chorleton, miller 0
4791230 2293356 2293356 defendant Wilkyns Thomas weaver 598222 598222 Wilkyns, Thomas, of Chorleton, weaver 1
4814834 2300750 2300750 defendant Pachet Nicholas husbandman 598222 598222 Pachet, Nicholas, of Chorleton, husbandman 7
4819427 2302151 2302151 defendant Tony John husbandman 598222 598222 Tony, John, of Chorleton, husbandman 0
4883022 2321613 2321613 defendant atte Grange Robert husbandman 598222 598222 atte Grange, Robert, of Chorleton, husbandman 3
4965649 2346649 2346649 defendant More William husbandman 598222 598222 More, William, of Chorleton, husbandman 0
5046397 2370562 2370562 defendant Colyns Richard husbandman 598222 598222 Colyns, Richard, of Chorleton, husbandman 0
5046398 2370562 2370562 defendant Neweman William husbandman 598222 598222 Neweman, William, of Chorleton, husbandman 1
5082729 2381336 2381336 defendant Butler William yeoman 598222 598222 Butler, William, of Chorleton, yeoman 0
5098683 2386044 2386044 defendant Hornecastell John husbandman 598222 598222 Hornecastell, John, of Chorleton, husbandman 2
5099945 2386421 2386421 defendant Swynshede Henry gent 598222 598222 Swynshede, Henry, of Chorleton, gent 1
5118000 2391695 2391695 defendant Hornecastell John husbandman 598222 598222 Hornecastell, John, of Chorleton, husbandman 1
5121167 2392617 2392617 defendant Shelton Thomas yeoman 598222 598222 Shelton, Thomas, of Chorleton, yeoman 0
5121168 2392617 2392617 defendant Shelton William husbandman 598222 598222 Shelton, William, of Chorleton, husbandman 1
5126498 2394227 2394227 defendant Loysot Thomas husbandman 598222 598222 Loysot, Thomas, of Chorleton, husbandman 0
5136015 2397043 2397043 defendant Thacher or Chacher John husbandman 598222 598222 Thacher or Chacher, John, of Chorleton, husbandman 2
5156100 2402944 2402944 defendant Wyot William husbandman 598222 598222 Wyot, William, of Chorleton, husbandman 0
5156101 2402944 2402944 defendant Smyth William husbandman 598222 598222 Smyth, William, of Chorleton, husbandman 1
5258953 2432915 2432915 defendant Hopkyns Richard husbandman 598222 598222 Hopkyns, Richard, of Chorleton, husbandman 0
5261902 2433830 2433830 defendant Ewyas John walker 598222 598222 Ewyas, John, of Chorleton, walker 0
5261903 2433830 2433830 defendant Ewyas Philip walker 598222 598222 Ewyas, Philip, of Chorleton, walker 1
5261904 2433830 2433830 defendant Ewyas Hugh walker 598222 598222 Ewyas, Hugh, of Chorleton, walker 2
5261923 2433837 2433837 defendant Colmon William husbandman 598222 598222 Colmon, William, of Chorleton, husbandman 1
5271293 2436698 2436698 defendant Horncastell John husbandman 598222 598222 Horncastell, John, of Chorleton, husbandman 2
5489839 2501843 2501843 defendant Hopkyns Robert husbandman 598222 598222 Hopkyns, Robert, of Chorleton, husbandman 1
5526459 2512841 2512841 defendant Wolmer John gent 598222 598222 Wolmer, John, of Chorleton, gent 0
5526461 2512842 2512842 defendant Wolmer John gent 598222 598222 Wolmer, John, of Chorleton, gent 0
5549753 2519959 2519959 defendant Barne Joan widow 598222 598222 Barne, Joan, of Chorleton, widow 2
5554345 2521309 2521309 defendant Smert John miller 598222 598222 Smert, John, of Chorleton, miller 2
5583755 2529993 2529993 defendant Edwardes Thomas husbandman 598222 598222 Edwardes, Thomas, of Chorleton, husbandman 0
5586269 2530749 2530749 defendant Eggeck John husbandman 598222 598222 Eggeck, John, of Chorleton, husbandman 0
5591482 2532308 2532308 defendant Chawcy William gent 598222 598222 Chawcy, William, of Chorleton, gent 0
5607029 2537094 2537094 defendant Halys Thomas husbandman 598222 598222 Halys, Thomas, of Chorleton, husbandman 0
5607030 2537094 2537094 defendant Stevynson John tailor 598222 598222 Stevynson, John, of Chorleton, tailor 1
5607031 2537094 2537094 defendant Elkyn or Ewyn John husbandman 598222 598222 Elkyn or Ewyn, John, of Chorleton, husbandman 2
5607032 2537094 2537094 defendant Shorte John husbandman 598222 598222 Shorte, John, of Chorleton, husbandman 3
5607371 2537201 2537201 defendant Omere John gent 598222 598222 Omere, John, of Chorleton, gent 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);