names

11 rows where place_id = 611813

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690175 1923084 1923084 defendant Somer Ambrose husbandman 611813 611813 Somer, Ambrose, of Selborne, husbandman 2
3830772 1967507 1967507 defendant Sylvester Thomas tailor 611813 611813 Sylvester, Thomas, of Selborne, tailor 1
3830775 1967508 1967508 defendant Sylvester Thomas tailor 611813 611813 Sylvester, Thomas, of Selborne, tailor 1
4103581 2061564 2061564 defendant Sharpe Innocent yeoman 611813 611813 Sharpe, Innocent, of Selborne, yeoman 2
4371934 2155023 2155023 defendant Preston William husbandman 611813 611813 Preston, William, of Selborne, husbandman 0
4373285 2155514 2155514 defendant Preston William yeoman 611813 611813 Preston, William, of Selborne, yeoman 0
4592478 2228999 2228999 defendant Perkyn John, sen   611813 611813 Perkyn, John, sen, of Selborne 0
4957622 2344252 2344252 defendant Brasyer John plumber 611813 611813 Brasyer, John, of Selborne, plumber 1
5007755 2359161 2359161 plaintiff Stepe John   611813 611813 Stepe, John, of Selborne, prior 0
5528068 2513343 2513343 defendant Shirwode Thomas miller 611813 611813 Shirwode, Thomas, of Selborne, miller 0
5529082 2513612 2513612 defendant Lytelfeld John husbandman 611813 611813 Lytelfeld, John, of Selborne, husbandman 4

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