names

57 rows where place_id = 610102

✎ 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
3681927 1920450 1920450 defendant Carnesewe William esq 610102 610102 Carnesewe, William, of St Kewe, esq 0
3681929 1920451 1920451 defendant Carnesowe William esq 610102 610102 Carnesowe, William, of St Kewe, esq 0
3746958 1940967 1940967 defendant Hynche Robert husbandman 610102 610102 Hynche, Robert, of St Kewe, husbandman 0
3760431 1945265 1945265 defendant Hynche Robert husbandman 610102 610102 Hynche, Robert, of St Kewe, husbandman 0
3760433 1945266 1945266 defendant Hynche Robert husbandman 610102 610102 Hynche, Robert, of St Kewe, husbandman 0
3778428 1950967 1950967 defendant Cabyll Nicholas gent 610102 610102 Cabyll, Nicholas, of St Kewe, gent 1
3783811 1952706 1952706 defendant Cabyll Nicholas gent 610102 610102 Cabyll, Nicholas, of St Kewe, gent 0
3800585 1958091 1958091 defendant Sutton John Laborer 610102 610102 Sutton, John, of St Kewe, Laborer 0
3800586 1958091 1958091 defendant Huchyn Mathew laborer 610102 610102 Huchyn, Mathew, of St Kewe, laborer 1
3800587 1958091 1958091 defendant Burnard William laborer 610102 610102 Burnard, William, of St Kewe, laborer 2
3856519 1975666 1975666 defendant Dagge John yeoman 610102 610102 Dagge, John, of St Kewe, yeoman 1
3912693 1994579 1994579 defendant Dagge William husbandman 610102 610102 Dagge, William, of St Kewe, husbandman 0
3915471 1995542 1995542 defendant Archer William husbandman 610102 610102 Archer, William, of St Kewe, husbandman 0
3945701 2005570 2005570 defendant Olyver George husbandman 610102 610102 Olyver, George, of St Kewe, husbandman 5
3961311 2011054 2011054 defendant Mathewe William yeoman 610102 610102 Mathewe, William, of St Kewe, yeoman 0
3964813 2012302 2012302 defendant Dagge John yeoman 610102 610102 Dagge, John, of St Kewe, yeoman 0
4006339 2027046 2027046 defendant Nycoll Thomas yeoman 610102 610102 Nycoll, Thomas, of St Kewe, yeoman 2
4011127 2028748 2028748 defendant Goldsmyth Robert clerk 610102 610102 Goldsmyth, Robert, of St Kewe, clerk 3
4019633 2031748 2031748 plaintiff Webber Nicholas husbandman 610102 610102 Webber, Nicholas, of St Kewe, husbandman 0
4079298 2052898 2052898 defendant Lawndye William husbandman 610102 610102 Lawndye, William, of St Kewe, husbandman 1
4079300 2052898 2052898 defendant Parson John husbandman 610102 610102 Parson, John, of St Kewe, husbandman 3
4098801 2059900 2059900 defendant Carnyewe George gent 610102 610102 together with Carnyewe, George, of St Kewe, gent 4
4107389 2062931 2062931 defendant Warren Edward husbandman 610102 610102 Warren, Edward, of St Kewe, husbandman 0
4110321 2063952 2063952 defendant Wylkens William husbandman 610102 610102 Wylkens, William, of St Kewe, husbandman 0
4110333 2063955 2063955 defendant Carnyewe George gent 610102 610102 together with Carnyewe, George, of St Kewe, gent 4
4133920 2072467 2072467 defendant Crome Thomas husbandman 610102 610102 Crome, Thomas, of St Kewe, husbandman 0
4133921 2072467 2072467 defendant Crome William husbandman 610102 610102 Crome, William, of St Kewe, husbandman 1
4145802 2076685 2076685 defendant Webber William yeoman 610102 610102 Webber, William, of St Kewe, yeoman 0
4158880 2081174 2081174 defendant Webber William yeoman 610102 610102 Webber, William, of St Kewe, yeoman 0
4158881 2081174 2081174 defendant Webber Francis husbandman 610102 610102 Webber, Francis, of St Kewe, husbandman 1
4158882 2081174 2081174 defendant Webber John husbandman 610102 610102 Webber, John, of St Kewe, husbandman 2
4172334 2085787 2085787 defendant Blake John husbandman 610102 610102 Blake, John, of St Kewe, husbandman 0
4172339 2085788 2085788 defendant Jeffery Richard husbandman 610102 610102 Jeffery, Richard, of St Kewe, husbandman 0
4172340 2085788 2085788 defendant Blake Thomas husbandman 610102 610102 Blake, Thomas, of St Kewe, husbandman 1
4172341 2085788 2085788 defendant Webber Richard husbandman 610102 610102 Webber, Richard, of St Kewe, husbandman 2
4172342 2085788 2085788 defendant Frodde Thomas husbandman 610102 610102 Frodde, Thomas, of St Kewe, husbandman 3
4172344 2085789 2085789 defendant Jeffery Richard husbandman 610102 610102 Jeffery, Richard, of St Kewe, husbandman 0
4172345 2085789 2085789 defendant Webber Richard husbandman 610102 610102 Webber, Richard, of St Kewe, husbandman 1
4172346 2085789 2085789 defendant Frodde Thomas husbandman 610102 610102 Frodde, Thomas, of St Kewe, husbandman 2
4172347 2085789 2085789 defendant Blake Thomas husbandman 610102 610102 Blake, Thomas, of St Kewe, husbandman 3
4242334 2110431 2110431 defendant Tennye John husbandman 610102 610102 together with Tennye, John, of St Kewe, husbandman 1
4247858 2112268 2112268 defendant Mathewe Richard gent 610102 610102 Mathewe, Richard, of St Kewe, gent 0
4252973 2113987 2113987 defendant Carnsewe George, junior gent 610102 610102 Carnsewe, George, junior, of St Kewe, gent 2
4261825 2116909 2116909 defendant Mathewe Richard gent 610102 610102 Mathewe, Richard, of St Kewe, gent 0
4293892 2127885 2127885 defendant Vallys Thomas laborer 610102 610102 Vallys, Thomas, of St Kewe, laborer 0
4297819 2129326 2129326 defendant Carnsewe George gent 610102 610102 (Carnsewe, George, of St Kewe, gent 1
4297820 2129326 2129326 defendant Inche Thomasine widow 610102 610102 Inche, Thomasine, of St Kewe, widow 2
4299745 2129994 2129994 defendant Goldsmythe John clerk 610102 610102 Goldsmythe, John, of St Kewe, clerk 0
4331734 2140909 2140909 defendant Inche or Juche John yeoman 610102 610102 Inche or Juche, John, of St Kewe, yeoman 2
4376032 2156492 2156492 defendant Inche John yeoman 610102 610102 Inche, John, of St Kewe, yeoman 0
4380140 2158000 2158000 defendant Randell Thomas yeoman 610102 610102 Randell, Thomas, of St Kewe, yeoman 0
4388013 2160620 2160620 defendant Goldesmithe John, senior clerk 610102 610102 Goldesmithe, John, senior, of St Kewe, clerk 0
4388014 2160620 2160620 defendant Goldesmithe John, junior merchant 610102 610102 Goldesmithe, John, junior, of St Kewe, merchant 1
4389715 2161187 2161187 defendant Dagge Richard gent 610102 610102 Dagge, Richard, of St Kewe, gent 2
4799514 2296028 2296028 defendant Bertram Walter carpenter 610102 610102 Bertram, Walter, of St Kewe, carpenter 0
5081100 2380851 2380851 defendant Archer John husbandman 610102 610102 Archer, John, of St Kewe, husbandman 6
5554939 2521448 2521448 defendant Huchyn William butcher 610102 610102 Huchyn, William, of St Kewe, butcher 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);