names

47 rows where place_id = 597018

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626964 1903289 1903289 defendant Plompton William esq 597018 597018 Plompton, William, of Plompton, esq 0
3626966 1903290 1903290 defendant Plompton William esq 597018 597018 Plompton, William, of Plompton, esq 0
3627987 1903607 1903607 defendant Knollis Ralph yeoman 597018 597018 Knollis, Ralph, of Plompton, yeoman 4
3647951 1909757 1909757 defendant Markewyke Richard husbandman 597018 597018 Markewyke, Richard, of Plompton, husbandman 0
3768638 1947839 1947839 defendant Trayton John carpenter 597018 597018 Trayton, John, of Plompton, carpenter 0
3768639 1947839 1947839 defendant Fawconer Thomas husbandman 597018 597018 Fawconer, Thomas, of Plompton, husbandman 1
3854659 1975102 1975102 defendant Pentecost John husbandman 597018 597018 Pentecost, John, of Plompton, husbandman 0
3866329 1978972 1978972 defendant Braythwayt William laborer 597018 597018 Braythwayt, William, of Plompton, laborer 0
3866331 1978973 1978973 defendant Braythwayt William laborer 597018 597018 Braythwayt, William, of Plompton, laborer 0
3866333 1978974 1978974 defendant Braythwayt William laborer 597018 597018 Braythwayt, William, of Plompton, laborer 0
3886547 1985751 1985751 defendant Sparke John mercer 597018 597018 Sparke, John, of Plompton, mercer 0
3920200 1997095 1997095 plaintiff Mascall John gent 597018 597018 Mascall, John, of Plompton, gent 0
3937340 2002824 2002824 defendant Plompton William (legal representative) 597018 597018 Plompton, William, of Plompton, esq, executor of 0
4363941 2152162 2152162 defendant Pycknoll Thomas husbandman 597018 597018 Pycknoll, Thomas, of Plompton, husbandman 0
4363942 2152162 2152162 defendant Newton John clerk 597018 597018 Newton, John, of Plompton, clerk 1
4368083 2153640 2153640 defendant Picknoll Thomas husbandman 597018 597018 Picknoll, Thomas, of Plompton, husbandman 0
4395475 2163070 2163070 defendant Smyth John yeoman 597018 597018 Smyth, John, of Plompton, yeoman 0
4647622 2245358 2245358 defendant Johnson Robert   597018 597018 Johnson, Robert, of Plompton 3
4702717 2266250 2266250 defendant atte Wode Richard laborer 597018 597018 atte Wode, Richard, of Plompton, laborer 4
4791854 2293556 2293556 defendant Wade John yeoman 597018 597018 Wade, John, of Plompton, yeoman 0
5059407 2374382 2374382 defendant Plompton William   597018 597018 Plompton, William, of Plompton, or of Knaresburgh, Yorks, knight 1
5059419 2374384 2374384 defendant Plompton William   597018 597018 Plompton, William, of Plompton, or of Knaresburgh, Yorks, knight 0
5230852 2424631 2424631 defendant Plompton William   597018 597018 Plompton, William, of Plompton, knight 0
5310011 2448024 2448024 defendant Plompton William   597018 597018 Plompton, William, of Plompton 0
5335585 2455716 2455716 plaintiff Gonne Thomas (legal representative) 597018 597018 Gonne, Thomas, of Plompton, executors of 0
5335586 2455716 2455716 plaintiff Ryall John husbandman 597018 597018 (Ryall, John, of Plompton, husbandman 1
5353605 2461199 2461199 defendant Plompton Godfrey esq 597018 597018 Plompton, Godfrey, of Plompton, esq 0
5388193 2471674 2471674 defendant Smyth Robert husbandman 597018 597018 Smyth, Robert, of Plompton, husbandman 0
5388194 2471674 2471674 defendant Smyth Richard husbandman 597018 597018 Smyth, Richard, of Plompton, husbandman 1
5388195 2471674 2471674 defendant Wode Bernard husbandman 597018 597018 Wode, Bernard, of Plompton, husbandman 2
5388196 2471674 2471674 defendant Benson William, senior husbandman 597018 597018 Benson, William, senior, of Plompton, husbandman 3
5388197 2471674 2471674 defendant Tayllour Robert husbandman 597018 597018 Tayllour, Robert, of Plompton, husbandman 4
5388198 2471674 2471674 defendant Hobsan William husbandman 597018 597018 Hobsan, William, of Plompton, husbandman 5
5388199 2471674 2471674 defendant Walbyngham Robert yeoman 597018 597018 Walbyngham, Robert, of Plompton, yeoman 6
5388200 2471674 2471674 defendant Wryght Robert   597018 597018 Wryght, Robert, of Plompton, plough wright 7
5486201 2500763 2500763 defendant Parker Robert husbandman 597018 597018 Parker, Robert, of Plompton, husbandman 0
5486202 2500763 2500763 defendant Smy- Richard husbandman 597018 597018 Smy-, Richard, of Plompton, husbandman 1
5486203 2500763 2500763 defendant Whityngham Henry husbandman 597018 597018 Whityngham, Henry, of Plompton, husbandman 2
5486204 2500763 2500763 defendant Benson Richard husbandman 597018 597018 Benson, Richard, of Plompton, husbandman 3
5486205 2500763 2500763 defendant Howchonson Richard husbandman 597018 597018 Howchonson, Richard, of Plompton, husbandman 4
5486206 2500763 2500763 defendant Wodde Barnard husbandman 597018 597018 Wodde, Barnard, of Plompton, husbandman 5
5486207 2500763 2500763 defendant Smyth Robert husbandman 597018 597018 Smyth, Robert, of Plompton, husbandman 6
5486208 2500763 2500763 defendant Judson John husbandman 597018 597018 Judson, John, of Plompton, husbandman 7
5486209 2500763 2500763 defendant Wynpeny Richard husbandman 597018 597018 Wynpeny, Richard, of Plompton, husbandman 8
5486210 2500763 2500763 defendant Parker Thomas husbandman 597018 597018 Parker, Thomas, of Plompton, husbandman 9
5486211 2500763 2500763 defendant Cotes Richard husbandman 597018 597018 Cotes, Richard, of Plompton, husbandman 10
5584250 2530141 2530141 defendant Plompton William esq 597018 597018 Plompton, William, of Plompton, esq 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);