names

67 rows where place_id = 593823

✎ 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
3613476 1871862 1871862 defendant Rednale Walter husbandman 593823 593823 Rednale, Walter, of Bernyngham, husbandman 1
3672265 1917324 1917324 defendant Wodes John husbandman 593823 593823 Wodes, John, of Bernyngham, husbandman 3
3731336 1936022 1936022 defendant Perken Thomas yeoman 593823 593823 Perken, Thomas, of Bernyngham, yeoman 0
3745885 1940618 1940618 defendant Parken Thomas husbandman 593823 593823 Parken, Thomas, of Bernyngham, husbandman 1
4461845 2188770 2188770 plaintiff Muryel John   593823 593823 Muryel, John, of Bernyngham, parson 1
4507090 2202686 2202686 plaintiff Vynter John   593823 593823 Vynter, John, of Bernyngham 0
4507339 2202759 2202759 defendant Cook John   593823 593823 Cook, John, of Bernyngham 2
4547185 2215052 2215052 defendant Stansfeld John   593823 593823 Stansfeld, John, of Bernyngham 0
4571153 2222548 2222548 defendant Flaye John   593823 593823 Flaye, John, of Bernyngham 0
4622488 2238014 2238014 defendant Jakson Robert   593823 593823 Jakson, Robert, of Bernyngham 1
4638722 2242855 2242855 plaintiff Chapman Roger   593823 593823 Chapman, Roger, of Bernyngham 0
4659246 2248760 2248760 defendant Sariantson William husbandman 593823 593823 Sariantson, William, of Bernyngham, husbandman 2
4696146 2264276 2264276 defendant Susanne John husbandman 593823 593823 Susanne, John, of Bernyngham, husbandman 0
4711003 2268798 2268798 defendant Pynkne John husbandman 593823 593823 Pynkne, John, of Bernyngham, husbandman 1
4715189 2270080 2270080 defendant Pynkene John yeoman 593823 593823 Pynkene, John, of Bernyngham, yeoman 0
4715203 2270084 2270084 defendant Pynkene John yeoman 593823 593823 Pynkene, John, of Bernyngham, yeoman 0
4715205 2270085 2270085 defendant Pynkene John yeoman 593823 593823 Pynkene, John, of Bernyngham, yeoman 0
4727811 2273942 2273942 defendant Pacok Thomas husbandman 593823 593823 Pacok, Thomas, of Bernyngham, husbandman 0
4749460 2280321 2280321 defendant Port John ploughman 593823 593823 Port, John, of Bernyngham, ploughman 0
4767943 2285946 2285946 defendant Thurkeld Richard chaplain 593823 593823 Thurkeld, Richard, of Bernyngham, chaplain 0
4782768 2290627 2290627 defendant Chapman Roger laborer 593823 593823 Chapman, Roger, of Bernyngham, laborer 1
4860512 2314646 2314646 defendant Rokeby Thomas gent 593823 593823 Rokeby, Thomas, of Bernyngham, gent 4
4860519 2314646 2314646 defendant Kereton Simon yeoman 593823 593823 Kereton, Simon, of Bernyngham, yeoman 11
4860520 2314646 2314646 defendant Gra- Richard yeoman 593823 593823 Gra-, Richard, of Bernyngham, yeoman 12
4888613 2323233 2323233 defendant Vyncent William, junior gent 593823 593823 Vyncent, William, junior, of Bernyngham, gent 1
4913473 2330710 2330710 defendant atte Gate William gent 593823 593823 atte Gate, William, of Bernyngham, gent 1
4938595 2338456 2338456 defendant atte Gate Elizabeth widow 593823 593823 atte Gate, Elizabeth, of Bernyngham, widow 0
4938596 2338456 2338456 defendant atte Gate Joan   593823 593823 atte Gate, Joan, of Bernyngham, servant 1
4948166 2341399 2341399 defendant Coldham John husbandman 593823 593823 Coldham, John, of Bernyngham, husbandman 2
4964999 2346448 2346448 defendant Scotte John husbandman 593823 593823 Scotte, John, of Bernyngham, husbandman 4
4977137 2350116 2350116 defendant Calston Margaret widow 593823 593823 Calston, Margaret, of Bernyngham, widow 1
4988419 2353501 2353501 defendant Golyn Henry yeoman 593823 593823 Golyn, Henry, of Bernyngham, yeoman 6
4995941 2355634 2355634 defendant Roos Richard husbandman 593823 593823 Roos, Richard, of Bernyngham, husbandman 0
5013581 2360816 2360816 defendant Perkyn John husbandman 593823 593823 Perkyn, John, of Bernyngham, husbandman 0
5013582 2360816 2360816 defendant Legat Robert husbandman 593823 593823 Legat, Robert, of Bernyngham, husbandman 1
5013583 2360816 2360816 defendant Palmer John husbandman 593823 593823 Palmer, John, of Bernyngham, husbandman 2
5022555 2363500 2363500 defendant Sergeantson William chaplain 593823 593823 Sergeantson, William, of Bernyngham, chaplain 0
5026559 2364649 2364649 defendant Neleson John husbandman 593823 593823 Neleson, John, of Bernyngham, husbandman 0
5026560 2364649 2364649 defendant Gollan John husbandman 593823 593823 Gollan, John, of Bernyngham, husbandman 1
5026561 2364649 2364649 defendant Roos Richard husbandman 593823 593823 Roos, Richard, of Bernyngham, husbandman 2
5026562 2364649 2364649 defendant Flaye Alice   593823 593823 Flaye, Alice, of Bernyngham, servant 3
5026563 2364649 2364649 defendant Henryson John husbandman 593823 593823 Henryson, John, of Bernyngham, husbandman 4
5026564 2364649 2364649 defendant Tesdale Thomas husbandman 593823 593823 Tesdale, Thomas, of Bernyngham, husbandman 5
5026565 2364649 2364649 defendant Wyghtman Henry husbandman 593823 593823 Wyghtman, Henry, of Bernyngham, husbandman 6
5026566 2364649 2364649 defendant Lovell John husbandman 593823 593823 Lovell, John, of Bernyngham, husbandman 7
5026568 2364650 2364650 defendant Neleson Thomas husbandman 593823 593823 Neleson, Thomas, of Bernyngham, husbandman 0
5026570 2364650 2364650 defendant Urry William husbandman 593823 593823 Urry, William, of Bernyngham, husbandman 2
5026571 2364650 2364650 defendant Aldirscogh John husbandman 593823 593823 Aldirscogh, John, of Bernyngham, husbandman 3
5026572 2364650 2364650 defendant Brone William husbandman 593823 593823 Brone, William, of Bernyngham, husbandman 4
5026573 2364650 2364650 defendant Shawe John husbandman 593823 593823 Shawe, John, of Bernyngham, husbandman 5
5026574 2364650 2364650 defendant Colyn John husbandman 593823 593823 Colyn, John, of Bernyngham, husbandman 6
5026575 2364650 2364650 defendant Aldirson Edmund husbandman 593823 593823 Aldirson, Edmund, of Bernyngham, husbandman 7
5070309 2377613 2377613 defendant Cutbertson William husbandman 593823 593823 Cutbertson, William, of Bernyngham, husbandman 1
5073814 2378656 2378656 defendant Chapman Roger butcher 593823 593823 Chapman, Roger, of Bernyngham, butcher 0
5082642 2381314 2381314 defendant Perkyn William husbandman 593823 593823 Perkyn, William, of Bernyngham, husbandman 2
5282917 2440065 2440065 defendant Onge William husbandman 593823 593823 Onge, William, of Bernyngham, husbandman 0
5288197 2441563 2441563 defendant Mesynger Robert husbandman 593823 593823 Mesynger, Robert, of Bernyngham, husbandman 0
5288198 2441563 2441563 defendant Shawe Roger husbandman 593823 593823 Shawe, Roger, of Bernyngham, husbandman 1
5288199 2441563 2441563 defendant Tesdell John husbandman 593823 593823 Tesdell, John, of Bernyngham, husbandman 2
5288200 2441563 2441563 defendant Raa Thomas tailor 593823 593823 Raa, Thomas, of Bernyngham, tailor 3
5288201 2441563 2441563 defendant Jakson John husbandman 593823 593823 Jakson, John, of Bernyngham, husbandman 4
5290472 2442217 2442217 defendant Miller John chaplain 593823 593823 Miller, John, of Bernyngham, chaplain 1
5307016 2447097 2447097 defendant Coldham Katherine widow 593823 593823 (Coldham, Katherine, of Bernyngham, widow 1
5374858 2467731 2467731 defendant Nelson John yeoman 593823 593823 Nelson, John, of Bernyngham, yeoman 3
5580749 2529058 2529058 defendant Eyer Thomas butcher 593823 593823 Eyer, Thomas, of Bernyngham, butcher 2
5598563 2534436 2534436 defendant Wynter Henry gent 593823 593823 Wynter, Henry, of Bernyngham, gent 1
5633461 2554463 2554463 defendant Coldham John carpenter 593823 593823 Coldham, John, of Bernyngham, carpenter 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);