names

59 rows where place_id = 603944

✎ 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
3656318 1912221 1912221 defendant Blome William butcher 603944 603944 Blome, William, of Dilham, butcher 0
3786474 1953561 1953561 defendant Sadler Nicholas   603944 603944 Sadler, Nicholas, of Dilham, worsted weaver 2
3865688 1978744 1978744 plaintiff Norgate John yeoman 603944 603944 Norgate, John, of Dilham, yeoman 0
3871351 1980668 1980668 defendant Lister William yeoman 603944 603944 Lister, William, of Dilham, yeoman 1
4076088 2051743 2051743 plaintiff Sewell Richard (legal representative) 603944 603944 Sewell, Richard, of Dilham, yeoman, executors of 0
4076094 2051743 2051743 defendant Tompson Henry sawyer 603944 603944 Tompson, Henry, of Dilham, sawyer 3
4076095 2051744 2051744 plaintiff Sewell Richard (legal representative) 603944 603944 Sewell, Richard, of Dilham, yeoman, executors of 0
4076100 2051745 2051745 plaintiff Sewell Richard (legal representative) 603944 603944 Sewell, Richard, of Dilham, yeoman, executors of 0
4076107 2051746 2051746 plaintiff Sewell Richard (legal representative) 603944 603944 Sewell, Richard, of Dilham, yeoman, executors of 0
4076114 2051747 2051747 plaintiff Sewell Richard (legal representative) 603944 603944 Sewell, Richard, of Dilham, yeoman, executors of 0
4076119 2051747 2051747 defendant Cubitt William butcher 603944 603944 Cubitt, William, of Dilham, butcher 2
4110817 2064125 2064125 defendant Dockyng Thomas yeoman 603944 603944 Dockyng, Thomas, of Dilham, yeoman 0
4110818 2064125 2064125 defendant Dockyng William husbandman 603944 603944 Dockyng, William, of Dilham, husbandman 1
4163587 2082785 2082785 defendant Cubitt William yeoman 603944 603944 Cubitt, William, of Dilham, yeoman 0
4187133 2090992 2090992 defendant Cubit William yeoman 603944 603944 Cubit, William, of Dilham, yeoman 0
4208775 2098617 2098617 defendant Dawson Stephen husbandman 603944 603944 Dawson, Stephen, of Dilham, husbandman 0
4310696 2133886 2133886 defendant Sewell Richard   603944 603944 Sewell, Richard, of Dilham yeoman 1
4327648 2139567 2139567 defendant Davy Hugh yeoman 603944 603944 Davy, Hugh, of Dilham, yeoman 0
4390908 2161573 2161573 defendant Davye Hugh yeoman 603944 603944 Davye, Hugh, of Dilham, yeoman 1
4407449 2167051 2167051 defendant Docking William husbandman 603944 603944 Docking, William, of Dilham, husbandman 0
4410524 2168111 2168111 defendant Kempe William gent 603944 603944 Kempe, William, of Dilham, gent 0
4415426 2169722 2169722 defendant Millere John le   603944 603944 Millere, John le, of Dilham 2
4441129 2182150 2182150 defendant Seyne Henry   603944 603944 Seyne, Henry, of Dilham 0
4454365 2186381 2186381 defendant Lyngsted William de   603944 603944 Lyngsted, William de, of Dilham 4
4460586 2188368 2188368 plaintiff Skot William   603944 603944 Skot, William, of Dilham 0
4509371 2203404 2203404 defendant Bolt Thomas   603944 603944 Bolt, Thomas, of Dilham 0
4565803 2220861 2220861 defendant Scot Geoffrey   603944 603944 Scot, Geoffrey, of Dilham 0
4577202 2224385 2224385 defendant Seyve Henry   603944 603944 Seyve, Henry, of Dilham 0
4686930 2261518 2261518 defendant Pygre Roger husbandman 603944 603944 Pygre, Roger, of Dilham, husbandman 2
4780533 2289908 2289908 defendant Geney John (legal representative) 603944 603944 Geney, John, of Dilham, knight, executors of 0
4780535 2289908 2289908 defendant Clepysby Robert esq 603944 603944 Clepysby, Robert, of Dilham, esq 2
4782642 2290584 2290584 defendant Robynys John husbandman 603944 603944 Robynys, John, of Dilham, husbandman 4
4793506 2294078 2294078 defendant Warmale John husbandman 603944 603944 Warmale, John, of Dilham, husbandman 0
4868317 2317067 2317067 defendant Funhale William husbandman 603944 603944 Funhale, William, of Dilham, husbandman 0
4868318 2317067 2317067 defendant Haldeyn Richard husbandman 603944 603944 Haldeyn, Richard, of Dilham, husbandman 1
4874276 2318899 2318899 defendant Briggate John, junior tailor 603944 603944 Briggate, John, junior, of Dilham, tailor 3
4937670 2338159 2338159 defendant Adams John husbandman 603944 603944 Adams, John, of Dilham, husbandman 0
4937673 2338160 2338160 defendant Adams John husbandman 603944 603944 Adams, John, of Dilham, husbandman 0
4945949 2340719 2340719 defendant Lynstede John husbandman 603944 603944 Lynstede, John, of Dilham, husbandman 0
4945960 2340723 2340723 plaintiff Inglose Henry   603944 603944 Inglose, Henry, of Dilham, knight 0
4989030 2353657 2353657 defendant Plumsted Nicholas chapman 603944 603944 Plumsted, Nicholas, of Dilham, chapman 0
4996116 2355695 2355695 defendant Inglose Henry   603944 603944 Inglose, Henry, of Dilham, knight 0
4996119 2355696 2355696 defendant Ingolse Henry   603944 603944 Ingolse, Henry, of Dilham, knight 0
5056211 2373434 2373434 defendant Chaumbyr John husbandman 603944 603944 Chaumbyr, John, of Dilham, husbandman 1
5077342 2379719 2379719 defendant Hardyngham John husbandman 603944 603944 Hardyngham, John, of Dilham, husbandman 5
5083076 2381446 2381446 defendant Geffreys Thomas husbandman 603944 603944 Geffreys, Thomas, of Dilham, husbandman 4
5086442 2382431 2382431 defendant Hardyngham John husbandman 603944 603944 Hardyngham, John, of Dilham, husbandman 1
5093819 2384592 2384592 defendant Love Edmund husbandman 603944 603944 Love, Edmund, of Dilham, husbandman 1
5101997 2387007 2387007 defendant Inglose Robert esq 603944 603944 Inglose, Robert, of Dilham, esq 2
5109651 2389251 2389251 defendant Inglose Henry (legal representative) 603944 603944 Inglose, Henry, of Dilham, knight, executors of 0
5109661 2389252 2389252 defendant Inglose Henry (legal representative) 603944 603944 Inglose, Henry, of Dilham, knight, executor of 0
5139872 2398139 2398139 defendant Inglose Henry esq 603944 603944 Inglose, Henry, of Dilham, esq 0
5160874 2404279 2404279 defendant Inglose Henry esq 603944 603944 Inglose, Henry, of Dilham, esq 0
5175529 2408525 2408525 defendant Ingolse Henry esq 603944 603944 Ingolse, Henry, of Dilham, esq 0
5182050 2410498 2410498 defendant Inglose Henry esq 603944 603944 Inglose, Henry, of Dilham, esq 0
5209821 2418607 2418607 defendant Inglose Henry esq 603944 603944 Inglose, Henry, of Dilham, esq 0
5236951 2426392 2426392 defendant Ewe alias Palfreyman Matthew husbandman or clerk 603944 603944 Ewe alias Palfreyman, Matthew, of Dilham, husbandman or clerk 0
5331706 2454571 2454571 defendant Neweland John husbandman 603944 603944 Neweland, John, of Dilham, husbandman 1
5540237 2517076 2517076 defendant Denewe John husbandman 603944 603944 Denewe, John, of Dilham, husbandman 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);