names

120 rows where place_id = 593015

✎ 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
3610065 1870815 1870815 defendant Hervy Richard husbandman 593015 593015 Hervy, Richard, of Melreth, husbandman 0
3626084 1903018 1903018 defendant Harvy Thomas yeoman 593015 593015 Harvy, Thomas, of Melreth, yeoman 1
3632329 1904933 1904933 defendant Sturmyn William husbandman 593015 593015 Sturmyn, William, of Melreth, husbandman 0
3632333 1904933 1904933 defendant Gateward Thomas husbandman 593015 593015 Gateward, Thomas, of Melreth, husbandman 4
3634238 1905506 1905506 defendant Asshe Waren husbandman 593015 593015 Asshe, Waren, of Melreth, husbandman 2
3643316 1908335 1908335 defendant Fesaunt William (legal representative) 593015 593015 Fesaunt, William, of Melreth, draper, executrix of 0
3643317 1908335 1908335 defendant Fesaunt Lucy widow 593015 593015 Fesaunt, Lucy, of Melreth, widow 1
3687819 1922355 1922355 plaintiff Colwell Richard   593015 593015 Colwell, Richard, of Melreth 0
3691290 1923434 1923434 defendant Schapp John yeoman 593015 593015 Schapp, John, of Melreth, yeoman 0
3705660 1928052 1928052 defendant Sharp John yeoman 593015 593015 Sharp, John, of Melreth, yeoman 0
3767071 1947360 1947360 defendant Yole William husbandman 593015 593015 Yole, William, of Melreth, husbandman 2
3784876 1953063 1953063 defendant Yole William husbandman 593015 593015 Yole, William, of Melreth, husbandman 2
3890107 1986924 1986924 defendant Slyter William yeoman 593015 593015 Slyter, William, of Melreth, yeoman 0
3946925 2005992 2005992 defendant Campyon John yeoman 593015 593015 Campyon, John, of Melreth, yeoman 0
4417153 2170231 2170231 defendant Gilot Roger   593015 593015 Gilot, Roger, of Melreth 0
4422830 2171998 2171998 defendant Brimpton George de   593015 593015 Brimpton, George de, of Melreth, son of John, who vouched Frend, George, kinsman & heir of John de Halughton, formerly bishop of Carlisle 0
4428308 2173688 2173688 plaintiff Stokton Thomas de   593015 593015 Stokton, Thomas de, of Melreth, vicar 0
4428311 2173688 2173688 defendant Waryn John   593015 593015 Waryn, John, of Melreth 2
4431076 2174477 2174477 defendant Brumpton George   593015 593015 Brumpton, George, of Melreth, son of John, who vouched Frend, George, kinsman & heir of John de Halughton, formerly bishop of Carlisle 0
4450490 2185118 2185118 defendant Cappe Hugh   593015 593015 Cappe, Hugh, of Melreth 0
4456880 2187162 2187162 defendant Cappe Hugh   593015 593015 Cappe, Hugh, of Melreth 0
4466802 2190287 2190287 defendant Pate Peter   593015 593015 Pate, Peter, of Melreth 0
4471161 2191640 2191640 plaintiff Canele Thomas   593015 593015 Canele, Thomas, of Melreth 0
4478330 2193899 2193899 plaintiff Hendekyn John   593015 593015 Hendekyn, John, of Melreth, on his own account 0
4559508 2218923 2218923 plaintiff Meryell William   593015 593015 Meryell, William, of Melreth 0
4620378 2237353 2237353 plaintiff Ingryth Warren   593015 593015 Ingryth, Warren, of Melreth 0
4620379 2237353 2237353 plaintiff Dynby Richard   593015 593015 Dynby, Richard, of Melreth 1
4621120 2237588 2237588 defendant Muryell John   593015 593015 Muryell, John, of Melreth 0
4651303 2246413 2246413 defendant Doun William husbandman 593015 593015 Doun, William, of Melreth, husbandman 1
4654580 2247312 2247312 plaintiff Bonde William   593015 593015 Bonde, William, of Melreth 0
4654581 2247312 2247312 defendant Bryd John miller 593015 593015 Bryd, John, of Melreth, miller 0
4656567 2247947 2247947 defendant Meriel William husbandman 593015 593015 Meriel, William, of Melreth, husbandman 0
4664982 2250529 2250529 defendant Boffere Margaret widow 593015 593015 Boffere, Margaret, of Melreth, widow 1
4666287 2250928 2250928 plaintiff Ingrith Hugh   593015 593015 Ingrith, Hugh, of Melreth 0
4666288 2250928 2250928 defendant Bryd John miller 593015 593015 Bryd, John, of Melreth, miller 0
4671106 2256627 2256627 defendant Kelm Edmund husbandman 593015 593015 Kelm, Edmund, of Melreth, husbandman 2
4686135 2261258 2261258 defendant Caltecote Nicholas, senior gent 593015 593015 Caltecote, Nicholas, senior, of Melreth, gent 0
4704896 2266908 2266908 defendant Austyn Warren husbandman 593015 593015 Austyn, Warren, of Melreth, husbandman 0
4704897 2266908 2266908 defendant Alman Alan husbandman 593015 593015 Alman, Alan, of Melreth, husbandman 1
4721747 2272137 2272137 defendant Austyn Warren husbandman 593015 593015 Austyn, Warren, of Melreth, husbandman 0
4723436 2272639 2272639 defendant Assh John ploughman 593015 593015 Assh, John, of Melreth, ploughman 0
4738555 2277150 2277150 defendant Ingrith William husbandman 593015 593015 Ingrith, William, of Melreth, husbandman 2
4747078 2279651 2279651 defendant Kelm Edmund husbandman 593015 593015 Kelm, Edmund, of Melreth, husbandman 0
4747080 2279651 2279651 defendant Colman John butcher 593015 593015 Colman, John, of Melreth, butcher 2
4747082 2279652 2279652 defendant Kaye Thomas laborer 593015 593015 Kaye, Thomas, of Melreth, laborer 0
4758503 2283039 2283039 defendant Power John husbandman 593015 593015 Power, John, of Melreth, husbandman 2
4758504 2283040 2283040 plaintiff Caldecote Nicholas   593015 593015 Caldecote, Nicholas, of Melreth 0
4765805 2285305 2285305 defendant Kelme Edmund husbandman 593015 593015 Kelme, Edmund, of Melreth, husbandman 0
4822865 2303235 2303235 defendant Kyng John   593015 593015 Kyng, John, of Melreth, plough wright 0
4832326 2306143 2306143 plaintiff Calcote Nicholas   593015 593015 Calcote, Nicholas, of Melreth 0
4852848 2312310 2312310 defendant Ingryth Warren gent 593015 593015 Ingryth, Warren, of Melreth, gent 0
4871149 2317953 2317953 defendant Austyn Waren husbandman 593015 593015 Austyn, Waren, of Melreth, husbandman 2
4886397 2322606 2322606 defendant Ingereth William husbandman 593015 593015 Ingereth, William, of Melreth, husbandman 3
4917063 2331844 2331844 defendant Bonde Robert mercer 593015 593015 Bonde, Robert, of Melreth, mercer 0
4928904 2335463 2335463 defendant Porter John husbandman 593015 593015 Porter, John, of Melreth, husbandman 0
4928905 2335463 2335463 defendant Belemyne William husbandman 593015 593015 Belemyne, William, of Melreth, husbandman 1
4929861 2335755 2335755 defendant Bonde Robert yeoman 593015 593015 Bonde, Robert, of Melreth, yeoman 0
4932497 2336558 2336558 defendant Bentyng John husbandman 593015 593015 Bentyng, John, of Melreth, husbandman 0
4941486 2339356 2339356 defendant Bonde Robert yeoman 593015 593015 Bonde, Robert, of Melreth, yeoman 2
4944498 2340258 2340258 defendant Taillour Thomas butcher 593015 593015 Taillour, Thomas, of Melreth, butcher 2
4953307 2342952 2342952 defendant Colop Nicholas husbandman 593015 593015 Colop, Nicholas, of Melreth, yeoman, or of Wykyn, Essex, husbandman 0
4953308 2342952 2342952 defendant Colop Edmund yeoman 593015 593015 together with Colop, Edmund, of Melreth, yeoman 1
4954150 2343211 2343211 defendant Porter John husbandman 593015 593015 Porter, John, of Melreth, husbandman 0
4954151 2343211 2343211 defendant Belemyne William husbandman 593015 593015 Belemyne, William, of Melreth, husbandman 1
4957558 2344232 2344232 defendant Austyn Waren husbandman 593015 593015 Austyn, Waren, of Melreth, husbandman 0
4957559 2344232 2344232 defendant Austyn John husbandman 593015 593015 Austyn, John, of Melreth, husbandman 1
4968192 2347437 2347437 defendant Bonde Robert mercer 593015 593015 Bonde, Robert, of Melreth, mercer 0
4971892 2348526 2348526 defendant Kyng Robert drover 593015 593015 Kyng, Robert, of Melreth, drover 2
4991416 2354318 2354318 defendant Colopp Edmund husbandman 593015 593015 Colopp, Edmund, of Melreth, husbandman 3
4991417 2354318 2354318 defendant Tayllour Thomas husbandman 593015 593015 Tayllour, Thomas, of Melreth, husbandman 4
4991491 2354339 2354339 defendant Key Thomas   593015 593015 Key, Thomas, of Melreth 3
5014794 2361201 2361201 defendant Asshe William husbandman 593015 593015 Asshe, William, of Melreth, husbandman 0
5017243 2361927 2361927 defendant Berwyn William yeoman 593015 593015 Berwyn, William, of Melreth, yeoman 0
5020395 2362850 2362850 defendant Elyse Nicholas gent 593015 593015 Elyse, Nicholas, of Melreth, gent 0
5023042 2363647 2363647 defendant Austyn Waren husbandman 593015 593015 Austyn, Waren, of Melreth, husbandman 3
5052299 2372292 2372292 defendant Leycetre William carter 593015 593015 Leycetre, William, of Melreth, carter 3
5072930 2378389 2378389 defendant Roulond William husbandman 593015 593015 Roulond, William, of Melreth, husbandman 3
5103621 2387485 2387485 defendant Avent John husbandman 593015 593015 Avent, John, of Melreth, husbandman 2
5107955 2388766 2388766 defendant Calcot John gent 593015 593015 Calcot, John, of Melreth, gent 0
5146401 2400078 2400078 defendant Pygge John carpenter 593015 593015 Pygge, John, of Melreth, carpenter 0
5151640 2401635 2401635 defendant Avent John husbandman 593015 593015 Avent, John, of Melreth, husbandman 1
5166562 2405939 2405939 defendant Pygge John carpenter 593015 593015 Pygge, John, of Melreth, carpenter 0
5186841 2411896 2411896 defendant Barron William husbandman 593015 593015 Barron, William, of Melreth, husbandman 3
5205367 2417324 2417324 defendant Avent John husbandman 593015 593015 Avent, John, of Melreth, husbandman 1
5205376 2417326 2417326 defendant Barron William husbandman 593015 593015 Barron, William, of Melreth, husbandman 3
5229704 2424306 2424306 defendant Lyly John husbandman 593015 593015 Lyly, John, of Melreth, husbandman 4
5232961 2425222 2425222 defendant Quie Eustace husbandman 593015 593015 Quie, Eustace, of Melreth, husbandman 0
5243660 2428339 2428339 defendant Pygge John carpenter 593015 593015 Pygge, John, of Melreth, carpenter 0
5249576 2429994 2429994 defendant Graunt William (legal representative) 593015 593015 Graunt, William, of Melreth, yeoman, executors of 0
5249580 2429994 2429994 defendant Chyppenale John yeoman 593015 593015 Chyppenale, John, of Melreth, yeoman 4
5250594 2430295 2430295 defendant Whitpayn John husbandman 593015 593015 Whitpayn, John, of Melreth, husbandman 0
5265231 2434883 2434883 defendant Burley or Curley Nicholas husbandman 593015 593015 Burley or Curley, Nicholas, of Melreth, husbandman 0
5278946 2438953 2438953 defendant Lounde Thomas husbandman 593015 593015 Lounde, Thomas, of Melreth, husbandman 1
5278947 2438953 2438953 defendant Hornnold William husbandman 593015 593015 Hornnold, William, of Melreth, husbandman 2
5280432 2439351 2439351 defendant Aldyng William yeoman 593015 593015 Aldyng, William, of Melreth, yeoman 0
5280433 2439351 2439351 defendant Bonde William baker 593015 593015 Bonde, William, of Melreth, baker 1
5285107 2440669 2440669 defendant Aldyng William yeoman 593015 593015 Aldyng, William, of Melreth, yeoman 4
5285113 2440670 2440670 defendant Aldyng William yeoman 593015 593015 Aldyng, William, of Melreth, yeoman 4
5294290 2443303 2443303 defendant Sutton Richard yeoman 593015 593015 Sutton, Richard, of Melreth, yeoman 0
5299919 2444941 2444941 defendant Aldyng William yeoman 593015 593015 Aldyng, William, of Melreth, yeoman 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);