names

36 rows where place_id = 593189

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610849 1871061 1871061 defendant Porter John husbandman 593189 593189 Porter, John, of Kneseworth, husbandman 0
3626132 1903034 1903034 defendant Game John husbandman 593189 593189 Game, John, of Kneseworth, husbandman 1
3645060 1908864 1908864 defendant Noble Richard tailor 593189 593189 Noble, Richard, of Kneseworth, tailor 1
3645061 1908864 1908864 defendant Porter Richard baker 593189 593189 Porter, Richard, of Kneseworth, baker 2
3645062 1908864 1908864 defendant Ingleby Robert laborer 593189 593189 Ingleby, Robert, of Kneseworth, laborer 3
3645063 1908864 1908864 defendant Warde John laborer 593189 593189 Warde, John, of Kneseworth, laborer 4
3652471 1911104 1911104 defendant Gybbe Thomas husbandman 593189 593189 Gybbe, Thomas, of Kneseworth, husbandman 1
3898979 1989864 1989864 defendant Porter Richard husbandman 593189 593189 Porter, Richard, of Kneseworth, husbandman 0
4416723 2170096 2170096 plaintiff Orable Simon   593189 593189 Orable, Simon, of Kneseworth 0
4682383 2260109 2260109 defendant Chaunberlayn Warin husbandman 593189 593189 Chaunberlayn, Warin, of Kneseworth, husbandman 1
4841711 2308944 2308944 defendant Strete Reginald gent 593189 593189 Strete, Reginald, of Kneseworth, gent 0
4991413 2354318 2354318 defendant Fylyon Richard husbandman 593189 593189 Fylyon, Richard, of Kneseworth, husbandman 0
5042137 2369256 2369256 defendant Okeman John husbandman 593189 593189 Okeman, John, of Kneseworth, husbandman 0
5064000 2375764 2375764 defendant Gillyngale Richard husbandman 593189 593189 Gillyngale, Richard, of Kneseworth, husbandman 0
5064001 2375764 2375764 defendant Wryght John   593189 593189 Wryght, John, of Kneseworth, servant 1
5064003 2375765 2375765 defendant Gyllyngale Richard husbandman 593189 593189 Gyllyngale, Richard, of Kneseworth, husbandman 0
5064009 2375768 2375768 defendant Wryght John   593189 593189 Wryght, John, of Kneseworth, servant 0
5064011 2375769 2375769 defendant Gillyngale Richard husbandman 593189 593189 Gillyngale, Richard, of Kneseworth, husbandman 0
5064012 2375769 2375769 defendant Wryght John   593189 593189 Wryght, John, of Kneseworth, servant 1
5100851 2386664 2386664 defendant Sprotford Richard husbandman 593189 593189 Sprotford, Richard, of Kneseworth, husbandman 0
5111123 2389638 2389638 defendant Nokeman John husbandman 593189 593189 Nokeman, John, of Kneseworth, husbandman 4
5111275 2389688 2389688 defendant Nokeman John thatcher 593189 593189 Nokeman, John, of Kneseworth, thatcher 0
5111278 2389688 2389688 defendant Gybbes Robert husbandman 593189 593189 Gybbes, Robert, of Kneseworth, husbandman 3
5111279 2389688 2389688 defendant Gibbes Waren husbandman 593189 593189 Gibbes, Waren, of Kneseworth, husbandman 4
5152062 2401740 2401740 defendant Okeman John thatcher 593189 593189 Okeman, John, of Kneseworth, thatcher 1
5152064 2401740 2401740 defendant Gyllyngale Richard husbandman 593189 593189 Gyllyngale, Richard, of Kneseworth, husbandman 3
5169982 2406955 2406955 defendant Okeman John thatcher 593189 593189 Okeman, John, of Kneseworth, thatcher 0
5169984 2406955 2406955 defendant Gyllyngale Richard husbandman 593189 593189 Gyllyngale, Richard, of Kneseworth, husbandman 2
5222005 2422140 2422140 defendant Kneseworth Richard gent 593189 593189 Kneseworth, Richard, of Kneseworth, gent 0
5240734 2427499 2427499 defendant Gibbe Warren   593189 593189 Gibbe, Warren, of Kneseworth, holy water clerk 2
5240739 2427500 2427500 defendant Stampeyn Richard husbandman 593189 593189 Stampeyn, Richard, of Kneseworth, husbandman 1
5260164 2433305 2433305 defendant Broun John yeoman 593189 593189 Broun, John, of Kneseworth, yeoman 0
5260165 2433305 2433305 defendant Daffron William chaplain 593189 593189 Daffron, William, of Kneseworth, chaplain 1
5265375 2434926 2434926 defendant Kneseworth John (legal representative) 593189 593189 Kneseworth, John, of Kneseworth, gent, administrator of 1
5540420 2517135 2517135 defendant Barford William husbandman 593189 593189 Barford, William, of Kneseworth, husbandman 0
5546155 2518867 2518867 plaintiff Tadlowe Thomas husbandman 593189 593189 Tadlowe, Thomas, of Kneseworth, 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);