names

24 rows where place_id = 617191

✎ 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
3718276 1932000 1932000 defendant Jones John husbandman 617191 617191 Jones, John, of Ombersley, husbandman 2
3765019 1946726 1946726 defendant Gardiner Philip weaver 617191 617191 Gardiner, Philip, of Ombersley, weaver 0
3780796 1951729 1951729 defendant Gardyner Richard husbandman 617191 617191 Gardyner, Richard, of Ombersley, husbandman 1
3797985 1957269 1957269 defendant Gardyner William husbandman 617191 617191 Gardyner, William, of Ombersley, husbandman 0
3848631 1973156 1973156 defendant Alye John tailor 617191 617191 Alye, John, of Ombersley, tailor 0
3848632 1973156 1973156 defendant Reynoldes Richard husbandman 617191 617191 Reynoldes, Richard, of Ombersley, husbandman 1
3848633 1973156 1973156 defendant Jonys Richard, junior husbandman 617191 617191 Jonys, Richard, junior, of Ombersley, husbandman 2
3848634 1973156 1973156 defendant Reynoldys John husbandman 617191 617191 Reynoldys, John, of Ombersley, husbandman 3
3868912 1979843 1979843 defendant Dally alias Dallahay Richard tailor 617191 617191 Dally alias Dallahay, Richard, of Ombersley, tailor 0
3868914 1979844 1979844 defendant Dally alias Dallehay Richard tailor 617191 617191 Dally alias Dallehay, Richard, of Ombersley, tailor 0
3956309 2009270 2009270 plaintiff Nasshe Thomas yeoman 617191 617191 Nasshe, Thomas, of Ombersley, yeoman 0
3961096 2010977 2010977 defendant Nasshe Thomas yeoman 617191 617191 Nasshe, Thomas, of Ombersley, yeoman 1
4073640 2050863 2050863 defendant Gandye or Gaudye George carrier 617191 617191 Gandye or Gaudye, George, of Ombersley, carrier 0
4073641 2050863 2050863 defendant Pardo Richard tailor 617191 617191 Pardo, Richard, of Ombersley, tailor 1
4089668 2056598 2056598 defendant Wall John husbandman 617191 617191 Wall, John, of Ombersley, husbandman 1
4158865 2081169 2081169 defendant Jones Robert husbandman 617191 617191 Jones, Robert, of Ombersley, husbandman 0
4377152 2156902 2156902 defendant Pardoe Lewis husbandman 617191 617191 Pardoe, Lewis, of Ombersley, husbandman 0
4395384 2163038 2163038 defendant Hemynge James yeoman 617191 617191 Hemynge, James, of Ombersley, yeoman 0
4395385 2163038 2163038 defendant Randell John husbandman 617191 617191 Randell, John, of Ombersley, husbandman 1
4669124 2256050 2256050 defendant Fox Thomas carpenter 617191 617191 Fox, Thomas, of Ombersley, carpenter 0
5117222 2391467 2391467 defendant Belcham John husbandman 617191 617191 Belcham, John, of Ombersley, husbandman 0
5223842 2422658 2422658 defendant Howele William husbandman 617191 617191 Howele, William, of Ombersley, husbandman 0
5527384 2513144 2513144 defendant Walker Richard husbandman 617191 617191 Walker, Richard, of Ombersley, husbandman 2
5540957 2517294 2517294 defendant Hemmyng John butcher 617191 617191 Hemmyng, John, of Ombersley, butcher 3

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