names

54 rows where place_id = 612342

✎ 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
3692758 1923924 1923924 defendant Kitson John chaplain 612342 612342 Kitson, John, of Skipton, chaplain 0
3698553 1925766 1925766 defendant Atkynson Reginald clothman 612342 612342 Atkynson, Reginald, of Skipton, clothman 1
3698554 1925766 1925766 defendant Jenkynson John husbandman 612342 612342 Jenkynson, John, of Skipton, husbandman 2
3698555 1925766 1925766 defendant Batterisby Edmund shoemaker 612342 612342 Batterisby, Edmund, of Skipton, shoemaker 3
3698556 1925766 1925766 defendant Haldworth John mercer 612342 612342 Haldworth, John, of Skipton, mercer 4
3878289 1982986 1982986 plaintiff Lambart John, senior   612342 612342 Lambart, John, senior, of Skipton 0
3950238 2007170 2007170 defendant Jollye Thomas (legal representative) 612342 612342 Jollye, Thomas, of Skipton, administrator of 0
3950239 2007170 2007170 defendant Jollye Ingelram gent 612342 612342 Jollye, Ingelram, of Skipton, gent 1
4003495 2026011 2026011 plaintiff Houlebye or Houltbye Nicholas   612342 612342 Houlebye or Houltbye, Nicholas, of Skipton 0
4017176 2030847 2030847 plaintiff Taylor Margaret   612342 612342 Margaret his wife, alias Margaret Hewett, of Skipton 1
4017179 2030848 2030848 plaintiff Taylor Margaret   612342 612342 Margaret his wife, alias Margaret Hewett, of Skipton 1
4260166 2116364 2116364 defendant Wetherhead John drover 612342 612342 Wetherhead, John, of Skipton, drover 1
4270564 2119734 2119734 defendant Apleton John weaver 612342 612342 Apleton, John, of Skipton, weaver 2
4271558 2120069 2120069 defendant Wetherhead John drover 612342 612342 Wetherhead, John, of Skipton, drover 1
4275872 2121509 2121509 defendant Nicholson John yeoman 612342 612342 Nicholson, John, of Skipton, yeoman 0
4275874 2121510 2121510 defendant Nicholson John yeoman 612342 612342 Nicholson, John, of Skipton, yeoman 0
4275875 2121510 2121510 defendant Nicholson Christopher yeoman 612342 612342 Nicholson, Christopher, of Skipton, yeoman 1
4275877 2121511 2121511 defendant Nicholson John yeoman 612342 612342 Nicholson, John, of Skipton, yeoman 0
4275878 2121511 2121511 defendant Nicholson Christopher yeoman 612342 612342 Nicholson, Christopher, of Skipton, yeoman 1
4275879 2121511 2121511 defendant Wesse George laborer 612342 612342 Wesse, George, of Skipton, laborer 2
4275881 2121512 2121512 defendant Whitelock George husbandman 612342 612342 Whitelock, George, of Skipton, husbandman 0
4312245 2134419 2134419 defendant Nicholson John   612342 612342 Nicholson, John, of Skipton yeoman 0
4316444 2135869 2135869 defendant Grene William butcher 612342 612342 Grene, William, of Skipton, butcher 0
4316445 2135869 2135869 defendant Hardye William laborer 612342 612342 Hardye, William, of Skipton, laborer 1
4316446 2135869 2135869 defendant Smithe William shoemaker 612342 612342 Smithe, William, of Skipton, shoemaker 2
4316447 2135869 2135869 defendant Benson Barnard laborer 612342 612342 Benson, Barnard, of Skipton, laborer 3
4353430 2148422 2148422 defendant Gudridge Alexander singleman 612342 612342 Gudridge, Alexander, of Skipton, yeoman, singleman 1
4391191 2161670 2161670 defendant Nesfeild Victor gent 612342 612342 Nesfeild, Victor, of Skipton, gent 3
4394235 2162673 2162673 defendant Kitchinge Robert yeoman 612342 612342 Kitchinge, Robert, of Skipton, yeoman 0
4398472 2164070 2164070 defendant Knype Michael tailor 612342 612342 Knype, Michael, of Skipton, tailor 0
4398475 2164070 2164070 defendant Hustler John yeoman 612342 612342 Hustler, John, of Skipton, yeoman 3
4404228 2165985 2165985 defendant Grame or Graine Mathew husbandman 612342 612342 Grame or Graine, Mathew, of Skipton, husbandman 0
4404229 2165985 2165985 defendant Wardman John husbandman 612342 612342 Wardman, John, of Skipton, husbandman 1
4408130 2167289 2167289 defendant Wardman John yeoman 612342 612342 Wardman, John, of Skipton, yeoman 0
4481752 2194994 2194994 defendant Chapman Peter   612342 612342 Chapman, Peter, of Skipton 0
4646428 2245019 2245019 defendant Kemr_ Robert   612342 612342 Kemr_, Robert, of Skipton 1
4717307 2270745 2270745 defendant Lame Adam gent 612342 612342 Lame, Adam, of Skipton, gent 0
4726202 2273477 2273477 defendant Cravyn John husbandman 612342 612342 Cravyn, John, of Skipton, husbandman 3
4755697 2282164 2282164 defendant Morys William mercer 612342 612342 Morys, William, of Skipton, mercer 2
4835263 2307029 2307029 plaintiff del Garth William   612342 612342 del Garth, William, of Skipton 0
4846421 2310387 2310387 defendant Holme John, sen husbandman 612342 612342 Holme, John, sen, of Skipton, husbandman 1
4846423 2310387 2310387 defendant Medilton Richard laborer 612342 612342 Medilton, Richard, of Skipton, laborer 3
4862634 2315300 2315300 plaintiff del Garth William   612342 612342 del Garth, William, of Skipton 0
4862639 2315301 2315301 plaintiff del Garth William   612342 612342 del Garth, William, of Skipton 0
4933832 2336962 2336962 defendant Caterall John gent 612342 612342 Caterall, John, of Skipton, gent 0
4938629 2338465 2338465 defendant Carlyll Henry laborer 612342 612342 Carlyll, Henry, of Skipton, laborer 1
5197778 2415091 2415091 defendant Jenkynson Richard yeoman 612342 612342 Jenkynson, Richard, of Skipton, yeoman 3
5540801 2517253 2517253 defendant Smyth Alice widow 612342 612342 Smyth, Alice, of Skipton, widow 0
5583773 2529999 2529999 defendant Malhom Robert chapman 612342 612342 Malhom, Robert, of Skipton, chapman 2
5583784 2530003 2530003 defendant Malhom Robert chapman 612342 612342 Malhom, Robert, of Skipton, chapman 3
5624094 2551484 2551484 defendant Watson John husbandman 612342 612342 Watson, John, of Skipton, husbandman 0
5624095 2551484 2551484 defendant Ravensholme Margery laborer 612342 612342 Ravensholme, Margery, of Skipton, laborer 1
5624096 2551484 2551484 defendant Lyngard Isolda laborer 612342 612342 Lyngard, Isolda, of Skipton, laborer 2
5624097 2551484 2551484 defendant Brabaner Alice laborer 612342 612342 Brabaner, Alice, of Skipton, laborer 3

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