names

92 rows where place_id = 590380

✎ 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
3601004 1867979 1867979 defendant Tales Thomas yeoman 590380 590380 Tales, Thomas, of Melton Moubray, yeoman 0
4415625 2169767 2169767 plaintiff Holewell Richard de   590380 590380 Holewell, Richard de, of Melton Moubray 0
4419262 2170903 2170903 plaintiff Banastre Hugh   590380 590380 Banastre, Hugh, of Melton Moubray 0
4434088 2175423 2175423 plaintiff Holewell Richard de   590380 590380 Holewell, Richard de, of Melton Moubray 0
4448616 2184497 2184497 defendant Lawe Richard in the   590380 590380 Lawe, Richard in the, of Melton Moubray 0
4473395 2192341 2192341 defendant atte Priours Walter   590380 590380 atte Priours, Walter, of Melton Moubray 0
4498863 2200279 2200279 defendant Gyrlle Richard shoemaker 590380 590380 Gyrlle, Richard, of Melton Moubray, shoemaker 0
4514194 2204856 2204856 defendant Orgar Robert   590380 590380 Orgar, Robert, of Melton Moubray 0
4515830 2205372 2205372 defendant Orger Robert   590380 590380 Orger, Robert, of Melton Moubray 0
4526504 2208572 2208572 defendant Orgar Robert   590380 590380 Orgar, Robert, of Melton Moubray 0
4527189 2208783 2208783 defendant Lane Robert in the   590380 590380 Lane, Robert in the, of Melton Moubray 0
4540706 2212998 2212998 defendant Burgeys John   590380 590380 Burgeys, John, of Melton Moubray 0
4576908 2224281 2224281 defendant Bayly John   590380 590380 Bayly, John, of Melton Moubray 0
4618764 2236871 2236871 defendant Spicer John   590380 590380 Spicer, John, of Melton Moubray 5
4634025 2241494 2241494 defendant Wryght Richard   590380 590380 Wryght, Richard, of Melton Moubray 0
4642618 2243959 2243959 plaintiff Helmeden William   590380 590380 Helmeden, William, of Melton Moubray 0
4720321 2271697 2271697 defendant Burgh Roger   590380 590380 Burgh, Roger, of Melton Moubray 0
4720781 2271831 2271831 defendant Assheby Margery   590380 590380 (Assheby, Margery, of Melton Moubray, widow, formerly wife of Robert 1
4728084 2274031 2274031 defendant Waltham Elizabeth   590380 590380 Waltham, Elizabeth, of Melton Moubray, widow, formerly wife of Edmund Waltham 0
4734503 2275957 2275957 defendant Burgh Roger   590380 590380 Burgh, Roger, of Melton Moubray, bailiff 5
4740190 2277644 2277644 defendant Baron William   590380 590380 Baron, William, of Melton Moubray, net knitter 1
4744554 2278931 2278931 defendant Milner Rober milner 590380 590380 Milner, Rober, of Melton Moubray, milner 0
4744556 2278931 2278931 defendant Bethewater Thomas laborer 590380 590380 Bethewater, Thomas, of Melton Moubray, laborer 2
4744783 2278991 2278991 defendant Burgh Roger husbandman 590380 590380 Burgh, Roger, of Melton Moubray, husbandman 0
4745673 2279247 2279247 plaintiff Goldsmyth John, junior   590380 590380 Goldsmyth, John, junior, of Melton Moubray, on his own account 0
4747764 2279855 2279855 defendant Lathum John gent 590380 590380 Lathum, John, of Melton Moubray, gent 0
4766615 2285549 2285549 defendant Baily John yeoman 590380 590380 Baily, John, of Melton Moubray, yeoman 3
4776223 2288553 2288553 defendant Bailly John yeoman 590380 590380 Bailly, John, of Melton Moubray, yeoman 0
4785329 2291429 2291429 defendant Milner Richard miller 590380 590380 Milner, Richard, of Melton Moubray, miller 0
4785331 2291430 2291430 defendant Milner Richard miller 590380 590380 Milner, Richard, of Melton Moubray, miller 0
4807065 2298408 2298408 defendant Talys John yeoman 590380 590380 Talys, John, of Melton Moubray, yeoman 0
4807066 2298408 2298408 defendant Talys William yeoman 590380 590380 Talys, William, of Melton Moubray, yeoman 1
4808620 2298860 2298860 defendant Goldesmyth John merchant 590380 590380 Goldesmyth, John, of Melton Moubray, merchant 4
4811969 2299858 2299858 plaintiff Goldsmyth John (legal representative) 590380 590380 Goldsmyth, John, of Melton Moubray, executors of 0
4811976 2299858 2299858 defendant Tabard Robert smith 590380 590380 Tabard, Robert, of Melton Moubray, smith 3
4811977 2299859 2299859 plaintiff Goldsmyth John, senior (legal representative) 590380 590380 Goldsmyth, John, senior, of Melton Moubray, executors of 0
4815502 2300954 2300954 defendant Sees John husbandman 590380 590380 Sees, John, of Melton Moubray, husbandman 4
4820739 2302560 2302560 defendant Benet Robert   590380 590380 Benet, Robert, of Melton Moubray, wright 0
4855911 2313222 2313222 defendant Legh Richard chapman 590380 590380 Legh, Richard, of Melton Moubray, chapman 0
4855913 2313222 2313222 defendant Tales John butcher 590380 590380 Tales, John, of Melton Moubray, butcher 2
4855914 2313222 2313222 defendant Tales William butcher 590380 590380 Tales, William, of Melton Moubray, butcher 3
4872727 2318421 2318421 defendant Cosour Robert chapman 590380 590380 Cosour, Robert, of Melton Moubray, chapman 0
4876169 2319504 2319504 defendant Clay Robert yeoman 590380 590380 Clay, Robert, of Melton Moubray, yeoman 0
4877207 2319829 2319829 defendant Tales John, senior butcher 590380 590380 Tales, John, senior, of Melton Moubray, butcher 0
4877208 2319829 2319829 defendant Tales William butcher 590380 590380 Tales, William, of Melton Moubray, butcher 1
4877209 2319829 2319829 defendant Taylour Nicholas husbandman 590380 590380 Taylour, Nicholas, of Melton Moubray, husbandman 2
4886505 2322642 2322642 defendant Tales John, senior butcher 590380 590380 Tales, John, senior, of Melton Moubray, butcher 0
4889898 2323629 2323629 defendant Bromhyll Robert yeoman 590380 590380 Bromhyll, Robert, of Melton Moubray, yeoman 3
4889899 2323629 2323629 defendant Tounesende alias Spycer Robert yeoman 590380 590380 Tounesende alias Spycer, Robert, of Melton Moubray, yeoman 4
4904466 2328005 2328005 defendant Bromhyll Robert yeoman 590380 590380 Bromhyll, Robert, of Melton Moubray, yeoman 3
4904467 2328005 2328005 defendant Tounnesende alias Spycer Robert yeoman 590380 590380 Tounnesende alias Spycer, Robert, of Melton Moubray, yeoman 4
4908931 2329339 2329339 defendant Carter Nicholas laborer 590380 590380 Carter, Nicholas, of Melton Moubray, laborer 0
4913397 2330690 2330690 defendant Elmeden Thomas fisher 590380 590380 Elmeden, Thomas, of Melton Moubray, fisher 0
4926876 2334835 2334835 defendant Holand William husbandman 590380 590380 Holand, William, of Melton Moubray, husbandman 3
4928559 2335361 2335361 defendant Orgar John gent 590380 590380 Orgar, John, of Melton Moubray, gent 0
4939848 2338851 2338851 defendant Broun John dyer 590380 590380 Broun, John, of Melton Moubray, dyer 2
4940058 2338918 2338918 defendant Hola- William husbandman 590380 590380 Hola-, William, of Melton Moubray, husbandman 0
4963528 2346006 2346006 defendant Dalby Robert butcher 590380 590380 Dalby, Robert, of Melton Moubray, butcher 0
4965342 2346557 2346557 defendant Saxby Geoffrey husbandman 590380 590380 Saxby, Geoffrey, of Melton Moubray, husbandman 0
4971044 2348279 2348279 defendant Lathom John husbandman 590380 590380 Lathom, John, of Melton Moubray, husbandman 0
4971472 2348395 2348395 defendant Clay Robert yeoman 590380 590380 Clay, Robert, of Melton Moubray, yeoman 0
4972815 2348807 2348807 defendant Holande William   590380 590380 Holande, William, of Melton Moubray, shepherd 0
4979671 2350876 2350876 defendant Milner Thomas miller 590380 590380 Milner, Thomas, of Melton Moubray, miller 0
4979672 2350876 2350876 defendant Seriaunt William butcher 590380 590380 Seriaunt, William, of Melton Moubray, butcher 1
4979673 2350876 2350876 defendant Dukworth William (legal representative) 590380 590380 Dukworth, William, of Melton Moubray, yeoman, executrix of 2
4981798 2351474 2351474 defendant Dalby Robert yeoman 590380 590380 Dalby, Robert, of Melton Moubray, yeoman 2
5000584 2357041 2357041 defendant Talus William yeoman 590380 590380 Talus, William, of Melton Moubray, yeoman 1
5051739 2372131 2372131 defendant Cley Robert husbandman 590380 590380 Cley, Robert, of Melton Moubray, husbandman 4
5051740 2372131 2372131 defendant Carter Robert husbandman 590380 590380 Carter, Robert, of Melton Moubray, husbandman 5
5095147 2384994 2384994 defendant Sergeant William butcher 590380 590380 Sergeant, William, of Melton Moubray, butcher 0
5112873 2390161 2390161 defendant Osbarn John weaver 590380 590380 Osbarn, John, of Melton Moubray, weaver 0
5115661 2391009 2391009 defendant Wynsterley Robert laborer 590380 590380 Wynsterley, Robert, of Melton Moubray, laborer 0
5136085 2397063 2397063 defendant Wynstley Robert laborer 590380 590380 Wynstley, Robert, of Melton Moubray, laborer 0
5137457 2397468 2397468 defendant Wynsterley Robert yeoman 590380 590380 Wynsterley, Robert, of Melton Moubray, yeoman 1
5137458 2397468 2397468 defendant Myddylton Peter laborer 590380 590380 Myddylton, Peter, of Melton Moubray, laborer 2
5137459 2397468 2397468 defendant Clay Robert yeoman 590380 590380 Clay, Robert, of Melton Moubray, yeoman 3
5154332 2402424 2402424 defendant Clay Robert yeoman 590380 590380 Clay, Robert, of Melton Moubray, yeoman 0
5154333 2402424 2402424 defendant Harpeley Thomas laborer 590380 590380 together with Harpeley, Thomas, of Melton Moubray, laborer 1
5154334 2402424 2402424 defendant Wynsterley Robert yeoman 590380 590380 Wynsterley, Robert, of Melton Moubray, yeoman 2
5154335 2402424 2402424 defendant Myddylton Peter laborer 590380 590380 Myddylton, Peter, of Melton Moubray, laborer 3
5154340 2402426 2402426 defendant Harpeley Thomas laborer 590380 590380 Harpeley, Thomas, of Melton Moubray, laborer 0
5154341 2402426 2402426 defendant Wynsterley Robert yeoman 590380 590380 Wynsterley, Robert, of Melton Moubray, yeoman 1
5154342 2402426 2402426 defendant Myddylton Peter laborer 590380 590380 Myddylton, Peter, of Melton Moubray, laborer 2
5157321 2403279 2403279 defendant Gerold Thomas smith 590380 590380 Gerold, Thomas, of Melton Moubray, smith 0
5223691 2422613 2422613 defendant of ye Lygh Peter yeoman 590380 590380 of ye Lygh, Peter, of Melton Moubray, yeoman 1
5238774 2426931 2426931 defendant Lye Peter yeoman 590380 590380 Lye, Peter, of Melton Moubray, yeoman 0
5333567 2455112 2455112 defendant Robson John yeoman 590380 590380 Robson, John, of Melton Moubray, yeoman 0
5333579 2455117 2455117 defendant Robson John yeoman 590380 590380 Robson, John, of Melton Moubray, yeoman 0
5335560 2455708 2455708 defendant Manton or Mauton Robert clerk 590380 590380 Manton or Mauton, Robert, of Melton Moubray, clerk 0
5353982 2461308 2461308 defendant Manton or Mauton Robert clerk 590380 590380 Manton or Mauton, Robert, of Melton Moubray, clerk 0
5393364 2473158 2473158 defendant Dalamere John husbandman 590380 590380 Dalamere, John, of Melton Moubray, husbandman 1
5622681 2551025 2551025 defendant Houby Thomas   590380 590380 Houby, Thomas, of Melton Moubray 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);