names

97 rows where place_id = 589163

✎ 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
3596734 1866615 1866615 defendant Tendryng John yeoman 589163 589163 Tendryng, John, of Boreham, yeoman 0
3596737 1866615 1866615 defendant Creke William laborer 589163 589163 Creke, William, of Boreham, laborer 3
3605555 1869404 1869404 defendant Zouche Thomas gent 589163 589163 Zouche, Thomas, of Boreham, gent 0
3606595 1869736 1869736 defendant John Hugh clerk 589163 589163 John, Hugh, of Boreham, clerk 0
3606596 1869736 1869736 defendant Wodde William husbandman 589163 589163 Wodde, William, of Boreham, husbandman 1
3756354 1943956 1943956 defendant Sabrygth John gent 589163 589163 Sabrygth, John, of Boreham, gent 0
3778404 1950961 1950961 defendant Googe John husbandman 589163 589163 Googe, John, of Boreham, husbandman 0
3778406 1950962 1950962 defendant Gouge John husbandman 589163 589163 Gouge, John, of Boreham, husbandman 0
3809035 1960707 1960707 defendant Harrys Thomas laborer 589163 589163 Harrys, Thomas, of Boreham, laborer 1
3820968 1964453 1964453 defendant Frynton Nicholas husbandman 589163 589163 Frynton, Nicholas, of Boreham, husbandman 1
4048477 2041906 2041906 plaintiff Tendringe Thomas gent 589163 589163 Tendringe, Thomas, of Boreham, gent 0
4063216 2047137 2047137 defendant Fritton Thomas yeoman 589163 589163 Fritton, Thomas, of Boreham, yeoman 0
4124259 2068967 2068967 defendant Pylborowe John gent 589163 589163 Pylborowe, John, of Boreham, or of Hatfeild Peverell, gent 1
4172702 2085911 2085911 defendant Hardye William yeoman 589163 589163 Hardye, William, of Boreham, yeoman 2
4172703 2085911 2085911 defendant Myller Thomas husbandman 589163 589163 Myller, Thomas, of Boreham, husbandman 3
4183633 2089760 2089760 defendant Poole Roger miller 589163 589163 Poole, Roger, of Boreham, miller 0
4183635 2089761 2089761 defendant Poole Roger miller 589163 589163 Poole, Roger, of Boreham, miller 0
4195632 2094025 2094025 defendant Pylborowe John gent 589163 589163 Pylborowe, John, of Boreham, or of Hatfeld Peverell, gent 0
4239240 2109348 2109348 defendant Ellyott David husbandman 589163 589163 Ellyott, David, of Boreham, Warmynster, husbandman 1
4279787 2122847 2122847 defendant Saule Nicholas husbandman 589163 589163 Saule, Nicholas, of Boreham, husbandman 0
4350941 2147584 2147584 defendant Stane Edmund yeoman 589163 589163 Stane, Edmund, of Boreham, yeoman 1
4393936 2162572 2162572 defendant Allyn John yeoman 589163 589163 Allyn, John, of Boreham, yeoman 0
4400085 2164619 2164619 defendant Crosse William blacksmith 589163 589163 Crosse, William, of Boreham, blacksmith 0
4400088 2164619 2164619 defendant Webb Mathew tailor 589163 589163 Webb, Mathew, of Boreham, tailor 3
4525907 2208402 2208402 defendant Stoure John   589163 589163 Stoure, John, of Boreham 0
4546990 2214992 2214992 plaintiff Bubbe Roger   589163 589163 Bubbe, Roger, of Boreham 0
4546992 2214992 2214992 defendant Shirreve John   589163 589163 Shirreve, John, of Boreham 1
4610648 2234396 2234396 defendant Shereve John   589163 589163 Shereve, John, of Boreham 3
4612439 2234955 2234955 defendant Glover Richard   589163 589163 Glover, Richard, of Boreham 0
4627009 2239398 2239398 plaintiff Redhood Thomas (legal representative) 589163 589163 Redhood, Thomas, of Boreham, executors of 0
4697397 2264672 2264672 defendant Pappesworth Walter yeoman 589163 589163 Pappesworth, Walter, of Boreham, yeoman 0
4808707 2298891 2298891 defendant Porter Robert gent 589163 589163 Porter, Robert, of Boreham, gent 0
4808709 2298891 2298891 defendant Tendryng John farmer 589163 589163 Tendryng, John, of Boreham, farmer 2
4839191 2308186 2308186 defendant Cranesle John clerk 589163 589163 Cranesle, John, of Boreham, clerk 0
4885529 2322355 2322355 defendant Fuller Richard husbandman 589163 589163 Fuller, Richard, of Boreham, husbandman 1
4922494 2333450 2333450 defendant Pakton Thomas chaplain 589163 589163 Pakton, Thomas, of Boreham, chaplain 1
4975194 2349538 2349538 defendant Bokener alias Wynchestre Henry yeoman 589163 589163 Bokener alias Wynchestre, Henry, of Boreham, yeoman 2
5014371 2361063 2361063 defendant atte Mille Robert husbandman 589163 589163 atte Mille, Robert, of Boreham, husbandman 2
5028205 2365121 2365121 defendant atte Mille Alice widow 589163 589163 atte Mille, Alice, of Boreham, widow 0
5028207 2365122 2365122 defendant Colbrond Thomas gent 589163 589163 Colbrond, Thomas, of Boreham, gent 0
5038532 2368167 2368167 plaintiff Alrede Richard (legal representative) 589163 589163 Alrede, Richard, of Boreham, esq, executors of 0
5044246 2369908 2369908 defendant Waleys John maltman 589163 589163 Waleys, John, of Boreham, maltman 0
5046688 2370630 2370630 defendant Bekenore Henry husbandman 589163 589163 Bekenore, Henry, of Boreham, husbandman 0
5048893 2371303 2371303 defendant Bykener Henry yeoman 589163 589163 Bykener, Henry, of Boreham, yeoman 1
5075105 2379055 2379055 defendant Alred Agnes widow 589163 589163 (Alred, Agnes, of Boreham, widow 1
5075106 2379055 2379055 defendant Stones Thomas esq 589163 589163 Stones, Thomas, of Boreham, esq 2
5082988 2381417 2381417 defendant Lampham John husbandman 589163 589163 Lampham, John, of Boreham, husbandman 0
5113212 2390258 2390258 defendant Bryghtnot Thomas husbandman 589163 589163 Bryghtnot, Thomas, of Boreham, husbandman 11
5114753 2390728 2390728 defendant Lampham John husbandman 589163 589163 Lampham, John, of Boreham, husbandman 0
5133829 2396387 2396387 defendant Alrede Agnes widow 589163 589163 Alrede, Agnes, of Boreham, widow 0
5138885 2397875 2397875 defendant Smyth William husbandman 589163 589163 Smyth, William, of Boreham, husbandman 2
5138887 2397875 2397875 defendant Carpenter Henry carpenter 589163 589163 Carpenter, Henry, of Boreham, carpenter 4
5154744 2402541 2402541 defendant Alrede Agnes widow 589163 589163 Alrede, Agnes, of Boreham, widow 0
5160008 2404028 2404028 defendant Grene Nicholas clerk 589163 589163 Grene, Nicholas, of Boreham, clerk 0
5174934 2408365 2408365 defendant Grene Nicholas clerk 589163 589163 Grene, Nicholas, of Boreham, clerk 0
5184976 2411351 2411351 defendant Wryght William butcher 589163 589163 Wryght, William, of Boreham, butcher 0
5187356 2412027 2412027 defendant Bylner Henry husbandman 589163 589163 Bylner, Henry, of Boreham, husbandman 2
5204623 2417097 2417097 defendant Wryght William butcher 589163 589163 Wryght, William, of Boreham, butcher 0
5205571 2417375 2417375 defendant Bykner Henry husbandman 589163 589163 Bykner, Henry, of Boreham, husbandman 2
5216295 2420504 2420504 defendant Flesshe John tailor 589163 589163 Flesshe, John, of Boreham, tailor 0
5216296 2420504 2420504 defendant Gray Robert husbandman 589163 589163 Gray, Robert, of Boreham, husbandman 1
5216298 2420504 2420504 defendant att Lay Richard husbandman 589163 589163 att Lay, Richard, of Boreham, husbandman 3
5216299 2420504 2420504 defendant Veryman John husbandman 589163 589163 Veryman, John, of Boreham, husbandman 4
5217615 2420890 2420890 defendant Colebronde Thomas gent 589163 589163 Colebronde, Thomas, of Boreham, gent 12
5217629 2420890 2420890 defendant at Mille Robert husbandman 589163 589163 at Mille, Robert, of Boreham, husbandman 26
5290756 2442298 2442298 defendant Mille Robert yeoman 589163 589163 Mille, Robert, of Boreham, yeoman 0
5299737 2444892 2444892 defendant Bastewyk John carpenter 589163 589163 Bastewyk, John, of Boreham, carpenter 0
5299739 2444893 2444893 defendant Bikener William smith 589163 589163 Bikener, William, of Boreham, smith 0
5299740 2444893 2444893 defendant Bastewyk John carpenter 589163 589163 together with Bastewyk, John, of Boreham, carpenter 1
5308231 2447494 2447494 defendant Sadeler John husbandman 589163 589163 Sadeler, John, of Boreham, husbandman 1
5325020 2452564 2452564 defendant Sadlyngton John husbandman 589163 589163 Sadlyngton, John, of Boreham, husbandman 0
5360603 2463348 2463348 defendant Colbronde Ralph gent 589163 589163 Colbronde, Ralph, of Boreham, gent 0
5382408 2470028 2470028 defendant Bruer Robert husbandman 589163 589163 Bruer, Robert, of Boreham, husbandman 0
5391308 2472594 2472594 defendant John Hugh clerk 589163 589163 John, Hugh, of Boreham, clerk 0
5402273 2475723 2475723 defendant Cooke John yeoman 589163 589163 Cooke, John, of Boreham, yeoman 1
5404688 2476418 2476418 defendant Bruer Robert husbandman 589163 589163 Bruer, Robert, of Boreham, husbandman 0
5406890 2477034 2477034 defendant Jordan Walter husbandman 589163 589163 Jordan, Walter, of Boreham, husbandman 2
5419207 2480672 2480672 defendant John Hugh chaplain 589163 589163 John, Hugh, of Boreham, chaplain 1
5420035 2480909 2480909 defendant Jordan (illegible) husbandman 589163 589163 Jordan, _, of Boreham, husbandman 2
5428872 2483549 2483549 defendant Freton John husbandman 589163 589163 Freton, John, of Boreham, husbandman 0
5434102 2485151 2485151 defendant Hewe John clerk 589163 589163 Hewe, John, of Boreham, clerk 1
5437405 2486132 2486132 defendant John Hugh chaplain 589163 589163 John, Hugh, of Boreham, chaplain 1
5437416 2486136 2486136 defendant John Hugh chaplain 589163 589163 John, Hugh, of Boreham, chaplain 1
5443513 2487971 2487971 defendant Freton John husbandman 589163 589163 Freton, John, of Boreham, husbandman 0
5450965 2490179 2490179 defendant Herde Thomas husbandman 589163 589163 Herde, Thomas, of Boreham, husbandman 0
5455865 2491661 2491661 plaintiff Bruer Robert   589163 589163 Bruer, Robert, of Boreham 0
5455868 2491661 2491661 defendant Tabour William fisher 589163 589163 Tabour, William, of Boreham, fisher 2
5467489 2495213 2495213 plaintiff Brener Robert   589163 589163 Brener, Robert, of Boreham 0
5467492 2495213 2495213 defendant Tabour William fisher 589163 589163 Tabour, William, of Boreham, fisher 2
5475815 2497767 2497767 defendant John Hugh clerk 589163 589163 John, Hugh, of Boreham, clerk 0
5476355 2497932 2497932 defendant Tabur William fishmonger 589163 589163 Tabur, William, of Boreham, fishmonger 4
5484480 2500276 2500276 plaintiff Mille Robert (legal representative) 589163 589163 Mille, Robert, of Boreham, administratrix of 0
5490434 2502033 2502033 defendant Wod Thomas yeoman 589163 589163 together with Wod, Thomas, of Boreham, yeoman 1
5543917 2518208 2518208 defendant Bykener Thomas smith 589163 589163 Bykener, Thomas, of Boreham, smith 2
5548311 2519537 2519537 defendant Atmyll Richard yeoman 589163 589163 Atmyll, Richard, of Boreham, yeoman 0
5573928 2526939 2526939 defendant John Hugh clerk 589163 589163 John, Hugh, of Boreham, clerk 2
5583397 2529880 2529880 defendant Payne Thomas husbandman 589163 589163 Payne, Thomas, of Boreham, husbandman 0

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