names

68 rows where place_id = 599982

✎ 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
3639189 1907071 1907071 defendant Holand Thomas gent 599982 599982 Holand, Thomas, of Fulbek, gent 0
3665194 1915067 1915067 defendant Sutton William   599982 599982 Sutton, William, of Fulbek, free mason 0
4526114 2208461 2208461 plaintiff Kirkeby John de   599982 599982 Kirkeby, John de, of Fulbek 0
4535363 2211331 2211331 defendant Alverton William weaver 599982 599982 Alverton, William, of Fulbek, weaver 0
4588358 2227750 2227750 defendant Warde Roger chaplain 599982 599982 Warde, Roger, of Fulbek, chaplain 0
4588359 2227750 2227750 defendant Warde Richard   599982 599982 Warde, Richard, of Fulbek 1
4595632 2229899 2229899 defendant Midelton Ralph   599982 599982 Midelton, Ralph, of Fulbek 0
4633418 2241306 2241306 defendant Moreys Thomas   599982 599982 Moreys, Thomas, of Fulbek 1
4654324 2247226 2247226 defendant Dekyn Robert husbandman 599982 599982 Dekyn, Robert, of Fulbek, husbandman 7
4693793 2263561 2263561 defendant Mores Thomas husbandman 599982 599982 Mores, Thomas, of fulbek, husbandman 0
4751242 2280839 2280839 defendant Ballum John husbandman 599982 599982 Ballum, John, of Fulbek, formerly of Norton Dysneye, husbandman 0
4753662 2281518 2281518 defendant Milthorp John husbandman 599982 599982 Milthorp, John, of fulbek, husbandman 0
4790425 2293092 2293092 defendant Warde Elias merchant 599982 599982 Warde, Elias, of Fulbek, merchant 0
4790429 2293094 2293094 defendant Warde Elias woolman 599982 599982 Warde, Elias, of Fulbek, woolman 0
4830285 2305510 2305510 defendant Kemp John husbandman 599982 599982 Kemp, John, of Fulbek, husbandman 1
4845550 2310116 2310116 defendant Eseby John   599982 599982 Eseby, John, of Fulbek, parson 11
4846760 2310493 2310493 defendant Coucher John husbandman 599982 599982 Coucher, John, of Fulbek, husbandman 3
4848653 2311049 2311049 defendant Esby John clerk 599982 599982 Esby, John, of Fulbek, clerk 0
4854134 2312703 2312703 defendant Alforton John weaver 599982 599982 Alforton, John, of Fulbek, weaver 0
4856417 2313383 2313383 defendant Honyngton John husbandman 599982 599982 Honyngton, John, of Fulbek, husbandman 0
4874237 2318887 2318887 defendant Alverton John husbandman 599982 599982 Alverton, John, of Fulbek, husbandman 0
4874238 2318887 2318887 defendant Milthorp John husbandman 599982 599982 Milthorp, John, of Fulbek, husbandman 1
4874239 2318887 2318887 defendant Douke John husbandman 599982 599982 Douke, John, of Fulbek, husbandman 2
4874240 2318887 2318887 defendant Lamme Thomas husbandman 599982 599982 Lamme, Thomas, of Fulbek, husbandman 3
4875946 2319437 2319437 defendant Ledenham John husbandman 599982 599982 Ledenham, John, of Fulbek, husbandman 0
4875947 2319437 2319437 defendant Alverton John weaver 599982 599982 Alverton, John, of Fulbek, weaver 1
4880094 2320683 2320683 defendant Pye John husbandman 599982 599982 Pye, John, of Fulbek, husbandman 0
4931649 2336287 2336287 defendant Pye John husbandman 599982 599982 Pye, John, of Fulbek, husbandman 0
4940975 2339202 2339202 defendant Alverton John yeoman 599982 599982 Alverton, John, of Fulbek, yeoman 0
4947354 2341167 2341167 defendant Gaywod William clerk 599982 599982 Gaywod, William, of Fulbek, clerk 0
4948021 2341363 2341363 defendant Alverton John   599982 599982 Alverton, John, of Fulbek, bailiff 4
4948035 2341365 2341365 defendant Alverton John   599982 599982 Alverton, John, of Fulbek, bailiff 4
4975355 2349589 2349589 defendant Mylthorp John weaver 599982 599982 Mylthorp, John, of Fulbek, weaver 0
4983464 2351966 2351966 defendant Donke or Douke John husbandman 599982 599982 Donke or Douke, John, of Fulbek, husbandman 0
4988544 2353529 2353529 defendant Ward Ellis merchant 599982 599982 Ward, Ellis, of Fulbek, merchant 0
4994568 2355238 2355238 defendant Douke or Donke John husbandman 599982 599982 Douke or Donke, John, of Fulbek, husbandman 1
5015687 2361473 2361473 defendant Ward Elias merchant 599982 599982 Ward, Elias, of Fulbek, merchant 0
5027897 2365038 2365038 defendant Douke or Donke John husbandman 599982 599982 Douke or Donke, John, of Fulbek, husbandman 5
5036615 2367576 2367576 defendant Honyngton John, junior husbandman 599982 599982 Honyngton, John, junior, of Fulbek, husbandman 0
5046206 2370495 2370495 defendant Eseby John clerk 599982 599982 Eseby, John, of Fulbek, clerk 1
5046209 2370496 2370496 defendant Dukke John husbandman 599982 599982 Dukke, John, of Fulbek, husbandman 1
5064062 2375785 2375785 defendant Donke John yeoman 599982 599982 Donke, John, of Fulbek, yeoman 1
5100864 2386668 2386668 defendant Oseby John clerk 599982 599982 Oseby, John, of Fulbek, clerk 0
5100865 2386668 2386668 defendant Skyrlowe William husbandman 599982 599982 Skyrlowe, William, of Fulbek, husbandman 1
5100866 2386668 2386668 defendant Mathew Thomas husbandman 599982 599982 Mathew, Thomas, of Fulbek, husbandman 2
5104931 2387879 2387879 defendant Freman Thomas husbandman 599982 599982 Freman, Thomas, of Fulbek, husbandman 0
5191119 2413142 2413142 defendant Morys William husbandman 599982 599982 Morys, William, of Fulbek, husbandman 1
5199176 2415511 2415511 defendant Gander John   599982 599982 Gander, John, of Fulbek 1
5199177 2415511 2415511 defendant Lam John   599982 599982 Lam, John, of Fulbek 2
5207218 2417852 2417852 defendant Morys William husbandman 599982 599982 Morys, William, of Fulbek, husbandman 1
5238145 2426744 2426744 defendant Eseby John clerk 599982 599982 Eseby, John, of Fulbek, clerk 2
5255465 2431831 2431831 defendant Handeley or Haudeley John yeoman 599982 599982 Handeley or Haudeley, John, of Fulbek, yeoman 2
5267428 2435575 2435575 defendant Alverton or Alnerton William yeoman 599982 599982 Alverton or Alnerton, William, of Fulbek, yeoman 7
5267430 2435575 2435575 defendant Mares William   599982 599982 Mares, William, of Fulbek, franklin 9
5296392 2443935 2443935 defendant Alverton William yeoman 599982 599982 Alverton, William, of Fulbek, yeoman 0
5296393 2443935 2443935 defendant Moreys William   599982 599982 Moreys, William, of Fulbek, franklin 1
5297906 2444396 2444396 defendant Mercer Robert husbandman 599982 599982 Mercer, Robert, of Fulbek, husbandman 0
5297908 2444396 2444396 defendant Honyngton Alice widow 599982 599982 Honyngton, Alice, of Fulbek, widow 2
5297909 2444396 2444396 defendant Honyngton William husbandman 599982 599982 Honyngton, William, of Fulbek, husbandman 3
5313204 2448983 2448983 defendant Cubbyng Simon husbandman 599982 599982 Cubbyng, Simon, of Fulbek, husbandman 0
5313205 2448983 2448983 defendant Cobbyng William husbandman 599982 599982 Cobbyng, William, of Fulbek, husbandman 1
5331713 2454572 2454572 defendant Farnesfeld William husbandman 599982 599982 Farnesfeld, William, of Fulbek, husbandman 0
5429656 2483807 2483807 defendant Farneffeld Richard husbandman 599982 599982 Farneffeld, Richard, of Fulbek, husbandman 0
5485730 2500629 2500629 defendant Alybon Thomas yeoman 599982 599982 Alybon, Thomas, of Fulbek, yeoman 4
5514262 2509308 2509308 defendant Porter Ralph yeoman 599982 599982 Porter, Ralph, of Fulbek, yeoman 1
5552144 2520669 2520669 defendant Messynden Edward gent 599982 599982 Messynden, Edward, of Fulbek, gent 2
5578010 2528191 2528191 defendant Beked Richard laborer 599982 599982 Beked, Richard, of Fulbek, laborer 0
5578011 2528191 2528191 defendant Harryson William laborer 599982 599982 Harryson, William, of Fulbek, laborer 1

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