names

19 rows where place_id = 675256

✎ 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
4017774 2031067 2031067 defendant Rogers Thomas clothier 675256 675256 Rogers, Thomas, of Tickhill, clothier 1
4075309 2051472 2051472 defendant Burley William butcher 675256 675256 Burley, William, of Tickhill, butcher 1
4119280 2067188 2067188 defendant Holmes Thomas maltster 675256 675256 Holmes, Thomas, of Tickhill, yeoman, maltster 1
4160737 2081833 2081833 defendant Turwyn John yeoman 675256 675256 Turwyn, John, of Tickhill, yeoman 0
4217136 2101487 2101487 defendant Frenche George yeoman 675256 675256 Frenche, George, of Tickhill, yeoman 0
4217137 2101487 2101487 defendant Booth Nicholas gent 675256 675256 Booth, Nicholas, of Tickhill, gent 1
4266799 2118538 2118538 defendant Frenche George yeoman 675256 675256 Frenche, George, of Tickhill, yeoman 0
4266800 2118538 2118538 defendant Boothe Nicholas gent 675256 675256 Boothe, Nicholas, of Tickhill, gent 1
4292922 2127533 2127533 defendant Wooderoofe or Woodroose Robert gent 675256 675256 Wooderoofe or Woodroose, Robert, of Tickhill, gent 3
4313432 2134806 2134806 defendant Holmes George gent 675256 675256 Holmes, George, of Tickhill, gent 3
4314186 2135069 2135069 defendant Boothe Nicholas gent 675256 675256 Boothe, Nicholas, of Tickhill, gent 0
4314187 2135069 2135069 defendant French George gent 675256 675256 French, George, of Tickhill, gent 1
4315825 2135643 2135643 defendant Howson george tanner 675256 675256 Howson, george, of Tickhill, tanner 0
4318978 2136752 2136752 defendant Boothe Nicholas gent 675256 675256 Boothe, Nicholas, of Tickhill, gent 0
4318981 2136753 2136753 defendant Turvyn John gent 675256 675256 Turvyn, John, of Tickhill, gent 0
4323220 2138181 2138181 defendant Furnes Thomas gent 675256 675256 (Furnes, Thomas, of Tickhill, gent 1
4335473 2142137 2142137 defendant Fournes Thomas gent 675256 675256 Fournes, Thomas, of Tickhill, gent 0
4367095 2153287 2153287 defendant Holmes George yeoman 675256 675256 Holmes, George, of Tickhill, yeoman 1
4367115 2153294 2153294 defendant Byncliffe Charles tanner 675256 675256 Byncliffe, Charles, of Tickhill, tanner 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);