names

151 rows where place_id = 587435

✎ 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
3591418 1864943 1864943 plaintiff Dymmok Thomas gent 587435 587435 Dymmok, Thomas, of Conyngesby, gent 0
3597958 1866985 1866985 defendant Palmer Thomas husbandman 587435 587435 Palmer, Thomas, of Conyngesby, husbandman 0
3599561 1867500 1867500 defendant Swyft John chapman 587435 587435 Swyft, John, of Conyngesby, chapman 2
3614989 1872331 1872331 defendant Porter William barker 587435 587435 (Porter, William, of Conyngesby, barker 1
3614990 1872331 1872331 defendant Colbek Robert shoemaker 587435 587435 Colbek, Robert, of Conyngesby, shoemaker 2
3614991 1872331 1872331 defendant Kyme William gent 587435 587435 Kyme, William, of Conyngesby, gent 3
3631546 1904683 1904683 defendant Wren John husbandman 587435 587435 Wren, John, of Conyngesby, husbandman 0
3655928 1912106 1912106 defendant Knyght Henry glover 587435 587435 Knyght, Henry, of Conyngesby, glover 0
3671789 1917168 1917168 defendant Grose Alan husbandman 587435 587435 Grose, Alan, of Conyngesby, husbandman 0
3733416 1936689 1936689 defendant Mason William merchant 587435 587435 Mason, William, of Conyngesby, merchant 0
3733417 1936689 1936689 defendant Whetecrofte Robert yeoman 587435 587435 Whetecrofte, Robert, of Conyngesby, yeoman 1
3733418 1936689 1936689 defendant Melton Richard yeoman 587435 587435 Melton, Richard, of Conyngesby, yeoman 2
3745504 1940500 1940500 defendant Croxby Richard chaplain 587435 587435 Croxby, Richard, of Conyngesby, chaplain 0
3761080 1945467 1945467 defendant Mason William merchant 587435 587435 Mason, William, of Conyngesby, merchant 0
3761081 1945467 1945467 defendant Whetecroft Robert yeoman 587435 587435 Whetecroft, Robert, of Conyngesby, yeoman 1
3761082 1945467 1945467 defendant Melton Richard yeoman 587435 587435 Melton, Richard, of Conyngesby, yeoman 2
3781159 1951844 1951844 defendant Bowys Robert   587435 587435 Bowys, Robert, of Conyngesby, shepherd 1
3851145 1973948 1973948 defendant Bowes Robert yeoman 587435 587435 Bowes, Robert, of Conyngesby, yeoman 0
3873972 1981518 1981518 defendant Mannyng Thomas husbandman 587435 587435 Mannyng, Thomas, of Conyngesby, husbandman 0
3881233 1983991 1983991 defendant Assheton John husbandman 587435 587435 Assheton, John, of Conyngesby, husbandman 0
3894300 1988312 1988312 defendant Roughton Alan laborer 587435 587435 Roughton, Alan, of Conyngesby, laborer 0
3896286 1988969 1988969 defendant Fethersnowe Alexander husbandman 587435 587435 Fethersnowe, Alexander, of Conyngesby, husbandman 0
3946244 2005763 2005763 defendant Storry Richard tinker 587435 587435 Storry, Richard, of Conyngesby, tinker 0
3960333 2010711 2010711 defendant Fetherston John husbandman 587435 587435 Fetherston, John, of Conyngesby, husbandman 0
3965856 2012674 2012674 defendant Caward John yeoman 587435 587435 Caward, John, of Conyngesby, yeoman 0
3967395 2013226 2013226 defendant Rookes Adam husbandman 587435 587435 Rookes, Adam, of Conyngesby, husbandman 1
3969557 2013964 2013964 defendant Coverle John yeoman 587435 587435 Coverle, John, of Conyngesby, yeoman 0
3969561 2013965 2013965 defendant Coverley John yeoman 587435 587435 Coverley, John, of Conyngesby, yeoman 0
3969565 2013966 2013966 defendant Coverle John yeoman 587435 587435 Coverle, John, of Conyngesby, yeoman 0
3970612 2014308 2014308 defendant Caward John yeoman 587435 587435 Caward, John, of Conyngesby, yeoman 0
3971203 2014485 2014485 defendant Peycock William gent 587435 587435 Peycock, William, of Conyngesby, gent 0
3971204 2014485 2014485 defendant Dawson Richard laborer 587435 587435 Dawson, Richard, of Conyngesby, laborer 1
3980196 2017683 2017683 plaintiff Pawston John tailor 587435 587435 Pawston, John, of Conyngesby, tailor 0
3980197 2017683 2017683 defendant Storry William yeoman 587435 587435 Storry, William, of Conyngesby, yeoman 0
3981193 2018033 2018033 defendant Dawson Richard laborer 587435 587435 Dawson, Richard, of Conyngesby, laborer 0
3984558 2019234 2019234 defendant Appleby John laborer 587435 587435 Appleby, John, of Conyngesby, laborer 2
4125865 2069535 2069535 defendant Crawforth John yeoman 587435 587435 Crawforth, John, of Conyngesby, yeoman 1
4132883 2072090 2072090 defendant Mellers John yeoman 587435 587435 Mellers, John, of Conyngesby, yeoman 0
4132884 2072090 2072090 defendant Ledall Hugh yeoman 587435 587435 Ledall, Hugh, of Conyngesby, yeoman 1
4132886 2072090 2072090 defendant Ambrose alias Randall William laborer 587435 587435 Ambrose alias Randall, William, of Conyngesby, laborer 3
4132887 2072090 2072090 defendant Horsman Richard laborer 587435 587435 Horsman, Richard, of Conyngesby, laborer 4
4132889 2072091 2072091 defendant Mellers John yeoman 587435 587435 Mellers, John, of Conyngesby, yeoman 0
4132890 2072091 2072091 defendant Ledall Hugh yeoman 587435 587435 Ledall, Hugh, of Conyngesby, yeoman 1
4132892 2072091 2072091 defendant Ambrose alias Randall William laborer 587435 587435 Ambrose alias Randall, William, of Conyngesby, laborer 3
4132893 2072091 2072091 defendant Horsman Richard laborer 587435 587435 Horsman, Richard, of Conyngesby, laborer 4
4132895 2072092 2072092 defendant Mellers John yeoman 587435 587435 Mellers, John, of Conyngesby, yeoman 0
4132896 2072092 2072092 defendant Ledall Hugh yeoman 587435 587435 Ledall, Hugh, of Conyngesby, yeoman 1
4132898 2072092 2072092 defendant Ambrose alias Randall William laborer 587435 587435 Ambrose alias Randall, William, of Conyngesby, laborer 3
4132899 2072092 2072092 defendant Horsman Richard laborer 587435 587435 Horsman, Richard, of Conyngesby, laborer 4
4132901 2072093 2072093 defendant Mellers John yeoman 587435 587435 Mellers, John, of Conyngesby, yeoman 0
4132902 2072093 2072093 defendant Ledall Hugh yeoman 587435 587435 Ledall, Hugh, of Conyngesby, yeoman 1
4132904 2072093 2072093 defendant Ambrose alias Randall William laborer 587435 587435 Ambrose alias Randall, William, of Conyngesby, laborer 3
4132905 2072093 2072093 defendant Horsman Richard laborer 587435 587435 Horsman, Richard, of Conyngesby, laborer 4
4233172 2107111 2107111 defendant Ditton William yeoman 587435 587435 Ditton, William, of Conyngesby, yeoman 0
4282470 2123770 2123770 defendant Pickeringe John yeoman 587435 587435 Pickeringe, John, of Conyngesby, yeoman 1
4415926 2169865 2169865 defendant Cumberwych Robert de tailor 587435 587435 Cumberwych, Robert de, of Conyngesby, tailor 0
4417446 2170340 2170340 defendant Poke Robert   587435 587435 Poke, Robert, of Conyngesby 0
4438785 2181422 2181422 plaintiff atte Halle Anne daughter of Robert atte Hall 587435 587435 atte Halle, Anne, of Conyngesby, daughter of Robert atte Hall 0
4442943 2182753 2182753 defendant atte Halle Annis daughter of Robert 587435 587435 atte Halle, Annis, of Conyngesby, daughter of Robert 3
4463459 2189266 2189266 defendant Cambok Peter   587435 587435 Cambok, Peter, of Conyngesby 0
4477200 2193537 2193537 defendant Boston John de   587435 587435 Boston, John de, of Conyngesby 0
4500851 2200886 2200886 plaintiff Knotte Roger   587435 587435 Knotte, Roger, of Conyngesby 0
4500853 2200887 2200887 plaintiff Knotte Roger   587435 587435 Knotte, Roger, of Conyngesby, on his own account 0
4510800 2203836 2203836 plaintiff Bauk Robert   587435 587435 Bauk, Robert, of Conyngesby 0
4523594 2207703 2207703 defendant Pokelyngton John clerk 587435 587435 Pokelyngton, John, of Conyngesby, clerk 1
4553544 2217038 2217038 defendant Hotoft Alan tailor 587435 587435 Hotoft, Alan, of Conyngesby, tailor 1
4556033 2217829 2217829 plaintiff Holtham Alan   587435 587435 Holtham, Alan, of Conyngesby 0
4556931 2218097 2218097 defendant Bramle John   587435 587435 Bramle, John, of Conyngesby 1
4556936 2218099 2218099 defendant Bramle John   587435 587435 Bramle, John, of Conyngesby 1
4573906 2223356 2223356 defendant Halstede William   587435 587435 Halstede, William, of Conyngesby 0
4584218 2226478 2226478 plaintiff Gilberd Thomas   587435 587435 Gilberd, Thomas, of Conyngesby 0
4584220 2226479 2226479 plaintiff Gilberd Thomas   587435 587435 Gilberd, Thomas, of Conyngesby 0
4600128 2231264 2231264 defendant Warde John   587435 587435 Warde, John, of Conyngesby 1
4604433 2232553 2232553 defendant Masun John   587435 587435 Masun, John, of Conyngesby 2
4626689 2239290 2239290 defendant Barbour John   587435 587435 Barbour, John, of Conyngesby 4
4655686 2247663 2247663 defendant Hervy Richard   587435 587435 Hervy, Richard, of Conyngesby, wright 1
4660403 2249078 2249078 defendant Birkewode Thomas yeoman 587435 587435 Birkewode, Thomas, of Conyngesby, yeoman 0
4666939 2255389 2255389 defendant London Richard de shipman 587435 587435 London, Richard de, of Conyngesby, shipman 3
4674497 2257635 2257635 defendant Clee Richard husbandman 587435 587435 Clee, Richard, of Conyngesby, husbandman 3
4677551 2258592 2258592 plaintiff Harvy Richard   587435 587435 Harvy, Richard, of Conyngesby 0
4684945 2260886 2260886 defendant Broune John tanner 587435 587435 Broune, John, of Conyngesby, tanner 0
4690974 2262701 2262701 defendant Breuhouse William mercer 587435 587435 Breuhouse, William, of Conyngesby, mercer 0
4695819 2264176 2264176 defendant Burnehowes William mercer 587435 587435 Burnehowes, William, of Conyngesby, mercer 0
4727690 2273902 2273902 defendant Sleght Robert laborer 587435 587435 Sleght, Robert, of Conyngesby, laborer 0
4733943 2275801 2275801 defendant Almotsoncook Richard   587435 587435 Almotsoncook, Richard, of Conyngesby, fen man 0
4735917 2276384 2276384 defendant Isabelson John tanner 587435 587435 Isabelson, John, of Conyngesby, tanner 0
4747955 2279910 2279910 defendant Almotson Robert   587435 587435 Almotson, Robert, of Conyngesby, fenne man 2
4750308 2280566 2280566 defendant Barbour John husbandman 587435 587435 Barbour, John, of Conyngesby, husbandman 4
4750530 2280639 2280639 defendant Grene John shipman 587435 587435 Grene, John, of Conyngesby, shipman 0
4796910 2295189 2295189 defendant Mason Thomas   587435 587435 Mason, Thomas, of Conyngesby, "turfgraver" 0
4810350 2299382 2299382 defendant Fyssher William butcher 587435 587435 Fyssher, William, of Conyngesby, butcher 0
4810401 2299402 2299402 defendant Fyssher William butcher 587435 587435 Fyssher, William, of Conyngesby, butcher 0
4813209 2300246 2300246 defendant Wryght Robert husbandman 587435 587435 Wryght, Robert, of Conyngesby, husbandman 0
4813210 2300246 2300246 defendant Dauson Robert husbandman 587435 587435 Dauson, Robert, of Conyngesby, husbandman 1
4816007 2301098 2301098 defendant Towety John laborer 587435 587435 Towety, John, of Conyngesby, laborer 0
4828196 2304862 2304862 defendant Mason Thomas husbandman 587435 587435 Mason, Thomas, of Conyngesby, husbandman 1
4830293 2305512 2305512 defendant Pyper William laborer 587435 587435 Pyper, William, of Conyngesby, laborer 0
4835277 2307032 2307032 defendant Langholm John gent 587435 587435 (Langholm, John, of Conyngesby, gent 1
4835850 2307201 2307201 defendant Isabelson John   587435 587435 Isabelson, John, of Conyngesby 5
4850022 2311474 2311474 defendant London Richard husbandman 587435 587435 London, Richard, of Conyngesby, husbandman 4

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