names

55 rows where place_id = 593280

✎ 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
3611173 1871171 1871171 defendant Wryght Henry husbandman 593280 593280 Wryght, Henry, of Flyntham, husbandman 0
3611175 1871172 1871172 defendant Wryght Henry husbandman 593280 593280 Wryght, Henry, of Flyntham, husbandman 0
3645413 1908974 1908974 defendant Hussey William gent 593280 593280 Hussey, William, of Flyntham, gent 0
3792699 1955569 1955569 defendant Howtoft William gent 593280 593280 Howtoft, William, of Flyntham, gent 0
3809224 1960766 1960766 defendant Howtoft William gent 593280 593280 Howtoft, William, of Flyntham, gent 0
3896207 1988936 1988936 defendant Hursy John gent 593280 593280 Hursy, John, of Flyntham, gent 0
4004303 2026319 2026319 defendant Hotteff or Hottess Richard yeoman 593280 593280 Hotteff or Hottess, Richard, of Flyntham, yeoman 0
4004305 2026320 2026320 defendant Hottoff Richard yeoman 593280 593280 Hottoff, Richard, of Flyntham, yeoman 0
4045613 2040881 2040881 defendant Banke James gent 593280 593280 Banke, James, of Flyntham, gent 0
4115935 2065985 2065985 defendant Bank Elizabeth widow 593280 593280 Bank, Elizabeth, of Flyntham, widow 0
4115938 2065986 2065986 defendant Hussey Edmund gent 593280 593280 Hussey, Edmund, of Flyntham, gent 0
4184082 2089929 2089929 defendant Antyn John husbandman 593280 593280 Antyn, John, of Flyntham, husbandman 0
4411656 2168495 2168495 defendant Pacie Robert husbandman 593280 593280 Pacie, Robert, of Flyntham, husbandman 0
4411657 2168495 2168495 defendant Bradley John yeoman 593280 593280 Bradley, John, of Flyntham, yeoman 1
4451788 2185537 2185537 plaintiff Hotot John   593280 593280 Hotot, John, of Flyntham 0
4451789 2185537 2185537 defendant Clerk William chaplain 593280 593280 Clerk, William, of Flyntham, chaplain 0
4451790 2185537 2185537 defendant Langton Joan   593280 593280 Langton, Joan, of Flyntham 1
4451793 2185537 2185537 defendant Draper John   593280 593280 Draper, John, of Flyntham 4
4451794 2185537 2185537 defendant Dankynson John   593280 593280 Dankynson, John, of Flyntham 5
4451795 2185538 2185538 plaintiff Hotot John   593280 593280 Hotot, John, of Flyntham 0
4494533 2198984 2198984 plaintiff Bracebrig John   593280 593280 Bracebrig, John, of Flyntham 0
4510796 2203835 2203835 defendant Harenge Henry   593280 593280 Harenge, Henry, of Flyntham 0
4512262 2204274 2204274 defendant Averenge Henry   593280 593280 Averenge, Henry, of Flyntham 0
4524715 2208068 2208068 plaintiff Hotoft John   593280 593280 Hotoft, John, of Flyntham 0
4558036 2218450 2218450 defendant Peke William   593280 593280 Peke, William, of Flyntham, vicar 0
4574514 2223560 2223560 defendant Peek William   593280 593280 Peek, William, of Flyntham 0
4598817 2230858 2230858 defendant Westron John   593280 593280 Westron, John, of Flyntham 6
4602403 2231968 2231968 defendant Huse Hugh   593280 593280 Huse, Hugh, of Flyntham, knight 0
4602405 2231969 2231969 defendant Huse Hugh   593280 593280 Huse, Hugh, of Flyntham, knight 0
4615864 2235953 2235953 defendant Hose Hugh   593280 593280 Hose, Hugh, of Flyntham, knight 0
4615866 2235954 2235954 defendant Hose Hugh   593280 593280 Hose, Hugh, of Flyntham, knight 0
4633574 2241356 2241356 defendant Nedeham John de   593280 593280 Nedeham, John de, of Flyntham, vicar 0
4644667 2244525 2244525 defendant Kyng John   593280 593280 Kyng, John, of Flyntham 0
4662427 2249724 2249724 defendant Huse Hugh   593280 593280 Huse, Hugh, of Flyntham, knight 0
4690125 2262469 2262469 defendant Landeford John de husbandman 593280 593280 Landeford, John de, of Flyntham, husbandman 0
4719779 2271532 2271532 defendant Carpenter John weaver 593280 593280 Carpenter, John, of Flyntham, weaver 2
4724124 2272840 2272840 defendant Smyth John chaplain 593280 593280 Smyth, John, of Flyntham, chaplain 0
4724125 2272840 2272840 defendant Savage John husbandman 593280 593280 Savage, John, of Flyntham, husbandman 1
4744383 2278882 2278882 defendant Smyth John chaplain 593280 593280 Smyth, John, of Flyntham, chaplain 0
4744384 2278882 2278882 defendant Savage John husbandman 593280 593280 Savage, John, of Flyntham, husbandman 1
4833786 2306575 2306575 defendant Huse Hugh esq 593280 593280 Huse, Hugh, of Flyntham, esq 0
4966667 2346965 2346965 plaintiff Drapour John   593280 593280 Drapour, John, of Flyntham 0
4983774 2352075 2352075 defendant Draper John yeoman 593280 593280 Draper, John, of Flyntham, yeoman 1
4983775 2352075 2352075 defendant Carter John yeoman 593280 593280 Carter, John, of Flyntham, yeoman 2
5046016 2370437 2370437 defendant Draper John   593280 593280 Draper, John, of Flyntham 3
5131259 2395630 2395630 defendant Smyth Hugh smith 593280 593280 Smyth, Hugh, of Flyntham, smith 2
5150772 2401369 2401369 defendant Smyth Hugh smith 593280 593280 Smyth, Hugh, of Flyntham, smith 2
5239830 2427225 2427225 defendant Huse Henry esq 593280 593280 Huse, Henry, of Flyntham, esq 0
5274662 2437666 2437666 defendant Hosy Henry gent 593280 593280 Hosy, Henry, of Flyntham, gent 2
5292168 2442704 2442704 defendant Hosy Henry gent 593280 593280 Hosy, Henry, of Flyntham, gent 1
5379044 2469038 2469038 defendant Draper Thomas yeoman 593280 593280 Draper, Thomas, of Flyntham, yeoman 1
5432168 2484588 2484588 defendant Weston William husbandman 593280 593280 Weston, William, of Flyntham, husbandman 1
5622837 2551072 2551072 defendant Draper John   593280 593280 Draper, John, of Flyntham 0
5622838 2551072 2551072 defendant Smyth Adam   593280 593280 Smyth, Adam, of Flyntham 1
5627036 2552424 2552424 defendant Hotoft John   593280 593280 Hotoft, John, of Flyntham 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);