names

62 rows where place_id = 598400

✎ 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
3632303 1904922 1904922 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
3642718 1908167 1908167 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
3656912 1912419 1912419 defendant White John husbandman 598400 598400 White, John, of Churstowe, husbandman 0
3656913 1912419 1912419 defendant Pers Henry   598400 598400 Pers, Henry, of Churstowe, mason 1
3656914 1912419 1912419 defendant Yell William   598400 598400 Yell, William, of Churstowe, mason 2
3693775 1924250 1924250 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3693777 1924251 1924251 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
3704232 1927622 1927622 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
3770096 1948310 1948310 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3795046 1956314 1956314 defendant Mugge John husbandman 598400 598400 Mugge, John, of Churstowe, husbandman 0
3795048 1956315 1956315 defendant Mugge John husbandman 598400 598400 Mugge, John, of Churstowe, husbandman 0
3797423 1957082 1957082 plaintiff Gilbert alias Webber William merchant 598400 598400 Gilbert alias Webber, William, of Churstowe, merchant 0
3805675 1959718 1959718 defendant Knollyng Robert husbandman 598400 598400 Knollyng, Robert, of Churstowe, husbandman 0
3810014 1961020 1961020 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 1
3814685 1962504 1962504 plaintiff Gilbert alias Webbe William Merchant 598400 598400 Gilbert alias Webbe, William, of Churstowe, Merchant 0
3819116 1963869 1963869 defendant Knollyng Robert husbandman 598400 598400 Knollyng, Robert, of Churstowe, husbandman 0
3823203 1965170 1965170 defendant Knollyng Robert husbandman 598400 598400 Knollyng, Robert, of Churstowe, husbandman 0
3824882 1965665 1965665 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3833731 1968480 1968480 defendant Hedde John, senior   598400 598400 Hedde, John, senior, of Churstowe, groom 0
3833732 1968480 1968480 defendant Hedde John, junior   598400 598400 Hedde, John, junior, of Churstowe, groom 1
3846262 1972388 1972388 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3875083 1981899 1981899 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3875087 1981901 1981901 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3875089 1981902 1981902 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3875091 1981903 1981903 defendant Legh John gent 598400 598400 Legh, John, of Churstowe, gent 0
3940659 2003881 2003881 defendant Whyte Thomas husbandman 598400 598400 Whyte, Thomas, of Churstowe, husbandman 0
3940660 2003881 2003881 defendant Squyer Robert husbandman 598400 598400 Squyer, Robert, of Churstowe, husbandman 1
3965405 2012512 2012512 defendant Byckeforde Thomas husbandman 598400 598400 Byckeforde, Thomas, of Churstowe, husbandman 0
3974598 2015679 2015679 defendant Burdwood John husbandman 598400 598400 Burdwood, John, of Churstowe, husbandman 0
3974599 2015679 2015679 defendant Campe John laborer 598400 598400 Campe, John, of Churstowe, laborer 1
3974600 2015679 2015679 defendant Tokerman Robert laborer 598400 598400 Tokerman, Robert, of Churstowe, laborer 2
3974601 2015679 2015679 defendant Nycholl John laborer 598400 598400 Nycholl, John, of Churstowe, laborer 3
3995152 2023013 2023013 defendant Burdwood John yeoman 598400 598400 Burdwood, John, of Churstowe, yeoman 1
4191968 2092750 2092750 defendant Buncker Nicholas husbandman 598400 598400 Buncker, Nicholas, of Churstowe, husbandman 0
4191969 2092750 2092750 defendant Buncker Thomas husbandman 598400 598400 Buncker, Thomas, of Churstowe, husbandman 1
4191970 2092750 2092750 defendant Buncker Maud spinster 598400 598400 Buncker, Maud, of Churstowe, spinster 2
4813520 2300337 2300337 defendant Benet Thomas husbandman 598400 598400 Benet, Thomas, of Churstowe, husbandman 0
4848220 2310914 2310914 defendant Hauke Robert husbandman 598400 598400 Hauke, Robert, of Churstowe, husbandman 2
4970905 2348242 2348242 defendant Spealte David husbandman 598400 598400 Spealte, David, of Churstowe, husbandman 0
4970906 2348242 2348242 defendant Abraham Richard chaplain 598400 598400 Abraham, Richard, of Churstowe, chaplain 1
4970907 2348242 2348242 defendant Horne John husbandman 598400 598400 Horne, John, of Churstowe, husbandman 2
5043837 2369783 2369783 defendant Boys John   598400 598400 Boys, John, of Churstowe, groom 1
5048956 2371322 2371322 defendant Benet Peter yeoman 598400 598400 Benet, Peter, of Churstowe, yeoman 0
5048957 2371322 2371322 defendant Benet Isolda widow 598400 598400 Benet, Isolda, of Churstowe, widow 1
5048958 2371322 2371322 defendant Erle John husbandman 598400 598400 Erle, John, of Churstowe, husbandman 2
5062873 2375429 2375429 defendant Boys Stephen husbandman 598400 598400 Boys, Stephen, of Churstowe, husbandman 2
5070339 2377622 2377622 defendant Sampson Richard chaplain 598400 598400 Sampson, Richard, of Churstowe, chaplain 0
5108986 2389046 2389046 defendant Hayes Peter husbandman 598400 598400 Hayes, Peter, of Churstowe, husbandman 0
5127177 2394425 2394425 defendant Cobyn William husbandman 598400 598400 Cobyn, William, of Churstowe, husbandman 2
5150593 2401318 2401318 defendant Holdyche John husbandman 598400 598400 Holdyche, John, of Churstowe, husbandman 0
5166263 2405854 2405854 defendant Colyn William husbandman 598400 598400 Colyn, William, of Churstowe, husbandman 2
5169057 2406684 2406684 defendant Holdyche John husbandman 598400 598400 Holdyche, John, of Churstowe, husbandman 0
5204815 2417159 2417159 defendant Holdyche John husbandman 598400 598400 Holdyche, John, of Churstowe, husbandman 0
5238289 2426782 2426782 defendant Suddon Lawrence weaver 598400 598400 Suddon, Lawrence, of Churstowe, weaver 0
5238290 2426782 2426782 defendant Brewer Walter husbandman 598400 598400 Brewer, Walter, of Churstowe, husbandman 1
5238291 2426782 2426782 defendant Ferys John husbandman 598400 598400 Ferys, John, of Churstowe, husbandman 2
5275426 2437880 2437880 defendant Legh Thomas husbandman 598400 598400 Legh, Thomas, of Churstowe, husbandman 3
5299703 2444882 2444882 defendant Spealte John husbandman 598400 598400 Spealte, John, of Churstowe, husbandman 0
5483257 2499936 2499936 defendant Legh William yeoman 598400 598400 Legh, William, of Churstowe, yeoman 1
5549276 2519839 2519839 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
5587148 2531009 2531009 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 0
5598772 2534493 2534493 defendant Legh William gent 598400 598400 Legh, William, of Churstowe, gent 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);