names

16 rows where place_id = 765616

✎ 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
4518892 2206275 2206275 defendant Underwode Richard   765616 765616 Underwode, Richard, of Bynglay 0
4639681 2243122 2243122 defendant Watere John   765616 765616 Watere, John, of Bynglay 0
4781906 2290352 2290352 defendant Page William yeoman 765616 765616 Page, William, of Bynglay, yeoman 3
4852239 2312130 2312130 defendant Hemsay John   765616 765616 Hemsay, John, of Bynglay, school master 0
4887599 2322959 2322959 defendant Smyth John smith 765616 765616 Smyth, John, of Bynglay, smith 10
4887600 2322959 2322959 defendant Smyth Thomas yeoman 765616 765616 Smyth, Thomas, of Bynglay, yeoman 11
4887601 2322959 2322959 defendant Whithede Robert laborer 765616 765616 Whithede, Robert, of Bynglay, laborer 12
4887602 2322959 2322959 defendant Lynghous Robert laborer 765616 765616 Lynghous, Robert, of Bynglay, laborer 13
4995404 2355468 2355468 defendant Hunte John   765616 765616 Hunte, John, of Bynglay, vicar 0
5104449 2387728 2387728 defendant Wode John yeoman 765616 765616 Wode, John, of Bynglay, yeoman 1
5104452 2387728 2387728 defendant Wode Thomas yeoman 765616 765616 Wode, Thomas, of Bynglay, yeoman 4
5116725 2391324 2391324 defendant Hertlay John yeoman 765616 765616 Hertlay, John, of Bynglay, yeoman 3
5298685 2444590 2444590 defendant Burton Richard chapman 765616 765616 Burton, Richard, of Bynglay, chapman 0
5306576 2446956 2446956 defendant Smyth William yeoman 765616 765616 Smyth, William, of Bynglay, yeoman 4
5306577 2446956 2446956 defendant Milner Robert   765616 765616 Milner, Robert, of Bynglay 5
5306578 2446956 2446956 defendant Ferrour William yeoman 765616 765616 Ferrour, William, of Bynglay, yeoman 6

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