names

46 rows where place_id = 627296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3775416 1950056 1950056 defendant Gervys Stephen yeoman 627296 627296 Gervys, Stephen, of Normanby, yeoman 0
3836811 1969414 1969414 defendant Jernes Thomas yeoman 627296 627296 Jernes, Thomas, of Normanby, yeoman 0
4042389 2039758 2039758 defendant Fotherby Francis esq 627296 627296 Fotherby, Francis, of Normanby, esq 1
4145642 2076629 2076629 defendant Clarke Robert husbandman 627296 627296 Clarke, Robert, of Normanby, husbandman 0
4280228 2122990 2122990 defendant Darnell Humphrey gent 627296 627296 Darnell, Humphrey, of Normanby, gent 1
4282045 2123621 2123621 defendant Darnell Humphrey gent 627296 627296 Darnell, Humphrey, of Normanby, gent 0
4300768 2130371 2130371 defendant Hewett William yeoman 627296 627296 Hewett, William, of Normanby, yeoman 0
4322771 2138033 2138033 defendant Conyers George gent 627296 627296 Conyers, George, of Normanby, gent 0
4337168 2142727 2142727 defendant Sheffeild John gent 627296 627296 Sheffeild, John, of Normanby, gent 0
4337169 2142727 2142727 defendant Mallett Roger gent 627296 627296 Mallett, Roger, of Normanby, gent 1
4417922 2170483 2170483 plaintiff Tebbe Henry   627296 627296 Tebbe, Henry, of Normanby 0
4430538 2174318 2174318 defendant Carleton John de   627296 627296 Carleton, John de, of Normanby 1
4430539 2174318 2174318 defendant Cornay John   627296 627296 Cornay, John, of Normanby 2
4430540 2174318 2174318 defendant Toncotes Richard de   627296 627296 Toncotes, Richard de, of Normanby 3
4456578 2187080 2187080 defendant Sergeant William   627296 627296 Sergeant, William, of Normanby 0
4470301 2191359 2191359 defendant Personnene Robert   627296 627296 Personnene, Robert, of Normanby 2
4476848 2193420 2193420 defendant Cornay William   627296 627296 Cornay, William, of Normanby 1
4487065 2196676 2196676 defendant Wath John   627296 627296 Wath, John, of Normanby, vicar 4
4513751 2204728 2204728 defendant Michell John   627296 627296 Michell, John, of Normanby 2
4534738 2211145 2211145 plaintiff Seman William   627296 627296 Seman, William, of Normanby, parson 0
4632903 2241163 2241163 defendant Patfyn William   627296 627296 Patfyn, William, of Normanby 0
4643706 2244259 2244259 defendant Mason John   627296 627296 Mason, John, of Normanby 1
4657990 2248381 2248381 defendant Corner John husbandman 627296 627296 Corner, John, of Normanby, husbandman 1
4657991 2248381 2248381 defendant Lenyngton or Levyngton William husbandman 627296 627296 Lenyngton or Levyngton, William, of Normanby, husbandman 2
4657992 2248381 2248381 defendant Whelewright Robert husbandman 627296 627296 Whelewright, Robert, of Normanby, husbandman 3
4673569 2257365 2257365 plaintiff Foderby John   627296 627296 Foderby, John, of Normanby 3
4686067 2261231 2261231 defendant Edwarde John yeoman 627296 627296 Edwarde, John, of Normanby, yeoman 0
4693919 2263602 2263602 defendant Andrewe Richard husbandman 627296 627296 Andrewe, Richard, of Normanby, husbandman 1
4745656 2279242 2279242 defendant Perot Peter yeoman 627296 627296 Perot, Peter, of Normanby, yeoman 2
4745657 2279242 2279242 defendant Doweber John laborer 627296 627296 Doweber, John, of Normanby, laborer 3
4764261 2284815 2284815 defendant Perkynson John   627296 627296 Perkynson, John, of Normanby, "pynder" 0
4792749 2293819 2293819 defendant Loweson Thomas husbandman 627296 627296 Loweson, Thomas, of Normanby, husbandman 0
4858693 2314092 2314092 defendant Pernell William laborer 627296 627296 Pernell, William, of Normanby, laborer 4
4972513 2348710 2348710 defendant Colby John husbandman 627296 627296 Colby, John, of Normanby, husbandman 1
4994265 2355160 2355160 plaintiff Foterby John   627296 627296 (Foterby, John, of Normanby 1
5025804 2364446 2364446 defendant Morele John   627296 627296 Morele, John, of Normanby, mason 1
5025805 2364446 2364446 defendant Hopkynson Richard husbandman 627296 627296 Hopkynson, Richard, of Normanby, husbandman 2
5026241 2364566 2364566 defendant Mason Robert   627296 627296 Mason, Robert, of Normanby, mason 0
5026242 2364566 2364566 defendant Brancroft Lawrence   627296 627296 Brancroft, Lawrence, of Normanby, mason 1
5026243 2364566 2364566 defendant Clerke Robert laborer 627296 627296 Clerke, Robert, of Normanby, laborer 2
5095724 2385170 2385170 defendant Coulby John husbandman 627296 627296 Coulby, John, of Normanby, husbandman 0
5096206 2385329 2385329 defendant Perrot John yeoman 627296 627296 Perrot, John, of Normanby, yeoman 1
5096220 2385332 2385332 defendant Mylns John husbandman 627296 627296 Mylns, John, of Normanby, husbandman 2
5475030 2497515 2497515 defendant Balderston John yeoman 627296 627296 Balderston, John, of Normanby, yeoman 1
5525135 2512451 2512451 defendant Baldyng John yeoman 627296 627296 Baldyng, John, of Normanby, yeoman 0
5555683 2521657 2521657 defendant Waker William chaplain 627296 627296 Waker, William, of Normanby, chaplain 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);