names

35 rows where place_id = 600119

✎ 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
3639770 1907248 1907248 defendant Gele John husbandman 600119 600119 Gele, John, of Ken, husbandman 0
3687732 1922331 1922331 defendant Bowhey Roger gent 600119 600119 Bowhey, Roger, of Ken, gent 0
3688513 1922565 1922565 defendant Dyer John yeoman 600119 600119 Dyer, John, of Ken, yeoman 2
3702556 1927069 1927069 defendant Colyn Thomas husbandman 600119 600119 Colyn, Thomas, of Ken, husbandman 0
3702557 1927069 1927069 defendant Peryman John tailor 600119 600119 Peryman, John, of Ken, tailor 1
3711114 1929789 1929789 defendant Cokke William yeoman 600119 600119 Cokke, William, of Ken, yeoman 0
3716338 1931401 1931401 defendant Colyn Thomas husbandman 600119 600119 Colyn, Thomas, of Ken, husbandman 0
3716339 1931401 1931401 defendant Peryman John tailor 600119 600119 Peryman, John, of Ken, tailor 1
3718635 1932106 1932106 defendant Bykham Robert husbandman 600119 600119 Bykham, Robert, of Ken, husbandman 0
3733248 1936632 1936632 defendant Huchyn William husbandman 600119 600119 Huchyn, William, of Ken, husbandman 0
3734377 1936991 1936991 defendant Bykham Robert husbandman 600119 600119 Bykham, Robert, of Ken, husbandman 0
3734382 1936993 1936993 defendant Symon John husbandman 600119 600119 Symon, John, of Ken, husbandman 0
3746097 1940687 1940687 defendant Jesse Henry husbandman 600119 600119 Jesse, Henry, of Ken, husbandman 0
3797121 1956982 1956982 defendant Hinchyn William husbandman 600119 600119 Hinchyn, William, of Ken, husbandman 0
3814355 1962402 1962402 defendant Cocke William husbandman 600119 600119 Cocke, William, of Ken, husbandman 0
3863487 1977984 1977984 defendant Ley Richard husbandman 600119 600119 Ley, Richard, of Ken, husbandman 0
4009004 2027985 2027985 defendant Ousley or Onsley Richard husbandman 600119 600119 Ousley or Onsley, Richard, of Ken, husbandman 0
4060040 2045988 2045988 defendant Penycott William yeoman 600119 600119 Penycott, William, of Ken, yeoman 0
4386401 2160131 2160131 defendant Pottery William yeoman 600119 600119 Pottery, William, of Ken, yeoman 1
4457019 2187207 2187207 defendant Stonpuge William   600119 600119 Stonpuge, William, of Ken 1
4525914 2208404 2208404 plaintiff Ken John   600119 600119 Ken, John, of Ken 0
4535595 2211410 2211410 plaintiff Smyth John   600119 600119 Smyth, John, of Ken 0
4550771 2216179 2216179 plaintiff Deny William   600119 600119 Deny, William, of Ken 0
4550772 2216179 2216179 defendant Jakeron Thomas   600119 600119 Jakeron, Thomas, of Ken 0
4556974 2218111 2218111 plaintiff Ken John   600119 600119 Ken, John, of Ken 0
4556975 2218111 2218111 defendant Jakeron Thomas   600119 600119 Jakeron, Thomas, of Ken 0
4556976 2218112 2218112 plaintiff Ken John   600119 600119 Ken, John, of Ken 0
4556977 2218112 2218112 defendant Russheworth John   600119 600119 Russheworth, John, of ken 0
4579415 2225039 2225039 defendant Uppehulle Henry   600119 600119 Uppehulle, Henry, of Ken 0
4582421 2225943 2225943 defendant Pyke Richard   600119 600119 Pyke, Richard, of Ken 0
4635485 2241958 2241958 defendant Stokwode Nicholas   600119 600119 Stokwode, Nicholas, of Ken 0
4651556 2246488 2246488 defendant Hethman Henry   600119 600119 Hethman, Henry, of Ken, bailiff 1
5315676 2449754 2449754 defendant Cokke William, senior yeoman 600119 600119 Cokke, William, senior, of Ken, yeoman 0
5480079 2499030 2499030 defendant Taillour Richard husbandman 600119 600119 Taillour, Richard, of Ken, husbandman 0
5544922 2518517 2518517 defendant Wodeward John, senior husbandman 600119 600119 Wodeward, John, senior, of Ken, 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);