names

74 rows where place_id = 588514

✎ 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
3594785 1865994 1865994 defendant Soule or Sonle John clerk 588514 588514 Soule or Sonle, John, of Burnham Westgate, clerk 0
3618320 1873359 1873359 defendant Grogon Robert husbandman 588514 588514 Grogon, Robert, of Burnham Westgate, husbandman 0
3664249 1914768 1914768 defendant Boston Robert butcher 588514 588514 Boston, Robert, of Burnham Westgate, butcher 0
3702167 1926935 1926935 defendant Chapman Edmund husbandman 588514 588514 Chapman, Edmund, of Burnham Westgate, husbandman 1
3876778 1982476 1982476 defendant Wood Ralph baker 588514 588514 Wood, Ralph, of Burnham Westgate, baker 1
3892149 1987629 1987629 defendant Woode Robert alias Ralph baker 588514 588514 Woode, Robert alias Ralph, of Burnham Westgate, baker 0
3892160 1987633 1987633 defendant Wode Ralph baker 588514 588514 Wode, Ralph, of Burnham Westgate, baker 0
3936521 2002540 2002540 plaintiff Martendale Edward merchant 588514 588514 Martendale, Edward, of Burnham Westgate, merchant 0
3936557 2002551 2002551 plaintiff Marytndale Edward merchant 588514 588514 Marytndale, Edward, of Burnham Westgate, merchant 0
3956389 2009297 2009297 plaintiff Newarke James mercer 588514 588514 Newarke, James, of Burnham Westgate, mercer 0
3966315 2012845 2012845 plaintiff Boston Richard, junior   588514 588514 Boston, Richard, junior, of Burnham Westgate 0
3966319 2012847 2012847 plaintiff Boston Richard butcher 588514 588514 Boston, Richard, of Burnham Westgate, butcher 0
3978161 2016942 2016942 plaintiff Martyndale Edward yeoman 588514 588514 Martyndale, Edward, of Burnham Westgate, yeoman 0
3978163 2016943 2016943 plaintiff Martyngdale Edward yeoman 588514 588514 Martyngdale, Edward, of Burnham Westgate, yeoman 0
3990985 2021539 2021539 plaintiff Boston Richard gent 588514 588514 Boston, Richard, of Burnham Westgate, butcher, gent 0
3998419 2024172 2024172 defendant Warde Richard husbandman 588514 588514 Warde, Richard, of Burnham Westgate, husbandman 0
3998420 2024172 2024172 defendant Newarke James mercer 588514 588514 Newarke, James, of Burnham Westgate, mercer 1
4004606 2026422 2026422 plaintiff Jenyson John   588514 588514 Jenyson, John, of Burnham Westgate 0
4016379 2030557 2030557 defendant Boston Richard gent 588514 588514 Boston, Richard, of Burnham Westgate, gent 0
4050514 2042611 2042611 defendant Jenyson John yeoman 588514 588514 Jenyson, John, of Burnham Westgate, yeoman 0
4060301 2046084 2046084 defendant Jenyson Thomas singleman 588514 588514 Jenyson, Thomas, of Burnham Westgate, yeoman, singleman 1
4081598 2053723 2053723 defendant Chymney Robert saddler 588514 588514 Chymney, Robert, of Burnham Westgate, saddler 0
4141972 2075361 2075361 defendant Jenyson Thomas gent 588514 588514 Jenyson, Thomas, of Burnham Westgate, gent 0
4157573 2080722 2080722 defendant Gade or Eade John draper 588514 588514 Gade or Eade, John, of Burnham Westgate, draper 1
4181579 2089040 2089040 defendant Sadsby George husbandman 588514 588514 Sadsby, George, of Burnham Westgate, husbandman 0
4205021 2097301 2097301 defendant Sadsbye George husbandman 588514 588514 Sadsbye, George, of Burnham Westgate, husbandman 0
4221938 2103168 2103168 defendant Jenyson John yeoman 588514 588514 Jenyson, John, of Burnham Westgate, yeoman 0
4221939 2103168 2103168 defendant Sadeslye or Sadesbye George yeoman 588514 588514 Sadeslye or Sadesbye, George, of Burnham Westgate, yeoman 1
4230966 2106330 2106330 defendant Boston Richard gent 588514 588514 Boston, Richard, of Burnham Westgate, gent 0
4230967 2106330 2106330 defendant Boston William gent 588514 588514 Boston, William, of Burnham Westgate, gent 1
4253598 2114195 2114195 defendant Boston Richard gent 588514 588514 Boston, Richard, of Burnham Westgate, gent 0
4279187 2122653 2122653 defendant Jenyson Thomas yeoman 588514 588514 Jenyson, Thomas, of Burnham Westgate, yeoman 0
4280999 2123255 2123255 defendant Cage John vintner 588514 588514 Cage, John, of Burnham Westgate, vintner 3
4336203 2142393 2142393 defendant Reade Thomas yeoman 588514 588514 Reade, Thomas, of Burnham Westgate, yeoman 0
4343294 2144929 2144929 defendant Barsham Thomas thatcher 588514 588514 Barsham, Thomas, of Burnham Westgate, thatcher 0
4354794 2148898 2148898 defendant Olyver Edward yeoman 588514 588514 Olyver, Edward, of Burnham Westgate, yeoman 1
4391036 2161620 2161620 defendant Allmer Thomas merchant 588514 588514 Allmer, Thomas, of Burnham Westgate, merchant 0
4391037 2161620 2161620 defendant Newarke Thomas mercer 588514 588514 Newarke, Thomas, of Burnham Westgate, yeoman, mercer 1
4399800 2164522 2164522 defendant Parnell Henry yeoman 588514 588514 Parnell, Henry, of Burnham Westgate, yeoman 1
4399803 2164523 2164523 defendant Parnell Henry yeoman 588514 588514 Parnell, Henry, of Burnham Westgate, yeoman 1
4405047 2166263 2166263 defendant Basham Thomas thatcher 588514 588514 Basham, Thomas, of Burnham Westgate, thatcher 1
4409078 2167641 2167641 defendant Almar Thomas merchant 588514 588514 Almar, Thomas, of Burnham Westgate, merchant 0
4661027 2249274 2249274 defendant Brede William husbamdman 588514 588514 Brede, William, of Burnham Westgate, husbamdman 2
4661029 2249274 2249274 defendant atte Grene John husbandman 588514 588514 atte Grene, John, of Burnham Westgate, husbandman 4
4992620 2354673 2354673 defendant Luwys William husbandman 588514 588514 Luwys, William, of Burnham Westgate, husbandman 1
4992621 2354673 2354673 defendant Smyth James smith 588514 588514 Smyth, James, of Burnham Westgate, smith 2
4992622 2354673 2354673 defendant Fuller Robert laborer 588514 588514 Fuller, Robert, of Burnham Westgate, laborer 3
4992624 2354673 2354673 defendant Wymark Richard laborer 588514 588514 Wymark, Richard, of Burnham Westgate, laborer 5
4995911 2355625 2355625 defendant Luwys William husbandman 588514 588514 Luwys, William, of Burnham Westgate, husbandman 1
4995912 2355625 2355625 defendant Smyth James smith 588514 588514 Smyth, James, of Burnham Westgate, smith 2
4995913 2355625 2355625 defendant Fuller Robert laborer 588514 588514 Fuller, Robert, of Burnham Westgate, laborer 3
4995915 2355625 2355625 defendant Wymark Richard laborer 588514 588514 Wymark, Richard, of Burnham Westgate, laborer 5
5125224 2393854 2393854 defendant Garlek John husbandman 588514 588514 Garlek, John, of Burnham Westgate, husbandman 4
5227824 2423753 2423753 defendant Skot Robert husbandman 588514 588514 Skot, Robert, of Burnham Westgate, husbandman 0
5283032 2440099 2440099 defendant Garlek John husbandman 588514 588514 Garlek, John, of Burnham Westgate, husbandman 0
5284978 2440629 2440629 defendant Antyngham William yeoman 588514 588514 Antyngham, William, of Burnham Westgate, yeoman 0
5286403 2441024 2441024 defendant Garleck John husbandman 588514 588514 Garleck, John, of Burnham Westgate, husbandman 2
5298722 2444601 2444601 defendant Garlok John yeoman 588514 588514 Garlok, John, of Burnham Westgate, yeoman 0
5298723 2444601 2444601 defendant Baxstere Henry yeoman 588514 588514 Baxstere, Henry, of Burnham Westgate, yeoman 1
5364952 2464710 2464710 defendant Heyward William, senior husbandman 588514 588514 Heyward, William, senior, of Burnham Westgate, husbandman 0
5364957 2464711 2464711 defendant Heyward William, senior hsubandman 588514 588514 Heyward, William, senior, of Burnham Westgate, hsubandman 0
5436207 2485768 2485768 defendant Heyward William husbandman 588514 588514 Heyward, William, of Burnham Westgate, husbandman 0
5459684 2492814 2492814 defendant jun   husbandman 588514 588514 _, jun, of Burnham Westgate, husbandman 0
5519982 2511086 2511086 defendant Grogon Robert yeoman 588514 588514 Grogon, Robert, of Burnham Westgate, yeoman 0
5534027 2515180 2515180 defendant Wyllyamson John shoemaker 588514 588514 Wyllyamson, John, of Burnham Westgate, shoemaker 0
5534028 2515180 2515180 defendant Heynes William husbandman 588514 588514 Heynes, William, of Burnham Westgate, husbandman 1
5540480 2517153 2517153 defendant Heynes alias Sherman William husbandman 588514 588514 Heynes alias Sherman, William, of Burnham Westgate, husbandman 0
5541928 2517595 2517595 defendant Lexham Margaret widow 588514 588514 Lexham, Margaret, of Burnham Westgate, widow 0
5547852 2519389 2519389 defendant Haynes William husbandman 588514 588514 Haynes, William, of Burnham Westgate, husbandman 0
5559620 2522773 2522773 defendant Janyson Thomas yeoman 588514 588514 Janyson, Thomas, of Burnham Westgate, yeoman 0
5561228 2523266 2523266 defendant Heynes William yeoman 588514 588514 Heynes, William, of Burnham Westgate, yeoman 0
5564310 2524174 2524174 defendant Haynes alias Sherman William husbandman 588514 588514 Haynes alias Sherman, William, of Burnham Westgate, husbandman 0
5606261 2536852 2536852 defendant Hoker William chaplain 588514 588514 Hoker, William, of Burnham Westgate, chaplain 0
5607691 2537305 2537305 defendant Mytton John clerk 588514 588514 Mytton, John, of Burnham Westgate, clerk 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);