names

56 rows where place_id = 591245

✎ 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
3603836 1868873 1868873 plaintiff Fawkener John mercer 591245 591245 Fawkener, John, of Melton Mowbray, mercer 0
3628382 1903743 1903743 defendant Farthyng Thomas butcher 591245 591245 Farthyng, Thomas, of Melton Mowbray, butcher 0
3647031 1909471 1909471 defendant Sharpe Richard yeoman 591245 591245 Sharpe, Richard, of Melton Mowbray, yeoman 0
3685928 1921756 1921756 defendant Porter Robert glover 591245 591245 (Porter, Robert, of Melton Mowbray, glover 1
3699649 1926120 1926120 defendant Sheperd Henry butcher 591245 591245 Sheperd, Henry, of Melton Mowbray, butcher 1
3699650 1926120 1926120 defendant Grey Richard roper 591245 591245 Grey, Richard, of Melton Mowbray, roper 2
3708431 1928935 1928935 defendant Watson William husbandman 591245 591245 Watson, William, of Melton Mowbray, husbandman 0
3710451 1929587 1929587 plaintiff Sherp Richard   591245 591245 Sherp, Richard, of Melton Mowbray 0
3720496 1932693 1932693 defendant Taberer William husbandman 591245 591245 Taberer, William, of Melton Mowbray, husbandman 3
3733124 1936588 1936588 defendant Parker William husbandman 591245 591245 Parker, William, of Melton Mowbray, husbandman 0
3733125 1936588 1936588 defendant Watson William husbandman 591245 591245 Watson, William, of Melton Mowbray, husbandman 1
3733131 1936591 1936591 defendant Smyth Henry husbandman 591245 591245 Smyth, Henry, of Melton Mowbray, husbandman 0
3733138 1936594 1936594 defendant Waryng William merchant 591245 591245 Waryng, William, of Melton Mowbray, merchant 0
3798325 1957375 1957375 defendant Mydelton John draper 591245 591245 Mydelton, John, of Melton Mowbray, draper 0
3855504 1975365 1975365 plaintiff Waryng William merchant of the staple 591245 591245 Waryng, William, of Melton Mowbray, merchant of the staple 0
3869616 1980077 1980077 plaintiff Waryng William merchant of the staple 591245 591245 Waryng, William, of Melton Mowbray, merchant of the staple 0
3869685 1980103 1980103 defendant Kechyn William chapman 591245 591245 Kechyn, William, of Melton Mowbray, chapman 1
3900473 1990388 1990388 defendant Holyngworth Robert butcher 591245 591245 Holyngworth, Robert, of Melton Mowbray, butcher 0
3905557 1992127 1992127 defendant Holyngworth Robert butcher 591245 591245 Holyngworth, Robert, of Melton Mowbray, butcher 0
3905558 1992127 1992127 defendant Shawcrosse Simon butcher 591245 591245 Shawcrosse, Simon, of Melton Mowbray, butcher 1
4215093 2100780 2100780 defendant Whytle Anthony (legal representative) 591245 591245 Whytle, Anthony, of Melton Mowbray, bailiff of Framland hundred, administratrix of 0
4215094 2100780 2100780 defendant Whitle Faith widow 591245 591245 Whitle, Faith, of Melton Mowbray, widow 1
4459465 2188010 2188010 defendant Gelle William   591245 591245 Gelle, William, of Melton Mowbray 0
4622716 2238079 2238079 plaintiff Machon John   591245 591245 Machon, John, of Melton Mowbray 0
4622718 2238080 2238080 plaintiff Machon John   591245 591245 Machon, John, of Melton Mowbray 0
4706118 2267290 2267290 defendant Spicer Richard spicer 591245 591245 Spicer, Richard, of Melton Mowbray, spicer 0
4720776 2271830 2271830 defendant Assheby Robert (legal representative) 591245 591245 Assheby, Robert, of Melton Mowbray, merchant, executors of 0
4720883 2271865 2271865 defendant Assheby Robert (legal representative) 591245 591245 Assheby, Robert, of Melton Mowbray, executors of 0
4720884 2271865 2271865 defendant Assheby Margery   591245 591245 (Assheby, Margery, of Melton Mowbray, widow, formerly wife of Robert 1
4731432 2275031 2275031 defendant Sharp Roger husbandman 591245 591245 Sharp, Roger, of Melton Mowbray, husbandman 0
4731433 2275031 2275031 defendant Lathorne John husbandman 591245 591245 Lathorne, John, of Melton Mowbray, husbandman 1
4736253 2276470 2276470 defendant Borugh Roger yeoman 591245 591245 Borugh, Roger, of Melton Mowbray, yeoman 0
4758827 2283114 2283114 defendant Thorp John butcher 591245 591245 Thorp, John, of Melton Mowbray, butcher 0
4764225 2284803 2284803 defendant Tales William yeoman 591245 591245 Tales, William, of Melton Mowbray, yeoman 2
4766608 2285548 2285548 defendant Assheby Robert (legal representative) 591245 591245 Assheby, Robert, of Melton Mowbray, merchant, executrix of 3
4766611 2285549 2285549 plaintiff Tales John   591245 591245 Tales, John, of Melton Mowbray 1
4768682 2286182 2286182 defendant Attales John yeoman 591245 591245 Attales, John, of Melton Mowbray, yeoman 0
4842467 2309180 2309180 defendant Whyteby Robert husbandman 591245 591245 Whyteby, Robert, of Melton Mowbray, husbandman 0
4926875 2334835 2334835 defendant Bythewatyr Thomas husbandman 591245 591245 Bythewatyr, Thomas, of Melton Mowbray, husbandman 2
4999573 2356747 2356747 defendant Talis William butcher 591245 591245 Talis, William, of Melton Mowbray, butcher 2
5064540 2375933 2375933 defendant Serjaunt William butcher 591245 591245 Serjaunt, William, of Melton Mowbray, butcher 0
5075848 2379267 2379267 defendant Lye Robert courser 591245 591245 Lye, Robert, of Melton Mowbray, courser 2
5075849 2379267 2379267 defendant Smyth John smith 591245 591245 Smyth, John, of Melton Mowbray, smith 3
5075854 2379268 2379268 defendant Lye Robert courser 591245 591245 Lye, Robert, of Melton Mowbray, courser 2
5075855 2379268 2379268 defendant Smyth John smith 591245 591245 Smyth, John, of Melton Mowbray, smith 3
5113870 2390446 2390446 defendant Lee alias Corser Richard husbandman 591245 591245 Lee alias Corser, Richard, of Melton Mowbray, husbandman 0
5125535 2393954 2393954 defendant Gerolde Thomas smith 591245 591245 Gerolde, Thomas, of Melton Mowbray, smith 2
5137456 2397468 2397468 defendant Harpeley Thomas laborer 591245 591245 Harpeley, Thomas, of Melton Mowbray, laborer 0
5160164 2404074 2404074 defendant Hoberd John   591245 591245 Hoberd, John, of Melton Mowbray, cart wright 0
5171447 2407373 2407373 defendant Harpeley Thomas laborer 591245 591245 Harpeley, Thomas, of Melton Mowbray, laborer 0
5171448 2407373 2407373 defendant Wynsterley Robert yeoman 591245 591245 Wynsterley, Robert, of Melton Mowbray, yeoman 1
5171449 2407373 2407373 defendant Myddylton Pepter laborer 591245 591245 Myddylton, Pepter, of Melton Mowbray, laborer 2
5171451 2407373 2407373 defendant Clay Robert yeoman 591245 591245 together with Clay, Robert, of Melton Mowbray, yeoman 4
5212094 2419277 2419277 defendant Lye Robert courser 591245 591245 Lye, Robert, of Melton Mowbray, courser 2
5212095 2419277 2419277 defendant Smyth John smith 591245 591245 Smyth, John, of Melton Mowbray, smith 3
5307898 2447379 2447379 defendant Lenton John yeoman 591245 591245 Lenton, John, of Melton Mowbray, yeoman 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);