names

123 rows where place_id = 760686

✎ 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
4472236 2191985 2191985 plaintiff Clyve Thomas   760686 760686 Clyve, Thomas, of Haveryng atte Boure 0
4478423 2193925 2193925 defendant Rycher William   760686 760686 Rycher, William, of Haveryng atte Boure 0
4493622 2198706 2198706 defendant Pounde Adam   760686 760686 Pounde, Adam, of Haveryng atte Boure 3
4512030 2204204 2204204 plaintiff Bokenham John   760686 760686 Bokenham, John, of Haveryng atte Boure 0
4541192 2213141 2213141 defendant Brody John carpenter 760686 760686 Brody, John, of Haveryng atte Boure, carpenter 0
4542137 2213430 2213430 defendant Wycheden Walter   760686 760686 Wycheden, Walter, of Haveryng atte Boure 0
4543442 2213839 2213839 defendant Gore Robert   760686 760686 Gore, Robert, of Haveryng atte Boure 0
4560901 2219363 2219363 plaintiff Olyve Thomas   760686 760686 Olyve, Thomas, of Haveryng atte Boure 0
4561383 2219507 2219507 defendant Love John esq 760686 760686 Love, John, of Haveryng atte Boure, esq 0
4664315 2250321 2250321 defendant Turk John husbandman 760686 760686 Turk, John, of Haveryng atte Boure, husbandman 0
4677399 2258547 2258547 defendant Emery John fishman 760686 760686 Emery, John, of Haveryng atte Boure, fishman 0
4694535 2263787 2263787 defendant Emory John husbandman 760686 760686 Emory, John, of Haveryng atte Boure, husbandman 0
4694536 2263787 2263787 defendant Sancry John husbandman 760686 760686 Sancry, John, of Haveryng atte Boure, husbandman 1
4719046 2271304 2271304 defendant Emery John husbandman 760686 760686 Emery, John, of Haveryng atte Boure, husbandman 1
4719697 2271507 2271507 defendant Savery John husbandman 760686 760686 Savery, John, of Haveryng atte Boure, husbandman 0
4729839 2274538 2274538 defendant Passelewe Roger husbandman 760686 760686 Passelewe, Roger, of Haveryng atte Boure, husbandman 0
4744379 2278881 2278881 defendant Aylemare Thomas pulter or skinner 760686 760686 Aylemare, Thomas, of Haveryng atte Boure, pulter or skinner 0
4755325 2282055 2282055 plaintiff atte Melle John tailor 760686 760686 atte Melle, John, of Haveryng atte Boure, tailor 0
4755326 2282055 2282055 defendant Uphaveryng Ralph gent 760686 760686 Uphaveryng, Ralph, of Haveryng atte Boure, gent 0
4764707 2284949 2284949 defendant Trot John butcher 760686 760686 Trot, John, of Haveryng atte Boure, butcher 1
4774145 2287901 2287901 plaintiff Turk John   760686 760686 Turk, John, of Haveryng atte Boure 0
4774153 2287902 2287902 plaintiff Turk John   760686 760686 Turk, John, of Haveryng atte Boure 0
4774161 2287903 2287903 plaintiff Turk John   760686 760686 Turk, John, of Haveryng atte Boure 0
4774266 2287935 2287935 plaintiff Tyk John   760686 760686 Tyk, John, of Haveryng atte Boure 0
4777224 2288863 2288863 plaintiff atte Melle John tailor 760686 760686 atte Melle, John, of Haveryng atte Boure, tailor 0
4777225 2288863 2288863 defendant Uphaveryng Ralph gent 760686 760686 Uphaveryng, Ralph, of Haveryng atte Boure, gent 0
4778560 2289277 2289277 defendant Edulf Thomas   760686 760686 Edulf, Thomas, of Haveryng atte Boure, servant 0
4778562 2289278 2289278 defendant Edulf Thomas   760686 760686 Edulf, Thomas, of Haveryng atte Boure, servant 0
4778563 2289278 2289278 defendant Aylemere Thomas pulter 760686 760686 Aylemere, Thomas, of Haveryng atte Boure, pulter 1
4785361 2291437 2291437 defendant Bret John laborer 760686 760686 Bret, John, of Haveryng atte Boure, laborer 1
4788139 2292363 2292363 defendant Trot Maud   760686 760686 Trot, Maud, of Haveryng atte Boure, widow of Trot, William 0
4788821 2292560 2292560 defendant Trotte John husbandman 760686 760686 Trotte, John, of Haveryng atte Boure, husbandman 0
4791629 2293477 2293477 defendant Fullere John summoner 760686 760686 Fullere, John, of Haveryng atte Boure, summoner 3
4809845 2299241 2299241 defendant Huntyng John   760686 760686 with Huntyng, John, of Haveryng atte Boure 1
4820590 2302513 2302513 defendant Holwell John fisher 760686 760686 Holwell, John, of Haveryng atte Boure, fisher 0
4820592 2302514 2302514 defendant Holwelle William hostiler 760686 760686 Holwelle, William, of Haveryng atte Boure, hostiler 0
4831848 2305982 2305982 defendant Serle William husbandman 760686 760686 Serle, William, of Haveryng atte Boure, husbandman 0
4874590 2318999 2318999 defendant Holwelle John fisher 760686 760686 Holwelle, John, of Haveryng atte Boure, fisher 0
4874591 2318999 2318999 defendant Holwelle William ostler 760686 760686 Holwelle, William, of Haveryng atte Boure, ostler 1
4885288 2322287 2322287 defendant Holwelle John fisher 760686 760686 Holwelle, John, of Haveryng atte Boure, fisher 0
4891524 2324085 2324085 defendant Bereman John yeoman 760686 760686 Bereman, John, of Haveryng atte Boure, yeoman 0
4896082 2325435 2325435 defendant Bappes Thomas husbandman 760686 760686 Bappes, Thomas, of Haveryng atte Boure, husbandman 0
4896083 2325435 2325435 defendant Marchall William laborer 760686 760686 Marchall, William, of Haveryng atte Boure, laborer 1
4896084 2325435 2325435 defendant Goldsmyth Richard husbandman 760686 760686 Goldsmyth, Richard, of Haveryng atte Boure, husbandman 2
4896085 2325435 2325435 defendant Bocher John husbandman 760686 760686 Bocher, John, of Haveryng atte Boure, husbandman 3
4896086 2325435 2325435 defendant Strete John husbandman 760686 760686 Strete, John, of Haveryng atte Boure, husbandman 4
4896087 2325435 2325435 defendant Quylter Reginald husbandman 760686 760686 Quylter, Reginald, of Haveryng atte Boure, husbandman 5
4898057 2326062 2326062 defendant Holwelle John ostler 760686 760686 Holwelle, John, of Haveryng atte Boure, ostler 0
4899098 2326360 2326360 plaintiff Wolff Robert   760686 760686 Wolff, Robert, of Haveryng atte Boure 0
4899657 2326524 2326524 defendant Hasilwell John husbandman 760686 760686 Hasilwell, John, of Haveryng atte Boure, husbandman 3
4899658 2326524 2326524 defendant Balgy Reginald yeoman 760686 760686 Balgy, Reginald, of Haveryng atte Boure, yeoman 4
4902150 2327283 2327283 defendant Cok John husbandman 760686 760686 Cok, John, of Haveryng atte Boure, husbandman 0
4904122 2327901 2327901 defendant Goldsmyth John yeoman 760686 760686 Goldsmyth, John, of Haveryng atte Boure, yeoman 0
4906284 2328553 2328553 defendant Wolff Robert husbandman 760686 760686 Wolff, Robert, of Haveryng atte Boure, husbandman 0
4912181 2330310 2330310 defendant Cappys John husbandman 760686 760686 Cappys, John, of Haveryng atte Boure, husbandman 0
4917869 2332099 2332099 defendant Uphaveryng John   760686 760686 Uphaveryng, John, of Haveryng atte Boure, husbandman & brother of Thomas, Uphaveryng, of Haveryng atte Boure 0
4923151 2333658 2333658 defendant atte Ree Robert husbandman 760686 760686 atte Ree, Robert, of Haveryng atte Boure, husbandman 0
4925906 2334533 2334533 defendant Wolff Robert husbandman 760686 760686 Wolff, Robert, of Haveryng atte Boure, husbandman 0
4927032 2334883 2334883 defendant Holwelle John fisher 760686 760686 Holwelle, John, of Haveryng atte Boure, fisher 0
4927034 2334884 2334884 defendant Holwelle William hosteler 760686 760686 Holwelle, William, of Haveryng atte Boure, hosteler 0
4928645 2335388 2335388 defendant Stace Julia widow 760686 760686 Stace, Julia, of Haveryng atte Boure, widow 0
4928646 2335388 2335388 defendant Balgy Reginald yeoman 760686 760686 Balgy, Reginald, of Haveryng atte Boure, yeoman 1
4928680 2335396 2335396 defendant Stace Julia widow 760686 760686 Stace, Julia, of Haveryng atte Boure, widow 0
4928681 2335396 2335396 defendant Balgy Reginald yeoman 760686 760686 Balgy, Reginald, of Haveryng atte Boure, yeoman 1
4946798 2341001 2341001 defendant Benton John maltman 760686 760686 Benton, John, of Haveryng atte Boure, maltman 1
4950242 2342040 2342040 defendant Capes Thomas husbandman 760686 760686 Capes, Thomas, of Haveryng atte Boure, husbandman 1
4951810 2342516 2342516 defendant Holwelle John fisher 760686 760686 Holwelle, John, of Haveryng atte Boure, fisher 0
4964078 2346167 2346167 defendant Chaterton Henry esq 760686 760686 Chaterton, Henry, of Haveryng atte Boure, esq 0
4976243 2349846 2349846 defendant Lorkyn John husbandman 760686 760686 Lorkyn, John, of Haveryng atte Boure, husbandman 0
4976244 2349846 2349846 defendant Walyron John husbandman 760686 760686 Walyron, John, of Haveryng atte Boure, husbandman 1
4986460 2352878 2352878 plaintiff Aylemer Thomas yeoman 760686 760686 Aylemer, Thomas, of Haveryng atte Boure, yeoman 0
4986462 2352878 2352878 defendant Stace William husbandman 760686 760686 Stace, William, of Haveryng atte Boure, husbandman 1
5000488 2357012 2357012 defendant Tapur Edmund butcher 760686 760686 Tapur, Edmund, of Haveryng atte Boure, butcher 0
5000489 2357012 2357012 defendant Haweley John butcher 760686 760686 Haweley, John, of Haveryng atte Boure, butcher 1
5002888 2357749 2357749 defendant Person Richard husbandman 760686 760686 Person, Richard, of Haveryng atte Boure, husbandman 1
5002894 2357751 2357751 defendant Colyn John husbandman 760686 760686 Colyn, John, of Haveryng atte Boure, husbandman 0
5006296 2358738 2358738 defendant Joy John yeoman 760686 760686 Joy, John, of Haveryng atte Boure, yeoman 2
5009861 2359761 2359761 defendant atte Fryth Ralph (legal representative) 760686 760686 atte Fryth, Ralph, of Haveryng atte Boure, carpenter, executors of 1
5009862 2359761 2359761 defendant Wryght Richard husbandman 760686 760686 (Wryght, Richard, of Haveryng atte Boure, husbandman 2
5018767 2362378 2362378 defendant Walden John husbandman 760686 760686 Walden, John, of Haveryng atte Boure, husbandman 0
5019687 2362639 2362639 defendant Chatirton Henry gent 760686 760686 Chatirton, Henry, of Haveryng atte Boure, gent 0
5023201 2363686 2363686 defendant Strete Thomas husbandman 760686 760686 Strete, Thomas, of Haveryng atte Boure, husbandman 1
5023686 2363835 2363835 defendant Oterton Robert yeoman 760686 760686 Oterton, Robert, of Haveryng atte Boure, yeoman 0
5031449 2366055 2366055 defendant Wynter John yeoman 760686 760686 Wynter, John, of Haveryng atte Boure, yeoman 0
5060769 2374802 2374802 defendant Haweley John   760686 760686 Haweley, John, of Haveryng atte Boure, tile maker 0
5060770 2374802 2374802 defendant Broune Robert butcher 760686 760686 Broune, Robert, of Haveryng atte Boure, butcher 1
5060773 2374802 2374802 defendant Taper Edmund husbandman 760686 760686 Taper, Edmund, of Haveryng atte Boure, husbandman 4
5060843 2374817 2374817 defendant Marshall John clothier 760686 760686 Marshall, John, of Haveryng atte Boure, clothier 0
5076564 2379494 2379494 defendant Heyward John tanner 760686 760686 Heyward, John, of Haveryng atte Boure, tanner 3
5090274 2383531 2383531 defendant Herde John smith 760686 760686 Herde, John, of Haveryng atte Boure, smith 0
5090275 2383531 2383531 defendant Spenser Robert yeoman 760686 760686 Spenser, Robert, of Haveryng atte Boure, yeoman 1
5103149 2387346 2387346 defendant Cappys John, senior husbandman 760686 760686 Cappys, John, senior, of Haveryng atte Boure, husbandman 0
5114594 2390678 2390678 defendant Neweman Thomas husbandman 760686 760686 Neweman, Thomas, of Haveryng atte Boure, husbandman 0
5114596 2390679 2390679 defendant Neweman Thomas husbandman 760686 760686 Neweman, Thomas, of Haveryng atte Boure, husbandman 0
5116458 2391247 2391247 defendant Hwett James   760686 760686 Hwett, James, of Haveryng atte Boure 1
5117107 2391429 2391429 defendant Hierde John yeoman 760686 760686 Hierde, John, of Haveryng atte Boure, yeoman 1
5117111 2391430 2391430 defendant Hierde John yeoman 760686 760686 Hierde, John, of Haveryng atte Boure, yeoman 1
5119161 2392033 2392033 defendant Gobyon John husbandman 760686 760686 Gobyon, John, of Haveryng atte Boure, husbandman 0
5119174 2392037 2392037 defendant Wryght John husbandman 760686 760686 Wryght, John, of Haveryng atte Boure, husbandman 0
5122139 2392896 2392896 defendant Payn William husbandman 760686 760686 Payn, William, of Haveryng atte Boure, husbandman 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);