names

70 rows where place_id = 621099

✎ 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
3739552 1938581 1938581 plaintiff Peryn Marion (legal representative) 621099 621099 Peryn, Marion, of Hevyngham, widow, executor of 0
3739553 1938581 1938581 plaintiff Reyner Thomas   621099 621099 Reyner, Thomas, of Hevyngham 1
3739554 1938581 1938581 defendant Hollyn alias Tayllour John husbandman 621099 621099 Hollyn alias Tayllour, John, of Hevyngham, husbandman 0
3776801 1950486 1950486 defendant Dogett Edmund gent 621099 621099 Dogett, Edmund, of Hevyngham, gent 0
3852696 1974451 1974451 defendant Pulte Thomas husbandman 621099 621099 Pulte, Thomas, of Hevyngham, husbandman 2
3905698 1992182 1992182 defendant Bawden John, junior draper 621099 621099 Bawden, John, junior, of Hevyngham, draper 0
3908337 1993086 1993086 defendant Hollynges alias Taylor John husbandman 621099 621099 Hollynges alias Taylor, John, of Hevyngham, husbandman 3
3908342 1993087 1993087 defendant Hollynges alias Taylor John husbandman 621099 621099 Hollynges alias Taylor, John, of Hevyngham, husbandman 3
4017336 2030907 2030907 plaintiff Thetford Andrew gent 621099 621099 Thetford, Andrew, of Hevyngham, gent 0
4017338 2030908 2030908 plaintiff Thetford Andrew gent 621099 621099 Thetford, Andrew, of Hevyngham, gent 0
4017340 2030909 2030909 plaintiff Thetford Andrew gent 621099 621099 Thetford, Andrew, of Hevyngham, gent 0
4017341 2030909 2030909 defendant Reymey Richard husbandman 621099 621099 Reymey, Richard, of Hevyngham, husbandman 0
4066398 2048276 2048276 defendant Freman John husbandman 621099 621099 Freman, John, of Hevyngham, husbandman 0
4076655 2051942 2051942 defendant Yong William husbandman 621099 621099 Yong, William, of Hevyngham, husbandman 18
4098725 2059874 2059874 defendant Well Francis husbandman 621099 621099 Well, Francis, of Hevyngham, husbandman 1
4288656 2125998 2125998 defendant Smyth Edmund husbandman 621099 621099 Smyth, Edmund, of Hevyngham, smith, husbandman 1
4288657 2125998 2125998 defendant Davy John tailor 621099 621099 Davy, John, of Hevyngham, tailor 2
4347982 2146546 2146546 defendant Davy John husbandman 621099 621099 Davy, John, of Hevyngham, husbandman 0
4369294 2154082 2154082 defendant Gyllyett or Gyllett Philip yeoman 621099 621099 Gyllyett or Gyllett, Philip, of Hevyngham, yeoman 0
4383853 2159304 2159304 defendant Rytches Richard thatcher 621099 621099 Rytches, Richard, of Hevyngham, thatcher 0
4450771 2185205 2185205 defendant Tubbe John   621099 621099 Tubbe, John, of Hevyngham 0
4450772 2185205 2185205 defendant Nally Henry   621099 621099 Nally, Henry, of Hevyngham 1
4450775 2185205 2185205 defendant Bory John de chaplain 621099 621099 Bory, John de, of Hevyngham, chaplain 4
4471401 2191720 2191720 plaintiff Cat William   621099 621099 Cat, William, of Hevyngham 0
4471403 2191721 2191721 plaintiff Cat William   621099 621099 Cat, William, of Hevyngham 0
4486622 2196528 2196528 defendant Dorell John   621099 621099 Dorell, John, of Hevyngham 0
4513733 2204724 2204724 defendant Ruddok William   621099 621099 Ruddok, William, of Hevyngham 3
4546473 2214829 2214829 defendant Ruddok William   621099 621099 Ruddok, William, of Hevyngham 1
4554944 2217473 2217473 defendant Pycard Agnes   621099 621099 Pycard, Agnes, of Hevyngham 5
4560701 2219296 2219296 defendant Houmfrey Robert   621099 621099 Houmfrey, Robert, of Hevyngham 0
4582743 2226041 2226041 defendant Burell John   621099 621099 Burell, John, of Hevyngham 0
4631326 2240688 2240688 defendant Brandiston Stephen   621099 621099 Brandiston, Stephen, of Hevyngham 1
4687816 2261759 2261759 defendant Tailloru Richard yeoman 621099 621099 Tailloru, Richard, of Hevyngham, yeoman 3
4696537 2264392 2264392 defendant Fuller Henry husbandman 621099 621099 Fuller, Henry, of Hevyngham, husbandman 4
4706838 2267517 2267517 defendant Baxtere alias Garneys or Garveys Bartholomew husbandman 621099 621099 Baxtere alias Garneys or Garveys, Bartholomew, of Hevyngham, husbandman 0
4707286 2267656 2267656 defendant Taliour Richard yeoman 621099 621099 Taliour, Richard, of Hevyngham, yeoman 1
4749283 2280270 2280270 defendant Taillour Richard husbandman 621099 621099 Taillour, Richard, of Hevyngham, husbandman 1
4837191 2307585 2307585 defendant Hendrys Adam yeoman 621099 621099 Hendrys, Adam, of Hevyngham, yeoman 0
4951412 2342404 2342404 defendant Martyn William husbandman 621099 621099 Martyn, William, of Hevyngham, husbandman 0
5046247 2370509 2370509 plaintiff Martyn William   621099 621099 Martyn, William, of Hevyngham 0
5143609 2399266 2399266 defendant Goodwyn Henry husbandman 621099 621099 Goodwyn, Henry, of Hevyngham, husbandman 1
5143610 2399266 2399266 defendant Porter Alexander husbandman 621099 621099 Porter, Alexander, of Hevyngham, husbandman 2
5147579 2400431 2400431 defendant Goodewyn Henry husbandman 621099 621099 Goodewyn, Henry, of Hevyngham, husbandman 0
5147580 2400431 2400431 defendant Spendelowe Henry husbandman 621099 621099 Spendelowe, Henry, of Hevyngham, husbandman 1
5147581 2400431 2400431 defendant Porter Alexander husbandman 621099 621099 Porter, Alexander, of Hevyngham, husbandman 2
5158537 2403616 2403616 defendant Goodwyns Henry husbandman 621099 621099 Goodwyns, Henry, of Hevyngham, husbandman 3
5162628 2404791 2404791 defendant Martyns Henry laborer 621099 621099 Martyns, Henry, of Hevyngham, laborer 2
5162629 2404791 2404791 defendant Godwyns Henry husbandman 621099 621099 Godwyns, Henry, of Hevyngham, husbandman 3
5164768 2405428 2405428 defendant Goodwyn Henry husbandman 621099 621099 Goodwyn, Henry, of Hevyngham, husbandman 1
5164769 2405428 2405428 defendant Porter Alexander husbandman 621099 621099 Porter, Alexander, of Hevyngham, husbandman 2
5178227 2409336 2409336 defendant Goodwyn Henry husbandman 621099 621099 Goodwyn, Henry, of Hevyngham, husbandman 1
5178228 2409336 2409336 defendant Porter Alexander husbandman 621099 621099 Porter, Alexander, of Hevyngham, husbandman 2
5182343 2410592 2410592 defendant Spendlove Henry yeoman 621099 621099 Spendlove, Henry, of Hevyngham, yeoman 0
5182344 2410592 2410592 defendant Caudeler Henry clerk 621099 621099 Caudeler, Henry, of Hevyngham, clerk 1
5196750 2414797 2414797 defendant Rolf John laborer 621099 621099 Rolf, John, of Hevyngham, laborer 3
5203347 2416742 2416742 defendant Spendelove Henry yeoman 621099 621099 Spendelove, Henry, of Hevyngham, yeoman 0
5203348 2416742 2416742 defendant Caudeler or Candeler Henry clerk 621099 621099 Caudeler or Candeler, Henry, of Hevyngham, clerk 1
5208756 2418282 2418282 defendant Godwyns Henry husbandman 621099 621099 together with Godwyns, Henry, of Hevyngham, husbandman 4
5212008 2419251 2419251 defendant Goodewyn Henry husbandman 621099 621099 Goodewyn, Henry, of Hevyngham, husbandman 0
5212009 2419251 2419251 defendant Spedelove Henry husbandman 621099 621099 Spedelove, Henry, of Hevyngham, husbandman 1
5212010 2419251 2419251 defendant Potter Alexander husbandman 621099 621099 Potter, Alexander, of Hevyngham, husbandman 2
5377528 2468558 2468558 defendant Cotes Thomas esq 621099 621099 Cotes, Thomas, of Hevyngham, esq 0
5380211 2469388 2469388 defendant Crotche William   621099 621099 Crotche, William, of Hevyngham 2
5384781 2470725 2470725 defendant Okys Alexander husbandman 621099 621099 Okys, Alexander, of Hevyngham, husbandman 26
5391935 2472770 2472770 defendant Potter William husbandman 621099 621099 Potter, William, of Hevyngham, husbandman 3
5425572 2482624 2482624 defendant Wyrmegey Stephen yeoman 621099 621099 Wyrmegey, Stephen, of Hevyngham, yeoman 0
5456679 2491921 2491921 defendant Martyns John husbandman 621099 621099 Martyns, John, of Hevyngham, husbandman 0
5456680 2491921 2491921 defendant Flood John yeoman 621099 621099 Flood, John, of Hevyngham, yeoman 1
5469779 2495888 2495888 defendant Thetford John   621099 621099 Thetford, John, of Hevyngham 0
5636263 2555300 2555300 defendant Hert William clerk 621099 621099 Hert, William, of Hevyngham, clerk 3

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