names

63 rows where place_id = 598209

✎ 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
3631575 1904688 1904688 defendant Rychardes Thomas husbandman 598209 598209 Rychardes, Thomas, of Keteryng, husbandman 0
3631576 1904688 1904688 defendant Oswaster John husbandman 598209 598209 Oswaster, John, of Keteryng, husbandman 1
3645178 1908900 1908900 defendant Parke Henry baker 598209 598209 Parke, Henry, of Keteryng, baker 0
3645557 1909006 1909006 defendant Pakke Henry baker 598209 598209 Pakke, Henry, of Keteryng, baker 0
3646931 1909438 1909438 defendant Grene John mercer 598209 598209 (Grene, John, of Keteryng, mercer 1
3648829 1910022 1910022 defendant Carter Richard yeoman 598209 598209 Carter, Richard, of Keteryng, yeoman 0
3648831 1910022 1910022 defendant Pakke Henry yeoman 598209 598209 Pakke, Henry, of Keteryng, yeoman 2
3692792 1923937 1923937 plaintiff Lane John gent 598209 598209 Lane, John, of Keteryng, gent 0
3713573 1930554 1930554 defendant Cave Thomas miller 598209 598209 Cave, Thomas, of Keteryng, miller 0
3722595 1933327 1933327 defendant Carter Richard yeoman 598209 598209 Carter, Richard, of Keteryng, yeoman 2
3730430 1935749 1935749 defendant Murre alias Morowe John tailor 598209 598209 Murre alias Morowe, John, of Keteryng, tailor 0
3785324 1953197 1953197 defendant Inchelard Thomas yeoman 598209 598209 Inchelard, Thomas, of Keteryng, yeoman 2
3808490 1960535 1960535 plaintiff Androwe John gilder 598209 598209 Androwe, John, of Keteryng, gilder 0
3818143 1963588 1963588 defendant Cathe Thomas shoemaker 598209 598209 Cathe, Thomas, of Keteryng, shoemaker 0
3850792 1973842 1973842 defendant Hanse or Hause Robert butcher 598209 598209 (Hanse or Hause, Robert, of Keteryng, butcher 2
3850794 1973842 1973842 defendant Cave Robert shoemaker 598209 598209 Cave, Robert, of Keteryng, shoemaker 4
3850795 1973842 1973842 defendant Cave Emma widow 598209 598209 Cave, Emma, of Keteryng, widow 5
3911014 1994009 1994009 defendant Grey Richard glover 598209 598209 Grey, Richard, of Keteryng, glover 0
3934833 2001950 2001950 defendant Lanae John gent 598209 598209 Lanae, John, of Keteryng, gent 0
3938283 2003142 2003142 defendant Jarman Robert butcher 598209 598209 Jarman, Robert, of keteryng, butcher 1
4193513 2093297 2093297 defendant Pylley John yeoman 598209 598209 Pylley, John, of Keteryng, yeoman 0
4668994 2256007 2256007 defendant Andrewe John baker 598209 598209 Andrewe, John, of Keteryng, baker 0
4800223 2296247 2296247 defendant Taillour John tailor 598209 598209 Taillour, John, of Keteryng, tailor 0
4800224 2296247 2296247 defendant Wryght Andrew husbandman 598209 598209 Wryght, Andrew, of Keteryng, husbandman 1
4800225 2296247 2296247 defendant Brewester John husbandman 598209 598209 Brewester, John, of Keteryng, husbandman 2
4873363 2318623 2318623 defendant Haselbeche John husbandman 598209 598209 Haselbeche, John, of Keteryng, husbandman 2
4900187 2326684 2326684 defendant Pratte John husbandman 598209 598209 Pratte, John, of Keteryng, husbandman 0
4970210 2348042 2348042 defendant Stevens William mercer 598209 598209 Stevens, William, of Keteryng, mercer 1
4976933 2350055 2350055 defendant Stevenes William mercer 598209 598209 Stevenes, William, of Keteryng, mercer 1
4979194 2350736 2350736 plaintiff Selby Richard merchant 598209 598209 Selby, Richard, of Keteryng, merchant 0
5027717 2364981 2364981 defendant Brake William tailor 598209 598209 Brake, William, of Keteryng, tailor 0
5027718 2364981 2364981 defendant Turvey John husbandman 598209 598209 Turvey, John, of Keteryng, husbandman 1
5070112 2377554 2377554 defendant Drake William tailor 598209 598209 Drake, William, of Keteryng, tailor 3
5070117 2377555 2377555 defendant Drake William tailor 598209 598209 Drake, William, of Keteryng, tailor 3
5089612 2383336 2383336 defendant Horn Ralph husbandman 598209 598209 Horn, Ralph, of Keteryng, husbandman 0
5090747 2383682 2383682 defendant Prat John, senior husbandman 598209 598209 Prat, John, senior, of Keteryng, husbandman 0
5102612 2387172 2387172 defendant Turvey John   598209 598209 Turvey, John, of Keteryng, notary 0
5123389 2393284 2393284 defendant Turvey John esq 598209 598209 Turvey, John, of Keteryng, esq 0
5136407 2397168 2397168 defendant Drake John tailor 598209 598209 Drake, John, of Keteryng, tailor 0
5136408 2397168 2397168 defendant Forster John weaver 598209 598209 Forster, John, of Keteryng, weaver 1
5156850 2403155 2403155 defendant Drake John tailor 598209 598209 Drake, John, of Keteryng, tailor 0
5156851 2403155 2403155 defendant Forster John weaver 598209 598209 Forster, John, of Keteryng, weaver 1
5217448 2420840 2420840 defendant Colfox Thomas yeoman 598209 598209 Colfox, Thomas, of Keteryng, yeoman 0
5228750 2424021 2424021 defendant Turvey John esq 598209 598209 Turvey, John, of Keteryng, esq 0
5235673 2426013 2426013 defendant Lynne Thomas, junior smith 598209 598209 Lynne, Thomas, junior, of Keteryng, smith 1
5237893 2426666 2426666 plaintiff Godwote John   598209 598209 Godwote, John, of Keteryng 0
5327424 2453274 2453274 plaintiff Turvey John (legal representative) 598209 598209 Turvey, John, of Keteryng, esq, notary, executrix of 0
5327426 2453274 2453274 defendant Kere Richard clerk 598209 598209 Kere, Richard, of Keteryng, clerk 0
5336038 2455854 2455854 plaintiff Gyles William merchant 598209 598209 Gyles, William, of Keteryng, merchant 0
5446724 2488917 2488917 defendant Myles John   598209 598209 Myles, John, of Keteryng 1
5478123 2498483 2498483 defendant Mylys Richard dyer 598209 598209 Mylys, Richard, of Keteryng, dyer 2
5487102 2501038 2501038 defendant Vance or Vauce John mercer 598209 598209 Vance or Vauce, John, of Keteryng, mercer 1
5587319 2531061 2531061 defendant Alderman Edmund weaver 598209 598209 Alderman, Edmund, of Keteryng, weaver 0
5587321 2531062 2531062 defendant Pak Henry yeoman 598209 598209 Pak, Henry, of Keteryng, yeoman 0
5587323 2531063 2531063 defendant Pak Henry yeoman 598209 598209 Pak, Henry, of Keteryng, yeoman 0
5587324 2531063 2531063 defendant Pake Robert weaver or dyer 598209 598209 Pake, Robert, of Keteryng, weaver or dyer 1
5587325 2531063 2531063 defendant Alderman Edmund weaver or dyer 598209 598209 Alderman, Edmund, of Keteryng, weaver or dyer 2
5587327 2531064 2531064 defendant Pak Robert weaver or dyer 598209 598209 Pak, Robert, of Keteryng, weaver or dyer 0
5599678 2534791 2534791 defendant Preston John yeoman 598209 598209 Preston, John, of Keteryng, yeoman 4
5607610 2537277 2537277 defendant Cave John shoemaker 598209 598209 Cave, John, of Keteryng, shoemaker 1
5607612 2537277 2537277 defendant Dunmowe John husbandman 598209 598209 Dunmowe, John, of Keteryng, husbandman 3
5610558 2547025 2547025 plaintiff Barbour William   598209 598209 Barbour, William, of Keteryng 0
5619244 2549866 2549866 defendant Annyes William   598209 598209 Annyes, William, of Keteryng 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);