names

19 rows where place_id = 702990

✎ 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
4145464 2076572 2076572 defendant Trovell or Trouell Robert gent 702990 702990 Trovell or Trouell, Robert, of Castle Morton, gent 0
4145465 2076572 2076572 defendant Stone Thomas husbandman 702990 702990 Stone, Thomas, of Castle Morton, husbandman 1
4149982 2078127 2078127 defendant Harvarde Edmund yeoman 702990 702990 Harvarde, Edmund, of Castle Morton, yeoman 1
4234977 2107784 2107784 defendant Coxe William yeoman 702990 702990 Coxe, William, of Castle Morton, yeoman 0
4241523 2110148 2110148 defendant Cockes William husbandman 702990 702990 Cockes, William, of Castle Morton, husbandman 0
4289842 2126429 2126429 defendant Coxe William husbandman 702990 702990 Coxe, William, of Castle Morton, husbandman 0
4289871 2126438 2126438 defendant Coxe William husbandman 702990 702990 Coxe, William, of Castle Morton, husbandman 0
4292160 2127266 2127266 defendant Wye John gent 702990 702990 Wye, John, of Castle Morton, gent 0
4299740 2129992 2129992 defendant Beale John yeoman 702990 702990 Beale, John, of Castle Morton, yeoman 1
4300752 2130365 2130365 defendant Coxe William yeoman 702990 702990 Coxe, William, of Castle Morton, yeoman 0
4300753 2130365 2130365 defendant Coxe John   702990 702990 Coxe, John, of Castle Morton, yeoman, his son 1
4325519 2138910 2138910 defendant Wrenford Roland gent 702990 702990 Wrenford, Roland, of Castle Morton, gent 2
4338523 2143226 2143226 defendant Morrie of Morrys John gent 702990 702990 Morrie of Morrys, John, of Castle Morton, gent 0
4382087 2158695 2158695 defendant Wye John gent 702990 702990 Wye, John, of Castle Morton, gent 0
4396461 2163391 2163391 defendant Ashley Robert yeoman 702990 702990 Ashley, Robert, of Castle Morton, yeoman 0
4398629 2164122 2164122 defendant Hullond Robert yeoman 702990 702990 Hullond, Robert, of Castle Morton, yeoman 1
4407985 2167237 2167237 defendant Hullins Robert shoemaker 702990 702990 Hullins, Robert, of Castle Morton, shoemaker 0
5585347 2530485 2530485 defendant Draper John husbandman 702990 702990 Draper, John, of Castle Morton, husbandman 0
5585348 2530485 2530485 defendant Gryffyn Thomas husbandman 702990 702990 Gryffyn, Thomas, of Castle Morton, husbandman 1

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