names

54 rows where place_id = 586763

✎ 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
3589556 1864373 1864373 defendant Potage Evan husbandman 586763 586763 Potage, Evan, of Rycall, husbandman 0
3611556 1871285 1871285 defendant Bank Richard gent 586763 586763 Bank, Richard, of Rycall, gent 0
3611557 1871285 1871285 defendant Potage Hugh husbandman 586763 586763 Potage, Hugh, of Rycall, husbandman 1
3611558 1871285 1871285 defendant Potage Roger husbandman 586763 586763 Potage, Roger, of Rycall, husbandman 2
3611559 1871285 1871285 defendant Leyeng Robert husbandman 586763 586763 Leyeng, Robert, of Rycall, husbandman 3
3611560 1871285 1871285 defendant Malynson John husbandman 586763 586763 Malynson, John, of Rycall, husbandman 4
3611561 1871285 1871285 defendant Honedon Christopher husbandman 586763 586763 Honedon, Christopher, of Rycall, husbandman 5
3611562 1871285 1871285 defendant Emundson John husbandman 586763 586763 Emundson, John, of Rycall, husbandman 6
3611563 1871285 1871285 defendant Cheston Christopher husbandman 586763 586763 Cheston, Christopher, of Rycall, husbandman 7
3620233 1873906 1873906 defendant Russell Nicholas carpenter 586763 586763 Russell, Nicholas, of Rycall, carpenter 0
3620234 1873906 1873906 defendant Russell John carpenter 586763 586763 Russell, John, of Rycall, carpenter 1
3620235 1873906 1873906 defendant Cooke James laborer 586763 586763 Cooke, James, of Rycall, laborer 2
3624343 1875147 1875147 defendant Candeler Agnes widow 586763 586763 Candeler, Agnes, of Rycall, widow 2
3837665 1969691 1969691 defendant Wode William weaver 586763 586763 Wode, William, of Rycall, weaver 2
3868132 1979578 1979578 defendant Stynger William yeoman 586763 586763 Stynger, William, of Rycall, yeoman 1
3885041 1985257 1985257 defendant Fletcher Robert tailor 586763 586763 Fletcher, Robert, of Rycall, tailor 0
3888457 1986402 1986402 defendant Gascoign Ralph gent 586763 586763 Gascoign, Ralph, of Rycall, gent 0
3942911 2004632 2004632 defendant Smyth William milner 586763 586763 Smyth, William, of Rycall, milner 0
4030413 2035533 2035533 defendant Newbye Ambrose gent 586763 586763 Newbye, Ambrose, of Rycall, gent 0
4055158 2044236 2044236 defendant Newby Ambrose gent 586763 586763 Newby, Ambrose, of Rycall, gent 0
4055160 2044237 2044237 defendant Newby Ambrose yeoman 586763 586763 Newby, Ambrose, of Rycall, yeoman 0
4096673 2059137 2059137 defendant Garthe James laborer 586763 586763 Garthe, James, of Rycall, laborer 0
4096674 2059137 2059137 defendant Carter Richard laborer 586763 586763 Carter, Richard, of Rycall, laborer 1
4199608 2095414 2095414 defendant Barton Thomas yeoman 586763 586763 Barton, Thomas, of Rycall, yeoman 0
4257311 2115422 2115422 defendant Heslington Marmaduke waterman 586763 586763 Heslington, Marmaduke, of Rycall, waterman 0
4508157 2203027 2203027 defendant Sudburgh John   586763 586763 Sudburgh, John, of Rycall 1
4519438 2206439 2206439 defendant Smytbarn John   586763 586763 Smytbarn, John, of Rycall 3
4519439 2206439 2206439 defendant Denyas Walter   586763 586763 Denyas, Walter, of Rycall 4
4532023 2210281 2210281 defendant Pek John   586763 586763 Pek, John, of Rycall 0
4542586 2213567 2213567 defendant Call Robert   586763 586763 Call, Robert, of Rycall 0
4558687 2218669 2218669 defendant Jonson John   586763 586763 Jonson, John, of Rycall 8
4564279 2220398 2220398 defendant Gascon John   586763 586763 Gascon, John, of Rycall 0
4565141 2220667 2220667 defendant Call Robert, sen   586763 586763 Call, Robert, sen, of Rycall 1
4591787 2228785 2228785 defendant Cook Thomas   586763 586763 Cook, Thomas, of Rycall 3
4600931 2231517 2231517 defendant Fairechild Peter   586763 586763 Fairechild, Peter, of Rycall 0
4620276 2237325 2237325 defendant Hawys John   586763 586763 Hawys, John, of Rycall 0
4623620 2238367 2238367 defendant Pas John   586763 586763 Pas, John, of Rycall 3
4707402 2267693 2267693 plaintiff Merston Robert de   586763 586763 Merston, Robert de, of Rycall 0
4708126 2267918 2267918 defendant Jonyson John husbandman 586763 586763 Jonyson, John, of Rycall, husbandman 0
4808170 2298731 2298731 defendant Jonson John husbandman 586763 586763 Jonson, John, of Rycall, husbandman 0
4861172 2314854 2314854 defendant Keld John husbandman 586763 586763 Keld, John, of Rycall, husbandman 0
4968076 2347397 2347397 defendant Marshall William smith 586763 586763 Marshall, William, of Rycall, smith 0
5028294 2365154 2365154 defendant Belford William gent 586763 586763 Belford, William, of Rycall, gent 0
5152824 2401965 2401965 defendant Morley Roger yeoman 586763 586763 Morley, Roger, of Rycall, yeoman 1
5211963 2419238 2419238 defendant Morley Roger yeoman 586763 586763 Morley, Roger, of Rycall, yeoman 0
5211964 2419238 2419238 defendant Chylde alias Childe Yonge John yeoman or fisher 586763 586763 Chylde alias Childe Yonge, John, of Rycall, yeoman or fisher 1
5211965 2419238 2419238 defendant Smythbarn Thomas weaver 586763 586763 Smythbarn, Thomas, of Rycall, weaver 2
5215087 2420137 2420137 defendant Morley Roger yeoman 586763 586763 Morley, Roger, of Rycall, yeoman 0
5283639 2440264 2440264 defendant Jakson John yeoman 586763 586763 Jakson, John, of Rycall, yeoman 2
5283640 2440264 2440264 defendant Watson Thomas laborer 586763 586763 Watson, Thomas, of Rycall, laborer 3
5320971 2451364 2451364 plaintiff Lare John   586763 586763 Lare, John, of Rycall, cartwright 0
5327132 2453190 2453190 defendant Bank Richard gent 586763 586763 Bank, Richard, of Rycall, gent 0
5368605 2465778 2465778 defendant Holstok John husbandman 586763 586763 Holstok, John, of Rycall, husbandman 1
5371519 2466678 2466678 defendant Davy Richard clerk & Master 586763 586763 Davy, Richard, of Rycall, clerk & Master 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);