names

19 rows where place_id = 652530

✎ 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
3924290 1998433 1998433 defendant Byllynghay John yeoman 652530 652530 Byllynghay, John, of Hogham, yeoman 0
3924291 1998433 1998433 defendant Byllyngay William yeoman 652530 652530 Byllyngay, William, of Hogham, yeoman 1
3924292 1998433 1998433 defendant Pulton William laborer 652530 652530 Pulton, William, of Hogham, laborer 2
3924293 1998433 1998433 defendant Pulton Edward tanner 652530 652530 Pulton, Edward, of Hogham, tanner 3
3924294 1998433 1998433 defendant Pulton Robert laborer 652530 652530 Pulton, Robert, of Hogham, laborer 4
3924295 1998433 1998433 defendant Howson John laborer 652530 652530 Howson, John, of Hogham, laborer 5
3924296 1998433 1998433 defendant Akam Alice spinster 652530 652530 Akam, Alice, of Hogham, spinster 6
4546182 2214752 2214752 defendant Hardy Richard   652530 652530 Hardy, Richard, of Hogham 0
4575546 2223859 2223859 defendant Sclater John clerk 652530 652530 Sclater, John, of Hogham, son of Richard, clerk 0
4716802 2270582 2270582 defendant Banbery John   652530 652530 Banbery, John, of Hogham, parson 0
4745193 2279100 2279100 defendant Bussy John   652530 652530 Bussy, John, of Hogham, knight 0
4780362 2289854 2289854 defendant Lorde Robert   652530 652530 Lorde, Robert, of Hogham, cartwright 0
4928967 2335486 2335486 defendant Elham Robert husbandman 652530 652530 Elham, Robert, of Hogham, husbandman 0
4928968 2335486 2335486 defendant Wylmyngton Henry husbandman 652530 652530 Wylmyngton, Henry, of Hogham, husbandman 1
5012141 2360398 2360398 defendant Proktour Robert husbandman 652530 652530 Proktour, Robert, of Hogham, husbandman 10
5017644 2362035 2362035 defendant Wylmyngton Henry husbandman 652530 652530 Wylmyngton, Henry, of Hogham, husbandman 0
5017645 2362035 2362035 defendant Wylmyngton Bartholomew husbandman 652530 652530 Wylmyngton, Bartholomew, of Hogham, husbandman 1
5238144 2426744 2426744 defendant Athekyrke Richard husbandman 652530 652530 Athekyrke, Richard, of Hogham, husbandman 1
5468401 2495490 2495490 defendant Bussy John esq 652530 652530 Bussy, John, of Hogham, esq 1

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