names

69 rows where place_id = 599756

✎ 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
3638146 1906748 1906748 defendant Bull John husbandman 599756 599756 Bull, John, of Newynton, husbandman 0
3865291 1978600 1978600 defendant Boys William gent 599756 599756 Boys, William, of Newynton, gent 2
3879337 1983340 1983340 defendant Boys William gent 599756 599756 Boys, William, of Newynton, gent 0
3900287 1990326 1990326 defendant Wynge William tailor 599756 599756 Wynge, William, of Newynton, tailor 3
4441867 2182391 2182391 defendant Barbour John   599756 599756 Barbour, John, of Newynton 0
4441868 2182391 2182391 defendant Cosyn William   599756 599756 Cosyn, William, of Newynton 1
4441869 2182391 2182391 defendant Berkesore William   599756 599756 Berkesore, William, of Newynton 2
4518279 2206092 2206092 defendant atte Rode Thomas   599756 599756 atte Rode, Thomas, of Newynton 0
4542079 2213415 2213415 defendant Balkebroke Richard   599756 599756 Balkebroke, Richard, of Newynton 0
4545138 2214397 2214397 defendant Loveday Richard   599756 599756 Loveday, Richard, of Newynton 0
4552361 2216691 2216691 plaintiff Fenell Stephen   599756 599756 Fenell, Stephen, of Newynton 0
4557317 2218226 2218226 defendant Foun Simon   599756 599756 Foun, Simon, of Newynton, mill ward 0
4557366 2218244 2218244 defendant Fenell Stephen   599756 599756 Fenell, Stephen, of Newynton 0
4581608 2225696 2225696 defendant Wadewell John   599756 599756 Wadewell, John, of Newynton 0
4587692 2227557 2227557 plaintiff Isakyn Thomas   599756 599756 Isakyn, Thomas, of Newynton, vicar 0
4587826 2227595 2227595 plaintiff Jeakyn Thomas   599756 599756 Jeakyn, Thomas, of Newynton, vicar 0
4590070 2228256 2228256 defendant Cooke John   599756 599756 Cooke, John, of Newynton, vicar 0
4590605 2228421 2228421 defendant Wagge Robert   599756 599756 Wagge, Robert, of Newynton 0
4598131 2230661 2230661 defendant Holyscombe Peter   599756 599756 Holyscombe, Peter, of Newynton 3
4598141 2230662 2230662 defendant Holyscombe Peter   599756 599756 Holyscombe, Peter, of Newynton 3
4613943 2235373 2235373 plaintiff Deye John   599756 599756 Deye, John, of Newynton 0
4619193 2237001 2237001 defendant Rode Thomas   599756 599756 Rode, Thomas, of Newynton 0
4643039 2244073 2244073 defendant Eynesham Nicholas   599756 599756 Eynesham, Nicholas, of Newynton 0
4661600 2249464 2249464 plaintiff Englyssh Richard   599756 599756 Englyssh, Richard, of Newynton 0
4661602 2249464 2249464 defendant Wemme Richard husbandman 599756 599756 Wemme, Richard, of Newynton, husbandman 1
4670314 2256422 2256422 defendant Brunker Walter (legal representative) 599756 599756 Brunker, Walter, of Newynton, executors of 0
4677539 2258588 2258588 defendant Frogenale Richard husbandman 599756 599756 Frogenale, Richard, of Newynton, husbandman 0
4700334 2265521 2265521 defendant Aldebury William gent 599756 599756 Aldebury, William, of Newynton, gent 0
4700339 2265522 2265522 defendant Aldelbury William gent 599756 599756 Aldelbury, William, of Newynton, gent 0
4708534 2268037 2268037 defendant Roger Thomas husbandman 599756 599756 Roger, Thomas, of Newynton, husbandman 0
4711723 2268989 2268989 plaintiff Saundre Robert   599756 599756 Saundre, Robert, of Newynton 0
4711726 2268989 2268989 defendant Marchaunt William (legal representative) 599756 599756 Marchaunt, William, of Newynton, executors of 2
4711729 2268990 2268990 plaintiff Saundre Robert   599756 599756 Saundre, Robert, of Newynton 0
4719428 2271421 2271421 defendant Lydesyng John husbandman 599756 599756 Lydesyng, John, of Newynton, husbandman 2
4729468 2274428 2274428 defendant Trygge John hosteller 599756 599756 Trygge, John, of Newynton, hosteller 1
4749925 2280452 2280452 defendant Turnour John husbandman 599756 599756 Turnour, John, of Newynton, husbandman 3
4755774 2282188 2282188 plaintiff Barebour John smith 599756 599756 Barebour, John, of Newynton, smith 0
4763461 2284557 2284557 defendant Clerk Laurence laborer 599756 599756 Clerk, Laurence, of Newynton, son of John, laborer 0
4812139 2299909 2299909 defendant Tayllour Michael tailor 599756 599756 Tayllour, Michael, of Newynton, tailor 0
4830140 2305468 2305468 plaintiff Berford William   599756 599756 Berford, William, of Newynton 0
4834652 2306840 2306840 defendant Corveser William   599756 599756 Corveser, William, of Newynton 0
4834653 2306840 2306840 defendant Underdowne James   599756 599756 Underdowne, James, of Newynton 1
4849700 2311382 2311382 defendant Adam William husbandman 599756 599756 Adam, William, of Newynton, husbandman 1
4861274 2314894 2314894 defendant Harpele Adam   599756 599756 Harpele, Adam, of Newynton, mason 0
4916337 2331611 2331611 defendant Baldok Helen widow 599756 599756 Baldok, Helen, of Newynton, widow 0
4934076 2337041 2337041 defendant Gage William smith 599756 599756 Gage, William, of Newynton, smith 0
4941588 2339389 2339389 defendant Baldok Ellen widow 599756 599756 Baldok, Ellen, of Newynton, widow 0
4955597 2343640 2343640 defendant Knyght Almary husbandman 599756 599756 Knyght, Almary, of Newynton, husbandman 1
4986162 2352785 2352785 plaintiff Atkyn Hugh   599756 599756 Atkyn, Hugh, of Newynton, parish chaplain 0
4986163 2352785 2352785 plaintiff Broke John husbandman 599756 599756 Broke, John, of Newynton, husbandman 1
5000226 2356943 2356943 defendant Cowestede Thomas husbandman 599756 599756 Cowestede, Thomas, of Newynton, husbandman 0
5073922 2378688 2378688 defendant Coke Robert yeoman 599756 599756 Coke, Robert, of Newynton, yeoman 15
5073925 2378688 2378688 defendant Archer Richard yeoman 599756 599756 Archer, Richard, of Newynton, yeoman 18
5075081 2379049 2379049 plaintiff Wynslowe Thomas   599756 599756 Wynslowe, Thomas,of Newynton 0
5100265 2386522 2386522 plaintiff Wynselowe Thomas   599756 599756 Wynselowe, Thomas, of Newynton 0
5129992 2395259 2395259 defendant Denys John yeoman 599756 599756 Denys, John, of Newynton, yeoman 0
5156791 2403144 2403144 defendant Wodard William hosteler 599756 599756 Wodard, William, of Newynton, hosteler 1
5226305 2423360 2423360 defendant Ledys John gent 599756 599756 Ledys, John, of Newynton, gent 0
5226309 2423361 2423361 defendant Ledys John gent 599756 599756 Ledys, John, of Newynton, gent 0
5231986 2424924 2424924 defendant Sherle Richard husbandman 599756 599756 Sherle, Richard, of Newynton, husbandman 2
5234887 2425787 2425787 defendant Marchaunt John husbandman 599756 599756 Marchaunt, John, of Newynton, husbandman 0
5240879 2427537 2427537 defendant Dene Agnes widow 599756 599756 Dene, Agnes, of Newynton, widow 3
5302444 2445697 2445697 defendant Marchuant John husbandman 599756 599756 Marchuant, John, of Newynton, husbandman 2
5317140 2450206 2450206 defendant Hyott William, junior husbandman 599756 599756 Hyott, William, junior, of Newynton, husbandman 3
5356974 2462243 2462243 defendant Morton William weaver 599756 599756 Morton, William, of Newynton, weaver 0
5356975 2462243 2462243 defendant Huntley Thomas yeoman 599756 599756 Huntley, Thomas, of Newynton, yeoman 1
5367307 2465426 2465426 defendant Overey Richard tailor 599756 599756 Overey, Richard, of Newynton, tailor 0
5439973 2486899 2486899 defendant Noke Richard butcher 599756 599756 Noke, Richard, of Newynton, butcher 4
5510938 2508260 2508260 defendant Sutton William yeoman 599756 599756 Sutton, William, of Newynton, yeoman 1

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