names

25 rows where place_id = 602114

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648465 1909919 1909919 defendant Brymsford John yeoman 602114 602114 Brymsford, John, of Alveley, Salop, yeoman 1
3691858 1923614 1923614 defendant Blyke Giles gent 602114 602114 Blyke, Giles, of Alveley, Salop, gent 0
3782125 1952162 1952162 defendant Lowley David yeoman 602114 602114 Lowley, David, of Alveley, Salop, yeoman 0
3797618 1957152 1957152 defendant Everdon Nicholas gent 602114 602114 Everdon, Nicholas, of Alveley, Salop, gent 0
3807360 1960207 1960207 defendant Blyke Giles gent 602114 602114 Blyke, Giles, of Alveley, Salop, gent 1
3892584 1987762 1987762 defendant Lee Humphrey gent 602114 602114 Lee, Humphrey, of Alveley, Salop, gent 0
3892586 1987763 1987763 defendant Lee Humphrey gent 602114 602114 Lee, Humphrey, of Alveley, Salop, gent 0
3951624 2007622 2007622 defendant Spyttull Hugh yeoman 602114 602114 Spyttull, Hugh, of Alveley, Salop, yeoman 0
3975551 2016014 2016014 defendant Howell John yeoman 602114 602114 Howell, John, of Alveley, Salop, yeoman 0
3977770 2016794 2016794 defendant Elcocke Thomas yeoman 602114 602114 Elcocke, Thomas, of Alveley, Salop, yeoman 0
4020180 2031940 2031940 defendant Lawley Arthur yeoman 602114 602114 Lawley, Arthur, of Alveley, Salop, yeoman 0
4054852 2044128 2044128 plaintiff Batche Hugh   602114 602114 Batche, Hugh, of Alveley, Salop 0
4065502 2047952 2047952 defendant Blike George gent 602114 602114 Blike, George, of Alveley, Salop, gent 1
4156962 2080513 2080513 defendant Pennell Thomas yeoman 602114 602114 Pennell, Thomas, of Alveley, Salop, yeoman 1
4170590 2085212 2085212 defendant Longley George yeoman 602114 602114 Longley, George, of Alveley, Salop, yeoman 0
4171283 2085417 2085417 defendant Lee John gent 602114 602114 Lee, John, of Alveley, Salop, gent 3
4181657 2089071 2089071 defendant Bradeley John yeoman 602114 602114 Bradeley, John, of Alveley, Salop, yeoman 0
4181804 2089118 2089118 defendant Bradeley John yeoman 602114 602114 Bradeley, John, of Alveley, Salop, yeoman 0
4190019 2092011 2092011 defendant Reynold William yeoman 602114 602114 (Reynold, William, of Alveley, Salop, yeoman 1
4190022 2092012 2092012 defendant Reynold William yeoman 602114 602114 (Reynold, William, of Alveley, Salop, yeoman 1
4203196 2096666 2096666 defendant Lee Johm gent 602114 602114 Lee, Johm, of Alveley, Salop, gent 3
4233250 2107142 2107142 defendant Lawley Lancelot yeoman 602114 602114 Lawley, Lancelot, of Alveley, Salop, yeoman 0
4234185 2107490 2107490 defendant Arden James carpenter 602114 602114 Arden, James, of Alveley, Salop, carpenter 0
4241873 2110274 2110274 defendant Lawley Lancelot yeoman 602114 602114 Lawley, Lancelot, of Alveley, Salop, yeoman 0
5538693 2516583 2516583 defendant Brymseford John yeoman 602114 602114 Brymseford, John, of Alveley, Salop, yeoman 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);