names

109 rows where place_id = 590425

✎ 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
3601167 1868030 1868030 defendant Bakke John yeoman 590425 590425 Bakke, John, of Langley, yeoman 0
3617430 1873072 1873072 defendant Thorne William husbandman 590425 590425 Thorne, William, of Langley, husbandman 1
3617433 1873073 1873073 defendant Thorne William husbandman 590425 590425 Thorne, William, of Langley, husbandman 1
3619080 1873569 1873569 defendant Rygalld Geoffrey husbandman 590425 590425 Rygalld, Geoffrey, of Langley, husbandman 3
3619267 1873629 1873629 defendant Cokkys William butcher 590425 590425 Cokkys, William, of Langley, butcher 1
3623800 1874976 1874976 defendant Deye John reeder 590425 590425 Deye, John, of Langley, reeder 1
3627798 1903553 1903553 defendant Coppyng John husbandman 590425 590425 Coppyng, John, of Langley, husbandman 0
3652211 1911033 1911033 defendant Carter John, senior yeoman 590425 590425 Carter, John, senior, of Langley, yeoman 0
3652212 1911033 1911033 defendant Carter John, junior yeoman 590425 590425 Carter, John, junior, of Langley, yeoman 1
3657020 1912457 1912457 defendant Walkington Robert   590425 590425 Walkington, Robert, of Langley, abbot of the Monastery of St Mary 0
3659040 1913090 1913090 defendant Teryll Jasper esq 590425 590425 Teryll, Jasper, of Langley, esq 0
3666685 1915528 1915528 plaintiff Walkington Robert   590425 590425 Walkington, Robert, of Langley, abbot of the Monastery of St Mary 0
3666687 1915529 1915529 plaintiff Walkington Robert former Abbot 590425 590425 Walkington, Robert, of Langley, abbot of the Monastery of St Mary, & successor to Walter, former Abbot 0
3676477 1918688 1918688 defendant Terell Jasper gent 590425 590425 Terell, Jasper, of Langley, gent 0
3676479 1918688 1918688 defendant Gryffyn John yeoman 590425 590425 Gryffyn, John, of Langley, yeoman 2
3682256 1920548 1920548 defendant Wafyr Robert husbandman 590425 590425 Wafyr, Robert, of Langley, husbandman 0
3692344 1923776 1923776 defendant Tyrrell Jasper gent 590425 590425 Tyrrell, Jasper, of Langley, gent 0
3720497 1932693 1932693 defendant Twyford Thomas (legal representative) 590425 590425 Twyford, Thomas, of Langley, gent, executrix of 4
3730038 1935635 1935635 defendant Harryson Richard husbandman 590425 590425 Harryson, Richard, of Langley, husbandman 0
3730291 1935705 1935705 defendant Frenche Geoffrey laborer 590425 590425 Frenche, Geoffrey, of Langley, laborer 0
3733469 1936711 1936711 plaintiff Edryche Robert   590425 590425 Edryche, Robert, of Langley 0
3733726 1936796 1936796 defendant Belle Alan tailor 590425 590425 Belle, Alan, of Langley, tailor 3
3745800 1940590 1940590 defendant Marton Thomas husbandman 590425 590425 Marton, Thomas, of Langley, husbandman 2
3753030 1942884 1942884 plaintiff Sarys Edmund   590425 590425 Sarys, Edmund, of Langley 0
3760708 1945349 1945349 defendant Rome Richard yeoman 590425 590425 Rome, Richard, of Langley, yeoman 0
3760709 1945349 1945349 defendant Clerke Richard yeoman 590425 590425 Clerke, Richard, of Langley, yeoman 1
3781688 1952015 1952015 defendant Eysyll Thomas husbandman 590425 590425 Eysyll, Thomas, of Langley, husbandman 0
3799720 1957833 1957833 defendant Burwell John butcher 590425 590425 Burwell, John, of Langley, butcher 0
3799722 1957834 1957834 defendant Burwell John butcher 590425 590425 Burwell, John, of Langley, butcher 0
3808720 1960606 1960606 defendant Bacheler John husbandman 590425 590425 Bacheler, John,of Langley, husbandman 2
3816747 1963143 1963143 defendant Burrewell John butcher 590425 590425 Burrewell, John, of Langley, butcher 0
3822926 1965076 1965076 defendant Bacheler John husbandman 590425 590425 Bacheler, John, of Langley, husbandman 1
3828800 1966885 1966885 defendant Carter John (legal representative) 590425 590425 Carter, John, of Langley, husbandman, executors of 0
3847193 1972679 1972679 defendant Bawdewyn John husbandman 590425 590425 Bawdewyn, John, of Langley, husbandman 0
3856448 1975640 1975640 defendant Blak John yeoman 590425 590425 Blak, John, of Langley, yeoman 4
3876094 1982255 1982255 defendant Todde John husbandman 590425 590425 Todde, John, of Langley, husbandman 2
3899998 1990218 1990218 defendant Cawell Thomas laborer 590425 590425 Cawell, Thomas, of Langley, laborer 2
3912574 1994537 1994537 defendant Romsdon John yeoman 590425 590425 Romsdon, John, of Langley, yeoman 1
3914992 1995366 1995366 defendant Haggas Henry tailor 590425 590425 Haggas, Henry, of Langley, tailor 0
3923537 1998181 1998181 defendant Haggas Henry tailor 590425 590425 Haggas, Henry, of Langley, tailor 0
3977259 2016616 2016616 plaintiff Lee Richard esq 590425 590425 Lee, Richard, of Langley, esq 0
4011711 2028924 2028924 plaintiff Porter Robert yeoman 590425 590425 Porter, Robert, of Langley, yeoman 0
4011713 2028925 2028925 plaintiff Porter Robert yeoman 590425 590425 Porter, Robert, of Langley, yeoman 0
4074540 2051196 2051196 defendant Gylion Christopher bowyer 590425 590425 Gylion, Christopher, of Langley, bowyer 0
4147581 2077295 2077295 defendant Nicolls Edmund tailor 590425 590425 Nicolls, Edmund, of Langley, tailor 3
4185179 2090323 2090323 defendant Procter Stephen shoemaker 590425 590425 Procter, Stephen, of Langley, shoemaker 2
4222609 2103400 2103400 defendant Smythe Thomas gent 590425 590425 Smythe, Thomas, of Langley, gent 0
4282574 2123807 2123807 defendant Skott Robert husbandman 590425 590425 Skott, Robert, of Langley, husbandman 0
4308874 2133253 2133253 defendant Cooke Thomas baker 590425 590425 Cooke, Thomas, of Langley, yeoman, baker 2
4323290 2138207 2138207 defendant Fydge Edward carpenter 590425 590425 Fydge, Edward, of Langley, carpenter 1
4621798 2237803 2237803 defendant Plasshy William   590425 590425 Plasshy, William, of Langley, the parkeres man 0
4658783 2248618 2248618 defendant Aleyn William ploughman 590425 590425 Aleyn, William, of Langley, ploughman 0
4716281 2270401 2270401 defendant Barbour Thomas   590425 590425 Barbour, Thomas, of Langley, wool man 0
4716282 2270401 2270401 defendant Preste William husbandman 590425 590425 Preste, William, of Langley, husbandman 1
4789803 2292878 2292878 defendant Welle Denis yeoman 590425 590425 Welle, Denis, of Langley, yeoman 0
4847952 2310836 2310836 plaintiff (not given) Margaret prioress of Sallowe 590425 590425 Sallowe, Margaret, of Langley, prioress of the the church of the BM 0
4876971 2319767 2319767 defendant Grove Robert husbandman 590425 590425 Grove, Robert, of Langley, husbandman 0
4876972 2319767 2319767 defendant Pastorell Ralph husbandman 590425 590425 Pastorell, Ralph, of Langley, husbandman 1
4947921 2341336 2341336 defendant Adwold John yeoman 590425 590425 Adwold, John, of Langley, yeoman 1
4954659 2343349 2343349 defendant Coke John husbandman 590425 590425 Coke, John, of Langley, husbandman 5
4980921 2351230 2351230 defendant Draycote Thomas collier 590425 590425 Draycote, Thomas, of Langley, collier 0
4980922 2351230 2351230 defendant Cook Emma spinster 590425 590425 Cook, Emma, of Langley, spinster 1
4980925 2351230 2351230 defendant Cook John collier 590425 590425 Cook, John, of Langley, collier 4
5041296 2369003 2369003 defendant (not given) Margaret prioress of Bellers of Bellairs 590425 590425 Bellers of Bellairs, Margaret, of Langley, prioress of the House or Priory 0
5060821 2374814 2374814 defendant Bocher Thomas husbandman 590425 590425 Bocher, Thomas, of Langley, husbandman 0
5091013 2383768 2383768 defendant Streme John yeoman 590425 590425 Streme, John, of Langley, yeoman 4
5214384 2419939 2419939 defendant White Thomas chapman 590425 590425 White, Thomas, of Langley, chapman 0
5214385 2419939 2419939 defendant Potter Robert husbandman 590425 590425 Potter, Robert, of Langley, husbandman 1
5214386 2419939 2419939 defendant Snell William husbandman 590425 590425 Snell, William, of Langley, husbandman 2
5216708 2420621 2420621 defendant Shepherd Reginald husbandman 590425 590425 Shepherd, Reginald, of Langley, husbandman 0
5216709 2420621 2420621 defendant Clondeham or Cloudeham John   590425 590425 Clondeham or Cloudeham, John, of Langley, "suker" 1
5275063 2437787 2437787 defendant Rumbald John husbandman 590425 590425 Rumbald, John, of Langley, husbandman 2
5298536 2444547 2444547 plaintiff Bellers Margaret   590425 590425 Bellers, Margaret, of Langley, prioress 0
5319570 2450947 2450947 defendant Rumbold Richard husbndman 590425 590425 Rumbold, Richard, of Langley, husbndman 2
5332767 2454867 2454867 defendant Seman John yeoman 590425 590425 Seman, John, of Langley, yeoman 4
5335356 2455644 2455644 defendant Pole Peter gent 590425 590425 Pole, Peter, of Langley, gent 0
5343697 2458212 2458212 defendant Wode John husbandman 590425 590425 Wode, John, of Langley, husbandman 2
5361221 2463535 2463535 defendant atte Wode John husbandman 590425 590425 atte Wode, John, of Langley, husbandman 3
5376577 2468274 2468274 defendant Myntlyng or Myntynge John   590425 590425 Myntlyng or Myntynge, John, of Langley, abbot of St Mary's Monastery 0
5395299 2473731 2473731 plaintiff Alpe Walter   590425 590425 Alpe, Walter, of Langley, abbot of the Abbey of Blessed Mary & successor to John Myntlyng, the former abbot 0
5402280 2475725 2475725 defendant Furlong Roger husbandman 590425 590425 Furlong, Roger, of Langley, husbandman 1
5402282 2475726 2475726 defendant Chelchescombe Thomas gent 590425 590425 Chelchescombe, Thomas, of Langley, gent 0
5427737 2483257 2483257 defendant Rumbold William, sen husbandman 590425 590425 Rumbold, William, sen, of Langley, husbandman 0
5427738 2483257 2483257 defendant Felsted John husbandman 590425 590425 Felsted, John, of Langley, husbandman 1
5428516 2483458 2483458 defendant Alpe Walter   590425 590425 Alpe, Walter, of Langley, abbot of the monastery of the BM 0
5438916 2486560 2486560 defendant Russell Thomas chaplain 590425 590425 Russell, Thomas, of Langley, chaplain 4
5445830 2488643 2488643 defendant Alpe Walter   590425 590425 Alpe, Walter, of Langley, abbot of the monastery of the BM 0
5452795 2490713 2490713 defendant Russell Thomas   590425 590425 Russell, Thomas, of Langley 4
5464736 2494366 2494366 defendant Russell Thomas chaplain 590425 590425 Russell, Thomas, of Langley, chaplain 4
5530575 2514079 2514079 defendant Cokeman William butcher 590425 590425 Cokeman, William, of Langley, butcher 3
5534452 2515320 2515320 defendant Pole Henry gent 590425 590425 Pole, Henry, of Langley, gent 0
5538234 2516444 2516444 defendant Shepher Nicholas yeoman 590425 590425 Shepher, Nicholas, of Langley, yeoman 0
5541436 2517434 2517434 defendant Shepherd Nicholas yeoman 590425 590425 Shepherd, Nicholas, of Langley, yeoman 1
5548671 2519654 2519654 defendant Reyner William yeoman 590425 590425 Reyner, William, of Langley, yeoman 0
5557269 2522086 2522086 defendant Twyford Thomas esq 590425 590425 Twyford, Thomas, of Langley, esq 1
5560057 2522900 2522900 plaintiff Shepperd alias Butteler Nicholas husbandman 590425 590425 Shepperd alias Butteler, Nicholas, of Langley, husbandman 0
5560059 2522901 2522901 plaintiff Shepperd alias Butteler Nicholas husbandman 590425 590425 Shepperd alias Butteler, Nicholas, of Langley, husbandman 0
5560065 2522902 2522902 plaintiff Shepperd alias Butteler Nicholas husbandman 590425 590425 Shepperd alias Butteler, Nicholas, of Langley, husbandman 0
5562780 2523703 2523703 defendant Reyner William yeoman 590425 590425 Reyner, William, of Langley, yeoman 1
5572366 2526469 2526469 defendant Twyford Thomas esq 590425 590425 Twyford, Thomas, of Langley, esq 1

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