names

144 rows where place_id = 587384

✎ 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
3591261 1864892 1864892 defendant Coke John husbandman 587384 587384 Coke, John, of Lyston, husbandman 4
3593705 1865669 1865669 defendant Chagesty William yeoman 587384 587384 Chagesty, William, of Lyston, yeoman 0
3598291 1867096 1867096 defendant Fouler Richard yeoman 587384 587384 Fouler, Richard, of Lyston, yeoman 3
3607148 1869900 1869900 defendant Harrys John husbandman 587384 587384 Harrys, John, of Lyston, husbandman 4
3607149 1869900 1869900 defendant Frere Thomas husbandman 587384 587384 Frere, Thomas, of Lyston, husbandman 5
3611714 1871325 1871325 defendant Harrys John husbandman 587384 587384 Harrys, John, of Lyston, husbandman 4
3611715 1871325 1871325 defendant Frere Thomas husbandman 587384 587384 Frere, Thomas, of Lyston, husbandman 5
3650448 1910508 1910508 defendant Holman Nicholas   587384 587384 Holman, Nicholas, of Lyston, mason 0
3664690 1914908 1914908 defendant Grene John (legal representative) 587384 587384 Grene, John, of Lyston, executors of 0
3682165 1920529 1920529 defendant Harry Patrick husbandman 587384 587384 Harry, Patrick, of Lyston, husbandman 0
3682166 1920529 1920529 defendant Stephyn Walter husbandman 587384 587384 Stephyn, Walter, of Lyston, husbandman 1
3682167 1920529 1920529 defendant Hendre John husbandman 587384 587384 Hendre, John, of Lyston, husbandman 2
3682168 1920529 1920529 defendant Genys John husbandman 587384 587384 Genys, John, of Lyston, husbandman 3
3682169 1920529 1920529 defendant Bokenham John husbandman 587384 587384 Bokenham, John, of Lyston, husbandman 4
3691421 1923476 1923476 defendant Mone William husbandman 587384 587384 Mone, William, of Lyston, husbandman 0
3705597 1928031 1928031 defendant Escote William smith 587384 587384 Escote, William, of Lyston, smith 0
3763684 1946285 1946285 defendant Pellewe Henry husbandman 587384 587384 Pellewe, Henry, of Lyston, husbandman 0
3763685 1946285 1946285 defendant Pellowe John husbandman 587384 587384 Pellowe, John, of Lyston, husbandman 1
3763686 1946285 1946285 defendant Stondon John husbandman 587384 587384 Stondon, John, of Lyston, husbandman 2
3763687 1946285 1946285 defendant Wollrigge Oliver husbandman 587384 587384 Wollrigge, Oliver, of Lyston, husbandman 3
3778618 1951024 1951024 defendant Moyn William yeoman 587384 587384 Moyn, William, of Lyston, yeoman 1
3778619 1951024 1951024 defendant Porter Walter husbandman 587384 587384 Porter, Walter, of Lyston, husbandman 2
3778621 1951024 1951024 defendant Morleys William yeoman 587384 587384 Morleys, William, of Lyston, yeoman 4
3779387 1951275 1951275 defendant Pratte John husbandman 587384 587384 Pratte, John, of Lyston, husbandman 0
3935646 2002234 2002234 defendant Wyllyams John husbandman 587384 587384 Wyllyams, John, of Lyston, husbandman 0
4022587 2032802 2032802 defendant Hutchyns William husbandman 587384 587384 Hutchyns, William, of Lyston, husbandman 0
4022590 2032803 2032803 defendant Hutchyns William husbandman 587384 587384 Hutchyns, William, of Lyston, husbandman 0
4037530 2038084 2038084 defendant Holman Nicholas husbandman 587384 587384 Holman, Nicholas, of Lyston, husbandman 0
4054936 2044159 2044159 defendant Cooke Thomas husbandman 587384 587384 Cooke, Thomas, of Lyston, husbandman 0
4092860 2057757 2057757 defendant Chamberlen Thomas husbandman 587384 587384 Chamberlen, Thomas, of Lyston, husbandman 0
4223411 2103680 2103680 defendant Lowther William clerk 587384 587384 Lowther, William, of Lyston, clerk 0
4223412 2103680 2103680 defendant Rayner William miller 587384 587384 Rayner, William, of Lyston, miller 1
4223413 2103680 2103680 defendant Blyes Ralph yeoman 587384 587384 Blyes, Ralph, of Lyston, yeoman 2
4223414 2103680 2103680 defendant Wilson Francis yeoman 587384 587384 Wilson, Francis, of Lyston, yeoman 3
4241320 2110082 2110082 defendant Lowther William clerk 587384 587384 Lowther, William, of Lyston, clerk 0
4248709 2112554 2112554 defendant Lowther William clerk 587384 587384 Lowther, William, of Lyston, clerk 0
4248711 2112554 2112554 defendant Blyes Ralph yeoman 587384 587384 Blyes, Ralph, of Lyston, yeoman 2
4250505 2113157 2113157 defendant Clopton William, junior   587384 587384 Clopton, William, junior, of Lyston, gent, his son 1
4264749 2117851 2117851 defendant Clopton William, junior   587384 587384 Clopton, William, junior, of Lyston, gent, his son 1
4339384 2143543 2143543 defendant Clopton William, junior   587384 587384 Clopton, William, junior, of Lyston, gent, his son 1
4339387 2143544 2143544 defendant Clopton William, junior   587384 587384 Clopton, William, junior, of Lyston, gent, his son 1
4347907 2146520 2146520 defendant Rogers Edward yeoman 587384 587384 Rogers, Edward, of Lyston, yeoman 2
4348845 2146858 2146858 defendant Clopton William, junior gent 587384 587384 Clopton, William, junior, of Lyston, gent 1
4348846 2146858 2146858 defendant Clopton Francis gent 587384 587384 Clopton, Francis, of Lyston, gent 2
4349120 2146952 2146952 defendant Clopton William, junior   587384 587384 Clopton, William, junior, of Lyston, Essex gent 0
4519748 2206533 2206533 defendant Nicholl William   587384 587384 Nicholl, William, of Lyston 2
4595416 2229822 2229822 defendant Warde John   587384 587384 Warde, John, of Lyston 0
4601280 2231635 2231635 defendant Cadley John   587384 587384 Cadley, John, of Lyston 0
4628492 2239831 2239831 defendant Stanton Gilbert   587384 587384 Stanton, Gilbert, of Lyston 1
4637075 2242398 2242398 defendant Warde John   587384 587384 Warde, John, of Lyston 6
4681748 2259903 2259903 defendant Hyndeford Roger   587384 587384 Hyndeford, Roger, of Lyston, franklin 0
4699031 2265168 2265168 defendant Mostard William   587384 587384 Mostard, William, of Lyston, bailiff 3
4708058 2267896 2267896 defendant Hyndeford Roger   587384 587384 Hyndeford, Roger, of Lyston, franklin 0
4723426 2272637 2272637 defendant Putford William husbandman 587384 587384 Putford, William, of Lyston, husbandman 0
4723427 2272637 2272637 defendant Hillowe John laborer 587384 587384 Hillowe, John, of Lyston, laborer 1
4756236 2282322 2282322 defendant Rigne John   587384 587384 Rigne, John, of Lyston, bailiff 3
4756240 2282323 2282323 defendant Mosterd William husbandman 587384 587384 Mosterd, William, of Lyston, husbandman 2
4757134 2282602 2282602 defendant Moigne John   587384 587384 Moigne, John, of Lyston 1
4775765 2288417 2288417 defendant Saundre Walter husbandman 587384 587384 Saundre, Walter, of Lyston, husbandman 0
4777119 2288823 2288823 defendant Lete John husbandman 587384 587384 Lete, John, of Lyston, husbandman 0
4777120 2288823 2288823 defendant Lete William husbandman 587384 587384 Lete, William, of Lyston, husbandman 1
4779126 2289447 2289447 defendant Moigne John   587384 587384 Moigne, John, of Lyston, bailiff 1
4783079 2290726 2290726 defendant Lynam Walter husbandman 587384 587384 (Lynam, Walter, of Lyston, husbandman 1
4789556 2292805 2292805 defendant Huntyngford John husbandman 587384 587384 Huntyngford, John, of Lyston, husbandman 0
4789557 2292805 2292805 defendant Hoper Richard hooper 587384 587384 Hoper, Richard, of Lyston, hooper 1
4789558 2292805 2292805 defendant Mouns John, junior yeoman 587384 587384 Mouns, John, junior, of Lyston, yeoman 2
4795860 2294855 2294855 defendant Lenne Walter husbandman 587384 587384 Lenne, Walter, of Lyston, husbandman 1
4795865 2294856 2294856 defendant Hunynford John husbandman 587384 587384 Hunynford, John, of Lyston, husbandman 3
4813489 2300329 2300329 defendant Mostard William   587384 587384 Mostard, William, of Lyston, bailiff 4
4822675 2303169 2303169 defendant Mouns Thomas yeoman 587384 587384 Mouns, Thomas, of Lyston, yeoman 0
4822676 2303169 2303169 defendant Lenne Peter husbandman 587384 587384 Lenne, Peter, of Lyston, husbandman 1
4828808 2305046 2305046 defendant Basbyn Robert tailor 587384 587384 Basbyn, Robert, of Lyston, tailor 1
4828809 2305046 2305046 defendant Saunder Lawrence husbandman 587384 587384 Saunder, Lawrence, of Lyston, husbandman 2
4828812 2305047 2305047 defendant Baslyn Robert tailor 587384 587384 Baslyn, Robert, of Lyston, tailor 1
4828813 2305047 2305047 defendant Saunder Lawrence husbandman 587384 587384 Saunder, Lawrence, of Lyston, husbandman 2
4834125 2306682 2306682 defendant Rowe Richard husbandman 587384 587384 Rowe, Richard, of Lyston, husbandman 0
4834126 2306682 2306682 defendant Myleton William husbandman 587384 587384 Myleton, William, of Lyston, husbandman 1
4834127 2306682 2306682 defendant Monus John husbandman 587384 587384 Monus, John, of Lyston, husbandman 2
4941103 2339239 2339239 plaintiff Nobyll John   587384 587384 Nobyll, John, of Lyston 1
4966300 2346853 2346853 defendant Basselyng Robert tailor 587384 587384 Basselyng, Robert, of Lyston, tailor 1
4985210 2352508 2352508 defendant Manus John   587384 587384 Manus, John, of Lyston, bailiff 2
5017009 2361867 2361867 defendant Mouns John husbandman 587384 587384 Mouns, John, of Lyston, husbandman 4
5021529 2363197 2363197 defendant Sterre John   587384 587384 Sterre, John, of Lyston, bailiff 0
5021553 2363200 2363200 defendant Facy Peter husbandman 587384 587384 Facy, Peter, of Lyston, husbandman 3
5021554 2363200 2363200 defendant Plympton John husbandman 587384 587384 Plympton, John, of Lyston, husbandman 4
5021555 2363200 2363200 defendant Rowe Edward husbandman 587384 587384 Rowe, Edward, of Lyston, husbandman 5
5033380 2366643 2366643 defendant Davy Richard smith 587384 587384 Davy, Richard, of Lyston, smith 0
5033381 2366643 2366643 defendant Baslyng Robert husbandman 587384 587384 Baslyng, Robert, of Lyston, husbandman 1
5033382 2366643 2366643 defendant Boket Thomas husbandman 587384 587384 Boket, Thomas, of Lyston, husbandman 2
5043361 2369636 2369636 defendant Rowe Edward husbandman 587384 587384 Rowe, Edward, of Lyston, husbandman 4
5062475 2375343 2375343 defendant Ste- John yeoman 587384 587384 Ste-, John, of Lyston, yeoman 3
5088830 2383110 2383110 defendant Parkman John barber 587384 587384 Parkman, John, of Lyston, barber 0
5125176 2393841 2393841 defendant Hamond John husbandman 587384 587384 Hamond, John, of Lyston, husbandman 2
5125177 2393841 2393841 defendant Morelegh John   587384 587384 Morelegh, John, of Lyston, mason 3
5125178 2393841 2393841 defendant Draper Otto laborer 587384 587384 Draper, Otto, of Lyston, laborer 4
5162613 2404788 2404788 plaintiff Venour William   587384 587384 Venour, William, of Lyston 0
5162616 2404789 2404789 plaintiff Venour William esq 587384 587384 Venour, William, of Lyston, esq 0
5176591 2408839 2408839 plaintiff Venour William esq 587384 587384 Venour, William, of Lyston, esq 0
5176594 2408840 2408840 plaintiff Venour William esq 587384 587384 Venour, William, of Lyston, esq 0
5178419 2409397 2409397 defendant Hamond John husbandman 587384 587384 Hamond, John, of Lyston, husbandman 1

Next page

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);