names

21 rows where place_id = 630719

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3796098 1956644 1956644 defendant Webbe Thomas husbandman 630719 630719 Webbe, Thomas, of Aysshewater, husbandman 0
3796101 1956645 1956645 defendant Webbe Thomas husbandman 630719 630719 Webbe, Thomas, of Aysshewater, husbandman 0
3836925 1969452 1969452 defendant Hardemede John husbandman 630719 630719 Hardemede, John, of Aysshewater, husbandman 0
3898520 1989717 1989717 defendant Bassett William husbandman 630719 630719 Bassett, William, of Aysshewater, husbandman 4
3946772 2005941 2005941 defendant Arscott Richard gent 630719 630719 Arscott, Richard, of Aysshewater, gent 0
4891054 2323943 2323943 defendant Jurdyn Roger husbandman 630719 630719 Jurdyn, Roger, of Aysshewater, husbandman 1
4949368 2341788 2341788 defendant Blakedon William yeoman 630719 630719 Blakedon, William, of Aysshewater, yeoman 1
4970910 2348243 2348243 defendant Jane Stephen yeoman 630719 630719 Jane, Stephen, of Aysshewater, yeoman 1
5017804 2362088 2362088 defendant Selegone or Selegove Joceus or Joce yeoman 630719 630719 Selegone or Selegove, Joceus or Joce, of Aysshewater, yeoman 0
5018688 2362353 2362353 defendant Perys John husbandman 630719 630719 Perys, John, of Aysshewater, husbandman 1
5052234 2372274 2372274 defendant Rogerman Richard husbandman 630719 630719 Rogerman, Richard, of Aysshewater, husbandman 0
5052235 2372274 2372274 defendant Rogerman John husbandman 630719 630719 Rogerman, John, of Aysshewater, husbandman 1
5052236 2372274 2372274 defendant Saunder Robert husbandman 630719 630719 Saunder, Robert, of Aysshewater, husbandman 2
5052237 2372274 2372274 defendant Reche Richard husbandman 630719 630719 Reche, Richard, of Aysshewater, husbandman 3
5052238 2372274 2372274 defendant Reche Robert husbandman 630719 630719 Reche, Robert, of Aysshewater, husbandman 4
5052239 2372274 2372274 defendant Aysshe Roger husbandman 630719 630719 Aysshe, Roger, of Aysshewater, husbandman 5
5053691 2372704 2372704 defendant Asshe Thomas husbandman 630719 630719 Asshe, Thomas, of Aysshewater, husbandman 1
5054988 2373054 2373054 defendant Rondell Thomas   630719 630719 Rondell, Thomas, of Aysshewater 3
5054993 2373055 2373055 defendant Rondell Thomas yeoman 630719 630719 Rondell, Thomas, of Aysshewater, yeoman 3
5076846 2379569 2379569 defendant Jane Stephen husbandman 630719 630719 Jane, Stephen, of Aysshewater, husbandman 0
5151000 2401432 2401432 defendant Jurden Edward husbandman 630719 630719 Jurden, Edward, of Aysshewater, husbandman 2

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