names

31 rows where place_id = 603068

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652951 1911252 1911252 defendant Wall alias Capper John yeoman 603068 603068 Wall alias Capper, John, of Cheston, yeoman 0
3678361 1919287 1919287 defendant Mery Robert yeoman 603068 603068 Mery, Robert, of Cheston, yeoman 0
3689016 1922724 1922724 defendant Blesdell Thomas yeoman 603068 603068 Blesdell, Thomas, of Cheston, yeoman 1
3691147 1923393 1923393 defendant Hoye Leonard maltman 603068 603068 Hoye, Leonard, of Cheston, maltman 1
3733046 1936558 1936558 defendant Pocar Thomas bucther 603068 603068 Pocar, Thomas, of Cheston, bucther 0
3824518 1965539 1965539 defendant Brody Nicholas baker 603068 603068 Brody, Nicholas, of Cheston, baker 0
3824519 1965539 1965539 defendant Palmer William laborer 603068 603068 Palmer, William, of Cheston, laborer 1
3870917 1980521 1980521 defendant Bykford John husbandman 603068 603068 Bykford, John, of Cheston, husbandman 0
3905331 1992050 1992050 defendant Hunt William yeoman 603068 603068 Hunt, William, of Cheston, yeoman 0
3919908 1996992 1996992 defendant Fak Philip husbandman 603068 603068 Fak, Philip, of Cheston, husbandman 0
3972524 2014967 2014967 plaintiff Garner Richard yeoman 603068 603068 Garner, Richard, of Cheston, yeoman 0
3996725 2023591 2023591 defendant Meeke Lawrence butcher 603068 603068 Meeke, Lawrence, of Cheston, butcher 4
4232539 2106884 2106884 defendant Preston Josias yeoman 603068 603068 Preston, Josias, of Cheston, yeoman 0
4235781 2108085 2108085 defendant Hunt Nicholas yeoman 603068 603068 Hunt, Nicholas, of Cheston, yeoman 1
4240609 2109842 2109842 defendant Crispe John yeoman 603068 603068 Crispe, John, of Cheston, yeoman 0
4255704 2114883 2114883 defendant Hunt Nicholas yeoman 603068 603068 Hunt, Nicholas, of Cheston, yeoman 1
4330483 2140492 2140492 defendant Hardyn or Hardyng Christopher husbandman 603068 603068 Hardyn or Hardyng, Christopher, of Cheston, husbandman 0
4331959 2140983 2140983 defendant Robson George yeoman 603068 603068 Robson, George, of Cheston, yeoman 1
4750870 2280738 2280738 defendant Reynoll Richard butcher 603068 603068 Reynoll, Richard, of Cheston, butcher 0
5026477 2364626 2364626 defendant Raven John laborer 603068 603068 Raven, John, of Cheston, laborer 0
5028014 2365072 2365072 defendant Kesewyke John husbandman 603068 603068 Kesewyke, John, of Cheston, husbandman 3
5114244 2390557 2390557 defendant Strowdyour Henry laborer 603068 603068 Strowdyour, Henry, of Cheston, laborer 0
5114245 2390557 2390557 defendant Strowdyour Robert laborer 603068 603068 Strowdyour, Robert, of Cheston, laborer 1
5443889 2488090 2488090 defendant Bylloke (illegible) maltman 603068 603068 Bylloke, _, of Cheston, maltman 1
5479019 2498746 2498746 defendant Starkey William yeoman 603068 603068 Starkey, William, of Cheston, yeoman 0
5479021 2498747 2498747 defendant Sterkey William yeoman 603068 603068 Sterkey, William, of Cheston, yeoman 0
5506906 2507076 2507076 defendant Loveday John gent 603068 603068 Loveday, John, of Cheston, gent 2
5557051 2522019 2522019 defendant Burton John, senior husbandman 603068 603068 Burton, John, senior, of Cheston, husbandman 0
5557052 2522019 2522019 defendant Burton John, junior husbandman 603068 603068 Burton, John, junior, of Cheston, husbandman 1
5566999 2524940 2524940 defendant Walker John laborer 603068 603068 Walker, John, of Cheston, laborer 0
5600351 2534997 2534997 defendant Grene Thomas clerk 603068 603068 Grene, Thomas, of Cheston, clerk 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);