names

106 rows where place_id = 610479

✎ 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
3683737 1921048 1921048 plaintiff Westhorp Ralph esq 610479 610479 Westhorp, Ralph, of Brompton, esq 0
3750071 1941939 1941939 defendant Boll John husbandman 610479 610479 Boll, John, of Brompton, husbandman 0
3826166 1966025 1966025 defendant Crone Thomas husbandman 610479 610479 Crone, Thomas, of Brompton, husbandman 3
3840534 1970599 1970599 defendant Taylar James yeoman 610479 610479 Taylar, James, of Brompton, yeoman 5
3849956 1973573 1973573 defendant Parker Edward yeoman 610479 610479 Parker, Edward, of Brompton, yeoman 0
3861699 1977374 1977374 defendant Walker Nicholas yeoman 610479 610479 Walker, Nicholas, of Brompton, yeoman 0
3890015 1986897 1986897 plaintiff Harle John esq 610479 610479 Harle, John, of Brompton, esq 0
3923771 1998255 1998255 defendant Muttelowe John husbandman 610479 610479 Muttelowe, John, of Brompton, husbandman 0
3923772 1998255 1998255 defendant Bayton Roger laborer 610479 610479 Bayton, Roger, of Brompton, laborer 1
3934508 2001836 2001836 defendant Carter Roger husbandman 610479 610479 Carter, Roger, of Brompton, husbandman 0
3943448 2004824 2004824 defendant Collyns William yeoman 610479 610479 Collyns, William, of Brompton, yeoman 0
3965587 2012578 2012578 defendant Watkyn Edmund yeoman 610479 610479 Watkyn, Edmund, of Brompton, yeoman 0
4051979 2043128 2043128 defendant Jackson William husbandman 610479 610479 Jackson, William, of Brompton, husbandman 0
4098864 2059922 2059922 defendant ap Owen Owen ap Jevan yeoman 610479 610479 ap Owen, Owen ap Jevan, of Brompton, yeoman 1
4130771 2071314 2071314 defendant Fletome James laborer 610479 610479 Fletome, James, of Brompton, laborer 2
4153594 2079349 2079349 defendant Marshe James shoemaker 610479 610479 Marshe, James, of Brompton, shoemaker 0
4160497 2081745 2081745 defendant Clarke Thomas husbandman 610479 610479 Clarke, Thomas, of Brompton, or of Littell Bromwich, Hopesaye, husbandman 0
4171478 2085489 2085489 defendant Churche Avice widow 610479 610479 (Churche, Avice, of Brompton, widow 1
4172127 2085713 2085713 defendant Carter Roger husbandman 610479 610479 Carter, Roger, of Brompton, husbandman 0
4180679 2088724 2088724 defendant Keyse James, senior yeoman 610479 610479 Keyse, James, senior, of Brompton, yeoman 2
4214750 2100666 2100666 defendant ap John Howell ap Rice gent 610479 610479 ap John, Howell ap Rice, of Brompton, gent 0
4223298 2103641 2103641 defendant Clarke Thomas husbandman 610479 610479 Clarke, Thomas, of Brompton, husbandman 0
4223399 2103677 2103677 defendant Hall James, senior yeoman 610479 610479 Hall, James, senior, of Brompton, yeoman 0
4223400 2103677 2103677 defendant Underwood Thomas yeoman 610479 610479 Underwood, Thomas, of Brompton, yeoman 1
4231784 2106613 2106613 defendant ap John Howell ap Rees gent 610479 610479 ap John, Howell ap Rees, of Brompton, gent 0
4240433 2109778 2109778 defendant Hall James, senior yeoman 610479 610479 Hall, James, senior, of Brompton, yeoman 0
4240434 2109778 2109778 defendant Underwood Thomas yeoman 610479 610479 Underwood, Thomas, of Brompton, yeoman 1
4240435 2109778 2109778 defendant Barwell John yeoman 610479 610479 Barwell, John, of Brompton, yeoman 2
4263645 2117504 2117504 defendant ap John Howell ap Rees gent 610479 610479 ap John, Howell ap Rees, of Brompton, gent 0
4263646 2117504 2117504 defendant ap Howell Edward (legal representative) 610479 610479 ap Howell, Edward, of Brompton, gent, executors of 1
4298537 2129579 2129579 defendant ap Griffith Robert   610479 610479 ap Griffith, Robert, of Brompton, gent, administrators of 0
4329331 2140121 2140121 defendant Powell Ellen widow 610479 610479 Powell, Ellen, of Brompton, widow 2
4372571 2155262 2155262 defendant Massy Francis gent 610479 610479 Massy, Francis, of Brompton, gent 0
4396730 2163472 2163472 defendant Getham John gent 610479 610479 Getham, John, of Brompton, gent 0
4398987 2164244 2164244 defendant Massie Francis yeoman 610479 610479 Massie, Francis, of Brompton, Presteigne, Radnor, yeoman 1
4411361 2168389 2168389 defendant Massy Francis gent 610479 610479 Massy, Francis, of Brompton, gent 1
4450432 2185097 2185097 plaintiff Harkyll John slater 610479 610479 Harkyll, John, of Brompton, slater, on his own account 0
4461500 2188676 2188676 plaintiff Staynton Simon de   610479 610479 Staynton, Simon de, of Brompton, parson 0
4468828 2190925 2190925 defendant Spark Richard   610479 610479 Spark, Richard, of Brompton 0
4468831 2190926 2190926 defendant Sparkes William   610479 610479 Sparkes, William, of Brompton 0
4518122 2206040 2206040 defendant Foche John   610479 610479 Foche, John, of Brompton 0
4522011 2207223 2207223 plaintiff Glover John   610479 610479 Glover, John, of Brompton 0
4528988 2209347 2209347 defendant Westhorp John   610479 610479 Westhorp, John, of Brompton 1
4572459 2222926 2222926 defendant Stone John   610479 610479 Stone, John, of Brompton 0
4612639 2235019 2235019 defendant Skayf John   610479 610479 Skayf, John, of Brompton 1
4655123 2247486 2247486 plaintiff Brette Robert   610479 610479 Brette, Robert, of Brompton 0
4668643 2255905 2255905 defendant Bentlay Thomas husbandman 610479 610479 Bentlay, Thomas, of Brompton, husbandman 1
4686111 2261247 2261247 defendant Nicolson John slater 610479 610479 Nicolson, John, of Brompton, slater 3
4707876 2267834 2267834 plaintiff Moryn John   610479 610479 Moryn, John, of Brompton 0
4715921 2270293 2270293 defendant Beryer William husbandman 610479 610479 Beryer, William, of Brompton, husbandman 0
4720910 2271872 2271872 defendant Beryer Maud widow 610479 610479 Beryer, Maud, of Brompton, widow 3
4767439 2285797 2285797 defendant Croyn Thomas yeoman 610479 610479 Croyn, Thomas, of Brompton, yeoman 1
4772006 2287219 2287219 defendant Rudeshale William husbandman 610479 610479 Rudeshale, William, of Brompton, husbandman 1
4783608 2290890 2290890 defendant Broun William husbandman 610479 610479 Broun, William, of Brompton, husbandman 2
4784369 2291113 2291113 defendant Croyn Thomas yeoman 610479 610479 Croyn, Thomas, of Brompton, yeoman 0
4799257 2295944 2295944 defendant Westhorp Thomas clerk 610479 610479 Westhorp, Thomas, of Brompton, clerk 1
4800798 2296439 2296439 defendant Croyne Thomas yeoman 610479 610479 Croyne, Thomas, of Brompton, yeoman 0
4812817 2300126 2300126 defendant Croyne Thomas yeoman 610479 610479 Croyne, Thomas, of Brompton, yeoman 2
4817821 2301656 2301656 defendant Smyth John husbandman & son of John Smyth 610479 610479 Smyth, John, of Brompton, husbandman & son of John Smyth 3
4819564 2302195 2302195 plaintiff Burgh John   610479 610479 Burgh, John, of Brompton 5
4819572 2302196 2302196 plaintiff Burgh John   610479 610479 Burgh, John, of Brompton 4
4848289 2310937 2310937 defendant Westhorp William gent 610479 610479 Westhorp, William, of Brompton, gent 1
4866690 2316543 2316543 defendant Croyne Thomas yeoman 610479 610479 Croyne, Thomas, of Brompton, yeoman 0
4875914 2319428 2319428 defendant Westhorp William gent 610479 610479 Westhorp, William, of Brompton, gent 0
4901408 2327050 2327050 plaintiff Burgh John   610479 610479 Burgh, John, of Brompton 0
4901576 2327092 2327092 defendant Goldyng John husbandman 610479 610479 Goldyng, John, of Brompton, husbandman 0
4902721 2327470 2327470 defendant Wright John yeoman 610479 610479 Wright, John, of Brompton, yeoman 0
4902722 2327470 2327470 defendant Willughby Richard chaplain 610479 610479 Willughby, Richard, of Brompton, chaplain 1
4902723 2327470 2327470 defendant Whitgest John husbandman 610479 610479 Whitgest, John, of Brompton, husbandman 2
4926419 2334685 2334685 defendant Knardesley William laborer 610479 610479 Knardesley, William, of Brompton, laborer 0
4980493 2351104 2351104 defendant Bysshopryk Thomas barker 610479 610479 Bysshopryk, Thomas, of Brompton, barker 1
4994011 2355081 2355081 defendant North John   610479 610479 North, John, of Brompton 0
4996213 2355723 2355723 defendant Wyot Hugh husbandman 610479 610479 Wyot, Hugh, of Brompton, husbandman 0
5016158 2361610 2361610 defendant Westhorp William gent 610479 610479 Westhorp, William, of Brompton, gent 0
5034300 2366891 2366891 plaintiff Stebbyng William   610479 610479 Stebbyng, William, of Brompton 0
5037937 2367976 2367976 defendant Cartwright William husbandman 610479 610479 Cartwright, William, of Brompton, husbandman 5
5081669 2381025 2381025 defendant Broun Richard husbandman 610479 610479 Broun, Richard, of Brompton, husbandman 0
5081883 2381077 2381077 defendant Brompton John merchant 610479 610479 Brompton, John, of Brompton, merchant 0
5110910 2389587 2389587 defendant Cokke Hugh husbandman 610479 610479 Cokke, Hugh, of Brompton, husbandman 0
5110916 2389588 2389588 defendant Cokke Hugh husbandman 610479 610479 Cokke, Hugh, of Brompton, husbandman 0
5115742 2391033 2391033 defendant Cok Hugh yeoman 610479 610479 Cok, Hugh, of Brompton, yeoman 0
5115743 2391033 2391033 defendant Cok Richard yeoman 610479 610479 Cok, Richard, of Brompton, yeoman 1
5130492 2395399 2395399 defendant Westhorpl George husbandman 610479 610479 Westhorpl George, of Brompton, husbandman 1
5130493 2395399 2395399 defendant Westhorp Richard   610479 610479 Westhorp, Richard, of Brompton, servant 2
5130494 2395399 2395399 defendant Westhorp Marmaduk   610479 610479 Westhorp, Marmaduk, of Brompton, servant 3
5130499 2395400 2395400 defendant Channoy or Chaunoy William husbandman 610479 610479 Channoy or Chaunoy, William, of Brompton, husbandman 3
5155197 2402668 2402668 defendant Cokke Richard husbandman 610479 610479 Cokke, Richard, of Brompton, husbandman 1
5171923 2407503 2407503 defendant Cokke Richard husbandman 610479 610479 Cokke, Richard, of Brompton, husbandman 1
5190686 2413024 2413024 defendant Cokke Richard husbandman 610479 610479 Cokke, Richard, of Brompton, husbandman 1
5200715 2415964 2415964 defendant Cokke Hugh husbandman 610479 610479 Cokke, Hugh, of Brompton, husbandman 0
5200716 2415964 2415964 defendant Cokke Richard husbandman 610479 610479 Cokke, Richard, of Brompton, husbandman 1
5211595 2419128 2419128 defendant Cokke Hugh husbandman 610479 610479 Cokke, Hugh, of Brompton, husbandman 0
5211596 2419128 2419128 defendant Cokke Richard husbandman 610479 610479 Cokke, Richard, of Brompton, husbandman 1
5236447 2426251 2426251 defendant Dale Thomas husbandman 610479 610479 Dale, Thomas, of Brompton, husbandman 0
5236448 2426251 2426251 defendant Franke John husbandman 610479 610479 Franke, John, of Brompton, husbandman 1
5236450 2426252 2426252 defendant Dale Thomas husbandman 610479 610479 Dale, Thomas, of Brompton, husbandman 0
5236451 2426252 2426252 defendant Franke John husbandman 610479 610479 Franke, John, of Brompton, husbandman 1
5279378 2439055 2439055 defendant Ulff Giles husbandman 610479 610479 Ulff, Giles, of Brompton, husbandman 4
5377807 2468643 2468643 defendant Artes John husbandman 610479 610479 Artes, John, of Brompton, husbandman 1
5515567 2509710 2509710 defendant Pyke John husbandman 610479 610479 Pyke, John, of Brompton, 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);