names

113 rows where place_id = 755212

✎ 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
4421441 2171611 2171611 plaintiff Cordewaner John le   755212 755212 Cordewaner, John le, of Lodelowe, son of Reginald 0
4421442 2171611 2171611 defendant Cleo William de la (legal representative) 755212 755212 Cleo, William de la, of Lodelowe, merchant, executrix of 0
4425771 2172871 2172871 plaintiff Minter Robert le   755212 755212 Minter, Robert le, of Lodelowe, son of Roger 0
4426455 2173086 2173086 plaintiff Oym John   755212 755212 Oym, John, of Lodelowe 0
4426976 2173262 2173262 defendant Digher Roger le   755212 755212 Digher, Roger le, of Lodelowe 0
4427325 2173380 2173380 defendant Saleburs John de merchant 755212 755212 Saleburs, John de, of Lodelowe, merchant 0
4427463 2173426 2173426 plaintiff Salop John de   755212 755212 Salop, John de, of Lodelowe 0
4443097 2182803 2182803 defendant Hereford William   755212 755212 Hereford, William, of Lodelowe 0
4443182 2182828 2182828 defendant Prille Nicholas   755212 755212 Prille, Nicholas, of Lodelowe 1
4443183 2182828 2182828 defendant Leg John baker 755212 755212 Leg, John, of Lodelowe, baker 2
4443189 2182829 2182829 defendant Prille Nicholas   755212 755212 Prille, Nicholas, of Lodelowe 3
4443728 2183007 2183007 defendant Goldsmiyth Henry   755212 755212 Goldsmiyth, Henry, of Lodelowe 0
4453829 2186206 2186206 defendant Goldsmyth Henry   755212 755212 Goldsmyth, Henry, of Lodelowe 0
4456673 2187113 2187113 plaintiff Orleton William de   755212 755212 Orleton, William de, of Lodelowe 0
4456675 2187114 2187114 plaintiff Orleton William de   755212 755212 Orleton, William de, of Lodelowe, on his own account 0
4456676 2187114 2187114 defendant Prille Nicholas   755212 755212 Prille, Nicholas, of Lodelowe 0
4456683 2187115 2187115 plaintiff Orleton William   755212 755212 Orleton, William, of Lodelowe 0
4458486 2187700 2187700 defendant Chaloner William le   755212 755212 Chaloner, William le, of Lodelowe 0
4459600 2188056 2188056 defendant Spicer John   755212 755212 Spicer, John, of Lodelowe 0
4463684 2189335 2189335 defendant Benhale John dyer 755212 755212 Benhale, John, of Lodelowe, dyer 2
4463775 2189351 2189351 defendant Benhale John dyer 755212 755212 Benhale, John, of Lodelowe, dyer 2
4466385 2190151 2190151 defendant Hordeley Richard   755212 755212 Hordeley, Richard, of Lodelowe 1
4472650 2192112 2192112 defendant Hereford William   755212 755212 (Hereford, William, of Lodelowe 1
4484094 2195720 2195720 plaintiff Parys William   755212 755212 Parys, William, of Lodelowe 0
4491228 2197945 2197945 defendant Girrous John   755212 755212 Girrous, John, of Lodelowe 0
4491230 2197946 2197946 defendant Girrous John   755212 755212 Girrous, John, of Lodelowe 0
4500261 2200708 2200708 defendant Orleton Thomas   755212 755212 Orleton, Thomas, of Lodelowe 1
4501581 2201099 2201099 defendant Beke Walter   755212 755212 Beke, Walter, of Lodelowe 0
4501583 2201099 2201099 defendant Brokton Thomas   755212 755212 Brokton, Thomas, of Lodelowe 2
4501585 2201100 2201100 defendant Beke Walter   755212 755212 Beke, Walter, of Lodelowe 0
4501586 2201100 2201100 defendant Barfote John   755212 755212 Barfote, John, of Lodelowe 1
4501587 2201100 2201100 defendant Brokton Thomas   755212 755212 Brokton, Thomas, of Lodelowe 2
4508277 2203075 2203075 defendant Coutrey Thomas le   755212 755212 Coutrey, Thomas le, of Lodelowe 0
4531157 2210021 2210021 plaintiff Parys William   755212 755212 Parys, William, of Lodelowe 0
4551380 2216369 2216369 defendant Gose John butcher 755212 755212 Gose, John, of Lodelowe, butcher 0
4555445 2217639 2217639 defendant Girrys John   755212 755212 Girrys, John, of Lodelowe 0
4560219 2219146 2219146 plaintiff Munton Roger furbisher 755212 755212 Munton, Roger, of Lodelowe, furbisher 0
4560220 2219146 2219146 defendant Bordon John   755212 755212 Bordon, John, of Lodelowe 0
4561341 2219495 2219495 plaintiff Parys William   755212 755212 Parys, William, of Lodelowe 0
4561349 2219496 2219496 plaintiff Parys William   755212 755212 Parys, William, of Lodelowe 0
4563163 2220046 2220046 plaintiff Wolf Walter   755212 755212 Wolf, Walter, of Lodelowe 2
4565611 2220814 2220814 defendant Mere Thomas   755212 755212 Mere, Thomas, of Lodelowe 0
4565612 2220814 2220814 defendant Chamberleyn Thomas walker 755212 755212 Chamberleyn, Thomas, of Lodelowe, walker 1
4565613 2220814 2220814 defendant Motyngham John dyer 755212 755212 Motyngham, John, of Lodelowe, dyer 2
4576091 2224020 2224020 plaintiff Brid John   755212 755212 Brid, John, of Lodelowe 0
4579654 2225123 2225123 plaintiff Courtre Thomas mercer 755212 755212 Courtre, Thomas, of Lodelowe, mercer 0
4579655 2225123 2225123 defendant Pyrfeld John   755212 755212 Pyrfeld, John, of Lodelowe 0
4579745 2225153 2225153 plaintiff Cresset William   755212 755212 Cresset, William, of Lodelowe 0
4579750 2225154 2225154 plaintiff Cresset William   755212 755212 Cresset, William, of Lodelowe 0
4591580 2228727 2228727 defendant Herdeleye Richard de   755212 755212 Herdeleye, Richard de, of Lodelowe 2
4593408 2229225 2229225 plaintiff Parys William   755212 755212 Parys, William, of Lodelowe 0
4606032 2233003 2233003 defendant Somp Richard   755212 755212 Somp, Richard, of Lodelowe 1
4606033 2233003 2233003 defendant Kyde William   755212 755212 Kyde, William, of Lodelowe 2
4606658 2233192 2233192 plaintiff Barbon Robert   755212 755212 Barbon, Robert, of Lodelowe 0
4617969 2236626 2236626 defendant Gyrrys John   755212 755212 Gyrrys, John, of Lodelowe 0
4623435 2238304 2238304 plaintiff Mere Thomas merchant 755212 755212 Mere, Thomas, of Lodelowe, merchant 0
4657171 2248128 2248128 defendant Southwode John dyer 755212 755212 Southwode, John, of Lodelowe, dyer 0
4664573 2250400 2250400 plaintiff Harryes Roger   755212 755212 Harryes, Roger, of Lodelowe 0
4664574 2250400 2250400 defendant Pegeon Thomas barker 755212 755212 Pegeon, Thomas, of Lodelowe, barker 0
4745906 2279308 2279308 defendant Ludford John weaver 755212 755212 Ludford, John, of Lodelowe, weaver 0
4748614 2280093 2280093 plaintiff Mere Thomas (legal representative) 755212 755212 Mere, Thomas, of Lodelowe, executors of 0
4780192 2289803 2289803 defendant Skynner John yeoman 755212 755212 Skynner, John, of Lodelowe, yeoman 0
4781952 2290361 2290361 plaintiff Laurence John, junior   755212 755212 (Laurence, John, junior, of Lodelowe 1
4782519 2290542 2290542 plaintiff Corbet Thomas (legal representative) 755212 755212 Corbet, Thomas, of Lodelowe, administrator of 0
4782531 2290546 2290546 defendant Colewall John, junior vintner 755212 755212 Colewall, John, junior, of Lodelowe, vintner 0
4789504 2292786 2292786 defendant Laurence John, senior draper 755212 755212 Laurence, John, senior, of Lodelowe, draper 0
4789506 2292787 2292787 defendant Laurence John, senior draper 755212 755212 Laurence, John, senior, of Lodelowe, draper 0
4792280 2293673 2293673 plaintiff Merewall Walter walker 755212 755212 Merewall, Walter, of Lodelowe, walker 0
4792587 2293772 2293772 defendant Hatton John butcher 755212 755212 Hatton, John, of Lodelowe, butcher 0
4792655 2293792 2293792 plaintiff More John mercer 755212 755212 More, John, of Lodelowe, mercer 0
4799201 2295931 2295931 defendant Pope William walker 755212 755212 Pope, William, of Lodelowe, walker 1
4800721 2296410 2296410 defendant Mere Robert vintner 755212 755212 Mere, Robert, of Lodelowe, vintner 0
4800722 2296410 2296410 defendant Merewall Walter walker 755212 755212 Merewall, Walter, of Lodelowe, walker 1
4800723 2296410 2296410 defendant Longeforth John walker 755212 755212 Longeforth, John, of Lodelowe, walker 2
4802507 2296972 2296972 defendant Pusselowe Thomas, senior   755212 755212 Pusselowe, Thomas, senior, of Lodelowe, school master 0
4803219 2297198 2297198 defendant Shraweley John (legal representative) 755212 755212 Shraweley, John, of Lodelowe, baker, executrix of 2
4803230 2297203 2297203 plaintiff Barbour Walter barber 755212 755212 Barbour, Walter, of Lodelowe, barber 0
4803235 2297204 2297204 plaintiff Barbour Walter barber 755212 755212 Barbour, Walter, of Lodelowe, barber 0
4803237 2297204 2297204 defendant Munselowe John yeoman 755212 755212 Munselowe, John, of Lodelowe, yeoman 1
4803239 2297204 2297204 defendant Taillour Clement tailor 755212 755212 Taillour, Clement, of Lodelowe, tailor 3
4805114 2297801 2297801 defendant Cole Thomas weaver 755212 755212 Cole, Thomas, of Lodelowe, weaver 0
4805610 2297963 2297963 defendant Graunger John   755212 755212 Graunger, John, of Lodelowe, servant 0
4811862 2299823 2299823 plaintiff Glover John   755212 755212 Glover, John, of Lodelowe 0
4811863 2299823 2299823 defendant Glover Clement glover 755212 755212 Glover, Clement, of Lodelowe, glover 0
4813414 2300309 2300309 defendant Dunnewode Walter sheerman 755212 755212 Dunnewode, Walter, of Lodelowe, sheerman 0
4823853 2303541 2303541 defendant Taillour John tailor 755212 755212 Taillour, John, of Lodelowe, tailor 0
4833811 2306582 2306582 plaintiff Cokkys Thomas   755212 755212 Cokkys, Thomas, of Lodelowe 0
4856179 2313306 2313306 defendant Monslowe William yeoman 755212 755212 Monslowe, William, of Lodelowe, yeoman 0
4856180 2313306 2313306 defendant Typper William mercer 755212 755212 Typper, William, of Lodelowe, mercer 1
4865929 2316316 2316316 defendant Mere Robert vintner 755212 755212 Mere, Robert, of Lodelowe, vintner 0
4869960 2317579 2317579 defendant Meyr Robert vintner 755212 755212 Meyr, Robert, of Lodelowe, vintner 0
4869961 2317579 2317579 defendant Hatton John butcher 755212 755212 Hatton, John, of Lodelowe, butcher 1
4869962 2317579 2317579 defendant Taillour Geoffrey tailor 755212 755212 Taillour, Geoffrey, of Lodelowe, tailor 2
4869963 2317579 2317579 defendant Taillour John tailor 755212 755212 Taillour, John, of Lodelowe, tailor 3
4874838 2319071 2319071 defendant Whitton John gent 755212 755212 Whitton, John, of Lodelowe, gent 0
4877586 2319947 2319947 defendant Mere Robert vintner 755212 755212 Mere, Robert, of Lodelowe, merchant, former apprentice of Mere, Thomas, of Lodelow, Salop, vintner 1
4877591 2319948 2319948 defendant Mere Robert vintner 755212 755212 Mere, Robert, of Lodelowe, merchant, former apprentice of Mere, Thomas, of Lodelow, Salop, vintner 1
4897343 2325828 2325828 defendant Bolesdon Thomas (legal representative) 755212 755212 Bolesdon, Thomas, of Lodelowe, saddler, executors of 0
4897344 2325828 2325828 defendant Bolesdon Agnes widow 755212 755212 (Bolesdon, Agnes, of Lodelowe, widow 1
4937190 2338000 2338000 plaintiff Broune John   755212 755212 Broune, John, of Lodelowe, millward 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);