names

19 rows where place_id = 636199

✎ 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
3829547 1967131 1967131 defendant Alsope Thomas husbandman 636199 636199 Alsope, Thomas, of Swythland, husbandman 0
3863966 1978127 1978127 defendant Dawkyn Stephen yeoman 636199 636199 Dawkyn, Stephen, of Swythland, yeoman 0
4370502 2154500 2154500 defendant Eckersall Margaret widow 636199 636199 Eckersall, Margaret, of Swythland, widow 0
4724149 2272847 2272847 defendant Spenlove William husbandman 636199 636199 Spenlove, William, of Swythland, husbandman 0
5083094 2381452 2381452 defendant Davers or Daners John esq 636199 636199 Davers or Daners, John, of Swythland, esq 0
5139240 2397967 2397967 defendant O' the Iles John (legal representative) 636199 636199 O' the Iles, John, of Swythland, clerk, executor of 5
5139241 2397967 2397967 defendant O' the Iles William   636199 636199 O' the Iles, William, of Swythland 6
5160136 2404064 2404064 defendant Iles John o' the (legal representative) 636199 636199 Iles, John o' the, of Swythland, clerk, executor of 5
5160137 2404064 2404064 defendant Iles William o' the gent 636199 636199 Iles, William o' the, of Swythland, gent 6
5175032 2408391 2408391 defendant Iles John o' the (legal representative) 636199 636199 Iles, John o' the, of Swythland, clerk, executor of 5
5175033 2408391 2408391 defendant Iles William o' the gent 636199 636199 Iles, William o' the, of Swythland, gent 6
5285862 2440886 2440886 defendant Sharpuls Roger eoman 636199 636199 Sharpuls, Roger, of Swythland, eoman 10
5285863 2440886 2440886 defendant Asshton Robert yeoman 636199 636199 Asshton, Robert, of Swythland, yeoman 11
5285864 2440886 2440886 defendant Laurence John yeoman 636199 636199 Laurence, John, of Swythland, yeoman 12
5285865 2440886 2440886 defendant Awens John yeoman 636199 636199 Awens, John, of Swythland, yeoman 13
5285873 2440887 2440887 defendant Dammers or Daunvers John, junior gent 636199 636199 Dammers or Daunvers, John, junior, of Swythland, gent 2
5285874 2440887 2440887 defendant Dammers or Daunvers Reginald gent 636199 636199 Dammers or Daunvers, Reginald, of Swythland, gent 3
5291404 2442488 2442488 plaintiff Daners or Davers John, senior esq 636199 636199 Daners or Davers, John, senior, of Swythland, esq 1
5560056 2522899 2522899 defendant Broun Robert husbandman 636199 636199 Broun, Robert, of Swythland, husbandman 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);