names

12 rows where place_id = 603688

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655410 1911952 1911952 defendant Chepyn John tailor 603688 603688 Chepyn, John, of East Hanyfeld, tailor 0
4986968 2353044 2353044 defendant Huntyngdon William farmer 603688 603688 Huntyngdon, William, of East Hanyfeld, farmer 0
4998183 2356325 2356325 defendant Smyth John husbandman 603688 603688 Smyth, John, of East Hanyfeld, husbandman 0
5041075 2368956 2368956 defendant Baron John yeoman 603688 603688 Baron, John, of East Hanyfeld, yeoman 4
5241549 2427728 2427728 defendant Croucheman Lawrence butcher 603688 603688 Croucheman, Lawrence, of Est Hanyfeld, butcher 1
5300035 2444974 2444974 defendant Chery John corser 603688 603688 Chery, John, of East Hanyfeld, corser 0
5300036 2444974 2444974 defendant Nobyll Thomas laborer 603688 603688 Nobyll, Thomas, of East Hanyfeld, laborer 1
5418772 2480539 2480539 defendant Geffrey Thomas yeoman 603688 603688 Geffrey, Thomas, of East Hanyfeld, yeoman 2
5436799 2485937 2485937 defendant Geffrey Thomas yeoman 603688 603688 Geffrey, Thomas, of East Hanyfeld, yeoman 2
5505081 2506498 2506498 defendant James John husbandman 603688 603688 James, John, of Est Hanyfeld, husbandman 2
5593150 2532843 2532843 defendant Boweman Richard yeoman 603688 603688 Boweman, Richard, of Est Hanyfeld, yeoman 0
5610137 2546879 2546879 defendant Smyth John   603688 603688 Smyth, John, of East Hanyfeld 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);