names

172 rows where place_id = 590873

✎ 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
3602573 1868466 1868466 plaintiff Cappe Thomas gent 590873 590873 Cappe, Thomas, of Normanton, gent 0
3602576 1868467 1868467 plaintiff Cappe Thomas gent 590873 590873 Cappe, Thomas, of Normanton, gent 0
3602579 1868468 1868468 plaintiff Cappe Thomas gent 590873 590873 Cappe, Thomas, of Normanton, gent 0
3619224 1873614 1873614 defendant Malet William gent 590873 590873 Malet, William, of Normanton, gent 0
3626475 1903136 1903136 defendant Thorpe Richard husbandman 590873 590873 Thorpe, Richard, of Normanton, husbandman 3
3630300 1904324 1904324 defendant Levet William gent 590873 590873 Levet, William, of Normanton, gent 2
3630731 1904435 1904435 defendant Wyng Thomas chaplain 590873 590873 Wyng, Thomas, of Normanton, chaplain 4
3638041 1906716 1906716 defendant Symson Nicholas husbandman 590873 590873 Symson, Nicholas, of Normanton, husbandman 0
3656787 1912377 1912377 defendant Saunder Thomas laborer 590873 590873 Saunder, Thomas, of Normanton, laborer 1
3670765 1916817 1916817 defendant Turnell Thomas smith 590873 590873 Turnell, Thomas, of Normanton, smith 1
3691327 1923447 1923447 defendant Tompson John yeoman 590873 590873 Tompson, John, of Normanton, yeoman 1
3704942 1927838 1927838 plaintiff Grandorge Humphrey   590873 590873 Grandorge, Humphrey, of Normanton 0
3708139 1928844 1928844 defendant Lake Margaret widow 590873 590873 Lake, Margaret, of Normanton, widow 0
3711308 1929841 1929841 defendant Wright Robert chapman 590873 590873 Wright, Robert, of Normanton, chapman 2
3712759 1930307 1930307 defendant Schoter William clerk 590873 590873 Schoter, William, of Normanton, clerk 0
3721332 1932979 1932979 defendant Alwod William husbandman 590873 590873 Alwod, William, of Normanton, husbandman 0
3739037 1938416 1938416 defendant Nayllour John husbandman 590873 590873 Nayllour, John, of Normanton, husbandman 0
3756699 1944068 1944068 defendant Alwood Robert husbandman 590873 590873 Alwood, Robert, of Normanton, husbandman 0
3756703 1944069 1944069 defendant Bawdewyn Henry husbandman 590873 590873 Bawdewyn, Henry, of Normanton, husbandman 0
3771574 1948808 1948808 defendant Unwyn William husbandman 590873 590873 Unwyn, William, of Normanton, husbandman 0
3780163 1951519 1951519 defendant Lyttylborowe Lawrence husbandman 590873 590873 Lyttylborowe, Lawrence, of Normanton, husbandman 0
3812001 1961661 1961661 defendant (not given) Richard vicar of Litelburgh 590873 590873 Litelburgh, Richard, of Normanton, vicar of Cotun, Notts 0
3819790 1964070 1964070 defendant Castell Richard husbandman 590873 590873 Castell, Richard, of Normanton, husbandman 0
3819792 1964071 1964071 defendant Castell Richard husbandman 590873 590873 Castell, Richard, of Normanton, husbandman 0
3821514 1964624 1964624 defendant Erby John miller 590873 590873 Erby, John, of Normanton, miller 0
3908781 1993232 1993232 defendant Eyre George gent 590873 590873 Eyre, George, of Normanton, gent 0
3924344 1998450 1998450 defendant Cappe John gent 590873 590873 Cappe, John, of Normanton, gent 0
3937228 2002782 2002782 defendant Nayler Guy husbandman 590873 590873 Nayler, Guy, of Normanton, husbandman 0
3964683 2012254 2012254 defendant Spycer William   590873 590873 Spycer, William, of Normanton, gent, or of Quarndon, Leics 0
4015624 2030285 2030285 defendant Hardwicke William yeoman 590873 590873 Hardwicke, William, of Normanton, yeoman 0
4024238 2033372 2033372 defendant Clarke George clerk 590873 590873 Clarke, George, of Normanton, clerk 0
4052376 2043271 2043271 defendant Lake John gent 590873 590873 Lake, John, of Normanton, gent 1
4052379 2043272 2043272 defendant Lake John gent 590873 590873 Lake, John, of Normanton, gent 1
4059157 2045675 2045675 defendant Fowler Richard yeoman 590873 590873 Fowler, Richard, of Normanton, yeoman 0
4071968 2050272 2050272 defendant Hardwyke William yeoman 590873 590873 Hardwyke, William, of Normanton, yeoman 0
4071970 2050273 2050273 defendant Clerke George clerk 590873 590873 Clerke, George, of Normanton, clerk 0
4071972 2050273 2050273 defendant Hardwycke William yeoman 590873 590873 Hardwycke, William, of Normanton, yeoman 2
4084891 2054874 2054874 defendant Clarke George clerk 590873 590873 Clarke, George, of Normanton, clerk 0
4084892 2054874 2054874 defendant Clarke William husbandman 590873 590873 Clarke, William, of Normanton, husbandman 1
4093802 2058107 2058107 defendant Clarke George clerk 590873 590873 Clarke, George, of Normanton, clerk 0
4093803 2058107 2058107 defendant Clarke William husbandman 590873 590873 Clarke, William, of Normanton, husbandman 1
4096608 2059114 2059114 defendant Mallett Alice widow 590873 590873 Mallett, Alice, of Normanton, widow 1
4115940 2065987 2065987 defendant Wright John yeoman 590873 590873 Wright, John, of Normanton, yeoman 0
4116481 2066183 2066183 defendant Hardwicke William gent 590873 590873 Hardwicke, William, of Normanton, gent 1
4135501 2073019 2073019 defendant Clarke Richard, junior husbandman 590873 590873 Clarke, Richard, junior, of Normanton, husbandman 0
4167671 2084187 2084187 defendant Mallett John gent 590873 590873 Mallett, John, of Normanton, gent 1
4189845 2091945 2091945 defendant Watkynson Robert yeoman 590873 590873 Watkynson, Robert, of Normanton, yeoman 0
4215926 2101067 2101067 defendant Stevenson William yeoman 590873 590873 Stevenson, William, of Normanton, yeoman 2
4215931 2101068 2101068 defendant Stevenson William yeoman 590873 590873 Stevenson, William, of Normanton, yeoman 2
4261299 2116746 2116746 defendant Jumper William gent 590873 590873 Jumper, William, of Normanton, gent 0
4289177 2126184 2126184 defendant Cappe Christopher gent 590873 590873 Cappe, Christopher, of Normanton, gent administratrix of 0
4310225 2133731 2133731 defendant Oswell John husbandman 590873 590873 Oswell, John, of Normanton, husbandman 1
4314881 2135319 2135319 defendant Laike Lancelot gent 590873 590873 Laike, Lancelot, of Normanton, gent 1
4333946 2141637 2141637 defendant Deane Brian clerk 590873 590873 Deane, Brian, of Normanton, clerk 1
4353281 2148375 2148375 defendant Nayler George yeoman 590873 590873 Nayler, George, of Normanton, yeoman 0
4392355 2162069 2162069 defendant Nayler George yeoman 590873 590873 Nayler, George, of Normanton, yeoman 2
4400056 2164606 2164606 defendant Tampion Henry clerk 590873 590873 Tampion, Henry, of Normanton, clerk 1
4435405 2175829 2175829 defendant Barker William   590873 590873 Barker, William, of Normanton 0
4438194 2181244 2181244 defendant Jouce or Jonce Robert   590873 590873 Jouce or Jonce, Robert, of Normanton 0
4439220 2181544 2181544 defendant Jouce Robert   590873 590873 Jouce, Robert, of Normanton 0
4445488 2183545 2183545 defendant Pye George   590873 590873 Pye, George, of Normanton 0
4445489 2183545 2183545 defendant Grayne Robert   590873 590873 Grayne, Robert, of Normanton 1
4445490 2183545 2183545 defendant Maynard John   590873 590873 Maynard, John, of Normanton 2
4445491 2183545 2183545 defendant Waryn John   590873 590873 Waryn, John, of Normanton 3
4445492 2183545 2183545 defendant del Welle John   590873 590873 del Welle, John, of Normanton 4
4445493 2183545 2183545 defendant Housom Robert   590873 590873 Housom, Robert, of Normanton 5
4453462 2186089 2186089 defendant Joice Robert   590873 590873 Joice, Robert, of Normanton 2
4455186 2186624 2186624 defendant Chaumberleyn William   590873 590873 Chaumberleyn, William, of Normanton 1
4455188 2186624 2186624 defendant Carter Richard   590873 590873 Carter, Richard, of Normanton 3
4487109 2196692 2196692 defendant Calale William   590873 590873 Calale, William, of Normanton 1
4489949 2197565 2197565 plaintiff Turvyll Ralph   590873 590873 Turvyll, Ralph, of Normanton 0
4501247 2200994 2200994 defendant (illegible) John or Joan   590873 590873 ----, John or Joan, of Normanton 1
4503254 2201583 2201583 defendant Huddeson Robert   590873 590873 Huddeson, Robert, of Normanton 1
4505438 2202230 2202230 plaintiff Spregonell William   590873 590873 Spregonell, William, of Normanton, parson 0
4510456 2203729 2203729 defendant Crosseby Robert   590873 590873 Crosseby, Robert, of Normanton 0
4510458 2203730 2203730 defendant Crosseby Roger   590873 590873 Crosseby, Roger, of Normanton 0
4514428 2204930 2204930 plaintiff Calall William ce   590873 590873 Calall, William ce, of Normanton 0
4518252 2206084 2206084 defendant Stayneston John, sen   590873 590873 Stayneston, John, sen, of Normanton 0
4518254 2206084 2206084 defendant Cook John   590873 590873 Cook, John, of Normanton 2
4518255 2206084 2206084 defendant Frere Thomas   590873 590873 Frere, Thomas, of Normanton 3
4518256 2206084 2206084 defendant Herteshorne John   590873 590873 Herteshorne, John, of Normanton 4
4545109 2214389 2214389 defendant Crosseby Roger   590873 590873 Crosseby, Roger, of Normanton 0
4562083 2219706 2219706 plaintiff Plasterer Thomas   590873 590873 Plasterer, Thomas, of Normanton 0
4578329 2224712 2224712 plaintiff Claypole John   590873 590873 Claypole, John, of Normanton, parson 0
4584071 2226438 2226438 defendant Steveneson John   590873 590873 Steveneson, John, of Normanton 1
4584076 2226438 2226438 defendant Stevenson Henry   590873 590873 Stevenson, Henry, of Normanton 6
4595298 2229781 2229781 defendant Love John   590873 590873 Love, John, of Normanton 1
4602306 2231938 2231938 defendant Graveley Henry de   590873 590873 Graveley, Henry de, of Normanton 0
4620104 2237270 2237270 plaintiff Hunt John   590873 590873 Hunt, John, of Normanton 0
4643230 2244130 2244130 defendant Melton William   590873 590873 Melton, William, of Normanton 1
4643234 2244131 2244131 defendant Pope William   590873 590873 Pope, William, of Normanton 2
4643235 2244131 2244131 defendant Habard John   590873 590873 Habard, John, of Normanton 3
4643243 2244131 2244131 defendant Melton William   590873 590873 Melton, William, of Normanton 11
4643557 2244217 2244217 defendant Normanton Geoffrey   590873 590873 Normanton, Geoffrey, of Normanton 4
4665167 2250589 2250589 defendant Ivenet John, senior husbandman 590873 590873 Ivenet, John, senior, of Normanton, husbandman 0
4669338 2256117 2256117 defendant Wade Robert smith 590873 590873 Wade, Robert, of Normanton, smith 0
4669339 2256117 2256117 defendant Helwys Robert husbandman 590873 590873 Helwys, Robert, of Normanton, husbandman 1
4669340 2256117 2256117 defendant Burstall John   590873 590873 Burstall, John, of Normanton, franklin 2
4674802 2257732 2257732 defendant Baker Thomas husbandman 590873 590873 Baker, Thomas, of Normanton, husbandman 4
4676825 2258369 2258369 defendant Webster Ralph husbandman 590873 590873 Webster, Ralph, of Normanton, husbandman 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);