names

64 rows where place_id = 586019

✎ 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
3587707 1863801 1863801 defendant Smyth Robert smith 586019 586019 Smyth, Robert, of South Cave, smith 1
3592365 1865228 1865228 defendant Aucbarowe Richard husbandman 586019 586019 Aucbarowe, Richard, of South Cave, husbandman 0
3620432 1873972 1873972 defendant Tenell John yeoman 586019 586019 Tenell, John, of South Cave, yeoman 0
3620433 1873972 1873972 defendant Mounder Stephen yeoman 586019 586019 Mounder, Stephen, of South Cave, yeoman 1
3622433 1874551 1874551 defendant Cokker Robert yeoman 586019 586019 Cokker, Robert, of South Cave, yeoman 0
3646401 1909269 1909269 defendant Ousteby Richard yeoman 586019 586019 Ousteby, Richard, of South Cave, yeoman 2
3724665 1933997 1933997 defendant Ledon Michael husbandman 586019 586019 Ledon, Michael, of South Cave, husbandman 0
3850433 1973727 1973727 defendant Johnson John, junior husbandman 586019 586019 Johnson, John, junior, of South Cave, husbandman 0
3850434 1973727 1973727 defendant Fowle John husbandman 586019 586019 Fowle, John, of South Cave, husbandman 1
3850435 1973727 1973727 defendant Leddell Michael husbandman 586019 586019 Leddell, Michael, of South Cave, husbandman 2
3850436 1973727 1973727 defendant Johnson William husbandman 586019 586019 Johnson, William, of South Cave, husbandman 3
3850437 1973727 1973727 defendant Johnson Richard husbandman 586019 586019 Johnson, Richard, of South Cave, husbandman 4
3895218 1988608 1988608 defendant Rypplyngham Hugh husbandman 586019 586019 Rypplyngham, Hugh, of South Cave, husbandman 0
4115254 2065747 2065747 defendant Hylton Roger gent 586019 586019 Hylton, Roger, of South Cave, gent 0
4178558 2087979 2087979 defendant Holmes John yeoman 586019 586019 Holmes, John, of South Cave, yeoman 0
4211609 2099610 2099610 defendant Todd Robert yeoman 586019 586019 Todd Robert, of South Cave, yeoman 1
4217428 2101589 2101589 defendant Johnson William   586019 586019 Johnson, William, of South Cave gent 0
4322547 2137952 2137952 defendant Todd Marmaduke yeoman 586019 586019 Todd, Marmaduke, of South Cave, yeoman 1
4341081 2144152 2144152 defendant Silverside Alvered yeoman 586019 586019 Silverside, Alvered, of South Cave, yeoman 0
4352249 2148021 2148021 defendant West William yeoman 586019 586019 West, William, of South Cave, yeoman 0
4420774 2171398 2171398 plaintiff Castel Donyngton William de   586019 586019 Castel Donyngton, William de, of South Cave 0
4420776 2171398 2171398 defendant Watekyn John   586019 586019 Watekyn, John, of South Cave 0
4508082 2203000 2203000 defendant Wythornwyk John de   586019 586019 Wythornwyk, John de, of South Cave 0
4508085 2203001 2203001 defendant Wythornwyk John   586019 586019 Wythornwyk, John, of South Cave 0
4562406 2219802 2219802 defendant Popilton John   586019 586019 Popilton, John, of South Cave, vicar 2
4564515 2220463 2220463 defendant Santon Thomas   586019 586019 Santon, Thomas, of South Cave 1
4564829 2220567 2220567 defendant Milner John   586019 586019 Milner, John, of South Cave 0
4596215 2230069 2230069 defendant Santon Thomas de   586019 586019 Santon, Thomas de, of South Cave 0
4655510 2247616 2247616 defendant atte Crosse Richard yeoman 586019 586019 atte Crosse, Richard, of South Cave, yeoman 0
4655511 2247616 2247616 defendant atte Crosse John yeoman 586019 586019 atte Crosse, John, of South Cave, yeoman 1
4660079 2248995 2248995 plaintiff de Santon Richard   586019 586019 de Santon, Richard, of South Cave 0
4660080 2248995 2248995 plaintiff de Santon Robert   586019 586019 de Santon, Robert, of South Cave 1
4699551 2265311 2265311 defendant Santon del Walde Thomas de esq 586019 586019 Santon del Walde, Thomas de, of South Cave, esq 1
4711213 2268859 2268859 defendant Santon Thomas gent 586019 586019 Santon, Thomas, of South Cave, gent 1
4733926 2275795 2275795 defendant Santon Thomas gent 586019 586019 Santon, Thomas, of South Cave, gent 4
4816137 2301135 2301135 plaintiff Lounde Alexander   586019 586019 Lounde, Alexander, of South Cave 0
4835046 2306962 2306962 plaintiff Dannay John   586019 586019 Dannay, John, of South Cave 0
4846434 2310390 2310390 defendant Frankys Thomas chaplain 586019 586019 Frankys, Thomas, of South Cave, chaplain 0
4847551 2310734 2310734 defendant Frankys Thomas chaplain 586019 586019 Frankys, Thomas, of South Cave, chaplain 1
4852618 2312240 2312240 defendant Lound Robert husbandman 586019 586019 Lound, Robert, of South Cave, husbandman 0
4898465 2326173 2326173 defendant Brabson William husbandman 586019 586019 Brabson, William, of South Cave, husbandman 2
4948758 2341593 2341593 defendant Payntour Thomas husbandman 586019 586019 Payntour, Thomas, of South Cave, husbandman 0
4986851 2353006 2353006 plaintiff Barnby William   586019 586019 Barnby, William, of South Cave, vicar 0
4987061 2353076 2353076 plaintiff Baynton Agnes (legal representative) 586019 586019 Baynton, Agnes, of South Cave, executors of 0
4987063 2353076 2353076 plaintiff (not given) William vicar of Barneby 586019 586019 Barneby, William, of South Cave, vicar of All Saints church 2
4991672 2354392 2354392 defendant Assheton William husbandman 586019 586019 Assheton, William, of South Cave, husbandman 2
5129196 2395028 2395028 plaintiff Crosby William   586019 586019 Crosby, William, of South Cave 0
5148422 2400669 2400669 plaintiff Crosby William   586019 586019 Crosby, William, of South Cave 0
5159568 2403915 2403915 defendant Shawe Robert walker 586019 586019 Shawe, Robert, of South Cave, walker 1
5159571 2403915 2403915 defendant Robynson John husbandman 586019 586019 Robynson, John, of South Cave, husbandman 4
5195389 2414402 2414402 defendant Shawe Robert walker 586019 586019 Shawe, Robert, of South Cave, walker 1
5195392 2414402 2414402 defendant Robynson John husbandman 586019 586019 Robynson, John, of South Cave, husbandman 4
5223028 2422452 2422452 defendant Crosseby William   586019 586019 Crosseby, William, of South Cave, franklin 2
5276724 2438274 2438274 defendant Johnson William weaver 586019 586019 Johnson, William, of South Cave, weaver 0
5327145 2453193 2453193 defendant Peyrson Andrew husbandman 586019 586019 Peyrson, Andrew, of South Cave, husbandman 6
5328486 2453595 2453595 defendant Rowte John husbandman 586019 586019 Rowte, John, of South Cave, husbandman 0
5328487 2453595 2453595 defendant Payntour John husbandman 586019 586019 Payntour, John, of South Cave, husbandman 1
5368598 2465775 2465775 defendant Crosseby William yeoman 586019 586019 Crosseby, William, of South Cave, yeoman 1
5412137 2478585 2478585 defendant Crosseby William yeoman 586019 586019 Crosseby, William, of South Cave, yeoman 1
5412143 2478587 2478587 defendant Crosseby William yeoman 586019 586019 Crosseby, William, of South Cave, yeoman 1
5500835 2505193 2505193 defendant London John gent 586019 586019 London, John, of South Cave, gent 0
5510557 2508138 2508138 defendant Grene Robert yeoman 586019 586019 Grene, Robert, of South Cave, yeoman 0
5515375 2509654 2509654 defendant London John gent 586019 586019 London, John, of South Cave, gent 0
5620492 2550267 2550267 defendant Pyrot Robert   586019 586019 Pyrot, Robert, of South Cave 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);