names

15 rows where place_id = 633048

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3810384 1961137 1961137 defendant Pulter Walter laborer 633048 633048 Pulter, Walter, of Alfolde, laborer 4
4363456 2152002 2152002 defendant Hurste Thomas yeoman 633048 633048 Hurste, Thomas, of Alfolde, yeoman 3
4382278 2158772 2158772 defendant Jackson Thomas yeoman 633048 633048 Jackson, Thomas, of Alfolde, yeoman 0
4413528 2169120 2169120 defendant Ekhurst Roger   633048 633048 Ekhurst, Roger, of Alfolde 0
4427134 2173310 2173310 defendant atte Leghe John   633048 633048 atte Leghe, John, of Alfolde 0
5276201 2438113 2438113 defendant Sterre John sawyer 633048 633048 Sterre, John, of Alfolde, sawyer 6
5276203 2438113 2438113 defendant Rokesby John sawyer 633048 633048 Rokesby, John, of Alfolde, sawyer 8
5276204 2438113 2438113 defendant Bleke William sawyer 633048 633048 Bleke, William, of Alfolde, sawyer 9
5276206 2438113 2438113 defendant Trego Walter sawyer 633048 633048 Trego, Walter, of Alfolde, sawyer 11
5276207 2438113 2438113 defendant Merston William sawyer 633048 633048 Merston, William, of Alfolde, sawyer 12
5276208 2438113 2438113 defendant Pope John tanner 633048 633048 Pope, John, of Alfolde, tanner 13
5276209 2438113 2438113 defendant Sherloke Henry tailor 633048 633048 Sherloke, Henry, of Alfolde, tailor 14
5276210 2438113 2438113 defendant Derby Alan husbandman 633048 633048 Derby, Alan, of Alfolde, husbandman 15
5276211 2438113 2438113 defendant Yonge John glasier 633048 633048 Yonge, John, of Alfolde, glasier 16
5276212 2438113 2438113 defendant Page William   633048 633048 Page, William, of Alfolde, lathe maker 17

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