names

55 rows where place_id = 671569

✎ 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
4002093 2025531 2025531 plaintiff Hawkyns Robert (legal representative) 671569 671569 Hawkyns, Robert, of Crewkerne, yeoman, executor of 0
4002095 2025531 2025531 defendant Prince Thomas yeoman 671569 671569 Prince, Thomas, of Crewkerne, yeoman 0
4002096 2025531 2025531 defendant Prince Isabel widow 671569 671569 Isabel his wife, alias Isabel Bearde, of Crewkerne, widow 1
4028721 2034922 2034922 plaintiff Cowche Robert hatter 671569 671569 Cowche, Robert, of Crewkerne, hatter 0
4060834 2046281 2046281 defendant Baker Robert yeoman 671569 671569 Baker, Robert, of Crewkerne, yeoman 0
4066084 2048157 2048157 defendant Lyte Peter gent 671569 671569 Lyte, Peter, of Crewkerne, gent 1
4072332 2050407 2050407 defendant Slade Hugh yeoman 671569 671569 Slade, Hugh, of Crewkerne, yeoman 1
4072483 2050462 2050462 defendant Palmer Robert husbandman 671569 671569 Palmer, Robert, of Crewkerne, husbandman 1
4089133 2056408 2056408 defendant Bragge John husbandman or yeoman 671569 671569 Bragge, John, of Crewkerne, husbandman or yeoman 2
4128714 2070565 2070565 defendant Baker Robert clothier 671569 671569 Baker, Robert, of Crewkerne, yeoman, clothier 0
4161918 2082238 2082238 defendant Duncham Peter baker 671569 671569 Duncham, Peter, of Crewkerne, baker 0
4209039 2098712 2098712 defendant Michell or Myche William yeoman 671569 671569 Michell or Myche, William, of Crewkerne, yeoman 2
4210682 2099294 2099294 defendant Downeham Peter baker 671569 671569 Downeham, Peter, of Crewkerne, baker 0
4221171 2102903 2102903 defendant Clarke alias Clement John husbandman 671569 671569 Clarke alias Clement, John, of Crewkerne, husbandman 0
4231398 2106483 2106483 defendant Farnam Hugh yeoman 671569 671569 Farnam, Hugh, of Crewkerne, yeoman 0
4263235 2117370 2117370 defendant Farman Hugh yeoman 671569 671569 Farman, Hugh, of Crewkerne, yeoman 0
4284286 2124429 2124429 defendant Symes Thomas, senior husbandman 671569 671569 Symes, Thomas, senior, of Crewkerne, or of Over Straton, husbandman 2
4289792 2126410 2126410 defendant Mettforde John husbandman 671569 671569 Mettforde, John, of Crewkerne, husbandman 0
4289793 2126410 2126410 defendant Mettforde Richard yeoman 671569 671569 Mettforde, Richard, of Crewkerne, yeoman 1
4289795 2126410 2126410 defendant Tampkin alias Clutterye Henry baker 671569 671569 Tampkin alias Clutterye, Henry, of Crewkerne, baker 3
4290843 2126781 2126781 defendant Cosens Edith widow 671569 671569 Cosens, Edith, of Crewkerne, widow 0
4303187 2131240 2131240 defendant Symes Thomas husbandman 671569 671569 Symes, Thomas, of Crewkerne, husbandman 0
4304832 2131824 2131824 defendant Dellinge John yeoman 671569 671569 Dellinge, John, of Crewkerne, yeoman 0
4306882 2132548 2132548 defendant Kenwaye Charles husbandman 671569 671569 Kenwaye, Charles, of Crewkerne, or of Mysterton, husbandman 0
4307706 2132836 2132836 defendant Jones John yeoman 671569 671569 Jones, John, of Crewkerne, yeoman 0
4314140 2135051 2135051 defendant Gardner Mathew haberdasher 671569 671569 Gardner, Mathew, of Crewkerne, or of Blandford Forum, Dorset, haberdasher 0
4314144 2135053 2135053 defendant Gardner William   671569 671569 Gardner, William, of Crewkerne, or of Nutford, Blandford Forum, Dorset, felt maker 0
4320743 2137351 2137351 defendant Symme or Symmes Thomas husbandman 671569 671569 Symme or Symmes, Thomas, of Crewkerne, or of Chidiocke, Dorset, husbandman 0
4323956 2138422 2138422 defendant Smythe Richard gent 671569 671569 Smythe, Richard, of Crewkerne, gent 1
4324710 2138656 2138656 defendant Hannynge William husbandman 671569 671569 Hannynge, William, of Crewkerne, husbandman 0
4325354 2138861 2138861 defendant Dawbeney John gent 671569 671569 Dawbeney, John, of Crewkerne, or of Wayford, Soms, gent 1
4325943 2139051 2139051 defendant Garrys Robert   671569 671569 Garrys, Robert, of Crewkerne, felt maker 2
4331535 2140843 2140843 defendant Taylor John husbandman 671569 671569 Taylor, John, of Crewkerne, or of Est Chenocke, husbandman 0
4342229 2144564 2144564 defendant Hutchins Richard yeoman 671569 671569 Hutchins, Richard, of Crewkerne, yeoman 0
4342230 2144564 2144564 defendant Wareham Richard chapman 671569 671569 Wareham, Richard, of Crewkerne, chapman 1
4358076 2150066 2150066 defendant Hannynge William yeoman 671569 671569 Hannynge, William, of Crewkerne, yeoman 0
4358283 2150131 2150131 defendant Butcher Clement yeoman 671569 671569 Butcher, Clement, of Crewkerne, yeoman 0
4366098 2152918 2152918 defendant Burrowe Alexander cooper 671569 671569 Burrowe, Alexander, of Crewkerne, cooper 0
4367645 2153482 2153482 defendant Stembridge Robert yeoman 671569 671569 Stembridge, Robert, of Crewkerne, yeoman 0
4368095 2153645 2153645 defendant Stone Robert tailor 671569 671569 Stone, Robert, of Crewkerne, tailor 1
4368096 2153645 2153645 defendant Kingdome Robert armorer 671569 671569 Kingdome, Robert, of Crewkerne, armorer 2
4370706 2154576 2154576 defendant Somers Thomas glasier 671569 671569 Somers, Thomas, of Crewkerne, glasier 1
4375876 2156433 2156433 defendant Tayler John husbandman 671569 671569 Tayler, John, of Crewkerne, husbandman 0
4376284 2156588 2156588 defendant Hoyle John baker 671569 671569 Hoyle, John, of Crewkerne, baker 1
4376664 2156719 2156719 defendant Symes Thomas fisherman 671569 671569 Symes, Thomas, of Crewkerne, fisherman 3
4379008 2157573 2157573 defendant Tayler James cutler 671569 671569 Tayler, James, of Crewkerne, cutler 1
4379009 2157573 2157573 defendant Tayler William husbandman 671569 671569 Tayler, William, of Crewkerne, husbandman 2
4380330 2158070 2158070 defendant Sharlocke Richard baker 671569 671569 Sharlocke, Richard, of Crewkerne, baker 0
4380332 2158071 2158071 defendant Pawle John miller 671569 671569 Pawle, John, of Crewkerne, miller 0
4385125 2159712 2159712 defendant Hanynge Richard husbandman 671569 671569 Hanynge, Richard, of Crewkerne, husbandman 0
4404397 2166039 2166039 defendant Combe William husbandman 671569 671569 Combe, William, of Crewkerne, husbandman 2
4407916 2167211 2167211 defendant Hutchins John innholder 671569 671569 Hutchins, John, of Crewkerne, innholder 2
4407918 2167212 2167212 defendant Symes Thomas yeoman 671569 671569 Symes, Thomas, of Crewkerne, yeoman 0
4407919 2167212 2167212 defendant East Alexander butcher 671569 671569 East, Alexander, of Crewkerne, butcher 1
4407920 2167212 2167212 defendant Garrys Robert   671569 671569 Garrys, Robert, of Crewkerne, felt maker 2

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