names

120 rows where place_id = 588620

✎ 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
3595079 1866094 1866094 defendant Keberd Henry yeoman 588620 588620 Keberd, Henry, of Broke, yeoman 1
3597878 1866958 1866958 defendant Richard Thomas husbandman 588620 588620 Richard, Thomas, of Broke, husbandman 0
3598308 1867099 1867099 defendant Belconger William tailor 588620 588620 Belconger, William, of Broke, tailor 0
3615289 1872426 1872426 defendant Tocottys Robert gent 588620 588620 Tocottys, Robert, of Broke, gent 0
3618050 1873268 1873268 defendant Richard Thomas butcher 588620 588620 Richard, Thomas, of Broke, butcher 0
3673233 1917643 1917643 defendant Keyberd Robert husbandman 588620 588620 Keyberd, Robert, of Broke, husbandman 0
3684016 1921133 1921133 plaintiff Willughby Robert   588620 588620 Willughby, Robert, of Broke, knight 0
3684371 1921243 1921243 plaintiff Wylloughby Robert   588620 588620 Wylloughby, Robert, of Broke, knight 0
3688915 1922694 1922694 defendant Belonger Robert husbandman 588620 588620 Belonger, Robert, of Broke, husbandman 1
3688918 1922694 1922694 defendant Belonger William (legal representative) 588620 588620 Belonger, William, of Broke, husbandman, executors of 4
3688920 1922694 1922694 defendant Belonger Jane widow 588620 588620 Belonger, Jane, of Broke, widow 6
3689212 1922792 1922792 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3693654 1924209 1924209 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 3
3709880 1929404 1929404 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3709883 1929405 1929405 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3717760 1931856 1931856 defendant Keyberd Robert husbandman 588620 588620 Keyberd, Robert, of Broke, husbandman 0
3718766 1932147 1932147 defendant George alias Edwardys Thomas fuller 588620 588620 George alias Edwardys, Thomas, of Broke, fuller 0
3722195 1933201 1933201 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3724220 1933861 1933861 defendant Curson John husbandman 588620 588620 Curson, John, of Broke, husbandman 0
3733513 1936726 1936726 defendant Rybard Robert yeoman 588620 588620 Rybard, Robert, of Broke, yeoman 0
3737962 1938090 1938090 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 1
3738431 1938227 1938227 defendant Curson John husbandman 588620 588620 Curson, John, of Broke, husbandman 0
3738432 1938227 1938227 defendant Molet Robert husbandman 588620 588620 Molet, Robert, of Broke, husbandman 1
3758154 1944537 1944537 defendant Kybard Robert husbandman 588620 588620 Kybard, Robert, of Broke, husbandman 0
3769771 1948199 1948199 defendant Curson John yeoman 588620 588620 Curson, John, of Broke, yeoman 0
3786376 1953524 1953524 defendant Burnowe Richard husbandman 588620 588620 Burnowe, Richard, of Broke, husbandman 2
3802869 1958795 1958795 defendant Pukford Thomas laborer 588620 588620 Pukford, Thomas, of Broke, Fresshewater, laborer 1
3802870 1958795 1958795 defendant Mosse John yeoman 588620 588620 Mosse, John, of Broke, Fresshewater, yeoman 2
3802871 1958795 1958795 defendant Edwardys David laborer 588620 588620 Edwardys, David, of Broke, Fresshewater, laborer 3
3813483 1962131 1962131 defendant Hobbys Richard husbandman 588620 588620 Hobbys, Richard, of Broke, husbandman 0
3831182 1967642 1967642 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3833153 1968298 1968298 defendant Gye John laborer 588620 588620 Gye, John, of Broke, laborer 1
3833898 1968539 1968539 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3833899 1968539 1968539 defendant Belconder William husbandman 588620 588620 Belconder, William, of Broke, husbandman 1
3858622 1976368 1976368 defendant Kybard Robert husbandman 588620 588620 Kybard, Robert, of Broke, husbandman 4
3858636 1976370 1976370 defendant Kyberd Robert husbandman 588620 588620 Kyberd, Robert, of Broke, husbandman 0
3861794 1977410 1977410 defendant Heynes John smith 588620 588620 Heynes, John, of Broke, smith 2
3862162 1977529 1977529 defendant Kyberd Robert yeoman 588620 588620 Kyberd, Robert, of Broke, yeoman 0
3862164 1977530 1977530 defendant Kyberd Robert yeoman 588620 588620 Kyberd, Robert, of Broke, yeoman 0
3876890 1982512 1982512 plaintiff Harwell Roger (legal representative) 588620 588620 Harwell, Roger, of Broke, clerk, executor of 0
3887417 1986056 1986056 defendant Nedeham alias Netham George yeoman 588620 588620 Nedeham alias Netham, George, of Broke, yeoman 0
3890936 1987233 1987233 defendant Kybart Robert husbandman 588620 588620 Kybart, Robert, of Broke, husbandman 0
3898007 1989539 1989539 defendant Knollys Thomas yeoman 588620 588620 Knollys, Thomas, of Broke, yeoman 1
3898622 1989747 1989747 defendant Kyberd Elizabeth widow 588620 588620 Kyberd, Elizabeth, of Broke, widow 2
3928608 1999906 1999906 plaintiff Bonham John   588620 588620 Bonham, John, of Broke, knight 0
3948352 2006486 2006486 defendant Brady Robert, senior husbandman 588620 588620 Brady, Robert, senior, of Broke, husbandman 0
3975031 2015829 2015829 defendant More John husbandman 588620 588620 More, John, of Broke, husbandman 0
3978652 2017111 2017111 defendant Antyell William singleman 588620 588620 Antyell, William, of Broke, singleman 0
3978654 2017111 2017111 defendant Asshby Richard laborer 588620 588620 Asshby, Richard, of Broke, laborer 2
3978655 2017112 2017112 plaintiff Mollett John carpenter 588620 588620 Mollett, John, of Broke, carpenter 0
4008436 2027784 2027784 plaintiff Mollett John, senior yeoman 588620 588620 Mollett, John, senior, of Broke, yeoman 0
4014891 2030041 2030041 plaintiff Ward Thomas gent 588620 588620 Ward, Thomas, of Broke, gent 3
4014897 2030042 2030042 plaintiff Ward Thomas gent 588620 588620 Ward, Thomas, of Broke, gent 3
4025224 2033684 2033684 plaintiff Brereton Sebastian   588620 588620 Brereton, Sebastian, of Broke 0
4059160 2045676 2045676 defendant Franke Robert laborer 588620 588620 Franke, Robert, of Broke, laborer 0
4059162 2045676 2045676 defendant Wood William husbandman 588620 588620 Wood, William, of Broke, husbandman 2
4108319 2063235 2063235 defendant ap David Owen husbandman 588620 588620 ap David, Owen, of Broke, husbandman 7
4108320 2063235 2063235 defendant Capper Richard husbandman 588620 588620 Capper, Richard, of Broke, husbandman 8
4108321 2063235 2063235 defendant Gethyn William husbandman 588620 588620 Gethyn, William, of Broke, husbandman 9
4150191 2078201 2078201 defendant Kent Robert husbandman 588620 588620 Kent, Robert, of Broke, husbandman 0
4516415 2205544 2205544 defendant Oxenden John, sen   588620 588620 Oxenden, John, sen, of Broke 2
4705114 2266972 2266972 defendant Roncle John gent 588620 588620 Roncle, John, of Broke, gent 2
4725263 2273192 2273192 defendant Plente Walter   588620 588620 Plente, Walter, of Broke, mill ward 3
4758722 2283084 2283084 defendant Aleyn Thomas tanner 588620 588620 Aleyn, Thomas, of Broke, tanner 1
4765699 2285266 2285266 defendant atte Mulle Robert husbandman 588620 588620 atte Mulle, Robert, of Broke, husbandman 0
4796516 2295067 2295067 defendant Jankyn William husbandman 588620 588620 Jankyn, William, of Broke, husbandman 4
4819697 2302235 2302235 defendant Horowe William chaplain 588620 588620 Horowe, William, of Broke, chaplain 1
4896895 2325682 2325682 defendant Jankyn William husbandman 588620 588620 Jankyn, William, of Broke, husbandman 1
4900092 2326660 2326660 defendant Burny William yeoman 588620 588620 Burny, William, of Broke, yeoman 0
4972672 2348759 2348759 defendant Pynhorne John husbandman 588620 588620 Pynhorne, John, of Broke, husbandman 4
5078893 2380172 2380172 defendant Holbroke Thomas weaver 588620 588620 Holbroke, Thomas, of Broke, weaver 1
5243872 2428401 2428401 defendant Estcote William husbandman 588620 588620 Estcote, William, of Broke, husbandman 0
5243873 2428401 2428401 defendant Kytcombe Thomas husbandman 588620 588620 Kytcombe, Thomas, of Broke, , husbandman 1
5243874 2428401 2428401 defendant Stere Thomas husbandman 588620 588620 Stere, Thomas, of Broke, husbandman 2
5262249 2433940 2433940 defendant Salesbury John husbandman 588620 588620 Salesbury, John, of Broke, husbandman 0
5262250 2433940 2433940 defendant Leeff John husbandman 588620 588620 Leeff, John, of Broke, husbandman 1
5262251 2433940 2433940 defendant Coke Thomas husbandman 588620 588620 Coke, Thomas, of Broke, husbandman 2
5309355 2447837 2447837 defendant Rycheman Robert yeoman 588620 588620 Rycheman, Robert, of Broke, yeoman 0
5325037 2452570 2452570 defendant Turnour Robert husbandman 588620 588620 Turnour, Robert, of Broke, husbandman 0
5325038 2452570 2452570 defendant Curson Stephen husbandman 588620 588620 Curson, Stephen, of Broke, husbandman 1
5331808 2454593 2454593 defendant Brady John yeoman 588620 588620 Brady, John, of Broke, yeoman 1
5345622 2458792 2458792 defendant Turnour Robert husbandman 588620 588620 Turnour, Robert, of Broke, husbandman 0
5359711 2463075 2463075 defendant Coone John husbandman 588620 588620 Coone, John, of Broke, husbandman 2
5385815 2471011 2471011 defendant Cooke Thomas, senior husbandman 588620 588620 Cooke, Thomas, senior, of Broke, husbandman 0
5410833 2478188 2478188 defendant Bone John husbandman 588620 588620 Bone, John, of Broke, husbandman 2
5424926 2482420 2482420 defendant Bone John husbandman 588620 588620 Bone, John, of Broke, husbandman 2
5437684 2486206 2486206 defendant Norton John clerk 588620 588620 Norton,John, of Broke, clerk 0
5455227 2491483 2491483 defendant Rypon William cooper 588620 588620 Rypon, William, of Broke, cooper 0
5455228 2491483 2491483 defendant Rypon Thomas cooper 588620 588620 Rypon, Thomas, of Broke, cooper 1
5487447 2501141 2501141 defendant May Gervase yeoman 588620 588620 May, Gervase, of Broke, yeoman 0
5487449 2501142 2501142 defendant May Gervase yeoman 588620 588620 May, Gervase, of Broke, yeoman 0
5498124 2504383 2504383 defendant May William gent 588620 588620 May, William, of Broke, gent 3
5500722 2505157 2505157 defendant May Gervase yeoman 588620 588620 May, Gervase, of Broke, yeoman 0
5514714 2509444 2509444 defendant Rychard Thomas husbandman 588620 588620 Rychard, Thomas, of Broke, husbandman 0
5521190 2511444 2511444 defendant Sheldon Richard gent 588620 588620 Sheldon, Richard, of Broke, gent 0
5521195 2511445 2511445 defendant Sheldon Richard gent 588620 588620 Sheldon, Richard, of Broke, gent 0
5525843 2512673 2512673 defendant Willughby Robert   588620 588620 Willughby, Robert, of Broke, knight 0
5525927 2512701 2512701 defendant Gyldenwater John husbandman 588620 588620 Gyldenwater, John, of Broke, husbandman 1
5526839 2512961 2512961 defendant Willoughby Robert   588620 588620 Willoughby, Robert, of Broke, knight 0
5528477 2513436 2513436 defendant Willoughby Robert   588620 588620 Willoughby, Robert, of Broke, knight 0

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