names

118 rows where place_id = 588012

✎ 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
3593101 1865470 1865470 defendant Harryson John laborer 588012 588012 Harryson, John, of Stratford atte Bowe, laborer 1
3593102 1865470 1865470 defendant Brode Thomas laborer 588012 588012 Brode, Thomas, of Stratford atte Bowe, laborer 2
3595203 1866133 1866133 defendant Haynes William beer brewer 588012 588012 Haynes, William, of Stratford atte Bowe, beer brewer 3
3595205 1866134 1866134 defendant Waren Thomas butcher 588012 588012 Waren, Thomas, of Stratford atte Bowe, butcher 0
3606051 1869560 1869560 defendant Turneley Nicholas baker 588012 588012 Turneley, Nicholas, of Stratford atte Bowe, baker 0
3606056 1869561 1869561 defendant Turneley Nicholas baker 588012 588012 Turneley, Nicholas, of Stratford atte Bowe, baker 0
3794759 1956239 1956239 defendant Farechylde Ralph baker 588012 588012 Farechylde, Ralph, of Stratford Atte Bowe, baker 2
3908030 1992981 1992981 plaintiff Prentyce William yeoman 588012 588012 Prentyce, William, of Stratford atte Bowe, yeoman 0
4442631 2182644 2182644 defendant Colyn Nicholas   588012 588012 Colyn, Nicholas, of Stratford atte Bowe 1
4492269 2198261 2198261 defendant Bower Richard   588012 588012 Bower, Richard, of Stratford atte Bowe 3
4492276 2198262 2198262 defendant Bower Richard   588012 588012 Bower, Richard, of Stratford atte Bowe 3
4525486 2208301 2208301 defendant Albyn Ralph baker 588012 588012 Albyn, Ralph, of Stratford atte Bowe, baker 0
4576969 2224305 2224305 plaintiff Burward Alice   588012 588012 Burward, Alice, of Stratford atte Bowe, prioress 0
4674103 2257509 2257509 defendant Smyth John smith 588012 588012 Smyth, John, of Stratford atte Bowe, smith 1
4681198 2259746 2259746 defendant Skelton Thomas yeoman 588012 588012 Skelton, Thomas, of Stratford atte Bowe, yeoman 3
4695919 2264209 2264209 plaintiff (not given) Alice prioress of Burward 588012 588012 Burward, Alice, of Stratford atte Bowe, prioress of the house of St Leonard 0
4714441 2269847 2269847 defendant Deigne Nicholas carpenter 588012 588012 Deigne, Nicholas, of Stratford atte Bowe, carpenter 0
4722273 2272287 2272287 defendant Mulvere Stephen miller 588012 588012 Mulvere, Stephen, of Stratford atte Bowe, miller 0
4756727 2282468 2282468 plaintiff Berwyk Alice   588012 588012 Berwyk, Alice, of Stratford atte Bowe 0
4759398 2283282 2283282 plaintiff Child William   588012 588012 Child, William, of Stratford atte Bowe 0
4771291 2287002 2287002 defendant Laurens John fuller 588012 588012 Laurens, John, of Stratford atte Bowe, fuller 1
4816482 2301246 2301246 defendant Borlyngton Edward clerk 588012 588012 Borlyngton, Edward, of Stratford atte Bowe, clerk 0
4816484 2301247 2301247 defendant Ham John chaplain 588012 588012 Ham, John, of Stratford atte Bowe, chaplain 0
4834513 2306803 2306803 defendant Awedemere William husbandman 588012 588012 Awedemere, William, of Stratford atte Bowe, husbandman 0
4834515 2306804 2306804 defendant Awedemere William husbandman 588012 588012 Awedemere, William, of Stratford atte Bowe, husbandman 0
4836096 2307269 2307269 defendant Howe Joan spinster 588012 588012 Howe, Joan, of Stratford atte Bowe, spinster 2
4836445 2307376 2307376 defendant Fyssher John fishmonger 588012 588012 Fyssher, John, of Stratford atte Bowe, fishmonger 0
4836446 2307376 2307376 defendant Heggenman John fishmonger 588012 588012 Heggenman, John, of Stratford atte Bowe, fishmonger 1
4855463 2313067 2313067 defendant Dunche Thomas brewer 588012 588012 Dunche, Thomas, of Stratford atte Bowe, brewer 0
4888925 2323320 2323320 defendant Pycot Edmund brewer 588012 588012 Pycot, Edmund, of Stratford atte Bowe, brewer 0
4907577 2328932 2328932 defendant Pycot Edmund brewer 588012 588012 Pycot, Edmund, of Stratford atte Bowe, brewer 0
4945183 2340473 2340473 defendant Bugate William   588012 588012 Bugate, William, of Stratford atte Bowe, tallow chandler 1
4971638 2348445 2348445 defendant Gibbes John brewer 588012 588012 Gibbes, John, of Stratford atte Bowe, brewer 0
4980690 2351160 2351160 defendant Gybbes John husbandman 588012 588012 Gybbes, John, of Stratford atte Bowe, husbandman 2
4992157 2354545 2354545 defendant Foster Robert chaplain 588012 588012 Foster, Robert, of Stratford atte Bowe, chaplain 0
5000687 2357075 2357075 defendant Loder Robert carrier 588012 588012 Loder, Robert, of Stratford atte Bowe, carrier 0
5004385 2358179 2358179 defendant Yerdley John tailor 588012 588012 Yerdley, John, of Stratford atte Bowe, tailor 0
5004753 2358294 2358294 defendant Broun Thomas baker 588012 588012 Broun, Thomas, of Stratford atte Bowe, baker 0
5004906 2358333 2358333 defendant Rawelyn Richard brewer 588012 588012 Rawelyn, Richard, of Stratford atte Bowe, brewer 0
5008168 2359272 2359272 plaintiff Stykker Joan baker 588012 588012 Stykker, Joan, of Stratford atte Bowe, formerly wife of John Stykker, baker 0
5008169 2359272 2359272 defendant Smalye John (legal representative) 588012 588012 Smalye, John, of Stratford atte Bowe, baker, executors of 0
5008183 2359276 2359276 defendant Bocher John   588012 588012 Bocher, John, of Stratford atte Bowe, servant 0
5008185 2359277 2359277 defendant Bocher John   588012 588012 Bocher, John, of Stratford atte Bowe, servant 0
5016929 2361845 2361845 defendant Waryn Thomas butcher 588012 588012 Waryn, Thomas, of Stratford atte Bowe, butcher 0
5021367 2363155 2363155 defendant Woderose John   588012 588012 Woderose, John, of Stratford atte Bowe, Middx yeoman 1
5021368 2363155 2363155 defendant Thressher Richard husbandman 588012 588012 Thressher, Richard, of Stratford atte Bowe, husbandman 2
5021371 2363156 2363156 defendant Woderose John   588012 588012 Woderose, John, of Stratford atte Bowe, Middx yeoman 1
5021372 2363156 2363156 defendant Thressher Richard husbandman 588012 588012 Thressher, Richard, of Stratford atte Bowe, husbandman 2
5025024 2364219 2364219 defendant Broune Thomas baker 588012 588012 Broune, Thomas, of Stratford atte Bowe, baker 0
5040279 2368689 2368689 defendant Smyth alias Depyng Thomas husbandman 588012 588012 Smyth alias Depyng, Thomas, of Stratford atte Bowe, husbandman 0
5047302 2370813 2370813 defendant Redman Roger yeoman 588012 588012 Redman, Roger, of Stratford atte Bowe, yeoman 2
5060467 2374709 2374709 defendant Treves Robert barber 588012 588012 Treves, Robert, of Stratford atte Bowe, barber 0
5061892 2375152 2375152 plaintiff Hamond John baker 588012 588012 Hamond, John, of Stratford atte Bowe, baker 0
5061893 2375152 2375152 defendant Lane John brewer 588012 588012 Lane, John, of Stratford atte Bowe, brewer 0
5061894 2375152 2375152 defendant Broune Emma widow 588012 588012 Broune, Emma, of Stratford atte Bowe, widow 1
5064316 2375874 2375874 defendant Hunt Robert   588012 588012 Hunt, Robert, of Stratford atte Bowe 0
5087971 2382858 2382858 defendant Godefellawe John smith 588012 588012 Godefellawe, John, of Stratford atte Bowe, or of Totyll Strete juxta Westminster Abbey, smith 0
5093541 2384509 2384509 defendant Janyvere Henry yeoman 588012 588012 Janyvere, Henry, of Stratford atte Bowe, yeoman 0
5101437 2386833 2386833 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5101439 2386833 2386833 defendant Hamond John brewer 588012 588012 Hamond, John, of Stratford atte Bowe, brewer 2
5105074 2387919 2387919 plaintiff Childe Thomas brewer 588012 588012 Childe, Thomas, of Stratford atte Bowe, baker, or of London, brewer 0
5105077 2387920 2387920 plaintiff Childe Thomas brewer 588012 588012 Childe, Thomas, of Stratford atte Bowe, baker, or of London, brewer 0
5107980 2388775 2388775 defendant atte Wode John chaplain 588012 588012 atte Wode, John, of Stratford atte Bowe, chaplain 1
5110184 2389386 2389386 defendant Pygot Edmund husbandman 588012 588012 Pygot, Edmund, of Stratford atte Bowe, husbandman 3
5118567 2391861 2391861 defendant Letot Thomas butcher 588012 588012 Letot, Thomas, of Stratford atte Bowe, butcher 2
5143303 2399178 2399178 defendant Treveys Robert barber 588012 588012 Treveys, Robert, of Stratford atte Bowe, barber 0
5143306 2399179 2399179 defendant Treveys Robert barber 588012 588012 Treveys, Robert, of Stratford atte Bowe, barber 0
5172175 2407583 2407583 defendant Steven Simon miller 588012 588012 Steven, Simon, of Stratford atte Bowe, miller 0
5177896 2409241 2409241 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 3
5182251 2410562 2410562 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5182254 2410563 2410563 defendant Lawrence John fuller 588012 588012 Lawrence, John, of Stratford atte Bowe, fuller 0
5195231 2414351 2414351 defendant Pygot Edmund   588012 588012 Pygot, Edmund, of Stratford atte Bowe 0
5195232 2414351 2414351 defendant Carpenter William carpenter 588012 588012 Carpenter, William, of Stratford atte Bowe, carpenter 1
5196507 2414731 2414731 plaintiff Smyth William baker 588012 588012 Smyth, William, of Stratford atte Bowe, baker 0
5196509 2414732 2414732 plaintiff Smyth William baker 588012 588012 Smyth, William, of Stratford atte Bowe, baker 0
5200729 2415969 2415969 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5201144 2416095 2416095 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 3
5203303 2416728 2416728 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5209170 2418410 2418410 defendant Pygot Edmund brewer 588012 588012 Pygot, Edmund, of Stratford atte Bowe, brewer 0
5209171 2418410 2418410 defendant Carpenter alias Richardson William carpenter 588012 588012 Carpenter alias Richardson, William, of Stratford atte Bowe, carpenter 1
5209674 2418569 2418569 plaintiff Smyth William baker 588012 588012 Smyth, William, of Stratford atte Bowe, baker 0
5211604 2419131 2419131 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5211607 2419132 2419132 defendant Laurence John fuller 588012 588012 Laurence, John, of Stratford atte Bowe, fuller 0
5214343 2419930 2419930 plaintiff Burgeys John baker 588012 588012 Burgeys, John, of Stratford atte Bowe, baker 0
5214345 2419931 2419931 plaintiff Burgeys John baker 588012 588012 Burgeys, John, of Stratford atte Bowe, baker 0
5224366 2422802 2422802 defendant Pygot Edmund brewer 588012 588012 Pygot, Edmund, of Stratford atte Bowe, brewer 0
5225128 2423020 2423020 defendant Carpenter alias Richardson William carpenter 588012 588012 Carpenter alias Richardson, William, of Stratford atte Bowe, carpenter 1
5225177 2423034 2423034 defendant Lytull Roger cordwainer 588012 588012 Lytull, Roger, of Stratford atte Bowe, cordwainer 0
5228146 2423839 2423839 defendant Lytull Roger   588012 588012 Lytull, Roger, of Stratford atte Bowe, servant 0
5236790 2426344 2426344 plaintiff Ferrour John smith 588012 588012 Ferrour, John, of Stratford atte Bowe, smith 0
5274382 2437588 2437588 plaintiff Poterose William (legal representative) 588012 588012 Poterose, William, of Stratford atte Bowe, baker, executors of 0
5274392 2437589 2437589 plaintiff Poterose William (legal representative) 588012 588012 Poterose, William, of Stratford atte Bowe, baker, executors of 0
5308184 2447477 2447477 plaintiff Rothelay William baker 588012 588012 Rothelay, William, of Stratford atte Bowe, baker 0
5315851 2449812 2449812 defendant Radley William baker 588012 588012 Radley, William, of Stratford atte Bowe, baker 0
5318456 2450613 2450613 defendant Carter Robert baker 588012 588012 Carter, Robert, of Stratford atte Bowe, baker 0
5333172 2454988 2454988 defendant Radley William baker 588012 588012 Radley, William, of Stratford atte Bowe, baker 0
5341229 2457451 2457451 defendant Wylcok Thomas husbandman 588012 588012 Wylcok, Thomas, of Stratford atte Bowe, husbandman 0
5346241 2458963 2458963 defendant Bolser John yeoman 588012 588012 Bolser, John, of Stratford atte Bowe, yeoman 0
5346243 2458964 2458964 defendant Bolser John yeoman 588012 588012 Bolser, John, of Stratford atte Bowe, yeoman 0
5407654 2477258 2477258 defendant Rowe John yeoman 588012 588012 Rowe, John, of Stratford atte Bowe, yeoman 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);