names

140 rows where place_id = 606762

✎ 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
3666440 1915454 1915454 defendant Haynes Thomas husbandman 606762 606762 Haynes, Thomas, of Baston, husbandman 3
3666441 1915454 1915454 defendant Appultoft Cecil tailor 606762 606762 Appultoft, Cecil, of Baston, tailor 4
3669170 1916294 1916294 defendant Clerke John glover 606762 606762 Clerke, John, of Baston, glover 0
3673252 1917648 1917648 defendant Townend William husbandman 606762 606762 Townend, William, of Baston, husbandman 6
3673300 1917664 1917664 defendant Townehend William husbandman 606762 606762 Townehend, William, of Baston, husbandman 3
3673305 1917665 1917665 defendant Towneshende William husbandman 606762 606762 Towneshende, William, of Baston, husbandman 3
3679304 1919587 1919587 defendant Clerke John glover 606762 606762 Clerke, John, of Baston, glover 0
3683246 1920880 1920880 defendant Whight John husbandman 606762 606762 Whight, John, of Baston, husbandman 0
3689218 1922793 1922793 defendant Townend William husbandman 606762 606762 Townend, William, of Baston, husbandman 3
3694552 1924499 1924499 defendant Coope Thomas husbandman 606762 606762 Coope, Thomas, of Baston, husbandman 0
3717474 1931750 1931750 defendant Cope Thomas miller 606762 606762 Cope, Thomas, of Baston, miller 0
3733005 1936545 1936545 defendant Leman Richard husbandman 606762 606762 Leman, Richard, of Baston, husbandman 0
3747279 1941072 1941072 plaintiff Dykelyn Richard clerk 606762 606762 Dykelyn, Richard, of Baston, clerk 0
3755421 1943649 1943649 defendant Holand Thomas laborer 606762 606762 Holand, Thomas, of Baston, laborer 1
3763868 1946342 1946342 defendant Haynes Thomas husbandman 606762 606762 Haynes, Thomas, of Baston, husbandman 0
3763870 1946342 1946342 defendant Gregory Thomas husbandman 606762 606762 Gregory, Thomas, of Baston, husbandman 2
3763871 1946342 1946342 defendant Cope Thomas husbandman 606762 606762 Cope, Thomas, of Baston, husbandman 3
3771380 1948740 1948740 defendant Hoo Robert husbandman 606762 606762 Hoo, Robert, of Baston, husbandman 0
3771381 1948740 1948740 defendant Knyght John husbandman 606762 606762 Knyght, John, of Baston, husbandman 1
3775550 1950097 1950097 defendant Heynes Thomas husbandman 606762 606762 Heynes, Thomas, of Baston, husbandman 0
3777132 1950598 1950598 defendant Arnold John butcher 606762 606762 Arnold, John, of Baston, butcher 0
3789031 1954382 1954382 defendant Ednam John husbandman 606762 606762 Ednam, John, of Baston, husbandman 0
3789032 1954382 1954382 defendant Knyght Richard husbandman 606762 606762 Knyght, Richard, of Baston, husbandman 1
3789033 1954382 1954382 defendant Hoo Robert husbandman 606762 606762 Hoo, Robert, of Baston, husbandman 2
3789034 1954382 1954382 defendant Knyght John husbandman 606762 606762 Knyght, John, of Baston, husbandman 3
3795993 1956609 1956609 defendant Heynes Thomas, senior husbandman 606762 606762 Heynes, Thomas, senior, of Baston, husbandman 0
3805500 1959659 1959659 defendant Haynes Thomas, senior husbandman 606762 606762 Haynes, Thomas, senior, of Baston, husbandman 0
3805502 1959659 1959659 defendant Haynes Thomas, junior laborer 606762 606762 Haynes, Thomas, junior, of Baston, laborer 2
3805503 1959659 1959659 defendant Howe Robert husbandman 606762 606762 Howe, Robert, of Baston, husbandman 3
3805504 1959659 1959659 defendant Arnold John butcher 606762 606762 Arnold, John, of Baston, butcher 4
3806798 1960030 1960030 defendant Haynes Thomas, senior husbandman 606762 606762 Haynes, Thomas, senior, of Baston, husbandman 0
3806799 1960030 1960030 defendant Wallet Richard husbandman 606762 606762 Wallet, Richard, of Baston, husbandman 1
3806800 1960030 1960030 defendant Haynes Thomas, junior husbandman 606762 606762 Haynes, Thomas, junior, of Baston, husbandman 2
3822980 1965096 1965096 defendant Hameray Thomas husbandman 606762 606762 Hameray, Thomas, of Baston, husbandman 0
3824477 1965527 1965527 defendant Cope Thomas husbandman 606762 606762 Cope, Thomas, of Baston, husbandman 0
3829697 1967180 1967180 defendant Blabbe William husbandman 606762 606762 Blabbe, William, of Baston, husbandman 0
3829698 1967180 1967180 defendant Heynys Thomas husbandman 606762 606762 Heynys, Thomas, of Baston, husbandman 1
3848936 1973261 1973261 defendant Cope Thomas husbandman 606762 606762 Cope, Thomas, of Baston, husbandman 1
3855638 1975402 1975402 defendant Knyghte John husbandman 606762 606762 Knyghte, John, of Baston, husbandman 0
3855641 1975403 1975403 defendant Knyghte John husbandman 606762 606762 Knyghte, John, of Baston, husbandman 0
3861852 1977423 1977423 defendant Howe Robert husbandman 606762 606762 Howe, Robert, of Baston, husbandman 0
3866502 1979026 1979026 defendant Johnson Richard laborer 606762 606762 Johnson, Richard, of Baston, laborer 0
3866503 1979026 1979026 defendant Burnett Martin carpenter 606762 606762 Burnett, Martin, of Baston, carpenter 1
3876689 1982447 1982447 defendant Cope Thomas yeoman 606762 606762 Cope, Thomas, of Baston, yeoman 0
3900053 1990239 1990239 defendant Cope John joiner 606762 606762 Cope, John, of Baston, joiner 1
3924616 1998547 1998547 defendant Cowpe Thomas husbandman 606762 606762 Cowpe, Thomas, of Baston, husbandman 0
3924617 1998547 1998547 defendant Cowpe William husbandman 606762 606762 Cowpe, William, of Baston, husbandman 1
3930449 2000531 2000531 plaintiff Corry John   606762 606762 Corry, John, of Baston 0
4080672 2053399 2053399 defendant Norstok Thomas   606762 606762 Norstok, Thomas, of Baston, shepherd 0
4110590 2064047 2064047 defendant Garfurth Edward yeoman 606762 606762 Garfurth, Edward, of Baston, yeoman 1
4126162 2069647 2069647 defendant Preston Elizabeth widow 606762 606762 Preston, Elizabeth, of Baston, widow 4
4233776 2107338 2107338 defendant Wallett William chandler 606762 606762 Wallett, William, of Baston, chandler 0
4235906 2108132 2108132 defendant Plomer William butcher 606762 606762 Plomer, William, of Baston, butcher 0
4297169 2129089 2129089 defendant Dickenson Thomas yeoman 606762 606762 Dickenson, Thomas, of Baston, yeoman 1
4362722 2151725 2151725 defendant Plomer William butcher 606762 606762 Plomer, William, of Baston, butcher 0
4362723 2151725 2151725 defendant Gibson Edward tailor 606762 606762 Gibson, Edward, of Baston, tailor 1
4380524 2158147 2158147 defendant Plomer William butcher 606762 606762 Plomer, William, of Baston, butcher 1
4442069 2182444 2182444 plaintiff Brian Robert   606762 606762 Brian, Robert, of Baston 0
4445600 2183577 2183577 defendant Mampton John   606762 606762 Mampton, John, of Baston 0
4458966 2187848 2187848 defendant Fessaunt William   606762 606762 Fessaunt, William, of Baston 1
4459209 2187925 2187925 defendant Fessaunt William   606762 606762 Fessaunt, William, of Baston 1
4488848 2197229 2197229 defendant Penreth William clerk 606762 606762 Penreth, William, of Baston, clerk 0
4506953 2202647 2202647 defendant Penreth William   606762 606762 Penreth, William, of Baston 0
4506956 2202649 2202649 plaintiff Ussher Richard   606762 606762 Ussher, Richard, of Baston 0
4506957 2202649 2202649 plaintiff Beby John de chaplain 606762 606762 Beby, John de, of Baston, chaplain 1
4506958 2202649 2202649 defendant Penreth William   606762 606762 Penreth, William, of Baston 0
4521038 2206916 2206916 defendant Pedder John   606762 606762 Pedder, John, of Baston 0
4541035 2213104 2213104 defendant Barbour Clement   606762 606762 Barbour, Clement, of Baston 0
4550154 2215990 2215990 defendant Manham Geoffrey   606762 606762 Manham, Geoffrey, of Baston 0
4561550 2219549 2219549 plaintiff Peddar John   606762 606762 Peddar, John, of Baston 0
4562105 2219712 2219712 defendant Howell Hugh   606762 606762 Howell, Hugh, of Baston 0
4609906 2234194 2234194 defendant Wymark John   606762 606762 Wymark, John, of Baston, brasyere or brass worker 0
4622368 2237975 2237975 defendant Wytham Robert   606762 606762 Wytham, Robert, of Baston 0
4627434 2239512 2239512 defendant Wytham Robert   606762 606762 Wytham, Robert, of Baston 0
4650121 2246054 2246054 defendant Manehan Geoffrey   606762 606762 Manehan, Geoffrey, of Baston 0
4650122 2246054 2246054 defendant Bevyrle Hugh   606762 606762 Bevyrle, Hugh, of Baston 1
4668624 2255898 2255898 defendant Mocaunt William milner 606762 606762 Mocaunt, William, of Baston, milner 0
4670027 2256325 2256325 defendant Webster John weaver 606762 606762 Webster, John, of Baston, weaver 0
4673321 2257293 2257293 defendant Welmay John husbandman 606762 606762 Welmay, John, of Baston, husbandman 1
4673323 2257294 2257294 defendant Hare William husbandman 606762 606762 Hare, William, of Baston, husbandman 0
4673324 2257294 2257294 defendant Claypool John husbandman 606762 606762 Claypool, John, of Baston, husbandman 1
4688288 2261905 2261905 defendant Sele Thomas husbandman 606762 606762 Sele, Thomas, of Baston, husbandman 0
4737835 2276937 2276937 defendant Fenne William de butcher 606762 606762 Fenne, William de, of Baston, butcher 1
4742483 2278302 2278302 defendant Maughan Geoffrey laborer 606762 606762 Maughan, Geoffrey, of Baston, laborer 0
4775937 2288477 2288477 defendant Moraunt William miller or muletier 606762 606762 Moraunt, William, of Baston, miller or muletier 0
4781968 2290364 2290364 defendant Morant William miller 606762 606762 Morant, William, of Baston, miller 0
4811201 2299613 2299613 defendant Wryght John husbandman 606762 606762 Wryght, John, of Baston, husbandman 0
4829430 2305246 2305246 plaintiff Barnetby John   606762 606762 Barnetby, John, of Baston on Humber 0
4832219 2306109 2306109 defendant Gylberd Robert husbandman 606762 606762 Gylberd, Robert, of Baston, husbandman 1
4838366 2307914 2307914 defendant Pampylyon Henry husbandman 606762 606762 Pampylyon, Henry, of Baston, husbandman 0
4856709 2313474 2313474 defendant Hare William husbandman 606762 606762 Hare, William, of Baston, husbandman 0
4856710 2313474 2313474 defendant Normanton Robert husbandman 606762 606762 Normanton, Robert, of Baston, husbandman 1
4858197 2313933 2313933 defendant Smyth John laborer 606762 606762 Smyth, John, of Baston, laborer 0
4858198 2313933 2313933 defendant Andr- Robert laborer 606762 606762 Andr-, Robert, of Baston, laborer 1
4860551 2314656 2314656 defendant Moraunt William miller 606762 606762 Moraunt, William, of Baston, miller 0
4878841 2320317 2320317 defendant Wryght John husbandman 606762 606762 Wryght, John, of Baston, husbandman 2
4878842 2320317 2320317 defendant Glover Robert husbandman 606762 606762 Glover, Robert, of Baston, husbandman 3
4878843 2320317 2320317 defendant Malle John husbandman 606762 606762 Malle, John, of Baston, husbandman 4
4884705 2322124 2322124 defendant Wryght John husbandman 606762 606762 Wryght, John, of Baston, husbandman 15
4892806 2324479 2324479 defendant Wryght Geoffrey husbandman 606762 606762 Wryght, Geoffrey, of Baston, husbandman 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);