names

76 rows where place_id = 616257

✎ 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
3668716 1916150 1916150 defendant Mot William husbandman 616257 616257 Mot, William, of Swaffham Prior, husbandman 1
3668717 1916150 1916150 defendant Dullyngham William husbandman 616257 616257 Dullyngham, William, of Swaffham Prior, husbandman 2
3668722 1916151 1916151 defendant Edward John smith 616257 616257 Edward, John, of Swaffham Prior, smith 3
3673537 1917749 1917749 defendant Dullyngham William husbandman 616257 616257 Dullyngham, William, of Swaffham Prior, husbandman 0
3673538 1917749 1917749 defendant Baldewyn John laborer 616257 616257 Baldewyn, John, of Swaffham Prior, laborer 1
3673539 1917749 1917749 defendant Master Thomas laborer 616257 616257 Master, Thomas, of Swaffham Prior, laborer 2
3697158 1925333 1925333 defendant Weysenham Richard fowler 616257 616257 Weysenham, Richard, of Swaffham Prior, fowler 0
3697259 1925366 1925366 plaintiff Stevyn alias Bettys William (legal representative) 616257 616257 Stevyn alias Bettys, William, of Swaffham, laborer, executor of 0
3697261 1925366 1925366 defendant Taylour John butcher 616257 616257 Taylour, John, of Swaffham Prior, butcher 0
3697262 1925366 1925366 defendant Edward John smith 616257 616257 Edward, John, of Swaffham Prior, smith 1
3697263 1925366 1925366 defendant Symson William tailor 616257 616257 Symson, William, of Swaffham Prior, tailor 2
3711048 1929767 1929767 plaintiff Stephyn alias Bettys William (legal representative) 616257 616257 Stephyn alias Bettys, William, of Swaffham, laborer, executor of 0
3713485 1930529 1930529 defendant Pound John glover 616257 616257 Pound, John, of Swaffham, glover 0
3717313 1931698 1931698 plaintiff Dee Thomas   616257 616257 Dee, Thomas, of Swaffham 0
3742831 1939611 1939611 plaintiff Payne Walter   616257 616257 (Payne, Walter, of Swaffham 1
3756706 1944071 1944071 plaintiff Bacchus Roland   616257 616257 Bacchus, Roland, of Swaffham Prior, notary public 0
3780919 1951764 1951764 defendant Stokye John   616257 616257 Stokye, John, of Swaffham, hair maker 1
3783218 1952503 1952503 defendant Briall Robert   616257 616257 Briall, Robert, of Swaffham Market, barber, son of Barbur, Theobald 0
3817236 1963304 1963304 defendant Owold John husbandman 616257 616257 Owold, John, of Swaffham, husbandman 10
3841448 1970904 1970904 defendant Danyell Ralph gent 616257 616257 Danyell, Ralph, of Swaffham, gent 0
3858124 1976196 1976196 defendant Dale Richard clerk 616257 616257 Dale, Richard, of Swaffham, clerk 2
3874867 1981815 1981815 defendant Mason Thomas yeoman 616257 616257 Mason, Thomas, of Swaffham, yeoman 0
3884516 1985094 1985094 defendant Bakhowse John   616257 616257 Bakhowse, John, of Swaffham Prior, notary 0
3905611 1992147 1992147 plaintiff Large Henry   616257 616257 Large, Henry, of Swaffham 0
3923783 1998259 1998259 plaintiff Stewerde William (legal representative) 616257 616257 Stewerde, William, of Swaffham, executor of 0
3923786 1998260 1998260 plaintiff Stewerde William (legal representative) 616257 616257 Stewerde, William, of Swaffham, executor of 0
3940875 2003955 2003955 defendant Morell John tanner 616257 616257 Morell, John, of Swaffham, tanner 5
3940876 2003955 2003955 defendant Morell Robert tanner 616257 616257 Morell, Robert, of Swaffham, tanner 6
3940884 2003956 2003956 defendant Morell John tanner 616257 616257 Morell, John, of Swaffham, tanner 5
3940885 2003956 2003956 defendant Morell Robert tanner 616257 616257 Morell, Robert, of Swaffham, tanner 6
3997134 2023743 2023743 defendant Homes Richard husbandman 616257 616257 Homes, Richard, of Swaffham Prior, husbandman 1
4000011 2024768 2024768 defendant Cuttle Robert husbandman 616257 616257 Cuttle, Robert, of Swaffham Prior, husbandman 0
4000012 2024768 2024768 defendant Frement Thomas husbandman 616257 616257 Frement, Thomas, of Swaffham Prior, husbandman 1
4001343 2025256 2025256 defendant Kynge William laborer 616257 616257 Kynge, William, of Swaffham, laborer 0
4018221 2031241 2031241 defendant Backhouse John yeoman 616257 616257 Backhouse, John, of Swaffham Prior, yeoman 0
4024488 2033434 2033434 defendant Ruse Cireac gent 616257 616257 Ruse, Cireac, of Swaffham Prior, gent 1
4036839 2037859 2037859 plaintiff Jackson John innholder 616257 616257 Jackson, John, of Swaffham, innholder 0
4072247 2050375 2050375 defendant Cannon Robert tanner 616257 616257 Cannon, Robert, of Swaffham, tanner 0
4072254 2050377 2050377 defendant Cannon Robert tanner 616257 616257 Cannon, Robert, of Swaffham, tanner 0
4078684 2052672 2052672 plaintiff Thake John maltster 616257 616257 Thake, John, of Swaffham, maltster 0
4113925 2065265 2065265 defendant Waters William yeoman 616257 616257 Waters, William, of Swaffham, yeoman 0
4113926 2065265 2065265 defendant Master Richard yeoman 616257 616257 Master, Richard, of Swaffham Prior, yeoman 1
4113928 2065265 2065265 defendant Kent John laborer 616257 616257 Kent, John, of Swaffham Prior, laborer 3
4121997 2068168 2068168 defendant Cooke Thomas yeoman 616257 616257 Cooke, Thomas, of Swaffham Prior, yeoman 0
4133777 2072415 2072415 defendant Purveys Christopher blacksmith 616257 616257 Purveys, Christopher, of Swaffham, blacksmith 0
4139546 2074506 2074506 defendant Rookes Osmund husbandman 616257 616257 Rookes, Osmund, of Swaffham Prior, husbandman 1
4158017 2080876 2080876 defendant Fynche John fishmonger 616257 616257 Fynche, John, of Swaffham, fishmonger 0
4183415 2089679 2089679 defendant Rookes Osmond husbandman 616257 616257 Rookes, Osmond, of Swaffham Prior, husbandman 1
4193018 2093125 2093125 defendant Morrell John yeoman 616257 616257 (Morrell, John, of Swaffham, yeoman 1
4215505 2100917 2100917 defendant Tebbold John husbandman 616257 616257 Tebbold, John, of Swaffham, husbandman 0
4222668 2103419 2103419 defendant Tanne Thomas yeoman 616257 616257 Tanne, Thomas, of Swaffham, yeoman 0
4224345 2103999 2103999 defendant Pickering Walter innholder 616257 616257 Pickering, Walter, of Swaffham, innholder 0
4241620 2110183 2110183 defendant Pickeringe John soaper 616257 616257 Pickeringe, John, of Swaffham, soaper 1
4265116 2117972 2117972 defendant Helman John yeoman 616257 616257 Helman, John, of Swaffham, yeoman 0
4265117 2117972 2117972 defendant Tebbold alias Briel John yeoman 616257 616257 Tebbold alias Briel, John, of Swaffham, yeoman 1
4265118 2117972 2117972 defendant Tanner William mercer 616257 616257 Tanner, William, of Swaffham, mercer 2
4291201 2126920 2126920 defendant Daynes Thomas carpenter 616257 616257 Daynes, Thomas, of Swaffham, carpenter 2
4309406 2133449 2133449 defendant Cooke Thomas yeoman 616257 616257 Cooke, Thomas, of Swaffham Prior, yeoman 0
4324407 2138558 2138558 defendant Holden John miller 616257 616257 Holden, John, of Swaffham, miller 0
4352297 2148039 2148039 defendant Cobbe Robert husbandman 616257 616257 Cobbe, Robert, of Swaffham Prior, husbandman 0
4352458 2148098 2148098 defendant Cracknell John butcher 616257 616257 Cracknell, John, of Swaffham Prior, butcher 1
4356224 2149399 2149399 defendant Dunham Stephen husbandman 616257 616257 Dunham, Stephen, of Swaffham, husbandman 0
4356225 2149399 2149399 defendant Covye Nicholas laborer 616257 616257 together with Covye, Nicholas, of Swaffham, laborer 1
4356408 2149469 2149469 defendant Cobb Robert maltster 616257 616257 Cobb, Robert, of Swaffham Prior, maltster 0
4360931 2151080 2151080 defendant Maister Richard husbandman 616257 616257 Maister, Richard, of Swaffham Prior, husbandman 0
4384591 2159535 2159535 defendant Nycholl William   616257 616257 Nycholl, William, of Swaffham, gent, or of Folsham, medicus 0
4398805 2164182 2164182 defendant Lavite or Leavett Humphrey gent 616257 616257 Lavite or Leavett, Humphrey, of Swaffham, gent 0
4405154 2166300 2166300 defendant Rooke or Rockey Osmond husbandman 616257 616257 Rooke or Rockey, Osmond, of Swaffham Prior, husbandman 0
4410591 2168132 2168132 defendant Covye Nicholas laborer 616257 616257 Covye, Nicholas, of Swaffham, laborer 0
4410592 2168132 2168132 defendant Dunham Stephen husbandman 616257 616257 together with Dunham, Stephen, of Swaffham, husbandman 1
4495760 2199358 2199358 plaintiff Lawe Henry   616257 616257 Lawe, Henry, of Swaffham 1
5040607 2368798 2368798 defendant Seiser John husbandman 616257 616257 Seiser, John, of Swaffham Prior, husbandman 1
5040608 2368798 2368798 defendant Fermour John yeoman 616257 616257 Fermour, John, of Swaffham, Prior, yeoman 2
5164635 2405391 2405391 plaintiff Aleyn John   616257 616257 Aleyn, John, of Swaffham 0
5236947 2426390 2426390 defendant Dawes William yeoman 616257 616257 Dawes, William, of Swaffham, yeoman 0
5447395 2489110 2489110 defendant Payn John shoemaker 616257 616257 Payn, John, of Swaffham, shoemaker 4

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