names

40 rows where place_id = 683192

✎ 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
4052875 2043463 2043463 defendant Rowgell Philip mariner 683192 683192 Rowgell, Philip, of Alboroughe, mariner 1
4055289 2044290 2044290 defendant Pytt John husbandman 683192 683192 Pytt, John, of Alboroughe, husbandman 0
4073633 2050861 2050861 defendant Strutton William carpenter 683192 683192 Strutton, William, of Alboroughe, carpenter 0
4073634 2050861 2050861 defendant Clement Roger carpenter 683192 683192 Clement, Roger, of Alboroughe, carpenter 1
4090196 2056781 2056781 defendant Deye William brewer 683192 683192 Deye, William, of Alboroughe, brewer 0
4091998 2057433 2057433 defendant Deye Robert yeoman 683192 683192 Deye, Robert, of Alboroughe, yeoman 0
4091999 2057433 2057433 defendant Freman Thomas yeoman 683192 683192 Freman, Thomas, of Alboroughe, yeoman 1
4092000 2057433 2057433 defendant Cadman William yeoman 683192 683192 Cadman, William, of Alboroughe, yeoman 2
4092001 2057433 2057433 defendant Casar Agnes widow 683192 683192 Casar, Agnes, of Alboroughe, widow 3
4092007 2057435 2057435 defendant Ellys Richard yeoman 683192 683192 Ellys, Richard, of Alboroughe, yeoman 0
4106331 2062554 2062554 defendant Bygg Richard yeoman 683192 683192 Bygg, Richard, of Alboroughe, yeoman 0
4106332 2062554 2062554 defendant Brunche William husbandman 683192 683192 Brunche, William, of Alboroughe, husbandman 1
4114905 2065618 2065618 defendant Daye William beer brewer 683192 683192 Daye, William, of Alboroughe, beer brewer 0
4137117 2073624 2073624 defendant Curdye William yeoman 683192 683192 Curdye, William, of Alboroughe, yeoman 0
4137118 2073624 2073624 defendant Hocker John, junior yeoman 683192 683192 together with Hocker, John, junior, of Alboroughe, yeoman 1
4141568 2075214 2075214 defendant Moore John clerk 683192 683192 Moore, John, of Alboroughe, clerk 2
4141740 2075275 2075275 defendant Warren John yeoman 683192 683192 Warren, John, of Alboroughe, yeoman 0
4150106 2078174 2078174 defendant More John clerk 683192 683192 More, John, of Alboroughe, clerk 0
4195417 2093942 2093942 defendant Gosse Christopher tailor 683192 683192 Gosse, Christopher, of Alboroughe, clerk Levold, John, of Starston, tailor 1
4201648 2096119 2096119 defendant Wester John butcher 683192 683192 Wester, John, of Alboroughe, butcher 2
4214917 2100719 2100719 defendant Harward Thomas gent 683192 683192 Harward, Thomas, of Alboroughe, gent 0
4227939 2105254 2105254 defendant Harwarde Thomas gent 683192 683192 Harwarde, Thomas, of Alboroughe, gent 4
4248416 2112459 2112459 defendant Seber William cordwainer 683192 683192 Seber, William, of Alboroughe, cordwainer 0
4251439 2113462 2113462 defendant Webster Robert, junior butcher 683192 683192 Webster, Robert, junior, of Alboroughe, butcher 1
4259396 2116117 2116117 defendant Fuller Christopher husbandman 683192 683192 Fuller, Christopher, of Alboroughe, husbandman 1
4260118 2116348 2116348 defendant Crapnell or Cracknell Lionel yeoman 683192 683192 Crapnell or Cracknell, Lionel, of Alboroughe, yeoman 2
4262185 2117024 2117024 defendant Skete Henry yeoman 683192 683192 Skete, Henry, of Alboroughe, yeoman 2
4262186 2117024 2117024 defendant Thurston Margaret widow 683192 683192 Thurston, Margaret, of Alboroughe, widow 3
4286258 2125137 2125137 defendant Baron or Barnes Thomas yeoman 683192 683192 Baron or Barnes, Thomas, of Alboroughe, yeoman 0
4318803 2136691 2136691 defendant Lullocke or Lubbocke James husbandman 683192 683192 Lullocke or Lubbocke, James, of Alboroughe, husbandman 2
4323251 2138193 2138193 defendant Hocker John, junior yeoman 683192 683192 Hocker, John, junior, of Alboroughe, yeoman 0
4323252 2138193 2138193 defendant Hocker John, senior yeoman 683192 683192 together with Hocker, John, senior, of Alboroughe, yeoman 1
4324024 2138446 2138446 defendant Capon George yeoman 683192 683192 Capon, George, of Alboroughe, yeoman 3
4332435 2141137 2141137 defendant Gogle or Gogell James yeoman 683192 683192 Gogle or Gogell, James, of Alboroughe, yeoman 1
4348836 2146854 2146854 defendant More John clerk 683192 683192 More, John, of Alboroughe, clerk 0
4350481 2147430 2147430 defendant Baron Thomas yeoman 683192 683192 Baron, Thomas, of Alboroughe, yeoman 0
4391670 2161832 2161832 defendant Webster Thomas butcher 683192 683192 Webster, Thomas, of Alboroughe, or of Wickmer, butcher 0
4399958 2164575 2164575 defendant Moore John clerk 683192 683192 Moore, John, of Alboroughe, clerk 0
4403381 2165698 2165698 defendant Bucke Richard husbandman 683192 683192 Bucke, Richard, of Alboroughe, husbandman 1
4404977 2166235 2166235 defendant Gogle James yeoman 683192 683192 Gogle, James, of Alboroughe, 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);