names

21 rows where place_id = 600115

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639737 1907236 1907236 defendant Hill John husbandman 600115 600115 (Hill, John, of Hese, Middx, husbandman 2
3873156 1981238 1981238 defendant Hyll William, senior   600115 600115 Hyll, William, senior, of Hese, Middx 3
4656052 2247775 2247775 defendant Koc John carpenter 600115 600115 Koc, John, of Hese, Middx, carpenter 2
4886254 2322563 2322563 defendant Cokke John, junior carpenter 600115 600115 Cokke, John, junior, of Hese, Middx, carpenter 5
4891327 2324015 2324015 defendant Cokke John carpenter 600115 600115 Cokke, John, of Hese, Middx, carpenter 0
4904090 2327894 2327894 defendant Cokke John, junior carpenter 600115 600115 Cokke, John, junior, of Hese, Middx, carpenter 5
4950573 2342142 2342142 defendant Smyth Ralph husbandman 600115 600115 Smyth, Ralph, of Hese, Middx, husbandman, son of Smyth, Stephen, of Hese, husbandman 0
4950578 2342143 2342143 defendant Smyth Ralph husbandman 600115 600115 Smyth, Ralph, of Hese, Middx, husbandman, son of Smyth, Stephen, of Hese, husbandman 0
5014832 2361214 2361214 defendant Wodegate Nicholas husbandman 600115 600115 (Wodegate, Nicholas, of Hese, Middx, husbandman 1
5155035 2402627 2402627 defendant Yonge Thomas husbandman 600115 600115 Yonge, Thomas, of Hese, Middx, husbandman 1
5190579 2412990 2412990 defendant Yonge Thomas husbandman 600115 600115 Yonge, Thomas, of Hese, Middx, husbandman 1
5271824 2436856 2436856 defendant Harre William husbandman 600115 600115 Harre, William, of Hese, Middx, husbandman 1
5286225 2440982 2440982 defendant Harre William husbandman 600115 600115 Harre, William, of Hese, Middx, husbandman 2
5286230 2440983 2440983 defendant Harre William husbandman 600115 600115 Harre, William, of Hese, Middx, husbandman 2
5302644 2445766 2445766 defendant Hyde William yeoman 600115 600115 Hyde, William, of Hese, Middx, yeoman 0
5335155 2455583 2455583 defendant Hylle John   600115 600115 Hylle, John, of Hese, Middx, husbandman, son of Hylle, William, of Hese 0
5335158 2455584 2455584 defendant Hylle William husbandman 600115 600115 Hylle, William, of Hese, Middx, husbandman 0
5335164 2455586 2455586 defendant Hylle William husbandman 600115 600115 Hylle, William, of Hese, Middx, husbandman 0
5404027 2476228 2476228 defendant Croweford William   600115 600115 Croweford, William, of Hese, Middx, holy water clerk 2
5417206 2480057 2480057 defendant Croweford William   600115 600115 Croweford, William, of Hese, Middx, holy water clerk 2
5627901 2552697 2552697 defendant Colverhous Thomas husbandman 600115 600115 Colverhous, Thomas, of Hese, Middx, 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);