names

77 rows where place_id = 590059

✎ 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
3599745 1867564 1867564 defendant Parker Andrew tailor 590059 590059 Parker, Andrew, of Byford, tailor 0
3667937 1915912 1915912 defendant Tompkyns John husbandman 590059 590059 Tompkyns, John, of Byford, husbandman 0
3690222 1923101 1923101 defendant Tompkyns John husbandman 590059 590059 Tompkyns, John, of Byford, husbandman 0
3726565 1934566 1934566 defendant Tomkyns John yeoman 590059 590059 Tomkyns, John, of Byford, yeoman 0
3826155 1966022 1966022 defendant ap Ithell Elizabeth widow 590059 590059 ap Ithell, Elizabeth, of Byford, widow 0
3893268 1987980 1987980 defendant Mores Philip husbandman 590059 590059 Mores, Philip, of Byford, husbandman 0
3893269 1987980 1987980 defendant Mores Lawrence laborer 590059 590059 Mores, Lawrence, of Byford, laborer 1
3893270 1987980 1987980 defendant Smyth John laborer 590059 590059 Smyth, John, of Byford, laborer 2
3893274 1987980 1987980 defendant ap Res Lewis laborer 590059 590059 ap Res, Lewis, of Byford, laborer 6
3907581 1992826 1992826 defendant Mores Philip husbandman 590059 590059 Mores, Philip, of Byford, husbandman 0
3907582 1992826 1992826 defendant Mores Lawrence laborer 590059 590059 Mores, Lawrence, of Byford, laborer 1
3907583 1992826 1992826 defendant Smyth John laborer 590059 590059 Smyth, John, of Byford, laborer 2
3907584 1992826 1992826 defendant Ap Ithell David laborer 590059 590059 Ap Ithell, David, of Byford, laborer 3
3907587 1992826 1992826 defendant ap Rees Lewis laborer 590059 590059 ap Rees, Lewis, of Byford, laborer 6
3968978 2013766 2013766 defendant Phelpott John yeoman 590059 590059 Phelpott, John, of Byford, yeoman 0
4023414 2033085 2033085 defendant Parsons James husbandman 590059 590059 Parsons, James, of Byford, husbandman 0
4023417 2033085 2033085 defendant Phelpott John husbandman 590059 590059 Phelpott, John, of Byford, husbandman 3
4192329 2092875 2092875 defendant Apowell Hugh yeoman 590059 590059 Apowell, Hugh, of Byford, yeoman 0
4244445 2111122 2111122 defendant Phileps Henry yeoman 590059 590059 Phileps, Henry, of Byford, yeoman 0
4411903 2168574 2168574 defendant Patfold James gent 590059 590059 Patfold, James, of Byford, gent 1
4411915 2168578 2168578 defendant Patsold James gent 590059 590059 Patsold, James, of Byford, gent 1
4515844 2205376 2205376 defendant Byford Lewis   590059 590059 Byford, Lewis, of Byford, parson 0
4522183 2207283 2207283 plaintiff Gomond John   590059 590059 Gomond, John, of Byford 0
4522184 2207283 2207283 defendant Pyers Roger (legal representative) 590059 590059 Pyers, Roger, of Byford, executors of 0
4522186 2207283 2207283 defendant (illegible) Thomas   590059 590059 _, Thomas, of Byford 2
4575564 2223866 2223866 defendant Carter Thomas   590059 590059 Carter, Thomas, of Byford 2
4616855 2236275 2236275 defendant Borne John   590059 590059 Borne, John, of Byford 0
4616858 2236276 2236276 defendant Bourne John   590059 590059 Bourne, John, of Byford 0
4616859 2236276 2236276 defendant Tailour John   590059 590059 Tailour, John, of Byford 1
4620551 2237412 2237412 defendant Hardolphe Henry smith 590059 590059 Hardolphe, Henry, of Byford, smith 0
4660717 2249174 2249174 defendant Bourne John yeoman 590059 590059 Bourne, John, of Byford, yeoman 0
4677921 2258712 2258712 defendant Gomond John widow 590059 590059 Gomond, John, of Byford, widow 0
4704667 2266840 2266840 defendant Hardolf Henry smith 590059 590059 Hardolf, Henry, of Byford, smith 0
4787065 2292017 2292017 defendant Partriche John clerk 590059 590059 Partriche, John, of Byford, clerk 3
4805148 2297810 2297810 defendant Wales Thomas milner 590059 590059 Wales, Thomas, of Byford, milner 5
4829798 2305365 2305365 defendant Gomond Edmund gent 590059 590059 Gomond, Edmund, of Byford, gent 1
4862272 2315210 2315210 defendant Hood John husbandman 590059 590059 Hood, John, of Byford, husbandman 1
4883852 2321857 2321857 defendant Walker Philip yeoman 590059 590059 Walker, Philip, of Byford, yeoman 1
4899849 2326590 2326590 defendant Gomond Edmund gent 590059 590059 Gomond, Edmund, of Byford, gent 0
4941700 2339426 2339426 defendant Gomond Edmund husbandman 590059 590059 Gomond, Edmund, of Byford, husbandman 0
5109872 2389315 2389315 defendant Bourne Thomas husbandman 590059 590059 Bourne, Thomas, of Byford, husbandman 0
5109875 2389315 2389315 defendant Herymon John clerk 590059 590059 Herymon, John, of Byford, clerk 3
5126524 2394233 2394233 defendant Warde Henry husbandman 590059 590059 Warde, Henry, of Byford, husbandman 2
5139168 2397948 2397948 defendant Gummond John gent 590059 590059 Gummond, John, of Byford, gent 3
5165758 2405729 2405729 defendant Warde Henry husbandman 590059 590059 Warde, Henry, of Byford, husbandman 0
5180208 2409951 2409951 defendant Warde Henry husbandman 590059 590059 Warde, Henry, of Byford, husbandman 0
5200711 2415962 2415962 defendant Gummond John gent 590059 590059 Gummond, John, of Byford, gent 0
5211593 2419127 2419127 defendant Gummond John gent 590059 590059 Gummond, John, of Byford, gent 0
5213080 2419561 2419561 defendant Gomonde Edmund gent 590059 590059 Gomonde, Edmund, of Byford, gent 0
5255636 2431881 2431881 defendant Gomonde James gent 590059 590059 Gomonde, James, of Byford, gent 0
5255638 2431881 2431881 defendant Borne Thomas yeoman 590059 590059 Borne, Thomas, of Byford, yeoman 2
5268089 2435783 2435783 defendant Adams Roger yeoman 590059 590059 Adams, Roger, of Byford, yeoman 0
5268093 2435785 2435785 defendant Gomond James gent 590059 590059 Gomond, James, of Byford, gent 0
5277683 2438556 2438556 defendant Gomond James gent 590059 590059 Gomond, James, of Byford, gent 0
5277685 2438557 2438557 defendant Adams Roger yeoman 590059 590059 Adams, Roger, of Byford, yeoman 0
5278090 2438683 2438683 defendant Robertys William husbandman 590059 590059 Robertys, William, of Byford, husbandman 3
5284990 2440632 2440632 defendant Warde Henry yeoman 590059 590059 Warde, Henry, of Byford, yeoman 2
5284991 2440632 2440632 defendant Trus Thomas laborer 590059 590059 Trus, Thomas, of Byford, laborer 3
5284992 2440632 2440632 defendant Hopkyns William laborer 590059 590059 Hopkyns, William, of Byford, laborer 4
5312297 2448715 2448715 defendant Gomond James gent 590059 590059 Gomond, James, of Byford, gent 0
5328076 2453466 2453466 defendant Burn Thomas husbandman 590059 590059 Burn, Thomas, of Byford, husbandman 0
5366918 2465304 2465304 defendant Spyre Stephen husbandman 590059 590059 Spyre, Stephen, of Byford, husbandman 0
5370372 2466320 2466320 defendant Wilson John laborer 590059 590059 Wilson, John, of Byford, laborer 2
5381290 2469703 2469703 defendant Hopkyns William husbandman 590059 590059 Hopkyns, William, of Byford, husbandman 0
5381292 2469703 2469703 defendant Oldcastell James husbandman 590059 590059 Oldcastell, James, of Byford, husbandman 2
5433312 2484930 2484930 defendant Gormande Edmund gent 590059 590059 Gormande, Edmund, of Byford, gent 1
5440800 2487159 2487159 defendant Gomond John gent 590059 590059 Gomond, John, of Byford, gent 0
5449106 2489627 2489627 defendant Gomonde John gent 590059 590059 Gomonde, John, of Byford, gent 1
5534248 2515244 2515244 defendant Gomond William gent 590059 590059 Gomond, William, of Byford, gent 0
5534249 2515244 2515244 defendant Dalton John laborer 590059 590059 Dalton, John, of Byford, laborer 1
5566636 2524836 2524836 defendant Weythe Hugh laborer 590059 590059 Weythe, Hugh, of Byford, laborer 2
5587388 2531081 2531081 defendant Gormyn Thomas husbandman 590059 590059 Gormyn, Thomas, of Byford, husbandman 0
5587389 2531081 2531081 defendant Gomond William gent 590059 590059 Gomond, William, of Byford, gent 1
5587390 2531081 2531081 defendant Wynnys Richard husbandman 590059 590059 Wynnys, Richard, of Byford, husbandman 2
5587391 2531081 2531081 defendant Bythell John husbandman 590059 590059 Bythell, John, of Byford, husbandman 3
5629846 2553337 2553337 defendant Gomond Edmund husbandman 590059 590059 Gomond, Edmund, of Byford, husbandman 0
5629847 2553337 2553337 defendant Gomond Roger boatman 590059 590059 Gomond, Roger, of Byford, boatman 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);