names

146 rows where place_id = 592031

✎ 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
3606354 1869655 1869655 defendant Croyn Robert husbandman 592031 592031 Croyn, Robert, of Madley, husbandman 0
3606355 1869655 1869655 defendant Baughan Hugh husbandman 592031 592031 Baughan, Hugh, of Madley, husbandman 1
3606356 1869655 1869655 defendant Smyth John husbandman 592031 592031 Smyth, John, of Madley, husbandman 2
3606357 1869655 1869655 defendant Gough John husbandman 592031 592031 Gough, John, of Madley, husbandman 3
3611720 1871327 1871327 defendant Baron William chaplain 592031 592031 Baron, William, of Madley, chaplain 0
3611731 1871331 1871331 defendant Carwardyn Edward chaplain 592031 592031 Carwardyn, Edward, of Madley, chaplain 0
3638970 1907010 1907010 defendant Carwardyn Lewis husbandman 592031 592031 Carwardyn, Lewis, of Madley, husbandman 2
3660308 1913485 1913485 defendant Smyth Robert smith 592031 592031 Smyth, Robert, of Madley, smith 1
3660970 1913702 1913702 defendant Seybone John yeoman 592031 592031 Seybone, John, of Madley, yeoman 0
3662333 1914133 1914133 defendant Carwardyn Lewis husbandman 592031 592031 Carwardyn, Lewis, of Madley, husbandman 0
3679531 1919667 1919667 defendant Davyes John husbandman 592031 592031 Davyes, John, of Madley, husbandman 4
3688499 1922560 1922560 defendant Payne Jenn laborer 592031 592031 Payne, Jenn, of Madley, laborer 0
3688500 1922560 1922560 defendant Payne Thomas husbandman 592031 592031 Payne, Thomas, of Madley, husbandman 1
3688501 1922560 1922560 defendant Tewe Howell laborer 592031 592031 Tewe, Howell, of Madley, laborer 2
3694953 1924632 1924632 defendant Dansey Thomas husbandman 592031 592031 Dansey, Thomas, of Madley, husbandman 0
3723764 1933708 1933708 defendant Barrewardyn Roger husbandman 592031 592031 Barrewardyn, Roger, of Madley, husbandman 4
3724138 1933833 1933833 defendant Dansy Thomas husbandman 592031 592031 Dansy, Thomas, of Madley, husbandman 0
3724140 1933833 1933833 defendant Symonde Thomas husbandman 592031 592031 Symonde, Thomas, of Madley, husbandman 2
3773845 1949531 1949531 defendant ap Jenkyn Lewis carpenter 592031 592031 ap Jenkyn, Lewis, of Madley, carpenter 3
3786593 1953602 1953602 defendant ap Rees John husbandman 592031 592031 ap Rees, John, of Madley, husbandman 0
3786958 1953723 1953723 defendant ap Ries John husbandman 592031 592031 ap Ries, John, of Madley, husbandman 0
3826156 1966022 1966022 defendant Bulkott William husbandman 592031 592031 Bulkott, William, of Madley, husbandman 1
3830882 1967541 1967541 defendant Fote Walter husbandman 592031 592031 Fote, Walter, of Madley, husbandman 1
3841211 1970829 1970829 defendant Hunt William clerk 592031 592031 Hunt, William, of Madley, clerk 0
3850293 1973678 1973678 defendant ap Rees John husbandman 592031 592031 ap Rees, John, of Madley, husbandman 1
3870592 1980405 1980405 defendant Smythe Thomas husbandman 592031 592031 Smythe, Thomas, of Madley, husbandman 2
3874852 1981808 1981808 defendant Gryffith Thomas husbandman 592031 592031 Gryffith, Thomas, of Madley, husbandman 0
3874853 1981808 1981808 defendant ap Ithell Thomas husbandman 592031 592031 ap Ithell, Thomas, of Madley, husbandman 1
3901853 1990843 1990843 defendant Dansey John husbandman 592031 592031 Dansey, John, of Madley, husbandman 0
3913922 1995003 1995003 defendant Seburne John husbandman 592031 592031 Seburne, John, of Madley, husbandman 0
3913923 1995003 1995003 defendant Holyday John husbandman 592031 592031 Holyday, John, of Madley, husbandman 1
3913924 1995003 1995003 defendant Kynnersley William husbandman 592031 592031 Kynnersley, William, of Madley, husbandman 2
3913925 1995003 1995003 defendant Bull James husbandman 592031 592031 Bull, James, of Madley, husbandman 3
3913926 1995003 1995003 defendant Baynam Thomas husbandman 592031 592031 Baynam, Thomas, of Madley, husbandman 4
3929664 2000271 2000271 defendant Lane Henry husbandman 592031 592031 Lane, Henry, of Madley, husbandman 0
3929675 2000271 2000271 defendant Goughe William husbandman 592031 592031 Goughe, William, of Madley, husbandman 11
3929676 2000271 2000271 defendant Wenlond Walter yeoman 592031 592031 Wenlond, Walter,of Madley, yeoman 12
3929688 2000272 2000272 defendant Beale William yeoman 592031 592031 Beale, William, of Madley, yeoman 4
3929689 2000272 2000272 defendant ap Rice Roger husbandman 592031 592031 ap Rice, Roger, of Madley, husbandman 5
3929692 2000272 2000272 defendant Seyborne John husbandman 592031 592031 Seyborne, John, of Madley, husbandman 8
3929696 2000272 2000272 defendant ap Jenour Walter husbandman 592031 592031 ap Jenour, Walter, of Madley, husbandman 12
3929697 2000272 2000272 defendant ap Rosser Richard husbandman 592031 592031 ap Rosser, Richard, of Madley, husbandman 13
3929703 2000273 2000273 defendant Smythe James husbandman 592031 592031 Smythe, James, of Madley, husbandman 0
3929705 2000273 2000273 defendant Rowles Salterus husbandman 592031 592031 Rowles, Salterus, of Madley, husbandman 2
3932847 2001276 2001276 defendant Coke William laborer 592031 592031 Coke, William, of Madley, laborer 41
4010585 2028563 2028563 defendant Yoroth Philip yeoman 592031 592031 Yoroth, Philip, of Madley, yeoman 0
4026927 2034280 2034280 defendant Lace John tailor 592031 592031 Lace, John, of Madley, tailor 0
4042457 2039781 2039781 defendant Geybon Thomas yeoman 592031 592031 Geybon, Thomas, of Madley, yeoman 8
4042471 2039782 2039782 defendant Seybon Thomas yeoman 592031 592031 Seybon, Thomas, of Madley, yeoman 8
4050782 2042717 2042717 defendant Charles John husbandman 592031 592031 Charles, John, of Madley, husbandman 0
4063210 2047136 2047136 defendant Perce Henry yeoman 592031 592031 Perce, Henry, of Madley, yeoman 4
4073746 2050904 2050904 defendant Lane Walter yeoman 592031 592031 Lane, Walter, of Madley, yeoman 0
4079318 2052904 2052904 defendant Lane Henry yeoman 592031 592031 Lane, Henry, of Madley, yeoman 0
4079319 2052904 2052904 defendant Lane Walter yeoman 592031 592031 Lane, Walter, of Madley, yeoman 1
4096511 2059079 2059079 defendant Olroyde Edward clothier 592031 592031 Olroyde, Edward, of Madley, or of Stanley, clothier 0
4104622 2061935 2061935 defendant Lane Walter yeoman 592031 592031 Lane, Walter, of Madley, yeoman 0
4105000 2062061 2062061 defendant Fote William husbandman 592031 592031 Fote, William, of Madley, husbandman 3
4118754 2066991 2066991 defendant Seybon Thomas husbandman 592031 592031 Seybon, Thomas, of Madley, husbandman 2
4118759 2066992 2066992 defendant Seybon Thomas husbandman 592031 592031 Seybon, Thomas, of Madley, husbandman 2
4121585 2068014 2068014 defendant Seybon Thomas husbandman 592031 592031 Seybon, Thomas, of Madley, husbandman 0
4127294 2070056 2070056 defendant Seybon William yeoman 592031 592031 Seybon, William, of Madley, yeoman 0
4127296 2070057 2070057 defendant Seybon William yeoman 592031 592031 Seybon, William, of Madley, yeoman 0
4127377 2070081 2070081 defendant Seybon Thomas husbandman 592031 592031 Seybon, Thomas, of Madley, husbandman 3
4143532 2075895 2075895 defendant Symons Edward yeoman 592031 592031 Symons, Edward, of Madley, yeoman 3
4147233 2077170 2077170 defendant Weston John yeoman 592031 592031 Weston, John, of Madley, yeoman 0
4149029 2077779 2077779 defendant Wyddowes George yeoman 592031 592031 Wyddowes, George, of Madley, yeoman 0
4149031 2077780 2077780 defendant Wyddowes George yeoman 592031 592031 Wyddowes, George, of Madley, yeoman 0
4176653 2087304 2087304 defendant Beale William, junior yeoman 592031 592031 Beale, William, junior, of Madley, yeoman 0
4176654 2087304 2087304 defendant Carwardyne John, senior yeoman 592031 592031 Carwardyne, John, senior, of Madley, yeoman 1
4176656 2087304 2087304 defendant Pantwall George yeoman 592031 592031 Pantwall, George, of Madley, yeoman 3
4176658 2087305 2087305 defendant Goughe Thomas yeoman 592031 592031 Goughe, Thomas, of Madley, yeoman 0
4176659 2087305 2087305 defendant Pantall George yeoman 592031 592031 Pantall, George, of Madley, yeoman 1
4179258 2088223 2088223 defendant Seborne John gent 592031 592031 Seborne, John, of Madley, gent 3
4179264 2088225 2088225 defendant Seborn John gent 592031 592031 Seborn, John, of Madley, gent 2
4180682 2088725 2088725 defendant Goughe Thomas yeoman 592031 592031 Goughe, Thomas, of Madley, yeoman 0
4199821 2095490 2095490 defendant Ocle Robert yeoman or shopkeeper 592031 592031 Ocle, Robert, of Madley, yeoman or shopkeeper 0
4199824 2095490 2095490 defendant Seybon William yeoman 592031 592031 Seybon, William, of Madley, yeoman 3
4206423 2097788 2097788 defendant Sebon William yeoman 592031 592031 Sebon, William, of Madley, yeoman 1
4214721 2100654 2100654 defendant Lawrence Richard yeoman 592031 592031 Lawrence, Richard, of Madley, yeoman 1
4215129 2100791 2100791 defendant Stevens Thomas smith 592031 592031 Stevens, Thomas, of Madley, smith 0
4215528 2100928 2100928 defendant Smythe Walter husbandman 592031 592031 Smythe, Walter, of Madley, husbandman 0
4215529 2100928 2100928 defendant Cardwardyne William yeoman 592031 592031 Cardwardyne, William, of Madley, yeoman 1
4217433 2101591 2101591 defendant Whicksteede William yeoman 592031 592031 Whicksteede, William, of Madley, yeoman 0
4224581 2104074 2104074 defendant Stevens Thomas smith 592031 592031 Stevens, Thomas, of Madley, smith 0
4233109 2107087 2107087 defendant Smythe Walter husbandman 592031 592031 Smythe, Walter, of Madley, husbandman 0
4233110 2107087 2107087 defendant Carwardine Thomas yeoman 592031 592031 Carwardine, Thomas, of Madley, yeoman 1
4238076 2108920 2108920 defendant Carwardyn William husbandman 592031 592031 Carwardyn, William, of Madley, or of Webton, husbandman 0
4238115 2108937 2108937 defendant Lawrens Maud widow 592031 592031 Lawrens, Maud, of Madley, widow 0
4238116 2108937 2108937 defendant Lawrens Richard yeoman 592031 592031 Lawrens, Richard, of Madley, yeoman 1
4238117 2108937 2108937 defendant Mawrens Margaret spinster 592031 592031 Mawrens, Margaret, of Madley, spinster 2
4241711 2110215 2110215 defendant Charles Joan widow 592031 592031 Charles, Joan, of Madley, widow 0
4241712 2110215 2110215 defendant Charles Thomas husbandman 592031 592031 Charles, Thomas, of Madley, husbandman 1
4241713 2110215 2110215 defendant Charles John husbandman 592031 592031 Charles, John, of Madley, husbandman 2
4241714 2110215 2110215 defendant Carwardyn Henry weaver 592031 592031 Carwardyn, Henry, of Madley, weaver 3
4292891 2127523 2127523 defendant Tompkyns John yeoman 592031 592031 Tompkyns, John, of Madley, yeoman 3
4296451 2128831 2128831 defendant Charles Joan widow 592031 592031 Charles, Joan, of Madley, widow 2
4314121 2135045 2135045 defendant Wicksteed William yeoman 592031 592031 Wicksteed, William, of Madley, yeoman 1
4319046 2136777 2136777 defendant Goughe Thomas yeoman 592031 592031 Goughe, Thomas, of Madley, yeoman 1
4370031 2154338 2154338 defendant Carwardyne Richard yeoman 592031 592031 Carwardyne, Richard, of Madley, yeoman 0
4374962 2156103 2156103 defendant Lewys Roger yeoman 592031 592031 Lewys, Roger, of Madley, yeoman 2

Next page

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