names

56 rows where place_id = 587503

✎ 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
3591586 1864993 1864993 defendant Becham William yeoman 587503 587503 Becham, William, of Orleton, yeoman 0
3609784 1870729 1870729 defendant Hasell John husbandman 587503 587503 Hasell, John, of Orleton, husbandman 0
3609785 1870729 1870729 defendant Shepard David husbandman 587503 587503 Shepard, David, of Orleton, husbandman 1
3642006 1907949 1907949 defendant Parlour Richard husbandman 587503 587503 Parlour, Richard, of Orleton, husbandman 1
3642446 1908081 1908081 defendant Caswold Henry gent 587503 587503 Caswold, Henry, of Orleton, gent 2
3680259 1919898 1919898 defendant Caswall Henry gent 587503 587503 Caswall, Henry, of Orleton, gent 0
3680260 1919898 1919898 defendant Caswall Thomas gent 587503 587503 Caswall, Thomas, of Orleton, gent 1
3686694 1921992 1921992 defendant Jonys John husbandman 587503 587503 Jonys, John, of Orleton, husbandman 2
3686695 1921992 1921992 defendant Jenyns John husbandman 587503 587503 Jenyns, John, of Orleton, husbandman 3
3726709 1934616 1934616 defendant Monmouth Nicholas husbandman 587503 587503 Monmouth, Nicholas, of Orleton, husbandman 0
3742378 1939488 1939488 defendant Monmoth Nicholas husbandman 587503 587503 Monmoth, Nicholas, of Orleton, husbandman 0
3744434 1940161 1940161 defendant Fleccher Margery widow 587503 587503 Fleccher, Margery, of Orleton, widow 1
3799586 1957791 1957791 defendant Lluwellin Thomas tailor 587503 587503 Lluwellin, Thomas, of Orleton, tailor 0
3838878 1970087 1970087 defendant Walker John husbandman 587503 587503 Walker, John, of Orleton, husbandman 0
3838949 1970110 1970110 defendant Hyll John husbandman 587503 587503 Hyll, John, of Orleton, husbandman 0
3838950 1970110 1970110 defendant Harfeld alias Hasett John husbandman 587503 587503 Harfeld alias Hasett, John, of Orleton, husbandman 1
3838951 1970110 1970110 defendant Tromper John husbandman 587503 587503 Tromper, John, of Orleton, husbandman 2
3850450 1973730 1973730 defendant Hyll John yeoman 587503 587503 Hyll, John, of Orleton, yeoman 0
3850452 1973730 1973730 defendant Parlour Thomas husbandman 587503 587503 Parlour, Thomas, of Orleton, husbandman 2
3855254 1975278 1975278 defendant Walker John husbandman 587503 587503 Walker, John, of Orleton, husbandman 0
3864109 1978180 1978180 defendant Walker John husbandman 587503 587503 Walker, John, of Orleton, husbandman 1
3878216 1982962 1982962 defendant Walker John yeoman 587503 587503 Walker, John, of Orleton, yeoman 0
3909470 1993468 1993468 defendant Walker John husbandman 587503 587503 Walker, John, of Orleton, husbandman 0
3940099 2003705 2003705 defendant Marten Richard husbandman 587503 587503 Marten, Richard, of Orleton, husbandman 1
4013555 2029585 2029585 defendant Fysher John   587503 587503 Fysher, John, of Orleton, yeoman, son of William 2
4013556 2029585 2029585 defendant Fysher Thomas   587503 587503 Fysher, Thomas, of Orleton, yeoman, son of William 3
4013561 2029586 2029586 defendant Fyssher John   587503 587503 Fyssher, John, of Orleton, yeoman, son of William 2
4013562 2029586 2029586 defendant Fyssher Thomas   587503 587503 Fyssher, Thomas, of Orleton, yeoman, son of William 3
4032384 2036245 2036245 defendant Deykyns William yeoman 587503 587503 Deykyns, William, of Orleton, yeoman 13
4032403 2036248 2036248 defendant Deykyns William yeoman 587503 587503 Deykyns, William, of Orleton, yeoman 9
4051582 2042984 2042984 defendant Wever Roger husbandman 587503 587503 Wever Roger, of Orleton, husbandman 0
4319190 2136826 2136826 defendant Turford Roger carpenter 587503 587503 Turford, Roger, of Orleton, carpenter 0
4511355 2203996 2203996 defendant Wolrich Walter   587503 587503 Wolrich, Walter, of Orleton 2
4511357 2203996 2203996 defendant Hulle James de la   587503 587503 Hulle, James de la, of Orleton 4
4579749 2225153 2225153 defendant Roberdeys William   587503 587503 Roberdeys, William, of Orleton 2
4579758 2225154 2225154 defendant Roberdeys William   587503 587503 Roberdeys, William, of Orleton 6
4610165 2234260 2234260 defendant Wolrych Walter   587503 587503 Wolrych, Walter, of Orleton 2
4611034 2234521 2234521 defendant Fyssher Hugh   587503 587503 (Fyssher, Hugh, of Orleton 1
4611036 2234521 2234521 defendant Smyth Richard   587503 587503 Smyth, Richard, of Orleton, administrators of 3
4611041 2234522 2234522 defendant Fyssher Hugh   587503 587503 (Fyssher, Hugh, of Orleton 1
4611043 2234522 2234522 defendant Smyth Richard   587503 587503 Smyth, Richard, of Orleton, administrators of 3
4638565 2242816 2242816 defendant Wolriche Walter   587503 587503 Wolriche, Walter, of Orleton 1
4647216 2245242 2245242 defendant Smyth William   587503 587503 Smyth, William, of Orleton 0
4661191 2249325 2249325 plaintiff Dydwy John   587503 587503 Dydwy, John, of Orleton 0
4820040 2302344 2302344 defendant Casewell Nicholas gent 587503 587503 Casewell, Nicholas, of Orleton, gent 0
4821699 2302861 2302861 defendant Reve John husbandman 587503 587503 Reve, John, of Orleton, husbandman 0
4871580 2318081 2318081 defendant Mersshe Nicholas chapman 587503 587503 Mersshe, Nicholas, of Orleton, chapman 1
4871581 2318081 2318081 defendant Broun Philip husbandman 587503 587503 Broun, Philip, of Orleton, husbandman 2
4904778 2328098 2328098 defendant Breton John husbandman 587503 587503 Breton, John, of Orleton, husbandman 2
4949378 2341792 2341792 defendant Walle William barker 587503 587503 Walle, William, of Orleton, barker 0
5118328 2391796 2391796 defendant Casewall Robert gent 587503 587503 Casewall, Robert, of Orleton, gent 0
5126776 2394308 2394308 defendant Casnall Robert gent 587503 587503 Casnall, Robert, of Orleton, gent 1
5279465 2439075 2439075 defendant Bolte John husbandman 587503 587503 Bolte, John, of Orleton, husbandman 0
5508558 2507542 2507542 defendant Mason William   587503 587503 Mason, William, of Orleton, mason 3
5584211 2530131 2530131 defendant Bydhawhyle Thomas husbandman 587503 587503 Bydhawhyle, Thomas, of Orleton, husbandman 4
5606274 2536856 2536856 defendant Brymfyld Thomas yeoman 587503 587503 Brymfyld, Thomas, of Orleton, yeoman 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);