names

26 rows where place_id = 673706

✎ 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
3709032 1929121 1929121 defendant Dykson Thomas husbandman 673706 673706 Dykson, Thomas, of Gosforth, Cumber, husbandman 2
4010986 2028707 2028707 defendant Moscrofte Richard husbandman 673706 673706 Moscrofte, Richard, of Gosforth, husbandman 0
4010988 2028708 2028708 defendant Nicolson Thomas husbandman 673706 673706 Nicolson, Thomas, of Gosforth, husbandman 0
4010989 2028708 2028708 defendant Mason Thomas husbandman 673706 673706 Mason, Thomas, of Gosforth, husbandman 1
4010990 2028708 2028708 defendant Nicolson William husbandman 673706 673706 Nicolson, William, of Gosforth, husbandman 2
4010991 2028708 2028708 defendant Dixon John husbandman 673706 673706 Dixon, John, of Gosforth, husbandman 3
4010993 2028709 2028709 defendant Shepherd Mathew husbandman 673706 673706 Shepherd, Mathew, of Gosforth, husbandman 0
4010994 2028709 2028709 defendant Mostrope William husbandman 673706 673706 Mostrope, William, of Gosforth, husbandman 1
4010995 2028709 2028709 defendant Nicolson John husbandman 673706 673706 Nicolson, John, of Gosforth, husbandman 2
4039313 2038689 2038689 defendant Errington William yeoman 673706 673706 Errington, William, of Gosforth, yeoman, Steell, Christopher, of Gosforth, yeoman 3
4039314 2038689 2038689 defendant Mall Robert yeoman 673706 673706 Mall, Robert, of Gosforth, yeoman 4
4039315 2038689 2038689 defendant Myller John yeoman 673706 673706 Myller, John, of Gosforth, yeoman 5
4039316 2038689 2038689 defendant Meill Robert yeoman 673706 673706 Meill, Robert, of Gosforth, yeoman 6
4039321 2038690 2038690 defendant Errington William yeoman 673706 673706 Errington, William, of Gosforth, yeoman 3
4039322 2038690 2038690 defendant Steell Christopher yeoman 673706 673706 Steell, Christopher, of Gosforth, yeoman 4
4039323 2038690 2038690 defendant Mall Robert yeoman 673706 673706 Mall, Robert, of Gosforth, yeoman 5
4039324 2038690 2038690 defendant Myller John yeoman 673706 673706 Myller, John, of Gosforth, yeoman 6
4039325 2038690 2038690 defendant Meill Robert yeoman 673706 673706 Meill, Robert, of Gosforth, yeoman 7
4320295 2137201 2137201 defendant Birkebye George yeoman 673706 673706 Birkebye, George, of Gosforth, yeoman 0
4320296 2137201 2137201 defendant Bose Edmund yeoman 673706 673706 Bose, Edmund, of Gosforth, yeoman 1
4365644 2152772 2152772 defendant Dickson John (legal representative) 673706 673706 Dickson, John, of Gosforth, executor of 2
4365692 2152779 2152779 defendant Boradell Robert yeoman 673706 673706 Boradell, Robert, of Gosforth, yeoman 5
4395993 2163235 2163235 defendant Jackson Jenetta widow 673706 673706 Jackson, Jenetta, of Gosforth, widow 3
4407529 2167082 2167082 defendant Johnson John yeoman 673706 673706 Johnson, John, of Gosforth, yeoman 2
4877247 2319838 2319838 defendant Grage John mercer 673706 673706 Grage, John, of Gosforth, mercer 0
4969096 2347723 2347723 defendant Southeworth Ralph yeoman 673706 673706 Southeworth, Ralph, of Gosforth, yeoman 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);