names

97 rows where place_id = 586511

✎ 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
3588919 1864184 1864184 defendant Whiteway John fuller 586511 586511 Whiteway, John, of Neubury, fuller 1
3588930 1864189 1864189 defendant Whiteway John fuller 586511 586511 Whiteway, John, of Neubury, fuller 1
3588933 1864190 1864190 defendant Whitway John fuller 586511 586511 Whitway, John, of Neubury, fuller 1
3700254 1926314 1926314 defendant Rypon Thomas clothier 586511 586511 Rypon, Thomas, of Neubury, clothier 0
3890765 1987179 1987179 defendant Dewen John dyer 586511 586511 Dewen, John, of Neubury, dyer 0
3900441 1990377 1990377 defendant Bennet John dyer 586511 586511 Bennet, John, of Neubury, brewer, Dewen, John, of Neubury, dyer 4
4413735 2169191 2169191 defendant Fatte Ralph   586511 586511 Fatte, Ralph, of Neubury 0
4435979 2175989 2175989 defendant Milys William   586511 586511 Milys, William, of Neubury 0
4435981 2175990 2175990 defendant Milys William   586511 586511 Milys, William, of Neubury 0
4435983 2175991 2175991 defendant Milys William   586511 586511 Milys, William, of Neubury 0
4435985 2175992 2175992 defendant Milys William   586511 586511 Milys, William, of Neubury 0
4451267 2185358 2185358 defendant Grenham John   586511 586511 Grenham, John, of Neubury 0
4473571 2192393 2192393 defendant Middelton John   586511 586511 Middelton, John, of Neubury 0
4474191 2192580 2192580 plaintiff Deneman Robert   586511 586511 Deneman, Robert, of Neubury 0
4474795 2192787 2192787 defendant Bakere Thomas   586511 586511 Bakere, Thomas, of Neubury 0
4486375 2196449 2196449 defendant Saundre John   586511 586511 Saundre, John, of Neubury 0
4487534 2196818 2196818 plaintiff Smyth Roger   586511 586511 Smyth, Roger, of Neubury, on his own account 0
4487676 2196861 2196861 defendant Drekevile William   586511 586511 Drekevile, William, of Neubury 3
4490282 2197658 2197658 defendant Deneman Robert   586511 586511 Deneman, Robert, of Neubury 0
4561047 2219405 2219405 defendant Smyth Robert   586511 586511 Smyth, Robert, of Neubury 1
4608347 2233722 2233722 defendant Mothe John dyer 586511 586511 Mothe, John, of Neubury, dyer 0
4626468 2239227 2239227 defendant Westburgh John   586511 586511 Westburgh, John, of Neubury 1
4682196 2260053 2260053 defendant Hertrygge Robert husbandman 586511 586511 Hertrygge, Robert, of Neubury, husbandman 3
4781573 2290250 2290250 defendant Depenale Robert cordwainer 586511 586511 Depenale, Robert, of Neubury, cordwainer 0
4856242 2313324 2313324 defendant Hosyer Robert draper 586511 586511 Hosyer, Robert, of Neubury, draper 0
4856243 2313324 2313324 defendant Barbor Henry husbandman 586511 586511 Barbor, Henry, of Neubury, husbandman 1
4857210 2313641 2313641 defendant Morgan Avery husbandman 586511 586511 Morgan, Avery, of Neubury, husbandman 1
4857211 2313641 2313641 defendant Croke William husbandman 586511 586511 Croke, William, of Neubury, husbandman 2
4857212 2313641 2313641 defendant Northhalle William husbandman 586511 586511 Northhalle, William, of Neubury, husbandman 3
4860778 2314731 2314731 defendant Chasych John husbandman 586511 586511 Chasych, John, of Neubury, husbandman 1
4861308 2314903 2314903 defendant Fryth Robert draper 586511 586511 Fryth, Robert, of Neubury, draper 0
4865041 2316043 2316043 defendant Knolle William baker 586511 586511 Knolle, William, of Neubury, baker 0
4865042 2316043 2316043 defendant Benet John fuller 586511 586511 Benet, John, of Neubury, fuller 1
4867106 2316674 2316674 defendant Horlok John husbandman 586511 586511 Horlok, John, of Neubury, husbandman 0
4883781 2321836 2321836 defendant Braybrok John yeoman 586511 586511 together with Braybrok, John, of Neubury, yeoman 2
4913207 2330629 2330629 plaintiff Chippes John   586511 586511 Chippes, John, of Neubury 0
4913208 2330629 2330629 defendant Abberbury Richard gent 586511 586511 Abberbury, Richard, of Neubury, gent 0
4922922 2333589 2333589 plaintiff Maget John   586511 586511 Maget, John, of Neubury 0
4922930 2333593 2333593 plaintiff Magot John   586511 586511 Magot, John, of Neubury 0
4938579 2338451 2338451 defendant Irysshe Nicholas butcher 586511 586511 Irysshe, Nicholas, of Neubury, butcher 0
4941948 2339465 2339465 defendant Wygge William weaver 586511 586511 together with Wygge, William, of Neubury, weaver 3
4944156 2340142 2340142 defendant Robynnes Thomas husbandman 586511 586511 Robynnes, Thomas, of Neubury, husbandman 0
4953514 2343022 2343022 defendant Waldry William weaver 586511 586511 Waldry, William, of Neubury, weaver 0
4954233 2343238 2343238 defendant Merssh John carpenter 586511 586511 Merssh, John, of Neubury, carpenter 0
4958009 2344362 2344362 defendant Dyer Walter   586511 586511 Dyer, Walter, of Neubury 0
4958383 2344474 2344474 defendant Toke Roger shoemaker 586511 586511 Toke, Roger, of Neubury, shoemaker 0
4963071 2345862 2345862 defendant Bocher Robert butcher 586511 586511 Bocher, Robert, of Neubury, butcher 1
4963216 2345906 2345906 defendant Bocher Robert butcher 586511 586511 Bocher, Robert, of Neubury, butcher 1
5016549 2361735 2361735 defendant Schathelok Thomas fuller 586511 586511 Schathelok, Thomas, of Neubury, fuller 0
5017410 2361981 2361981 plaintiff Chebrey or Chelrey John (legal representative) 586511 586511 Chebrey or Chelrey, John, of Neubury, clerk, executors of 0
5021111 2363069 2363069 defendant Tanner Thomas husbandman 586511 586511 Tanner, Thomas, of Neubury, husbandman 3
5021112 2363069 2363069 defendant Parker Richard tailor 586511 586511 Parker, Richard, of Neubury, tailor 4
5023799 2363868 2363868 defendant Hasylden Roger butcher 586511 586511 Hasylden, Roger, of Neubury, butcher 0
5034868 2367054 2367054 defendant Exe John chapman 586511 586511 Exe, John, of Neubury, chapman 2
5045314 2370225 2370225 defendant Smyth William chapman 586511 586511 Smyth, William, of Neubury, chapman 1
5058632 2374142 2374142 defendant Spycer Richard chaplain 586511 586511 Spycer, Richard,of Neubury, chaplain 0
5063295 2375554 2375554 defendant Fyssher William fisher 586511 586511 Fyssher, William, of Neubury, fisher 0
5086318 2382390 2382390 defendant Mortemere Richard butcher 586511 586511 Mortemere, Richard, of Neubury, butcher 0
5094164 2384698 2384698 defendant Spenser Henry yeoman 586511 586511 Spenser, Henry, of Neubury, yeoman 0
5097065 2385574 2385574 defendant Smyth William chapman 586511 586511 Smyth, William, of Neubury, chapman 2
5097199 2385615 2385615 defendant Hunte John yeoman 586511 586511 Hunte, John, of Neubury, yeoman 2
5101602 2386889 2386889 defendant Domenet Simon butcher 586511 586511 Domenet, Simon, of Neubury, butcher 0
5106841 2388427 2388427 defendant Domenet Simon butcher 586511 586511 Domenet, Simon, of Neubury, butcher 0
5117472 2391544 2391544 defendant Chillond Roger fuller 586511 586511 Chillond, Roger, of Neubury, fuller 2
5117478 2391545 2391545 defendant Chillond Roger fuller 586511 586511 Chillond, Roger, of Neubury, fuller 2
5212840 2419499 2419499 defendant White Thomas cooper 586511 586511 White, Thomas, of Neubury, cooper 0
5237224 2426471 2426471 plaintiff Frye Thomas   586511 586511 Frye, Thomas, of Neubury 0
5260389 2433377 2433377 defendant Bolford John, senior (legal representative) 586511 586511 Bolford, John, senior, of Neubury, carpenter, executrix of 1
5278327 2438764 2438764 defendant Lone or Love Thomas fuller 586511 586511 Lone or Love, Thomas, of Neubury, fuller 0
5284253 2440413 2440413 defendant Crede John butcher 586511 586511 Crede, John, of Neubury, butcher 4
5292392 2442773 2442773 defendant Colyns John weaver 586511 586511 Colyns, John, of Neubury, weaver 2
5337659 2456334 2456334 defendant Percy alias Bocher Simon husbandman or butcher 586511 586511 Percy alias Bocher, Simon, of Neubury, husbandman or butcher 0
5356342 2462054 2462054 defendant Godewyn Richard fuller 586511 586511 Godewyn, Richard, of Neubury, fuller 1
5425306 2482540 2482540 defendant Hurton Stephen yeoman 586511 586511 Hurton, Stephen, of Neubury, yeoman 1
5456591 2491893 2491893 defendant Hurton Stephen yeoman 586511 586511 Hurton, Stephen, of Neubury, yeoman 1
5462258 2493613 2493613 defendant Merryet Richard yeoman 586511 586511 Merryet, Richard, of Neubury, yeoman 0
5468434 2495499 2495499 defendant Hurton Stephen yeoman 586511 586511 Hurton, Stephen, of Neubury, yeoman 1
5468435 2495499 2495499 defendant Croke John yeoman 586511 586511 Croke, John, of Neubury, yeoman 2
5468439 2495500 2495500 defendant Hurton Stephen yeoman 586511 586511 Hurton, Stephen, of Neubury, yeoman 1
5468440 2495500 2495500 defendant Croke John yeoman 586511 586511 Croke, John, of Neubury, yeoman 2
5505035 2506485 2506485 defendant Burlee John yeoman 586511 586511 Burlee, John, of Neubury, yeoman 0
5506800 2507047 2507047 defendant Grene Giles weaver 586511 586511 Grene, Giles, of Neubury, weaver 1
5531711 2514453 2514453 defendant Sewey Robert yeoman 586511 586511 (Sewey, Robert, of Neubury, yeoman 2
5546739 2519050 2519050 defendant Flakette John clothmaker 586511 586511 Flakette, John, of Neubury, clothmaker 0
5546740 2519050 2519050 defendant Sevyer John clothmaker 586511 586511 Sevyer, John, of Neubury, clothmaker 1
5560510 2523033 2523033 defendant Benet Thomas clothier 586511 586511 Benet, Thomas, of Neubury, clothier 0
5561817 2523441 2523441 defendant Soper Thomas   586511 586511 Soper, Thomas, of Neubury, clothier, administrators of 0
5561818 2523441 2523441 defendant Elys John, junior clothier 586511 586511 (Elys, John, junior, of Neubury, clothier 1
5563772 2524013 2524013 defendant Medewas William weaver 586511 586511 Medewas, William, of Neubury, weaver 0
5578554 2528362 2528362 defendant Couper Thomas butcher 586511 586511 Couper, Thomas, of Neubury, butcher 0
5615483 2548629 2548629 plaintiff Glover William   586511 586511 Glover, William, of Neubury 0
5615484 2548629 2548629 defendant Bocher Robert   586511 586511 Bocher, Robert, of Neubury 0
5616570 2548983 2548983 defendant Spicer Edith   586511 586511 Spicer, Edith, of Neubury 0
5616572 2548984 2548984 defendant Spicer Edith   586511 586511 Spicer, Edith, of Neubury 0
5620235 2550185 2550185 defendant Chapman Richard   586511 586511 Chapman, Richard, of Neubury 0
5620236 2550185 2550185 defendant Smyth Richard   586511 586511 Smyth, Richard, of Neubury 1
5621838 2550739 2550739 defendant Skottes Agnes   586511 586511 Skottes, Agnes, of Neubury 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);