names

90 rows where place_id = 593618

✎ 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
3612598 1871577 1871577 defendant Seyntmaure William esq 593618 593618 Seyntmaure, William, of North Molton, esq 0
3622573 1874595 1874595 defendant May Robert husbandman 593618 593618 May, Robert, of North Molton, husbandman 0
3642203 1908009 1908009 defendant Burges Philip husbandman 593618 593618 Burges, Philip, of North Molton, husbandman 0
3642204 1908009 1908009 defendant Hetherherd John husbandman 593618 593618 Hetherherd, John, of North Molton, husbandman 1
3642205 1908009 1908009 defendant Moreman John husbandman 593618 593618 Moreman, John, of North Molton, husbandman 2
3643304 1908331 1908331 defendant Hethurd Philip chaplain 593618 593618 Hethurd, Philip, of North Molton, chaplain 0
3644176 1908611 1908611 defendant Grey William yeoman 593618 593618 Grey, William, of North Molton, yeoman 2
3644178 1908611 1908611 defendant Grey Thomas yeoman 593618 593618 Grey, Thomas, of North Molton, yeoman 4
3644213 1908622 1908622 defendant Grey William yeoman 593618 593618 Grey, William, of North Molton, yeoman 0
3644215 1908622 1908622 defendant Grey Thomas yeoman 593618 593618 Grey, Thomas, of North Molton, yeoman 2
3659921 1913358 1913358 defendant Mayowe Robert husnbadman 593618 593618 Mayowe, Robert, of North Molton, husnbadman 7
3659922 1913358 1913358 defendant Pawe Richard husbandman 593618 593618 Pawe, Richard, of North Molton, husbandman 8
3675620 1918411 1918411 plaintiff Hetherd John (legal representative) 593618 593618 Hetherd, John, of North Molton, tucker, executrix of 0
3711512 1929910 1929910 defendant Maye Robert husbandman 593618 593618 Maye, Robert, of North Molton, husbandman 0
3742123 1939404 1939404 defendant Belamy John husbandman 593618 593618 Belamy, John, of North Molton, husbandman 1
3742124 1939404 1939404 defendant Belamy Thomas husbandman 593618 593618 Belamy, Thomas, of North Molton, husbandman 2
3754426 1943341 1943341 defendant Thorne Richard husbandman 593618 593618 Thorne, Richard, of North Molton, husbandman 0
3754429 1943342 1943342 defendant Belamy John husbandman 593618 593618 Belamy, John, of North Molton, husbandman 1
3754430 1943342 1943342 defendant Belamy Thomas husbandman 593618 593618 Belamy, Thomas, of North Molton, husbandman 2
3771700 1948849 1948849 defendant Thorne Richard husbandman 593618 593618 Thorne, Richard, of North Molton, husbandman 0
3771703 1948850 1948850 defendant Belamy John husbandman 593618 593618 Belamy, John, of North Molton, husbandman 1
3771704 1948850 1948850 defendant Belamy Thomas husbandman 593618 593618 Belamy, Thomas, of North Molton, husbandman 2
3789403 1954509 1954509 defendant Thorne Richard husbandman 593618 593618 Thorne, Richard, of North Molton, husbandman 0
3805585 1959688 1959688 defendant Thorne Richard husbandman 593618 593618 Thorne, Richard, of North Molton, husbandman 0
3823924 1965354 1965354 plaintiff Vycary Robert (legal representative) 593618 593618 Vycary, Robert, of North Molton, executors of 0
3824837 1965646 1965646 defendant Top Robert husbandman 593618 593618 Top, Robert, of North Molton, husbandman 0
3854033 1974897 1974897 plaintiff Stycke Henry merchant 593618 593618 Stycke, Henry, of North Molton, merchant 0
3895793 1988799 1988799 defendant Uprychard Lewis weaver 593618 593618 Uprychard, Lewis, of North Molton, weaver 0
3956892 2009481 2009481 plaintiff Parker John gent 593618 593618 Parker, John, of North Molton, gent 0
3963257 2011752 2011752 defendant Bennett Charles husbandman 593618 593618 Bennett, Charles, of North Molton, husbandman 0
3965008 2012366 2012366 defendant Moreman Thomas laborer 593618 593618 Moreman, Thomas, of North Molton, laborer 1
3965009 2012366 2012366 defendant Moll John husbandman 593618 593618 Moll, John, of North Molton, husbandman 2
3965010 2012366 2012366 defendant Blake Michael husbandman 593618 593618 Blake, Michael, of North Molton, husbandman 3
3965011 2012366 2012366 defendant Thorne Walter husbandman 593618 593618 Thorne, Walter, of North Molton, husbandman 4
3965012 2012366 2012366 defendant Kyngden John laborer 593618 593618 Kyngden, John, of North Molton, laborer 5
3968675 2013683 2013683 defendant Passemore Nicholas   593618 593618 Passemore, Nicholas, of North Molton, groom 0
3968676 2013683 2013683 defendant Tappe John, senior husbandman 593618 593618 Tappe, John, senior, of North Molton, husbandman 1
3968677 2013683 2013683 defendant Dee John, senior   593618 593618 Dee, John, senior, of North Molton, groom 2
3973196 2015196 2015196 plaintiff Grede Gregory clothier 593618 593618 Grede, Gregory, of North Molton, or of Colompton, clothier 0
3974614 2015685 2015685 defendant Lawdey Andrew husbandman 593618 593618 Lawdey, Andrew, of North Molton, husbandman 0
3979987 2017605 2017605 plaintiff Parker Thomas (legal representative) 593618 593618 Parker, Thomas, of North Molton, executor of 0
4147322 2077201 2077201 defendant Hawkeridge Giles yeoman 593618 593618 Hawkeridge, Giles, of North Molton, yeoman 1
4195067 2093838 2093838 defendant Bennett Charles yeoman 593618 593618 Bennett, Charles, of North Molton, yeoman 1
4286822 2125342 2125342 defendant Courteney Thomas gent 593618 593618 Courteney, Thomas, of North Molton, gent 0
4288329 2125874 2125874 defendant Hocaridge Giles husbandman 593618 593618 Hocaridge, Giles, of North Molton, husbandman 0
4312915 2134642 2134642 defendant Bennett Charles yeoman 593618 593618 Bennett, Charles, of North Molton, yeoman 3
4326047 2139083 2139083 defendant Courtney Thomas gent 593618 593618 Courtney, Thomas, of North Molton, gent 0
4327737 2139602 2139602 defendant Courteney Thomas gent 593618 593618 Courteney, Thomas, of North Molton, gent 0
4384436 2159485 2159485 defendant Bennett Charles husbandman 593618 593618 Bennett, Charles, of North Molton, husbandman 0
4389114 2160988 2160988 defendant Toppe Thomas husbandman 593618 593618 Toppe, Thomas, of North Molton, husbandman 0
4574344 2223507 2223507 defendant Smyth David   593618 593618 Smyth, David, of North Molton 0
4574345 2223507 2223507 defendant Edward John   593618 593618 Edward, John, of North Molton 1
4574346 2223507 2223507 defendant Harper Clarice   593618 593618 Harper, Clarice, of North Molton 2
4574347 2223507 2223507 defendant Fouke Robert   593618 593618 Fouke, Robert, of North Molton 3
4574348 2223507 2223507 defendant Squyer Robert   593618 593618 Squyer, Robert, of North Molton 4
4587055 2227360 2227360 plaintiff Horn John   593618 593618 Horn, John, of North Molton 0
4591619 2228736 2228736 defendant Squyer Robert   593618 593618 Squyer, Robert, of North Molton 0
4591620 2228736 2228736 defendant Squyer Thomas   593618 593618 Squyer, Thomas, of North Molton 1
4629422 2240130 2240130 plaintiff Somere Walter   593618 593618 Somere, Walter, of North Molton 0
4767508 2285815 2285815 defendant Suthray John husbandman 593618 593618 Suthray, John, of North Molton, husbandman 2
4779112 2289445 2289445 defendant Berehed David   593618 593618 Berehed, David, of North Molton, bailiff 1
4792485 2293737 2293737 defendant Dyer Thomas husbandman 593618 593618 Dyer, Thomas, of North Molton, husbandman 0
4859574 2314365 2314365 defendant Sanger John butcher 593618 593618 Sanger, John, of North Molton, butcher 1
4879779 2320594 2320594 defendant Grey Thomas husbandman 593618 593618 Grey, Thomas, of North Molton, husbandman 1
4935821 2337594 2337594 defendant Smyth William smith 593618 593618 Smyth, William, of North Molton, smith 1
4935822 2337594 2337594 defendant Bernard William clerk 593618 593618 Bernard, William, of North Molton, clerk 2
4951501 2342429 2342429 defendant Baron John husbandman 593618 593618 Baron, John, of North Molton, husbandman 2
4951506 2342430 2342430 defendant Baron John husbandman 593618 593618 Baron, John, of North Molton, husbandman 2
4957962 2344350 2344350 defendant Broun John smith 593618 593618 (Broun, John, of North Molton, smith 1
4963146 2345884 2345884 defendant Smyth William smith 593618 593618 Smyth, William, of North Molton, smith 1
4963147 2345884 2345884 defendant Bernard William clerk 593618 593618 Bernard, William, of North Molton, clerk 2
5032911 2366513 2366513 defendant Bernard William yeoman 593618 593618 Bernard, William, of North Molton, yeoman 2
5033343 2366632 2366632 defendant Beare Robert husbandman 593618 593618 Beare, Robert, of North Molton, husbandman 1
5033344 2366632 2366632 defendant Beare Thomas husbandman 593618 593618 Beare, Thomas, of North Molton, husbandman 2
5033345 2366632 2366632 defendant Southeray Thomas husbandman 593618 593618 Southeray, Thomas, of North Molton, husbandman 3
5043898 2369804 2369804 defendant Hamond Robert smith 593618 593618 Hamond, Robert, of North Molton, smith 1
5131402 2395673 2395673 defendant Tronte or Troute John husbandman 593618 593618 Tronte or Troute, John, of North Molton, husbandman 0
5236689 2426315 2426315 defendant de St Maur Thomas   593618 593618 de St Maur, Thomas, of North Molton, knight 0
5236692 2426316 2426316 defendant Mollond Thomas yeoman 593618 593618 Mollond, Thomas, of North Molton, yeoman 0
5312815 2448863 2448863 plaintiff Beare John husbandman 593618 593618 Beare, John, of North Molton, husbandman 0
5350835 2460371 2460371 defendant Landy William husbandman 593618 593618 Landy, William, of North Molton, husbandman 0
5467028 2495087 2495087 defendant Godman Richard husbandman 593618 593618 Godman, Richard, of North Molton, husbandman 0
5478300 2498538 2498538 defendant Godeman Richard husbandman 593618 593618 Godeman, Richard, of North Molton, husbandman 0
5480479 2499133 2499133 defendant Mey Robert tucker 593618 593618 Mey, Robert, of North Molton, tucker 6
5490045 2501906 2501906 plaintiff Beare John   593618 593618 Beare, John, of North Molton 0
5530972 2514204 2514204 plaintiff Sayntmaure William, junior esq 593618 593618 Sayntmaure, William, junior, of North Molton, esq 0
5531091 2514242 2514242 defendant SeyntMaure William   593618 593618 SeyntMaure, William, of North Molton 0
5544898 2518511 2518511 defendant Seyntmaur William, senior   593618 593618 Seyntmaur, William, senior, of North Molton 0
5569301 2525581 2525581 defendant Vycary Robert husbandman 593618 593618 Vycary, Robert, of North Molton, husbandman 0
5598417 2534389 2534389 defendant Thorne Roger husbandman 593618 593618 Thorne, Roger, of North Molton, husbandman 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);