names

18 rows where place_id = 596021

✎ 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
3622792 1874659 1874659 defendant Wynne Richard carpenter 596021 596021 Wynne, Richard, of Bardewell, carpenter 0
3643562 1908418 1908418 defendant Fuller Robert weaver 596021 596021 Fuller, Robert, of Bardewell, weaver 0
3648791 1910013 1910013 plaintiff Otley Henry (legal representative) 596021 596021 Otley, Henry, of Bardewell, administratrix of 0
3729948 1935620 1935620 defendant Bronde George gent 596021 596021 Bronde, George, of Bardewell, gent 2
3776943 1950532 1950532 defendant Perkyn John husbandman 596021 596021 Perkyn, John, of Bardewell, husbandman 0
3779056 1951174 1951174 plaintiff Draper Stephen gent 596021 596021 Draper, Stephen, of Bardewell, gent 0
3795184 1956361 1956361 defendant Sefferey William husbandman 596021 596021 Sefferey, William, of Bardewell, husbandman 0
4105735 2062339 2062339 defendant Muryell Stephen gent 596021 596021 Muryell, Stephen, of Bardewell, gent 0
4343300 2144931 2144931 defendant Muryell Stephen (legal representative) 596021 596021 Muryell, Stephen, of Bardewell, gent, administratrix of 0
4343455 2144987 2144987 defendant Muriell Stephen (legal representative) 596021 596021 Muriell, Stephen, of Bardewell, gent, administratrix of 0
4343456 2144987 2144987 defendant Muryell Anne widow 596021 596021 Muryell, Anne, of Bardewell, widow 1
5095230 2385022 2385022 defendant Herward John yeoman 596021 596021 Herward, John, of Bardewell, yeoman 1
5095234 2385023 2385023 defendant Herward John yeoman 596021 596021 Herward, John, of Bardewell, yeoman 1
5257893 2432592 2432592 defendant Geddyng John esq 596021 596021 Geddyng, John, of Bardewell, esq 0
5260181 2433311 2433311 defendant Gate John yeoman 596021 596021 Gate, John, of Bardewell, yeoman 0
5263873 2434458 2434458 defendant Barough John   596021 596021 Barough, John, of Bardewell 0
5549794 2519971 2519971 defendant Smyth Thomas husbandman 596021 596021 Smyth, Thomas, of Bardewell, husbandman 2
5594130 2533142 2533142 defendant Bace or Bate William husbandman 596021 596021 Bace or Bate, William, of Bardewell, husbandman 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);