names

64 rows where place_id = 595581

✎ 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
3621085 1874150 1874150 defendant Billyald William yeoman 595581 595581 Billyald, William, of Sutton on Trent, yeoman 0
3621088 1874151 1874151 defendant Alyn William yeoman 595581 595581 Alyn, William, of Sutton on Trent, yeoman 1
3621091 1874152 1874152 defendant Alyn William yeoman 595581 595581 Alyn, William, of Sutton on Trent, yeoman 1
3645932 1909120 1909120 defendant Porter Thomas yeoman 595581 595581 Porter, Thomas, of Sutton on Trent, yeoman 0
3670764 1916817 1916817 defendant Hylton Robert laborer 595581 595581 Hylton, Robert, of Sutton on Trent, laborer 0
3709843 1929393 1929393 plaintiff Roger William   595581 595581 Roger, William, of Sutton on Trent 0
3764412 1946531 1946531 defendant Burton Richard husbandman 595581 595581 Burton, Richard, of Sutton on Trent, husbandman 0
3767444 1947460 1947460 defendant Foster Andrew   595581 595581 Foster, Andrew, of Sutton on Trent, mason 0
3767445 1947460 1947460 defendant Broke John butcher 595581 595581 Broke, John, of Sutton on Trent, butcher 1
3767446 1947460 1947460 defendant Hunter Edward husbandman 595581 595581 Hunter, Edward, of Sutton on Trent, husbandman 2
3767447 1947460 1947460 defendant Blanke Francis husbandman 595581 595581 Blanke, Francis, of Sutton on Trent, husbandman 3
3767448 1947460 1947460 defendant Worth Thomas carpenter 595581 595581 Worth, Thomas, of Sutton on Trent, carpenter 4
3798641 1957483 1957483 defendant Spur Thomas husbandman 595581 595581 Spur, Thomas, of Sutton on Trent, husbandman 0
3805200 1959571 1959571 defendant Borodale Roger carpenter 595581 595581 Borodale, Roger, of Sutton on Trent, carpenter 3
3816106 1962937 1962937 defendant Spur Thomas husbandman 595581 595581 Spur, Thomas, of Sutton on Trent, husbandman 0
3822274 1964871 1964871 defendant Spur Thomas husbandman 595581 595581 Spur, Thomas, of Sutton on Trent, husbandman 0
3822275 1964871 1964871 defendant Gylbert Richard husbandman 595581 595581 Gylbert, Richard, of Sutton on Trent, husbandman 1
3822276 1964871 1964871 defendant Newton Nicholas husbandman 595581 595581 Newton, Nicholas, of Sutton on Trent, husbandman 2
3977388 2016661 2016661 defendant Cave Peter husbandman 595581 595581 Cave, Peter, of Sutton on Trent, husbandman 0
3983100 2018729 2018729 defendant Greye Robert husbandman 595581 595581 Greye, Robert, of Sutton on Trent, husbandman 0
3995447 2023114 2023114 defendant Childers William husbandman 595581 595581 Childers, William, of Sutton on Trent, husbandman 0
4354649 2148857 2148857 defendant Sudberye Edmund, senior yeoman 595581 595581 Sudberye, Edmund, senior, of Sutton on Trent, yeoman 0
4408043 2167259 2167259 defendant Walis William yeoman 595581 595581 Walis, William, of Sutton on Trent, yeoman 0
4448395 2184427 2184427 defendant Bechekirke Thomas   595581 595581 Bechekirke, Thomas, of Sutton on Trent 0
4689945 2262408 2262408 defendant Bocher John butcher 595581 595581 Bocher, John, of Sutton on Trent, butcher 0
4719566 2271460 2271460 defendant Wormehill John husbandman 595581 595581 Wormehill, John, of Sutton on Trent, husbandman 0
4719778 2271532 2271532 defendant Hulle William   595581 595581 Hulle, William, of Sutton on Trent, wright 1
4737464 2276833 2276833 defendant Kyrkeby Richard fishmonger 595581 595581 Kyrkeby, Richard, of Sutton on Trent, fishmonger 0
4737465 2276833 2276833 defendant Rayne Robert tailor 595581 595581 Rayne, Robert, of Sutton on Trent, tailor 1
4759245 2283233 2283233 defendant Gilbert John husbandman 595581 595581 Gilbert, John, of Sutton on Trent, husbandman 0
4768505 2286123 2286123 defendant Carter John fishmonger 595581 595581 Carter, John, of Sutton on Trent, fishmonger 4
4787383 2292122 2292122 defendant Makesey John butcher 595581 595581 Makesey, John, of Sutton on Trent, butcher 0
4820068 2302354 2302354 defendant Maxsey John husbandman 595581 595581 Maxsey, John, of Sutton on Trent, husbandman 1
4830544 2305574 2305574 defendant Bayle John miller 595581 595581 Bayle, John, of Sutton on Trent, miller 0
4835662 2307147 2307147 defendant Gambyll Robert chapman 595581 595581 Gambyll, Robert, of Sutton on Trent, chapman 0
4839840 2308370 2308370 defendant Scot John husbandman 595581 595581 Scot, John, of Sutton on Trent, husbandman 3
4852101 2312088 2312088 defendant Maxsay John butcher 595581 595581 Maxsay, John, of Sutton on Trent, butcher 2
4872127 2318244 2318244 defendant Maxsay William butcher 595581 595581 Maxsay, William, of Sutton on Trent, butcher 0
4880040 2320670 2320670 defendant Maxsay John butcher 595581 595581 Maxsay, John, of Sutton on Trent, butcher 2
4889877 2323622 2323622 defendant Maksey John husbandman 595581 595581 Maksey, John, of Sutton on Trent, husbandman 0
4920385 2332892 2332892 defendant Cromwell John husbandman 595581 595581 Cromwell, John, of Sutton on Trent, husbandman 2
4947261 2341132 2341132 defendant Shepherd John husbandman 595581 595581 Shepherd, John, of Sutton on Trent, husbandman 2
4974687 2349396 2349396 defendant Audeley Gilbert husbandman 595581 595581 Audeley, Gilbert, of Sutton on Trent, husbandman 1
5045904 2370410 2370410 defendant Sterope Thomas husbandman 595581 595581 Sterope, Thomas, of Sutton on Trent, husbandman 1
5066914 2376629 2376629 defendant Houson or Honson John husbandman 595581 595581 Houson or Honson, John, of Sutton on Trent, husbandman 2
5069738 2377444 2377444 defendant Adlyn William husbandman 595581 595581 Adlyn, William, of Sutton on Trent, husbandman 2
5069739 2377444 2377444 defendant Adlyn Robert husbandman 595581 595581 Adlyn, Robert, of Sutton on Trent, husbandman 3
5156557 2403070 2403070 defendant Harecourte William tailor 595581 595581 Harecourte, William, of Sutton on Trent, tailor 1
5172722 2407751 2407751 defendant Harecourte William tailor 595581 595581 Harecourte, William, of Sutton on Trent, tailor 1
5192470 2413533 2413533 defendant Harecourt William tailor 595581 595581 Harecourt, William, of Sutton on Trent, tailor 0
5230689 2424587 2424587 defendant Taillour William   595581 595581 Taillour, William, of Sutton on Trent 3
5319112 2450809 2450809 defendant Nicolson John butcher 595581 595581 Nicolson, John, of Sutton on Trent, butcher 0
5347641 2459417 2459417 defendant Nicholason John yeoman 595581 595581 Nicholason, John, of Sutton on Trent, yeoman 3
5347648 2459418 2459418 defendant Nicolason John yeoman 595581 595581 Nicolason, John, of Sutton on Trent, yeoman 3
5497590 2504222 2504222 defendant Nicolson John butcher 595581 595581 Nicolson, John, of Sutton on Trent, butcher 0
5497856 2504300 2504300 defendant Nicolson John yeoman 595581 595581 Nicolson, John, of Sutton on Trent, yeoman 0
5543596 2518102 2518102 defendant Eyre Thomas clerk 595581 595581 Eyre, Thomas, of Sutton on Trent, clerk 2
5569461 2525631 2525631 defendant Daweson John, junior laborer 595581 595581 Daweson, John, junior, of Sutton on Trent, laborer 0
5569462 2525631 2525631 defendant Sutton William, junior laborer 595581 595581 Sutton, William, junior, of Sutton on Trent, laborer 1
5576050 2527574 2527574 defendant Glaucester Henry gent 595581 595581 Glaucester, Henry, of Sutton on Trent, gent 0
5577102 2527884 2527884 defendant Deen Thomas husbandman 595581 595581 Deen, Thomas, of Sutton on Trent, husbandman 2
5581337 2529234 2529234 defendant Nicholson Simon husbandman 595581 595581 Nicholson, Simon, of Sutton on Trent, husbandman 0
5631858 2553981 2553981 defendant de Cromwell John yeoman 595581 595581 de Cromwell, John, of Sutton on Trent, yeoman 0
5631859 2553981 2553981 defendant Shepherde John husbandman 595581 595581 Shepherde, John, of Sutton on Trent, husbandman 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);