names

264 rows where place_id = 607914

✎ 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
3671435 1917045 1917045 defendant Wyter John yeoman 607914 607914 Wyter, John, of Wrangle, yeoman 0
3752562 1942728 1942728 defendant Watson William husbandman 607914 607914 Watson, William, of Wrangle, husbandman 0
3761860 1945717 1945717 defendant Stephynson William husbandman 607914 607914 Stephynson, William, of Wrangle, husbandman 0
3793699 1955895 1955895 defendant Hopster William, junior husbandman 607914 607914 Hopster, William, junior, of Wrangle, husbandman 0
3824817 1965639 1965639 plaintiff Willons Agnes widow 607914 607914 Willons, Agnes, of Wrangle, widow 0
3824818 1965639 1965639 defendant Willons Walter husbandman 607914 607914 Willons, Walter, of Wrangle, husbandman 0
3824820 1965639 1965639 defendant Whitebrede John husbandman 607914 607914 Whitebrede, John, of Wrangle, husbandman 2
3830132 1967323 1967323 defendant Rede John merchant of the staple 607914 607914 Rede, John, of Wrangle, merchant of the staple 0
3831084 1967607 1967607 defendant Rede John merchant 607914 607914 Rede, John, of Wrangle, merchant 0
3836298 1969261 1969261 defendant Gildon John, senior husbandman 607914 607914 Gildon, John, senior, of Wrangle, husbandman 0
3836481 1969316 1969316 defendant Rede Richard merchant of the staple 607914 607914 Rede, Richard, of Wrangle, merchant of the staple 1
3852575 1974413 1974413 defendant Rede Richard merchant of the staple 607914 607914 Rede, Richard, of Wrangle, merchant of the staple 1
3868686 1979768 1979768 defendant Rede John gent 607914 607914 Rede, John, of Wrangle, gent 0
3887101 1985949 1985949 defendant Benne Alexander husbandman 607914 607914 Benne, Alexander, of Wrangle, husbandman 0
3887102 1985949 1985949 defendant Kame Roger laborer 607914 607914 Kame, Roger, of Wrangle, laborer 1
3895443 1988685 1988685 defendant Chamber Henry husbandman 607914 607914 Chamber, Henry, of Wrangle, husbandman 0
3911915 1994309 1994309 defendant Rede John gent 607914 607914 Rede, John, of Wrangle, gent 0
3916529 1995904 1995904 defendant Came Roger husbandman 607914 607914 Came, Roger, of Wrangle, husbandman 0
3916530 1995904 1995904 defendant Tolus Hugh husbandman 607914 607914 Tolus, Hugh, of Wrangle, husbandman 1
3916531 1995904 1995904 defendant Claxton Robert husbandman 607914 607914 Claxton, Robert, of Wrangle, husbandman 2
3916532 1995904 1995904 defendant Benne Robert husbandman 607914 607914 Benne, Robert, of Wrangle, husbandman 3
3916533 1995904 1995904 defendant Wright William husbandman 607914 607914 Wright, William, of Wrangle, husbandman 4
3922246 1997751 1997751 defendant Reed Francis gent 607914 607914 Reed, Francis, of Wrangle, gent 0
3922247 1997751 1997751 defendant Bate Richard laborer 607914 607914 Bate, Richard, of Wrangle, laborer 1
3972295 2014875 2014875 defendant Ambler John husbandman 607914 607914 Ambler, John, of Wrangle, husbandman 0
3992456 2022065 2022065 defendant Leyter John yeoman 607914 607914 (Leyter, John, of Wrangle, yeoman 1
4029090 2035049 2035049 defendant Leister John yeoman 607914 607914 Leister, John, of Wrangle, yeoman 0
4037797 2038171 2038171 defendant Pekerynge William husbandman 607914 607914 Pekerynge, William, of Wrangle, or of Leke, husbandman 0
4044656 2040537 2040537 defendant Redde William gent 607914 607914 Redde, William, of Wrangle, gent 0
4063781 2047332 2047332 defendant Leceter John yeoman 607914 607914 Leceter, John, of Wrangle, yeoman 0
4089271 2056448 2056448 defendant Boston William husbandman 607914 607914 Boston, William, of Wrangle, husbandman 0
4089272 2056448 2056448 defendant Gray John smith 607914 607914 Gray, John, of Wrangle, smith 1
4089273 2056448 2056448 defendant Dewse William husbandman 607914 607914 Dewse, William, of Wrangle, husbandman 2
4089275 2056449 2056449 defendant Gulbyn or Gubbyn John yeoman 607914 607914 Gulbyn or Gubbyn, John, of Wrangle, yeoman 0
4089276 2056449 2056449 defendant Ryngatt William smith 607914 607914 Ryngatt, William, of Wrangle, smith 1
4089277 2056449 2056449 defendant Toly Richard laborer 607914 607914 Toly, Richard, of Wrangle, laborer 2
4090834 2057010 2057010 defendant Hopster Walter husbandman 607914 607914 Hopster, Walter, of Wrangle, husbandman 0
4091788 2057356 2057356 defendant Elwarde Walter yeoman 607914 607914 Elwarde, Walter, of Wrangle, yeoman 0
4092436 2057597 2057597 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4093968 2058169 2058169 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4096146 2058950 2058950 defendant Walker Richard thatcher 607914 607914 Walker, Richard, of Wrangle, thatcher 0
4096147 2058950 2058950 defendant White Thomas laborer 607914 607914 White, Thomas, of Wrangle, laborer 1
4112106 2064586 2064586 defendant Chamberleyn Francis yeoman 607914 607914 Chamberleyn, Francis, of Wrangle, yeoman 0
4115313 2065767 2065767 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4117619 2066597 2066597 defendant Chamberleyn Francis yeoman 607914 607914 Chamberleyn, Francis, of Wrangle, yeoman 0
4121315 2067919 2067919 defendant Southe John yeoman 607914 607914 Southe, John, of Wrangle, yeoman 0
4122143 2068225 2068225 defendant Leceter John yeoman 607914 607914 Leceter, John, of Wrangle, yeoman 0
4122146 2068225 2068225 defendant Walker Richard yeoman 607914 607914 Walker, Richard, of Wrangle, yeoman 3
4124708 2069131 2069131 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4125272 2069324 2069324 defendant Chamberlayne Francis yeoman 607914 607914 Chamberlayne, Francis, of Wrangle, yeoman 0
4125273 2069324 2069324 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 1
4125505 2069404 2069404 defendant Chamberlayne Francis gent 607914 607914 Chamberlayne, Francis, of Wrangle, gent 0
4138214 2074036 2074036 defendant Chamberlayne Francis yeoman 607914 607914 Chamberlayne, Francis, of Wrangle, yeoman 0
4145336 2076531 2076531 defendant Leceter John yeoman 607914 607914 Leceter, John, of Wrangle, yeoman 0
4146189 2076818 2076818 defendant Singleton Richard husbandman 607914 607914 Singleton, Richard, of Wrangle, husbandman 0
4151319 2078584 2078584 defendant Leceter John yeoman 607914 607914 Leceter, John, of Wrangle, yeoman 0
4151322 2078585 2078585 defendant Leceter John yeoman 607914 607914 Leceter, John, of Wrangle, yeoman 0
4167298 2084062 2084062 defendant Chamberlayn Francis yeoman 607914 607914 Chamberlayn, Francis, of Wrangle, yeoman 8
4168890 2084610 2084610 defendant Sallet John yeoman 607914 607914 Sallet, John, of Wrangle, yeoman 0
4171447 2085477 2085477 defendant Rede William gent 607914 607914 Rede, William, of Wrangle, gent 0
4172200 2085740 2085740 defendant Rede William gent 607914 607914 Rede, William, of Wrangle, gent 0
4172201 2085740 2085740 defendant Rede John gent 607914 607914 Rede, John, of Wrangle, gent 1
4172254 2085760 2085760 defendant Ben or Bever John mercer 607914 607914 Ben or Bever, John, of Wrangle, mercer 0
4173554 2086206 2086206 defendant Chamberlayne Francis yeoman 607914 607914 Chamberlayne, Francis, of Wrangle, yeoman 0
4176497 2087262 2087262 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4186322 2090701 2090701 defendant Chamberlayn Francis yeoman 607914 607914 Chamberlayn, Francis, of Wrangle, yeoman 0
4189090 2091675 2091675 defendant Reade William gent 607914 607914 Reade, William, of Wrangle, gent 0
4189091 2091675 2091675 defendant Gilden John husbandman 607914 607914 Gilden, John, of Wrangle, husbandman 1
4190003 2092006 2092006 defendant Tunarde Nicholas husbandman 607914 607914 Tunarde, Nicholas, of Wrangle, husbandman 0
4196905 2094468 2094468 defendant Chamberlayne Francis yeoman 607914 607914 Chamberlayne, Francis, of Wrangle, yeoman 0
4199778 2095473 2095473 defendant Panton John yeoman 607914 607914 Panton, John, of Wrangle, yeoman 0
4234895 2107758 2107758 defendant Clerkson Salamon yeoman 607914 607914 Clerkson, Salamon, of Wrangle, yeoman 0
4234896 2107758 2107758 defendant Shingelton Richard husbandman 607914 607914 Shingelton, Richard, of Wrangle, husbandman 1
4234897 2107758 2107758 defendant Symson John husbandman 607914 607914 Symson, John, of Wrangle, husbandman 2
4239057 2109282 2109282 defendant Hill John husbandman 607914 607914 Hill, John, of Wrangle, husbandman 0
4261085 2116676 2116676 defendant Goodricke Francis yeoman 607914 607914 Goodricke, Francis, of Wrangle, yeoman 0
4283038 2123966 2123966 defendant Banyster Miles yeoman 607914 607914 Banyster, Miles, of Wrangle, yeoman 0
4288277 2125854 2125854 defendant Benne John yeoman 607914 607914 Benne, John, of Wrangle, yeoman 0
4298977 2129731 2129731 defendant Benne John husbandman 607914 607914 Benne, John, of Wrangle, husbandman 0
4298979 2129732 2129732 defendant Robinson John husbandman 607914 607914 Robinson, John, of Wrangle, husbandman 0
4298980 2129732 2129732 defendant Panton John husbandman 607914 607914 Panton, John, of Wrangle, husbandman 1
4298982 2129732 2129732 defendant Mayson William husbandman 607914 607914 Mayson, William, of Wrangle, husbandman 3
4363884 2152142 2152142 defendant Sallett John husbandman 607914 607914 Sallett, John, of Wrangle, husbandman 0
4363885 2152142 2152142 defendant Goodricke William laborer 607914 607914 Goodricke, William, of Wrangle, laborer 1
4423498 2172198 2172198 defendant Godeman atte Hill Thomas   607914 607914 Godeman atte Hill, Thomas, of Wrangle, son of Walter 0
4424516 2172506 2172506 defendant Raunde John   607914 607914 Raunde, John, of Wrangle 0
4424517 2172506 2172506 defendant Raunde William   607914 607914 Raunde, William, of Wrangle 1
4424518 2172506 2172506 defendant Wilot Alan   607914 607914 Wilot, Alan, of Wrangle 2
4424519 2172506 2172506 defendant Wyse Baldrick   607914 607914 Wyse, Baldrick, of Wrangle 3
4424520 2172506 2172506 defendant Wyse Alan   607914 607914 Wyse, Alan, of Wrangle 4
4424521 2172506 2172506 defendant Stave Hugh   607914 607914 Stave, Hugh, of Wrangle 5
4424522 2172506 2172506 defendant Mordon Richard   607914 607914 Mordon, Richard, of Wrangle, son of Alan 6
4424523 2172506 2172506 defendant Campion Richard   607914 607914 Campion, Richard, of Wrangle 7
4424524 2172506 2172506 defendant Capman Aldous   607914 607914 Capman, Aldous, of Wrangle 8
4424900 2172626 2172626 defendant Michel William   607914 607914 Michel, William, of Wrangle 0
4428582 2173746 2173746 defendant Whytbred Alexander   607914 607914 Whytbred, Alexander, of Wrangle 0
4429398 2174000 2174000 defendant Le Straunge Roger   607914 607914 Le Straunge, Roger, of Wrangle 0
4434044 2175407 2175407 defendant Straunge Roger   607914 607914 Straunge, Roger, of Wrangle 0
4434047 2175408 2175408 defendant Straunge Roger   607914 607914 Straunge, Roger, of Wrangle 0
4455312 2186668 2186668 defendant Johenson William   607914 607914 Johenson, William, of Wrangle 1

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