names

82 rows where place_id = 586264

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588308 1863996 1863996 defendant Northam Henry husbandman 586264 586264 Northam, Henry, of North Lewe, husbandman 0
3599549 1867496 1867496 defendant Northam Robert yeoman 586264 586264 Northam, Robert, of North Lewe, yeoman 0
3609232 1870550 1870550 defendant Lake alias Gregory Henry husbandman 586264 586264 Lake alias Gregory, Henry, of North Lewe, husbandman 0
3651425 1910810 1910810 defendant Hacche John gent 586264 586264 Hacche, John, of North Lewe, gent 0
3655346 1911929 1911929 defendant Hill John husbandman 586264 586264 Hill, John, of North Lewe, husbandman 3
3655347 1911929 1911929 defendant Nicoll Gregory husbandman 586264 586264 Nicoll, Gregory, of North Lewe, husbandman 4
3656186 1912182 1912182 defendant Kelley William gent 586264 586264 Kelley, William, of North Lewe, gent 0
3657762 1912681 1912681 defendant Kelley William gent 586264 586264 Kelley, William, of North Lewe, gent 0
3657769 1912682 1912682 defendant Kelley William gent 586264 586264 Kelley, William, of North Lewe, gent 1
3674312 1918010 1918010 defendant Wyke Thomas husbandman 586264 586264 Wyke, Thomas, of North Lewe, husbandman 0
3682046 1920494 1920494 defendant Arkysworthy John husbandman 586264 586264 Arkysworthy, John, of North Lewe, husbandman 0
3682047 1920494 1920494 defendant Glanfeld William husbandman 586264 586264 Glanfeld, William, of North Lewe, husbandman 1
3682048 1920494 1920494 defendant Glanfeld John   586264 586264 Glanfeld, John, of North Lewe, groom 2
3682049 1920494 1920494 defendant Northam Vincent husbandman 586264 586264 Northam, Vincent, of North Lewe, husbandman 3
3682050 1920494 1920494 defendant Northam Gilbert husbandman 586264 586264 Northam, Gilbert, of North Lewe, husbandman 4
3690356 1923146 1923146 defendant Tokyll Thomas weaver 586264 586264 Tokyll, Thomas, of North Lewe, weaver 1
3693826 1924268 1924268 defendant Northam John, senior husbandman 586264 586264 Northam, John, senior, of North Lewe, husbandman 0
3700887 1926523 1926523 defendant Webbe Robert tanner 586264 586264 Webbe, Robert, of North Lewe, tanner 1
3700888 1926523 1926523 defendant Northam Vincent thatcher 586264 586264 Northam, Vincent, of North Lewe, thatcher 2
3712947 1930371 1930371 defendant Wyke Sybil widow 586264 586264 Wyke, Sybil, of North Lewe, widow 0
3718330 1932017 1932017 defendant Arkesworthy John husbandman 586264 586264 Arkesworthy, John, of North Lewe, husbandman 0
3720151 1932579 1932579 defendant Northam Henry husbandman 586264 586264 Northam, Henry, of North Lewe, husbandman 0
3720152 1932579 1932579 defendant Jackeman Robert tanner 586264 586264 Jackeman, Robert, of North Lewe, tanner 1
3729133 1935361 1935361 defendant Northam Vincent husbandman 586264 586264 Northam, Vincent, of North Lewe, husbandman 0
3729134 1935361 1935361 defendant Weke Thomas husbandman 586264 586264 Weke, Thomas, of North Lewe, husbandman 1
3734542 1937049 1937049 defendant Newcombe William husbandman 586264 586264 Newcombe, William, of North Lewe, husbandman 2
3737746 1938027 1938027 defendant Weke Thomas yeoman 586264 586264 Weke, Thomas, of North Lewe, yeoman 0
3762447 1945899 1945899 defendant Glanfyld William husbandman 586264 586264 Glanfyld, William, of North Lewe, husbandman 0
3762448 1945899 1945899 defendant Carre John husbandman 586264 586264 Carre, John, of North Lewe, husbandman 1
3762450 1945899 1945899 defendant Northam John husbandman 586264 586264 Northam, John, of North Lewe, husbandman 3
3762451 1945899 1945899 defendant Medlond Richard butcher 586264 586264 Medlond, Richard, of North Lewe, butcher 4
3762454 1945900 1945900 defendant Northam Vincent husbandman 586264 586264 Northam, Vincent, of North Lewe, husbandman 0
3805937 1959796 1959796 defendant Webber Robert tanner 586264 586264 Webber, Robert, of North Lewe, tanner 1
3805938 1959796 1959796 defendant Huchyn John husbandman 586264 586264 Huchyn, John, of North Lewe, husbandman 2
3805939 1959796 1959796 defendant Lake John husbandman 586264 586264 Lake, John, of North Lewe, husbandman 3
3805940 1959796 1959796 defendant Newcombe William husbandman 586264 586264 Newcombe, William, of North Lewe, husbandman 4
3809995 1961013 1961013 defendant Kellygh William esq 586264 586264 Kellygh, William, of North Lewe, esq 0
3809997 1961014 1961014 defendant Ford John husbandman 586264 586264 Ford, John, of North Lewe, husbandman 0
3815496 1962761 1962761 defendant Cary John esq 586264 586264 Cary, John, of North Lewe, gent, son of Cary, Robert, esq 0
3843129 1971375 1971375 defendant Style John husbandman 586264 586264 Style, John, of North Lewe, husbandman 0
3843130 1971375 1971375 defendant Parys John husbandman 586264 586264 Parys, John, of North Lewe, husbandman 1
3851030 1973914 1973914 defendant Style John husbandman 586264 586264 Style, John, of North Lewe, husbandman 0
3880061 1983591 1983591 defendant Northam Vincent yeoman 586264 586264 Northam, Vincent, of North Lewe, husbandman;Holand, John, of North Lewe, yeoman 0
3960318 2010704 2010704 defendant Turner Francis husbandman 586264 586264 Turner, Francis, of North Lewe, husbandman 0
3980574 2017816 2017816 defendant Arnold William husbandman 586264 586264 Arnold, William, of North Lewe, husbandman 0
4032806 2036387 2036387 defendant Weeke William weaver 586264 586264 Weeke, William, of North Lewe, weaver 0
4041677 2039510 2039510 defendant Newcomb Alexander husbandman 586264 586264 Newcomb, Alexander, of North Lewe, husbandman 1
4041685 2039510 2039510 defendant Wadlond John husbandman 586264 586264 Wadlond, John, of North Lewe, husbandman 9
4200789 2095834 2095834 defendant Shorte Thomas husbandman 586264 586264 Shorte, Thomas, of North Lewe, husbandman 0
4200791 2095835 2095835 defendant Wadland John, senior husbandman 586264 586264 Wadland, John, senior, of North Lewe, husbandman 0
4205443 2097457 2097457 defendant Soper alias Glanfyld Richard husbandman 586264 586264 Soper alias Glanfyld, Richard, of North Lewe, husbandman 0
4337349 2142796 2142796 defendant Weekes Richard gent 586264 586264 Weekes, Richard, of North Lewe, gent 1
4356620 2149548 2149548 defendant Gidleigh Hanibal yeoman 586264 586264 together with Gidleigh, Hanibal, of North Lewe, yeoman 1
4900790 2326880 2326880 defendant Bradstone Walter husbandman 586264 586264 Bradstone, Walter, of North Lewe, husbandman 3
5065817 2376297 2376297 defendant Glamvile Richard husbandman 586264 586264 Glamvile, Richard, of North Lewe, husbandman 0
5073071 2378432 2378432 defendant Holman Robert laborer 586264 586264 Holman, Robert, of North Lewe, laborer 0
5158392 2403576 2403576 defendant Glanvyle Hugh husbandman 586264 586264 Glanvyle, Hugh, of North Lewe, husbandman 1
5158397 2403577 2403577 defendant Glamvyle Hugh husbandman 586264 586264 Glamvyle, Hugh, of North Lewe, husbandman 1
5208677 2418261 2418261 defendant Glanvyle Hugh husbandman 586264 586264 Glanvyle, Hugh, of North Lewe, husbandman 0
5208681 2418262 2418262 defendant Glanvyle Hugh husbandman 586264 586264 Glanvyle, Hugh, of North Lewe, husbandman 0
5257983 2432619 2432619 defendant Hokday John husbandman 586264 586264 Hokday, John, of North Lewe, husbandman 0
5257984 2432619 2432619 defendant Southyeo Walter smith 586264 586264 Southyeo, Walter, of North Lewe, smith 1
5282545 2439955 2439955 defendant Bradston Walter husbandman 586264 586264 Bradston, Walter, of North Lewe, husbandman 0
5285891 2440888 2440888 defendant Parys William yeoman 586264 586264 Parys, William, of North Lewe, yeoman 8
5364516 2464558 2464558 defendant Hamond Thomas husbandman 586264 586264 Hamond, Thomas, of North Lewe, husbandman 4
5415212 2479492 2479492 defendant Flanche John clerk 586264 586264 Flanche, John, of North Lewe, clerk 0
5415213 2479492 2479492 defendant Stephans John clerk 586264 586264 Stephans, John, of North Lewe, clerk 1
5415214 2479492 2479492 defendant Maynard Vincent gent 586264 586264 Maynard, Vincent, of North Lewe, gent 2
5415215 2479492 2479492 defendant Bryan John yeoman 586264 586264 Bryan, John, of North Lewe, yeoman 3
5415216 2479492 2479492 defendant Hokkeday Nicholas laborer 586264 586264 Hokkeday, Nicholas, of North Lewe, laborer 4
5415217 2479492 2479492 defendant Smyth Walter smith 586264 586264 Smyth, Walter, of North Lewe, smith 5
5415218 2479492 2479492 defendant Rodde Walter weaver 586264 586264 Rodde, Walter, of North Lewe, weaver 6
5415219 2479492 2479492 defendant Fullard Nicholas   586264 586264 Fullard, Nicholas, of North Lewe, groom 7
5431377 2484337 2484337 defendant Flanche John clerk 586264 586264 Flanche, John, of North Lewe, clerk 0
5431378 2484337 2484337 defendant Stephans John clerk 586264 586264 Stephans, John, of North Lewe, clerk 1
5431379 2484337 2484337 defendant Maynard Vincent gent 586264 586264 Maynard, Vincent, of North Lewe, gent 2
5431380 2484337 2484337 defendant Bryan John yeoman 586264 586264 Bryan, John, of North Lewe, yeoman 3
5431381 2484337 2484337 defendant Hokkelday Nicholas laborer 586264 586264 Hokkelday, Nicholas, of North Lewe, laborer 4
5431382 2484337 2484337 defendant Smyth Walter smith 586264 586264 Smyth, Walter, of North Lewe, smith 5
5431383 2484337 2484337 defendant Redde Walter weaver 586264 586264 Redde, Walter, of North Lewe, weaver 6
5431384 2484337 2484337 defendant Fullard Nicholas   586264 586264 Fullard, Nicholas, of North Lewe, groom 7
5496257 2503781 2503781 defendant Flanche John clerk 586264 586264 Flanche, John, of North Lewe, clerk 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);