names

98 rows where place_id = 613561

✎ 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
3699059 1925912 1925912 defendant Honybrewe Hugh mercer 613561 613561 Honybrewe, Hugh, of Shirborne, mercer 0
3718855 1932174 1932174 defendant Nevell alias Noble Thomas yeoman 613561 613561 Nevell alias Noble, Thomas, of Shirborne, yeoman 0
3794898 1956272 1956272 plaintiff Cokeman Robert tanner 613561 613561 Cokeman, Robert, of Shirborne, tanner 0
3826713 1966205 1966205 plaintiff Baskervyld Philip esq 613561 613561 Baskervyld, Philip, of Shirborne, esq 0
3956039 2009180 2009180 defendant Harrys John clerk 613561 613561 Harrys, John, of Shirborne, clerk 0
3971185 2014477 2014477 defendant Woodale alias Robert Richard yeoman 613561 613561 Woodale alias Robert, Richard, of Shirborne, yeoman 0
4056476 2044700 2044700 defendant Raynold Henry husbandman 613561 613561 Raynold, Henry, of Shirborne, husbandman 1
4246568 2111827 2111827 defendant Chapleyn alias Reynold Henry husbandman 613561 613561 Chapleyn alias Reynold, Henry, of Shirborne, husbandman 0
4306405 2132382 2132382 defendant Bisshoppe Lawrence tailor 613561 613561 Bisshoppe, Lawrence, of Shirborne, tailor 1
4306406 2132382 2132382 defendant Baunton William victualer 613561 613561 Baunton, William, of Shirborne, victualer 2
4328930 2139989 2139989 defendant Webbe alias Morrell William yeoman 613561 613561 Webbe alias Morrell, William, of Shirborne, yeoman 0
4488439 2197103 2197103 defendant Seman John   613561 613561 Seman, John, of Shirborne 0
4489072 2197301 2197301 defendant Tannere Raymond   613561 613561 Tannere, Raymond, of Shirborne 2
4506189 2202444 2202444 defendant Jolyf Robert   613561 613561 Jolyf, Robert, of Shirborne 2
4522003 2207222 2207222 plaintiff Glover Hugh   613561 613561 Glover, Hugh, of Shirborne 0
4523937 2207821 2207821 defendant Jolyf Robert   613561 613561 Jolyf, Robert, of Shirborne 0
4523944 2207823 2207823 defendant Laurance Edward   613561 613561 Laurance, Edward, of Shirborne 2
4532730 2210505 2210505 defendant Jolyf Robert   613561 613561 Jolyf, Robert, of Shirborne 0
4532731 2210505 2210505 defendant Hoper William   613561 613561 Hoper, William, of Shirborne 1
4532732 2210505 2210505 defendant Oke William   613561 613561 Oke, William, of Shirborne 2
4539675 2212670 2212670 defendant Nevyll John   613561 613561 Nevyll, John, of Shirborne 0
4547322 2215094 2215094 defendant Noublet John   613561 613561 Noublet, John, of Shirborne 1
4562831 2219934 2219934 plaintiff Purye William chapman 613561 613561 Purye, William, of Shirborne, chapman 0
4596727 2230216 2230216 defendant Gardyner John   613561 613561 Gardyner, John, of Shirborne 0
4598491 2230764 2230764 defendant Jeoner John   613561 613561 Jeoner, John, of Shirborne 1
4606453 2233130 2233130 defendant Corneys John   613561 613561 Corneys, John, of Shirborne 0
4608064 2233634 2233634 defendant Purye William   613561 613561 Purye, William, of Shirborne 1
4658258 2248463 2248463 plaintiff Cote William   613561 613561 Cote, William, of Shirborne 0
4673579 2257368 2257368 defendant Ilberd John gent 613561 613561 Ilberd, John, of Shirborne, gent 0
4750633 2280673 2280673 defendant Payn William yeoman 613561 613561 Payn, William, of Shirborne, yeoman 1
4771764 2287146 2287146 defendant Muleward Peter   613561 613561 Muleward, Peter, of Shirborne, mule ward or mill ward 1
4796958 2295205 2295205 defendant Bailly John tanner 613561 613561 Bailly, John, of Shirborne, tanner 0
4796959 2295205 2295205 defendant Muleward Peter   613561 613561 Muleward, Peter, of Shirborne, millward 1
4803274 2297216 2297216 plaintiff Baret John, senior   613561 613561 Baret, John, senior, of Shirborne, on his own account 0
4808294 2298772 2298772 defendant Benet Thomas shoemaker 613561 613561 Benet, Thomas, of Shirborne, shoemaker 0
4834170 2306697 2306697 plaintiff Corneys John   613561 613561 Corneys, John, of Shirborne 0
4834290 2306736 2306736 defendant Jakes Richard weaver 613561 613561 Jakes, Richard, of Shirborne, weaver 0
4841748 2308955 2308955 defendant Barfote John weaver 613561 613561 Barfote, John, of Shirborne, weaver 2
4853124 2312393 2312393 defendant Beduwill William weaver 613561 613561 Beduwill, William, of Shirborne, weaver 0
4853125 2312393 2312393 defendant Gaunt John ostler 613561 613561 Gaunt, John, of Shirborne, ostler 1
4859174 2314243 2314243 plaintiff Asteleye John   613561 613561 (Asteleye, John, of Shirborne 1
4861213 2314873 2314873 plaintiff Corneys John   613561 613561 Corneys, John, of Shirborne 0
4864486 2315865 2315865 defendant Parche John mercer 613561 613561 Parche, John, of Shirborne, mercer 3
4872547 2318370 2318370 defendant Rogger Robert tucker 613561 613561 Rogger, Robert, of Shirborne, tucker 1
4937324 2338039 2338039 defendant Webbe Thomas carpenter 613561 613561 Webbe, Thomas, of Shirborne, carpenter 0
4956245 2343828 2343828 defendant Canon Roger butcher 613561 613561 Canon, Roger, of Shirborne, butcher 0
5007251 2359013 2359013 plaintiff Sparowe Thomas   613561 613561 Sparowe, Thomas, of Shirborne 0
5023608 2363815 2363815 defendant Cayell Thomas butcher 613561 613561 Cayell, Thomas, of Shirborne, butcher 0
5023609 2363815 2363815 defendant Pyle John yeoman 613561 613561 Pyle, John, of Shirborne, yeoman 1
5029246 2365434 2365434 defendant Knappe Robert merchant 613561 613561 Knappe, Robert, of Shirborne, merchant 1
5029249 2365434 2365434 defendant Stokes Richard yeoman 613561 613561 Stokes, Richard, of Shirborne, yeoman 4
5066722 2376574 2376574 defendant Fydeon William clerk 613561 613561 Fydeon, William, of Shirborne, clerk 8
5086772 2382526 2382526 defendant Lane Richard yeoman 613561 613561 Lane, Richard, of Shirborne, yeoman 0
5107753 2388698 2388698 defendant Whityn William smith 613561 613561 Whityn, William, of Shirborne, smith 0
5112602 2390069 2390069 defendant Rokes John esq 613561 613561 Rokes, John, of Shirborne, esq 0
5112604 2390070 2390070 defendant Rokes John esq 613561 613561 Rokes, John, of Shirborne, esq 0
5193367 2413788 2413788 defendant Sharpe John shoemaker 613561 613561 Sharpe, John, of Shirborne, shoemaker 0
5223820 2422652 2422652 defendant Sharpe John cordwainer 613561 613561 Sharpe, John, of Shirborne, cordwainer 0
5244191 2428496 2428496 defendant Valeys Martin tailor 613561 613561 Valeys, Martin, of Shirborne, tailor 1
5250615 2430302 2430302 defendant Romayn William gent 613561 613561 Romayn, William, of Shirborne, gent 0
5250618 2430302 2430302 defendant Vowell John mercer 613561 613561 Vowell, John, of Shirborne, mercer 3
5251867 2430692 2430692 defendant Exceter John dyer 613561 613561 Exceter, John, of Shirborne, dyer 0
5266979 2435427 2435427 defendant Coker John weaver 613561 613561 Coker, John, of Shirborne, weaver 1
5281650 2439701 2439701 defendant Cayleway William gent 613561 613561 Cayleway, William, of Shirborne, gent 0
5287429 2441347 2441347 defendant Kaylewey William gent 613561 613561 (Kaylewey, William, of Shirborne, gent 1
5287430 2441347 2441347 defendant Cosyn Thomas gent 613561 613561 Cosyn, Thomas, of Shirborne, gent 2
5303922 2446178 2446178 defendant Cooke Philip merchant 613561 613561 Cooke, Philip, of Shirborne, merchant 0
5313136 2448959 2448959 defendant Dyer Richard clothier 613561 613561 Dyer, Richard, of Shirborne, clothier 1
5313137 2448959 2448959 defendant Bryghtrygge Thomas tanner 613561 613561 Bryghtrygge, Thomas, of Shirborne, tanner 2
5320165 2451121 2451121 defendant Pyle Walter weaver 613561 613561 Pyle, Walter, of Shirborne, weaver 1
5320166 2451121 2451121 defendant Dyer Richard husbandman 613561 613561 Dyer, Richard, of Shirborne, husbandman 2
5334056 2455251 2455251 defendant Port Edward yeoman 613561 613561 Port, Edward, of Shirborne, yeoman 7
5350365 2460235 2460235 defendant Valeys Martin draper 613561 613561 Valeys, Martin, of Shirborne, draper 0
5376178 2468139 2468139 defendant Manston Richard yeoman 613561 613561 Manston, Richard, of Shirborne, yeoman 1
5376179 2468139 2468139 defendant Harrys ohn yeoman 613561 613561 Harrys, ohn, of Shirborne, yeoman 2
5397750 2474428 2474428 defendant Fronkeleyn Thomas   613561 613561 Fronkeleyn, Thomas, of Shirborne 0
5397751 2474428 2474428 defendant Olyver Henry tanner 613561 613561 Olyver, Henry, of Shirborne, tanner 1
5410900 2478212 2478212 defendant Frankeleyn Thomas   613561 613561 Frankeleyn, Thomas, of Shirborne 0
5410901 2478212 2478212 defendant Olyver (illegible) tanner 613561 613561 Olyver, _, of Shirborne, tanner 1
5410902 2478212 2478212 defendant Bryghtrygg Thomas tanner 613561 613561 Bryghtrygg, Thomas, of Shirborne, tanner 2
5414454 2479261 2479261 defendant Collowe Nicholas weaver 613561 613561 Collowe, Nicholas, of Shirborne, weaver 0
5431354 2484331 2484331 defendant Fauntleroye John gent 613561 613561 Fauntleroye, John, of Shirborne, gent 1
5485453 2500561 2500561 defendant Beker John (legal representative) 613561 613561 Beker, John, of Shirborne, draper, executrix of 1
5485865 2500665 2500665 defendant London Walter mercer 613561 613561 London, Walter, of Shirborne, mercer 0
5486635 2500899 2500899 defendant Dyer Thomas dyer 613561 613561 Dyer, Thomas, of Shirborne, dyer 0
5486637 2500900 2500900 defendant Dyer Thomas dyer 613561 613561 Dyer, Thomas, of Shirborne, dyer 0
5493843 2503065 2503065 defendant Rogers William tucker 613561 613561 Rogers, William, of Shirborne, tucker 0
5508853 2507622 2507622 defendant Roger William tucker 613561 613561 Roger, William, of Shirborne, tucker 0
5508855 2507623 2507623 defendant Rogers William tucker 613561 613561 Rogers, William, of Shirborne, tucker 0
5531902 2514521 2514521 defendant Schogyn John innholder 613561 613561 Schogyn, John, of Shirborne, innholder 1
5537064 2516075 2516075 defendant Rede William chapman 613561 613561 Rede, William, of Shirborne, chapman 2
5559366 2522706 2522706 defendant Lans William innholder 613561 613561 Lans, William, of Shirborne, innholder 1
5562249 2523555 2523555 defendant Snellyng Robert merchant 613561 613561 Snellyng, Robert, of Shirborne, merchant 2
5567722 2525134 2525134 plaintiff Dyne Richard carpenter 613561 613561 Dyne, Richard, of Shirborne, carpenter 0
5592561 2532663 2532663 defendant Best John   613561 613561 Best, John, of Shirborne, tanner, son of Best, John 2
5610442 2546982 2546982 defendant Fathere Walter   613561 613561 Fathere, Walter, of Shirborne 0
5612605 2547687 2547687 plaintiff Chaimberleyn Isabel   613561 613561 Chaimberleyn, Isabel, of Shirborne 0
5627908 2552699 2552699 defendant Petegrue William tucker 613561 613561 Petegrue, William, of Shirborne, tucker 0

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