names

23 rows where place_id = 594690

✎ 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
3617195 1873003 1873003 defendant Barlot John gent 594690 594690 Barlot, John, of Byllyngeshurst, gent 0
3617196 1873003 1873003 defendant Howeles Thomas   594690 594690 Howeles, Thomas, of Byllyngeshurst, wheelwright 1
3617197 1873003 1873003 defendant Penfold Richard yeoman 594690 594690 Penfold, Richard, of Byllyngeshurst, yeoman 2
3617198 1873003 1873003 defendant Gaston or Easton William laborer 594690 594690 Gaston or Easton, William, of Byllyngeshurst, laborer 3
3704692 1927754 1927754 defendant Grynfeld John yeoman 594690 594690 Grynfeld, John, of Byllyngeshurst, yeoman 2
3718694 1932126 1932126 defendant Grynfeld John yeoman 594690 594690 Grynfeld, John, of Byllyngeshurst, yeoman 2
3831222 1967653 1967653 defendant Grenefyld John husbandman 594690 594690 Grenefyld, John, of Byllyngeshurst, husbandman 0
3846089 1972335 1972335 defendant Grenfeld John husbandman 594690 594690 Grenfeld, John, of Byllyngeshurst, husbandman 1
3859455 1976651 1976651 defendant Norreys Nicholas sherman 594690 594690 Norreys, Nicholas, of Byllyngeshurst, sherman 0
3861754 1977396 1977396 defendant Lyttyll John husbandman 594690 594690 Lyttyll, John, of Byllyngeshurst, husbandman 0
3861755 1977396 1977396 defendant Hyll Richard husbandman 594690 594690 Hyll, Richard, of Byllyngeshurst, husbandman 1
3883535 1984765 1984765 defendant Grenefeld John yeoman 594690 594690 Grenefeld, John, of Byllyngeshurst, yeoman 0
3903399 1991361 1991361 defendant Tredcrofte Richard husbandman 594690 594690 Tredcrofte, Richard, of Byllyngeshurst, husbandman 1
3911567 1994186 1994186 defendant Garton William yeoman 594690 594690 Garton, William, of Byllyngeshurst, yeoman 0
4127792 2070228 2070228 defendant West Richard yeoman 594690 594690 West, Richard, of Byllyngeshurst, yeoman 1
4128117 2070348 2070348 defendant Wells Robert yeoman 594690 594690 Wells, Robert, of Byllyngeshurst, yeoman 1
4734523 2275964 2275964 defendant Segrave John husbandman 594690 594690 Segrave, John, of Byllyngeshurst, husbandman 0
4767685 2285872 2285872 defendant Segrave John   594690 594690 Segrave, John, of Byllyngeshurst, wool merchant 0
4836588 2307415 2307415 defendant Howleys Thomas husbandman 594690 594690 Howleys, Thomas, of Byllyngeshurst, husbandman 1
4840126 2308460 2308460 defendant Tayllour Richard (legal representative) 594690 594690 Tayllour, Richard, of Byllyngeshurst, executors of 0
4840127 2308460 2308460 defendant Docy Walter laborer 594690 594690 (Docy, Walter, of Byllyngeshurst, laborer 1
5495113 2503436 2503436 defendant Chamber Thomas (legal representative) 594690 594690 Chamber, Thomas, of Byllyngeshurst, yeoman, executors of 0
5512200 2508677 2508677 defendant Atte Lye Richard husbandman 594690 594690 Atte Lye, Richard, of Byllyngeshurst, 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);