names

36 rows where place_id = 586031

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587740 1863811 1863811 defendant Cotton Thomas clerk 586031 586031 Cotton, Thomas, of Rykmansworth, Herts, clerk 2
3597730 1866910 1866910 defendant Bereman Thomas barber 586031 586031 Bereman, Thomas, of Rykmansworth, Herts, barber 1
3601105 1868009 1868009 defendant Danyell Alice widow 586031 586031 Danyell, Alice, of Rykmansworth, Herts, widow 2
3613249 1871797 1871797 defendant Danyell Richard gent 586031 586031 Danyell, Richard, of Rykmansworth, Herts, gent 6
3660515 1913550 1913550 defendant Knyght Richard yeoman 586031 586031 Knyght, Richard, of Rykmansworth, Herts, yeoman 0
3660520 1913551 1913551 defendant Knyght Richard yeoman 586031 586031 Knyght, Richard, of Rykmansworth, Herts, yeoman 0
3662959 1914326 1914326 defendant Creke John gent 586031 586031 Creke, John, of Rykmansworth, Herts, gent 5
3710629 1929646 1929646 defendant Creke William gent 586031 586031 Creke, William, of Rykmansworth, Herts, gent 2
3728184 1935076 1935076 defendant Bond Rose widow 586031 586031 Bond, Rose, of Rykmansworth, Herts, widow 1
3765304 1946812 1946812 defendant Myller William butcher 586031 586031 Myller, William, of Rykmansworth, Herts, butcher 1
3773361 1949381 1949381 defendant Grover Robert husbandman 586031 586031 Grover, Robert, of Rykmansworth, Herts, husbandman 1
3784425 1952911 1952911 plaintiff Marten David yeoman 586031 586031 Marten, David, of Rykmansworth, Herts, yeoman 0
3791494 1955178 1955178 defendant Creke William gent 586031 586031 Creke, William, of Rykmansworth, Herts, gent 0
3809515 1960859 1960859 plaintiff Belche George husbandman 586031 586031 Belche, George, of Rykmansworth, Herts, husbandman 0
3810619 1961218 1961218 defendant Creke William gent 586031 586031 Creke, William, of Rykmansworth, Herts, gent 0
3825856 1965936 1965936 defendant Gryce Gregory clerk 586031 586031 Gryce, Gregory, of Rykmansworth, Herts, clerk 1
3873595 1981391 1981391 defendant Dane William butcher 586031 586031 Dane, William, of Rykmansworth, Herts, butcher 0
3894778 1988459 1988459 defendant Evelyng Henry (legal representative) 586031 586031 Evelyng, Henry, of Rykmansworth, Herts, executor of 0
3953087 2008145 2008145 defendant Rolfe Richard laborer 586031 586031 Rolfe, Richard, of Rykmansworth, Herts, laborer 0
3955578 2009020 2009020 defendant Wyngborne Henry gent 586031 586031 Wyngborne, Henry, of Rykmansworth, Herts, gent 1
5096932 2385534 2385534 defendant War- Richard fuller 586031 586031 War-, Richard, of Rykmansworth, Herts, fuller 0
5096937 2385535 2385535 defendant Warde Richard fuller 586031 586031 Warde, Richard, of Rykmansworth, Herts, fuller 0
5117375 2391515 2391515 defendant Playtour Richard butcher 586031 586031 Playtour, Richard, of Rykmansworth, Herts, butcher 0
5134157 2396486 2396486 defendant Revell William husbandman 586031 586031 Revell, William, of Rykmansworth, Herts, husbandman 2
5221211 2421903 2421903 defendant Wymond Henry ostler 586031 586031 Wymond, Henry, of Rykmansworth, Herts, ostler 2
5252892 2431017 2431017 defendant Reve John husbandman 586031 586031 Reve, John, of Rykmansworth, Herts, husbandman 1
5305230 2446568 2446568 defendant Danyell George esq 586031 586031 Danyell, George, of Rykmansworth, Herts, esq 3
5329358 2453865 2453865 defendant Tayllour Hugh tailor 586031 586031 Tayllour, Hugh, of Rykmansworth, Herts, tailor 4
5497377 2504155 2504155 defendant Rouberd or Ronberd John yeoman 586031 586031 Rouberd or Ronberd, John, of Rykmansworth, Herts, yeoman 1
5540219 2517070 2517070 defendant Hatton William husbandman 586031 586031 Hatton, William, of Rykmansworth, Herts, husbandman 0
5540223 2517071 2517071 defendant Hatton William husbandman 586031 586031 Hatton, William, of Rykmansworth, Herts, husbandman 0
5568855 2525441 2525441 defendant Dyer Thomas chapman 586031 586031 Dyer, Thomas, of Rykmansworth, Herts, chapman 1
5569922 2525778 2525778 defendant Sevyn Thomas turner 586031 586031 Sevyn, Thomas, of Rykmansworth, Herts, turner 0
5572492 2526498 2526498 defendant Creke Thomas gent 586031 586031 Creke, Thomas, of Rykmansworth, Herts, gent 0
5572497 2526499 2526499 defendant Creke Thomas gent 586031 586031 Creke, Thomas, of Rykmansworth, Herts, gent 0
5605845 2536720 2536720 defendant Dyar Thomas yeoman 586031 586031 Dyar, Thomas, of Rykmansworth, Herts, 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);