names

53 rows where place_id = 608117

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672241 1917316 1917316 defendant Freme Richard, senior husbandman 608117 608117 Freme, Richard, senior, of Bysley, husbandman 0
3729110 1935353 1935353 defendant White John yeoman 608117 608117 White, John, of Bysley, yeoman 0
3729111 1935353 1935353 defendant Chamber William tucker 608117 608117 Chamber, William, of Bysley, tucker 1
3777665 1950762 1950762 defendant Vuwyn John clothier 608117 608117 Vuwyn, John, of Bysley, clothier 0
3786059 1953431 1953431 defendant Dowell John yeoman 608117 608117 Dowell, John, of Bysley, yeoman 3
3793880 1955953 1955953 defendant Whytyng John butcher 608117 608117 Whytyng, John, of Bysley, butcher 0
3808876 1960657 1960657 defendant Kyng Edward weaver 608117 608117 Kyng, Edward, of Bysley, weaver 0
3853340 1974667 1974667 defendant Gryme James weaver 608117 608117 Gryme, James, of Bysley, weaver 0
3947868 2006318 2006318 defendant Hyll Leonard weaver 608117 608117 Hyll, Leonard, of Bysley, weaver 0
3955489 2008988 2008988 defendant Hyll Leonard clothier 608117 608117 Hyll, Leonard, of Bysley, clothier 0
3959593 2010447 2010447 defendant Astmede alias Huntere Thomas yeoman 608117 608117 Astmede alias Huntere, Thomas, of Bysley, yeoman 0
4050169 2042492 2042492 defendant Trappe Richard carrier 608117 608117 Trappe, Richard, of Bysley, carrier 0
4115148 2065706 2065706 defendant Uttyng Thomas husbandman 608117 608117 Uttyng, Thomas, of Bysley, husbandman 0
4232971 2107040 2107040 defendant Byrchett William yeoman 608117 608117 Byrchett, William, of Bysley, yeoman 3
4244515 2111146 2111146 defendant Rogers Thomas clothier 608117 608117 Rogers, Thomas, of Bysley, clothier 1
4244516 2111146 2111146 defendant Gardyner Edward yeoman 608117 608117 Gardyner, Edward, of Bysley, yeoman 2
4287227 2125490 2125490 defendant Hancoxe Margery widow 608117 608117 Hancoxe, Margery, of Bysley, widow 0
4287228 2125490 2125490 defendant Hancoxe John yeoman 608117 608117 Hancoxe, John, of Bysley, yeoman 1
4287230 2125491 2125491 defendant Hancoxe Margery widow 608117 608117 Hancoxe, Margery, of Bysley, widow 0
4287231 2125491 2125491 defendant Hancoxe John yeoman 608117 608117 Hancoxe, John, of Bysley, yeoman 1
4311666 2134223 2134223 defendant Taylowe Thomas clothier 608117 608117 Taylowe, Thomas, of Bysley, clothier 0
4384189 2159404 2159404 defendant Hopton Richard yeoman 608117 608117 Hopton, Richard, of Bysley, yeoman 0
4384190 2159404 2159404 defendant Robinson Joan widow 608117 608117 Robinson, Joan, of Bysley, widow 1
4387645 2160505 2160505 defendant Cobbett Robert thatcher 608117 608117 Cobbett, Robert, of Bysley, thatcher 1
4398559 2164098 2164098 defendant Dayngerfeild William clothier 608117 608117 Dayngerfeild, William, of Bysley, clothier 0
4710981 2268791 2268791 defendant atte Welle Robert laborer 608117 608117 atte Welle, Robert, of Bysley, laborer 0
4770325 2286689 2286689 defendant Notylyn John husbandman 608117 608117 Notylyn, John, of Bysley, husbandman 0
4802451 2296957 2296957 defendant Rooke Thomas yeoman 608117 608117 Rooke, Thomas, of Bysley, yeoman 3
4803341 2297236 2297236 defendant Dore Walter husbandman 608117 608117 Dore, Walter, of Bysley, husbandman 3
4823426 2303414 2303414 defendant Benyll or Bevyll Walter husbandman 608117 608117 Benyll or Bevyll, Walter, of Bysley, husbandman 1
4854969 2312909 2312909 defendant Roke Thomas husbandman 608117 608117 Roke, Thomas, of Bysley, husbandman 2
4976920 2350050 2350050 defendant Banknotte William husbandman 608117 608117 Banknotte, William, of Bysley, husbandman 1
4983309 2351913 2351913 defendant Lyon John, senior husbandman 608117 608117 Lyon, John, senior, of Bysley, husbandman 2
5013332 2360736 2360736 defendant Framptone Robert husbandman 608117 608117 Framptone, Robert, of Bysley, husbandman 1
5078705 2380118 2380118 defendant Castelman John yeoman 608117 608117 Castelman, John, of Bysley, yeoman 3
5138374 2397732 2397732 defendant Frampton Robert gent 608117 608117 Frampton, Robert, of Bysley, gent 1
5138375 2397732 2397732 defendant Frampton John husbandman 608117 608117 Frampton, John, of Bysley, husbandman 2
5138376 2397732 2397732 defendant Froucester Henry husbandman 608117 608117 Froucester, Henry, of Bysley, husbandman 3
5138378 2397732 2397732 defendant Houchyns John husbandman 608117 608117 Houchyns, John, of Bysley, husbandman 5
5159170 2403798 2403798 defendant Frampton Robert husbandman 608117 608117 Frampton, Robert, of Bysley, husbandman 1
5159171 2403798 2403798 defendant Frampton John husbandman 608117 608117 Frampton, John, of Bysley, husbandman 2
5159172 2403798 2403798 defendant Frouceter Henry husbandman 608117 608117 Frouceter, Henry, of Bysley, husbandman 3
5159174 2403798 2403798 defendant Houchyns John gent 608117 608117 Houchyns, John, of Bysley, gent 5
5174409 2408216 2408216 defendant Frampton Robert husbandman 608117 608117 Frampton, Robert, of Bysley, husbandman 1
5174410 2408216 2408216 defendant Frampton John husbandman 608117 608117 Frampton, John, of Bysley, husbandman 2
5174411 2408216 2408216 defendant Fronceter Henry husbandman 608117 608117 Fronceter, Henry, of Bysley, husbandman 3
5174413 2408216 2408216 defendant Houchyns John husbandman 608117 608117 Houchyns, John, of Bysley, husbandman 5
5273748 2437403 2437403 defendant Frampston John yeoman 608117 608117 Frampston, John, of Bysley, yeoman 3
5526760 2512939 2512939 defendant Pyre John yeoman 608117 608117 Pyre, John, of Bysley, yeoman 0
5526761 2512939 2512939 defendant Clyveshale or Clyneshale Richard husbandman 608117 608117 Clyveshale or Clyneshale, Richard, of Bysley, husbandman 1
5526762 2512939 2512939 defendant Taillour John husbandman 608117 608117 Taillour, John, of Bysley, husbandman 2
5598521 2534421 2534421 defendant Astmede alias Hunte John yeoman 608117 608117 Astmede alias Hunte, John, of Bysley, yeoman 0
5600199 2534945 2534945 defendant Attwod John chaplain 608117 608117 Attwod, John, of Bysley, chaplain 0

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