names

138 rows where place_id = 754132

✎ 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
4418028 2170518 2170518 defendant Horsham Anne   754132 754132 Horsham, Anne, of Brendewode, wife of Richard 0
4418031 2170518 2170518 defendant Horsham Richard   754132 754132 together with Horsham, Richard, of Brendewode 3
4418032 2170518 2170518 defendant Wynkere Hugh le   754132 754132 Wynkere, Hugh le, of Brendewode 4
4418034 2170519 2170519 defendant Horsham Richard   754132 754132 Horsham, Richard, of Brendewode 0
4418036 2170520 2170520 defendant Wynkere Hugh le   754132 754132 Wynkere, Hugh le, of Brendewode 0
4418127 2170551 2170551 defendant atte Wode Henry   754132 754132 atte Wode, Henry, of Brendewode 2
4428966 2173862 2173862 defendant Hedham Annice   754132 754132 Hedham, Annice, of Brendewode, formerly wife of 0
4428969 2173862 2173862 defendant Horsham Richard   754132 754132 together with Horsham, Richard, of Brendewode 3
4428970 2173862 2173862 defendant Wynkere Hugh le   754132 754132 Wynkere, Hugh le, of Brendewode 4
4428972 2173863 2173863 defendant Wynkere or Wyntere Hugh le   754132 754132 Wynkere or Wyntere, Hugh le, of Brendewode 0
4428973 2173863 2173863 defendant Horsham Richard   754132 754132 together with Horsham, Richard, of Brendewode 1
4429321 2173976 2173976 defendant atte Wode Henry   754132 754132 atte Wode, Henry, of Brendewode 2
4469626 2191164 2191164 defendant Bret Thomas   754132 754132 Bret, Thomas, of Brendewode 0
4490036 2197599 2197599 defendant Chyld John   754132 754132 Chyld, John, of Brendewode 0
4515434 2205243 2205243 plaintiff Child John   754132 754132 Child, John, of Brendewode 0
4532571 2210453 2210453 defendant Pulter Henry   754132 754132 Pulter, Henry, of Brendewode 0
4548365 2215430 2215430 plaintiff Child John   754132 754132 Child, John, of Brendewode 0
4548366 2215430 2215430 defendant Lovekyn William   754132 754132 Lovekyn, William, of Brendewode 0
4556257 2217898 2217898 defendant Lovekyn William   754132 754132 Lovekyn, William, of Brendewode 0
4556863 2218081 2218081 defendant Payn John   754132 754132 Payn, John, of Brendewode 0
4573029 2223099 2223099 plaintiff Bakere Joan   754132 754132 Bakere, Joan, of Brendewode 0
4576006 2223991 2223991 defendant Hoke John   754132 754132 Hoke, John, of Brendewode 0
4577253 2224405 2224405 plaintiff Canoun William   754132 754132 Canoun, William, of Brendewode 0
4577725 2224539 2224539 defendant Canon William   754132 754132 Canon, William, of Brendewode 1
4584724 2226646 2226646 defendant Pulter Henry   754132 754132 Pulter, Henry, of Brendewode 0
4589173 2227995 2227995 defendant Hacoun John   754132 754132 Hacoun, John, of Brendewode 1
4589174 2227995 2227995 defendant Love William   754132 754132 Love, William, of Brendewode 2
4601772 2231775 2231775 defendant Frank John   754132 754132 Frank, John, of Brendewode 2
4610646 2234396 2234396 defendant Canon William   754132 754132 Canon, William, of Brendewode 1
4610979 2234505 2234505 defendant Tylneye Henry   754132 754132 Tylneye, Henry, of Brendewode 2
4610983 2234506 2234506 defendant Tylneye Henry   754132 754132 Tylneye, Henry, of Brendewode 2
4613281 2235186 2235186 defendant Pulter Henry   754132 754132 Pulter, Henry, of Brendewode 0
4614727 2235618 2235618 defendant Bakere Thomas   754132 754132 Bakere, Thomas, of Brendewode 0
4634724 2241712 2241712 defendant Pulter Henry   754132 754132 Pulter, Henry, of Brendewode 0
4638613 2242831 2242831 defendant Duche John   754132 754132 Duche, John, of Brendewode 1
4638614 2242831 2242831 defendant Canon William   754132 754132 Canon, William, of Brendewode 2
4647788 2245415 2245415 defendant Boys Henry   754132 754132 Boys, Henry, of Brendewode 6
4656509 2247931 2247931 defendant Duche John husbandman 754132 754132 Duche, John, of Brendewode, husbandman 1
4664005 2250228 2250228 defendant Evilene William ostler 754132 754132 Evilene, William, of Brendewode, ostler 0
4664006 2250228 2250228 defendant Graye John cordwainer 754132 754132 Graye, John, of Brendewode, cordwainer 1
4669253 2256089 2256089 defendant Love or Lone William laborer 754132 754132 Love or Lone, William, of Brendewode, laborer 1
4679745 2259281 2259281 defendant Edwyn Richard carpenter 754132 754132 Edwyn, Richard, of Brendewode, carpenter 4
4776486 2288640 2288640 defendant Clerk John yeoman 754132 754132 Clerk, John, of Brendewode, yeoman 0
4794782 2294508 2294508 defendant Smyth John   754132 754132 Smyth, John, of Brendewode, ostler, or of Stoke Neylond 0
4795255 2294663 2294663 defendant Esy John cordwainer 754132 754132 Esy, John, of Brendewode, cordwainer 0
4795256 2294663 2294663 defendant Edewyn William carpenter 754132 754132 Edewyn, William, of Brendewode, carpenter 1
4801474 2296641 2296641 defendant Osbern John ostler 754132 754132 Osbern, John, of Brendewode, ostler 4
4804262 2297518 2297518 defendant Bocher John butcher 754132 754132 Bocher, John, of Brendewode, butcher 1
4804263 2297518 2297518 defendant Gerold John butcher 754132 754132 Gerold, John, of Brendewode, butcher 2
4820586 2302511 2302511 defendant Esy John shoemaker 754132 754132 Esy, John, of Brendewode, shoemaker 0
4823240 2303358 2303358 defendant Bocher John yeoman 754132 754132 Bocher, John, of Brendewode, yeoman 0
4865260 2316108 2316108 defendant Richard John ostler 754132 754132 Richard, John, of Brendewode, ostler 0
4871585 2318083 2318083 defendant Fuller Thomas baker 754132 754132 Fuller, Thomas, of Brendewode, baker 0
4881163 2321017 2321017 defendant Prior Richard hosteler 754132 754132 Prior, Richard, of Brendewode, hosteler 0
4888842 2323299 2323299 defendant Staunford John gent 754132 754132 Staunford, John, of Brendewode, gent 0
4906292 2328556 2328556 defendant Richard John hosteler 754132 754132 Richard, John, of Brendewode, hosteler 0
4917474 2331980 2331980 defendant Richard John hosteller 754132 754132 Richard, John, of Brendewode, hosteller 0
4921991 2333287 2333287 defendant Spycere alias Stampford Willam chaplain 754132 754132 Spycere alias Stampford, Willam, of Brendewode, chaplain 0
4935508 2337503 2337503 defendant Richard John hosteler 754132 754132 Richard, John, of Brendewode, hosteler 0
4974850 2349448 2349448 defendant Neell John   754132 754132 Neell, John, of Brendewode, servant 1
4975951 2349769 2349769 defendant Rede John cordwainer 754132 754132 Rede, John, of Brendewode, cordwainer 1
4975952 2349769 2349769 defendant Rede William shoemaker 754132 754132 Rede, William, of Brendewode, shoemaker 2
4989683 2353832 2353832 defendant Hayward Richard butcher 754132 754132 Hayward, Richard, of Brendewode, butcher 3
4989684 2353832 2353832 defendant Cotermong John ostler 754132 754132 Cotermong, John, of Brendewode, ostler 4
5017718 2362057 2362057 defendant Laton John   754132 754132 Laton, John, of Brendewode, servant 0
5020665 2362938 2362938 defendant Cheveyne John hosteler 754132 754132 Cheveyne, John, of Brendewode, hosteler 0
5021693 2363244 2363244 defendant Brodee Stephen butcher 754132 754132 Brodee, Stephen, of Brendewode, butcher 0
5022058 2363345 2363345 defendant Baker Thomas baker 754132 754132 Baker, Thomas, of Brendewode, baker 0
5038844 2368259 2368259 defendant French John chandler 754132 754132 French, John, of Brendewode, chandler 1
5046153 2370478 2370478 defendant Baker Thomas baker 754132 754132 Baker, Thomas, of Brendewode, baker 0
5046550 2370610 2370610 defendant Haukyn William chapman 754132 754132 Haukyn, William, of Brendewode, chapman 1
5048431 2371169 2371169 plaintiff Rissher John   754132 754132 Rissher, John, of Brendewode 0
5057316 2373753 2373753 defendant de Ely alias Cotermonger John yeoman 754132 754132 de Ely alias Cotermonger, John, of Brendewode, yeoman 0
5057318 2373754 2373754 defendant de Ely alias Cotermonger John yeoman 754132 754132 de Ely alias Cotermonger, John, of Brendewode, yeoman 0
5061413 2375001 2375001 defendant Conyngesburgh Edmund clerk 754132 754132 Conyngesburgh, Edmund, of Brendewode, clerk 0
5069200 2377283 2377283 defendant Frenssh John   754132 754132 Frenssh, John, of Brendewode, tallow chandler 1
5069660 2377423 2377423 defendant Freberne Richard butcher 754132 754132 Freberne, Richard, of Brendewode, butcher 0
5073475 2378552 2378552 defendant Crampe John husbandman 754132 754132 Crampe, John, of Brendewode, husbandman 0
5078288 2379995 2379995 plaintiff Brice John   754132 754132 Brice, John, of Brendewode 0
5079092 2380234 2380234 defendant of Ely John yeoman 754132 754132 of Ely, John, of Brendewode, yeoman 2
5084055 2381733 2381733 defendant Brewet William cordwainer 754132 754132 Brewet, William, of Brendewode, cordwainer 0
5085864 2382261 2382261 defendant White John tiler 754132 754132 White, John, of Brendewode, tiler 1
5085865 2382261 2382261 defendant Ely John yeoman 754132 754132 Ely, John, of Brendewode, yeoman 2
5087013 2382581 2382581 defendant Ely alias Costermonger John yeoman 754132 754132 Ely alias Costermonger, John, of Brendewode, yeoman 0
5087014 2382581 2382581 defendant Frebarn Richard butcher 754132 754132 Frebarn, Richard, of Brendewode, butcher 1
5087016 2382582 2382582 defendant Ely alias Cotermonger John yeoman 754132 754132 Ely alias Cotermonger, John, of Brendewode, yeoman 0
5087017 2382582 2382582 defendant Frebarn Richard butcher 754132 754132 Frebarn, Richard, of Brendewode, butcher 1
5095717 2385167 2385167 defendant of Ely alias Cottermonger John yeoman 754132 754132 of Ely alias Cottermonger, John, of Brendewode, yeoman 0
5102867 2387258 2387258 defendant Richard John ostler 754132 754132 Richard, John, of Brendewode, ostler 1
5115463 2390947 2390947 defendant Ryssher John baker 754132 754132 Ryssher, John, of Brendewode, baker 2
5115464 2390947 2390947 defendant Crakebon Thomas butcher 754132 754132 Crakebon, Thomas, of Brendewode, butcher 3
5119172 2392036 2392036 defendant Bowett William cordwainer 754132 754132 Bowett, William, of Brendewode, cordwainer 2
5124945 2393771 2393771 defendant Serche John husbandman 754132 754132 Serche, John, of Brendewode, husbandman 0
5163266 2404988 2404988 defendant Frebarn Richard butcher 754132 754132 Frebarn, Richard, of Brendewode, butcher 1
5163789 2405144 2405144 defendant Crakebon Thomas butcher 754132 754132 Crakebon, Thomas, of Brendewode, butcher 1
5163792 2405145 2405145 defendant Crakebon Thomas butcher 754132 754132 Crakebon, Thomas, of Brendewode, butcher 1
5172479 2407678 2407678 defendant Stanford William clerk 754132 754132 Stanford, William, of Brendewode, clerk 0
5172481 2407678 2407678 defendant Ruddok Thomas smith 754132 754132 Ruddok, Thomas, of Brendewode, smith 2
5178107 2409300 2409300 defendant Brewet William shoemaker 754132 754132 Brewet, William, of Brendewode, shoemaker 0
5207953 2418059 2418059 defendant Bryde Richard husbandman 754132 754132 Bryde, Richard, of Brendewode, 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);