names

28 rows where place_id = 592816

✎ 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
3609036 1870482 1870482 defendant Tranley alias Stanley Nicholas baker or yeoman 592816 592816 Tranley alias Stanley, Nicholas, of Stratford at Bowe, baker or yeoman 0
3638280 1906791 1906791 defendant Parker George brewer 592816 592816 Parker, George, of Stratford at Bowe, brewer 3
3646077 1909170 1909170 defendant Latymer Richard clerk 592816 592816 Latymer, Richard, of Stratford at Bowe, clerk 0
3657638 1912649 1912649 defendant Chapman Thomas butcher 592816 592816 Chapman, Thomas, of Stratford at Bowe, butcher 1
3667499 1915777 1915777 defendant Mason William baker 592816 592816 Mason, William, of Stratford at Bowe, baker 0
3667503 1915778 1915778 defendant Mason William baker 592816 592816 Mason, William, of Stratford at Bowe, baker 1
3679096 1919528 1919528 defendant Wylson John miller 592816 592816 Wylson, John, of Stratford at Bowe, miller 3
3679097 1919528 1919528 defendant Wellys John yeoman 592816 592816 Wellys, John, of Stratford at Bowe, yeoman 4
3696315 1925068 1925068 defendant Couper Thomas husbandman 592816 592816 Couper, Thomas, of Stratford at Bowe, husbandman 0
3727341 1934825 1934825 defendant Rose John carpenter 592816 592816 Rose, John, of Stratford at Bowe, carpenter 1
3727342 1934825 1934825 defendant Samme Robert baker 592816 592816 Samme, Robert, of Stratford at Bowe, baker 2
3727343 1934825 1934825 defendant Sparowe Stephen laborer 592816 592816 Sparowe, Stephen, of Stratford at Bowe, laborer 3
3793354 1955783 1955783 defendant Colynes William smith 592816 592816 Colynes, William, of Stratford at Bowe, smith 0
3800300 1958013 1958013 defendant Colyns William smith 592816 592816 Colyns, William, of Stratford at Bowe, smith 6
3812595 1961826 1961826 defendant Hame William   592816 592816 Hame, William, of Stratford at Bowe, mill wright 3
4126914 2069919 2069919 defendant Dove Thomas yeoman 592816 592816 Dove, Thomas, of Stratford at Bowe, yeoman 0
4293898 2127888 2127888 defendant Simons John innholder 592816 592816 Simons, John, of Stratford at Bowe, innholder 0
5270128 2436366 2436366 defendant Burgeys John baker 592816 592816 Burgeys, John, of Stratford at Bowe, baker 0
5365747 2464944 2464944 defendant Upham John miller 592816 592816 Upham, John, of Stratford at Bowe, miller 0
5398646 2474678 2474678 defendant Hooke John butcher 592816 592816 Hooke, John, of Stratford at Bowe, butcher 0
5411760 2478470 2478470 defendant Hooke John butcher 592816 592816 Hooke, John, of Stratford at Bowe, butcher 0
5425910 2482711 2482711 defendant Hooke John butcher 592816 592816 Hooke, John, of Stratford at bowe, butcher 0
5425912 2482712 2482712 defendant Hooke John butcher 592816 592816 Hooke, John, of Stratford at Bowe, butcher 0
5496327 2503805 2503805 plaintiff Hyndeley William miller 592816 592816 Hyndeley, William, of Stratford at Bowe, miller 0
5515556 2509707 2509707 defendant Bartilmewe Thomas cordwainer 592816 592816 Bartilmewe, Thomas, of Stratford at Bowe, cordwainer 1
5525655 2512616 2512616 defendant Pere William baker 592816 592816 Pere, William, of Stratford at Bowe, baker 0
5577474 2528013 2528013 defendant Sterman John baker 592816 592816 Sterman, John, of Stratford at Bowe, baker 1
5604297 2536207 2536207 defendant Bote Robert baker 592816 592816 Bote, Robert, of Stratford at Bowe, baker 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);