names

71 rows where place_id = 594095

✎ 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
3614542 1872198 1872198 defendant Farneham Stephen cordwainer 594095 594095 Farneham, Stephen, of Odyham, cordwainer 0
3614543 1872198 1872198 defendant Bradshawe William cordwainer 594095 594095 Bradshawe, William, of Odyham, cordwainer 1
3614544 1872198 1872198 defendant Trassh Henry cordwainer 594095 594095 Trassh, Henry, of Odyham, cordwainer 2
3614545 1872198 1872198 defendant Farneham John fuller 594095 594095 Farneham, John, of Odyham, fuller 3
3632130 1904865 1904865 defendant Welles James yeoman 594095 594095 Welles, James, of Odyham, yeoman 0
3632230 1904897 1904897 defendant at Hole John, senior husbandman 594095 594095 at Hole, John, senior, of Odyham, husbandman 2
3632231 1904897 1904897 defendant at Hole John, junior husbandman 594095 594095 at Hole, John, junior, of Odyham, husbandman 3
3735854 1937452 1937452 defendant Alexander Richard weaver 594095 594095 Alexander, Richard, of Odyham, weaver 0
3741220 1939112 1939112 defendant Maltheus John husbandman 594095 594095 Maltheus, John, of Odyham, husbandman 0
3741223 1939112 1939112 defendant Whyttyng Henry husbandman 594095 594095 (Whyttyng, Henry, of Odyham, husbandman 3
3741469 1939200 1939200 defendant at Hole John yeoman 594095 594095 at Hole, John, of Odyham, yeoman 0
3753199 1942941 1942941 defendant Shoter Richard mercer 594095 594095 Shoter, Richard, of Odyham, mercer 0
3762561 1945936 1945936 defendant Alexander Richard weaver 594095 594095 Alexander, Richard, of Odyham, weaver 0
3767843 1947580 1947580 defendant Bowell Thomas   594095 594095 Bowell, Thomas, of Odyham, tile maker 1
3767846 1947581 1947581 defendant Bowell Thomas   594095 594095 Bowell, Thomas, of Odyham, tile maker 1
3784123 1952817 1952817 defendant Holwey Robert weaver 594095 594095 Holwey, Robert, of Odyham, weaver 1
3784124 1952817 1952817 defendant Wyllys Robert clothier 594095 594095 Wyllys, Robert, of Odyham, clothier 2
3910923 1993976 1993976 defendant Bycknoll Richard blacksmith 594095 594095 Bycknoll, Richard, of Odyham, blacksmith 0
3911800 1994271 1994271 defendant Gaston Edward butcher 594095 594095 Gaston, Edward, of Odyham, butcher 0
3924664 1998564 1998564 defendant Hollewey Robert weaver 594095 594095 Hollewey, Robert, of Odyham, weaver 0
3924707 1998579 1998579 defendant Bycknoll Richard blacksmith 594095 594095 Bycknoll, Richard, of Odyham, blacksmith 0
3965660 2012604 2012604 defendant Smythe alias Heath Thomas clothier 594095 594095 Smythe alias Heath, Thomas, of Odyham, clothier 0
4065326 2047884 2047884 plaintiff Hasell John shoemaker 594095 594095 Hasell, John, of Odyham, shoemaker 0
4065328 2047884 2047884 defendant Chappell William mercer 594095 594095 Chappell, William, of Odyham, mercer 0
4234546 2107628 2107628 defendant Kynge John yeoman 594095 594095 Kynge, John, of Odyham, or of Pinnocke Shere, Glos, yeoman 0
4295899 2128629 2128629 defendant Younge Nicholas gent 594095 594095 Younge, Nicholas, of Odyham, gent 0
4322377 2137898 2137898 defendant Southe Richard clothier 594095 594095 Southe, Richard, of Odyham, clothier 0
4322601 2137975 2137975 defendant Wigge Robert blacksmith 594095 594095 Wigge, Robert, of Odyham, blacksmith 0
4322602 2137975 2137975 defendant Lypscombe Robert innholder 594095 594095 Lypscombe, Robert, of Odyham, innholder 1
4364891 2152494 2152494 defendant Yonge Robert gent 594095 594095 Yonge, Robert, of Odyham, gent 0
4365802 2152803 2152803 defendant Maton Leonard yeoman 594095 594095 Maton, Leonard, of Odyham, or of Chesenham, Enforde, Wilts, yeoman 0
4365803 2152803 2152803 defendant Hyde Thomas yeoman 594095 594095 Hyde, Thomas, of Odyham, or of Puthale, Litel Bedwin, Wilts, yeoman 1
4391733 2161856 2161856 defendant Yonge John gent 594095 594095 Yonge, John, of Odyham, gent 1
4475267 2192946 2192946 defendant Vaus Richard   594095 594095 Vaus, Richard, of Odyham 0
4533378 2210706 2210706 plaintiff Richard John   594095 594095 Richard, John, of Odyham 0
4533380 2210707 2210707 plaintiff Richard John   594095 594095 Richard, John, of Odyham 0
4541710 2213300 2213300 defendant Knyght John   594095 594095 Knyght, John, of Odyham 2
4552049 2216592 2216592 defendant Richard John   594095 594095 Richard, John, of Odyham 0
4552051 2216593 2216593 defendant Richard John   594095 594095 Richard, John, of Odyham 0
4560414 2219197 2219197 defendant Richard John   594095 594095 Richard, John, of Odyham 0
4605988 2232988 2232988 defendant Skynnere John   594095 594095 Skynnere, John, of Odyham 0
4627295 2239481 2239481 defendant Knyght John   594095 594095 Knyght, John, of Odyham 0
4740763 2277817 2277817 defendant Westbrok William   594095 594095 Westbrok, William, of Odyham, franklin 0
4740764 2277817 2277817 defendant Graunt John   594095 594095 Graunt, John, of Odyham, franklin 1
4740765 2277817 2277817 defendant Umfray William   594095 594095 Umfray, William, of Odyham, franklin 2
4799336 2295967 2295967 defendant Drapere Thomas husbandman 594095 594095 Drapere, Thomas, of Odyham, husbandman 1
4813738 2300407 2300407 defendant Wodeley Robert   594095 594095 Wodeley, Robert, of Odyham, bailiff 0
4879504 2320516 2320516 defendant West John smith 594095 594095 West, John, of Odyham, smith 4
4925007 2334252 2334252 defendant Laurence John husbandman 594095 594095 Laurence, John, of Odyham, husbandman 2
4997232 2356025 2356025 defendant atte Halle Robert husbandman 594095 594095 atte Halle, Robert, of Odyham, husbandman 0
4997233 2356025 2356025 defendant Graunt John husbandman 594095 594095 Graunt, John, of Odyham, husbandman 1
4997234 2356025 2356025 defendant atte Halle William   594095 594095 atte Halle, William, of Odyham, servant 2
5086733 2382513 2382513 defendant Graunte alias atte Halle Agnes widow 594095 594095 Graunte alias atte Halle, Agnes, of Odyham, widow 0
5212532 2419413 2419413 defendant Berewe John gent 594095 594095 Berewe, John, of Odyham, gent 0
5249966 2430099 2430099 defendant Broun Nicholas yeoman 594095 594095 Broun, Nicholas, of Odyham, yeoman 3
5264768 2434739 2434739 plaintiff Smyth William   594095 594095 Smyth, William, of Odyham 0
5286303 2441001 2441001 defendant Kydwelly John yeoman 594095 594095 Kydwelly, John, of Odyham, yeoman 1
5329966 2454041 2454041 defendant Graunt Robert gent 594095 594095 Graunt, Robert, of Odyham, gent 0
5346668 2459111 2459111 defendant Lylewyght John husbandman 594095 594095 Lylewyght, John, of Odyham, husbandman 1
5360321 2463264 2463264 defendant Budde John miller 594095 594095 Budde, John, of Odyham, miller 1
5360323 2463264 2463264 defendant Staysot Richard tiler 594095 594095 Staysot, Richard, of Odyham, tiler 3
5401696 2475543 2475543 defendant Muller Thomas miller 594095 594095 Muller, Thomas, of Odyham, miller 4
5414621 2479308 2479308 defendant Miller Thomas miller 594095 594095 Miller, Thomas, of Odyham, miller 3
5414628 2479310 2479310 defendant Miller Thomas miller 594095 594095 Miller, Thomas, of Odyham, miller 3
5414633 2479311 2479311 defendant Miller Thomas miller 594095 594095 Miller, Thomas, of Odyham, miller 3
5502913 2505823 2505823 defendant Graunte John yeoman 594095 594095 Graunte, John, of Odyham, yeoman 2
5514465 2509371 2509371 defendant Vaus or Vans John   594095 594095 Vaus or Vans, John, of Odyham, gent, "philiciar" of the bench 0
5547665 2519331 2519331 defendant Creswell Thomas clothier 594095 594095 Creswell, Thomas, of Odyham, clothier 0
5576973 2527843 2527843 defendant Crossewell Thomas clothier 594095 594095 Crossewell, Thomas, of Odyham, clothier 0
5597074 2533993 2533993 defendant Vaus or Vans Richard gent 594095 594095 Vaus or Vans, Richard, of Odyham, gent 0
5613649 2548044 2548044 defendant Hernewe Robert, junior   594095 594095 Hernewe, Robert, junior, of Odyham 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);