names

107 rows where place_id = 589060

✎ 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
3596397 1866503 1866503 defendant Bygge John miller 589060 589060 Bygge, John, of Wantynge, miller 3
3863558 1978005 1978005 defendant Sarneham Stephen yeoman 589060 589060 Sarneham, Stephen, of Wantynge, yeoman 1
3863559 1978005 1978005 defendant Radige Nicholas yeoman 589060 589060 Radige, Nicholas, of Wantynge, yeoman 2
3863560 1978005 1978005 defendant Aldeworthe Robert yeoman 589060 589060 Aldeworthe, Robert, of Wantynge, yeoman 3
3916506 1995897 1995897 defendant Radysshe Nicholas yeoman 589060 589060 Radysshe, Nicholas, of Wantynge, yeoman 0
3927177 1999424 1999424 plaintiff Aldeworthe Robert, senior tanner 589060 589060 Aldeworthe, Robert, senior, of Wantynge, tanner 0
4474786 2192783 2192783 plaintiff Dycon Richard   589060 589060 Dycon, Richard, of Wantynge, on his own account 0
4547339 2215100 2215100 defendant Taillour John   589060 589060 Taillour, John, of Wantynge 1
4547343 2215101 2215101 defendant Taillour John   589060 589060 Taillour, John, of Wantynge 1
4547347 2215102 2215102 defendant Taillour John   589060 589060 Taillour, John, of Wantynge 1
4604876 2232695 2232695 defendant Rys Philip   589060 589060 Rys, Philip, of Wantynge 1
4606275 2233074 2233074 defendant Lane John   589060 589060 Lane, John, of Wantynge 1
4606278 2233075 2233075 defendant Lane John   589060 589060 Lane, John, of Wantynge 1
4631204 2240658 2240658 defendant Sclatter John   589060 589060 Sclatter, John, of Wantynge 5
4658879 2248649 2248649 defendant Okeborn Alexander husbandman 589060 589060 Okeborn, Alexander, of Wantynge, husbandman 0
4687079 2261561 2261561 defendant Clerk John husbandman 589060 589060 Clerk, John, of Wantynge, husbandman 14
4718928 2271261 2271261 defendant Hardyng William husbandman 589060 589060 Hardyng, William, of Wantynge, husbandman 1
4748161 2279971 2279971 defendant Pleystowe Richard   589060 589060 Pleystowe, Richard, of Wantynge, bailiff 6
4751285 2280853 2280853 defendant Tubbe Richard husbandman 589060 589060 Tubbe, Richard, of Wantynge, husbandman 0
4751286 2280853 2280853 defendant Haryng William husbandman 589060 589060 Haryng, William, of Wantynge, husbandman 1
4777526 2288966 2288966 defendant Prynce Richard shoemaker 589060 589060 Prynce, Richard, of Wantynge, shoemaker 0
4777527 2288966 2288966 defendant Hayward Thomas shoemaker 589060 589060 Hayward, Thomas, of Wantynge, shoemaker 1
4785766 2291585 2291585 defendant Clotheman John   589060 589060 Clotheman, John, of Wantynge, shepherd 0
4789203 2292679 2292679 defendant Hopton Hugh mercer 589060 589060 Hopton, Hugh, of Wantynge, mercer 0
4860777 2314731 2314731 defendant Heler John husbandman 589060 589060 Heler, John, of Wantynge, husbandman 0
4862007 2315132 2315132 defendant Bocher Robert butcher 589060 589060 Bocher, Robert, of Wantynge, butcher 0
4862008 2315132 2315132 defendant Tanner Richard tanner 589060 589060 Tanner, Richard, of Wantynge, tanner 1
4865666 2316225 2316225 defendant Clerk Richard husbandman 589060 589060 Clerk, Richard, of Wantynge, husbandman 0
4872386 2318324 2318324 defendant Crouche William husbandman 589060 589060 Crouche, William, of Wantynge, husbandman 0
4872389 2318325 2318325 defendant Hikkes Roger husbandman 589060 589060 Hikkes, Roger, of Wantynge, husbandman 0
4874784 2319055 2319055 defendant Burymyll Roger weaver 589060 589060 Burymyll, Roger, of Wantynge, weaver 4
4881556 2321132 2321132 defendant Clerk Thomas chapman 589060 589060 Clerk, Thomas, of Wantynge, chapman 1
4881581 2321141 2321141 defendant Baker Walter baker 589060 589060 Baker, Walter, of Wantynge, baker 0
4881582 2321141 2321141 defendant Clothman John weaver 589060 589060 Clothman, John, of Wantynge, weaver 1
4881584 2321142 2321142 defendant Boteler William yeoman 589060 589060 Boteler, William, of Wantynge, yeoman 0
4881585 2321142 2321142 defendant Haukyn Edmund husbandman 589060 589060 Haukyn, Edmund, of Wantynge, husbandman 1
4881586 2321142 2321142 defendant Barnour Thomas barber 589060 589060 Barnour, Thomas, of Wantynge, barber 2
4881587 2321142 2321142 defendant Couper John, junior cooper 589060 589060 Couper, John, junior, of Wantynge, cooper 3
4919358 2332566 2332566 defendant Upton John butcher 589060 589060 Upton, John, of Wantynge, butcher 1
4923558 2333802 2333802 defendant Segar John yeoman 589060 589060 Segar, John, of Wantynge, yeoman 0
4923560 2333802 2333802 defendant Burymyll Roger weaver 589060 589060 Burymyll, Roger, of Wantynge, weaver 2
4923561 2333802 2333802 defendant Castell Ralph weaver 589060 589060 Castell, Ralph, of Wantynge, weaver 3
4923562 2333802 2333802 defendant Hayward Thomas shoemaker 589060 589060 Hayward, Thomas, of Wantynge, shoemaker 4
4926635 2334749 2334749 defendant Segre John   589060 589060 Segre, John, of Wantynge, Berks, bailor 0
4933679 2336911 2336911 defendant Breuhouse William chapman 589060 589060 Breuhouse, William, of Wantynge, chapman 0
4934482 2337177 2337177 defendant Brenhouse or Breuhouse William chapman 589060 589060 Brenhouse or Breuhouse, William, of Wantynge, chapman 0
4935993 2337658 2337658 plaintiff Bocher Robert (legal representative) 589060 589060 Bocher, Robert, of Wantynge, executors of 0
4935995 2337658 2337658 defendant Northe alias Burymyll Roger weaver 589060 589060 Northe alias Burymyll, Roger, of Wantynge, weaver 0
4935996 2337659 2337659 plaintiff Bocher Robert (legal representative) 589060 589060 Bocher, Robert, of Wantynge, executors of 0
4935999 2337659 2337659 defendant Northe alias Burymyll Roger weaver 589060 589060 Northe alias Burymyll, Roger, of Wantynge, weaver 0
4944644 2340308 2340308 defendant Cornewell John tailor 589060 589060 Cornewell, John, of Wantynge, tailor 0
4963070 2345862 2345862 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
4963072 2345862 2345862 defendant Breuhouse William chapman 589060 589060 Breuhouse, William, of Wantynge, chapman 2
4963215 2345906 2345906 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
4963217 2345906 2345906 defendant Breuhouse William chapman 589060 589060 Breuhouse, William, of Wantynge, chapman 2
4969203 2347750 2347750 defendant Brouns Richard husbandman 589060 589060 Brouns, Richard, of Wantynge, husbandman 0
4969413 2347807 2347807 defendant Vyncent Richard barber 589060 589060 Vyncent, Richard, of Wantynge, barber 0
4970856 2348226 2348226 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
4985114 2352474 2352474 defendant Burymyll Roger weaver 589060 589060 Burymyll, Roger, of Wantynge, weaver 0
4985129 2352480 2352480 defendant Skynner Richard   589060 589060 Skynner, Richard, of Wantynge, parchment maker 0
5022723 2363557 2363557 defendant Hykkes Roger husbandman 589060 589060 Hykkes, Roger, of Wantynge, husbandman 1
5026111 2364534 2364534 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
5032531 2366397 2366397 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
5041707 2369121 2369121 defendant Clynche John chapman 589060 589060 Clynche, John, of Wantynge, chapman 3
5051535 2372077 2372077 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
5057543 2373825 2373825 plaintiff Colyns John   589060 589060 Colyns, John, of Wantynge 0
5069309 2377308 2377308 defendant Leycetyr John, junior yeoman 589060 589060 Leycetyr, John, junior, of Wantynge, yeoman 1
5092845 2384286 2384286 defendant Reysyn Philip husbandman 589060 589060 Reysyn, Philip, of Wantynge, husbandman 0
5094192 2384707 2384707 plaintiff Colyns John   589060 589060 Colyns, John, of Wantynge 2
5098226 2385910 2385910 plaintiff Upton John   589060 589060 Upton, John, of Wantynge 0
5098228 2385911 2385911 plaintiff Upton John   589060 589060 Upton, John, of Wantynge 0
5098230 2385912 2385912 plaintiff Upton John   589060 589060 Upton, John, of Wantynge 0
5100510 2386571 2386571 defendant Hyckys William butcher 589060 589060 Hyckys, William, of Wantynge, butcher 0
5102743 2387216 2387216 defendant Bray Robert yeoman 589060 589060 Bray, Robert, of Wantynge, yeoman 1
5112278 2389974 2389974 defendant Payn John (legal representative) 589060 589060 Payn, John, of Wantynge, husbandman, executors of 0
5112279 2389974 2389974 defendant Bedford John husbandman 589060 589060 (Bedford, John, of Wantynge, husbandman 1
5112835 2390149 2390149 defendant Braye Robert merchant 589060 589060 Braye, Robert, of Wantynge, or of Watlyngton, Oxon, merchant 0
5115041 2390817 2390817 defendant Tubbe Robert weaver 589060 589060 Tubbe, Robert, of Wantynge, weaver 1
5117470 2391544 2391544 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
5117476 2391545 2391545 defendant Clynche John draper 589060 589060 Clynche, John, of Wantynge, draper 0
5134704 2396645 2396645 plaintiff Baldewyn Richard   589060 589060 Baldewyn, Richard, of Wantynge 1
5135481 2396890 2396890 plaintiff Merlawe Roger gent 589060 589060 Merlawe, Roger, of Wantynge, gent 0
5142854 2399038 2399038 defendant Clynt John husbandman 589060 589060 Clynt, John, of Wantynge, husbandman 0
5142858 2399039 2399039 defendant Lyrbeke Thomas clerk 589060 589060 Lyrbeke, Thomas, of Wantynge, clerk 0
5159185 2403801 2403801 defendant Clenche John draper 589060 589060 Clenche, John, of Wantynge, draper 3
5215107 2420143 2420143 defendant Upton John husbandman 589060 589060 Upton, John, of Wantynge, husbandman 1
5218956 2421271 2421271 plaintiff Colyns John   589060 589060 (Colyns, John, of Wantynge 1
5245867 2428954 2428954 defendant Clynche John husbandman 589060 589060 Clynche, John, of Wantynge, husbandman 2
5246418 2429116 2429116 defendant Copter William butcher 589060 589060 Copter, William, of Wantynge, butcher 0
5246569 2429159 2429159 defendant Bosbury William corveser 589060 589060 Bosbury, William, of Wantynge, corveser 0
5246571 2429160 2429160 defendant Bosbury William corveser 589060 589060 Bosbury, William, of Wantynge, corveser 0
5279911 2439200 2439200 defendant Davy Richard butcher 589060 589060 Davy, Richard, of Wantynge, butcher 2
5280316 2439321 2439321 defendant Davy Richard husbandman 589060 589060 Davy, Richard, of Wantynge, husbandman 2
5286073 2440934 2440934 defendant Boteler Thomas chapman 589060 589060 Boteler, Thomas, of Wantynge, chapman 2
5286076 2440935 2440935 defendant Boteler Thomas   589060 589060 Boteler, Thomas, of Wantynge, "cappoman" 1
5288292 2441596 2441596 defendant Warner Robert draper 589060 589060 Warner, Robert, of Wantynge, draper 0
5288293 2441596 2441596 defendant Aumey or Armey Thomas draper 589060 589060 Aumey or Armey, Thomas, of Wantynge, draper 1
5289437 2441911 2441911 defendant Chilton alias Chapman William chapman 589060 589060 Chilton alias Chapman, William, of Wantynge, chapman 0
5289438 2441911 2441911 defendant Ameney Thomas tailor 589060 589060 Ameney, Thomas, of Wantynge, tailor 1
5294000 2443219 2443219 defendant Davy Richard butcher 589060 589060 Davy, Richard, of Wantynge, butcher 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);