names

179 rows where place_id = 588406

✎ 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
3594380 1865875 1865875 defendant Leke Robert clerk 588406 588406 Leke, Robert, of Colton, clerk 0
3613547 1871885 1871885 defendant Dykson John yeoman 588406 588406 Dykson, John, of Colton, yeoman 0
3613549 1871885 1871885 defendant Est Peter husbandman 588406 588406 Est, Peter, of Colton, husbandman 2
3619995 1873824 1873824 defendant Leke Robert clerk 588406 588406 Leke, Robert, of Colton, clerk 0
3619997 1873825 1873825 defendant Leke Robert clerk 588406 588406 Leke, Robert, of Colton, clerk 0
3638061 1906723 1906723 defendant Sawker Roger clerk 588406 588406 Sawker, Roger, of Colton, clerk 0
3653510 1911364 1911364 defendant Geffrey Thomas yeoman 588406 588406 Geffrey, Thomas, of Colton, yeoman 0
3697605 1925474 1925474 defendant Bradbury John yeoman 588406 588406 Bradbury, John, of Colton, yeoman 0
3700566 1926420 1926420 defendant Saunders Robert husbandman 588406 588406 Saunders, Robert, of Colton, husbandman 0
3710704 1929668 1929668 defendant Wygans John husbandman 588406 588406 Wygans, John, of Colton, husbandman 0
3710705 1929668 1929668 defendant Adams Thomas husbandman 588406 588406 Adams, Thomas, of Colton, husbandman 1
3714173 1930731 1930731 defendant Saunders Robert husbandman 588406 588406 Saunders, Robert, of Colton, husbandman 0
3714938 1930967 1930967 defendant Bradbury John yeoman 588406 588406 Bradbury, John, of Colton, yeoman 0
3716770 1931536 1931536 defendant Shepperd Richard yeoman 588406 588406 Shepperd, Richard, of Colton, yeoman 2
3757892 1944449 1944449 defendant Bradbury John yeoman 588406 588406 Bradbury, John, of Colton, yeoman 0
3757895 1944450 1944450 defendant Bradbury John yeoman 588406 588406 Bradbury, John, of Colton, yeoman 0
3760847 1945395 1945395 defendant Shepparte Richard yeoman 588406 588406 Shepparte, Richard, of Colton, yeoman 1
3760851 1945396 1945396 defendant Shepperd Richard yeoman 588406 588406 Shepperd, Richard, of Colton, yeoman 1
3765674 1946929 1946929 defendant Turnour William husbandman 588406 588406 Turnour, William, of Colton, husbandman 2
3775809 1950183 1950183 defendant Bradbury John yeoman 588406 588406 Bradbury, John, of Colton, yeoman 0
3778212 1950893 1950893 defendant Shymmyng John husbandman 588406 588406 Shymmyng, John, of Colton, husbandman 1
3778216 1950894 1950894 defendant Symmyng John husbandman 588406 588406 Symmyng, John, of Colton, husbandman 2
3790510 1954854 1954854 defendant Shepard Richard yeoman 588406 588406 Shepard, Richard, of Colton, yeoman 1
3824469 1965524 1965524 defendant Shepperd Richard yeoman 588406 588406 Shepperd, Richard, of Colton, yeoman 1
3826807 1966236 1966236 defendant Cusshyn Roger husbandman 588406 588406 Cusshyn, Roger, of Colton, husbandman 0
3826814 1966237 1966237 defendant Cusshyn Roger husbandman 588406 588406 Cusshyn, Roger, of Colton, husbandman 0
3837474 1969624 1969624 defendant Brett William husbandman 588406 588406 Brett, William, of Colton, husbandman 2
3937176 2002765 2002765 defendant Knyght Humphrey yeoman 588406 588406 Knyght, Humphrey, of Colton, yeoman 1
3937818 2002980 2002980 defendant Knyght Humphrey yeoman 588406 588406 Knyght, Humphrey, of Colton, yeoman 0
3998211 2024106 2024106 defendant Conceite William husbandman 588406 588406 Conceite, William, of Colton, husbandman 0
4004657 2026441 2026441 defendant Saunders Thomas yeoman 588406 588406 Saunders, Thomas, of Colton, yeoman 0
4010463 2028515 2028515 defendant Waynford John yeoman 588406 588406 Waynford, John, of Colton, yeoman 0
4013345 2029506 2029506 plaintiff Rogers Robert   588406 588406 Rogers, Robert, of Colton 2
4023480 2033106 2033106 defendant Moore Thomas yeoman 588406 588406 Moore, Thomas, of Colton, yeoman 0
4023482 2033107 2033107 defendant More Thomas yeoman 588406 588406 More, Thomas, of Colton, yeoman 0
4027071 2034326 2034326 defendant Wylson Thomas husbandman 588406 588406 Wylson, Thomas, of Colton, husbandman 0
4042315 2039733 2039733 defendant Waynford John yeoman 588406 588406 Waynford, John, of Colton, yeoman 0
4047536 2041570 2041570 defendant Spencer Henry gent 588406 588406 Spencer, Henry, of Colton, gent 2
4047539 2041571 2041571 defendant Spenser Henry gent 588406 588406 Spenser, Henry, of Colton, gent 1
4051725 2043036 2043036 defendant Chalton Hugh husbandman 588406 588406 Chalton, Hugh, of Colton, husbandman 0
4051726 2043036 2043036 defendant Bradbury Christopher husbandman 588406 588406 together with Bradbury, Christopher, of Colton, husbandman 1
4051732 2043039 2043039 defendant Bradbury Christopher husbandman 588406 588406 Bradbury, Christopher, of Colton, husbandman 0
4051733 2043039 2043039 defendant Chalton Hugh husbandman 588406 588406 together with Chalton, Hugh, of Colton, husbandman 1
4172811 2085946 2085946 defendant Carre Robert   588406 588406 Carre, Robert, of Colton, wheelwright 3
4176748 2087337 2087337 defendant Taylor Leonard husbandman 588406 588406 Taylor, Leonard, of Colton, husbandman 1
4176749 2087337 2087337 defendant Baggeley Thomas tailor 588406 588406 Baggeley, Thomas, of Colton, tailor 2
4176750 2087337 2087337 defendant Wiggen Sampson husbandman 588406 588406 Wiggen, Sampson, of Colton, husbandman 3
4196040 2094165 2094165 defendant Carre Robert   588406 588406 Carre, Robert, of Colton, ploughwright 3
4199906 2095519 2095519 defendant Taylor Leonard husbandman 588406 588406 Taylor, Leonard, of Colton, husbandman 1
4199907 2095519 2095519 defendant Bageley Thomas tailor 588406 588406 Bageley, Thomas, of Colton, tailor 2
4250325 2113089 2113089 defendant Amyas Thomas yeoman 588406 588406 Amyas, Thomas, of Colton, yeoman 0
4259998 2116314 2116314 defendant Vyncent Richard butcher 588406 588406 Vyncent, Richard, of Colton, butcher 1
4278146 2122291 2122291 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 1
4281019 2123262 2123262 defendant Spenser Roger gent 588406 588406 Spenser, Roger, of Colton, gent 2
4282973 2123948 2123948 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4285321 2124799 2124799 defendant Spencer Roger   588406 588406 Spencer, Roger, of Colton gent 1
4291581 2127066 2127066 defendant Walenger John yeoman 588406 588406 Walenger, John, of Colton, yeoman 0
4323260 2138196 2138196 defendant Norfolke Christopher yeoman 588406 588406 Norfolke, Christopher, of Colton, yeoman 0
4333727 2141559 2141559 defendant Lynsey Francis husbandman 588406 588406 Lynsey, Francis, of Colton, husbandman 3
4338399 2143178 2143178 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4338403 2143180 2143180 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4349135 2146958 2146958 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4351451 2147759 2147759 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4387093 2160338 2160338 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 3
4389313 2161053 2161053 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4389953 2161264 2161264 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 1
4398730 2164155 2164155 defendant Spencer Roger gent 588406 588406 Spencer, Roger, of Colton, gent 0
4442840 2182716 2182716 defendant Palmere John   588406 588406 Palmere, John, of Colton 0
4467579 2190540 2190540 defendant Palmere John caudeler 588406 588406 Palmere, John, of Colton, caudeler 2
4482819 2195333 2195333 plaintiff Moubray William (legal representative) 588406 588406 Moubray, William, of Colton, executors of 0
4482825 2195334 2195334 plaintiff Moubray William (legal representative) 588406 588406 Moubray, William, of Colton, executors of 0
4482832 2195335 2195335 plaintiff Moubray William (legal representative) 588406 588406 Moubray, William, of Colton, executors of 0
4488921 2197254 2197254 defendant Smythson John   588406 588406 Smythson, John, of Colton 7
4522487 2207373 2207373 defendant Clerk William   588406 588406 Clerk, William, of Colton, parson 0
4564454 2220449 2220449 defendant Rabuk Richard   588406 588406 Rabuk, Richard, of Colton 1
4564455 2220449 2220449 defendant Huchonson Robert   588406 588406 Huchonson, Robert, of Colton 2
4580273 2225312 2225312 defendant Denne Richard   588406 588406 Denne, Richard, of Colton 9
4586926 2227311 2227311 defendant Lawys Nicholas   588406 588406 Lawys, Nicholas, of Colton 0
4595184 2229748 2229748 defendant Styward John   588406 588406 Styward, John, of Colton 3
4595185 2229748 2229748 defendant Baker Henry   588406 588406 Baker, Henry, of Colton 4
4595197 2229749 2229749 defendant Styward John   588406 588406 Styward, John, of Colton 3
4595198 2229749 2229749 defendant Barker Henry   588406 588406 Barker, Henry, of Colton 4
4599441 2231041 2231041 defendant Styward William   588406 588406 Styward, William, of Colton 0
4613335 2235202 2235202 defendant Stele John   588406 588406 Stele, John, of Colton 0
4616174 2236061 2236061 defendant Stele John   588406 588406 Stele, John, of Colton 1
4621760 2237787 2237787 plaintiff Lawes William   588406 588406 Lawes, William, of Colton 0
4630801 2240522 2240522 defendant Lawys William   588406 588406 Lawys, William, of Colton 6
4634930 2241769 2241769 defendant Waleswor Robert   588406 588406 Waleswor, Robert, of Colton, parson 0
4650741 2246236 2246236 defendant Walesworde Robert   588406 588406 Walesworde, Robert, of Colton, parson of the church 0
4661936 2249579 2249579 defendant Forster John smith 588406 588406 Forster, John, of Colton, smith 2
4663949 2250208 2250208 defendant Rose John, junior   588406 588406 Rose, John, junior, of Colton 0
4680326 2259459 2259459 defendant Wytton Richard yeoman 588406 588406 Wytton, Richard, of Colton, yeoman 0
4680328 2259459 2259459 defendant Palmer John yeoman 588406 588406 Palmer, John, of Colton, yeoman 2
4680330 2259460 2259460 defendant Wytton Richard yeoman 588406 588406 Wytton, Richard, of Colton, yeoman 0
4680332 2259460 2259460 defendant Palmer John yeoman 588406 588406 Palmer, John, of Colton, yeoman 2
4681624 2259864 2259864 defendant Clerk John husbandman 588406 588406 Clerk, John, of Colton, husbandman 1
4691876 2262994 2262994 defendant atte Style Roger butcher 588406 588406 atte Style, Roger, of Colton, butcher 1
4700937 2265696 2265696 defendant Style Roger yeoman 588406 588406 Style, Roger, of Colton, yeoman 1
4705991 2267248 2267248 defendant Style Robert   588406 588406 Style, Robert, of Colton 2
4721779 2272146 2272146 defendant Rede Robert, sen husbandman 588406 588406 Rede, Robert, sen, of Colton, husbandman 0

Next page

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