names

26 rows where place_id = 618894

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3726983 1934708 1934708 defendant Mountforth Martin gent 618894 618894 Mountforth, Martin, of Tyso, gent 2
3743783 1939939 1939939 defendant Grey Thomas yeoman 618894 618894 Grey, Thomas, of Tyso, yeoman 2
3749367 1941722 1941722 defendant Dales Joan widow 618894 618894 Dales, Joan, of Tyso, widow 1
3772451 1949072 1949072 defendant Clyfton Edward chaplain 618894 618894 Clyfton, Edward, of Tyso, chaplain 0
3850705 1973811 1973811 defendant Emyns alias Chesse William husbandman 618894 618894 Emyns alias Chesse, William, of Tyso, husbandman 0
3856525 1975668 1975668 defendant Reve William husbandman 618894 618894 Reve, William, of Tyso, husbandman 0
3879141 1983276 1983276 defendant Spycer Thomas husbandman 618894 618894 Spycer, Thomas, of Tyso, husbandman 1
3880580 1983765 1983765 defendant Taylour John tailor 618894 618894 Taylour, John, of Tyso, tailor 0
3884843 1985203 1985203 defendant Rede William husbandman 618894 618894 Rede, William, of Tyso, husbandman 2
3890610 1987123 1987123 defendant Spycer John husbandman 618894 618894 Spycer, John, of Tyso, husbandman 1
4071637 2050151 2050151 defendant Rychard Thomas husbandman 618894 618894 Rychard, Thomas, of Tyso, husbandman 1
4383008 2159031 2159031 defendant Shropshire Richard yeoman 618894 618894 Shropshire, Richard, of Tyso, yeoman 0
4525331 2208264 2208264 defendant Sergant John   618894 618894 Sergant, John, of Tyso 0
4597259 2230387 2230387 defendant Walker Stephen   618894 618894 Walker, Stephen, of Tyso 1
4753339 2281420 2281420 defendant Clerkes William laborer 618894 618894 Clerkes, William, of Tyso, laborer 1
4826046 2304184 2304184 defendant Middilton William husbandman 618894 618894 Middilton, William, of Tyso, husbandman 1
4826062 2304185 2304185 defendant all the rest are husbandman: Middilton William   618894 618894 all the rest are husbandman: Middilton, William, of Tyso 1
4849669 2311374 2311374 defendant Hulle John husbandman 618894 618894 Hulle, John, of Tyso, husbandman 0
4849671 2311375 2311375 defendant Heynes William husbandman 618894 618894 Heynes, William, of Tyso, husbandman 0
4852103 2312089 2312089 defendant Parker Roger   618894 618894 Parker, Roger, of Tyso, park man 0
4852104 2312089 2312089 defendant Middilton William husbandman 618894 618894 Middilton, William, of Tyso, husbandman 1
4880042 2320671 2320671 defendant Parker Roger parker 618894 618894 Parker, Roger, of Tyso, parker 0
4880043 2320671 2320671 defendant Middilton William husbandman 618894 618894 Middilton, William, of Tyso, husbandman 1
5120185 2392343 2392343 defendant atte Vyne William husbandman 618894 618894 atte Vyne, William, of Tyso, husbandman 0
5274083 2437498 2437498 defendant Bussh Martin husbandman 618894 618894 Bussh, Martin, of tyso, husbandman 2
5478431 2498574 2498574 defendant Busby Walter clerk 618894 618894 Busby, Walter, of Tyso, clerk 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);