names

82 rows where place_id = 621884

✎ 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
3744092 1940049 1940049 plaintiff Alyssander William turner 621884 621884 Alyssander, William, of Lyndefeld, turner 0
3915039 1995385 1995385 defendant Slutter Edward mercer 621884 621884 Slutter, Edward, of Lyndefeld, mercer 0
4129191 2070741 2070741 defendant Gere Thomas husbandman 621884 621884 Gere, Thomas, of Lyndefeld, husbandman 0
4261701 2116868 2116868 defendant Martyn Richard husbandman 621884 621884 Martyn, Richard, of Lyndefeld, husbandman 0
4450094 2184986 2184986 defendant Pottere John   621884 621884 Pottere, John, of Lyndefeld 0
4483649 2195577 2195577 defendant Motyn Ralph   621884 621884 Motyn, Ralph, of lyndefeld 0
4517166 2205772 2205772 plaintiff Craddok Richard (legal representative) 621884 621884 Craddok, Richard, of Lyndefeld, executor of 0
4543245 2213769 2213769 defendant Mason John   621884 621884 Mason, John, of Lyndefeld 0
4543246 2213769 2213769 defendant Tynker Thomas   621884 621884 together with Tynker, Thomas, of Lyndefeld 1
4543589 2213886 2213886 defendant Bokeselle Walter   621884 621884 Bokeselle, Walter, of Lyndefeld 0
4572827 2223039 2223039 defendant Bocher William   621884 621884 Bocher, William, of Lyndefeld 0
4573000 2223089 2223089 defendant Smyth Thomas   621884 621884 Smyth, Thomas, of Lyndefeld 0
4581590 2225689 2225689 defendant Boucher William   621884 621884 Boucher, William, of Lyndefeld 1
4621201 2237621 2237621 defendant atte Berne John   621884 621884 atte Berne, John, of Lyndefeld 0
4621203 2237622 2237622 defendant atte Berne John   621884 621884 atte Berne, John, of Lyndefeld 0
4623790 2238417 2238417 defendant atte Berne John   621884 621884 atte Berne, John, of Lyndefeld 0
4623792 2238417 2238417 defendant Sayer John   621884 621884 Sayer, John, of Lyndefeld 2
4634944 2241773 2241773 defendant Dyer Thomas   621884 621884 Dyer, Thomas, of Lyndefeld 0
4656277 2247857 2247857 defendant Ludwell Richard drover 621884 621884 Ludwell, Richard, of Lyndefeld, drover 0
4689641 2262321 2262321 defendant Glover William husbandman 621884 621884 Glover, William, of Lyndefeld, husbandman 0
4703936 2266609 2266609 defendant atte Berne John butcher 621884 621884 atte Berne, John, of Lyndefeld, butcher 0
4722319 2272305 2272305 defendant Potter John laborer 621884 621884 Potter, John, of Lyndefeld, laborer 0
4725943 2273401 2273401 plaintiff Golde John   621884 621884 Golde, John, of Lyndefeld 0
4733694 2275717 2275717 defendant Deghere Thomas laborer 621884 621884 Deghere, Thomas, of Lyndefeld, laborer 0
4735664 2276303 2276303 defendant Deygher Thomas husbandman 621884 621884 Deygher, Thomas, of Lyndefeld, husbandman 1
4741504 2278010 2278010 defendant atte Wode John fuller 621884 621884 atte Wode, John, of Lyndefeld, fuller 0
4747989 2279922 2279922 defendant Deghere Thomas laborer 621884 621884 Deghere, Thomas, of Lyndefeld, laborer 0
4771272 2286995 2286995 defendant Coupere John laborer 621884 621884 Coupere, John, of Lyndefeld, laborer 1
4785783 2291591 2291591 defendant Baldyng Richard cooper 621884 621884 Baldyng, Richard, of Lyndefeld, cooper 1
4785810 2291594 2291594 defendant atte Broke Thomas husbandman 621884 621884 atte Broke, Thomas, of Lyndefeld, husbandman 10
4789600 2292820 2292820 defendant Payn John wheeler 621884 621884 Payn, John, of Lyndefeld, wheeler 0
4789601 2292820 2292820 defendant Baldyng John potter 621884 621884 Baldyng, John, of Lyndefeld, potter 1
4790077 2292972 2292972 defendant Deghere Thomas laborer 621884 621884 Deghere, Thomas, of Lyndefeld, laborer 0
4790079 2292973 2292973 defendant Deghere Thomas laborer 621884 621884 Deghere, Thomas, of Lyndefeld, laborer 0
4970437 2348105 2348105 defendant Aleyn John laborer 621884 621884 Aleyn, John, of Lyndefeld, laborer 0
4984270 2352221 2352221 defendant Pegden John husbandman 621884 621884 Pegden, John, of Lyndefeld, husbandman 1
4984271 2352221 2352221 defendant Pegden Richard husbandman 621884 621884 Pegden, Richard, of Lyndefeld, husbandman 2
4984272 2352221 2352221 defendant atte Vale William husbandman 621884 621884 atte Vale, William, of Lyndefeld, husbandman 3
4997368 2356062 2356062 defendant Aleyn Richard husbandman 621884 621884 Aleyn, Richard, of Lyndefeld, husbandman 0
5037308 2367783 2367783 defendant Payn Thomas wheeler 621884 621884 Payn, Thomas, of Lyndefeld, wheeler 4
5037309 2367783 2367783 defendant Pekeden Richard laborer 621884 621884 Pekeden, Richard, of Lyndefeld, laborer 5
5048096 2371052 2371052 defendant Michelborne William butcher 621884 621884 Michelborne, William, of Lyndefeld, butcher 1
5089240 2383225 2383225 defendant Mosot or Mofot Richard husbandman 621884 621884 Mosot or Mofot, Richard, of Lyndefeld, husbandman 0
5099361 2386241 2386241 plaintiff Westhale William   621884 621884 Westhale, William, of Lyndefeld 0
5099960 2386424 2386424 defendant Sayer James chapman 621884 621884 Sayer, James, of Lyndefeld, chapman 0
5118016 2391698 2391698 defendant Johnson Nicholas cordwainer 621884 621884 Johnson, Nicholas, of Lyndefeld, cordwainer 0
5227870 2423768 2423768 defendant Pylstye Thomas carpenter 621884 621884 Pylstye, Thomas, of Lyndefeld, carpenter 0
5260609 2433452 2433452 defendant Sayer Richard mercer 621884 621884 Sayer, Richard, of Lyndefeld, mercer 0
5260610 2433452 2433452 defendant Underhill Thomas butcher 621884 621884 Underhill, Thomas, of Lyndefeld, butcher 1
5260611 2433452 2433452 defendant Potter William smith 621884 621884 Potter, William, of Lyndefeld, smith 2
5260612 2433452 2433452 defendant Gere Richard weaver 621884 621884 Gere, Richard, of Lyndefeld, weaver 3
5260613 2433452 2433452 defendant Gere Tomas fuller 621884 621884 Gere, Tomas, of Lyndefeld, fuller 4
5260616 2433452 2433452 defendant Kynge John, senior husbandman 621884 621884 Kynge, John, senior, of Lyndefeld, husbandman 7
5260617 2433452 2433452 defendant Kynge John, junior   621884 621884 Kynge, John, junior, of Lyndefeld, groom 8
5269485 2436175 2436175 defendant Mastall Joan widow 621884 621884 Mastall, Joan, of Lyndefeld, widow 0
5269486 2436175 2436175 defendant Mastall John laborer 621884 621884 Mastall, John, of Lyndefeld, laborer 1
5276468 2438189 2438189 defendant Remys Hugh chapman 621884 621884 Remys, Hugh, of Lyndefeld, chapman 0
5294879 2443490 2443490 defendant atte Hill William husbandman 621884 621884 atte Hill, William, of Lyndefeld, husbandman 0
5297572 2444296 2444296 defendant Baker Robert tailor 621884 621884 Baker, Robert, of Lyndefeld, tailor 0
5297573 2444296 2444296 defendant Martyn John baker 621884 621884 Martyn, John, of Lyndefeld, baker 1
5297574 2444296 2444296 defendant Undyrhylle Thomas   621884 621884 Undyrhylle, Thomas, of Lyndefeld 2
5297576 2444296 2444296 defendant Potter William smith 621884 621884 Potter, William, of Lyndefeld, smith 4
5323599 2452142 2452142 defendant Pylstede Thomas carpenter 621884 621884 Pylstede, Thomas, of Lyndefeld, carpenter 1
5325281 2452650 2452650 defendant Pentecost Richard carpenter 621884 621884 Pentecost, Richard, of Lyndefeld, carpenter 0
5325283 2452650 2452650 defendant atte Lee Thomas husbandman 621884 621884 atte Lee, Thomas, of Lyndefeld, husbandman 2
5325284 2452650 2452650 defendant Mone John husbandman 621884 621884 Mone, John, of Lyndefeld, husbandman 3
5432050 2484554 2484554 defendant Wheler John husbandman 621884 621884 Wheler, John, of Lyndefeld, husbandman 0
5432052 2484554 2484554 defendant Bryan Richard husbandman 621884 621884 Bryan, Richard, of Lyndefeld, husbandman 2
5448268 2489374 2489374 defendant Brayn Richard yeoman 621884 621884 Brayn, Richard, of Lyndefeld, yeoman 2
5472207 2496653 2496653 defendant Bryan Richard yeoman 621884 621884 Bryan, Richard, of Lyndefeld, yeoman 2
5483599 2500044 2500044 defendant Bryan Richard husbandman 621884 621884 Bryan, Richard, of Lyndefeld, husbandman 3
5496162 2503749 2503749 defendant Baldyng Thomas weaver 621884 621884 Baldyng, Thomas, of Lyndefeld, weaver 1
5496163 2503749 2503749 defendant Baldyng Richard laborer 621884 621884 Baldyng, Richard, of Lyndefeld, laborer 2
5496164 2503749 2503749 defendant Baldyng James laborer 621884 621884 Baldyng, James, of Lyndefeld, laborer 3
5497909 2504318 2504318 defendant Damme Christopher clerk 621884 621884 Damme, Christopher, of Lyndefeld, clerk 0
5512708 2508831 2508831 defendant Damme Christopher clerk 621884 621884 Damme, Christopher, of Lyndefeld, clerk 0
5627158 2552461 2552461 defendant Tynker Walter   621884 621884 Tynker, Walter, of Lyndefeld 1
5627159 2552461 2552461 defendant Coly Richard   621884 621884 Coly, Richard, of Lyndefeld 2
5627160 2552461 2552461 defendant Berne John   621884 621884 Berne, John, of Lyndefeld 3
5627161 2552461 2552461 defendant Melshe Richard   621884 621884 Melshe, Richard, of Lyndefeld 4
5627163 2552461 2552461 defendant Sigger Simon   621884 621884 Sigger, Simon, of Lyndefeld 6
5627165 2552461 2552461 defendant Snellyng Thomas   621884 621884 Snellyng, Thomas, of Lyndefeld 8

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