names

24 rows where place_id = 590651

✎ 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
3601890 1868246 1868246 defendant Pastowe John husbandman 590651 590651 Pastowe, John, of St Dey, husbandman 1
3638662 1906905 1906905 defendant Franke Michael husbandman 590651 590651 Franke, Michael, of St Dey, husbandman 0
3638663 1906905 1906905 defendant Marche William husbandman 590651 590651 Marche, William, of St Dey, husbandman 1
3638664 1906905 1906905 defendant Hoper Lawrence husbandman 590651 590651 Hoper, Lawrence, of St Dey, husbandman 2
3639647 1907209 1907209 defendant Franke Michael husbandman 590651 590651 Franke, Michael, of St Dey, husbandman 0
3652112 1911008 1911008 defendant Engoef William smith 590651 590651 Engoef , William, of St Dey, smith 5
3652113 1911008 1911008 defendant Deynshire John yeoman 590651 590651 Deynshire, John, of St Dey, yeoman 6
3652116 1911009 1911009 defendant Vathy William yeoman 590651 590651 Vathy, William, of St Dey, yeoman 0
3686132 1921822 1921822 defendant Michell Martin yeoman 590651 590651 Michell, Martin, of St Dey, yeoman 3
3701232 1926629 1926629 defendant Michell Martin yeoman 590651 590651 Michell, Martin, of St Dey, yeoman 3
3892509 1987741 1987741 defendant William Nicholas Thomas husbandman 590651 590651 William, Nicholas Thomas, of St Dey, husbandman 1
4656194 2247824 2247824 defendant Joon Alice spinster 590651 590651 Joon, Alice, of St Dey, spinster 0
4715683 2270233 2270233 defendant Treng William   590651 590651 Treng, William, of St Dey, bailiff 1
4769845 2286544 2286544 defendant Jakenryn Robert smith 590651 590651 Jakenryn, Robert, of St Dey, smith 0
4860804 2314741 2314741 defendant Gampe Geoffrey   590651 590651 Gampe, Geoffrey, of St Dey, millward 1
4860808 2314742 2314742 defendant Gampe Geoffrey   590651 590651 Gampe, Geoffrey, of St Dey, millward 1
5063663 2375664 2375664 defendant Burgh Roger gent 590651 590651 Burgh, Roger, of St Dey, gent 1
5063664 2375664 2375664 defendant Maryn Thomas husbandman 590651 590651 Maryn, Thomas, of St Dey, husbandman 2
5063665 2375664 2375664 defendant Joce Alan husbandman 590651 590651 Joce, Alan, of St Dey, husbandman 3
5063666 2375664 2375664 defendant Polglas John shoemaker 590651 590651 Polglas, John, of St Dey, shoemaker 4
5063667 2375664 2375664 defendant Frank John husbandman 590651 590651 Frank, John, of St Dey, husbandman 5
5063668 2375664 2375664 defendant Nicoll John husbandman 590651 590651 Nicoll, John, of St Dey, husbandman 6
5599188 2534625 2534625 defendant Hockyn William husbandman 590651 590651 Hockyn, William, of St Dey, husbandman 0
5607004 2537084 2537084 defendant Hockyn William husbandman 590651 590651 Hockyn, William, of St Dey, husbandman 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);