names

78 rows where place_id = 588483

✎ 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
3594651 1865956 1865956 defendant Baguley Robert yeoman 588483 588483 Baguley, Robert, of Audeley, yeoman 0
3594654 1865957 1865957 defendant Baguley Robert yeoman 588483 588483 Baguley, Robert, of Audeley, yeoman 0
3594655 1865957 1865957 defendant Smyth Ralph yeoman 588483 588483 Smyth, Ralph, of Audeley, yeoman 1
3632124 1904862 1904862 defendant Buttur Thomas husbandman 588483 588483 Buttur, Thomas, of Audeley, husbandman 0
3638920 1906998 1906998 defendant Aldynger Ralph husbandman 588483 588483 Aldynger, Ralph, of Audeley, husbandman 2
3638926 1906999 1906999 defendant Aldynger Randolph husbandman 588483 588483 Aldynger, Randolph, of Audeley, husbandman 2
3638932 1907000 1907000 defendant Aldynger Ralph husbandman 588483 588483 Aldynger, Ralph, of Audeley, husbandman 2
3699192 1925961 1925961 defendant Tuchet John   588483 588483 Tuchet, John, of Audeley, knight 0
3727882 1934989 1934989 defendant Tuchet John   588483 588483 Tuchet, John, of Audeley, knight 0
3747750 1941218 1941218 defendant Audeley John   588483 588483 Audeley, John, of Audeley, knight 0
3793172 1955725 1955725 plaintiff Bolton John   588483 588483 Bolton, John, of Audeley 0
3793175 1955725 1955725 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, yeoman 2
3793177 1955725 1955725 defendant Shawe Richard yeoman 588483 588483 Shawe, Richard, of Audeley, yeoman 4
3793178 1955726 1955726 plaintiff Bolton John   588483 588483 Bolton, John, of Audeley 0
3793181 1955726 1955726 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, yeoman 2
3793183 1955726 1955726 defendant Shawe Richard yeoman 588483 588483 Shawe, Richard, of Audeley, yeoman 4
3825570 1965849 1965849 plaintiff Wyttaght Warburga widow 588483 588483 Wyttaght, Warburga, of Audeley, widow 0
3825571 1965849 1965849 defendant Wyttaght William yeoman 588483 588483 Wyttaght, William, of Audeley, yeoman 0
3825572 1965849 1965849 defendant Ryley John yeoman 588483 588483 Ryley, John, of Audeley, yeoman 1
3841716 1970993 1970993 defendant Gawell Richard husbandman 588483 588483 Gawell, Richard, of Audeley, husbandman 1
3851273 1973996 1973996 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, yeoman 2
3851278 1973997 1973997 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, yeoman 2
3862045 1977494 1977494 defendant Reve John yeoman 588483 588483 Reve, John, of Audeley, yeoman 1
3869286 1979969 1979969 defendant Smyth John tanner 588483 588483 Smyth, John, of Audeley, tanner 0
3869289 1979970 1979970 defendant Parker John yeoman 588483 588483 Parker, John, of Audeley, yeoman 1
3869290 1979970 1979970 defendant Blower Agnes widow 588483 588483 Blower, Agnes, of Audeley, widow 2
3891982 1987568 1987568 defendant Reve John, junior husbandman 588483 588483 Reve, John, junior, of Audeley, husbandman 0
3891984 1987569 1987569 defendant Reve John, junior husbandman 588483 588483 Reve, John, junior, of Audeley, husbandman 0
3894518 1988376 1988376 defendant Garrett John bloomer 588483 588483 Garrett, John, of Audeley, bloomer 0
3916371 1995858 1995858 defendant Reve John yeoman 588483 588483 Reve, John, of Audeley, yeoman 0
3963020 2011664 2011664 defendant Geneson Ralph yeoman 588483 588483 Geneson, Ralph, of Audeley, yeoman 0
3963021 2011664 2011664 defendant Smyth Humphrey yeoman 588483 588483 Smyth, Humphrey, of Audeley, yeoman 1
3963022 2011664 2011664 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, or of Pele, yeoman 2
3963024 2011665 2011665 defendant Geneson Ralph yeoman 588483 588483 Geneson, Ralph, of Audeley, yeoman 0
3963025 2011665 2011665 defendant Smyth Humphrey yeoman 588483 588483 Smyth, Humphrey, of Audeley, yeoman 1
3963026 2011665 2011665 defendant Smyth Robert yeoman 588483 588483 Smyth, Robert, of Audeley, or of Pele, yeoman 2
4037284 2038000 2038000 plaintiff Jones Richard   588483 588483 Jones, Richard, of Audeley, gent, administrators of 0
4066425 2048287 2048287 defendant Synar or Syvar Robert laborer 588483 588483 Synar or Syvar, Robert, of Audeley, laborer 0
4172193 2085737 2085737 defendant Boughe John husbandman 588483 588483 Boughe, John, of Audeley, or of Knowlande, husbandman 0
4215997 2101088 2101088 defendant Parker Humphrey   588483 588483 Parker, Humphrey, of Audeley, husbandman, his son 1
4232516 2106875 2106875 defendant Garnett John yeoman 588483 588483 Garnett, John, of Audeley, yeoman 0
4279554 2122765 2122765 defendant Rowley William yeoman 588483 588483 (Rowley, William, of Audeley, yeoman 1
4288604 2125977 2125977 defendant Rowley William yeoman 588483 588483 (Rowley, William, of Audeley, yeoman 1
4288605 2125977 2125977 defendant Forster alias Burghe Robert tanner 588483 588483 Forster alias Burghe, Robert, of Audeley, tanner 2
4336914 2142636 2142636 defendant Garrett James yeoman 588483 588483 Garrett, James, of Audeley, yeoman 2
4336915 2142636 2142636 defendant Vigars Henry laborer 588483 588483 Vigars, Henry, of Audeley, laborer 3
4339453 2143565 2143565 defendant Bolton Roger yeoman 588483 588483 Bolton, Roger, of Audeley, yeoman 0
4343941 2145159 2145159 defendant Parker John tailor 588483 588483 Parker, John, of Audeley, tailor 1
4386010 2160009 2160009 defendant Balle John carpenter 588483 588483 Balle, John, of Audeley, carpenter 1
4409849 2167897 2167897 defendant Rowley Arthur yeoman 588483 588483 Rowley, Arthur, of Audeley, yeoman 0
5107186 2388532 2388532 defendant Baguley Peter yeoman 588483 588483 Baguley, Peter, of Audeley, yeoman 0
5107187 2388532 2388532 defendant Wood William yeoman 588483 588483 Wood, William, of Audeley, yeoman 1
5119307 2392069 2392069 defendant Lovete Thomas husbandman 588483 588483 Lovete, Thomas, of Audeley, husbandman 2
5149617 2401017 2401017 defendant Bagiley Peter yeoman 588483 588483 Bagiley, Peter, of Audeley, yeoman 1
5168495 2406501 2406501 defendant Bagiliey Peter yeoman 588483 588483 Bagiliey, Peter, of Audeley, yeoman 1
5184480 2411202 2411202 defendant Bagiley Peter yeoman 588483 588483 Bagiley, Peter, of Audeley, yeoman 0
5213737 2419748 2419748 defendant Longley Thomas husbandman 588483 588483 Longley, Thomas, of Audeley, husbandman 2
5213739 2419748 2419748 defendant Taillour Philip husbandman 588483 588483 Taillour, Philip, of Audeley, husbandman 4
5230069 2424411 2424411 plaintiff Audeley John   588483 588483 Audeley, John, of Audeley, knight 0
5281895 2439780 2439780 defendant Rugges Richard husbandman 588483 588483 Rugges, Richard, of Audeley, husbandman 0
5281896 2439780 2439780 defendant Wode William yeoman 588483 588483 Wode, William, of Audeley, yeoman 1
5297601 2444302 2444302 defendant Parker Richard yeoman 588483 588483 Parker, Richard, of Audeley, yeoman 1
5297602 2444302 2444302 defendant Crokebye Thomas yeoman 588483 588483 Crokebye, Thomas, of Audeley, yeoman 2
5414345 2479226 2479226 defendant Audeley John   588483 588483 Audeley, John, of Audeley, knight 0
5444862 2488353 2488353 defendant Browet Thomas yeoman 588483 588483 Browet, Thomas, of Audeley, yeoman 12
5446977 2488987 2488987 defendant Audeley John   588483 588483 Audeley, John, of Audeley, knight 0
5457445 2492125 2492125 defendant Croket Thomas yeoman 588483 588483 Croket, Thomas, of Audeley, yeoman 11
5469373 2495766 2495766 defendant Corket Thomas yeoman 588483 588483 Corket, Thomas, of Audeley, yeoman 12
5493516 2502974 2502974 defendant Smyth John husbandman 588483 588483 Smyth, John, of Audeley, husbandman 0
5493517 2502974 2502974 defendant Verdon Fithian husbandman 588483 588483 Verdon, Fithian, of Audeley, husbandman 1
5493522 2502976 2502976 defendant Smyth John husbandman 588483 588483 Smyth, John, of Audeley, husbandman 0
5493523 2502976 2502976 defendant Verdon Fithian husbandman 588483 588483 Verdon, Fithian, of Audeley, husbandman 1
5495492 2503552 2503552 defendant Stretforthe Robert yeoman 588483 588483 Stretforthe, Robert, of Audeley, yeoman 0
5562895 2523739 2523739 defendant Butter Richard smith 588483 588483 Butter, Richard, of Audeley, smith 1
5562896 2523739 2523739 defendant Boughey Thomas yeoman 588483 588483 Boughey, Thomas, of Audeley, yeoman 2
5562897 2523739 2523739 defendant Boughey James smith 588483 588483 Boughey, James, of Audeley, smith 3
5562898 2523739 2523739 defendant Holyn William husbandman 588483 588483 Holyn, William, of Audeley, husbandman 4
5568146 2525231 2525231 plaintiff Ewe William (legal representative) 588483 588483 Ewe, William, of Audeley, executors of 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);