names

31 rows where place_id = 592193

✎ 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
3606888 1869819 1869819 defendant Organ Thomas husbandman 592193 592193 Organ, Thomas, of Westerley, husbandman 0
3670106 1916595 1916595 defendant Chestentre John carpenter 592193 592193 Chestentre, John, of Westerley, carpenter 1
3678375 1919292 1919292 defendant Joachym Thomas, junior   592193 592193 Joachym, Thomas, junior, of Westerley, "wayneman" 0
3771681 1948842 1948842 defendant Pryg Richard husbandman 592193 592193 Pryg, Richard, of Westerley, husbandman 2
3828118 1966661 1966661 defendant Tomkyns John chaplain 592193 592193 Tomkyns, John, of Westerley, chaplain 3
3877714 1982787 1982787 defendant Fowler John husbandman 592193 592193 Fowler, John, of Westerley, husbandman 1
3896858 1989161 1989161 defendant Chaterton George yeoman 592193 592193 Chaterton, George, of Westerley, yeoman 0
3911269 1994087 1994087 defendant Chaterton George yeoman 592193 592193 Chaterton, George, of Westerley, yeoman 0
3911271 1994088 1994088 defendant Chatterton George yeoman 592193 592193 Chatterton, George, of Westerley, yeoman 0
3913851 1994979 1994979 defendant Somers Thomas husbandman 592193 592193 Somers, Thomas, of Westerley, husbandman 1
3921736 1997613 1997613 defendant Chadderton George gent 592193 592193 Chadderton, George, of Westerley, gent 0
4028102 2034701 2034701 defendant Wykham John baker 592193 592193 Wykham, John, of Westerley, baker 0
4493966 2198807 2198807 defendant Hulle John   592193 592193 Hulle, John, of Westerley 1
4538662 2212369 2212369 defendant Ferrour Richard   592193 592193 Ferrour, Richard, of Westerley 0
4607519 2233464 2233464 defendant Sheppeherd William   592193 592193 Sheppeherd, William, of Westerley 2
4607520 2233464 2233464 defendant Taillour John   592193 592193 Taillour, John, of Westerley 3
4614149 2235434 2235434 defendant Taillour John   592193 592193 Taillour, John, of Westerley 1
4627886 2239652 2239652 defendant Hulle John   592193 592193 Hulle, John, of Westerley 0
4708583 2268056 2268056 defendant Lendesey Walter husbandman 592193 592193 Lendesey, Walter, of Westerley, husbandman 0
4774978 2288170 2288170 defendant Taillour John collier 592193 592193 Taillour, John, of Westerley, collier 5
4866368 2316449 2316449 defendant Hull- William yeoman 592193 592193 Hull-, William, of Westerley, yeoman 3
4890080 2323676 2323676 defendant Hille William yeoman 592193 592193 Hille, William, of Westerley, yeoman 2
5078706 2380118 2380118 defendant Hyll William yeoman 592193 592193 Hyll, William, of Westerley, yeoman 4
5171012 2407247 2407247 defendant Priour John husbandman 592193 592193 Priour, John, of Westerley, husbandman 2
5171013 2407247 2407247 defendant Peryman John husbandman 592193 592193 Peryman, John, of Westerley, husbandman 3
5189209 2412575 2412575 defendant Priour John husbandman 592193 592193 Priour, John, of Westerley, husbandman 2
5189210 2412575 2412575 defendant Peryman John husbandman 592193 592193 Peryman, John, of Westerley, husbandman 3
5206428 2417612 2417612 defendant Priour John husbandman 592193 592193 Priour, John, of Westerley, husbandman 2
5206429 2417612 2417612 defendant Peryman John husbandman 592193 592193 Peryman, John, of Westerley, husbandman 3
5218984 2421282 2421282 defendant Hylle William husbandman 592193 592193 Hylle, William, of Westerley, husbandman 2
5526287 2512801 2512801 defendant Rogers Thomas husbandman 592193 592193 Rogers, Thomas, of Westerley, husbandman 2

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);