names

57 rows where place_id = 587329

✎ 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
3591102 1864841 1864841 defendant Coldyk Robert mariner 587329 587329 Coldyk, Robert, of Wellys juxta Mare, mariner 0
3597889 1866961 1866961 defendant Howes Robert butcher 587329 587329 Howes, Robert, of Wellys juxta Mare, butcher 0
3597890 1866961 1866961 defendant Robynson William mariner 587329 587329 Robynson, William, of Wellys juxta Mare, mariner 1
3597893 1866961 1866961 defendant Clubbe William fishmonger 587329 587329 Clubbe, William, of Wellys juxta Mare, fishmonger 4
3607742 1870072 1870072 defendant Howes Robert butcher 587329 587329 Howes, Robert, of Wellys juxta Mare, butcher 0
3607743 1870072 1870072 defendant Robynson William mariner 587329 587329 Robynson, William, of Wellys juxta Mare, mariner 1
3617172 1872995 1872995 defendant Benyng Simon yeoman 587329 587329 Benyng, Simon, of Wellys juxta Mare, yeoman 3
3726131 1934437 1934437 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 1
3742303 1939463 1939463 defendant Cougham John yeoman 587329 587329 Cougham, John, of Wellys juxta Mare, yeoman 0
3751606 1942417 1942417 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 2
3767975 1947620 1947620 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 0
3784483 1952932 1952932 defendant Burgany Hugh yeoman 587329 587329 Burgany, Hugh, of Wellys juxta Mare, yeoman 1
3785347 1953205 1953205 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 0
3785662 1953306 1953306 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 0
3802499 1958678 1958678 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 3
3848496 1973110 1973110 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 0
3865610 1978715 1978715 defendant Goldsmyth Thomas yeoman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, yeoman 0
3883140 1984623 1984623 defendant Jekeler alias Jeckelowe John yeoman 587329 587329 Jekeler alias Jeckelowe, John, of Wellys juxta Mare, yeoman 0
3894152 1988260 1988260 defendant Goldsmyth Henry yeoman 587329 587329 (Goldsmyth, Henry, of Wellys juxta Mare, yeoman 2
3894157 1988261 1988261 defendant Goldsmyth Henry yeoman 587329 587329 (Goldsmyth, Henry, of Wellys juxta Mare, yeoman 1
4937019 2337953 2337953 defendant Williamson Richard husbandman 587329 587329 Williamson, Richard, of Wellys juxta Mare, husbandman 1
4943927 2340066 2340066 defendant Rammyng John laborer 587329 587329 Rammyng, John, of Wellys juxta Mare, laborer 4
4943932 2340067 2340067 defendant Edmond Margaret widow 587329 587329 Edmond, Margaret, of Wellys juxta Mare, widow 3
5014921 2361241 2361241 defendant Pollard Thomas shoemaker 587329 587329 Pollard, Thomas, of Wellys juxta Mare, shoemaker 0
5023135 2363668 2363668 plaintiff Gryggys John   587329 587329 Gryggys, John, of Wellys juxta Mare 2
5103409 2387424 2387424 defendant Bastard John husbandman 587329 587329 Bastard, John, of Wellys juxta Mare, husbandman 0
5112326 2389992 2389992 defendant Smyth John husbandman 587329 587329 Smyth, John, of Wellys juxta Mare, husbandman 0
5117522 2391557 2391557 defendant Walsokyn alias Smyth John husbandman 587329 587329 Walsokyn alias Smyth, John, of Wellys juxta Mare, husbandman 0
5123425 2393295 2393295 defendant Dodde John baker 587329 587329 Dodde, John, of Wellys juxta Mare, baker 0
5251078 2430440 2430440 defendant Wyllyamson alias Bocher Richard butcher 587329 587329 Wyllyamson alias Bocher, Richard, of Wellys juxta Mare, butcher 0
5251080 2430441 2430441 defendant Wyllyamson alias Bochere Richard butcher 587329 587329 Wyllyamson alias Bochere, Richard, of Wellys juxta Mare, butcher 0
5253077 2431069 2431069 defendant Bokeler William chipman 587329 587329 Bokeler, William, of Wellys juxta Mare, chipman 0
5258571 2432799 2432799 defendant Collys William yeoman 587329 587329 Collys, William, of Wellys juxta Mare, yeoman 0
5267155 2435486 2435486 defendant Tatyrshale alias Suthwell John (legal representative) 587329 587329 Tatyrshale alias Suthwell, John, of Wellys juxta Mare, clerk, executors of 0
5292840 2442899 2442899 defendant Dodde John baker 587329 587329 Dodde, John, of Wellys juxta Mare, baker 1
5296296 2443906 2443906 defendant Collys William yeoman 587329 587329 Collys, William, of Wellys juxta Mare, yeoman 0
5312715 2448840 2448840 defendant Collys William yeoman 587329 587329 Collys, William, of Wellys juxta Mare, yeoman 0
5315917 2449835 2449835 defendant Walsokyn John husbandman 587329 587329 Walsokyn, John, of Wellys juxta Mare, husbandman 3
5316162 2449910 2449910 defendant Collys William yeoman 587329 587329 Collys, William, of Wellys juxta Mare, yeoman 0
5316163 2449910 2449910 defendant Burgony Hugh yeoman 587329 587329 Burgony, Hugh, of Wellys juxta Mare, yeoman 1
5316998 2450162 2450162 defendant Smyth alias Walsokyn John smith 587329 587329 Smyth alias Walsokyn, John, of Wellys juxta Mare, smith 0
5324126 2452301 2452301 plaintiff Burgone Richard   587329 587329 Burgone, Richard, of Wellys juxta Mare 1
5329089 2453781 2453781 defendant Thornton Nicholas mariner 587329 587329 Thornton, Nicholas, of Wellys juxta Mare, mariner 0
5329090 2453781 2453781 defendant Bullok John yeoman 587329 587329 Bullok, John, of Wellys juxta Mare, yeoman 1
5337096 2456172 2456172 defendant Fuller Hugh husbandman 587329 587329 Fuller, Hugh, of Wellys juxta Mare, husbandman 2
5350345 2460230 2460230 plaintiff Collys William   587329 587329 Collys, William, of Wellys juxta Mare 0
5485459 2500562 2500562 defendant Grygges Thomas gent 587329 587329 Grygges, Thomas, of Wellys juxta Mare, gent 0
5516292 2509927 2509927 defendant Taverham Thomas gent 587329 587329 Taverham, Thomas, of Wellys juxta Mare, gent 1
5521506 2511542 2511542 plaintiff Clubb William yeoman 587329 587329 Clubb, William, of Wellys juxta Mare, yeoman 0
5531038 2514223 2514223 defendant Robynson William mariner 587329 587329 Robynson, William, of Wellys juxta Mare, mariner 2
5544825 2518490 2518490 defendant House Robert bowyer 587329 587329 House, Robert, of Wellys juxta Mare, bowyer 4
5558647 2522480 2522480 defendant Grygges Albricus gent 587329 587329 Grygges, Albricus, of Wellys juxta Mare, gent 0
5578300 2528282 2528282 defendant Thorp John baker 587329 587329 Thorp, John, of Wellys juxta Mare, baker 0
5579829 2528771 2528771 defendant Thorp John baker 587329 587329 Thorp, John, of Wellys juxta Mare, baker 0
5584855 2530341 2530341 defendant Warcop Robert yeoman 587329 587329 Warcop, Robert, of Wellys juxta Mare, yeoman 1
5595408 2533514 2533514 defendant Dodworth Thomas husbandman 587329 587329 Dodworth, Thomas, of Wellys juxta Mare, husbandman 1
5603149 2535871 2535871 defendant Cheteryng Nicholas husbandman 587329 587329 Cheteryng, Nicholas, of Wellys juxta Mare, husbandman 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);