names

11 rows where place_id = 644638

✎ 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
3880950 1983899 1983899 defendant Calton Robert yeoman or schoolmaster 644638 644638 Calton, Robert, of Rotheley, Leics, yeoman or schoolmaster 1
3976697 2016418 2016418 defendant Langley Ralph gent 644638 644638 Langley, Ralph, of Rotheley, Leics, gent 11
4799320 2295962 2295962 defendant Symond Thomas laborer 644638 644638 Symond, Thomas, of Rotheley, Leics, laborer 3
4803633 2297322 2297322 defendant Petypace Peter husbandman 644638 644638 Petypace, Peter, of Rotheley, Leics, husbandman 1
4814219 2300552 2300552 defendant Bygge Richard husbandman & son of Roger Bygge 644638 644638 Bygge, Richard, of Rotheley, Leics, husbandman & son of Roger Bygge 0
5161263 2404388 2404388 defendant Rove Simon husbandman 644638 644638 Rove, Simon, of Rotheley, Leics, husbandman 1
5175712 2408579 2408579 defendant Reve Simon husbandman 644638 644638 Reve, Simon, of Rotheley, Leics, husbandman 1
5175717 2408580 2408580 defendant Reve Simon husbandman 644638 644638 Reve, Simon, of Rotheley, Leics, husbandman 1
5197173 2414912 2414912 defendant Reve Simon husbandman 644638 644638 Reve, Simon, of Rotheley, Leics, husbandman 1
5280810 2439460 2439460 defendant Kyngeston Ralph esq 644638 644638 Kyngeston, Ralph, of Rotheley, Leics, esq 0
5488492 2501446 2501446 defendant Kyngston Ralph gent 644638 644638 Kyngston, Ralph, of Rotheley, Leics, gent 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);