names

15 rows where place_id = 733299

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4303848 2131478 2131478 defendant Bentham William yeoman 733299 733299 Bentham, William, of Laighton Bussard, yeoman 0
4335266 2142066 2142066 defendant Ames Edward gent 733299 733299 Ames, Edward, of Laighton Bussard, gent 2
4335451 2142128 2142128 defendant Colsworthe George   733299 733299 Colsworthe, George, of Laighton Bussard, parchment maker 0
4337137 2142715 2142715 defendant Birche James, junior draper 733299 733299 Birche, James, junior, of Laighton Bussard, draper 0
4352806 2148211 2148211 defendant Martyn Robert husbandman 733299 733299 Martyn, Robert, of Laighton Bussard, husbandman 0
4385762 2159929 2159929 defendant Baker John shoemaker 733299 733299 Baker, John, of Laighton Bussard, shoemaker 0
4385764 2159930 2159930 defendant Birche James, senior draper 733299 733299 Birche, James, senior, of Laighton Bussard, draper 0
4396761 2163485 2163485 defendant Bolsworth Edmund yeoman 733299 733299 Bolsworth, Edmund, of Laighton Bussard, yeoman 1
4407507 2167074 2167074 defendant Eliott Richard shoemaker 733299 733299 Eliott, Richard, of Laighton Bussard, shoemaker 0
4409093 2167646 2167646 defendant Bosard Robert miller 733299 733299 Bosard, Robert, of Laighton Bussard, miller 0
4409094 2167646 2167646 defendant Studd Robert husbandman 733299 733299 Studd, Robert, of Laighton Bussard, husbandman 1
4409095 2167646 2167646 defendant Twede Richard husbandman 733299 733299 Twede, Richard, of Laighton Bussard, husbandman 2
4409098 2167647 2167647 defendant Welles Francis yeoman 733299 733299 Welles, Francis, of Laighton Bussard, yeoman 0
4409099 2167647 2167647 defendant Andrewe John husbandman 733299 733299 Andrewe, John, of Laighton Bussard, husbandman 1
4409100 2167647 2167647 defendant Johnson Richard husbandman 733299 733299 Johnson, Richard, of Laighton Bussard, 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);