names

41 rows where place_id = 603529

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654841 1911773 1911773 defendant Ball Adam husbandman 603529 603529 Ball, Adam, of Thorleston, husbandman 0
3654842 1911773 1911773 defendant Lyston Robert husbandman 603529 603529 Lyston, Robert, of Thorleston, husbandman 1
3666186 1915371 1915371 defendant Cornyssh Robert husbandman 603529 603529 Cornyssh, Robert, of Thorleston, husbandman 0
3705609 1928035 1928035 defendant Putte Robert laborer 603529 603529 Putte, Robert, of Thorleston, laborer 0
3709943 1929425 1929425 defendant Ball Isabel widow 603529 603529 Ball, Isabel, of Thorleston, widow 0
3709945 1929425 1929425 defendant Stephyn David husbandman 603529 603529 Stephyn, David, of Thorleston, husbandman 2
3709947 1929426 1929426 defendant Ball Isabel widow 603529 603529 Ball, Isabel, of Thorleston, widow 0
3709948 1929426 1929426 defendant Stephyn David husbandman 603529 603529 Stephyn, David, of Thorleston, husbandman 1
3709949 1929426 1929426 defendant Putte Robert laborer 603529 603529 Putte, Robert, of Thorleston, laborer 2
3709950 1929426 1929426 defendant Clement John laborer 603529 603529 Clement, John, of Thorleston, laborer 3
3709951 1929426 1929426 defendant Seman Joan spinster 603529 603529 Seman, Joan, of Thorleston, spinster 4
3709952 1929426 1929426 defendant Wakeham Isabel spinster 603529 603529 Wakeham, Isabel, of Thorleston, spinster 5
3723775 1933712 1933712 defendant Cornysshe Robert husbandman 603529 603529 Cornysshe, Robert, of Thorleston, husbandman 0
3724518 1933954 1933954 defendant Pernell John weaver 603529 603529 Pernell, John, of Thorleston, weaver 0
3775316 1950019 1950019 defendant Phelip Roger husbandman 603529 603529 Phelip, Roger, of Thorleston, husbandman 0
3787540 1953893 1953893 defendant Phelyp Roger husbandman 603529 603529 Phelyp, Roger, of Thorleston, husbandman 1
3792615 1955550 1955550 defendant Phelip or Phenp Roger husbandman 603529 603529 Phelip or Phenp, Roger, of Thorleston, husbandman 1
4518715 2206229 2206229 plaintiff Dorset John   603529 603529 Dorset, John, of Thorleston 0
4660247 2249038 2249038 defendant Rugge Edmund (legal representative) 603529 603529 Rugge, Edmund, of Thorleston, executors of 4
4660496 2249108 2249108 defendant del Rodes John, senior yeoman 603529 603529 del Rodes, John, senior, of Thorleston, yeoman 0
4660497 2249108 2249108 defendant Hesilhed John yeoman 603529 603529 Hesilhed, John, of Thorleston, yeoman 1
4710534 2268653 2268653 defendant Brewer John husbandman 603529 603529 Brewer, John, of Thorleston, husbandman 0
4710536 2268653 2268653 defendant Baker Robert husbandman 603529 603529 Baker, Robert, of Thorleston, husbandman 2
4758244 2282952 2282952 defendant Boolde Richard husbandman 603529 603529 Boolde, Richard, of Thorleston, husbandman 4
4794319 2294365 2294365 defendant Prideaux William gent 603529 603529 Prideaux, William, of Thorleston, gent 0
4809664 2299187 2299187 defendant atte Wode John husbandman 603529 603529 atte Wode, John, of Thorleston, husbandman 0
4809665 2299187 2299187 defendant Cove or Cone John husbandman 603529 603529 Cove or Cone, John, of Thorleston, husbandman 1
4809666 2299187 2299187 defendant Hillyng Robert husbandman 603529 603529 Hillyng, Robert, of Thorleston, husbandman 2
4809667 2299187 2299187 defendant Sture Walter husbandman 603529 603529 Sture, Walter, of Thorleston, husbandman 3
4814922 2300775 2300775 defendant Burle John gent 603529 603529 Burle, John, of Thorleston, gent 0
4889270 2323431 2323431 defendant Burley John gent 603529 603529 Burley, John, of Thorleston, gent 0
4929320 2335588 2335588 defendant Burlegh John gent 603529 603529 Burlegh, John, of Thorleston, gent 0
4946524 2340907 2340907 defendant Forde Robert husbandman 603529 603529 (Forde, Robert, of Thorleston, husbandman 1
4962909 2345822 2345822 defendant Kylmynawattys William husbandman 603529 603529 Kylmynawattys, William, of Thorleston, husbandman 0
5016521 2361727 2361727 defendant Kent John chaplain 603529 603529 Kent, John, of Thorleston, chaplain 0
5016522 2361727 2361727 defendant Stephene John husbandman 603529 603529 Stephene, John, of Thorleston, husbandman 1
5016523 2361727 2361727 defendant Kylmynawet William husbandman 603529 603529 together with Kylmynawet, William, of Thorleston, husbandman 2
5039780 2368541 2368541 defendant Walton William   603529 603529 Walton, William, of Thorleston, mason 1
5521050 2511408 2511408 defendant Balle Adam yeoman 603529 603529 Balle, Adam, of Thorleston, yeoman 0
5634518 2554795 2554795 defendant Bruwer John laborer 603529 603529 Bruwer, John, of Thorleston, laborer 0
5634519 2554795 2554795 defendant Horne William laborer 603529 603529 Horne, William, of Thorleston, laborer 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);