names

24 rows where place_id = 618309

✎ 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
3723827 1933730 1933730 defendant Godyn Christopher husbandman 618309 618309 Godyn, Christopher, of Upchirche, husbandman 0
3723829 1933731 1933731 defendant Godyn Lawrence husbandman 618309 618309 Godyn, Lawrence, of Upchirche, husbandman 0
4587693 2227557 2227557 defendant Upton William   618309 618309 Upton, William, of Upchirche 0
4587827 2227595 2227595 defendant Upton William   618309 618309 Upton, William, of Upchirche 0
4601913 2231823 2231823 defendant Uptone William   618309 618309 Uptone, William, of Upchirche 3
4647842 2245434 2245434 defendant Upton William   618309 618309 Upton, William, of Upchirche 2
4705347 2267045 2267045 defendant Borke John husbandman 618309 618309 Borke, John, of Upchirche, husbandman 1
4711731 2268990 2268990 defendant Hurt Alice widow 618309 618309 Hurt, Alice, of Upchirche, widow 1
4747549 2279787 2279787 defendant atte John Broke husbandman 618309 618309 atte John, Broke, of Upchirche, husbandman 0
4782558 2290556 2290556 defendant atte Forde Henry laborer 618309 618309 atte Forde, Henry, of Upchirche, laborer 0
4907214 2328820 2328820 defendant Spodill John husbandman 618309 618309 Spodill, John, of Upchirche, husbandman 0
5013280 2360718 2360718 defendant Cerlys Nicholas husbandman 618309 618309 Cerlys, Nicholas, of Upchirche, husbandman 0
5063799 2375704 2375704 defendant Wroughton Henry gent 618309 618309 Wroughton, Henry, of Upchirche, gent 0
5063800 2375704 2375704 defendant Wroughton William husbandman 618309 618309 Wroughton, William, of Upchirche, husbandman 1
5080025 2380506 2380506 defendant Colyn John husbandman 618309 618309 Colyn, John, of Upchirche, husbandman 3
5080027 2380507 2380507 defendant Colyn John husbandman 618309 618309 Colyn, John, of Upchirche, husbandman 0
5105737 2388128 2388128 defendant Wroghtone William husbandman 618309 618309 Wroghtone, William, of Upchirche, husbandman 0
5237705 2426612 2426612 defendant Godewyn James husbandman 618309 618309 Godewyn, James, of Upchirche, husbandman 2
5290480 2442220 2442220 defendant Badcok John husbandman 618309 618309 Badcok, John, of Upchirche, husbandman 2
5290484 2442221 2442221 defendant Baldok John husbandman 618309 618309 Baldok, John, of Upchirche, husbandman 2
5290487 2442222 2442222 defendant Baldok John husbandman 618309 618309 Baldok, John, of Upchirche, husbandman 1
5514585 2509409 2509409 defendant Waryn Henry husbandman 618309 618309 Waryn, Henry, of Upchirche, husbandman 0
5597459 2534105 2534105 defendant Waren Henry husbandman 618309 618309 Waren, Henry, of Upchirche, husbandman 2
5626407 2552230 2552230 defendant Coker William   618309 618309 Coker, William, of Upchirche, gent, son of Adam Coker, knight 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);