names

108 rows where place_id = 600991

✎ 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
3643440 1908374 1908374 defendant Cartewright George smith 600991 600991 Cartewright, George, of Wolaston, smith 0
3645831 1909100 1909100 defendant Hagley John husbandman 600991 600991 Hagley, John, of Wolaston, husbandman 1
3857249 1975901 1975901 defendant Thornes Thomas gent 600991 600991 Thornes, Thomas, of Wolaston, gent 0
3902674 1991126 1991126 defendant Davys Morris husbandman 600991 600991 Davys, Morris, of Wolaston, husbandman 1
3930297 2000481 2000481 defendant Jamys Robert husbandman 600991 600991 Jamys, Robert, of Wolaston, husbandman 0
3930299 2000481 2000481 defendant Yagge John laborer 600991 600991 Yagge, John, of Wolaston, laborer 2
3961603 2011158 2011158 defendant Mayor John husbandman 600991 600991 Mayor, John, of Wolaston, husbandman 0
4040920 2039241 2039241 defendant Maddock Thomas gent 600991 600991 Maddock, Thomas, of Wolaston, gent 0
4439734 2181700 2181700 defendant Elyot Ralph   600991 600991 Elyot, Ralph, of Wolaston 2
4440549 2181956 2181956 defendant Elyot Ralph   600991 600991 Elyot, Ralph, of Wolaston 2
4446777 2183908 2183908 defendant Bedell William butcher 600991 600991 Bedell, William, of Wolaston, butcher 0
4486993 2196651 2196651 defendant Carter William   600991 600991 Carter, William, of Wolaston 1
4518106 2206035 2206035 defendant Kyngusman William, sen   600991 600991 Kyngusman, William, sen, of Wolaston 0
4537561 2212023 2212023 plaintiff Taillour Henry   600991 600991 Taillour, Henry, of Wolaston 0
4537563 2212024 2212024 plaintiff Taillour Henry   600991 600991 Taillour, Henry, of Wolaston 0
4588644 2227824 2227824 plaintiff Kyngesman William   600991 600991 Kyngesman, William, of Wolaston 0
4588648 2227824 2227824 defendant Herde Adam   600991 600991 Herde, Adam, of Wolaston 3
4588649 2227824 2227824 defendant Bodyngton John   600991 600991 Bodyngton, John, of Wolaston 4
4588650 2227825 2227825 plaintiff Kyngesman William   600991 600991 Kyngesman, William, of Wolaston 0
4650722 2246229 2246229 plaintiff Wyllughby Hugh   600991 600991 Wyllughby, Hugh, of Wolaston 0
4656113 2247792 2247792 plaintiff Bydell John   600991 600991 Bydell, John, of Wolaston 0
4669165 2256062 2256062 defendant Gauge Adam husbandman 600991 600991 Gauge, Adam, of Wolaston, husbandman 0
4669266 2256095 2256095 defendant Haweyn Lawrence husbandman 600991 600991 Haweyn, Lawrence, of Wolaston, husbandman 0
4714051 2269723 2269723 defendant Everdon William drover 600991 600991 Everdon, William, of Wolaston, drover 1
4728968 2274299 2274299 plaintiff Kyngesman William (legal representative) 600991 600991 Kyngesman, William, of Wolaston, executors of 0
4728969 2274299 2274299 plaintiff Kyngesman Elizabeth   600991 600991 (Kyngesman, Elizabeth, of Wolaston, formerly wife of William 1
4739201 2277355 2277355 plaintiff Wyllughby Hugh esq 600991 600991 Wyllughby, Hugh, of Wolaston, esq 0
4740727 2277806 2277806 defendant Bedell Thomas merchant 600991 600991 Bedell, Thomas, of Wolaston, merchant 1
4745846 2279289 2279289 defendant Pakke John husbandman 600991 600991 Pakke, John, of Wolaston, husbandman 0
4761870 2284055 2284055 defendant Talpe Robert chapman 600991 600991 Talpe, Robert, of Wolaston, chapman 3
4774019 2287857 2287857 defendant Smethe John husbandman 600991 600991 Smethe, John, of Wolaston, husbandman 0
4774020 2287857 2287857 defendant Gewyn William husbandman 600991 600991 Gewyn, William, of Wolaston, husbandman 1
4794991 2294575 2294575 defendant Wedee Robert (legal representative) 600991 600991 Wedee, Robert, of Wolaston, executrix of 0
4799461 2296012 2296012 defendant Smethe John husbandman 600991 600991 Smethe, John, of Wolaston, husbandman 0
4829868 2305387 2305387 plaintiff Bedell John   600991 600991 Bedell, John, of Wolaston 0
4829869 2305387 2305387 plaintiff Andrewe Stephen   600991 600991 Andrewe, Stephen, of Wolaston 1
4829871 2305388 2305388 plaintiff Bedell John, sen   600991 600991 Bedell, John, sen, of Wolaston 0
4829872 2305388 2305388 plaintiff Bedell Thomas   600991 600991 Bedell, Thomas, of Wolaston 1
4830943 2305703 2305703 plaintiff Bovell John   600991 600991 Bovell, John, of Wolaston 0
4830944 2305703 2305703 plaintiff Andrewe Stephen   600991 600991 Andrewe, Stephen, of Wolaston 1
4849944 2311456 2311456 defendant Corbet Thomas esq 600991 600991 (Corbet, Thomas, of Wolaston, esq 1
4861178 2314857 2314857 defendant Bapty John husbandman 600991 600991 Bapty, John, of Wolaston, husbandman 0
4865934 2316318 2316318 defendant Pakke John husbandman 600991 600991 Pakke, John, of Wolaston, husbandman 0
4878486 2320215 2320215 defendant Bedyll John, senior woolman 600991 600991 Bedyll, John, senior, of Wolaston, woolman 0
4878487 2320215 2320215 defendant Bedyll Thomas gent 600991 600991 Bedyll, Thomas, of Wolaston, gent 1
4890090 2323678 2323678 defendant Shipman Geoffrey mariner 600991 600991 Shipman, Geoffrey, of Wolaston, mariner 0
4892994 2324532 2324532 defendant Talpe Robert chapman 600991 600991 Talpe, Robert, of Wolaston, chapman 2
4921826 2333239 2333239 defendant Addecok Thomas wheeler 600991 600991 Addecok, Thomas, of Wolaston, wheeler 4
4948858 2341626 2341626 defendant Lake William husbandman 600991 600991 Lake, William, of Wolaston, husbandman 0
4974651 2349385 2349385 defendant Duffeld Thomas husbandman 600991 600991 Duffeld, Thomas, of Wolaston, husbandman 4
5001015 2357174 2357174 defendant Lybard John husbandman 600991 600991 Lybard, John, of Wolaston, husbandman 0
5038288 2368091 2368091 defendant Brygge William laborer 600991 600991 Brygge, William, of Wolaston, laborer 2
5045685 2370344 2370344 defendant Lyttelbury John yeoman 600991 600991 Lyttelbury, John, of Wolaston, yeoman 0
5046355 2370546 2370546 defendant Tylly John   600991 600991 Tylly, John, of Wolaston, mason 1
5062053 2375208 2375208 defendant Lamport Ralph gent 600991 600991 Lamport, Ralph, of Wolaston, gent 0
5070109 2377554 2377554 defendant Lytelbury John yeoman 600991 600991 Lytelbury, John, of Wolaston, yeoman 0
5070111 2377554 2377554 defendant Drynkewell William husbandman 600991 600991 Drynkewell, William, of Wolaston, husbandman 2
5071484 2377967 2377967 defendant Lyttilbury John yeoman 600991 600991 Lyttilbury, John, of Wolaston, yeoman 0
5072396 2378232 2378232 defendant Pakke William husbandman 600991 600991 Pakke, William, of Wolaston, husbandman 1
5072397 2378232 2378232 defendant Valens Reginald husbandman 600991 600991 Valens, Reginald, of Wolaston, husbandman 2
5088947 2383143 2383143 defendant Lytylbury John yeoman 600991 600991 Lytylbury, John, of Wolaston, yeoman 0
5088948 2383143 2383143 defendant Lebard John husbandman 600991 600991 Lebard, John, of Wolaston, husbandman 1
5088949 2383143 2383143 defendant Hareet John husbandman 600991 600991 Hareet, John, of Wolaston, husbandman 2
5088950 2383143 2383143 defendant Smyth Roger husbandman 600991 600991 Smyth, Roger, of Wolaston, husbandman 3
5261349 2433658 2433658 defendant Bolnowe John carter 600991 600991 Bolnowe, John, of Wolaston, carter 2
5276292 2438138 2438138 defendant Bolnowe John husbandman 600991 600991 Bolnowe, John, of Wolaston, husbandman 0
5285140 2440678 2440678 defendant Morley William clerk 600991 600991 Morley, William, of Wolaston, clerk 1
5285141 2440678 2440678 defendant Pakke William husbadman 600991 600991 Pakke, William, of Wolaston, husbadman 2
5285142 2440678 2440678 defendant Bolne John husbandman 600991 600991 Bolne, John, of Wolaston, husbandman 3
5285143 2440678 2440678 defendant Andrewe John butcher 600991 600991 Andrewe, John, of Wolaston, butcher 4
5285144 2440678 2440678 defendant Gefferay William weaver 600991 600991 Gefferay, William, of Wolaston, weaver 5
5285145 2440678 2440678 defendant Wylymot John husbandman 600991 600991 Wylymot, John, of Wolaston, husbandman 6
5285146 2440678 2440678 defendant Grene John husbandman 600991 600991 Grene, John, of Wolaston, husbandman 7
5285147 2440678 2440678 defendant Ever John husbandman 600991 600991 Ever, John, of Wolaston, husbandman 8
5291292 2442457 2442457 defendant Mase John husbandman 600991 600991 Mase, John, of Wolaston, husbandman 0
5291293 2442457 2442457 defendant Haryet William husbandman 600991 600991 Haryet, William, of Wolaston, husbandman 1
5291294 2442457 2442457 defendant Bolno John husbandman 600991 600991 Bolno, John, of Wolaston, husbandman 2
5291295 2442457 2442457 defendant Ley John husbandman 600991 600991 Ley, John, of Wolaston, husbandman 3
5291296 2442457 2442457 defendant Toyton Thomas husbandman 600991 600991 Toyton, Thomas, of Wolaston, husbandman 4
5310542 2448189 2448189 defendant Pakke William husbandman 600991 600991 Pakke, William, of Wolaston, husbandman 2
5310544 2448189 2448189 defendant Bolneho John yeoman 600991 600991 Bolneho, John, of Wolaston, yeoman 4
5312647 2448820 2448820 defendant Hochyn William, senior husbandman 600991 600991 Hochyn, William, senior, of Wolaston, husbandman 0
5312648 2448820 2448820 defendant Hochyn William, junior husbandman 600991 600991 Hochyn, William, junior, of Wolaston, husbandman 1
5312649 2448820 2448820 defendant Hochyn John laborer 600991 600991 Hochyn, John, of Wolaston, laborer 2
5331651 2454550 2454550 defendant Bolnowe John husbandman 600991 600991 Bolnowe, John, of Wolaston, husbandman 0
5331657 2454553 2454553 defendant Bolnowe John husbandman 600991 600991 Bolnowe, John, of Wolaston, husbandman 0
5331968 2454636 2454636 defendant Packe William husbandman 600991 600991 Packe, William, of Wolaston, husbandman 0
5331969 2454636 2454636 defendant Hochon William, senior husbandman 600991 600991 Hochon, William, senior, of Wolaston, husbandman 1
5331970 2454636 2454636 defendant Hochon William, junior husbandman 600991 600991 Hochon, William, junior, of Wolaston, husbandman 2
5331971 2454636 2454636 defendant Hochon Thomas husbandman 600991 600991 Hochon, Thomas, of Wolaston, husbandman 3
5335582 2455715 2455715 defendant Bolney Thomas husbandman 600991 600991 Bolney, Thomas, of Wolaston, husbandman 0
5335583 2455715 2455715 defendant Bolney John husbandman 600991 600991 Bolney, John, of Wolaston, husbandman 1
5335584 2455715 2455715 defendant Andrewe John husbandman 600991 600991 Andrewe, John, of Wolaston, husbandman 2
5339935 2457060 2457060 defendant Bolno John husbandman 600991 600991 Bolno, John, of Wolaston, husbandman 1
5339936 2457060 2457060 defendant Andrewe John butcher 600991 600991 Andrewe, John, of Wolaston, butcher 2
5339938 2457061 2457061 defendant Packe William husbandman 600991 600991 Packe, William, of Wolaston, husbandman 0
5339939 2457061 2457061 defendant Bolno John husbandman 600991 600991 Bolno, John, of Wolaston, husbandman 1
5339940 2457061 2457061 defendant Andrewe John butcher 600991 600991 Andrewe, John, of Wolaston, butcher 2
5345200 2458668 2458668 defendant Andrewe John butcher 600991 600991 Andrewe, John, of Wolaston, butcher 1
5376335 2468195 2468195 defendant Packe John husbandman 600991 600991 Packe, John, of Wolaston, 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);