names

23 rows where place_id = 762123

✎ 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
3872444 1981007 1981007 defendant Skynner Reginald   762123 762123 Skynner, Reginald, of Roudham, worsted weaver 0
4484802 2195944 2195944 defendant Cawell Henry   762123 762123 Cawell, Henry, of Roudham 0
4489461 2197424 2197424 defendant Sporle Richard   762123 762123 Sporle, Richard, of Roudham 1
4512344 2204302 2204302 defendant Cristemesse Richard chaplain 762123 762123 Cristemesse, Richard, of Roudham, chaplain 0
4512345 2204302 2204302 defendant Benne John   762123 762123 Benne, John, of Roudham 1
4533991 2210900 2210900 defendant Parlour William   762123 762123 Parlour, William, of Roudham 0
4548756 2215549 2215549 defendant atte Greve John   762123 762123 atte Greve, John, of Roudham 3
4548766 2215550 2215550 defendant Grene John   762123 762123 Grene, John, of Roudham 3
4554074 2217198 2217198 defendant Sporle Richard   762123 762123 Sporle, Richard, of Roudham 0
4569547 2222061 2222061 defendant Sporle Richard   762123 762123 Sporle, Richard, of Roudham 1
4571509 2222667 2222667 defendant Benne John   762123 762123 Benne, John, of Roudham 3
4573414 2223216 2223216 defendant Benne John   762123 762123 Benne, John, of Roudham 1
4579949 2225215 2225215 defendant Benne John   762123 762123 Benne, John, of Roudham 5
4606285 2233077 2233077 defendant Benne John   762123 762123 Benne, John, of Roudham 1
4613990 2235389 2235389 defendant Parlour William   762123 762123 Parlour, William, of Roudham 2
4627933 2239665 2239665 defendant Benne John   762123 762123 Benne, John, of Roudham 1
4627934 2239665 2239665 defendant Benne Henry   762123 762123 Benne, Henry, of Roudham 2
4688613 2262002 2262002 plaintiff Thweyt Edmund   762123 762123 Thweyt, Edmund, of Roudham, on his own account 0
4755227 2282023 2282023 defendant Parbour or Parkour William husbandman 762123 762123 Parbour or Parkour, William, of Roudham, husbandman 1
4756748 2282474 2282474 defendant Parlour William husbandman 762123 762123 Parlour, William, of Roudham, husbandman 3
5306561 2446953 2446953 defendant Payn Peter gent 762123 762123 Payn, Peter, of Roudham, gent 0
5508288 2507476 2507476 defendant Smythe Thomas husbandman 762123 762123 Smythe, Thomas, of Roudham, husbandman 1
5508293 2507477 2507477 defendant Smythe Thomas husbandman 762123 762123 Smythe, Thomas, of Roudham, husbandman 1

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