names

65 rows where place_id = 586948

✎ 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
3590060 1864531 1864531 defendant Wederherd Richard yeoman 586948 586948 Wederherd, Richard, of Crofte, yeoman 0
3599150 1867370 1867370 defendant Crofte Richard   586948 586948 Crofte, Richard, of Crofte, knight 0
3616110 1872677 1872677 defendant Saunderson Robert husbandman 586948 586948 Saunderson, Robert, of Crofte, husbandman 0
3704375 1927669 1927669 defendant Ellerbek William yeoman 586948 586948 Ellerbek, William, of Crofte, yeoman 3
3857226 1975893 1975893 defendant Stevynson William chapman 586948 586948 Stevynson, William, of Crofte, chapman 0
3876899 1982515 1982515 defendant Anderson Thomas husbandman 586948 586948 Anderson, Thomas, of Crofte, husbandman 1
3905389 1992071 1992071 defendant Bawdre Margery widow 586948 586948 Bawdre, Margery, of Crofte, widow 0
3920612 1997242 1997242 defendant Goodknap Richard husbandman 586948 586948 (Goodknap, Richard, of Crofte, husbandman 1
3935538 2002196 2002196 defendant Mawer Anthony husbandman 586948 586948 Mawer, Anthony, of Crofte, husbandman 0
3953716 2008374 2008374 plaintiff Johnson Alice widow 586948 586948 Alice his wife, alias Alice Ranson or Rauson, of Crofte, widow 1
3953717 2008374 2008374 defendant Goodderson William yeoman 586948 586948 Goodderson, William, of Crofte, yeoman 0
3956187 2009236 2009236 defendant Dandyson Nicholas husbandman 586948 586948 Dandyson, Nicholas, of Crofte, husbandman 1
3971021 2014421 2014421 defendant Lambertson Nicholas husbandman 586948 586948 Lambertson, Nicholas, of Crofte, husbandman 1
3983882 2019006 2019006 plaintiff Stevenson William (legal representative) 586948 586948 Stevenson, William, of Crofte, or of Bamber, yeoman, executors of 0
4087157 2055695 2055695 defendant Cooker Christopher gent 586948 586948 Cooker, Christopher, of Crofte, gent 0
4115278 2065755 2065755 defendant Wolby John yeoman 586948 586948 Wolby, John, of Crofte, yeoman 0
4121459 2067968 2067968 defendant Grene Thomas yeoman 586948 586948 Grene, Thomas, of Crofte, yeoman 0
4127586 2070158 2070158 defendant Brewster Edward husbandman 586948 586948 Brewster, Edward, of Crofte, husbandman 0
4151365 2078599 2078599 defendant Turtill Thomas husbandman 586948 586948 Turtill, Thomas, of Crofte, husbandman 0
4164286 2083030 2083030 defendant Grynall John husbandman 586948 586948 Grynall, John, of Crofte, husbandman 0
4166386 2083739 2083739 defendant Maltby Thomas husbandman 586948 586948 Maltby, Thomas, of Crofte, husbandman 0
4189232 2091727 2091727 defendant Grene William yeoman 586948 586948 Grene, William, of Crofte, yeoman 0
4198998 2095206 2095206 defendant Dandyson alias Lambertson Nicholas husbandman 586948 586948 Dandyson alias Lambertson, Nicholas, of Crofte, husbandman 0
4212710 2099986 2099986 defendant Grene William yeoman 586948 586948 Grene, William, of Crofte, yeoman 0
4226743 2104827 2104827 defendant Stampe William husbandman 586948 586948 Stampe, William, of Crofte, yeoman, or of Stepinge Magna, Lincs, husbandman 1
4235166 2107859 2107859 defendant Stampe William husbandman 586948 586948 Stampe, William, of Crofte, yeoman, or of Stepinge Magna, husbandman 1
4254069 2114360 2114360 defendant Badrye John yeoman 586948 586948 Badrye, John, of Crofte, yeoman 0
4257068 2115337 2115337 defendant Browne Valentine esq 586948 586948 Browne, Valentine, of Crofte, esq 0
4257069 2115337 2115337 defendant Dalton Martin yeoman 586948 586948 Dalton, Martin, of Crofte, yeoman 1
4257073 2115337 2115337 defendant Boughe William yeoman 586948 586948 Boughe, William, of Crofte, yeoman 5
4274729 2121107 2121107 defendant Thorpe George yeoman 586948 586948 Thorpe, George, of Crofte, yeoman 0
4280311 2123016 2123016 defendant Francklyn Thomas yeoman 586948 586948 Francklyn, Thomas, of Crofte, yeoman 0
4298290 2129489 2129489 defendant Moore Arnold yeoman 586948 586948 Moore, Arnold, of Crofte, yeoman 0
4298291 2129489 2129489 defendant Moore Richard yeoman 586948 586948 Moore, Richard, of Crofte, yeoman 1
4298292 2129489 2129489 defendant Powell Richard yeoman 586948 586948 Powell, Richard, of Crofte, yeoman 2
4299071 2129765 2129765 defendant Thorpe George yeoman 586948 586948 Thorpe, George, of Crofte, yeoman 0
4358706 2150281 2150281 defendant Dalton Mark yeoman 586948 586948 (Dalton, Mark, of Crofte, yeoman 1
4372004 2155048 2155048 defendant Jenkyns George husbandman 586948 586948 Jenkyns, George, of Crofte, husbandman 3
4374816 2156047 2156047 defendant Grene William yeoman 586948 586948 Grene, William, of Crofte, yeoman 2
4377662 2157083 2157083 defendant Hopton Thomas gent 586948 586948 Hopton, Thomas, of Crofte, or of Wynforton, gent 0
4379614 2157801 2157801 defendant Tunstall Robert clerk 586948 586948 Tunstall, Robert, of Crofte, clerk 0
4449518 2184796 2184796 defendant Bedde Thomas   586948 586948 Bedde, Thomas, of Crofte 0
4511903 2204172 2204172 plaintiff Bodd Thomas   586948 586948 Bodd, Thomas, of Crofte 0
4671046 2256613 2256613 defendant Hudson William husbandman 586948 586948 Hudson, William, of Crofte, husbandman 2
4771879 2287180 2287180 defendant Godeknape John   586948 586948 Godeknape, John, of Crofte, fare carter 1
4834868 2306908 2306908 defendant Saresone Thomas husbandman 586948 586948 Saresone, Thomas, of Crofte, husbandman 1
4967337 2347174 2347174 defendant Hudson Walter husbandman 586948 586948 Hudson, Walter, of Crofte, husbandman 5
5106689 2388382 2388382 defendant Grenne William   586948 586948 Grenne, William, of Crofte, wright 4
5108229 2388838 2388838 defendant Pelson William husbandman 586948 586948 Pelson, William, of Crofte, husbandman 0
5139442 2398022 2398022 defendant Watson Walter husbandman 586948 586948 Watson, Walter, of Crofte, husbandman 3
5160426 2404140 2404140 defendant Watson Walter husbandman 586948 586948 Watson, Walter, of Crofte, husbandman 3
5160696 2404228 2404228 plaintiff Sparke John   586948 586948 Sparke, John, of Crofte 0
5175230 2408447 2408447 defendant Watson Walter husbandman 586948 586948 Watson, Walter, of Crofte, husbandman 3
5175414 2408502 2408502 plaintiff Sparke John   586948 586948 Sparke, John, of Crofte 0
5196287 2414663 2414663 defendant Watson Walter husbandman 586948 586948 Watson, Walter, of Crofte, husbandman 3
5295540 2443685 2443685 defendant Milne John husbandman 586948 586948 Milne, John, of Crofte, husbandman 7
5327550 2453312 2453312 defendant Spark Thomas husbandman 586948 586948 Spark, Thomas, of Crofte, husbandman 0
5327552 2453313 2453313 defendant Sparke Thomas husbandman 586948 586948 Sparke, Thomas, of Crofte, husbandman 0
5333629 2455130 2455130 defendant Growedon John husbandman 586948 586948 Growedon, John, of Crofte, husbandman 1
5333630 2455130 2455130 defendant Growedon William laborer 586948 586948 Growedon, William, of Crofte, laborer 2
5333633 2455131 2455131 defendant Growedon John husbandman 586948 586948 Growedon, John, of Crofte, husbandman 1
5333634 2455131 2455131 defendant Growedon William laborer 586948 586948 Growedon, William, of Crofte, laborer 2
5361127 2463509 2463509 defendant Pynder Simon husbandman 586948 586948 Pynder, Simon, of Crofte, husbandman 1
5468460 2495507 2495507 plaintiff Clarvaux Richard esq 586948 586948 Clarvaux, Richard, of Crofte, esq 0
5635876 2555180 2555180 defendant Jaye Hugh yeoman 586948 586948 Jaye, Hugh, of Crofte, yeoman 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);