names

51 rows where place_id = 610007

✎ 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
3681503 1920306 1920306 plaintiff Smyth John   610007 610007 Smyth, John, of Hicchyn 0
3723391 1933584 1933584 defendant Smyth Roger yeoman 610007 610007 Smyth, Roger, of Hicchyn, yeoman 1
4525183 2208215 2208215 defendant wynter John fishmonger 610007 610007 wynter, John, of Hicchyn, fishmonger 3
4668488 2255852 2255852 plaintiff Beaufew Thomas   610007 610007 Beaufew, Thomas, of Hicchyn 0
4723094 2272533 2272533 defendant Day William butcher 610007 610007 Day, William, of Hicchyn, butcher 0
4794351 2294377 2294377 defendant Ruddok John   610007 610007 Ruddok, John, of Hicchyn, bailiff 0
4794933 2294560 2294560 defendant Bosevyle Ralph husbandman 610007 610007 Bosevyle, Ralph, of Hicchyn, husbandman 2
4794934 2294560 2294560 defendant Love William husbandman 610007 610007 Love, William, of Hicchyn, husbandman 3
4833510 2306487 2306487 defendant Bays John butcher 610007 610007 Bays, John, of Hicchyn, butcher 0
4833512 2306488 2306488 defendant Bays John butcher 610007 610007 Bays, John, of Hicchyn, butcher 0
4833513 2306488 2306488 defendant Halle Richard tanner 610007 610007 Halle, Richard, of Hicchyn, tanner 1
4842354 2309140 2309140 defendant Bays John butcher 610007 610007 Bays, John, of Hicchyn, butcher 0
4842355 2309140 2309140 defendant Halle Richard tanner 610007 610007 Halle, Richard, of Hicchyn, tanner 1
4846737 2310488 2310488 defendant Waterman Robert   610007 610007 Waterman, Robert, of Hicchyn, wheel wright 0
4940640 2339101 2339101 defendant Quelard Ralph butcher 610007 610007 Quelard, Ralph, of Hicchyn, butcher 0
4951368 2342391 2342391 defendant Campion Nicholas clerk 610007 610007 Campion, Nicholas, of Hicchyn, clerk 0
4951369 2342391 2342391 defendant Sutton Henry yeoman 610007 610007 Sutton, Henry, of Hicchyn, yeoman 1
4962350 2345640 2345640 defendant Spygon John gent 610007 610007 Spygon, John, of Hicchyn, gent 0
4963666 2346044 2346044 defendant Cook John husbandman 610007 610007 Cook, John, of Hicchyn, husbandman 0
4963670 2346045 2346045 defendant Cook John husbandman 610007 610007 Cook, John, of Hicchyn, husbandman 2
4975240 2349549 2349549 defendant Boldero John yeoman 610007 610007 Boldero, John, of Hicchyn, yeoman 0
5030538 2365803 2365803 defendant Dorkyn John   610007 610007 Dorkyn, John, of Hicchyn, shepherd 0
5030540 2365803 2365803 defendant Payntour John painrer 610007 610007 Payntour, John, of Hicchyn, painrer 2
5030541 2365803 2365803 defendant Bayes John butcher 610007 610007 Bayes, John, of Hicchyn, butcher 3
5030542 2365803 2365803 defendant Clay Robert husbandman 610007 610007 Clay, Robert, of Hicchyn, husbandman 4
5030876 2365902 2365902 defendant Barton Richard   610007 610007 Barton, Richard, of Hicchyn, notary 0
5030877 2365902 2365902 defendant Tayllour John butcher 610007 610007 Tayllour, John, of Hicchyn, butcher 1
5112209 2389952 2389952 defendant Mathewe Roger chapman 610007 610007 Mathewe, Roger, of Hicchyn, chapman 0
5182599 2410666 2410666 plaintiff Coke John   610007 610007 Coke, John, of Hicchyn 0
5190073 2412838 2412838 defendant Hunsseel Thomas dyer 610007 610007 Hunsseel, Thomas, of Hicchyn, dyer 1
5212769 2419482 2419482 defendant Quyllard Ralph butcher 610007 610007 Quyllard, Ralph, of Hicchyn, butcher 0
5216754 2420635 2420635 defendant Bestney William yeoman 610007 610007 Bestney, William, of Hicchyn, yeoman 2
5222698 2422354 2422354 defendant Taillour John butcher 610007 610007 Taillour, John, of Hicchyn, butcher 0
5224449 2422820 2422820 plaintiff Pulter John   610007 610007 Pulter, John, of Hicchyn 0
5224452 2422820 2422820 defendant Taylour John butcher 610007 610007 Taylour, John, of Hicchyn, butcher 2
5235765 2426035 2426035 defendant Bestney Thomas chapman 610007 610007 Bestney, Thomas, of Hicchyn, chapman 1
5237495 2426549 2426549 defendant Pulter John   610007 610007 Pulter, John, of Hicchyn 1
5261404 2433673 2433673 defendant Stoppesley John baker 610007 610007 Stoppesley, John, of Hicchyn, baker 0
5265284 2434902 2434902 defendant Segewyk John widow 610007 610007 Segewyk, John, of Hicchyn, widow 0
5265285 2434902 2434902 defendant Lyndesey Hugh hosier 610007 610007 Lyndesey, Hugh, of Hicchyn, hosier 1
5307748 2447333 2447333 plaintiff Pulter John gent 610007 610007 Pulter, John, of Hicchyn, gent 0
5355705 2461863 2461863 defendant Bottour Thomas tanner 610007 610007 Bottour, Thomas, of Hicchyn, tanner 0
5355706 2461863 2461863 defendant Frost John tanner 610007 610007 Frost, John, of Hicchyn, tanner 1
5363646 2464285 2464285 defendant Taylour William yeoman 610007 610007 Taylour, William, of Hicchyn, yeoman 0
5382722 2470121 2470121 plaintiff Snowe John   610007 610007 Snowe, John, of Hicchyn 0
5384389 2470622 2470622 defendant Lawe William tilemaker 610007 610007 Lawe, William, of Hicchyn, tilemaker 2
5498552 2504511 2504511 defendant Taillour Richard husbandman 610007 610007 Taillour, Richard, of Hicchyn, husbandman 1
5578332 2528293 2528293 defendant Berne John husbandman 610007 610007 Berne, John, of Hicchyn, husbandman 0
5579403 2528637 2528637 defendant Baker William yeoman or clerk 610007 610007 Baker, William, of Hicchyn, yeoman or clerk 0
5604534 2536280 2536280 defendant Hall John stringer 610007 610007 Hall, John, of Hicchyn, stringer 1
5625051 2551772 2551772 defendant Bestnye Richard cordwainer 610007 610007 Bestnye, Richard, of Hicchyn, cordwainer 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);