names

95 rows where place_id = 585872

✎ 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
3587395 1863702 1863702 defendant Dod Hamon husbandman 585872 585872 Dod, Hamon, of Wy, husbandman 0
3587396 1863702 1863702 defendant Coke William tanner 585872 585872 Coke, William, of Wy, tanner 1
3596515 1866543 1866543 defendant Dod Thomas fuller 585872 585872 Dod, Thomas, of Wy, fuller 0
3596517 1866544 1866544 defendant Dod Thomas fuller 585872 585872 Dod, Thomas, of Wy, fuller 0
3597402 1866808 1866808 defendant Rolfe Thomas gent 585872 585872 Rolfe, Thomas, of Wy, gent 0
3600365 1867758 1867758 defendant Dod Hamon husbandman 585872 585872 Dod, Hamon, of Wy, husbandman 0
3614413 1872158 1872158 defendant Coke Joan Stephen, yeoman 585872 585872 Joan his wife): Cutlasse, Stephen, of Wy, yeoman 2
3622015 1874427 1874427 defendant Atwater John butcher 585872 585872 Atwater, John, of Wy, butcher 1
3622668 1874619 1874619 defendant Serlys William yeoman 585872 585872 Serlys, William, of Wy, yeoman 2
3622939 1874703 1874703 plaintiff Rose William   585872 585872 Rose, William, of Wy 0
3623314 1874819 1874819 defendant Fleccher John tailor 585872 585872 Fleccher, John, of Wy, tailor 0
3632759 1905060 1905060 plaintiff Horton William   585872 585872 Horton, William, of Wy 0
3634477 1905583 1905583 defendant Abarowe John husbandman 585872 585872 Abarowe, John, of Wy, husbandman 1
3641494 1907798 1907798 defendant Halk Richard   585872 585872 Halk, Richard, of Wy 0
4452504 2185781 2185781 defendant Gerard William   585872 585872 Gerard, William, of Wy 3
4536831 2211792 2211792 defendant Carpenter Nicholas   585872 585872 Carpenter, Nicholas, of Wy 0
4672876 2257158 2257158 defendant Pound John laborer 585872 585872 Pound, John, of Wy, laborer 5
4679294 2259134 2259134 defendant Mercer Hugh fuller 585872 585872 Mercer, Hugh, of Wy, fuller 0
4679395 2259172 2259172 plaintiff Kempe Thomas   585872 585872 Kempe, Thomas, of Wy 0
4679398 2259173 2259173 plaintiff Kempe Thomas   585872 585872 Kempe, Thomas, of Wy 0
4679401 2259173 2259173 defendant Swayn John repyer 585872 585872 Swayn, John, of Wy, repyer 2
4747352 2279729 2279729 plaintiff Kempt Thomas   585872 585872 Kempt, Thomas, of Wy, on his own account 0
4747355 2279729 2279729 defendant Bedford John chapman 585872 585872 Bedford, John, of Wy, chapman 2
4787308 2292100 2292100 defendant Pecham John laborer 585872 585872 Pecham, John, of Wy, laborer 0
4790095 2292978 2292978 plaintiff Kempe Thomas   585872 585872 Kempe, Thomas, of Wy 0
4790098 2292979 2292979 plaintiff Kempe Thomas   585872 585872 Kempe, Thomas, of Wy 0
4790100 2292980 2292980 plaintiff Kempe Thomas   585872 585872 Kempe, Thomas, of Wy 0
4802016 2296816 2296816 defendant Purdom Alexander carpenter 585872 585872 Purdom, Alexander, of Wy, carpenter 0
4884246 2321981 2321981 defendant Knyght Lawrence butcher 585872 585872 Knyght, Lawrence, of Wy, butcher 1
4897041 2325728 2325728 defendant Petham John laborer 585872 585872 Petham, John, of Wy, laborer 0
4897042 2325728 2325728 defendant Petham Thomas laborer 585872 585872 Petham, Thomas, of Wy, laborer 1
4936179 2337716 2337716 defendant Tanner William husbandman 585872 585872 Tanner, William, of Wy, husbandman 0
4936564 2337819 2337819 defendant Chambre William   585872 585872 Chambre, William, of Wy, holy water clerk 0
4937385 2338062 2338062 defendant Bery William husbandman 585872 585872 Bery, William, of Wy, husbandman 0
4937388 2338063 2338063 defendant Bery William husbandman 585872 585872 Bery, William, of Wy, husbandman 0
4938479 2338413 2338413 defendant Bette John husbandman 585872 585872 Bette, John, of Wy, husbandman 0
4941492 2339357 2339357 defendant Browyn Peter husbandman 585872 585872 Browyn, Peter, of Wy, husbandman 2
4950943 2342260 2342260 defendant Richard Thomas yeoman 585872 585872 Richard, Thomas, of Wy, yeoman 0
4960810 2345195 2345195 defendant Smethe Roger butcher 585872 585872 Smethe, Roger, of Wy, butcher 2
4968397 2347515 2347515 defendant Jankyn William   585872 585872 Jankyn, William, of Wy, tile maker 0
4974190 2349237 2349237 defendant Baldewyne William yeoman 585872 585872 Baldewyne, William, of Wy, yeoman 3
4974354 2349296 2349296 defendant Grydle or Erydle John yeoman 585872 585872 Grydle or Erydle, John, of Wy, yeoman 1
4976622 2349965 2349965 defendant Payn Richard husbandman 585872 585872 Payn, Richard, of Wy, husbandman 0
5027611 2364951 2364951 defendant Baldewyn William tiler 585872 585872 Baldewyn, William, of Wy, tiler 0
5051919 2372187 2372187 defendant Abery William chandler 585872 585872 Abery, William, of Wy, chandler 0
5053180 2372549 2372549 defendant Kynet John husbandman 585872 585872 Kynet, John, of Wy, husbandman 0
5069487 2377373 2377373 defendant Richard Agnes widow 585872 585872 Richard, Agnes, of Wy, widow 0
5069488 2377373 2377373 defendant Gerard Richard husbandman 585872 585872 Gerard, Richard, of Wy, husbandman 1
5073096 2378438 2378438 defendant Cartare William tailor 585872 585872 Cartare, William, of Wy, tailor 3
5074926 2379007 2379007 plaintiff Wyllok Thomas   585872 585872 Wyllok, Thomas,of Wy 0
5077192 2379680 2379680 defendant Aleyn Ncholas husbandman 585872 585872 Aleyn, Ncholas, of Wy, husbandman 0
5100154 2386486 2386486 plaintiff Wyllok Thomas   585872 585872 Wyllok, Thomas, of Wy 0
5100155 2386486 2386486 defendant German Hamo yeoman 585872 585872 German, Hamo, of Wy, yeoman 0
5100156 2386487 2386487 plaintiff Wyllok Thomas   585872 585872 Wyllok, Thomas,of Wy 0
5218114 2421032 2421032 defendant London William husbandman 585872 585872 London, William, of Wy, husbandman 0
5237677 2426602 2426602 defendant Bocher Hamon husbandman 585872 585872 Bocher, Hamon, of Wy, husbandman 0
5246647 2429179 2429179 defendant Beverle John husbandman 585872 585872 Beverle, John, of Wy, husbandman 3
5246649 2429180 2429180 plaintiff Serlys William chapman 585872 585872 Serlys, William, of Wy, chapman 0
5246653 2429180 2429180 defendant Kenet John husbandman 585872 585872 Kenet, John, of Wy, husbandman 3
5284353 2440441 2440441 defendant Austyn William tanner 585872 585872 Austyn, William, of Wy, tanner 3
5337979 2456443 2456443 defendant London William yeoman 585872 585872 London, William, of Wy, yeoman 0
5337983 2456444 2456444 defendant Sely William husbandman 585872 585872 Sely, William, of Wy, husbandman 0
5337987 2456445 2456445 defendant Soly William husbandman 585872 585872 Soly, William, of Wy, husbandman 0
5338417 2456590 2456590 defendant Serles William, junior chapman 585872 585872 Serles, William, junior, of Wy, chapman 0
5338420 2456590 2456590 defendant Serles William, senior husbandman 585872 585872 Serles, William, senior, of Wy, husbandman 3
5339930 2457058 2457058 defendant Bakkem Richard husbandman 585872 585872 Bakkem Richard, of Wy, husbandman 0
5345418 2458739 2458739 defendant Austyn Thomas tanner 585872 585872 Austyn, Thomas, of Wy, tanner 1
5360325 2463265 2463265 plaintiff Serlys William (legal representative) 585872 585872 Serlys, William, of Wy, chapman, executors of 0
5360327 2463265 2463265 plaintiff Jancok William   585872 585872 Jancok, William, of Wy 2
5360330 2463266 2463266 plaintiff Serlys William (legal representative) 585872 585872 Serlys, William, of Wy, chapman, executors of 0
5360332 2463266 2463266 plaintiff Jancok William   585872 585872 Jancok, William, of Wy 2
5360787 2463405 2463405 defendant Sely William husbandman 585872 585872 Sely, William, of Wy, husbandman 1
5394262 2473421 2473421 defendant Wode Hamon chapman 585872 585872 Wode, Hamon, of Wy, chapman 0
5407428 2477193 2477193 defendant Wode (illegible) chapman 585872 585872 Wode, ---, of wy, chapman 0
5481323 2499357 2499357 defendant Dodde Hamon yeoman 585872 585872 Dodde, Hamon, of Wy, yeoman 1
5485165 2500483 2500483 defendant Selke Hamon husbandman 585872 585872 Selke, Hamon, of Wy, husbandman 0
5488855 2501541 2501541 defendant Peak Geoffrey yeoman 585872 585872 Peak, Geoffrey, of Wy, yeoman 0
5494366 2503217 2503217 defendant Randolf John tailor 585872 585872 Randolf, John, of Wy, tailor 0
5500793 2505179 2505179 plaintiff Serllis William (legal representative) 585872 585872 Serllis, William, of Wy, chapman, executor of 0
5500794 2505179 2505179 plaintiff Jancok William   585872 585872 Jancok, William, of Wy 1
5509752 2507881 2507881 defendant Wariff William husbandman 585872 585872 Wariff, William, of Wy, husbandman 2
5513653 2509119 2509119 defendant Rolff Thomas gent 585872 585872 Rolff, Thomas, of Wy, gent 0
5514770 2509460 2509460 defendant Ware Richard yeoman 585872 585872 Ware, Richard, of Wy, yeoman 0
5530587 2514084 2514084 plaintiff Rose William   585872 585872 Rose, William, of Wy, son of Rose, John 0
5549199 2519812 2519812 defendant Chapman Henry yeoman 585872 585872 Chapman, Henry, of Wy, yeoman 2
5563020 2523781 2523781 defendant Rolff Simon butcher 585872 585872 Rolff, Simon, of Wy, butcher 0
5563021 2523781 2523781 defendant Rolff Hamon husbandman 585872 585872 Rolff, Hamon, of Wy, husbandman 1
5563023 2523782 2523782 defendant Rolff Simon butcher 585872 585872 Rolff, Simon, of Wy, butcher 0
5563024 2523782 2523782 defendant Rolff Hamon husbandman 585872 585872 Rolff, Hamon, of Wy, husbandman 1
5571672 2526266 2526266 defendant Barry Bicholas husbandman 585872 585872 Barry, Bicholas, of Wy, husbandman 4
5577439 2528002 2528002 defendant Rolf Simon husbandman 585872 585872 Rolf, Simon, of Wy, husbandman 1
5577446 2528004 2528004 defendant Dode Hamo husbandman 585872 585872 Dode, Hamo, of Wy, husbandman 0
5601234 2535275 2535275 defendant Wale Roger laborer 585872 585872 Wale, Roger, of Wy, laborer 0
5615375 2548604 2548604 defendant Ulge Henery   585872 585872 Ulge, Henery, of Wy 0
5625629 2551958 2551958 defendant Gotle John draper 585872 585872 Gotle, John, of Wy, draper 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);