names

66 rows where place_id = 604729

✎ 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
3659060 1913096 1913096 defendant Okeham Nicholas yeoman 604729 604729 Okeham, Nicholas, of Newbury, Berks, yeoman 1
3662432 1914163 1914163 plaintiff Mey John clothier 604729 604729 Mey, John, of Newbury, Berks, clothier 0
3676637 1918730 1918730 defendant Andrewes John chapman 604729 604729 (Andrewes, John, of Newbury, Berks, chapman 1
3676640 1918731 1918731 defendant Andrews John chapman 604729 604729 (Andrews, John, of Newbury, Berks, chapman 1
3720886 1932828 1932828 defendant Cokkys John fuller 604729 604729 Cokkys, John, of Newbury, Berks, fuller 2
3773771 1949511 1949511 defendant Elys John yeoman 604729 604729 Elys, John, of Newbury, Berks, yeoman 0
3777589 1950743 1950743 defendant Smyth Richard mercer 604729 604729 Smyth, Richard, of Newbury, Berks, mercer 0
3779746 1951399 1951399 defendant Sharpe Edward clothmaker 604729 604729 Sharpe, Edward, of Newbury, Berks, clothmaker 0
3788706 1954270 1954270 defendant Sharpe Edward clothman 604729 604729 Sharpe, Edward, of Newbury, Berks, clothman 0
3824377 1965495 1965495 defendant Childe Mathew clothmaker 604729 604729 Childe, Mathew, of Newbury, Berks, clothmaker 0
3848005 1972951 1972951 defendant Chamer John butcher 604729 604729 Chamer, John, of Newbury, Berks, butcher 0
3916447 1995879 1995879 defendant Surrage Robert clothier 604729 604729 Surrage, Robert, of Newbury, Berks, clothier 1
3930469 2000536 2000536 defendant Pykeryng Richard clothier 604729 604729 Pykeryng, Richard, of Newbury, Berks, clothier 2
3939594 2003547 2003547 defendant Bell Edmund clerk 604729 604729 Bell, Edmund, of Newbury, Berks, clerk 0
3946021 2005684 2005684 defendant Hynde Giles glover 604729 604729 Hynde, Giles, of Newbury, Berks, glover 1
3954234 2008555 2008555 defendant Pawmer alias Smyth John yeoman 604729 604729 Pawmer alias Smyth, John, of Newbury, Berks, yeoman 0
3959202 2010305 2010305 defendant Slocock Thomas butcher 604729 604729 Slocock, Thomas, of Newbury, Berks, butcher 0
3959204 2010306 2010306 defendant Slocock Thomas butcher 604729 604729 Slocock, Thomas, of Newbury, Berks, butcher 0
4041726 2039523 2039523 plaintiff Nottyngham William gent 604729 604729 Nottyngham, William, of Newbury, Berks, gent 0
4041729 2039524 2039524 plaintiff Nottyngham William gent 604729 604729 Nottyngham, William, of Newbury, Berks, gent 0
4041732 2039525 2039525 plaintiff Nottyngham William gent 604729 604729 Nottyngham, William, of Newbury, Berks, gent 0
4041735 2039526 2039526 plaintiff Nottyngham William gent 604729 604729 Nottyngham, William, of Newbury, Berks, gent 0
4696901 2264510 2264510 defendant Moth John dyer 604729 604729 Moth, John, of Newbury, Berks, dyer 3
4698710 2265078 2265078 defendant Hill Henry chapman 604729 604729 Hill, Henry, of Newbury, Berks, chapman 0
4698908 2265137 2265137 plaintiff Denman Robert   604729 604729 Denman, Robert, of Newbury, Berks 0
4698911 2265138 2265138 plaintiff Denman Robert   604729 604729 Denman, Robert, of Newbury, Berks 0
4699099 2265184 2265184 defendant Tounesend Edward chapman 604729 604729 Tounesend, Edward, of Newbury, Berks, chapman 3
4710144 2268524 2268524 defendant Tounsende Edward felmonger 604729 604729 Tounsende, Edward, of Newbury, Berks, felmonger 0
4721174 2271955 2271955 defendant Motthe Agnes widow 604729 604729 Motthe, Agnes, of Newbury, Berks, widow 6
4769956 2286576 2286576 defendant Exe John chapman 604729 604729 Exe, John, of Newbury, Berks, chapman 1
4771784 2287151 2287151 defendant Messanger Nicholas yeoman 604729 604729 Messanger, Nicholas, of Newbury, Berks, yeoman 0
4827595 2304682 2304682 defendant Langryssh Robert   604729 604729 Langryssh, Robert, of Newbury, Berks, parson 0
4837700 2307724 2307724 defendant Smyth Thomas smith 604729 604729 Smyth, Thomas, of Newbury, Berks, smith 0
4839309 2308220 2308220 defendant Kyngeston Thomas   604729 604729 Kyngeston, Thomas, of Newbury, Berks, arrow maker 1
4850104 2311491 2311491 defendant Hendyng John fuller 604729 604729 Hendyng, John, of Newbury, Berks, fuller 0
4879459 2320504 2320504 defendant Halle William skinner 604729 604729 Halle, William, of Newbury, Berks, skinner 0
4879461 2320505 2320505 defendant Halle William skinner 604729 604729 Halle, William, of Newbury, Berks, skinner 0
4988364 2353488 2353488 defendant Bowyer Robert   604729 604729 Bowyer, Robert, of Newbury, Berks, bow maker 1
4988607 2353549 2353549 defendant Holnest John clerk 604729 604729 Holnest, John, of Newbury, Berks, clerk 1
4988611 2353550 2353550 defendant Waldre Vincent weaver 604729 604729 Waldre, Vincent, of Newbury, Berks, weaver 1
4994905 2355328 2355328 defendant Brise Thomas hosier 604729 604729 Brise, Thomas, of Newbury, Berks, hosier 0
4994911 2355331 2355331 defendant Hoiser Robert yeoman 604729 604729 Hoiser, Robert, of Newbury, Berks, yeoman 0
4999731 2356797 2356797 defendant Exe John chapman 604729 604729 Exe, John, of Newbury, Berks, chapman 1
5006752 2358871 2358871 defendant R_wo John fuller 604729 604729 R_wo, John, of Newbury, Berks, fuller 0
5128236 2394734 2394734 defendant Love Thomas chapman 604729 604729 Love, Thomas, of Newbury, Berks, chapman 1
5128240 2394735 2394735 defendant Love Thomas chapman 604729 604729 Love, Thomas, of Newbury, Berks, chapman 1
5150821 2401385 2401385 defendant Bentley Thomas chapman 604729 604729 Bentley, Thomas, of Newbury, Berks, chapman 1
5249132 2429867 2429867 defendant Okham Alice widow 604729 604729 Okham, Alice, of Newbury, Berks, widow 0
5250707 2430330 2430330 defendant Bedford John merchant 604729 604729 Bedford, John, of Newbury, Berks, merchant 0
5273579 2437348 2437348 defendant Crede John butcher 604729 604729 Crede, John, of Newbury, Berks, butcher 4
5310321 2448118 2448118 defendant Scarlok Thomas fuller 604729 604729 Scarlok, Thomas, of Newbury, Berks, fuller 0
5403534 2476080 2476080 defendant Whytewey John fuller 604729 604729 Whytewey, John, of Newbury, Berks, fuller 4
5415892 2479686 2479686 defendant Whytyngton William   604729 604729 Whytyngton, William, of Newbury, Berks 3
5420374 2481016 2481016 defendant Scarlok John hosier 604729 604729 Scarlok, John, of Newbury, Berks, hosier 0
5420376 2481017 2481017 defendant Scarlok John hosier 604729 604729 Scarlok, John, of Newbury, Berks, hosier 0
5420379 2481017 2481017 defendant Nevyll Alice widow 604729 604729 Nevyll, Alice, of Newbury, Berks, widow 3
5432468 2484683 2484683 defendant Whytyngton William gent 604729 604729 Whytyngton, William, of Newbury, Berks, gent 3
5439040 2486597 2486597 defendant Neweporte John weaver & clothier 604729 604729 Neweporte, John, of Newbury, Berks, weaver & clothier 3
5439159 2486636 2486636 defendant Scarlok John hosier 604729 604729 Scarlok, John, of Newbury, Berks, hosier 0
5439162 2486636 2486636 defendant Nevyll Alice widow 604729 604729 Nevyll, Alice, of Newbury, Berks, widow 3
5470183 2495998 2495998 defendant Soper Thomas kerseyman 604729 604729 Soper, Thomas, of Newbury, Berks, kerseyman 0
5501491 2505402 2505402 defendant Polhampton William spicer 604729 604729 Polhampton, William, of Newbury, Berks, spicer 0
5563741 2524006 2524006 defendant Weston John yeoman 604729 604729 Weston, John, of Newbury, Berks, yeoman 0
5563749 2524007 2524007 defendant Weston John yeoman 604729 604729 (Weston, John, of Newbury, Berks, yeoman 1
5563755 2524008 2524008 defendant Weston John yeoman 604729 604729 Weston, John, of Newbury, Berks, yeoman 0
5597836 2534221 2534221 plaintiff Devenyssh Thomas clothier 604729 604729 Devenyssh, Thomas, of Newbury, Berks, clothier 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);