names

105 rows where place_id = 602043

✎ 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
3648193 1909831 1909831 defendant Frankisshe Henry innholder 602043 602043 Frankisshe, Henry, of Hoveden, innholder 0
3648195 1909832 1909832 defendant Fyssher Richard chaplain 602043 602043 Fyssher, Richard, of Hoveden, chaplain 0
3667506 1915779 1915779 defendant Monketon Edward clerk 602043 602043 Monketon, Edward, of Hoveden, clerk 1
4009212 2028062 2028062 defendant Abbott Thomas tanner 602043 602043 Abbott, Thomas, of Hoveden, tanner 1
4009214 2028063 2028063 defendant Massham Cuthbert   602043 602043 Massham, Cuthbert, of Hoveden, Yorks butcher 0
4009215 2028063 2028063 defendant Abbott Thomas tanner 602043 602043 Abbott, Thomas, of Hoveden, tanner 1
4090119 2056750 2056750 defendant Burtenshawe John husbandman 602043 602043 Burtenshawe, John, of Hoveden, husbandman 0
4090120 2056750 2056750 defendant Abbott Thomas tanner 602043 602043 Abbott, Thomas, of Hoveden, tanner 1
4090121 2056750 2056750 defendant Pearson Richard yeoman 602043 602043 Pearson, Richard, of Hoveden, yeoman 2
4090123 2056751 2056751 defendant Wylfytt John yeoman 602043 602043 Wylfytt, John, of Hoveden, yeoman 0
4090124 2056751 2056751 defendant Bynnes Nicholas butcher 602043 602043 Bynnes, Nicholas, of Hoveden, butcher 1
4090125 2056751 2056751 defendant Thorpe Thomas husbandman 602043 602043 Thorpe, Thomas, of Hoveden, husbandman 2
4090126 2056751 2056751 defendant Collynson Robert husbandman 602043 602043 Collynson, Robert, of Hoveden, husbandman 3
4126157 2069646 2069646 defendant Cootes Thomas tailor 602043 602043 Cootes, Thomas, of Hoveden, tailor 0
4143864 2076017 2076017 defendant Parker William tanner 602043 602043 Parker, William, of Hoveden or of Howldame, tanner 0
4149379 2077909 2077909 defendant Coot or Cootes Thomas tailor 602043 602043 Coot or Cootes, Thomas, of Hoveden, tailor 0
4185753 2090518 2090518 defendant Kyrbye Edmund   602043 602043 Kyrbye, Edmund, of Hoveden, Yorks chapman 2
4220795 2102766 2102766 defendant Dalbie Thomas cooper 602043 602043 Dalbie, Thomas, of Hoveden, cooper 3
4222230 2103267 2103267 defendant Musgrave Cuthbert yeoman 602043 602043 Musgrave, Cuthbert, of Hoveden, yeoman 1
4275419 2121338 2121338 defendant Sherecroft Robert innholder 602043 602043 Sherecroft, Robert, of Hoveden, innholder 0
4275967 2121544 2121544 defendant Westgarthe Thomas laborer 602043 602043 Westgarthe, Thomas, of Hoveden, laborer 0
4309414 2133452 2133452 defendant Pearson Nicholas gent 602043 602043 Pearson, Nicholas, of Hoveden, gent 1
4319604 2136969 2136969 defendant Burrell Richard   602043 602043 Burrell, Richard, of Hoveden, surgeon 2
4346990 2146200 2146200 defendant Banck William draper 602043 602043 Banck, William, of Hoveden, draper 0
4413927 2169255 2169255 plaintiff Cauntebrugge John de   602043 602043 Cauntebrugge, John de, of Hoveden 0
4414606 2169476 2169476 plaintiff Egremund Thomas   602043 602043 Egremund, Thomas, of Hoveden 0
4419589 2171014 2171014 plaintiff Benetland Thomas de   602043 602043 Benetland, Thomas de, of Hoveden 0
4419590 2171014 2171014 defendant Prodhome Walter   602043 602043 Prodhome, Walter, of Hoveden, prebendary of the prebend of Barneby, in the church of St Peter 0
4424582 2172526 2172526 plaintiff Kelkefeld Robert de   602043 602043 Kelkefeld, Robert de, of Hoveden 0
4426435 2173079 2173079 plaintiff Ousthorp John de (legal representative) 602043 602043 Ousthorp, John de, of Hoveden, formerly prebendary of the prebend in St Peter's church, executor of 0
4430355 2174283 2174283 defendant Lound Robert de   602043 602043 Lound, Robert de, of Hoveden 0
4441698 2182343 2182343 defendant Cayvill John de   602043 602043 Cayvill, John de, of Hoveden 3
4441700 2182343 2182343 defendant Whyte Ralph   602043 602043 Whyte, Ralph, of Hoveden 5
4441701 2182343 2182343 defendant Fleccher Thomas   602043 602043 Fleccher, Thomas, of Hoveden 6
4441702 2182343 2182343 defendant Wright Richard   602043 602043 Wright, Richard, of Hoveden 7
4441703 2182343 2182343 defendant Wilson John   602043 602043 Wilson, John, of Hoveden 8
4462750 2189048 2189048 defendant Cisson John   602043 602043 Cisson, John, of Hoveden 8
4495703 2199336 2199336 defendant Mak Isabell   602043 602043 Mak, Isabell, of Hoveden 1
4509800 2203551 2203551 plaintiff Bacheler John   602043 602043 Bacheler, John, of Hoveden 0
4514991 2205095 2205095 plaintiff Cecill Robert   602043 602043 Cecill, Robert, of Hoveden 0
4519023 2206304 2206304 defendant Mody William   602043 602043 Mody, William, of Hoveden 0
4519038 2206306 2206306 defendant Mody William   602043 602043 Mody, William, of Hoveden 0
4537472 2211989 2211989 defendant Home John   602043 602043 Home, John, of Hoveden 0
4550251 2216024 2216024 plaintiff Dabourgh John   602043 602043 Dabourgh, John, of Hoveden 0
4559648 2218973 2218973 plaintiff Middelham Robert tailor 602043 602043 Middelham, Robert, of Hoveden, tailor 0
4564840 2220570 2220570 defendant Midelham Robert   602043 602043 Midelham, Robert, of Hoveden 0
4624653 2238692 2238692 plaintiff Norton alias Clerk William   602043 602043 Norton alias Clerk, William, of Hoveden 0
4627923 2239662 2239662 defendant Mody William   602043 602043 Mody, William, of Hoveden 0
4627924 2239662 2239662 defendant Dryby John   602043 602043 Dryby, John, of Hoveden 1
4669365 2256126 2256126 defendant Modey William husbandman 602043 602043 Modey, William, of Hoveden, husbandman 3
4681243 2259759 2259759 defendant Watson Richard husbandman 602043 602043 Watson, Richard, of Hoveden, husbandman 4
4682309 2260091 2260091 defendant Thomlynson William husbandman 602043 602043 Thomlynson, William, of Hoveden, husbandman 0
4682310 2260091 2260091 defendant Higden John glover 602043 602043 Higden, John, of Hoveden, glover 1
4684813 2260850 2260850 defendant Balne Robert yeoman 602043 602043 Balne, Robert, of Hoveden, yeoman 0
4687956 2261801 2261801 defendant Frankeleyne William clerk 602043 602043 Frankeleyne, William, of Hoveden, clerk 0
4696615 2264418 2264418 defendant Grene Robert   602043 602043 Grene, Robert, of Hoveden, wright 3
4705442 2267069 2267069 defendant Walker Thomas yeoman 602043 602043 Walker, Thomas, of Hoveden, yeoman 0
4705444 2267070 2267070 defendant Tomson Robert yeoman 602043 602043 Tomson, Robert, of Hoveden, yeoman 0
4708317 2267974 2267974 defendant Hygdon John   602043 602043 Hygdon, John, of Hoveden, glove maker 2
4731104 2274928 2274928 defendant Thomlynson William courier 602043 602043 Thomlynson, William, of Hoveden, formerly living in Thorp, courier 0
4733012 2275504 2275504 defendant Blybargh William butcher 602043 602043 Blybargh, William, of Hoveden, butcher 1
4733013 2275504 2275504 defendant Mody William fishmonger 602043 602043 Mody, William, of Hoveden, fishmonger 2
4838358 2307911 2307911 defendant Boythorp Cecily widow 602043 602043 Boythorp, Cecily, of Hoveden, widow 0
4838359 2307911 2307911 defendant Bone Peter husbandman 602043 602043 Bone, Peter, of Hoveden, husbandman 1
4838362 2307912 2307912 defendant Ryng John   602043 602043 Ryng, John, of Hoveden, coverlet weaver 0
4932066 2336423 2336423 plaintiff (not given) William vicar of Welles 602043 602043 Welles, William, of Hoveden, vicar of the Collegiate church 0
5039001 2368312 2368312 plaintiff Barker John (legal representative) 602043 602043 Barker, John, of Hoveden, executor of John Brigge, of Kingston upon Hull, chaplain of the church of Holy Trinity, executor of 0
5046959 2370713 2370713 defendant Laton William gent 602043 602043 Laton, William, of Hoveden, gent 0
5138263 2397700 2397700 defendant Crosseland William fisher 602043 602043 Crosseland, William, of Hoveden, fisher 0
5138264 2397700 2397700 defendant Parker (illegible) yeoman 602043 602043 Parker, --, of Hoveden, yeoman 1
5138265 2397700 2397700 defendant Atkynson Robert glover 602043 602043 Atkynson, Robert, of Hoveden, glover 2
5159060 2403765 2403765 defendant Crosseland William fishmonger 602043 602043 Crosseland, William, of Hoveden, fishmonger 0
5159062 2403765 2403765 defendant Atkynson Robert   602043 602043 Atkynson, Robert, of Hoveden, glove maker 2
5159063 2403765 2403765 defendant Barker Thomas sadler 602043 602043 Barker, Thomas, of Hoveden, sadler 3
5174318 2408193 2408193 defendant Crosseland William fishmonger 602043 602043 Crosseland, William, of Hoveden, fishmonger 0
5174319 2408193 2408193 defendant Parker William yeoman 602043 602043 Parker, William, of Hoveden, yeoman 1
5174320 2408193 2408193 defendant Atkynson Robert   602043 602043 Atkynson, Robert, of Hoveden, glove maker 2
5178536 2409434 2409434 defendant Cobbe John chaplain 602043 602043 Cobbe, John, of Hoveden, chaplain 0
5185004 2411357 2411357 defendant Paythorn Richard smith 602043 602043 Paythorn, Richard, of Hoveden, smith 0
5185005 2411357 2411357 defendant Sadyler Thomas sadler 602043 602043 Sadyler, Thomas, of Hoveden, sadler 1
5185006 2411357 2411357 defendant Ferror William smith 602043 602043 Ferror, William, of Hoveden, smith 2
5185007 2411357 2411357 defendant Ryng John shoemaker 602043 602043 Ryng, John, of Hoveden, shoemaker 3
5185008 2411357 2411357 defendant Ryng John butcher 602043 602043 Ryng, John, of Hoveden, butcher 4
5185009 2411357 2411357 defendant Huson Thomas shoemaker 602043 602043 Huson, Thomas, of Hoveden, shoemaker 5
5268118 2435797 2435797 defendant Williamson Richard yeoman 602043 602043 Williamson, Richard, of Hoveden, yeoman 0
5269582 2436210 2436210 defendant Yotson William husbandman 602043 602043 Yotson, William, of Hoveden, husbandman 0
5270810 2436559 2436559 defendant Hoode John fletcher 602043 602043 Hoode, John, of Hoveden, fletcher 0
5272517 2437036 2437036 defendant Sargeauntson John tailor 602043 602043 Sargeauntson, John, of Hoveden, tailor 0
5272518 2437036 2437036 defendant Felde William tailor 602043 602043 Felde, William, of Hoveden, tailor 1
5273432 2437303 2437303 defendant Palmer John   602043 602043 Palmer, John, of Hoveden 0
5273433 2437303 2437303 defendant Burrerfeld Bertram harper 602043 602043 Burrerfeld, Bertram, of Hoveden, harper 1
5273435 2437303 2437303 defendant (illegible) John shoemaker 602043 602043 ---, John, of Hoveden, shoemaker 3
5274374 2437586 2437586 plaintiff Lucas rRobert   602043 602043 Lucas, rRobert, of Hoveden 1
5299860 2444925 2444925 defendant Cutte Thomas dyer 602043 602043 Cutte, Thomas, of Hoveden, dyer 0
5368614 2465780 2465780 defendant Pynkne Matilda laborer 602043 602043 Pynkne, Matilda, of Hoveden, laborer 0
5378565 2468879 2468879 plaintiff Varvasour William gent 602043 602043 Varvasour, William, of Hoveden, gent 0
5382216 2469972 2469972 defendant Gaukethorp Thomas   602043 602043 Gaukethorp, Thomas, of Hoveden, mason 0
5392345 2472895 2472895 defendant Beterwyk Thomas tailor 602043 602043 Beterwyk, Thomas, of Hoveden, tailor 0
5394043 2473356 2473356 defendant Palmer John husbandman 602043 602043 Palmer, John, of Hoveden, husbandman 0
5394044 2473356 2473356 defendant Holden William tailor 602043 602043 Holden, William, of Hoveden, tailor 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);