names

99 rows where place_id = 589773

✎ 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
3598691 1867215 1867215 defendant Connesdewe John, junior husbandman 589773 589773 Connesdewe, John, junior, of Wodeford, husbandman 2
3638408 1906834 1906834 defendant More Thomas miller 589773 589773 More, Thomas, of Wodeford, miller 0
3638583 1906883 1906883 defendant Bradley Thomas butcher 589773 589773 Bradley, Thomas, of Wodeford, butcher 3
3638584 1906883 1906883 defendant Broun Andrew baker 589773 589773 Broun, Andrew, of Wodeford, baker 4
3656007 1912131 1912131 defendant Wemden John butcher 589773 589773 Wemden, John, of Wodeford, butcher 0
3656411 1912250 1912250 defendant Perkyns John husbandman 589773 589773 Perkyns, John, of Wodeford, husbandman 2
3665633 1915202 1915202 plaintiff Stondon William   589773 589773 Stondon, William, of Wodeford 0
3670611 1916772 1916772 defendant Maye Richard husbandman 589773 589773 Maye, Richard, of Wodeford, husbandman 0
3813517 1962145 1962145 defendant Pyke John yeoman 589773 589773 Pyke, John, of Wodeford, yeoman 0
3914241 1995109 1995109 defendant Edy James weaver 589773 589773 Edy, James, of Wodeford, weaver 0
3914242 1995109 1995109 defendant Heyward John husbandman 589773 589773 Heyward, John, of Wodeford, husbandman 1
3914243 1995109 1995109 defendant Baylly John tucker 589773 589773 Baylly, John, of Wodeford, tucker 2
4440717 2182010 2182010 defendant Launder William draper 589773 589773 Launder, William, of Wodeford, draper 0
4448793 2184561 2184561 defendant Hulman Richard   589773 589773 Hulman, Richard, of Wodeford 0
4471692 2191813 2191813 defendant Gode John   589773 589773 Gode, John, of Wodeford 0
4496990 2199721 2199721 defendant Walcote Lawrence   589773 589773 Walcote, Lawrence, of Wodeford 0
4503523 2201675 2201675 defendant Taillour William   589773 589773 Taillour, William, of Wodeford 0
4528566 2209212 2209212 plaintiff Mason Thomas   589773 589773 Mason, Thomas, of Wodeford 0
4529267 2209437 2209437 plaintiff Mmason Thomas   589773 589773 Mmason, Thomas, of Wodeford 0
4532177 2210329 2210329 plaintiff Porter John   589773 589773 Porter, John, of Wodeford 0
4551121 2216293 2216293 defendant Bocher William   589773 589773 Bocher, William, of Wodeford 0
4553143 2216919 2216919 defendant Clerk Walter   589773 589773 Clerk, Walter, of Wodeford 1
4573644 2223270 2223270 defendant Jankyn John   589773 589773 Jankyn, John, of Wodeford, administrators of 0
4573646 2223270 2223270 defendant Lalleford Agnes   589773 589773 Lalleford, Agnes, of Wodeford 2
4579889 2225198 2225198 defendant Lalford William clerk 589773 589773 Lalford, William, of Wodeford, clerk 0
4583869 2226371 2226371 defendant Pakkere William   589773 589773 Pakkere, William, of Wodeford 0
4585579 2226912 2226912 defendant Tydy Robert   589773 589773 Tydy, Robert, of Wodeford 0
4612857 2235083 2235083 plaintiff Cromp John   589773 589773 Cromp, John, of Wodeford 0
4622710 2238077 2238077 defendant Henand William   589773 589773 Henand, William, of Wodeford 2
4655960 2247742 2247742 defendant Dyer John fisher 589773 589773 Dyer John, of Wodeford, fisher 0
4683859 2260561 2260561 defendant Hauewille John husbandman 589773 589773 Hauewille, John, of Wodeford, husbandman 0
4683860 2260561 2260561 defendant Haukeweill Richard laborer 589773 589773 Haukeweill, Richard, of Wodeford, laborer 1
4685579 2261083 2261083 defendant Bothe John husbandman 589773 589773 Bothe, John, of Wodeford, husbandman 0
4710413 2268610 2268610 defendant Haukewille John husbandman 589773 589773 Haukewille, John, of Wodeford, husbandman 0
4710414 2268610 2268610 defendant Haukewille Richard husbandman 589773 589773 Haukewille, Richard, of Wodeford, husbandman 1
4719681 2271503 2271503 defendant Walter John husbandman 589773 589773 Walter, John, of Wodeford, husbandman 0
4746527 2279476 2279476 defendant Hunte Robert yeoman 589773 589773 Hunte, Robert, of Wodeford, yeoman 1
4756585 2282423 2282423 defendant Olyver Thomas   589773 589773 Olyver, Thomas, of Wodeford, mill ward 0
4756586 2282423 2282423 defendant Olyver John   589773 589773 Olyver, John, of Wodeford, mill ward 1
4787803 2292250 2292250 defendant Fraunces John husbandman 589773 589773 Fraunces, John, of Wodeford, husbandman 0
4830802 2305662 2305662 defendant Stokwelle John husbandman 589773 589773 Stokwelle, John, of Wodeford, husbandman 0
4858098 2313905 2313905 plaintiff Henand or Hevand William   589773 589773 Henand or Hevand, William, of Wodeford 1
4891943 2324218 2324218 defendant Whitlyng John husbandman 589773 589773 Whitlyng, John, of Wodeford, husbandman 0
4893987 2324820 2324820 defendant Cokkes John husbandman 589773 589773 Cokkes, John, of Wodeford, husbandman 3
4902756 2327482 2327482 defendant Crumpe John miller 589773 589773 Crumpe, John, of Wodeford, miller 0
4923486 2333778 2333778 defendant Grene Oliver   589773 589773 Grene, Oliver, of Wodeford, parson 0
4939397 2338704 2338704 defendant Shelton Thomas clerk 589773 589773 Shelton, Thomas, of Wodeford, clerk 0
4960530 2345118 2345118 defendant Perys Richard husbandman 589773 589773 Perys, Richard, of Wodeford, husbandman 3
4970903 2348241 2348241 defendant Hoigge Stephen husbandman 589773 589773 Hoigge, Stephen, of Wodeford, husbandman 0
4971927 2348539 2348539 defendant Lenton Roger gent 589773 589773 Lenton, Roger, of Wodeford, gent 0
4973202 2348921 2348921 defendant Pryk John husbandman 589773 589773 Pryk, John, of Wodeford, husbandman 0
4985706 2352641 2352641 defendant Conssedwe William husbandman 589773 589773 Conssedwe, William, of Wodeford, husbandman 1
4985707 2352641 2352641 defendant Conssedwe Richard husbandman 589773 589773 Conssedwe, Richard, of Wodeford, husbandman 2
4992186 2354556 2354556 defendant Wellys John husbandman 589773 589773 Wellys, John, of Wodeford, husbandman 0
4992192 2354559 2354559 defendant Wellys John husbandman 589773 589773 Wellys, John, of Wodeford, husbandman 0
4998325 2356371 2356371 defendant Lenton Roger gent 589773 589773 Lenton, Roger, of Wodeford, gent 0
5045384 2370249 2370249 defendant Rygelot Roger husbandman 589773 589773 Rygelot, Roger, of Wodeford, husbandman 0
5057324 2373756 2373756 defendant Bode John yeoman 589773 589773 Bode, John, of Wodeford, yeoman 1
5090045 2383458 2383458 defendant Apelby Alexander husbandman 589773 589773 Apelby, Alexander, of Wodeford, husbandman 2
5108992 2389047 2389047 defendant Lyfden or Lysden John tailor 589773 589773 Lyfden or Lysden, John, of Wodeford, tailor 4
5108993 2389047 2389047 defendant Wyllyam Thomas husbandman 589773 589773 Wyllyam, Thomas, of Wodeford, husbandman 5
5137409 2397453 2397453 defendant Page Stephen   589773 589773 Page, Stephen, of Wodeford 0
5137411 2397454 2397454 defendant Page Stephen   589773 589773 Page, Stephen, of Wodeford, groom 0
5141613 2398657 2398657 defendant Webbe William yeoman 589773 589773 Webbe, William, of Wodeford, yeoman 1
5158050 2403477 2403477 defendant Hoigge Stephen yeoman 589773 589773 Hoigge, Stephen, of Wodeford, yeoman 0
5193880 2413934 2413934 defendant Piers Richard husbandman 589773 589773 Piers, Richard, of Wodeford, husbandman 4
5208435 2418193 2418193 defendant Piers Richard husbandman 589773 589773 Piers, Richard, of Wodeford, husbandman 4
5235611 2425997 2425997 defendant Hyndyn Richard husbandman 589773 589773 Hyndyn, Richard, of Wodeford, husbandman 1
5246574 2429161 2429161 defendant Hyndon John husbandman 589773 589773 Hyndon, John, of Wodeford, husbandman 0
5261111 2433585 2433585 defendant Serrank or Serrauk John tailor 589773 589773 Serrank or Serrauk, John, of Wodeford, tailor 0
5261113 2433586 2433586 defendant Serrank or Serrauk John tailor 589773 589773 Serrank or Serrauk, John, of Wodeford, tailor 0
5273357 2437277 2437277 defendant Davy Thomas   589773 589773 Davy, Thomas, of Wodeford, parson 2
5273362 2437278 2437278 defendant Symond Richard husbandman 589773 589773 Symond, Richard, of Wodeford, husbandman 3
5343043 2458011 2458011 defendant Langeman John   589773 589773 Langeman, John, of Wodeford, "helyer" 1
5343047 2458012 2458012 defendant Langeman John   589773 589773 Langeman, John, of Wodeford, "helyer" 1
5352075 2460755 2460755 defendant Horell John, senior laborer 589773 589773 Horell, John, senior, of Wodeford, laborer 0
5367538 2465494 2465494 defendant Counesdue John husbandman 589773 589773 Counesdue, John, of Wodeford, husbandman 0
5371307 2466605 2466605 defendant Horell John   589773 589773 Horell, John, of Wodeford, hakney man 0
5381476 2469762 2469762 defendant Hogell John husbandman 589773 589773 Hogell, John, of Wodeford, husbandman 2
5386049 2471081 2471081 defendant Cumesdewe John husbandman 589773 589773 Cumesdewe, John, of Wodeford, husbandman 0
5386378 2471172 2471172 defendant Cunnesdewe John husbandman 589773 589773 Cunnesdewe, John, of Wodeford, husbandman 0
5388677 2471817 2471817 defendant Hooell John husbandman 589773 589773 Hooell, John, of Wodeford, husbandman 2
5392870 2473034 2473034 defendant Smyth Richard smith 589773 589773 Smyth, Richard, of Wodeford, smith 0
5398647 2474679 2474679 plaintiff Counesdewe John husbandman 589773 589773 Counesdewe, John, of Wodeford, husbandman 0
5408583 2477532 2477532 defendant Turnour John yeoman 589773 589773 Turnour, John, of Wodeford, yeoman 0
5418876 2480571 2480571 defendant Smyth Richard smith 589773 589773 Smyth, Richard, of Wodeford, smith 0
5425628 2482647 2482647 defendant Counesdewe John husbandman 589773 589773 Counesdewe, John, of Wodeford, husbandman 0
5444056 2488137 2488137 defendant Counesdewe John husbandman 589773 589773 Counesdewe, John, of Wodeford, husbandman 0
5456782 2491947 2491947 defendant Counesdewe John husbandman 589773 589773 Counesdewe, John, of Wodeford, husbandman 0
5500979 2505241 2505241 defendant Penreth Richard tanner 589773 589773 Penreth, Richard, of Wodeford, tanner 2
5502953 2505834 2505834 defendant Shankton John laborer 589773 589773 Shankton, John, of Wodeford, laborer 0
5502954 2505834 2505834 defendant Broun William laborer 589773 589773 Broun, William, of Wodeford, laborer 1
5503249 2505926 2505926 defendant Horell John   589773 589773 Horell, John, of Wodeford 0
5503251 2505927 2505927 defendant Horell John yeoman 589773 589773 Horell, John, of Wodeford, yeoman 0
5588249 2531329 2531329 defendant Waren John smith 589773 589773 Waren, John, of Wodeford, smith 0
5593614 2532985 2532985 defendant Weynden John butcher 589773 589773 Weynden, John, of Wodeford, butcher 0
5607531 2537250 2537250 defendant Garde William yeoman 589773 589773 Garde, William, of Wodeford, yeoman 2
5610559 2547025 2547025 defendant Clyve John   589773 589773 Clyve, John, of Wodeford 0
5635477 2555062 2555062 defendant Smyth Ricard smith 589773 589773 Smyth, Ricard, of Wodeford, smith 0

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