names

150 rows where place_id = 612120

✎ 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
3691699 1923564 1923564 defendant Gybbe Robert butcher 612120 612120 Gybbe, Robert, of Sleford, butcher 0
3691700 1923564 1923564 defendant Gybbe Thomas mercer 612120 612120 Gybbe, Thomas, of Sleford, mercer 1
3747837 1941247 1941247 defendant Cowet or Colbet Nicholas gent 612120 612120 Cowet or Colbet, Nicholas, of Sleford, gent 0
3747842 1941247 1941247 defendant Gosdesburgh Robert yeoman 612120 612120 Gosdesburgh, Robert, of Sleford, yeoman 5
3779933 1951452 1951452 defendant Bowet Nicholas gent 612120 612120 Bowet, Nicholas, of Sleford, gent 0
3779940 1951452 1951452 defendant Goldesburgh Robert yeoman 612120 612120 Goldesburgh, Robert, of Sleford, yeoman 7
3796868 1956898 1956898 defendant Godesburgh Robert yeoman 612120 612120 Godesburgh, Robert, of Sleford, yeoman 7
3806963 1960081 1960081 defendant Husey William esq 612120 612120 Husey, William, of Sleford, esq 2
3807667 1960294 1960294 defendant Newbolt William yeoman 612120 612120 Newbolt, William, of Sleford, yeoman 3
3809773 1960944 1960944 defendant Warmeth or Warmothe Thomas barker 612120 612120 Warmeth or Warmothe, Thomas, of Sleford, barker 1
3809774 1960944 1960944 defendant Raynoldson Henry glover 612120 612120 Raynoldson, Henry, of Sleford, glover 2
3833926 1968548 1968548 defendant Warmouth Thomas tanner 612120 612120 Warmouth, Thomas, of Sleford, tanner 1
3846362 1972416 1972416 defendant Dixson Robert yeoman 612120 612120 Dixson, Robert, of Sleford, yeoman 0
3888923 1986538 1986538 defendant Broune Richard innkeeper 612120 612120 Broune, Richard, of Sleford, innkeeper 0
3888926 1986539 1986539 defendant Folkyngham Thomas gent 612120 612120 Folkyngham, Thomas, of Sleford, gent 0
3896457 1989020 1989020 defendant Sylversyde John smith 612120 612120 Sylversyde, John, of Sleford, smith 2
3899490 1990044 1990044 defendant Sumpton Agnes widow 612120 612120 Sumpton, Agnes, of Sleford, widow 0
3901625 1990771 1990771 defendant Bugge William husbandman 612120 612120 Bugge, William, of Sleford, husbandman 1
3902963 1991220 1991220 defendant Browne Richard innholder 612120 612120 Browne, Richard, of Sleford, innholder 0
3902966 1991221 1991221 defendant Browne Richard innholder 612120 612120 Browne, Richard, of Sleford, innholder 0
3902969 1991222 1991222 defendant Sawnby Thomas mercer 612120 612120 Sawnby, Thomas, of Sleford, mercer 0
3902974 1991223 1991223 defendant Broune Richard innholder 612120 612120 Broune, Richard, of Sleford, innholder 0
3954816 2008753 2008753 defendant Hawkrige Wilfrid tanner 612120 612120 Hawkrige, Wilfrid, of Sleford, tanner 0
4103207 2061429 2061429 defendant Ball Thomas yeoman 612120 612120 Ball, Thomas, of Sleford, yeoman 0
4130406 2071187 2071187 defendant Williamson Thomas laborer 612120 612120 Williamson, Thomas, of Sleford, laborer 0
4238672 2109141 2109141 defendant Carr Lancelot gent 612120 612120 Carr, Lancelot, of Sleford, gent 3
4247106 2112006 2112006 defendant Carr Lancelot gent 612120 612120 Carr, Lancelot, of Sleford, gent 3
4280110 2122954 2122954 defendant Folkingham John innholder 612120 612120 Folkingham, John, of Sleford, innholder 0
4280111 2122954 2122954 defendant Dalton Edward yeoman 612120 612120 Dalton, Edward, of Sleford, yeoman 1
4295464 2128465 2128465 defendant Timberland Robert butcher 612120 612120 Timberland, Robert, of Sleford, butcher 0
4374109 2155811 2155811 defendant Spencer Richard butcher 612120 612120 Spencer, Richard, of Sleford, butcher 0
4440074 2181823 2181823 plaintiff Baxster John   612120 612120 Baxster, John, of Sleford 0
4445182 2183465 2183465 defendant Saunby Thomas de   612120 612120 Saunby, Thomas de, of Sleford 0
4461333 2188626 2188626 defendant Lente Robert   612120 612120 Lente, Robert, of Sleford 0
4475955 2193150 2193150 defendant Croftes John de   612120 612120 Croftes, John de, of Sleford 0
4492591 2198385 2198385 plaintiff (illegible)     612120 612120 ----, of Sleford 0
4501321 2201019 2201019 plaintiff Lewete or Kewete William   612120 612120 Lewete or Kewete, William, of Sleford 0
4501762 2201146 2201146 defendant Skepper Thomas   612120 612120 #Skepper, Thomas, of Sleford 4
4504531 2201976 2201976 defendant Helyngton John   612120 612120 Helyngton, John, of Sleford 0
4526895 2208691 2208691 plaintiff Laweson John   612120 612120 Laweson, John, of Sleford 0
4527207 2208790 2208790 plaintiff Lewte William   612120 612120 Lewte, William, of Sleford 0
4535474 2211366 2211366 plaintiff Bene John   612120 612120 Bene, John, of Sleford 1
4537025 2211848 2211848 defendant Almat John   612120 612120 Almat, John, of Sleford 0
4557770 2218359 2218359 defendant Poynton William   612120 612120 Poynton, William, of Sleford 0
4561849 2219640 2219640 defendant Lauson John   612120 612120 Lauson, John, of Sleford 1
4565739 2220843 2220843 defendant Marum Thomas   612120 612120 Marum, Thomas, of Sleford 6
4566273 2221015 2221015 defendant Ropere Robert   612120 612120 Ropere, Robert, of Sleford 0
4566366 2221053 2221053 plaintiff Stele Thomas merchant 612120 612120 Stele, Thomas, of Sleford, merchant 0
4567013 2221238 2221238 defendant Skepper Thomas   612120 612120 Skepper, Thomas, of Sleford 3
4599128 2230941 2230941 plaintiff Slory John   612120 612120 Slory, John, of Sleford 3
4610773 2234439 2234439 defendant Chapeleyn John   612120 612120 Chapeleyn, John, of Sleford 0
4624542 2238657 2238657 defendant Chapman John   612120 612120 Chapman, John, of Sleford 0
4650842 2246266 2246266 defendant Botheby Thomas de   612120 612120 Botheby, Thomas de, of Sleford 0
4650843 2246266 2246266 defendant Pollard John   612120 612120 Pollard, John, of Sleford 1
4658516 2248544 2248544 defendant Whitwell John butcher 612120 612120 Whitwell, John, of Sleford, butcher 0
4659765 2248903 2248903 defendant Chappeman John butcher 612120 612120 Chappeman, John, of Sleford, butcher 0
4665338 2250649 2250649 defendant Lesyngham John husbandman 612120 612120 Lesyngham, John, of Sleford, husbandman 1
4666325 2250940 2250940 defendant Priour John husbandman 612120 612120 Priour, John, of Sleford, husbandman 0
4669335 2256116 2256116 defendant Bukyngham John clerk 612120 612120 Bukyngham, John, of Sleford, clerk 0
4672110 2256924 2256924 defendant Clytherowe Thomas yeoman 612120 612120 Clytherowe, Thomas, of Sleford, yeoman 3
4672113 2256925 2256925 defendant Lesyngham John   612120 612120 Lesyngham, John, of Sleford, bailiff 1
4672259 2256971 2256971 defendant Bocher Thomas butcher 612120 612120 Bocher, Thomas, of Sleford, butcher 0
4680121 2259392 2259392 defendant Chapman John butcher 612120 612120 Chapman, John, of Sleford, butcher 2
4690853 2262671 2262671 plaintiff Wodecok Robert   612120 612120 Wodecok, Robert, of Sleford 0
4690854 2262671 2262671 defendant Belton Margaret shepster or cloth cutter 612120 612120 Belton, Margaret, of Sleford, shepster or cloth cutter 0
4705351 2267046 2267046 defendant Chapman John butcher 612120 612120 Chapman, John, of Sleford, butcher 0
4705784 2267181 2267181 plaintiff Ledbeter William   612120 612120 Ledbeter, William, of Sleford 0
4705786 2267182 2267182 plaintiff Ledbeter William   612120 612120 Ledbeter, William, of Sleford 0
4706000 2267251 2267251 plaintiff Leveryngton Agatha   612120 612120 Leveryngton, Agatha, of Sleford 0
4729420 2274414 2274414 defendant Wodecok Robert yeoman 612120 612120 Wodecok, Robert, of Sleford, yeoman 5
4729438 2274420 2274420 defendant Danet Walter husbandman 612120 612120 Danet, Walter, of Sleford, husbandman 0
4730128 2274624 2274624 defendant Elston Simon de   612120 612120 Elston, Simon de, of Sleford, servant 0
4730130 2274625 2274625 defendant del Howe John dyer 612120 612120 del Howe, John, of Sleford, dyer 0
4737548 2276856 2276856 defendant Howe John de dyer 612120 612120 Howe, John de, of Sleford, dyer 0
4739419 2277413 2277413 defendant Frence John glover 612120 612120 Frence, John, of Sleford, glover 0
4746400 2279443 2279443 defendant atte Kirk John tanner 612120 612120 atte Kirk, John, of Sleford, tanner 0
4746401 2279443 2279443 defendant Coddare Alan laborer 612120 612120 Coddare, Alan, of Sleford, laborer 1
4746402 2279443 2279443 defendant Pechere Robert carter 612120 612120 Pechere, Robert, of Sleford, carter 2
4746405 2279443 2279443 defendant Shoter Thomas husbandman 612120 612120 Shoter, Thomas, of Sleford, husbandman 5
4746409 2279444 2279444 defendant atte Kirke John butcher 612120 612120 atte Kirke, John, of Sleford, butcher 0
4746412 2279445 2279445 defendant Marom Thomas husbandman 612120 612120 Marom, Thomas, of Sleford, husbandman 0
4746413 2279446 2279446 plaintiff Helyngton Robert   612120 612120 Helyngton, Robert, of Sleford 0
4746414 2279446 2279446 defendant Coddare Alan laborer 612120 612120 Coddare, Alan, of Sleford, laborer 0
4746415 2279446 2279446 defendant Sadeler William husbandman 612120 612120 Sadeler, William, of Sleford, husbandman 1
4746416 2279446 2279446 defendant Spencer Robert butcher 612120 612120 Spencer, Robert, of Sleford, butcher 2
4746417 2279446 2279446 defendant Marum Thomas toller or toll collector 612120 612120 Marum, Thomas, of Sleford, toller or toll collector 3
4749161 2280238 2280238 defendant Chapellam John yeoman 612120 612120 Chapellam, John, of Sleford, yeoman 0
4754607 2281823 2281823 defendant Sadeler William sadler 612120 612120 Sadeler, William, of Sleford, sadler 6
4764378 2284851 2284851 defendant Sadeler William sadler 612120 612120 Sadeler, William, of Sleford, sadler 6
4764436 2284864 2284864 defendant Stafforthschawe John draper 612120 612120 Stafforthschawe, John, of Sleford, draper 0
4767969 2285953 2285953 plaintiff Michell John   612120 612120 Michell, John, of Sleford 0
4790421 2293090 2293090 defendant Teleby William walker 612120 612120 Teleby, William, of Sleford, walker 0
4790424 2293092 2293092 plaintiff Kyng William   612120 612120 Kyng, William, of Sleford 0
4790428 2293094 2293094 plaintiff Kynge William   612120 612120 Kynge, William, of Sleford 0
4792140 2293640 2293640 defendant Colyn John dyer 612120 612120 Colyn, John, of Sleford, dyer 3
4807132 2298429 2298429 plaintiff Chapeley John   612120 612120 Chapeley, John, of Sleford 1
4808474 2298819 2298819 defendant Astlyon William husbandman 612120 612120 Astlyon, William, of Sleford, husbandman 3
4810024 2299291 2299291 defendant Hillyngton John gent 612120 612120 Hillyngton, John, of Sleford, gent 0
4810025 2299291 2299291 defendant Tyede Thomas barber 612120 612120 Tyede, Thomas, of Sleford, barber 1
4810026 2299291 2299291 defendant Milner John milner 612120 612120 Milner, John, of Sleford, milner 2

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