names

81 rows where place_id = 593183

✎ 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
3610826 1871053 1871053 defendant Borant Thomas husbandman 593183 593183 Borant, Thomas, of Nonyngton, husbandman 1
3613364 1871826 1871826 defendant Austyn Robert husbandman 593183 593183 Austyn, Robert, of Nonyngton, husbandman 0
3693057 1924035 1924035 defendant Draper John husbandman 593183 593183 Draper, John, of Nonyngton, husbandman 3
3711375 1929862 1929862 defendant Rye Thomas butcher 593183 593183 Rye, Thomas, of Nonyngton, butcher 0
3711376 1929862 1929862 defendant Wrake William husbandman 593183 593183 Wrake, William, of Nonyngton, husbandman 1
3745173 1940395 1940395 defendant Howlett John husbandman 593183 593183 Howlett, John, of Nonyngton, husbandman 1
3751464 1942375 1942375 defendant Broun David husbandman 593183 593183 Broun, David, of Nonyngton, husbandman 2
3751476 1942378 1942378 defendant Sayer John (legal representative) 593183 593183 Sayer, John, of Nonyngton, husbandman, executrix of 3
3751477 1942378 1942378 defendant Sayer Agnes widow 593183 593183 Sayer, Agnes, of Nonyngton, widow 4
3757871 1944441 1944441 defendant Howlett John husbandman 593183 593183 Howlett, John, of Nonyngton, husbandman 1
3781332 1951904 1951904 defendant Rye Thomas butcher 593183 593183 Rye, Thomas, of Nonyngton, butcher 2
3791948 1955329 1955329 defendant Fenett John yeoman 593183 593183 Fenett, John, of Nonyngton, yeoman 0
3834512 1968737 1968737 defendant Fynett John husbandman 593183 593183 Fynett, John, of Nonyngton, husbandman 1
3853041 1974570 1974570 defendant Fynet John husbandman 593183 593183 Fynet, John, of Nonyngton, husbandman 0
3899574 1990076 1990076 defendant Moket Richard yeoman 593183 593183 Moket, Richard, of Nonyngton, yeoman 0
3910091 1993683 1993683 plaintiff Stuppell William husbandman 593183 593183 Stuppell, William, of Nonyngton, husbandman 0
3923901 1998306 1998306 defendant Welshe Robert husbandman 593183 593183 Welshe, Robert, of Nonyngton, husbandman 1
3923902 1998306 1998306 defendant Belk Mathew yeoman 593183 593183 Belk, Mathew, of Nonyngton, yeoman 2
3923921 1998311 1998311 defendant Welshe Robert husbandman 593183 593183 Welshe, Robert, of Nonyngton, husbandman 1
3961894 2011254 2011254 defendant Watkyns David yeoman 593183 593183 Watkyns, David, of Nonyngton, yeoman 0
3968109 2013471 2013471 defendant Watkyns David yeoman 593183 593183 Watkyns, David, of Nonyngton, yeoman 0
4127163 2070004 2070004 defendant Brooke Edward gent 593183 593183 Brooke, Edward, of Nonyngton, gent 1
4199013 2095212 2095212 defendant Baylls Christopher clerk 593183 593183 Baylls, Christopher, of Nonyngton, clerk 0
4300438 2130256 2130256 defendant Conyngesby Gilbert gent 593183 593183 Conyngesby, Gilbert, of Nonyngton, gent 0
4311201 2134065 2134065 defendant Joad Andrew yeoman 593183 593183 Joad, Andrew, of Nonyngton, yeoman 1
4317063 2136081 2136081 defendant Engeham Edward gent 593183 593183 Engeham, Edward, of Nonyngton, gent 0
4593400 2229222 2229222 defendant Leche Thomas   593183 593183 Leche, Thomas, of Nonyngton 1
4642623 2243960 2243960 defendant Rand Roger   593183 593183 Rand, Roger, of Nonyngton 1
4642624 2243960 2243960 defendant Bet Thomas   593183 593183 Bet, Thomas, of Nonyngton 2
4679220 2259109 2259109 defendant Evodhewe Richard laborer 593183 593183 Evodhewe, Richard, of Nonyngton, laborer 0
4717728 2270880 2270880 defendant Davy John laborer 593183 593183 Davy, John, of Nonyngton, laborer 0
4717730 2270881 2270881 defendant Davy John laborer 593183 593183 Davy, John, of Nonyngton, laborer 0
4723743 2272729 2272729 defendant Orlaston John laborer 593183 593183 Orlaston, John, of Nonyngton, laborer 1
4743713 2278691 2278691 defendant Bengemyn Richard husbandman 593183 593183 Bengemyn, Richard, of Nonyngton, husbandman 0
4743714 2278691 2278691 defendant Bengemyn Thomas husbandman 593183 593183 Bengemyn, Thomas, of Nonyngton, husbandman 1
4822060 2302976 2302976 plaintiff Sempster Alice   593183 593183 Sempster, Alice, of Nonyngton 0
4859803 2314435 2314435 defendant atte Forde William husbabdman 593183 593183 (atte Forde, William, of Nonyngton, husbabdman 2
4884227 2321975 2321975 defendant Fyneux John gent 593183 593183 Fyneux, John, of Nonyngton, gent 0
4891047 2323941 2323941 defendant Beniamyn Richard   593183 593183 Beniamyn, Richard, of Nonyngton 0
4906550 2328634 2328634 defendant Ketyngton John yeoman 593183 593183 Ketyngton, John, of Nonyngton, yeoman 4
4911545 2330112 2330112 defendant Godehewe Richard   593183 593183 Godehewe, Richard, of Nonyngton, attorney 0
4911553 2330116 2330116 defendant Chamburleyn John   593183 593183 Chamburleyn, John, of Nonyngton, attorney 0
4911554 2330116 2330116 defendant Godehewe Richard husbandman 593183 593183 with Godehewe, Richard, of Nonyngton, husbandman 1
4918279 2332239 2332239 defendant Fyneux John esq 593183 593183 Fyneux, John, of Nonyngton, esq, on his own account 0
4922825 2333552 2333552 defendant Fyneux John esq 593183 593183 Fyneux, John, of Nonyngton, esq 0
4927776 2335124 2335124 defendant Fyneux John gent 593183 593183 Fyneux, John, of Nonyngton, gent 0
4937144 2337988 2337988 defendant Chamburleyn John   593183 593183 Chamburleyn, John, of Nonyngton, attorney 0
4937145 2337988 2337988 defendant Godehewe Richard husbandman 593183 593183 together with Godehewe, Richard, of Nonyngton, husbandman 1
4948114 2341383 2341383 defendant Fyneux John esq 593183 593183 Fyneux, John, of Nonyngton, esq 0
4958189 2344417 2344417 defendant Ketynton John husbandman 593183 593183 Ketynton, John, of Nonyngton, husbandman 2
4975215 2349542 2349542 defendant Ketyngton John husbandman 593183 593183 Ketyngton, John, of Nonyngton, husbandman 0
4984699 2352351 2352351 defendant Ketyngton John gent 593183 593183 Ketyngton, John, of Nonyngton, gent 1
5005341 2358464 2358464 defendant Marchall alias Marchaunt John gent 593183 593183 Marchall alias Marchaunt, John, of Nonyngton, gent 4
5031109 2365972 2365972 defendant Hachard William husbandman 593183 593183 Hachard, William, of Nonyngton, husbandman 2
5034353 2366905 2366905 defendant Bengemyn Peter husbandman 593183 593183 Bengemyn, Peter, of Nonyngton, husbandman 2
5037738 2367911 2367911 defendant Fyneux John esq 593183 593183 Fyneux, John, of Nonyngton, esq 0
5038667 2368211 2368211 defendant Abbot John yeoman 593183 593183 Abbot, John, of Nonyngton, yeoman 0
5051797 2372150 2372150 defendant Fyneux John esq 593183 593183 Fyneux, John, of Nonyngton, esq 0
5136102 2397070 2397070 defendant Stratton Richard husbandman 593183 593183 Stratton, Richard, of Nonyngton, husbandman 1
5179368 2409703 2409703 defendant Veryer William laborer 593183 593183 Veryer, William, of Nonyngton, laborer 1
5201863 2416311 2416311 defendant Veryer William laborer 593183 593183 Veryer, William, of Nonyngton, laborer 1
5227913 2423779 2423779 defendant atte Welle Thomas husbandman 593183 593183 atte Welle, Thomas, of Nonyngton, husbandman 0
5329140 2453792 2453792 defendant Brown Thomas yeoman 593183 593183 Brown, Thomas, of Nonyngton, yeoman 0
5341606 2457565 2457565 defendant Oxynden Thomas husbandman 593183 593183 Oxynden, Thomas, of Nonyngton, husbandman 0
5348450 2459655 2459655 defendant Hopday John husbandman 593183 593183 Hopday, John, of Nonyngton, husbandman 1
5354882 2461602 2461602 defendant Baker Robert husbandman 593183 593183 Baker, Robert, of Nonyngton, husbandman 0
5360181 2463226 2463226 defendant Broun Thomas husbandman 593183 593183 Broun, Thomas, of Nonyngton, husbandman 4
5373784 2467394 2467394 defendant Aylesbery Robert husbandman 593183 593183 Aylesbery, Robert, of Nonyngton, husbandman 0
5420210 2480963 2480963 defendant Penne Nicholas husbandman 593183 593183 Penne, Nicholas, of Nonyngton, husbandman 0
5430337 2484010 2484010 defendant Braboner Richard weaver 593183 593183 Braboner, Richard, of Nonyngton, weaver 1
5430339 2484010 2484010 defendant Blakhous William husbandman 593183 593183 (Blakhous, William, of Nonyngton, husbandman 3
5446936 2488978 2488978 defendant Roper John husbandman 593183 593183 Roper, John, of Nonyngton, husbandman 0
5446937 2488978 2488978 defendant Braboner Richard weaver 593183 593183 Braboner, Richard, of Nonyngton, weaver 1
5486199 2500762 2500762 defendant Bowys James clerk 593183 593183 Bowys, James, of Nonyngton, clerk 0
5496044 2503707 2503707 defendant Best Thomas husbandman 593183 593183 Best, Thomas, of Nonyngton, husbandman 5
5511016 2508285 2508285 defendant Best Thomas husbandman 593183 593183 Best, Thomas, of Nonyngton, husbandman 3
5521309 2511482 2511482 defendant Hykke William husbandman 593183 593183 Hykke, William, of Nonyngton, husbandman 0
5543953 2518219 2518219 defendant Quylter Simon husbandman 593183 593183 Quylter, Simon, of Nonyngton, husbandman 1
5543956 2518219 2518219 defendant Stopell Peter husbandman 593183 593183 Stopell, Peter, of Nonyngton, husbandman 4
5588544 2531422 2531422 defendant Hambroke William husbandman 593183 593183 Hambroke, William, of Nonyngton, husbandman 2
5631875 2553988 2553988 defendant Bynge Stephen husbandman 593183 593183 Bynge, Stephen, of Nonyngton, 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);