names

57 rows where place_id = 603006

✎ 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
3619296 1873638 1873638 defendant Burgh Edward   603006 603006 Burgh, Edward, of Gaynesburgh, Lincs, knight 0
3619298 1873639 1873639 defendant Burgh Edward   603006 603006 Burgh, Edward, of Gaynesburgh, Lincs, knight 0
3625111 1875388 1875388 defendant Balderston John   603006 603006 Balderston, John, of Gaynesburgh, Lincs, parish clerk 2
3652643 1911160 1911160 defendant Tyndale Philip gent 603006 603006 Tyndale, Philip, of Gaynesburgh, Lincs, gent 4
3653097 1911299 1911299 defendant Burgh Edward   603006 603006 Burgh, Edward, of Gaynesburgh, Lincs, knight 0
3696451 1925116 1925116 defendant Johnson Roger merchant of the staple 603006 603006 Johnson, Roger, of Gaynesburgh, Lincs, merchant of the staple 0
3697500 1925439 1925439 defendant Johnson Roger yeoman 603006 603006 Johnson, Roger, of Gaynesburgh, Lincs, yeoman 0
3706626 1928357 1928357 defendant Burgh Edward   603006 603006 Burgh, Edward, of Gaynesburgh, Lincs, knight 1
3766243 1947095 1947095 defendant Burgh Cuthbert gent 603006 603006 Burgh, Cuthbert, of Gaynesburgh, Lincs, gent 0
3810591 1961210 1961210 defendant Came Richard butcher 603006 603006 Came, Richard, of Gaynesburgh, Lincs, butcher 0
3816379 1963032 1963032 defendant Johnson Roger yeoman 603006 603006 Johnson, Roger, of Gaynesburgh, Lincs, yeoman 0
3823464 1965242 1965242 defendant Brough Thomas   603006 603006 Brough, Thomas, of Gaynesburgh, Lincs, knight 0
3854258 1974968 1974968 defendant Cotton Humphrey clerk 603006 603006 Cotton, Humphrey, of Gaynesburgh, Lincs, or of Hytchyn, Herts, clerk 0
3910484 1993822 1993822 defendant Foderby George gent 603006 603006 Foderby, George, of Gaynesburgh, Lincs, gent 0
4707676 2267764 2267764 defendant del Hall John tanner 603006 603006 del Hall, John, of Gaynesburgh, Lincs, tanner 2
4727232 2273777 2273777 defendant Neweton William yeoman 603006 603006 Neweton, William, of Gaynesburgh, Lincs, yeoman 0
4755927 2282237 2282237 defendant Mitford Thomas gent 603006 603006 Mitford, Thomas, of Gaynesburgh, Lincs, gent 2
4795918 2294872 2294872 defendant Mitford Thomas gent 603006 603006 Mitford, Thomas, of Gaynesburgh, Lincs, gent 0
4837540 2307677 2307677 defendant Canston or Causton Roger tanner 603006 603006 Canston or Causton, Roger, of Gaynesburgh, Lincs, tanner 0
4837550 2307680 2307680 defendant Causton Roger tanner 603006 603006 Causton, Roger, of Gaynesburgh, Lincs, tanner 0
4877051 2319794 2319794 defendant Hayles Walter husbandman 603006 603006 Hayles, Walter, of Gaynesburgh, Lincs, husbandman 0
4883586 2321783 2321783 defendant Noreys John merchant 603006 603006 Noreys, John, of Gaynesburgh, Lincs, merchant 3
4886445 2322619 2322619 defendant Dathell Elizabeth widow 603006 603006 Dathell, Elizabeth, of Gaynesburgh, Lincs, widow 1
4909132 2329398 2329398 defendant Lucy Willam   603006 603006 Lucy, Willam, of Gaynesburgh, Lincs, knight 0
4941016 2339209 2339209 defendant Bytheway John   603006 603006 Bytheway, John, of Gaynesburgh, Lincs, "cogman" 3
4948577 2341534 2341534 defendant Flete John gent 603006 603006 Flete, John, of Gaynesburgh, Lincs, gent 0
4948579 2341535 2341535 defendant Flete John gent 603006 603006 Flete, John, of Gaynesburgh, Lincs, gent 0
4978881 2350640 2350640 defendant Hayles John yeoman 603006 603006 Hayles, John, of Gaynesburgh, Lincs, yeoman 2
4991585 2354367 2354367 defendant Wevell John yeoman 603006 603006 Wevell, John, of Gaynesburgh, Lincs, yeoman 2
5000238 2356946 2356946 defendant Rouchestre Richard   603006 603006 Rouchestre, Richard, of Gaynesburgh, Lincs, bailiff 0
5000249 2356949 2356949 defendant Rouchestre Richard   603006 603006 Rouchestre, Richard, of Gaynesburgh, Lincs, bailiff 0
5061908 2375157 2375157 defendant Godeman Gilbert waterman 603006 603006 Godeman, Gilbert, of Gaynesburgh, Lincs, waterman 0
5067187 2376705 2376705 defendant Pykhowe Thomas merchant 603006 603006 Pykhowe, Thomas, of Gaynesburgh, Lincs, merchant 1
5067189 2376706 2376706 defendant Kynge William merchant 603006 603006 Kynge, William, of Gaynesburgh, Lincs, merchant 0
5067195 2376707 2376707 defendant Hanworth John merchant 603006 603006 Hanworth, John, of Gaynesburgh, Lincs, merchant 2
5067253 2376718 2376718 defendant Everard John merchant 603006 603006 Everard, John, of Gaynesburgh, Lincs, merchant 8
5084943 2382002 2382002 defendant Dalisson Robert merchant of the staple 603006 603006 Dalisson, Robert, of Gaynesburgh, Lincs, merchant of the staple 0
5084946 2382003 2382003 defendant Dalisson Robert merchant of the staple 603006 603006 Dalisson, Robert, of Gaynesburgh, Lincs, merchant of the staple 0
5090855 2383716 2383716 plaintiff Catley Edmund   603006 603006 Catley, Edmund, of Gaynesburgh, Lincs 2
5122627 2393051 2393051 defendant Fulbank William fisher 603006 603006 Fulbank, William, of Gaynesburgh, Lincs, fisher 0
5136404 2397167 2397167 defendant Kyng William   603006 603006 Kyng, William, of Gaynesburgh, Lincs 3
5170045 2406975 2406975 defendant Sharpe Henry mercer 603006 603006 Sharpe, Henry, of Gaynesburgh, Lincs, mercer 0
5187381 2412036 2412036 defendant Sharpe Henry mercer 603006 603006 Sharpe, Henry, of Gaynesburgh, Lincs, mercer 0
5187386 2412037 2412037 defendant Sharpe Henry mercer 603006 603006 Sharpe, Henry, of Gaynesburgh, Lincs, mercer 0
5196565 2414747 2414747 defendant Flete John gent 603006 603006 Flete, John, of Gaynesburgh, Lincs, gent 0
5205579 2417378 2417378 defendant Sharpe Henry mercer 603006 603006 Sharpe, Henry, of Gaynesburgh, Lincs, mercer 0
5209698 2418576 2418576 defendant Flete John gent 603006 603006 Flete, John, of Gaynesburgh, Lincs, gent 0
5226135 2423308 2423308 defendant Everard John, senior merchant 603006 603006 Everard, John, senior, of Gaynesburgh, Lincs, merchant 0
5230096 2424419 2424419 defendant Wyntur Thomas chapman 603006 603006 Wyntur, Thomas, of Gaynesburgh, Lincs, chapman 4
5230107 2424421 2424421 defendant Wyntur Thomas chapman 603006 603006 Wyntur, Thomas, of Gaynesburgh, Lincs, chapman 4
5236499 2426261 2426261 defendant Burgh Thomas   603006 603006 Burgh, Thomas, of Gaynesburgh, Lincs, knight 0
5296476 2443959 2443959 defendant Leysthorp Robert laborer 603006 603006 Leysthorp, Robert, of Gaynesburgh, Lincs, laborer 2
5340665 2457280 2457280 defendant Tyndale Thomas gent 603006 603006 Tyndale, Thomas, of Gaynesburgh, Lincs, gent 1
5374242 2467544 2467544 defendant Wyldy William yeoman 603006 603006 Wyldy, William, of Gaynesburgh, Lincs, yeoman 3
5550554 2520185 2520185 defendant Hall Roger saddler 603006 603006 Hall, Roger, of Gaynesburgh, Lincs, saddler 0
5577906 2528162 2528162 defendant Burgh Edward   603006 603006 Burgh, Edward, of Gaynesburgh, Lincs, knight 0
5635059 2554951 2554951 defendant Burdet John esq 603006 603006 Burdet, John, of Gaynesburgh, Lincs, esq 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);