names

21 rows where place_id = 649200

✎ 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
3905529 1992117 1992117 defendant Keynes Humphrey esq 649200 649200 Keynes, Humphrey, of Wynckley, esq 0
4071317 2050045 2050045 defendant Hamont Robert husbandman 649200 649200 Hamont, Robert, of Wynckley, husbandman 1
4071318 2050045 2050045 defendant Joppe Humphrey husbandman 649200 649200 Joppe, Humphrey, of Wynckley, husbandman 2
4080850 2053462 2053462 defendant Jope Humphrey husbandman 649200 649200 Jope, Humphrey, of Wynckley, husbandman 0
4080977 2053511 2053511 defendant Bennet John husbandman 649200 649200 Bennet, John, of Wynckley, husbandman 0
4080978 2053511 2053511 defendant Bennet Robert husbandman 649200 649200 Bennet, Robert, of Wynckley, husbandman 1
4127076 2069975 2069975 defendant Hatherleighe Nicholas husbandman 649200 649200 Hatherleighe, Nicholas, of Wynckley, husbandman 0
4127077 2069975 2069975 defendant Ellys William husbandman 649200 649200 Ellys, William, of Wynckley, husbandman 1
4192414 2092901 2092901 defendant May John weaver 649200 649200 May, John, of Wynckley, weaver 0
4203133 2096645 2096645 defendant Webber John yeoman 649200 649200 Webber, John, of Wynckley, yeoman 0
4203436 2096753 2096753 defendant Bennett Edward dyer 649200 649200 Bennett, Edward, of Wynckley, dyer 0
4203437 2096753 2096753 defendant Barnpoole William   649200 649200 Barnpoole, William, of Wynckley, groom 1
4223073 2103560 2103560 defendant Hayne alias Wood Richard   649200 649200 Hayne alias Wood, Richard, of Wynckley yeoman 0
4223074 2103560 2103560 defendant Sowdon Roger clerk 649200 649200 Sowdon, Roger, of Wynckley, clerk 1
4243938 2110953 2110953 defendant Luxston Thomas husbandman 649200 649200 Luxston, Thomas, of Wynckley, husbandman 0
4267311 2118702 2118702 defendant Luxton Peter husbandman 649200 649200 Luxton, Peter, of Wynckley, husbandman 0
4290333 2126597 2126597 defendant Pawe George yeoman 649200 649200 Pawe, George, of Wynckley, yeoman 0
4318309 2136511 2136511 defendant Sowden Roger clerk 649200 649200 Sowden, Roger, of Wynckley, clerk 2
4380789 2158243 2158243 defendant Sowdon Roger clerk 649200 649200 Sowdon, Roger, of Wynckley, clerk 0
4412152 2168658 2168658 defendant Kyngforde John yeoman 649200 649200 Kyngforde, John, of Wynckley, yeoman 1
4412153 2168658 2168658 defendant Rattenbury Richard yeoman 649200 649200 Rattenbury, Richard, of Wynckley, yeoman 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);