names

12 rows where place_id = 592806

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609000 1870471 1870471 defendant Bromfelde John husbandman 592806 592806 Bromfelde, John, of Hampstede, husbandman 3
3650572 1910546 1910546 defendant Howse Edmund husbandman 592806 592806 Howse, Edmund, of Hampstede, husbandman 1
3745453 1940483 1940483 plaintiff Bryghtwell Richard yeoman 592806 592806 Bryghtwell, Richard, of Hampstede, yeoman 0
4097779 2059537 2059537 defendant Dancaster John yeoman 592806 592806 Dancaster, John, of Hampstede, yeoman 0
4505529 2202263 2202263 defendant Kete John   592806 592806 Kete, John, of Hampstede, son of John 0
4714026 2269714 2269714 defendant Ferrour William clerk 592806 592806 Ferrour, William, of Hampstede, clerk 2
4923928 2333922 2333922 defendant Davy John husbandman 592806 592806 Davy, John, of Hampstede, husbandman 2
5322545 2451821 2451821 defendant Crokker John smith 592806 592806 Crokker, John, of Hampstede, smith 1
5378974 2469018 2469018 defendant Wanton John laborer 592806 592806 Wanton, John, of Hampstede, laborer 1
5523087 2512047 2512047 defendant Wysse John husbandman 592806 592806 Wysse, John, of Hampstede, husbandman 0
5523088 2512047 2512047 defendant Henwode Robert husbandman 592806 592806 Henwode, Robert, of Hampstede, husbandman 1
5625222 2551828 2551828 plaintiff Luyke Thomas   592806 592806 Luyke, Thomas, of Hampstede 0

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