names

59 rows where place_id = 588463

✎ 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
3594580 1865936 1865936 defendant Bolton Edward gent 588463 588463 Bolton, Edward, of Bresyngham, gent 0
3613992 1872035 1872035 defendant Smethurst Thomas clerk 588463 588463 Smethurst, Thomas, of Bresyngham, clerk 0
3613993 1872035 1872035 defendant Toly Nicholas husbandman 588463 588463 Toly, Nicholas, of Bresyngham, husbandman 1
3613995 1872036 1872036 defendant Smethurst Thomas clerk 588463 588463 Smethurst, Thomas, of Bresyngham, clerk 0
3613996 1872036 1872036 defendant Toly Nicholas husbandman 588463 588463 Toly, Nicholas, of Bresyngham, husbandman 1
3620742 1874063 1874063 defendant Smythurst Thomas clerk 588463 588463 Smythurst, Thomas, of Bresyngham, clerk 0
3633811 1905387 1905387 defendant Bolton William gent 588463 588463 Bolton, William, of Bresyngham, gent 1
3647415 1909579 1909579 defendant Bolton William gent 588463 588463 Bolton, William, of Bresyngham, gent 0
3734198 1936937 1936937 defendant Symond John pinner 588463 588463 Symond, John, of Bresyngham, pinner 0
3747104 1941012 1941012 defendant Weston Geoffrey yeoman 588463 588463 Weston, Geoffrey, of Bresyngham, yeoman 0
3759414 1944933 1944933 defendant Symond Roger butcher 588463 588463 Symond, Roger, of Bresyngham, butcher 3
3760680 1945341 1945341 defendant Weston Geoffrey yeoman 588463 588463 Weston, Geoffrey, of Bresyngham, yeoman 0
3827204 1966373 1966373 defendant Gryce William laborer 588463 588463 Gryce, William, of Bresyngham, laborer 0
3841722 1970996 1970996 defendant Whayte John carpenter 588463 588463 Whayte, John, of Bresyngham, carpenter 0
3872474 1981019 1981019 defendant Middeles Henry, junior husbandman 588463 588463 Middeles, Henry, junior, of Bresyngham, husbandman 0
3872475 1981019 1981019 defendant Whayte John carpenter 588463 588463 Whayte, John, of Bresyngham, carpenter 1
3872476 1981019 1981019 defendant Erle John carpentrer 588463 588463 Erle, John, of Bresyngham, carpentrer 2
3892243 1987659 1987659 plaintiff Medyldyche Henry   588463 588463 Medyldyche, Henry, of Bresyngham 0
3899686 1990110 1990110 defendant Myllett John husbandman 588463 588463 Myllett, John, of Bresyngham, husbandman 0
3928097 1999736 1999736 defendant Kene John yeoman 588463 588463 Kene, John, of Bresyngham, yeoman 1
3931858 2000953 2000953 defendant Cowper Henry husbandman 588463 588463 Cowper, Henry, of Bresyngham, husbandman 0
3943559 2004865 2004865 defendant Howard Thomas yeoman 588463 588463 Howard, Thomas, of Bresyngham, yeoman 0
3952897 2008084 2008084 defendant Elyngham Richard cordwainer 588463 588463 Elyngham, Richard, of Bresyngham, cordwainer 2
3957626 2009728 2009728 defendant Trowth John yeoman 588463 588463 Trowth, John, of Bresyngham, yeoman 0
3959653 2010470 2010470 defendant Myddyldych Henry husbandman 588463 588463 Myddyldych, Henry, of Bresyngham, husbandman 2
3997893 2024005 2024005 defendant Howard Thomas (legal representative) 588463 588463 Howard, Thomas, of Bresyngham, yeoman, executors of 0
3997895 2024005 2024005 defendant Howard William yeoman 588463 588463 Howard, William, of Bresyngham, yeoman 2
4202452 2096399 2096399 defendant Folsier John yeoman 588463 588463 Folsier, John, of Bresyngham, yeoman 0
4274061 2120872 2120872 defendant Crosse Thomas schoolmaster 588463 588463 Crosse, Thomas, of Bresyngham, schoolmaster 2
4517850 2205968 2205968 defendant Tree John tanner 588463 588463 Tree, John, of Bresyngham, tanner 2
4546342 2214794 2214794 defendant Wo_ Robert de   588463 588463 Wo_, Robert de, of Bresyngham 0
4750121 2280508 2280508 defendant Skete Robert husbandman 588463 588463 Skete, Robert, of Bresyngham, husbandman 3
4750122 2280508 2280508 defendant Skete Roger husbandman 588463 588463 Skete, Roger, of Bresyngham, husbandman 4
4793237 2293980 2293980 defendant Sket Robert husbandman 588463 588463 Sket, Robert, of Bresyngham, husbandman 1
4888094 2323081 2323081 plaintiff Rokyngham Edmund   588463 588463 Rokyngham, Edmund, of Bresyngham 0
4977715 2350295 2350295 defendant Myddeldyche Henry husbandman 588463 588463 Myddeldyche, Henry, of Bresyngham, husbandman 0
4977718 2350296 2350296 defendant Rokyngham Edmund yeoman 588463 588463 Rokyngham, Edmund, of Bresyngham, yeoman 0
4986774 2352982 2352982 defendant Benyght John tiler 588463 588463 Benyght, John, of Bresyngham, tiler 1
5029031 2365361 2365361 defendant Medeldyk Henry husbandman 588463 588463 Medeldyk, Henry, of Bresyngham, husbandman 0
5076809 2379559 2379559 defendant Lancastre John esq 588463 588463 Lancastre, John, of Bresyngham, esq 0
5076810 2379559 2379559 defendant Frevyle William esq 588463 588463 Frevyle, William, of Bresyngham, esq 1
5088691 2383069 2383069 defendant Middeldyche Henry husbandman 588463 588463 Middeldyche, Henry, of Bresyngham, husbandman 0
5320898 2451339 2451339 plaintiff Lancastre John, senior (legal representative) 588463 588463 Lancastre, John, senior, of Bresyngham, esq, executors of 0
5320902 2451340 2451340 plaintiff Lancastre John, senior (legal representative) 588463 588463 Lancastre, John, senior, of Bresyngham, esq, executors of 0
5472043 2496597 2496597 plaintiff Lancaster William gent 588463 588463 Lancaster, William, of Bresyngham, gent 0
5472045 2496598 2496598 plaintiff Lancastre William gent 588463 588463 Lancastre, William, of Bresyngham, gent 0
5483470 2500002 2500002 plaintiff Lancastre William gent 588463 588463 Lancastre, William, of Bresyngham, gent 0
5483472 2500003 2500003 plaintiff Lancastre William gent 588463 588463 Lancastre, William, of Bresyngham, gent 0
5496142 2503743 2503743 defendant Lancastre Henry (legal representative) 588463 588463 Lancastre, Henry, of Bresyngham, esq, executors of 0
5496149 2503744 2503744 defendant Lancastre William esq 588463 588463 (Lancastre, William, of Bresyngham, esq 1
5522333 2511805 2511805 defendant Pylkyngton Roger esq 588463 588463 Pylkyngton, Roger, of Bresyngham, esq 0
5522464 2511845 2511845 defendant Medyldyche Thomas yeoman 588463 588463 Medyldyche, Thomas, of Bresyngham, yeoman 2
5530355 2514005 2514005 defendant Bolton Edward esq 588463 588463 Bolton, Edward, of Bresyngham, esq 0
5535379 2515591 2515591 plaintiff Bolton Edward esq 588463 588463 Bolton, Edward, of Bresyngham, esq 0
5535381 2515592 2515592 plaintiff Bolton Edward esq 588463 588463 Bolton, Edward, of Bresyngham, esq 0
5543891 2518199 2518199 defendant Bolton Edward gent 588463 588463 Bolton, Edward, of Bresyngham, gent 0
5560490 2523027 2523027 defendant Bolton Edward gent 588463 588463 Bolton, Edward, of Bresyngham, gent 0
5608136 2537449 2537449 defendant Bulcok George (legal representative) 588463 588463 Bulcok, George, of Bresyngham, draper, executors of 2
5608139 2537449 2537449 defendant Kene William husbandman 588463 588463 Kene, William, of Bresyngham, husbandman 5

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);