names

62 rows where place_id = 605262

✎ 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
3628071 1903634 1903634 defendant Trygge John merchant 605262 605262 Trygge, John, of Loughborowe, or of Petyrburgh, Nhants, merchant 0
3660950 1913696 1913696 defendant Darker Oliver butcher 605262 605262 Darker, Oliver, of Loughborowe, butcher 0
3671701 1917134 1917134 defendant Smalley William baker 605262 605262 Smalley, William, of Loughborowe, baker 0
3671702 1917134 1917134 defendant Harvy John mercer 605262 605262 Harvy, John, of Loughborowe, mercer 1
3699349 1926014 1926014 defendant Bank William husbandman 605262 605262 Bank, William, of Loughborowe, husbandman 0
3700312 1926338 1926338 defendant Stanford Thurstan butcher 605262 605262 Stanford, Thurstan, of Loughborowe, butcher 0
3700313 1926338 1926338 defendant Chacy Edmund butcher 605262 605262 Chacy, Edmund, of Loughborowe, butcher 1
3700315 1926338 1926338 defendant Laurance Arthur baker 605262 605262 Laurance, Arthur, of Loughborowe, baker 3
3712835 1930335 1930335 defendant Smalley William baker 605262 605262 Smalley, William, of Loughborowe, baker 0
3712836 1930335 1930335 defendant Baker Richard baker 605262 605262 Baker, Richard, of Loughborowe, baker 1
3712898 1930353 1930353 defendant Bankes William husbandman 605262 605262 Bankes, William, of Loughborowe, husbandman 0
3730672 1935828 1935828 defendant Cloar John yeoman 605262 605262 Cloar, John, of Loughborowe, yeoman 3
3731634 1936122 1936122 defendant Hoden William mercer 605262 605262 Hoden, William, of Loughborowe, mercer 0
3744379 1940141 1940141 defendant Columbell John fisher 605262 605262 Columbell, John, of Loughborowe, fisher 0
3750274 1942002 1942002 defendant Stanford Thurstan butcher 605262 605262 Stanford, Thurstan, of Loughborowe, butcher 0
3750275 1942002 1942002 defendant Chace Edward butcher 605262 605262 Chace, Edward, of Loughborowe, butcher 1
3753336 1942982 1942982 defendant Hurte Robert fishmonger 605262 605262 Hurte, Robert, of Loughborowe, fishmonger 0
3756662 1944063 1944063 defendant Chase Edmund butcher 605262 605262 Chase, Edmund, of Loughborowe, butcher 0
3756663 1944063 1944063 defendant Hurt Robert mercer 605262 605262 Hurt, Robert, of Loughborowe, mercer 1
3795457 1956456 1956456 defendant Smyth Thomas yeoman 605262 605262 Smyth, Thomas, of Loughborowe, yeoman 0
3795458 1956456 1956456 defendant Hurte Robert yeoman 605262 605262 Hurte, Robert, of Loughborowe, yeoman 1
3815912 1962881 1962881 defendant Foxley John butcher 605262 605262 Foxley, John, of Loughborowe, butcher 0
3815913 1962881 1962881 defendant Smyth Thomas butcher 605262 605262 Smyth, Thomas, of Loughborowe, butcher 1
3815914 1962881 1962881 defendant Branche Bartholomew glover 605262 605262 Branche, Bartholomew, of Loughborowe, glover 2
3832614 1968125 1968125 defendant Mylner Thomas laborer 605262 605262 Mylner, Thomas, of Loughborowe, laborer 1
3838866 1970082 1970082 defendant Gryffyth John yeoman 605262 605262 Gryffyth, John, of Loughborowe, yeoman 2
3979254 2017328 2017328 defendant Lawrence John (legal representative) 605262 605262 Lawrence, John, of Loughborowe, yeoman, executors of 0
3979255 2017328 2017328 defendant Readman Leonard yeoman 605262 605262 (Readman, Leonard, of Loughborowe, yeoman 1
3979267 2017332 2017332 defendant Lawrence John (legal representative) 605262 605262 Lawrence, John, of Loughborowe, yeoman, executors of 0
3979268 2017332 2017332 defendant Readman Leonard yeoman 605262 605262 (Readman, Leonard, of Loughborowe, yeoman 1
4057577 2045090 2045090 defendant Peache William gent 605262 605262 Peache, William, of Loughborowe, gent 0
4057578 2045090 2045090 defendant Whaton James yeoman 605262 605262 Whaton, James, of Loughborowe, yeoman 1
4057579 2045090 2045090 defendant Thorpe Ralph husbandman 605262 605262 Thorpe, Ralph, of Loughborowe, husbandman 2
4057580 2045090 2045090 defendant Lyme alias Prockter Thomas husbandman 605262 605262 Lyme alias Prockter, Thomas, of Loughborowe, husbandman 3
4057581 2045090 2045090 defendant Slacke John husbandman 605262 605262 Slacke, John, of Loughborowe, husbandman 4
4058686 2045498 2045498 defendant Gibson Clement yeoman 605262 605262 Gibson, Clement, of Loughborowe, yeoman 1
4061822 2046624 2046624 defendant Haughton Henry, junior yeoman 605262 605262 Haughton, Henry, junior, of Loughborowe, or of Woodhouse, Derbs, yeoman 0
4065569 2047976 2047976 defendant Woodruffe Edmund gent 605262 605262 Woodruffe, Edmund, of Loughborowe, or of Hucklowe, Derbs, gent 0
4065570 2047976 2047976 defendant Hill John yeoman 605262 605262 Hill, John, of Loughborowe, or of Hyll, Derbs, yeoman 1
4081836 2053808 2053808 plaintiff Wolley John   605262 605262 Wolley, John, of Loughborowe, woollen draper, administrators of 0
4081840 2053808 2053808 defendant Deddicke John glover 605262 605262 Deddicke, John, of Loughborowe, glover 0
4081841 2053808 2053808 defendant Sneathe Clement husbandman 605262 605262 Sneathe, Clement, of Loughborowe, husbandman 1
4118521 2066916 2066916 defendant Cawdewell George baker 605262 605262 Cawdewell, George, of Loughborowe, baker 0
4186367 2090719 2090719 defendant Dobson Magnus victualer 605262 605262 Dobson, Magnus, of Loughborowe, victualer 1
4206066 2097669 2097669 defendant Laynard Thomas gent 605262 605262 Laynard, Thomas, of Loughborowe, yeoman, or of Whittelberie, Nhants, gent 0
4362380 2151597 2151597 defendant Dobson Magnus mercer 605262 605262 Dobson, Magnus, of Loughborowe, mercer 1
4370362 2154453 2154453 defendant Heywood John tailor 605262 605262 Heywood, John, of Loughborowe, tailor 1
4370363 2154453 2154453 defendant Foster Henry plasterer 605262 605262 Foster, Henry, of Loughborowe, plasterer 2
5512313 2508709 2508709 defendant Parker Richard yeoman 605262 605262 Parker, Richard, of Loughborowe, yeoman 1
5539237 2516758 2516758 defendant Coldwell Roger shoemaker 605262 605262 Coldwell, Roger, of Loughborowe, shoemaker 0
5539238 2516758 2516758 defendant Mardeley Roger mercer 605262 605262 Mardeley, Roger, of Loughborowe, mercer 1
5539239 2516758 2516758 defendant Walwyn Richard husbandman 605262 605262 Walwyn, Richard, of Loughborowe, husbandman 2
5555041 2521481 2521481 defendant Burton Christopher (legal representative) 605262 605262 Burton, Christopher, of Loughborowe, merchant of the staple, executors of 0
5573820 2526910 2526910 defendant Phyppys Henry yeoman 605262 605262 Phyppys, Henry, of Loughborowe, yeoman 0
5573821 2526910 2526910 defendant Colston Richard (legal representative) 605262 605262 Colston, Richard, of Loughborowe, yeoman, executrix of 1
5573822 2526910 2526910 defendant Colston Alice widow 605262 605262 Colston, Alice, of Loughborowe, widow 2
5573824 2526910 2526910 defendant Woode Thomas baker 605262 605262 (Woode, Thomas, of Loughborowe, baker 4
5574203 2527018 2527018 defendant Shippe Henry butcher 605262 605262 Shippe, Henry, of Loughborowe, butcher 0
5587795 2531201 2531201 defendant Large John fisher 605262 605262 Large, John, of Loughborowe, fisher 1
5591865 2532442 2532442 defendant Calcrofte Thomas gent 605262 605262 Calcrofte, Thomas, of Loughborowe, gent 1
5595902 2533633 2533633 defendant Trygg John merchant 605262 605262 Trygg, John, of Loughborowe, or of Peterborough, Nhants, merchant 0
5603371 2535941 2535941 defendant Whetley Thomas draper 605262 605262 Whetley, Thomas, of Loughborowe, draper 0

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