names

106 rows where place_id = 592631

✎ 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
3608316 1870259 1870259 defendant Topratte Robert merchant 592631 592631 Topratte, Robert, of Bruggewater, merchant 0
4455295 2186664 2186664 defendant Somenour William   592631 592631 together with Somenour, William, of Bruggewater 15
4466919 2190327 2190327 defendant Devenyssh Roger   592631 592631 Devenyssh, Roger, of Bruggewater 0
4476073 2193186 2193186 defendant Cary John spicer 592631 592631 Cary, John, of Bruggewater, spicer 2
4478991 2194091 2194091 plaintiff Hoper Henry   592631 592631 Hoper, Henry, of Bruggewater, on his own account 0
4490977 2197871 2197871 defendant Tomere William   592631 592631 Tomere, William, of Bruggewater, burgess 0
4506272 2202461 2202461 defendant Ralegh John   592631 592631 Ralegh, John, of Bruggewater 2
4509881 2203575 2203575 defendant Ball William   592631 592631 Ball, William, of Bruggewater 1
4512250 2204272 2204272 plaintiff Cole John merchant 592631 592631 Cole, John, of Bruggewater, merchant 1
4527682 2208936 2208936 plaintiff Sydenham John   592631 592631 Sydenham, John, of Bruggewater 3
4531290 2210062 2210062 defendant Tannere Stephen   592631 592631 Tannere, Stephen, of Bruggewater 0
4533884 2210869 2210869 defendant Hegge John   592631 592631 Hegge, John, of Bruggewater 0
4533886 2210870 2210870 plaintiff Ruddok Walter   592631 592631 Ruddok, Walter, of Bruggewater 0
4533887 2210870 2210870 defendant Hogge John   592631 592631 Hogge, John, of Bruggewater 0
4538808 2212411 2212411 defendant Matheu John   592631 592631 Matheu, John, of Bruggewater 1
4546576 2214858 2214858 defendant Kedwelly John clerk 592631 592631 Kedwelly, John, of Bruggewater, clerk 0
4551868 2216531 2216531 plaintiff Engelby Thomas   592631 592631 Engelby, Thomas, of Bruggewater, burgess 0
4554910 2217465 2217465 defendant Hone John   592631 592631 Hone, John, of Bruggewater 0
4554911 2217465 2217465 defendant Mogge Robert   592631 592631 Mogge, Robert, of Bruggewater 1
4560270 2219160 2219160 defendant Sydenham John   592631 592631 Sydenham, John, of Bruggewater 0
4565444 2220761 2220761 defendant Stapuldon William   592631 592631 Stapuldon, William, of Bruggewater 0
4570868 2222456 2222456 plaintiff Sydenham John   592631 592631 (Sydenham, John, of Bruggewater 1
4583979 2226407 2226407 defendant Taillour Robert   592631 592631 Taillour, Robert, of Bruggewater Estover 6
4583980 2226407 2226407 defendant Lome William   592631 592631 Lome, William, of Bruggewater 7
4586493 2227188 2227188 defendant Burnard John   592631 592631 Burnard, John, of Bruggewater 0
4588070 2227668 2227668 plaintiff Kedwelly John   592631 592631 Kedwelly, John, of Bruggewater 0
4588071 2227668 2227668 defendant Tomer William (legal representative) 592631 592631 Tomer, William, of Bruggewater, executors of 0
4598223 2230682 2230682 defendant Poule John   592631 592631 Poule, John, of Bruggewater 5
4602420 2231975 2231975 defendant Elleworth Lawrence   592631 592631 Elleworth, Lawrence, of Bruggewater 1
4615231 2235774 2235774 defendant Bertlot Roger dyer 592631 592631 Bertlot, Roger, of Bruggewater, dyer 0
4631241 2240667 2240667 defendant Tanner Philip   592631 592631 Tanner, Philip, of Bruggewater 2
4631476 2240736 2240736 plaintiff Thomere William   592631 592631 Thomere, William, of Bruggewater, administrators of 0
4631483 2240737 2240737 plaintiff Thomere William   592631 592631 Thomere, William, of Bruggewater, administrators of 0
4648636 2245654 2245654 defendant Edward John weaver 592631 592631 Edward, John, of Bruggewater, weaver 0
4662254 2249667 2249667 defendant Edeney William tailor 592631 592631 Edeney, William, of Bruggewater, tailor 0
4669328 2256113 2256113 defendant Barbour John barber 592631 592631 Barbour, John, of Bruggewater, barber 0
4675641 2257991 2257991 defendant Bette John   592631 592631 Bette, John, of Bruggewater, milward 1
4675990 2258101 2258101 defendant Bageler John chapman 592631 592631 Bageler, John, of Bruggewater, chapman 0
4676174 2258161 2258161 defendant Henton John merchant 592631 592631 Henton, John, of Bruggewater, merchant 1
4676175 2258161 2258161 defendant Tailloru John tailor 592631 592631 Tailloru, John, of Bruggewater, tailor 2
4676176 2258161 2258161 defendant Taillour Henry merchant 592631 592631 Taillour, Henry, of Bruggewater, merchant 3
4678905 2259006 2259006 defendant Owtlawe John merchant 592631 592631 Owtlawe, John, of Bruggewater, merchant 0
4681668 2259876 2259876 defendant Taillour Nicholas tailor 592631 592631 Taillour, Nicholas, of Bruggewater, tailor 0
4682336 2260099 2260099 defendant Kyng Robert merchant 592631 592631 Kyng, Robert, of Bruggewater, merchant 1
4684633 2260792 2260792 defendant Tanner Philip tanner 592631 592631 Tanner, Philip, of Bruggewater, tanner 2
4688311 2261912 2261912 defendant Bundell Robert tanner 592631 592631 Bundell, Robert, of Bruggewater, tanner 2
4690872 2262678 2262678 plaintiff Woder John   592631 592631 Woder, John, of Bruggewater, on his own account 0
4709451 2268311 2268311 defendant Twynche William fuller 592631 592631 Twynche, William, of Bruggewater, fuller 1
4709454 2268312 2268312 defendant Payne Thomas chapman 592631 592631 Payne, Thomas, of Bruggewater, chapman 1
4726050 2273433 2273433 plaintiff Goune John mercer 592631 592631 Goune, John, of Bruggewater, mercer 0
4728132 2274048 2274048 plaintiff Hull Robert   592631 592631 Hull, Robert, of Bruggewater 0
4731780 2275128 2275128 defendant Kyng Robert merchant 592631 592631 Kyng, Robert, of Bruggewater, merchant 1
4731781 2275128 2275128 defendant Gardyner Richard merchant 592631 592631 Gardyner, Richard, of Bruggewater, merchant 2
4731782 2275128 2275128 defendant Curteys Robert shipman 592631 592631 Curteys, Robert, of Bruggewater, shipman 3
4732580 2275366 2275366 defendant Goune John chapman 592631 592631 Goune, John, of Bruggewater, chapman 0
4732581 2275366 2275366 defendant Loveday Thomas weaver 592631 592631 Loveday, Thomas, of Bruggewater, weaver 1
4775235 2288249 2288249 defendant Dodesham Richard baker 592631 592631 Dodesham, Richard, of Bruggewater, baker 0
4794668 2294471 2294471 defendant Comyn John yeoman 592631 592631 Comyn, John, of Bruggewater, yeoman 0
4794669 2294471 2294471 defendant Deye Henry butcher 592631 592631 Deye, Henry, of Bruggewater, butcher 1
4800507 2296339 2296339 defendant Gascoigne William (legal representative) 592631 592631 Gascoigne, William, of Bruggewater, executor of 0
4852266 2312134 2312134 defendant Clavell John husbandman 592631 592631 Clavell, John, of Bruggewater, husbandman 0
4852267 2312134 2312134 defendant Touker Geoffrey fuller 592631 592631 Touker, Geoffrey, of Bruggewater, fuller 1
4855215 2312982 2312982 defendant Sequard Nicholas cardmaker 592631 592631 Sequard, Nicholas, of Bruggewater, cardmaker 0
4855220 2312984 2312984 defendant Segnard Nicholas   592631 592631 Segnard, Nicholas, of Bruggewater, card maker 0
4855486 2313077 2313077 defendant Ferys John merchant 592631 592631 Ferys, John, of Bruggewater, merchant 0
4862109 2315159 2315159 defendant Comyn John merchant 592631 592631 Comyn, John, of Bruggewater, merchant 3
4865226 2316096 2316096 defendant Bryttyll Richard gent 592631 592631 Bryttyll, Richard, of Bruggewater, gent 0
4867414 2316774 2316774 defendant Bonham John   592631 592631 Bonham, John, of Bruggewater 0
4878503 2320222 2320222 defendant Smyth John merchant 592631 592631 Smyth, John, of Bruggewater, merchant 0
4878504 2320222 2320222 defendant Marchefeld Thomas merchant 592631 592631 Marchefeld, Thomas, of Bruggewater, merchant 1
4878505 2320222 2320222 defendant Ayleward John merchant 592631 592631 Ayleward, John, of Bruggewater, merchant 2
4894428 2324931 2324931 defendant Toky William merchant 592631 592631 Toky, William, of Bruggewater, merchant 0
4934465 2337172 2337172 plaintiff atte Wyll William   592631 592631 atte Wyll, William, of Bruggewater 0
4934714 2337252 2337252 defendant Smyth William merchant 592631 592631 Smyth, William, of Bruggewater, merchant 0
4940854 2339167 2339167 defendant Grene Robert mercer 592631 592631 Grene, Robert, of Bruggewater, mercer 0
4940855 2339167 2339167 defendant Pares Robert tucker 592631 592631 Pares, Robert, of Bruggewater, tucker 1
4959989 2344951 2344951 defendant Craddok Thomas merchant 592631 592631 Craddok, Thomas, of Bruggewater, merchant 0
4962796 2345783 2345783 defendant Lacom Thomas merchant 592631 592631 Lacom, Thomas, of Bruggewater, merchant 0
4983885 2352108 2352108 defendant Lacom Thomas merchant 592631 592631 Lacom, Thomas, of Bruggewater, merchant 0
5013443 2360768 2360768 defendant Aleys John yeoman 592631 592631 Aleys, John, of Bruggewater, yeoman 1
5013444 2360768 2360768 defendant Hardyng Thomas chaplain 592631 592631 Hardyng, Thomas, of Bruggewater, chaplain 2
5014173 2360995 2360995 defendant Godehyne or Godehyve Thomas husbandman or merchant 592631 592631 Godehyne or Godehyve, Thomas, of Bruggewater, husbandman or merchant 0
5014175 2360996 2360996 defendant Godehyve or Godehyne Thomas husbandman or merchant 592631 592631 Godehyve or Godehyne, Thomas, of Bruggewater, husbandman or merchant 0
5066753 2376585 2376585 defendant Feld Thomas merchant 592631 592631 Feld, Thomas, of Bruggewater, merchant 1
5066754 2376585 2376585 defendant Craddok Thomas merchant 592631 592631 Craddok, Thomas, of Bruggewater, merchant 2
5090362 2383561 2383561 defendant Driffeld Richard barber 592631 592631 Driffeld, Richard, of Bruggewater, barber 0
5126186 2394140 2394140 defendant Parker John mercer 592631 592631 Parker, John, of Bruggewater, mercer 3
5126193 2394141 2394141 defendant Parys Walter fuller 592631 592631 Parys, Walter, of Bruggewater, fuller 2
5144820 2399636 2399636 defendant Parker John mercer 592631 592631 Parker, John, of Bruggewater, mercer 3
5144832 2399638 2399638 defendant Parys Walter fuller 592631 592631 Parys, Walter, of Bruggewater, fuller 2
5155425 2402742 2402742 defendant Wheler John clerk 592631 592631 Wheler, John, of Bruggewater, clerk 0
5172069 2407547 2407547 defendant Wheler John clerk 592631 592631 Wheler, John, of Bruggewater, clerk 0
5214182 2419876 2419876 defendant Growe Thomas merchant 592631 592631 Growe, Thomas, of Bruggewater, merchant 0
5215131 2420148 2420148 defendant Boldey William hosier 592631 592631 Boldey, William, of Bruggewater, hosier 1
5216696 2420619 2420619 plaintiff Deye Henry   592631 592631 Deye, Henry, of Bruggewater, butcher, adminitrators of 0
5235648 2426008 2426008 plaintiff Deye Henry   592631 592631 Deye, Henry, of Bruggewater, butcher, administrators of 0
5242533 2428021 2428021 plaintiff Michell William   592631 592631 Michell, William, of Bruggewater 0
5253005 2431047 2431047 defendant Elys John (legal representative) 592631 592631 Elys, John, of Bruggewater, executors of 0
5339684 2456985 2456985 defendant Milleyn Robert baker 592631 592631 Milleyn, Robert, of Bruggewater, baker 0
5352820 2460968 2460968 defendant Tredwyn William tailor 592631 592631 Tredwyn, William, of Bruggewater, tailor 3

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);