names

249 rows where place_id = 586085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587895 1863865 1863865 defendant Bedale John yeoman 586085 586085 Bedale, John, of Welton, yeoman 0
3657873 1912711 1912711 defendant Maier Thomas husbandman 586085 586085 Maier, Thomas, of Welton, husbandman 1
3657874 1912711 1912711 defendant Maier Robert husbandman 586085 586085 Maier, Robert, of Welton, husbandman 2
3657876 1912711 1912711 defendant Maier Willaia husbandman 586085 586085 Maier, Willaia, of Welton, husbandman 4
3759521 1944970 1944970 defendant Yswell John husbandman 586085 586085 Yswell, John, of Welton, husbandman 1
3774992 1949914 1949914 defendant Coke John husbandman 586085 586085 Coke, John, of Welton, husbandman 0
3774993 1949914 1949914 defendant Simondes Thomas laborer 586085 586085 Simondes, Thomas, of Welton, laborer 1
3782713 1952337 1952337 plaintiff Inglond Thomas   586085 586085 Inglond, Thomas, of Welton 0
3786209 1953481 1953481 defendant Smalley Richard husbandman 586085 586085 Smalley, Richard, of Welton, husbandman 0
3799287 1957693 1957693 plaintiff Inglond Thomas   586085 586085 Inglond, Thomas, of Welton 0
3807898 1960358 1960358 defendant Smalley Richard   586085 586085 Smalley, Richard, of Welton 0
3807899 1960358 1960358 defendant Hornesey Thomas husbandman 586085 586085 Hornesey, Thomas, of Welton, husbandman 1
3807900 1960358 1960358 defendant Johnson Robert pardoner 586085 586085 Johnson, Robert, of Welton, pardoner 2
3809777 1960945 1960945 defendant Bellamy Christopher yeoman 586085 586085 Bellamy, Christopher, of Welton, yeoman 1
3824826 1965642 1965642 defendant Johnson Robert husbandman 586085 586085 Johnson, Robert, of Welton, husbandman 0
3825516 1965832 1965832 defendant Kosse Richard husbandman 586085 586085 Kosse, Richard, of Welton, husbandman 0
3825517 1965832 1965832 defendant Pynson Robert   586085 586085 Pynson, Robert, of Welton, wright 1
3844183 1971731 1971731 defendant Johnson Robert husbandman 586085 586085 Johnson, Robert, of Welton, husbandman 0
3852506 1974392 1974392 defendant Kempe Robert husbandman 586085 586085 Kempe, Robert, of Welton, husbandman 1
3852507 1974392 1974392 defendant Arstebyng Robert laborer 586085 586085 Arstebyng, Robert, of Welton, laborer 2
3857986 1976146 1976146 plaintiff Beck Thomas yeoman 586085 586085 Beck, Thomas, of Welton, yeoman 0
3857987 1976146 1976146 plaintiff Bakon Robert yeoman 586085 586085 Bakon, Robert, of Welton, yeoman 1
3859641 1976720 1976720 defendant Hornsey Geoffrey yeoman 586085 586085 Hornsey, Geoffrey, of Welton, yeoman 0
3859643 1976721 1976721 defendant Hornsey Geoffrey yeoman 586085 586085 Hornsey, Geoffrey, of Welton, yeoman 0
3884212 1984985 1984985 defendant Rychardson John husbandman 586085 586085 Rychardson, John, of Welton, husbandman 5
3924031 1998346 1998346 defendant Knobley Robert husbandman 586085 586085 Knobley, Robert, of Welton, husbandman 1
3932238 2001089 2001089 defendant Newporte John gent 586085 586085 Newporte, John, of Welton, gent 0
3932550 2001175 2001175 defendant Downyng John husbandman 586085 586085 Downyng, John, of Welton, husbandman 1
3951938 2007741 2007741 defendant Grubbe Richard husbandman 586085 586085 Grubbe, Richard, of Welton, husbandman 0
3960445 2010751 2010751 plaintiff Sturton Henry   586085 586085 Sturton, Henry, of Welton 0
3960446 2010751 2010751 defendant Newmarshe Robert yeoman 586085 586085 Newmarshe, Robert, of Welton, yeoman 0
3960447 2010751 2010751 defendant Carlill John yeoman 586085 586085 Carlill, John, of Welton, yeoman 1
3987234 2020180 2020180 defendant Wyggen John yeoman 586085 586085 together with Wyggen, John, of Welton, yeoman 1
3987236 2020181 2020181 defendant Wyggyn John yeoman 586085 586085 Wyggyn, John, of Welton, yeoman 0
3989456 2020967 2020967 defendant Gyll Lawrence husbandman 586085 586085 together with Gyll, Lawrence, of Welton, husbandman 1
3991950 2021881 2021881 plaintiff Broxholm Robert gent 586085 586085 Broxholm, Robert, of Welton, gent 0
3991953 2021882 2021882 plaintiff Broxholme Robert yeoman 586085 586085 Broxholme, Robert, of Welton, yeoman 0
3991955 2021883 2021883 plaintiff Broxholme Robert yeoman 586085 586085 Broxholme, Robert, of Welton, yeoman 0
3991957 2021884 2021884 plaintiff Broxholme Robert yeoman 586085 586085 Broxholme, Robert, of Welton, yeoman 0
4033484 2036637 2036637 plaintiff Grene Thomas husbandman 586085 586085 Grene, Thomas, of Welton, husbandman 0
4051969 2043124 2043124 defendant Wigan John yeoman 586085 586085 Wigan, John, of Welton, yeoman 4
4077059 2052081 2052081 defendant Wolfe Richard husbandman 586085 586085 Wolfe, Richard, of Welton, or of Northampton, husbandman 0
4088666 2056247 2056247 defendant Woolfe Richard husbandman 586085 586085 Woolfe, Richard, of Welton, husbandman 0
4098447 2059772 2059772 defendant Cheveley Thomas carpenter 586085 586085 Cheveley, Thomas, of Welton, carpenter 0
4105925 2062412 2062412 defendant Wolfe Richard   586085 586085 Wolfe, Richard, of Welton, husbandman Seaton, Nicholas, of Wycken, gent husbandman, son of Simon 0
4113923 2065264 2065264 defendant Gouldinge James laborer 586085 586085 Gouldinge, James, of Welton, laborer 0
4134254 2072576 2072576 defendant Wayer William yeoman 586085 586085 Wayer, William, of Welton, yeoman 0
4144578 2076264 2076264 defendant Sylversyd Alvered yeoman 586085 586085 Sylversyd, Alvered, of Welton, yeoman 0
4145129 2076456 2076456 defendant Teysdayle William weaver 586085 586085 Teysdayle, William, of Welton, weaver 2
4150640 2078360 2078360 defendant Somersceles Henry miller 586085 586085 Somersceles, Henry, of Welton, miller 2
4176339 2087202 2087202 defendant Ware William yeoman 586085 586085 Ware, William, of Welton, yeoman 0
4176340 2087202 2087202 defendant Corye William clerk 586085 586085 Corye, William, of Welton, clerk 1
4176449 2087242 2087242 defendant Ashbye John husbandman 586085 586085 Ashbye, John, of Welton, husbandman 0
4176451 2087243 2087243 defendant Carr William husbandman 586085 586085 Carr, William, of Welton, husbandman 0
4176453 2087244 2087244 defendant Cooke John yeoman 586085 586085 Cooke, John, of Welton, yeoman 0
4176455 2087245 2087245 defendant Cooke John yeoman 586085 586085 Cooke, John, of Welton, yeoman 0
4176457 2087246 2087246 defendant Raynyarde Richard yeoman 586085 586085 Raynyarde, Richard, of Welton, yeoman 0
4179320 2088241 2088241 defendant Ware William yeoman 586085 586085 Ware, William, of Welton, yeoman 2
4179321 2088241 2088241 defendant Grene William yeoman 586085 586085 Grene, William, of Welton, yeoman 3
4179325 2088242 2088242 defendant Ware William yeoman 586085 586085 Ware, William, of Welton, yeoman 2
4179326 2088242 2088242 defendant Grene William yeoman 586085 586085 Grene, William, of Welton, yeoman 3
4187375 2091086 2091086 defendant Smythe Henry yeoman 586085 586085 Smythe, Henry, of Welton, yeoman 0
4195126 2093856 2093856 defendant Sharpe Brian tailor 586085 586085 Sharpe, Brian, of Welton, tailor 1
4232282 2106796 2106796 defendant Benyworth Henry yeoman 586085 586085 Benyworth, Henry, of Welton, yeoman 0
4241067 2109997 2109997 defendant Benyworth Henry yeoman 586085 586085 Benyworth, Henry, of Welton, yeoman 0
4277176 2121950 2121950 defendant Harryson John husbandman 586085 586085 Harryson, John, of Welton, husbandman 1
4277181 2121951 2121951 defendant Harryson John husbandman 586085 586085 Harryson, John, of Welton, husbandman 1
4277329 2121995 2121995 defendant Tailer George gent 586085 586085 Tailer, George, of Welton, gent 0
4283464 2124123 2124123 defendant Thorpe Libeus yeoman 586085 586085 Thorpe, Libeus, of Welton, yeoman 0
4283477 2124126 2124126 defendant Thorpe Libeus yeoman 586085 586085 Thorpe, Libeus, of Welton, yeoman 0
4295475 2128468 2128468 defendant Dickenson Hugh husbandman 586085 586085 Dickenson, Hugh, of Welton, husbandman 0
4300855 2130404 2130404 defendant Wood Thomas clerk 586085 586085 Wood, Thomas, of Welton, clerk 1
4338908 2143362 2143362 defendant Kempe Thomas yeoman 586085 586085 Kempe, Thomas, of Welton, yeoman 1
4354143 2148677 2148677 defendant Coldwell Oliver husbandman 586085 586085 Coldwell, Oliver, of Welton, husbandman 0
4356246 2149408 2149408 defendant Walton Randolph yeoman 586085 586085 Walton, Randolph, of Welton, yeoman 0
4358662 2150267 2150267 defendant Bacon William husbandman 586085 586085 Bacon, William, of Welton, husbandman 0
4359475 2150547 2150547 defendant Smyth Robert gent 586085 586085 Smyth, Robert, of Welton, gent 0
4366579 2153095 2153095 defendant Welden Michael gent 586085 586085 Welden, Michael, of Welton, gent 0
4366583 2153095 2153095 defendant Joplyn Cuthbert yeoman 586085 586085 Joplyn, Cuthbert, of Welton, yeoman 4
4377600 2157067 2157067 defendant Taylor George yeoman 586085 586085 Taylor, George, of Welton, yeoman 0
4377601 2157067 2157067 defendant Harryson John yeoman 586085 586085 Harryson, John, of Welton, yeoman 1
4377602 2157067 2157067 defendant Barker John husbandman 586085 586085 Barker, John, of Welton, husbandman 2
4377604 2157068 2157068 defendant Taylor George yeoman 586085 586085 Taylor, George, of Welton, yeoman 0
4377605 2157068 2157068 defendant Barker John husbandman 586085 586085 Barker, John, of Welton, husbandman 1
4377607 2157069 2157069 defendant Taylor George yeoman 586085 586085 Taylor, George, of Welton, yeoman 0
4377608 2157069 2157069 defendant Sympkynson Richard husbandman 586085 586085 Sympkynson, Richard, of Welton, husbandman 1
4377610 2157070 2157070 defendant Tayler George yeoman 586085 586085 Tayler, George, of Welton, yeoman 0
4377611 2157070 2157070 defendant Raynshawe Henry husbandman 586085 586085 Raynshawe, Henry, of Welton, husbandman 1
4377725 2157104 2157104 defendant Tayler George gent 586085 586085 Tayler, George, of Welton, gent 0
4378955 2157551 2157551 defendant Smyth Brian yeoman 586085 586085 Smyth, Brian, of Welton, yeoman 0
4378957 2157552 2157552 defendant Smyth Brian yeoman 586085 586085 Smyth, Brian, of Welton, yeoman 0
4378959 2157553 2157553 defendant Smythe Brian yeoman 586085 586085 Smythe, Brian, of Welton, yeoman 0
4379022 2157578 2157578 defendant Hatfeild Thomas husbandman 586085 586085 Hatfeild, Thomas, of Welton, yeoman, or of Boothbie, husbandman 0
4381306 2158428 2158428 defendant Smyth Robert gent 586085 586085 Smyth, Robert, of Welton, gent 0
4413620 2169152 2169152 defendant Tiwe John   586085 586085 Tiwe, John, of Welton 0
4415404 2169714 2169714 defendant Alforth Thomas de chaplain 586085 586085 Alforth, Thomas de, of Welton, chaplain 0
4417681 2170409 2170409 defendant Wright Walter le   586085 586085 Wright, Walter le, of Welton 0
4419362 2170939 2170939 defendant Broun Richard   586085 586085 Broun, Richard, of Welton, parson of the church of Weston by Northampton 0
4422663 2171944 2171944 plaintiff Eyr John le   586085 586085 Eyr, John le, of Welton, son of Henry 0
4437527 2176493 2176493 defendant (not given) Geoffrey vicar of Coo 586085 586085 Coo, Geoffrey, of Welton, vicar of the church of Flore 0

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