names

67 rows where place_id = 636272

✎ 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
3829883 1967238 1967238 defendant Key John mercer 636272 636272 Key, John, of South Petherton, mercer 0
3839047 1970138 1970138 defendant Brett John (legal representative) 636272 636272 Brett, John, of South Petherton, esq, executrix of 4
3839048 1970138 1970138 defendant Brett Elizabeth widow 636272 636272 Brett, Elizabeth, of South Petherton, widow 5
3844022 1971674 1971674 defendant Mocke Thomas yeoman 636272 636272 Mocke, Thomas, of South Petherton, yeoman 0
3900716 1990468 1990468 defendant Michell Elizabeth widow 636272 636272 Michell, Elizabeth, of South Petherton, widow 0
3915412 1995521 1995521 defendant Wescote Robert fishmonger 636272 636272 Wescote, Robert, of South Petherton, fishmonger 0
3915414 1995522 1995522 defendant Wescote Robert fishmonger 636272 636272 Wescote, Robert, of South Petherton, fishmonger 0
3932317 2001112 2001112 defendant Ayssheley Thomas mercer 636272 636272 Ayssheley, Thomas, of South Petherton, mercer 3
3948013 2006368 2006368 defendant Forte Thomas husbandman 636272 636272 Forte, Thomas, of South Petherton, husbandman 1
3964944 2012346 2012346 plaintiff Baker William husbandman 636272 636272 Baker, William, of South Petherton, husbandman 0
3970020 2014110 2014110 defendant Kyngman John, senior gent 636272 636272 Kyngman, John, senior, of South Petherton, gent 0
3998343 2024146 2024146 defendant Rapsyon John yeoman 636272 636272 Rapsyon, John, of South Petherton, yeoman 0
4041300 2039376 2039376 defendant Glover Thomas husbandman 636272 636272 Glover, Thomas, of South Petherton, husbandman 0
4070940 2049905 2049905 defendant Baker Mathew husbandman 636272 636272 Baker, Mathew, of South Petherton, husbandman 0
4077976 2052427 2052427 defendant Syme William fishmonger 636272 636272 Syme, William, of South Petherton, fishmonger 0
4078231 2052517 2052517 defendant Radberd John   636272 636272 Radberd, John, of South Petherton 0
4078236 2052519 2052519 plaintiff Sybley John (legal representative) 636272 636272 Sybley, John, of South Petherton, husbandman, executrix of 0
4081106 2053554 2053554 defendant Kyngman John yeoman 636272 636272 Kyngman, John, of South Petherton, yeoman 1
4089610 2056575 2056575 defendant Bale Alice widow 636272 636272 Alice his wife, alias Alice Carter, of South Petherton, widow 1
4104209 2061780 2061780 defendant Baker Mathew husbandman 636272 636272 Baker, Mathew, of South Petherton, husbandman 0
4116643 2066246 2066246 defendant Farneham John yeoman 636272 636272 Farneham, John, of South Petherton, yeoman 0
4120025 2067450 2067450 defendant Banbury Richard husbandman 636272 636272 Banbury, Richard, of South Petherton, husbandman 0
4120026 2067450 2067450 defendant Jones John   636272 636272 Jones, John, of South Petherton, woollen draper 1
4120027 2067450 2067450 defendant Pyttard William husbandman 636272 636272 Pyttard, William, of South Petherton, husbandman 2
4120034 2067453 2067453 defendant Glover John baker 636272 636272 Glover, John, of South Petherton, baker 0
4120037 2067453 2067453 defendant Waller Richard husbandman 636272 636272 Waller, Richard, of South Petherton, husbandman 3
4127100 2069982 2069982 defendant Glover John, senior baker 636272 636272 Glover, John, senior, of South Petherton, baker 0
4127401 2070090 2070090 defendant Marshe William tiler 636272 636272 Marshe, William, of South Petherton, tiler 0
4133232 2072209 2072209 defendant Banbury Robert   636272 636272 Banbury, Robert, of South Petherton, woollen draper 1
4151415 2078618 2078618 defendant Wills John husbandman 636272 636272 Wills, John, of South Petherton, husbandman 1
4161231 2082009 2082009 defendant Masters Copston fletcher 636272 636272 Masters, Copston, of South Petherton, fletcher 0
4194519 2093634 2093634 defendant Symme William fishmonger 636272 636272 Symme, William, of South Petherton, or of Stretton, Soms, fishmonger 0
4194520 2093634 2093634 defendant Symme John husbandman 636272 636272 Symme, John, of South Petherton, or of Stretton, husbandman 1
4210439 2099210 2099210 defendant Anstice or Austice Thomas, junior brasier 636272 636272 Anstice or Austice, Thomas, junior, of South Petherton, brasier 0
4245392 2111435 2111435 defendant Rolle John husbandman 636272 636272 Rolle, John, of South Petherton, husbandman 0
4245393 2111435 2111435 defendant Jones John husbandman 636272 636272 Jones, John, of South Petherton, husbandman 1
4245394 2111435 2111435 defendant Kingman John yeoman 636272 636272 Kingman, John, of South Petherton, yeoman 2
4245395 2111435 2111435 defendant Fraunc Christopher husbandman 636272 636272 Fraunc, Christopher, of South Petherton, husbandman 3
4246237 2111719 2111719 defendant Kyngman John yeoman 636272 636272 Kyngman, John, of South Petherton, yeoman 2
4262946 2117271 2117271 defendant Forte George yeoman 636272 636272 Forte, George, of South Petherton, yeoman 0
4262947 2117271 2117271 defendant Prynce Richard husbandman 636272 636272 Prynce, Richard, of South Petherton, husbandman 1
4286721 2125303 2125303 defendant Bodye alias Marke John husbandman 636272 636272 Bodye alias Marke, John, of South Petherton, husbandman 0
4306084 2132267 2132267 defendant Aishford Hugh yeoman 636272 636272 Aishford, Hugh, of South Petherton, yeoman 2
4306992 2132587 2132587 defendant More Thomas husbandman 636272 636272 More, Thomas, of South Petherton, husbandman 0
4309551 2133500 2133500 defendant Bodye alias Marke John husbandman 636272 636272 Bodye alias Marke, John, of South Petherton, husbandman 0
4309552 2133500 2133500 defendant Baker alias Cannon John husbandman 636272 636272 Baker alias Cannon, John, of South Petherton, husbandman 1
4320755 2137355 2137355 defendant Barrett John husbandman 636272 636272 Barrett, John, of South Petherton, husbandman 0
4359136 2150431 2150431 defendant Boddy alias Markes John husbandman 636272 636272 Boddy alias Markes, John, of South Petherton, husbandman 1
4360414 2150891 2150891 defendant Androwe John carpenter 636272 636272 Androwe, John, of South Petherton, carpenter 0
4369876 2154280 2154280 defendant Vaxe John husbandman 636272 636272 Vaxe, John, of South Petherton, husbandman 1
4379259 2157662 2157662 defendant Aishe Humphrey gent 636272 636272 Aishe, Humphrey, of South Petherton, gent 2
4388467 2160780 2160780 defendant Westcott Joan spinster 636272 636272 Westcott, Joan, of South Petherton, spinster 0
4388471 2160782 2160782 defendant Westcott Robert, senior yeoman 636272 636272 Westcott, Robert, senior, of South Petherton, yeoman 0
4388473 2160783 2160783 defendant Westcott Susan spinster 636272 636272 Westcott, Susan, of South Petherton, spinster 0
4391443 2161754 2161754 defendant Body alias Marke John husbandman 636272 636272 Body alias Marke, John, of South Petherton, husbandman 0
4391444 2161754 2161754 defendant Forte George husbandman 636272 636272 Forte, George, of South Petherton, husbandman 1
4396425 2163379 2163379 defendant Dreinck Elizabeth widow 636272 636272 Dreinck, Elizabeth, of South Petherton, widow 0
4398050 2163926 2163926 defendant Baker alias Cannon John husbandman 636272 636272 Baker alias Cannon, John, of South Petherton, husbandman 0
4401033 2164936 2164936 defendant Bale Walter tucker 636272 636272 Bale, Walter, of South Petherton, tucker 0
4404683 2166134 2166134 defendant Wescote John yeoman 636272 636272 Wescote, John, of south Petherton, yeoman 0
4408211 2167317 2167317 defendant Willye Richard husbandman 636272 636272 Willye, Richard, of South Petherton, husbandman 2
4565981 2220914 2220914 plaintiff Splite Robert (legal representative) 636272 636272 Splite, Robert, of South Petherton, executors of 0
4615232 2235774 2235774 defendant Hwet Edward   636272 636272 Hwet, Edward, of South Petherton 1
4696108 2264265 2264265 defendant Pyper John   636272 636272 Pyper, John, of South Petherton, groom 0
5126353 2394189 2394189 defendant Knappe alias Stylle William yeoman 636272 636272 Knappe alias Stylle, William, of South Petherton, yeoman 1
5295494 2443672 2443672 defendant Jammell Henry husbandman 636272 636272 Jammell, Henry, of South Petherton, husbandman 0
5583763 2529996 2529996 defendant Case Mary widow 636272 636272 Case, Mary, of South Petherton, widow 1

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