names

108 rows where place_id = 591392

✎ 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
3604275 1869000 1869000 defendant Kent William yeoman or chaplain 591392 591392 Kent, William, of Bradeford, yeoman or chaplain 0
3607020 1869860 1869860 defendant Glanvyle Thomas yeoman 591392 591392 Glanvyle, Thomas, of Bradeford, yeoman 1
3607022 1869860 1869860 defendant Garlond Thomas yeoman 591392 591392 (Garlond, Thomas, of Bradeford, yeoman 3
3607498 1870004 1870004 defendant Glanvyle Thomas yeoman 591392 591392 Glanvyle, Thomas, of Bradeford, yeoman 1
3624637 1875240 1875240 defendant Hall Thomas esq 591392 591392 Hall, Thomas, of Bradeford, esq 0
4419670 2171044 2171044 defendant atte Halle Thomas   591392 591392 atte Halle, Thomas, of Bradeford 0
4431230 2174528 2174528 defendant atte Halle Thomas   591392 591392 atte Halle, Thomas, of Bradeford 0
4432485 2174930 2174930 plaintiff Dabnoun John   591392 591392 Dabnoun, John, of Bradeford 0
4434165 2175448 2175448 plaintiff Middelton John de   591392 591392 Middelton, John de, of Bradeford, parson 1
4436571 2176175 2176175 defendant Frensch William   591392 591392 Frensch, William, of Bradeford 0
4444849 2183363 2183363 plaintiff Cook Richard   591392 591392 Cook, Richard, of Bradeford 0
4455324 2186671 2186671 defendant Sant Adam   591392 591392 Sant, Adam, of Bradeford 0
4489080 2197303 2197303 plaintiff Tapener John   591392 591392 Tapener, John, of Bradeford 0
4494624 2199011 2199011 defendant Aylregge John smith 591392 591392 Aylregge, John, of Bradeford, smith 0
4495647 2199319 2199319 defendant Cable Edward   591392 591392 Cable, Edward, of Bradeford 0
4502941 2201489 2201489 plaintiff Norton John   591392 591392 Norton, John, of Bradeford 0
4502942 2201489 2201489 defendant Norton William   591392 591392 Norton, William, of Bradeford 0
4522005 2207222 2207222 defendant Dyer John   591392 591392 Dyer, John, of Bradeford 1
4530316 2209769 2209769 defendant Gardener Roger   591392 591392 Gardener, Roger, of Bradeford 0
4530321 2209770 2209770 defendant Gardener Roger   591392 591392 Gardener, Roger, of Bradeford 0
4535060 2211243 2211243 plaintiff Shepton John   591392 591392 Shepton, John, of Bradeford 0
4536088 2211564 2211564 defendant Dyer John   591392 591392 Dyer, John, of Bradeford 1
4539157 2212502 2212502 defendant Growe Robert   591392 591392 Growe, Robert, of Bradeford 0
4542588 2213568 2213568 defendant Taillour William   591392 591392 Taillour, William, of Bradeford 0
4560448 2219210 2219210 plaintiff Couk Richard merchant 591392 591392 Couk, Richard, of Bradeford, merchant 1
4573035 2223102 2223102 plaintiff Bakere John   591392 591392 Bakere, John, of Bradeford 0
4598475 2230761 2230761 defendant Dyer John   591392 591392 Dyer, John, of Bradeford 2
4624641 2238688 2238688 defendant Chepman John   591392 591392 Chepman, John, of Bradeford 4
4624647 2238689 2238689 defendant Chepman John   591392 591392 Chepman, John, of Bradeford 4
4627866 2239644 2239644 defendant Piers Thomas   591392 591392 Piers, Thomas, of Bradeford 1
4636262 2242173 2242173 defendant Waskam Robert   591392 591392 (Waskam, Robert, of Bradeford, vicar 1
4636263 2242173 2242173 defendant Raffall Thomas   591392 591392 Raffall, Thomas, of Bradeford, millward 2
4653052 2246887 2246887 defendant Palmer William mercer 591392 591392 Palmer, William, of Bradeford, mercer 0
4653064 2246891 2246891 defendant Spirwyt Joan   591392 591392 Spirwyt, Joan, of Bradeford 0
4663719 2250136 2250136 defendant Mundy Walter laborer 591392 591392 Mundy, Walter, of Bradeford, laborer 0
4666355 2250952 2250952 defendant Sompnour Robert chapman 591392 591392 Sompnour, Robert, of Bradeford, chapman 0
4667914 2255665 2255665 defendant Chapeleyn John husbandman 591392 591392 Chapeleyn, John, of Bradeford, husbandman 0
4669090 2256040 2256040 defendant Rogers William husbandman 591392 591392 Rogers, William, of Bradeford, husbandman 0
4691145 2262750 2262750 defendant Deneys Thomas gent 591392 591392 Deneys, Thomas, of Bradeford, gent 0
4693128 2263355 2263355 defendant Deneys Thomas gent 591392 591392 Deneys, Thomas, of Bradeford, gent 0
4694674 2263831 2263831 defendant Noreys Walter husbandman 591392 591392 Noreys, Walter, of Bradeford, husbandman 4
4695381 2264034 2264034 defendant Wyseman William glasier 591392 591392 Wyseman, William, of Bradeford, glasier 4
4698896 2265135 2265135 plaintiff Deneys Thomas   591392 591392 Deneys, Thomas, of Bradeford 0
4717385 2270776 2270776 defendant Hiptrotte Henry merchant 591392 591392 Hiptrotte, Henry, of Bradeford, merchant 0
4717903 2270940 2270940 defendant Whateley Nicholas fuller 591392 591392 Whateley, Nicholas, of Bradeford, fuller 0
4718311 2271066 2271066 defendant Deneys Thomas gent 591392 591392 Deneys, Thomas, of Bradeford, gent 0
4718532 2271135 2271135 defendant Deyer John dyer 591392 591392 Deyer, John, of Bradeford by Dorchester, dyer 2
4723449 2272644 2272644 plaintiff Deneys Thomas   591392 591392 Deneys, Thomas, of Bradeford 0
4723956 2272792 2272792 plaintiff Deneys Thomas   591392 591392 Deneys, Thomas, of Bradeford 1
4724744 2273036 2273036 defendant Cardemaker Robert cardmaker 591392 591392 Cardemaker, Robert, of Bradeford, cardmaker 0
4733858 2275771 2275771 defendant Giffard John husbandman 591392 591392 Giffard, John, of Bradeford, husbandman 0
4739873 2277546 2277546 defendant Hiptrotte Henry merchant 591392 591392 Hiptrotte, Henry, of Bradeford, merchant 0
4755913 2282233 2282233 defendant Wastell Walter husbandman 591392 591392 Wastell, Walter, of Bradeford, husbandman 0
4762037 2284111 2284111 defendant Assheley Robert gent 591392 591392 Assheley, Robert, of Bradeford, gent 0
4780889 2290024 2290024 defendant Plomer Thomas husbandman 591392 591392 Plomer, Thomas, of Bradeford, husbandman 0
4780890 2290024 2290024 defendant Godefere William husbandman 591392 591392 Godefere, William, of Bradeford, husbandman 1
4782451 2290519 2290519 defendant Kynnok David laborer 591392 591392 Kynnok, David, of Bradeford, laborer 0
4824465 2303701 2303701 plaintiff Peprson John   591392 591392 Peprson, John, of Bradeford 2
4824470 2303702 2303702 plaintiff Peprson John   591392 591392 Peprson, John, of Bradeford 2
4829093 2305141 2305141 plaintiff Aysshcomb William   591392 591392 Aysshcomb, William, of Bradeford 0
4830282 2305509 2305509 defendant Slade Richard husbandman 591392 591392 Slade, Richard, of Bradeford, husbandman 0
4834010 2306642 2306642 defendant Helyer Walter   591392 591392 Helyer, Walter, of Bradeford, bailiff 3
4852272 2312136 2312136 defendant Waskam Robert husbandman 591392 591392 Waskam, Robert, of Bradeford, husbandman 0
4852273 2312136 2312136 defendant Spencer Richard husbandman 591392 591392 Spencer, Richard, of Bradeford, husbandman 1
4852274 2312136 2312136 defendant Gardener William husbandman 591392 591392 Gardener, William, of Bradeford, husbandman 2
4852275 2312136 2312136 defendant Mille John husbandman 591392 591392 Mille, John, of Bradeford, husbandman 3
4852276 2312136 2312136 defendant Videshade John husbandman 591392 591392 Videshade, John, of Bradeford, husbandman 4
4857444 2313716 2313716 defendant Smyth Richard husbandman 591392 591392 Smyth, Richard, of Bradeford, husbandman 0
4877800 2320020 2320020 defendant Helyer Walter husbandman 591392 591392 Helyer, Walter, of Bradeford, husbandman 1
4885496 2322346 2322346 defendant Boucher John butcher 591392 591392 Boucher, John, of Bradeford, butcher 0
4893082 2324554 2324554 defendant Helyer Walter husbandman 591392 591392 Helyer,Walter, of Bradeford, husbandman 1
4905811 2328420 2328420 defendant Bonde Richard yeoman 591392 591392 Bonde, Richard, of Bradeford, yeoman 0
4917515 2331993 2331993 plaintiff Geffrey Thomas husbandman 591392 591392 Geffrey, Thomas, of Bradeford, husbandman 0
4917516 2331993 2331993 defendant Geffrey Thomas husbandman 591392 591392 Geffrey, Thomas, of Bradeford, husbandman 0
4953318 2342956 2342956 defendant Tyler Thomas helyer or roofer 591392 591392 Tyler, Thomas, of Bradeford, helyer or roofer 0
4957571 2344237 2344237 defendant Assheley Edmund gent 591392 591392 Assheley, Edmund, of Bradeford, gent 0
4964213 2346198 2346198 defendant Deneys Gilbert gent 591392 591392 Deneys, Gilbert, of Bradeford, gent 0
4964953 2346432 2346432 defendant Hippetrot Henry merchant 591392 591392 Hippetrot, Henry, of Bradeford, merchant 0
4966693 2346971 2346971 defendant Hiptrot Henry chapman 591392 591392 Hiptrot, Henry, of Bradeford, chapman 0
4987957 2353366 2353366 defendant Hiptrot Henry merchant 591392 591392 Hiptrot, Henry, of Bradeford, merchant 1
4989048 2353662 2353662 defendant Denys Gilbert gent 591392 591392 Denys, Gilbert, of Bradeford, gent 0
4989766 2353857 2353857 defendant Norton John dyer 591392 591392 Norton, John, of Bradeford, dyer 0
4990858 2354156 2354156 defendant Deneys Gilbert gent 591392 591392 Deneys, Gilbert, of Bradeford, gent 0
4991167 2354246 2354246 defendant Perys Henry husbandman 591392 591392 Perys, Henry, of Bradeford, husbandman 0
5005622 2358542 2358542 defendant Weryng William husbandman 591392 591392 Weryng, William, of Bradeford, husbandman 0
5010089 2359818 2359818 defendant Clerke Thomas weaver 591392 591392 Clerke, Thomas, of Bradeford, weaver 0
5010450 2359930 2359930 defendant Hippetrot Henry chapman 591392 591392 Hippetrot, Henry, of Bradeford, chapman 1
5011119 2360104 2360104 defendant Alford William laborer 591392 591392 Alford, William, of Bradeford, laborer 0
5011772 2360293 2360293 defendant Alford William husbandman 591392 591392 Alford, William, of Bradeford, husbandman 0
5019314 2362538 2362538 defendant Boteler John   591392 591392 Boteler, John, of Bradeford, bailiff 2
5055524 2373233 2373233 defendant Touker James tucker 591392 591392 Touker, James, of Bradeford, tucker 0
5057773 2373895 2373895 defendant Gyrne John laborer 591392 591392 Gyrne, John, of Bradeford, laborer 0
5164102 2405234 2405234 defendant Swete Thomas glasier 591392 591392 Swete, Thomas, of Bradeford, glasier 0
5187790 2412148 2412148 defendant Salisbury William glasier 591392 591392 Salisbury, William, of Bradeford Abbot, glasier 0
5244190 2428496 2428496 defendant Swete Thomas glasier 591392 591392 Swete, Thomas, of Bradeford, glasier 0
5259840 2433199 2433199 defendant Hamelyn Thomas gent 591392 591392 Hamelyn, Thomas, of Bradeford, gent 0
5330347 2454152 2454152 defendant Palmer William mercer 591392 591392 Palmer, William, of Bradeford, mercer 0
5330348 2454152 2454152 defendant Taylour William draper 591392 591392 Taylour, William, of Bradeford, draper 1
5330349 2454152 2454152 defendant Preston John mercer 591392 591392 Preston, John, of Bradeford, mercer 2
5505169 2506526 2506526 defendant Glanvyle Thomas husbandman 591392 591392 Glanvyle, Thomas, of Bradeford, husbandman 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);