names

12 rows where place_id = 640907

✎ 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
3858249 1976236 1976236 plaintiff Blounte Richard   640907 640907 Blounte, Richard, of Monkeland 1
3950567 2007274 2007274 defendant Hethe John yeoman 640907 640907 Hethe, John, of Monkeland, yeoman 16
3950585 2007275 2007275 defendant Hethe John yeoman 640907 640907 Hethe, John, of Monkeland, yeoman 16
5141712 2398688 2398688 defendant Gower Walter laborer 640907 640907 Gower, Walter, of Monkeland, laborer 2
5515125 2509578 2509578 defendant Nasshe Walter husbandman 640907 640907 Nasshe, Walter, of Monkeland, husbandman 0
5515126 2509578 2509578 defendant Seward Thomas husbandman 640907 640907 Seward, Thomas, of Monkeland, husbandman 1
5515128 2509578 2509578 defendant Strete John husbandman 640907 640907 Strete, John, of Monkeland, husbandman 3
5515133 2509579 2509579 defendant Walsheman Meredith husbandman 640907 640907 Walsheman, Meredith, of Monkeland, husbandman 2
5515139 2509580 2509580 defendant Smythe John husbandman 640907 640907 Smythe, John, of Monkeland, husbandman 3
5603044 2535837 2535837 defendant Churcheyarde William husbandman 640907 640907 Churcheyarde, William, of Monkeland, husbandman 0
5603835 2536068 2536068 defendant Syward Edmund husbandman 640907 640907 Syward, Edmund, of Monkeland, husbandman 0
5603836 2536068 2536068 defendant Gowarn Walter husbandman 640907 640907 Gowarn, Walter, of Monkeland, 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);