names

99 rows where place_id = 592619

✎ 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
3608270 1870243 1870243 defendant Cane or Cave Roger husbandman 592619 592619 Cane or Cave, Roger, of South Leverton, husbandman 0
3609135 1870514 1870514 defendant Edynstowe Thomas husbandman 592619 592619 Edynstowe, Thomas, of South Leverton, husbandman 0
3612260 1871469 1871469 defendant Stephynson Roger yeoman 592619 592619 Stephynson, Roger, of South Leverton, yeoman 2
3612519 1871546 1871546 defendant Stephynson Roger husbandman 592619 592619 Stephynson, Roger, of South Leverton, husbandman 3
3671252 1916984 1916984 defendant Wylkynson Edmund husbandman 592619 592619 Wylkynson, Edmund, of South Leverton, husbandman 0
3683717 1921041 1921041 defendant More Thomas husbandman 592619 592619 More, Thomas, of South Leverton, husbandman 1
3703813 1927471 1927471 defendant Kempe Thomas yeoman 592619 592619 Kempe, Thomas, of South Leverton, yeoman 2
3721427 1933009 1933009 defendant Nevyle Alexander esq 592619 592619 Nevyle, Alexander, of South Leverton, esq 0
3721430 1933010 1933010 defendant Nevyle Alexander esq 592619 592619 Nevyle, Alexander, of South Leverton, esq 0
3721433 1933011 1933011 defendant Nevyle Alexander esq 592619 592619 Nevyle, Alexander, of South Leverton, esq 0
3764191 1946451 1946451 defendant Edynstowe John clerk 592619 592619 Edynstowe, John, of South Leverton, husbandman, sonof Edynstowe, Thomas, clerk 0
3774632 1949793 1949793 defendant Nevell Thomas gent 592619 592619 Nevell, Thomas, of South Leverton, gent 0
3806687 1959989 1959989 defendant (not given) Robert vicar of Foster 592619 592619 Foster, Robert, of South Leverton, vicar of Sutterton 3
3915561 1995573 1995573 defendant Botheby Adam husbandman 592619 592619 Botheby, Adam, of South Leverton, husbandman 0
3954069 2008495 2008495 defendant Nevell Alexander esq 592619 592619 Nevell, Alexander, of South Leverton, esq 0
3965325 2012490 2012490 defendant Jackson Robert husbandman 592619 592619 Jackson, Robert, of South Leverton, husbandman 0
3965326 2012490 2012490 defendant Keyworth Christopher husbandman 592619 592619 Keyworth, Christopher, of South Leverton, husbandman 1
3965327 2012490 2012490 defendant Darley Leonard husbandman 592619 592619 Darley, Leonard, of South Leverton, husbandman 2
3965328 2012490 2012490 defendant Monke Hugh husbandman 592619 592619 Monke, Hugh, of South Leverton, husbandman 3
3976417 2016328 2016328 defendant Ward Thomas laborer 592619 592619 Ward, Thomas, of South Leverton, laborer 1
4017180 2030848 2030848 defendant Power Francis gent 592619 592619 Power, Francis, of South Leverton, gent 0
4046762 2041296 2041296 defendant Hynde Thomas husbandman 592619 592619 Hynde, Thomas, of South Leverton, husbandman 0
4086164 2055324 2055324 defendant Carryar George husbandman 592619 592619 Carryar, George, of South Leverton, husbandman 0
4111422 2064332 2064332 defendant Darley Leonard yeoman 592619 592619 Darley, Leonard, of South Leverton, yeoman 0
4111423 2064332 2064332 defendant Cave Anthony yeoman 592619 592619 Cave, Anthony, of South Leverton, yeoman 1
4148076 2077457 2077457 defendant Cave Alexander   592619 592619 Cave, Alexander, of South Leverton, yeoman, his son 1
4217117 2101480 2101480 defendant Cave George yeoman 592619 592619 Cave, George, of South Leverton, yeoman 0
4410840 2168215 2168215 defendant Hynde Thomas laborer 592619 592619 Hynde, Thomas, of South Leverton, laborer 0
4473288 2192305 2192305 defendant Frankys William   592619 592619 Frankys, William, of South Leverton 0
4473289 2192305 2192305 defendant Cane Roger   592619 592619 Cane, Roger, of South Leverton 1
4473290 2192305 2192305 defendant Mekesburgh Robert   592619 592619 Mekesburgh, Robert, of South Leverton 2
4473292 2192306 2192306 defendant Frankys William   592619 592619 Frankys, William, of South Leverton 0
4473293 2192306 2192306 defendant Cane Roger   592619 592619 Cane, Roger, of South Leverton 1
4473294 2192306 2192306 defendant Mekesburgh Robert   592619 592619 Mekesburgh, Robert, of South Leverton 2
4474434 2192662 2192662 plaintiff Dolant Cecily   592619 592619 Dolant, Cecily, of South Leverton 0
4474435 2192662 2192662 defendant Adcok Richard   592619 592619 Adcok, Richard, of South Leverton 0
4527359 2208836 2208836 defendant Tomlynson Robert   592619 592619 Tomlynson, Robert, of South Leverton 0
4544242 2214116 2214116 defendant Jankynson John   592619 592619 Jankynson, John, of South Leverton 0
4573710 2223294 2223294 defendant Cave Roger   592619 592619 Cave, Roger, of South Leverton 0
4589689 2228143 2228143 defendant Lincoln Robert   592619 592619 Lincoln, Robert, of South Leverton 2
4589690 2228143 2228143 defendant Bocher Ralph   592619 592619 Bocher, Ralph, of South Leverton 3
4642455 2243917 2243917 defendant Lord Robert   592619 592619 Lord, Robert, of South Leverton 0
4642458 2243917 2243917 defendant Thomlynson Robert   592619 592619 Thomlynson, Robert, of South Leverton 3
4645471 2244745 2244745 plaintiff Nevyll William   592619 592619 Nevyll, William, of South Leverton 0
4645479 2244745 2244745 defendant Pygot William   592619 592619 Pygot, William, of South Leverton 7
4674379 2257596 2257596 defendant Halton William chaplain 592619 592619 Halton, William, of South Leverton, chaplain 1
4681805 2259920 2259920 defendant Shawe John husbandman 592619 592619 Shawe, John, of South Leverton, husbandman 0
4729767 2274516 2274516 defendant Schawe John yeoman 592619 592619 Schawe, John, of South Leverton, yeoman 0
4729768 2274516 2274516 defendant Doland William husbandman 592619 592619 Doland, William, of South Leverton, husbandman 1
4743479 2278622 2278622 defendant Shagh John yeoman 592619 592619 Shagh, John, of South Leverton, yeoman 0
4745925 2279312 2279312 defendant Lorde Robert husbandman 592619 592619 Lorde, Robert, of South Leverton, husbandman 2
4745926 2279312 2279312 defendant Hamlyn Hugh laborer 592619 592619 Hamlyn, Hugh, of South Leverton, laborer 3
4745929 2279313 2279313 defendant Lorde Robert husbandman 592619 592619 Lorde, Robert, of South Leverton, husbandman 1
4745930 2279313 2279313 defendant Hamlyn Hugh laborer 592619 592619 Hamlyn, Hugh, of South Leverton, laborer 2
4774807 2288113 2288113 defendant Lord Robert husbandman 592619 592619 Lord, Robert, of South Leverton, husbandman 2
4815209 2300868 2300868 defendant Lord Robert husbandman 592619 592619 Lord, Robert, of South Leverton, husbandman 0
4841744 2308954 2308954 defendant Lorde Robert husbandman 592619 592619 Lorde, Robert, of South Leverton, husbandman 3
4853281 2312441 2312441 defendant Hopkynson John chaplain 592619 592619 Hopkynson, John, of South Leverton, chaplain 1
4853284 2312441 2312441 defendant Jonson Robert husbandman 592619 592619 Jonson, Robert, of South Leverton, husbandman 4
4871247 2317981 2317981 defendant Jonesson Robert husbandman 592619 592619 Jonesson, Robert, of South Leverton, husbandman 2
4872142 2318246 2318246 plaintiff Nevyll William   592619 592619 Nevyll, William, of South Leverton 0
4974240 2349258 2349258 defendant Lord Robert, senior husbandman 592619 592619 Lord, Robert, senior, of South Leverton, husbandman 0
5010791 2360008 2360008 defendant Horne William husbandman 592619 592619 Horne, William, of South Leverton, husbandman 7
5021293 2363131 2363131 defendant Strechley Robert husbandman 592619 592619 Strechley, Robert, of South Leverton, husbandman 0
5028952 2365337 2365337 defendant Drayton John husbandman 592619 592619 Drayton, John, of South Leverton, husbandman 0
5028953 2365337 2365337 defendant Lorde Robert husbandman 592619 592619 Lorde, Robert, of South Leverton, husbandman 1
5028954 2365337 2365337 defendant Edenstowe John gent 592619 592619 Edenstowe, John, of South Leverton, gent 2
5031130 2365980 2365980 defendant Lorde Robert   592619 592619 Lorde, Robert, of South Leverton, ploughwright 0
5066826 2376607 2376607 defendant Edynstowe Thomas gent 592619 592619 Edynstowe, Thomas, of South Leverton, gent 1
5079235 2380283 2380283 defendant Nevile Thomas gent 592619 592619 Nevile, Thomas, of South Leverton, gent 0
5079237 2380284 2380284 defendant Nevile Thomas gent 592619 592619 Nevile, Thomas, of South Leverton,gent 0
5091510 2383908 2383908 defendant Drayton John husbandman 592619 592619 Drayton, John, of South Leverton, husbandman 2
5091511 2383908 2383908 defendant Alyce Peter husbandman 592619 592619 Alyce, Peter, of South Leverton, husbandman 3
5115819 2391052 2391052 defendant Casse John husbandman 592619 592619 Casse, John, of South Leverton, husbandman 0
5115820 2391052 2391052 defendant Pigot Hugh husbandman 592619 592619 Pigot, Hugh, of South Leverton, husbandman 1
5156476 2403049 2403049 defendant Clerke Robert husbandman 592619 592619 Clerke, Robert, of South Leverton, husbandman 3
5172671 2407734 2407734 defendant Clerke Robert husbandman 592619 592619 Clerke, Robert, of South Leverton, husbandman 3
5172672 2407734 2407734 defendant Keworth John husbandman 592619 592619 Keworth, John, of South Leverton, son of William, husbandman 4
5192342 2413497 2413497 defendant Clerke Robert husbandman 592619 592619 Clerke, Robert, of South Leverton, husbandman 3
5192343 2413497 2413497 defendant Keworth John husbandman 592619 592619 Keworth, John, of South Leverton, son of William, husbandman 4
5223063 2422459 2422459 defendant Case John husbandman 592619 592619 Case, John, of South Leverton, husbandman 2
5223094 2422463 2422463 defendant Smyth Edmund smith 592619 592619 Smyth, Edmund, of South Leverton, smith 0
5250436 2430245 2430245 defendant Strecheley Robert husbandman 592619 592619 Strecheley, Robert, of South Leverton, husbandman 1
5341506 2457532 2457532 defendant Stevynson Roger husbandman 592619 592619 Stevynson, Roger, of South Leverton, husbandman 11
5341507 2457532 2457532 defendant Eymer William husbandman 592619 592619 Eymer, William, of South Leverton, husbandman 12
5388516 2471768 2471768 defendant Cave or Cane Roger yeoman 592619 592619 Cave or Cane, Roger, of South Leverton, yeoman 1
5470940 2496239 2496239 defendant Cane Roger yeoman 592619 592619 Cane, Roger, of South Leverton, yeoman 1
5498674 2504549 2504549 defendant Tankerley John gent 592619 592619 Tankerley, John, of South Leverton, gent 0
5513165 2508966 2508966 defendant Okedeyn Tristram yeoman 592619 592619 Okedeyn, Tristram, of South Leverton, yeoman 0
5513166 2508966 2508966 defendant Okedeyn John chaplain 592619 592619 Okedeyn, John, of South Leverton, chaplain 1
5513168 2508967 2508967 defendant Okedeyn Tristram yeoman 592619 592619 Okedeyn, Tristram, of South Leverton, yeoman 0
5513169 2508967 2508967 defendant Okedeyn John chaplain 592619 592619 Okedeyn, John, of South Leverton, chaplain 1
5513171 2508968 2508968 defendant Okewyn Tristen yeoman 592619 592619 Okewyn, Tristen, of South Leverton, yeoman 0
5513172 2508968 2508968 defendant Okewyn John chaplain 592619 592619 Okewyn, John, of South Leverton, chaplain 1
5520761 2511314 2511314 defendant Drayton Robert yeoman 592619 592619 Drayton, Robert, of South Leverton, yeoman 3
5528743 2513509 2513509 defendant Stevenson Roger yeoman 592619 592619 Stevenson, Roger, of South Leverton, yeoman 0
5551181 2520376 2520376 defendant Stevenson Roger yeoman 592619 592619 Stevenson, Roger, of South Leverton, yeoman 0
5608181 2537461 2537461 defendant Nevell Alexander gent 592619 592619 Nevell, Alexander, of South Leverton, gent 0
5627035 2552424 2552424 plaintiff Nevyll William   592619 592619 Nevyll, William, of South Leverton 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);