names

40 rows where place_id = 608210

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672640 1917442 1917442 defendant Cowper Roger husbandman 608210 608210 Cowper, Roger, of Chaddesley Corbett, husbandman 0
3672641 1917442 1917442 defendant Rawston alias Kendall John smith 608210 608210 Rawston alias Kendall, John, of Chaddesley Corbett, smith 1
3672642 1917442 1917442 defendant Sturmy Richard husbandman 608210 608210 Sturmy, Richard, of Chaddesley Corbett, husbandman 2
3683315 1920906 1920906 defendant Burneverd John smith 608210 608210 Burneverd, John, of Chaddesley Corbett, smith 0
3691937 1923640 1923640 defendant Burdenhill Humphrey husbandman 608210 608210 Burdenhill, Humphrey, of Chaddesley Corbett, husbandman 0
3692139 1923710 1923710 defendant Sturmy Richard husbandman 608210 608210 Sturmy, Richard, of Chaddesley Corbett, husbandman 0
3692140 1923710 1923710 defendant Rolston Alice spinster 608210 608210 Rolston, Alice, of Chaddesley Corbett, spinster 1
3764327 1946505 1946505 defendant Bagerley John husbandman 608210 608210 Bagerley, John, of Chaddesley Corbett, husbandman 1
3798947 1957583 1957583 defendant Tayler Silvester   608210 608210 Tayler, Silvester, of Chaddesley Corbett, scythe smith 3
3804615 1959384 1959384 defendant Wakeman William husbandman 608210 608210 Wakeman, William, of Chaddesley Corbett, husbandman 0
3808897 1960662 1960662 plaintiff Bache John   608210 608210 Bache, John, of Chaddesley Corbett, scythe smith 0
3808898 1960662 1960662 defendant Sturmy Richard husbandman 608210 608210 Sturmy, Richard, of Chaddesley Corbett, husbandman 0
3810797 1961278 1961278 defendant Venton John weaver 608210 608210 Venton, John, of Chaddesley Corbett, weaver 0
3812253 1961734 1961734 defendant Oldnall Richard husbandman 608210 608210 Oldnall, Richard, of Chaddesley Corbett, husbandman 2
3812254 1961734 1961734 defendant Coke William husbandman 608210 608210 Coke, William, of Chaddesley Corbett, husbandman 3
3825597 1965856 1965856 defendant Lambe John grinder 608210 608210 Lambe, John, of Chaddesley Corbett, grinder 2
3831814 1967849 1967849 defendant Newey Richard   608210 608210 Newey, Richard, of Chaddesley Corbett, scythe smith 0
3840904 1970724 1970724 defendant Kendall Thomas   608210 608210 Kendall, Thomas, of Chaddesley Corbett, scythe smith 0
3840905 1970724 1970724 defendant Broun John laborer 608210 608210 Broun, John, of Chaddesley Corbett, laborer 1
3840906 1970724 1970724 defendant Davys Thomas   608210 608210 Davys, Thomas, of Chaddesley Corbett, scythe smith 2
3848273 1973030 1973030 defendant Dawbys John yeoman 608210 608210 Dawbys, John, of Chaddesley Corbett, yeoman 0
3850902 1973875 1973875 defendant Whiteacur Christopher carpenter 608210 608210 Whiteacur, Christopher, of Chaddesley Corbett, carpenter 3
3850903 1973875 1973875 defendant Hadley John carpenter 608210 608210 Hadley, John, of Chaddesley Corbett, carpenter 4
3880504 1983737 1983737 defendant Lambe John husbandman 608210 608210 Lambe, John, of Chaddesley Corbett, husbandman 0
3918324 1996465 1996465 defendant Bache Matilda widow 608210 608210 Bache, Matilda, of Chaddesley Corbett, widow 0
3918325 1996465 1996465 defendant Bache John husbandman 608210 608210 Bache, John, of Chaddesley Corbett, husbandman 1
3918326 1996465 1996465 defendant Bache Richard husbandman 608210 608210 Bache, Richard, of Chaddesley Corbett, husbandman 2
3918737 1996596 1996596 defendant Sturmy Richard husbandman 608210 608210 Sturmy, Richard, of Chaddesley Corbett, husbandman 3
3920808 1997306 1997306 defendant Goodyer Henry grinder 608210 608210 Goodyer, Henry, of Chaddesley Corbett, grinder 3
3924367 1998461 1998461 defendant Smyth William   608210 608210 Smyth, William, of Chaddesley Corbett, scythe smith 0
3924368 1998461 1998461 defendant Rychard Roger husbandman 608210 608210 Rychard, Roger, of Chaddesley Corbett, husbandman 1
3926422 1999166 1999166 defendant Bache Matilda   608210 608210 Bache, Matilda, of Chaddesley Corbett 0
3935739 2002262 2002262 defendant Goppe Roger   608210 608210 Goppe, Roger, of Chaddesley Corbett, scythe smith 0
3937677 2002931 2002931 defendant Langworth Thomas yeoman 608210 608210 Langworth, Thomas, of Chaddesley corbett, yeoman 0
3937683 2002934 2002934 defendant Pakyngton John gent 608210 608210 Pakyngton, John, of Chaddesley Corbett, gent 0
4089667 2056598 2056598 defendant Freman Simon   608210 608210 Freman, Simon, of Chaddesley Corbett, scythe smith 0
4240399 2109766 2109766 defendant Leyte Gilbert husbandman 608210 608210 Leyte, Gilbert, of Chaddesley Corbett, husbandman 2
4329011 2140014 2140014 defendant Parker Thomas   608210 608210 Parker, Thomas, of Chaddesley Corbett, wheelwright 0
4329013 2140015 2140015 defendant Walforde William weaver 608210 608210 Walforde, William, of Chaddesley Corbett, weaver 0
5532977 2514856 2514856 defendant Berkette John yeoman 608210 608210 Berkette, John, of Chaddesley Corbett, yeoman 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);