names

26 rows where place_id = 657882

✎ 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
3946151 2005731 2005731 defendant James John yeoman 657882 657882 James, John, of Herton, yeoman 0
3946152 2005731 2005731 defendant Griffin James husbandman 657882 657882 Griffin, James, of Herton, husbandman 1
4063755 2047321 2047321 defendant Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4065577 2047979 2047979 plaintiff Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4084339 2054669 2054669 defendant Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4095393 2058675 2058675 defendant Hebb William   657882 657882 Hebb, William, of Herton, yeoman, his son 1
4111248 2064272 2064272 defendant Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4111249 2064272 2064272 defendant Hobby John yeoman 657882 657882 Hobby, John, of Herton, yeoman 1
4113875 2065248 2065248 defendant Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4113878 2065249 2065249 defendant Hebbe Jenkin yeoman 657882 657882 Hebbe, Jenkin, of Herton, yeoman 0
4479710 2194315 2194315 defendant Russell William   657882 657882 Russell, William, of Herton 1
4761488 2283936 2283936 defendant Lille Richard husbandman 657882 657882 Lille, Richard, of Herton, husbandman 0
4761489 2283936 2283936 defendant Skepper John husbandman 657882 657882 Skepper, John, of Herton, husbandman 1
4761490 2283936 2283936 defendant Skepper Thomas husbandman 657882 657882 Skepper, Thomas, of Herton, husbandman 2
4887523 2322935 2322935 defendant Frere John   657882 657882 Frere, John, of Herton, bailiff 1
4944869 2340384 2340384 defendant Averey Walter husbandman 657882 657882 Averey, Walter, of Herton, husbandman 1
4987080 2353083 2353083 defendant Reydon Thomas tailor 657882 657882 Reydon, Thomas, of Herton, tailor 0
5076740 2379543 2379543 defendant Richard Thomas yeoman 657882 657882 Richard, Thomas, of Herton, yeoman 0
5198707 2415375 2415375 defendant Dragon William husbandman 657882 657882 Dragon, William, of Herton, husbandman 0
5211937 2419229 2419229 defendant Stanbury John (legal representative) 657882 657882 Stanbury, John, of Herton, clerk, executor of 0
5211940 2419230 2419230 defendant Stanbury John (legal representative) 657882 657882 Stanbury, John, of Herton, clerk, executor of 0
5260704 2433472 2433472 plaintiff Leyman John mercer 657882 657882 Leyman, John, of Herton, mercer 0
5368151 2465666 2465666 defendant Moreman John, senior tanner 657882 657882 Moreman, John, senior, of Herton, tanner 0
5548576 2519625 2519625 defendant Snowe John tanner 657882 657882 Snowe, John, of Herton, tanner 0
5568762 2525412 2525412 defendant Blanchard William, junior husbandman 657882 657882 Blanchard, William, junior, of Herton, husbandman 0
5630924 2553683 2553683 defendant Yne or Yve John yeoman 657882 657882 Yne or Yve, John, of Herton, yeoman 8

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);