names

34 rows where place_id = 648202

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3900411 1990369 1990369 defendant Punder William husbandman 648202 648202 Punder, William, of Carleton Roode, husbandman 2
3984901 2019357 2019357 defendant Crampe John tailor 648202 648202 Crampe, John, of Carleton Roode, tailor 0
4053275 2043550 2043550 defendant Seman William yeoman 648202 648202 Seman, William, of Carleton Roode, or of Dyckleborowe, yeoman 0
4075927 2051693 2051693 defendant Inbye or Jubye Edward yeoman 648202 648202 Inbye or Jubye, Edward, of Carleton Roode, yeoman 2
4075928 2051693 2051693 defendant Harlyng Thomas yeoman 648202 648202 Harlyng, Thomas, of Carleton Roode, yeoman 3
4075931 2051694 2051694 defendant Page John husbandman 648202 648202 Page, John, of Carleton Roode, husbandman 1
4075932 2051694 2051694 defendant Page Richard husbandman 648202 648202 Page, Richard, of Carleton Roode, husbandman 2
4106669 2062676 2062676 defendant Bennett Henry gent 648202 648202 Bennett, Henry, of Carleton Roode, gent 1
4115095 2065687 2065687 defendant Pyle Stephen yeoman 648202 648202 Pyle, Stephen, of Carleton Roode, yeoman 1
4158311 2080976 2080976 defendant Partricke Nicholas, senior yeoman 648202 648202 Partricke, Nicholas, senior, of Carleton Roode, yeoman 1
4216314 2101199 2101199 defendant Machyn Thomas yeoman 648202 648202 Machyn, Thomas, of Carleton Roode, yeoman 0
4221686 2103076 2103076 defendant Page William yeoman 648202 648202 Page, William, of Carleton Roode, yeoman 1
4222309 2103293 2103293 defendant Sparrowe John yeoman 648202 648202 Sparrowe, John, of Carleton Roode, yeoman 1
4222652 2103414 2103414 defendant Nubye Richard husbandman 648202 648202 Nubye, Richard, of Carleton Roode, husbandman 0
4241498 2110138 2110138 defendant Kempe Thomas   648202 648202 together with Kempe, Thomas, of Carleton Roode, hoop maker 1
4284760 2124597 2124597 defendant Graye William   648202 648202 Graye, William, of Carleton Roode, mason 1
4338445 2143197 2143197 defendant Machyn Robert   648202 648202 Machyn, Robert, of Carleton Roode, wheelwright 0
4338446 2143197 2143197 defendant Paryshe Richard sawyer 648202 648202 Paryshe, Richard, of Carleton Roode, sawyer 1
4345998 2145858 2145858 defendant Bullitont Francis husbandman 648202 648202 Bullitont, Francis, of Carleton Roode, husbandman 3
4346001 2145859 2145859 defendant Bullitont John yeoman 648202 648202 Bullitont, John, of Carleton Roode, yeoman 1
4346002 2145859 2145859 defendant Crispe Thomas gent 648202 648202 Crispe, Thomas, of Carleton Roode, gent 2
4350717 2147503 2147503 defendant Machyn Robert   648202 648202 Machyn, Robert, of Carleton Roode, wheelwright 0
4350719 2147503 2147503 defendant Longe William   648202 648202 Longe, William, of Carleton Roode, wheelwright 2
4351310 2147708 2147708 defendant Sparrowe Thomas tailor 648202 648202 Sparrowe, Thomas, of Carleton Roode, tailor 2
4394458 2162743 2162743 defendant Bullytont John husbandman 648202 648202 Bullytont, John, of Carleton Roode, husbandman 1
4394459 2162743 2162743 defendant Bullytont Francis husbandman 648202 648202 Bullytont, Francis, of Carleton Roode, husbandman 2
4405804 2166507 2166507 defendant Bullytofte Ralph yeoman 648202 648202 Bullytofte, Ralph, of Carleton Roode, yeoman 3
4408720 2167511 2167511 defendant Machen Robert   648202 648202 Machen, Robert, of Carleton Roode, wheelwright 2
5084893 2381989 2381989 plaintiff Godfrey Walter   648202 648202 Godfrey, Walter, of Carleton Roode 0
5084894 2381989 2381989 defendant Smyth Robert   648202 648202 Smyth, Robert, of Carleton Roode: Randolf, Richard, of Carleton Roode 0
5291005 2442370 2442370 defendant Pyle Richard husbandman 648202 648202 Pyle, Richard, of Carleton Roode, husbandman 3
5483549 2500027 2500027 defendant Joby John husbandman 648202 648202 Joby, John, of Carleton Roode, husbandman 0
5493778 2503045 2503045 defendant Joby John yeoman 648202 648202 Joby, John, of Carleton Roode, yeoman 0
5493779 2503045 2503045 defendant Joby William husbandman 648202 648202 Joby, William, of Carleton Roode, husbandman 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);