names

32 rows where place_id = 601108

✎ 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
3643885 1908518 1908518 defendant Pulter William gent 601108 601108 Pulter, William, of Hechyn, gent 0
3643886 1908518 1908518 defendant Stanley John laborer 601108 601108 Stanley, John, of Hechyn, laborer 1
3643887 1908518 1908518 defendant Dawes William dyer 601108 601108 Dawes, William, of Hechyn, dyer 2
3643888 1908518 1908518 defendant Davy Thomas laborer 601108 601108 Davy, Thomas, of Hechyn, laborer 3
3662611 1914225 1914225 defendant Crosseby John butcher 601108 601108 Crosseby, John, of Hechyn, butcher 0
3670640 1916781 1916781 defendant Bell Thomas carpenter 601108 601108 Bell, Thomas, of Hechyn, carpenter 1
3670641 1916781 1916781 defendant Denys William dyer 601108 601108 Denys, William, of Hechyn, dyer 2
3670642 1916781 1916781 defendant Bretyn William   601108 601108 Bretyn, William, of Hechyn, tile maker 3
3670643 1916781 1916781 defendant Alde Joan widow 601108 601108 Alde, Joan, of Hechyn, widow 4
3736357 1937614 1937614 defendant Thurgood John yeoman 601108 601108 Thurgood, John, of Hechyn, yeoman 0
3827070 1966325 1966325 defendant Thurgood John yeoman 601108 601108 Thurgood, John, of Hechyn, yeoman 0
3828280 1966718 1966718 defendant Smyth William butcher 601108 601108 Smyth, William, of Hechyn, butcher 0
3872873 1981143 1981143 defendant Smythe William butcher 601108 601108 Smythe, William, of Hechyn, butcher 0
3879836 1983514 1983514 defendant Aylworth John husbandman 601108 601108 Aylworth, John, of Hechyn, husbandman 0
3879838 1983515 1983515 defendant Aylworth John husbandman 601108 601108 Aylworth, John, of Hechyn, husbandman 0
3892074 1987601 1987601 defendant Ponde John husbandman 601108 601108 Ponde, John, of Hechyn, husbandman 1
3921933 1997680 1997680 defendant Malett Henry clerk 601108 601108 Malett, Henry, of Hechyn, clerk 2
4765456 2285183 2285183 defendant Taillour Richard yeoman 601108 601108 Taillour, Richard, of Hechyn, yeoman 0
4845572 2310125 2310125 defendant Bays John butcher 601108 601108 Bays, John, of Hechyn, butcher 0
4891537 2324089 2324089 defendant Lynchelade John butcher 601108 601108 Lynchelade, John, of Hechyn, butcher 0
4974520 2349342 2349342 defendant Todgos William gent 601108 601108 Todgos, William, of Hechyn, gent 1
4983953 2352130 2352130 plaintiff Pulter John merchant 601108 601108 Pulter, John, of Hechyn, merchant 1
4983956 2352131 2352131 plaintiff Pulter John merchant 601108 601108 Pulter, John, of Hechyn, merchant 1
5075484 2379162 2379162 defendant Skot William pulter 601108 601108 Skot, William, of Hechyn, pulter 0
5509824 2507909 2507909 defendant Carby Henry husbandman 601108 601108 Carby, Henry, of Hechyn, husbandman 0
5548358 2519552 2519552 defendant Parys Thomas yeoman 601108 601108 Parys, Thomas, of Hechyn, yeoman 2
5550236 2520102 2520102 defendant Glove John husbandman 601108 601108 Glove, John, of Hechyn, husbandman 1
5559181 2522648 2522648 defendant Parysse Thomas yeoman 601108 601108 Parysse, Thomas, of Hechyn, yeoman 2
5563373 2523885 2523885 defendant Tristeram Lawrence husbandman 601108 601108 Tristeram, Lawrence, of Hechyn, husbandman 2
5575081 2527293 2527293 plaintiff Skypwyth William esq 601108 601108 Skypwyth, William, of Hechyn, esq 0
5579498 2528669 2528669 defendant Rowe Thomas skinner 601108 601108 Rowe, Thomas, of Hechyn, skinner 0
5588339 2531355 2531355 plaintiff Parys Thomas   601108 601108 Parys, Thomas, of Hechyn 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);