names

51 rows where place_id = 586772

✎ 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
3589577 1864379 1864379 defendant Hubberd Roger husbandman 586772 586772 Hubberd, Roger, of Shalford, husbandman 0
3598895 1867281 1867281 defendant Motte John yeoman 586772 586772 Motte, John, of Shalford, yeoman 0
3606665 1869759 1869759 defendant Rochald Henry husbandman 586772 586772 Rochald, Henry, of Shalford, husbandman 0
3607385 1869972 1869972 defendant Nasshe John husbandman 586772 586772 Nasshe, John, of Shalford, husbandman 0
3683209 1920867 1920867 defendant Ungle Richard husbandman 586772 586772 Ungle, Richard, of Shalford, husbandman 0
3688174 1922451 1922451 defendant Bankys Richard husbandman 586772 586772 Bankys, Richard, of Shalford, husbandman 1
3817311 1963325 1963325 defendant Purcas Roger carpenter 586772 586772 Purcas, Roger, of Shalford, carpenter 0
3819932 1964115 1964115 defendant Purcas Roger carpenter 586772 586772 Purcas, Roger, of Shalford, carpenter 0
3906380 1992420 1992420 defendant Dodd John husbandman 586772 586772 Dodd, John, of Shalford, husbandman 0
4041472 2039440 2039440 defendant Bele Henry   586772 586772 Bele, Henry, of Shalford, yeoman, administrators of 0
4041473 2039440 2039440 defendant Callys Thomas yeoman 586772 586772 (Callys, Thomas, of Shalford, yeoman 1
4121045 2067815 2067815 defendant Algor William yeoman 586772 586772 Algor, William, of Shalford, yeoman 0
4201684 2096134 2096134 defendant Harman George tanner 586772 586772 Harman, George, of Shalford, tanner 0
4239247 2109350 2109350 defendant Bretten Richard butcher 586772 586772 Bretten, Richard, of Shalford, butcher 2
4277903 2122202 2122202 defendant Maly Thomas husbandman 586772 586772 Maly, Thomas, of Shalford, husbandman 1
4277978 2122227 2122227 defendant Buy Bartholomew gent 586772 586772 Buy, Bartholomew, of Shalford, gent 1
4282799 2123886 2123886 defendant Oliver Richard   586772 586772 Oliver, Richard, of Shalford, yeoman, ploughwright 0
4282981 2123951 2123951 defendant Bretten Richard butcher 586772 586772 Bretten, Richard, of Shalford, butcher 1
4303566 2131373 2131373 defendant Pawsolen John yeoman 586772 586772 Pawsolen, John, of Shalford, yeoman 1
4303567 2131373 2131373 defendant Olyvere Richard   586772 586772 Olyvere, Richard, of Shalford, ploughwright 2
4364810 2152467 2152467 defendant Muschampe William esq 586772 586772 Muschampe, William, of Shalford, esq 0
4389299 2161048 2161048 defendant Pasfeild John yeoman 586772 586772 Pasfeild, John, of Shalford, yeoman 0
4393087 2162297 2162297 defendant Baye Bartholomew gent 586772 586772 Baye, Bartholomew, of Shalford, gent 2
4398247 2163997 2163997 defendant Chennell Thomas yeoman 586772 586772 Chennell, Thomas, of Shalford, yeoman 0
4404374 2166032 2166032 defendant Cannon George husbandman 586772 586772 Cannon, George, of Shalford, husbandman 1
4651054 2246331 2246331 defendant Pertryche John   586772 586772 Pertryche, John, of Shalford, shepherd 0
4673339 2257300 2257300 plaintiff Crukern John   586772 586772 Crukern, John, of Shalford, vicar 0
4698389 2264975 2264975 defendant Wynchecombe John clerk 586772 586772 Wynchecombe, John, of Shalford, clerk 0
5092072 2384056 2384056 defendant Reynold John husbandman 586772 586772 Reynold, John, of Shalford, husbandman 1
5213921 2419803 2419803 plaintiff Brette John   586772 586772 Brette, John, of Shalford 0
5243663 2428340 2428340 defendant Bette Richard husbandman 586772 586772 Bette, Richard, of Shalford, husbandman 1
5262391 2433982 2433982 defendant Reynold John yeoman 586772 586772 Reynold, John, of Shalford, yeoman 2
5264409 2434624 2434624 plaintiff Brette John carpenter 586772 586772 Brette, John, of Shalford, carpenter 1
5312361 2448734 2448734 defendant Reynold John yeoman 586772 586772 Reynold, John, of Shalford, yeoman 0
5319809 2451017 2451017 defendant Grey John smith 586772 586772 Grey, John, of Shalford, smith 0
5328987 2453749 2453749 defendant Assh John husbandman 586772 586772 Assh, John, of Shalford, husbandman 0
5376043 2468100 2468100 defendant Spencer Thomas   586772 586772 Spencer, Thomas, of Shalford husbandman 1
5395185 2473695 2473695 defendant Reynold John yeoman 586772 586772 Reynold, John, of Shalford, yeoman 0
5491175 2502259 2502259 defendant Baker John husbandman 586772 586772 Baker, John, of Shalford, husbandman 1
5491176 2502259 2502259 defendant Asshe John husbandman 586772 586772 Asshe, John, of Shalford, husbandman 2
5491177 2502259 2502259 defendant Paunpeslond John husbandman 586772 586772 Paunpeslond, John, of Shalford, husbandman 3
5491178 2502259 2502259 defendant Hoberd Roger husbandman 586772 586772 Hoberd, Roger, of Shalford, husbandman 4
5514801 2509473 2509473 defendant Nassh John   586772 586772 Nassh, John, of Shalford, lime burner 0
5538456 2516510 2516510 defendant Gyfford Richard   586772 586772 Gyfford, Richard, of Shalford, tile maker 0
5538457 2516510 2516510 defendant Turner John shoemaker 586772 586772 Turner, John, of Shalford, shoemaker 1
5552387 2520749 2520749 defendant Felde Robert husbandman 586772 586772 Felde, Robert, of Shalford, husbandman 0
5558759 2522514 2522514 plaintiff Preston John   586772 586772 Preston, John, of Shalford 0
5564680 2524255 2524255 defendant Lamberd William carpenter 586772 586772 Lamberd, William, of Shalford, carpenter 1
5579558 2528685 2528685 defendant Ower Joan widow 586772 586772 Ower, Joan, of Shalford, widow 0
5590127 2531888 2531888 defendant Spencer Thomas yeoman 586772 586772 Spencer, Thomas, of Shalford, yeoman 3
5596117 2533700 2533700 defendant Smyth John husbandman 586772 586772 Smyth, John, of Shalford, 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);