names

26 rows where place_id = 692183

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3931526 2000844 2000844 defendant Harwell John yeoman 692183 692183 Harwell, John, of Cleobury Mortimer, yeoman 0
4093590 2058026 2058026 defendant Bache William cordwainer 692183 692183 Bache, William, of Cleobury Mortymer, cordwainer 0
4093718 2058078 2058078 defendant Dallowe Thomas yeoman 692183 692183 Dallowe, Thomas, of Cleobury Mortymer, yeoman 0
4099482 2060145 2060145 defendant Newall Edward painter 692183 692183 Newall, Edward, of Cleobury Mortymer, painter 0
4113602 2065145 2065145 defendant Bedow William cordwainer 692183 692183 Bedow, William, of Cleobury, cordwainer 0
4317305 2136166 2136166 defendant Uncle or Unckles Richard cooper 692183 692183 Uncle or Unckles, Richard, of Cleobury Mortimer, cooper 0
4330621 2140534 2140534 defendant Monday Thomas mercer 692183 692183 Monday, Thomas, of Cleobury Mortymer, mercer 1
4382578 2158881 2158881 defendant Pyper Richard husbandman 692183 692183 Pyper, Richard, of Cleobury Mortymer, husbandman 0
4382580 2158882 2158882 defendant Pyper Richard husbandman 692183 692183 Pyper, Richard, of Cleobury Mortimer, husbandman 0
4391266 2161696 2161696 defendant Marston William clerk 692183 692183 Marston, William, of Cleobury Mortymer, clerk 0
4391267 2161696 2161696 defendant Pyper Thomas husbandman 692183 692183 together with Pyper, Thomas, of Cleobury Mortymer, husbandman 1
4391268 2161696 2161696 defendant Pyper Edward husbandman 692183 692183 Pyper, Edward, of Cleobury Mortymer, husbandman 2
4491279 2197961 2197961 defendant Stevenes John   692183 692183 Stevenes, John, of Cleobury Mortimer 0
4578355 2224720 2224720 defendant Walkere Richard   692183 692183 Walkere, Richard, of Cleobury 0
4578356 2224720 2224720 defendant Tampet Robert   692183 692183 Tampet, Robert, of Cleobury 1
4578357 2224720 2224720 defendant Dodynton John smith 692183 692183 Dodynton, John, of Cleobury, smith 2
4886844 2322740 2322740 defendant Holyns John gent 692183 692183 Holyns, John, of Cleobury, gent 0
5171222 2407308 2407308 defendant Hevyn John gent 692183 692183 Hevyn, John, of Cleobury Mortimer, gent 0
5171223 2407308 2407308 defendant Hertford Thomas yeoman 692183 692183 Hertford, Thomas, of Cleobury Mortymer, yeoman 1
5250372 2430229 2430229 defendant Bridde Richard clerk 692183 692183 Bridde, Richard, of Cleobury Mortymer, clerk 3
5286345 2441008 2441008 defendant Bridde William yeoman 692183 692183 Bridde, William, of Cleobury Mortemer, yeoman 0
5286346 2441008 2441008 defendant Forster Edmund yeoman 692183 692183 Forster, Edmund, of Cleobury Mortemer, yeoman 1
5286347 2441008 2441008 defendant Hubald William cordwainer 692183 692183 Hubald, William, of Cleobury Mortymer, cordwainer 2
5286348 2441008 2441008 defendant Monselowe Roger laborer 692183 692183 Monselowe, Roger, of Cleobury Mortemer, laborer 3
5286349 2441008 2441008 defendant Robyns Thomas yeoman 692183 692183 Robyns, Thomas, of Cleobury Mortymer, yeoman 4
5331321 2454444 2454444 plaintiff Bryd William (legal representative) 692183 692183 Bryd, William, of Cleobury Mortymer, executors of 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);