names

61 rows where place_id = 600025

✎ 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
3639385 1907128 1907128 defendant Whalley James yeoman 600025 600025 Whalley, James, of Shenston, yeoman 0
3639386 1907128 1907128 defendant Gresbroke John, junior yeoman 600025 600025 Gresbroke, John, junior, of Shenston, yeoman 1
3639387 1907128 1907128 defendant Ireland George laborer 600025 600025 Ireland, George, of Shenston, laborer 2
3639389 1907129 1907129 defendant Whalley James yeoman 600025 600025 Whalley, James, of Shenston, yeoman 0
3639390 1907129 1907129 defendant Gressebroke John, junior yeoman 600025 600025 Gressebroke, John, junior, of Shenston, yeoman 1
3640630 1907511 1907511 defendant Rokett William yeoman 600025 600025 Rokett, William, of Shenston, yeoman 0
3647675 1909663 1909663 defendant Hunt Henry clerk 600025 600025 Hunt, Henry, of Shenston, clerk 0
3654407 1911639 1911639 defendant Roket William yeoman 600025 600025 Roket, William, of Shenston, yeoman 0
3668760 1916164 1916164 defendant Gresbroke John, senior yeoman 600025 600025 Gresbroke, John, senior, of Shenston, yeoman 0
3668762 1916165 1916165 defendant Gresbroke John, senior yeoman 600025 600025 Gresbroke, John, senior, of Shenston, yeoman 0
3686746 1922008 1922008 defendant Richardys Henry husbandman 600025 600025 Richardys, Henry, of Shenston, husbandman 4
3700208 1926297 1926297 defendant Rokett William yeoman 600025 600025 Rokett, William, of Shenston, yeoman 0
3708368 1928911 1928911 defendant Richardis John husbandman 600025 600025 Richardis, John, of Shenston, husbandman 0
3708369 1928911 1928911 defendant Richardis Richard husbandman 600025 600025 Richardis, Richard, of Shenston, husbandman 1
3740224 1938800 1938800 defendant Cooke John husbandman 600025 600025 Cooke, John, of Shenston, husbandman 2
3836725 1969388 1969388 plaintiff Grasbroke John   600025 600025 (Grasbroke, John, of Shenston 1
3836731 1969389 1969389 plaintiff Grasbroke John   600025 600025 (Grasbroke, John, of Shenston 1
3836735 1969390 1969390 plaintiff Grasbroke John   600025 600025 (Grasbroke, John, of Shenston 1
3837789 1969733 1969733 defendant Ruddyng Ellen widow 600025 600025 Ruddyng, Ellen, of Shenston, widow 3
3837790 1969733 1969733 defendant Ruddyng Humphrey husbandman 600025 600025 Ruddyng, Humphrey, of Shenston, husbandman 4
3837792 1969734 1969734 defendant Ruddyng Ellen widow 600025 600025 Ruddyng, Ellen, of Shenston, widow 0
3837793 1969734 1969734 defendant Ruddyng Humphrey husbandman 600025 600025 Ruddyng, Humphrey, of Shenston, husbandman 1
3894614 1988407 1988407 defendant Gresbroke John yeoman 600025 600025 Gresbroke, John, of Shenston, yeoman 0
3894616 1988407 1988407 defendant Gresbroke Robert yeoman 600025 600025 Gresbroke, Robert, of Shenston, yeoman 2
3916883 1996011 1996011 defendant Hunte Robert yeoman 600025 600025 Hunte, Robert, of Shenston, yeoman 1
3922600 1997874 1997874 defendant Rydgeley Thomas gent 600025 600025 Rydgeley, Thomas, of Shenston, gent 0
3937960 2003029 2003029 defendant Walker Isabel spinster 600025 600025 Walker, Isabel, of Shenston, spinster 0
4025804 2033882 2033882 defendant Rydgdale George sawyer 600025 600025 Rydgdale, George, of Shenston, sawyer 1
4048144 2041772 2041772 defendant ap Ryce John husbandman 600025 600025 ap Ryce, John, of Shenston, husbandman 0
4048146 2041773 2041773 defendant Ruddinge Thomas yeoman 600025 600025 Ruddinge, Thomas, of Shenston, yeoman 0
4130466 2071209 2071209 defendant Yoxall John yeoman 600025 600025 Yoxall, John, of Shenston, yeoman 0
4170551 2085196 2085196 defendant Osburne John yeoman 600025 600025 Osburne, John, of Shenston, yeoman 0
4170552 2085196 2085196 defendant Norres Ralph smith 600025 600025 Norres, Ralph, of Shenston, smith 1
4201697 2096139 2096139 defendant Yoxall John yeoman 600025 600025 Yoxall, John, of Shenston, yeoman 0
4343922 2145155 2145155 defendant Parkes James yeoman 600025 600025 Parkes, James, of Shenston, yeoman 2
4356553 2149523 2149523 defendant Hanchurch John collier 600025 600025 Hanchurch, John, of Shenston, collier 1
4399242 2164331 2164331 defendant Ball Thomas tailor 600025 600025 Ball, Thomas, of Shenston, tailor 2
4531881 2210235 2210235 defendant Taillour Richard   600025 600025 Taillour, Richard, of Shenston 0
4747855 2279878 2279878 defendant Thomas servant of Thomas Carter laborer 600025 600025 Thomas, servant of Thomas Carter, of Shenston, laborer 1
4747858 2279879 2279879 defendant Brynton John husbandman 600025 600025 Brynton, John, of Shenston, husbandman 0
4747859 2279879 2279879 defendant Thomas-servant-Carter Thomas laborer 600025 600025 Thomas-servant-Carter, Thomas, of Shenston, laborer 1
4766546 2285527 2285527 defendant Brynton John husbandman 600025 600025 Brynton, John, of Shenston, husbandman 0
4766547 2285527 2285527 defendant Thomas servant of Thomas Carter laborer 600025 600025 Thomas, servant of Thomas Carter, of Shenston, laborer 1
4795439 2294726 2294726 defendant Brynton John husbandman 600025 600025 Brynton, John, of Shenston, husbandman 0
4795440 2294726 2294726 defendant Carter Thomas Thomasservant laborer 600025 600025 Carter, Thomas Thomasservant, of Shenston, laborer 1
4872002 2318217 2318217 defendant Gresbroke John husbandman 600025 600025 Gresbroke, John, of Shenston, husbandman 6
4872023 2318218 2318218 defendant Bresbroke John husbandman 600025 600025 Bresbroke, John, of Shenston, husbandman 6
4872049 2318219 2318219 defendant Bresbroke John husbandman 600025 600025 Bresbroke, John, of Shenston, husbandman 12
4952606 2342741 2342741 defendant Gresbroke John husbandman 600025 600025 Gresbroke, John, of Shenston, husbandman 0
4969848 2347930 2347930 defendant Sauvage John yeoman 600025 600025 Sauvage, John, of Shenston, yeoman 1
5094495 2384797 2384797 defendant Rugeley Robert gent 600025 600025 Rugeley, Robert, of Shenston, gent 0
5374049 2467486 2467486 plaintiff Keyley James   600025 600025 Keyley, James, of Shenston 1
5503985 2506158 2506158 defendant Southworth Thomas yeoman 600025 600025 Southworth, Thomas, of Shenston, yeoman 0
5503986 2506158 2506158 defendant Hykson William carpenter 600025 600025 Hykson, William, of Shenston, carpenter 1
5563834 2524030 2524030 defendant Hunt Henry clerk 600025 600025 Hunt, Henry, of Shenston, clerk 0
5563835 2524030 2524030 defendant Ryggeley William gent 600025 600025 Ryggeley, William, of Shenston, gent 1
5563836 2524030 2524030 defendant Whalley James yeman 600025 600025 Whalley, James, of Shenston, yeman 2
5563837 2524030 2524030 defendant Segwyke Roger husbandman 600025 600025 Segwyke, Roger, of Shenston, husbandman 3
5569886 2525767 2525767 defendant Hunt Roger pardoner 600025 600025 Hunt, Roger, of Shenston, pardoner 1
5604676 2536326 2536326 plaintiff Ruggeley William gent 600025 600025 Ruggeley, William, of Shenston, gent 0
5605702 2536669 2536669 defendant Hunt Henry clerk 600025 600025 (Hunt, Henry, of Shenston, clerk 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);