names

71 rows where place_id = 600475

✎ 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
3641172 1907689 1907689 defendant Hargill Robert husbandman 600475 600475 Hargill, Robert, of Wistowe, husbandman 0
3649295 1910169 1910169 defendant Colson Robert yeoman 600475 600475 Colson, Robert, of Wistowe, yeoman 0
3685438 1921596 1921596 defendant Dracotes William (legal representative) 600475 600475 Dracotes, William, of Wistowe, gent, executors of 0
3685439 1921596 1921596 defendant Cokson Amery gent 600475 600475 (Cokson, Amery, of Wistowe, gent 1
3685440 1921596 1921596 defendant Ashton Oliver gent 600475 600475 Ashton, Oliver, of Wistowe, gent 2
3716273 1931383 1931383 defendant Man Thomas yeoman 600475 600475 Man, Thomas, of Wistowe, yeoman 0
3716274 1931383 1931383 defendant Barker Thomas yeoman 600475 600475 Barker, Thomas, of Wistowe, yeoman 1
3716275 1931383 1931383 defendant Atkynson Robert yeoman 600475 600475 Atkynson, Robert, of Wistowe, yeoman 2
3770895 1948585 1948585 defendant Harreson Robert husbandman 600475 600475 Harreson, Robert, of Wistowe, husbandman 0
3797708 1957181 1957181 defendant Cokson Ambrose gent 600475 600475 Cokson, Ambrose, of Wistowe, gent 0
3822304 1964881 1964881 defendant Burton Roger gent 600475 600475 Burton, Roger, of Wistowe, gent 0
3822305 1964881 1964881 defendant Camage William laborer 600475 600475 Camage, William, of Wistowe, laborer 1
4001389 2025275 2025275 defendant Laurence John laborer 600475 600475 Laurence, John, of Wistowe, laborer 0
4141009 2075014 2075014 defendant Wallis William husbandman 600475 600475 Wallis, William, of Wistowe, husbandman 0
4141010 2075014 2075014 defendant Addisond Peter laborer 600475 600475 Addisond, Peter, of Wistowe, laborer 1
4158138 2080915 2080915 defendant Yonge Thomas husbandman 600475 600475 Yonge, Thomas, of Wistowe, husbandman 0
4196736 2094405 2094405 defendant Wakefyld Thomas husbandman 600475 600475 Wakefyld, Thomas, of Wistowe, husbandman 1
4224238 2103966 2103966 defendant Teyler John gent 600475 600475 Teyler, John, of Wistowe, gent 0
4241124 2110017 2110017 defendant Towrye Miles yeoman 600475 600475 Towrye, Miles, of Wistowe, yeoman 0
4250046 2112997 2112997 defendant Shipman John laborer 600475 600475 Shipman, John, of Wistowe, laborer 0
4255989 2114980 2114980 defendant Wollans George yeoman 600475 600475 Wollans, George, of Wistowe, yeoman 0
4268329 2119010 2119010 defendant Wolland George yeoman 600475 600475 Wolland, George, of Wistowe, yeoman 0
4284434 2124483 2124483 defendant Tayler John gent 600475 600475 Tayler, John, of Wistowe, gent 0
4311288 2134094 2134094 defendant Mann Thomas yeoman 600475 600475 Mann, Thomas, of Wistowe, yeoman 2
4316426 2135862 2135862 defendant Dickonson Richard tailor 600475 600475 Dickonson, Richard, of Wistowe, tailor 2
4320262 2137189 2137189 defendant Skelton Peter gent 600475 600475 Skelton, Peter, of Wistowe, gent 0
4320263 2137189 2137189 defendant Towrie Miles yeoman 600475 600475 Towrie, Miles, of Wistowe, yeoman 1
4320520 2137271 2137271 defendant Howley or Hawley Thomas husbandman 600475 600475 Howley or Hawley, Thomas, of Wistowe, husbandman 0
4321335 2137553 2137553 defendant Knowles Edward laborer 600475 600475 Knowles, Edward, of Wistowe, laborer 0
4321351 2137560 2137560 defendant Beverley Thomas, junior gent 600475 600475 Beverley, Thomas, junior, of Wistowe, gent 0
4355920 2149288 2149288 defendant Nelson Jasper yeoman 600475 600475 Nelson, Jasper, of Wistowe, yeoman 0
4355922 2149289 2149289 defendant Wilkinson John yeoman 600475 600475 Wilkinson, John, of Wistowe, yeoman 0
4385319 2159781 2159781 defendant Beverley Thomas gent 600475 600475 Beverley, Thomas, of Wistowe, gent 0
4385324 2159783 2159783 defendant Beverley John gent 600475 600475 Beverley, John, of Wistowe, gent 0
4389497 2161114 2161114 defendant Tayler John gent 600475 600475 Tayler, John, of Wistowe, gent 0
4401253 2165012 2165012 defendant Man Thomas yeoman 600475 600475 Man, Thomas, of Wistowe, yeoman 0
4485214 2196079 2196079 plaintiff Pulter Richard   600475 600475 Pulter, Richard, of Wistowe 0
4581968 2225804 2225804 defendant Ragull John   600475 600475 Ragull, John, of Wistowe 9
4594284 2229473 2229473 defendant Pulter Richard   600475 600475 Pulter, Richard, of Wistowe 3
4649830 2245972 2245972 defendant Derworthy Wiliam   600475 600475 Derworthy, Wiliam, of Wistowe 8
5163066 2404924 2404924 defendant Graunt William husbandman 600475 600475 Graunt, William, of Wistowe, husbandman 3
5213467 2419671 2419671 defendant Barley William husbandman 600475 600475 Barley, William, of Wistowe, husbandman 0
5213468 2419671 2419671 defendant Dudmon John husbandman 600475 600475 Dudmon, John, of Wistowe, husbandman 1
5213469 2419671 2419671 defendant More John husbandman 600475 600475 More, John, of Wistowe, husbandman 2
5213470 2419671 2419671 defendant Leeke Robert husbandman 600475 600475 Leeke, Robert, of Wistowe, husbandman 3
5213474 2419673 2419673 defendant Taury Christopher husbandman 600475 600475 Taury, Christopher, of Wistowe, husbandman 0
5213475 2419673 2419673 defendant Barley Robert husbandman 600475 600475 Barley, Robert, of Wistowe, husbandman 1
5309926 2448005 2448005 defendant Gower George   600475 600475 Gower, George, of Wistowe 0
5420402 2481027 2481027 defendant Dyconson Thomas   600475 600475 Dyconson, Thomas, of Wistowe, vicar 0
5420403 2481027 2481027 defendant Darley Richard yeoman 600475 600475 Darley, Richard, of Wistowe, yeoman 1
5420404 2481027 2481027 defendant Dyconson Alexander yeoman 600475 600475 Dyconson, Alexander, of Wistowe, yeoman 2
5439221 2486659 2486659 defendant Diconson Thomas clerk 600475 600475 Diconson, Thomas, of Wistowe, clerk 0
5439222 2486659 2486659 defendant Darley John yeoman 600475 600475 Darley, John, of Wistowe, yeoman 1
5439223 2486659 2486659 defendant Diconson Alexander yeoman 600475 600475 Diconson, Alexander, of Wistowe, yeoman 2
5453066 2490798 2490798 defendant Diconson Thomas clerk 600475 600475 Diconson, Thomas, of Wistowe, clerk 0
5453067 2490798 2490798 defendant Dorley John yeoman 600475 600475 Dorley, John, of Wistowe, yeoman 1
5453068 2490798 2490798 defendant Derley Alexander yeoman 600475 600475 Derley, Alexander, of Wistowe, yeoman 2
5473202 2496944 2496944 defendant Fox William gent 600475 600475 Fox, William, of Wistowe, gent 0
5476508 2497979 2497979 defendant Derley Richard yeoman 600475 600475 Derley, Richard, of Wistowe, yeoman 0
5488080 2501326 2501326 defendant Derley Richard yeoman 600475 600475 Derley, Richard, of Wistowe, yeoman 0
5542925 2517906 2517906 defendant Carleton John husbandman 600475 600475 Carleton, John, of Wistowe, husbandman 0
5542926 2517906 2517906 defendant Rauson or Ranson William husbandman 600475 600475 Rauson or Ranson, William, of Wistowe, husbandman 1
5542927 2517906 2517906 defendant Barker William, junior husbandman 600475 600475 Barker, William, junior, of Wistowe, husbandman 2
5542928 2517906 2517906 defendant Leyke John husbandman 600475 600475 Leyke, John, of Wistowe, husbandman 3
5542931 2517907 2517907 defendant Colyngworth John husbandman 600475 600475 Colyngworth, John, of Wistowe, husbandman 0
5542932 2517907 2517907 defendant Barker Robert husbandman 600475 600475 Barker, Robert, of Wistowe, husbandman 1
5542933 2517907 2517907 defendant Spenser John husbandman 600475 600475 Spenser, John, of Wistowe, husbandman 2
5542934 2517907 2517907 defendant Bell Henry husbandman 600475 600475 Bell, Henry, of Wistowe, husbandman 3
5542935 2517907 2517907 defendant Tyler Simon husbandman 600475 600475 Tyler, Simon, of Wistowe, husbandman 4
5595695 2533573 2533573 defendant Schesing Thomas butcher 600475 600475 Schesing, Thomas, of Wistowe, butcher 1
5595697 2533573 2533573 defendant Burton Robert dyer 600475 600475 Burton, Robert, of Wistowe, dyer 3

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);