names

51 rows where place_id = 586688

✎ 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
3589379 1864317 1864317 defendant Bulkeley Ralph gent 586688 586688 Bulkeley, Ralph, of Bampton, Oxon, gent 4
3591201 1864871 1864871 defendant Turney John yeoman 586688 586688 Turney, John, of Bampton, Oxon, yeoman 0
3712855 1930341 1930341 defendant Weste Edmund husbandman 586688 586688 Weste, Edmund, of Bampton, Oxon, husbandman 0
3743543 1939856 1939856 defendant Weste Edmund husbandman 586688 586688 Weste, Edmund, of Bampton, Oxon, husbandman 0
3902603 1991103 1991103 defendant Bulkeley John yeoman 586688 586688 Bulkeley, John, of Bampton, Oxon, yeoman 0
4015077 2030080 2030080 defendant Frenche John yeoman 586688 586688 Frenche, John, of Bampton, Oxon, yeoman 0
4020968 2032227 2032227 defendant Knyght Richard gent 586688 586688 Knyght, Richard, of Bampton, Oxon, gent 3
4067782 2048789 2048789 defendant Wyllyard John mercer 586688 586688 Wyllyard, John, of Bampton, Oxon, mercer 0
4109147 2063525 2063525 defendant Knight Richard gent 586688 586688 Knight, Richard, of Bampton, Oxon, gent 0
4126767 2069861 2069861 defendant Smyth Joan widow 586688 586688 Joan his wife, formerly Joan Harrys, of Bampton, Oxon, widow 1
4189071 2091666 2091666 defendant Davy Watkin gent 586688 586688 Davy, Watkin, of Bampton, Oxon, gent 3
4206857 2097940 2097940 defendant Bursell or Cursell Mathew husbandman 586688 586688 Bursell or Cursell, Mathew, of Bampton, Oxon, husbandman 3
4355992 2149314 2149314 defendant Stokes John husbandman 586688 586688 Stokes, John, of Bampton, Oxon, husbandman 0
4380114 2157992 2157992 defendant Stookes John husbandman 586688 586688 Stookes, John, of Bampton, Oxon, husbandman 0
4465678 2189942 2189942 defendant Fretwell Thomas   586688 586688 Fretwell, Thomas, of Bampton, Oxon 0
4683168 2260352 2260352 defendant Hoper William clerk 586688 586688 Hoper, William, of Bampton, Oxon, clerk 0
4813063 2300201 2300201 defendant Fetyplace Thomas esq 586688 586688 Fetyplace, Thomas, of Bampton, Oxon, esq 0
4813068 2300202 2300202 defendant Fetiplace Thomas esq 586688 586688 Fetiplace, Thomas, of Bampton, Oxon, esq 0
4842294 2309120 2309120 defendant Wren Nicholas husbandman 586688 586688 Wren, Nicholas, of Bampton, Oxon, husbandman 1
4860994 2314796 2314796 defendant Wrenne Nicholas   586688 586688 Wrenne, Nicholas, of Bampton, Oxon, franklin 4
4861000 2314797 2314797 defendant Wrenne Nicholas   586688 586688 Wrenne, Nicholas, of Bampton, Oxon, franklin 3
4890586 2323814 2323814 defendant Phetiplas Thomas esq 586688 586688 Phetiplas, Thomas, of Bampton, Oxon, esq 2
4897285 2325808 2325808 defendant Phetoplas Thomas esq 586688 586688 Phetoplas, Thomas, of Bampton, Oxon, esq 2
4919399 2332577 2332577 defendant Hoper Robert chaplain 586688 586688 Hoper, Robert, of Bampton, Oxon, chaplain 0
4919468 2332593 2332593 plaintiff Hille John gent 586688 586688 Hille, John, of Bampton, Oxon, gent 0
4931654 2336289 2336289 defendant Kayho Geoffrey yeoman 586688 586688 Kayho, Geoffrey, of Bampton, Oxon, yeoman 1
4942387 2339606 2339606 defendant Wrenne Nicholas   586688 586688 Wrenne, Nicholas, of Bampton, Oxon, franklin 0
4945125 2340455 2340455 defendant Hoper Robert chaplain 586688 586688 Hoper, Robert, of Bampton, Oxon, chaplain 0
4945698 2340635 2340635 defendant Wayte Andrew husbandman 586688 586688 Wayte, Andrew, of Bampton, Oxon, husbandman 3
4957066 2344067 2344067 defendant Kayho Geoffrey   586688 586688 Kayho, Geoffrey, of Bampton, Oxon, bailiff 0
5004215 2358125 2358125 defendant Houper Robert chaplain 586688 586688 Houper, Robert, of Bampton, Oxon, chaplain 1
5026731 2364690 2364690 defendant Fila John clerk 586688 586688 Fila, John, of Bampton, Oxon, clerk 0
5043238 2369597 2369597 defendant Cayoo Geoffrey yeoman 586688 586688 Cayoo, Geoffrey, of Bampton, Oxon, yeoman 4
5043241 2369598 2369598 defendant Cayoo Geoffrey yeoman 586688 586688 Cayoo, Geoffrey, of Bampton, Oxon, yeoman 1
5199129 2415498 2415498 defendant Culmer John clerk 586688 586688 Culmer, John, of Bampton, Oxon, clerk 4
5326494 2453008 2453008 defendant Stokys Thomas, junior husbandman 586688 586688 Stokys, Thomas, junior, of Bampton, Oxon, husbandman 0
5341597 2457562 2457562 defendant Humfreyton Richard gent 586688 586688 Humfreyton, Richard, of Bampton, Oxon, gent 2
5386106 2471095 2471095 defendant Newman William chapman 586688 586688 Newman, William, of Bampton, Oxon, chapman 2
5398369 2474597 2474597 defendant Newman William chapman 586688 586688 Newman, William, of Bampton, Oxon, chapman 2
5416050 2479730 2479730 defendant Umfrey Henry husbandman 586688 586688 Umfrey, Henry, of Bampton, Oxon, husbandman 2
5420105 2480930 2480930 defendant Neweman William chapman 586688 586688 Neweman, William, of Bampton, Oxon, chapman 1
5432703 2484744 2484744 defendant Umfrey Henry husbandman 586688 586688 Umfrey, Henry, of Bampton, Oxon, husbandman 2
5432707 2484745 2484745 defendant Umfrey Henry husbandman 586688 586688 Umfrey, Henry, of Bampton, Oxon, husbandman 2
5432711 2484746 2484746 defendant Umfrey Henry husbandman 586688 586688 Umfrey, Henry, of Bampton, Oxon, husbandman 2
5520378 2511194 2511194 defendant Flodeate Henry husbandman 586688 586688 Flodeate, Henry, of Bampton, Oxon, husbandman 2
5535988 2515758 2515758 plaintiff Bryan William   586688 586688 Bryan, William, of Bampton, Oxon 0
5568263 2525262 2525262 defendant Clappam Robert butcher 586688 586688 Clappam, Robert, of Bampton, Oxon, butcher 1
5593399 2532918 2532918 defendant Sterthup Bartholomew husbandman 586688 586688 Sterthup, Bartholomew, of Bampton, Oxon, husbandman 1
5598487 2534414 2534414 defendant Sterthup Bartholomew husbandman 586688 586688 Sterthup, Bartholomew, of Bampton, Oxon, husbandman 1
5598492 2534415 2534415 defendant Sterthup Bartholomew husbandman 586688 586688 Sterthup, Bartholomew, of Bampton, Oxon, husbandman 0
5598498 2534416 2534416 defendant Smyth Robert husbandman 586688 586688 Smyth, Robert, of Bampton, Oxon, husbandman 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);