names

66 rows where place_id = 685455

✎ 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
4062549 2046898 2046898 defendant Bewlen Lewis haberdasher 685455 685455 Bewlen, Lewis, of Ludlowe, Shrops, haberdasher 0
4550071 2215961 2215961 defendant Orleton Thomas   685455 685455 Orleton, Thomas, of Ludlowe, Shrops 0
4576713 2224225 2224225 defendant Glover William   685455 685455 Glover, William, of Ludlowe, Shrops 0
4583462 2226248 2226248 defendant Jolyf William mercer 685455 685455 Jolyf, William, of Ludlowe, Shrops, mercer 1
4666910 2255381 2255381 defendant Corbet Thomas mercer 685455 685455 Corbet, Thomas, of Ludlowe, Shrops, mercer 1
4678158 2258778 2258778 defendant Glover William merchant 685455 685455 Glover, William, of Ludlowe, Shrops, merchant 0
4740806 2277828 2277828 defendant Mere Robert chapman 685455 685455 Mere, Robert, of Ludlowe, Shrops, chapman 1
4802214 2296884 2296884 defendant Barbour Walter draper 685455 685455 Barbour, Walter, of Ludlowe, Shrops, draper 0
4806186 2298139 2298139 defendant Scole Thomas deemer 685455 685455 Scole, Thomas, of Ludlowe, Shrops, deemer 0
4808813 2298924 2298924 defendant Nornecote Richard shoemaker 685455 685455 Nornecote, Richard, of Ludlowe, Shrops, shoemaker 0
4836865 2307490 2307490 defendant Tipper William mercer 685455 685455 Tipper, William, of Ludlowe, Shrops, mercer 1
4840874 2308682 2308682 defendant Wyttelton John chapman 685455 685455 Wyttelton, John, of Ludlowe, Shrops, chapman 3
4840923 2308696 2308696 defendant Wyttelton John chapman 685455 685455 Wyttelton, John, of Ludlowe, Shrops, chapman 3
4843129 2309378 2309378 defendant Parys Thomas chapman 685455 685455 Parys, Thomas, of Ludlowe, Shrops, chapman 1
4843133 2309379 2309379 defendant Parys Thomas chapman 685455 685455 Parys, Thomas, of Ludlowe, Shrops, chapman 1
4854003 2312660 2312660 defendant Sherman John chapman 685455 685455 Sherman, John, of Ludlowe, Shrops, chapman 0
4915882 2331462 2331462 plaintiff Dyere alias Pontesbery Thomas (legal representative) 685455 685455 Dyere alias Pontesbery, Thomas, of Ludlowe, Shrops, dyer, executor of 0
4916974 2331813 2331813 defendant Dyer John merchant 685455 685455 Dyer, John, of Ludlowe, Shrops, merchant 0
4926907 2334845 2334845 defendant Hosyer John merchant 685455 685455 Hosyer, John, of Ludlowe, Shrops, merchant 2
4931799 2336332 2336332 defendant Ludlowe William esq 685455 685455 Ludlowe, William, of Ludlowe, Shrops, esq 1
4985466 2352573 2352573 defendant Dodmer John chapman 685455 685455 Dodmer, John, of Ludlowe, Shrops, chapman 1
4985749 2352654 2352654 defendant Walsch Anastasia taverner 685455 685455 Walsch, Anastasia, of Ludlowe, Shrops, taverner 2
4994976 2355356 2355356 defendant Dyche Geoffrey dyer 685455 685455 Dyche, Geoffrey, of Ludlowe, Shrops, dyer 0
5000773 2357103 2357103 defendant Myghell Thomas vintner 685455 685455 (Myghell, Thomas, of Ludlowe, Shrops, vintner 1
5011644 2360259 2360259 defendant Osbarn Philip chapman 685455 685455 Osbarn, Philip, of Ludlowe, Shrops, chapman 0
5011646 2360259 2360259 defendant Dyche Geoffre dyer 685455 685455 Dyche, Geoffre, of Ludlowe, Shrops, dyer 2
5012601 2360525 2360525 defendant Parys John gent 685455 685455 Parys, John, of Ludlowe, Shrops, gent 0
5050136 2371665 2371665 defendant Howe John tanner 685455 685455 Howe, John, of Ludlowe, Shrops, tanner 0
5127589 2394553 2394553 defendant Chamburleyn alias Walker Thomas, junior fuller 685455 685455 Chamburleyn alias Walker, Thomas, junior, of Ludlowe, Shrops, fuller 0
5128100 2394691 2394691 defendant Pempere David merchant 685455 685455 Pempere, David, of Ludlowe, Shrops, merchant 1
5135657 2396940 2396940 defendant Smyth John sheerman 685455 685455 Smyth, John, of Ludlowe, Shrops, sheerman 2
5135673 2396944 2396944 defendant Smyth John sheer man 685455 685455 Smyth, John, of Ludlowe, Shrops, sheer man 2
5145520 2399834 2399834 defendant Bowdeler Gillian   685455 685455 Bowdeler, Gillian, of Ludlowe, Shrops, widow, relict of John Bowdeler 1
5155923 2402893 2402893 defendant Smyth John sheerman 685455 685455 Smyth, John, of Ludlowe, Shrops, sheerman 2
5165921 2405778 2405778 defendant Bowdeler John (legal representative) 685455 685455 Bowdeler, John, of Ludlowe, Shrops, administratrix of 0
5165922 2405778 2405778 defendant Bowdeler Gillian widow & relict of John 685455 685455 Bowdeler, Gillian, of Ludlowe, Shrops, widow & relict of John 1
5169532 2406826 2406826 defendant Mere Robert (legal representative) 685455 685455 Mere, Robert, of Ludlowe, Shrops, merchant, executors of 1
5195157 2414329 2414329 defendant Sherman John chapman 685455 685455 Sherman, John, of Ludlowe, Shrops, chapman 2
5202482 2416487 2416487 defendant Bowdeler John (legal representative) 685455 685455 Bowdeler, John, of Ludlowe, Shrops, administratrix of 0
5209122 2418398 2418398 defendant Sherman John chapman 685455 685455 Sherman, John, of Ludlowe, Shrops, chapman 2
5298970 2444680 2444680 defendant Hodgekyns alias Benet John baker 685455 685455 Hodgekyns alias Benet, John, of Ludlowe, Shrops, baker 0
5306072 2446803 2446803 defendant Morton Thomas baker 685455 685455 Morton, Thomas, of Ludlowe, Shrops, baker 3
5367407 2465457 2465457 defendant Haseley Hugh draper 685455 685455 Haseley, Hugh, of Ludlowe, Shrops, draper 1
5379113 2469061 2469061 defendant Brenley Nicholas carrier 685455 685455 Brenley, Nicholas, of Ludlowe, Shrops, carrier 1
5379926 2469307 2469307 plaintiff Aleyn John esq 685455 685455 Aleyn, John, of Ludlowe, Shrops, esq 0
5388437 2471740 2471740 defendant Stevens Thomas merchant 685455 685455 Stevens, Thomas, of Ludlowe, Shrops, merchant 0
5388440 2471741 2471741 defendant Stevens Thomas merchant 685455 685455 Stevens, Thomas, of Ludlowe, Shrops, merchant 0
5388805 2471859 2471859 defendant Aleyn John   685455 685455 Aleyn, John, of Ludlowe, Shrops 3
5401442 2475478 2475478 defendant Aleyn John gent 685455 685455 Aleyn, John, of Ludlowe, Shrops, gent 3
5401970 2475622 2475622 defendant Thlody John yeoman 685455 685455 Thlody, John, of Ludlowe, Shrops, yeoman 1
5401973 2475623 2475623 defendant Thlody John yeoman 685455 685455 Thlody, John, of Ludlowe, Shrops, yeoman 1
5402468 2475775 2475775 defendant Dee John yeoman 685455 685455 Dee, John, of Ludlowe, Shrops, yeoman 1
5403806 2476162 2476162 defendant Beaupe or Beaupre Edward gent 685455 685455 Beaupe or Beaupre, Edward, of Ludlowe, Shrops, gent 0
5414048 2479136 2479136 defendant Stevenves Thomas merchant 685455 685455 Stevenves, Thomas, of Ludlowe, Shrops, merchant 0
5414411 2479248 2479248 defendant Aleyn John gent 685455 685455 Aleyn, John, of Ludlowe, Shrops, gent 2
5421726 2481434 2481434 defendant Bowedeler William butcher 685455 685455 Bowedeler, William, of Ludlowe, Shrops, butcher 0
5431618 2484413 2484413 defendant Dee John yeoman 685455 685455 Dee, John, of Ludlowe, Shrops, yeoman 1
5434666 2485305 2485305 defendant Tyler Hugh clerk & parson of St Lawrence's church 685455 685455 Tyler, Hugh, of Ludlowe, Shrops, clerk & parson of St Lawrence's church 1
5438533 2486461 2486461 defendant Raulynson John yeoman 685455 685455 Raulynson, John, of Ludlowe, Shrops, yeoman 1
5441577 2487399 2487399 defendant _deler William butcher 685455 685455 _deler, William, of Ludlowe, Shrops, butcher 0
5459179 2492648 2492648 defendant Eyneouse John walker 685455 685455 Eyneouse, John, of Ludlowe, Shrops, walker 0
5462163 2493577 2493577 defendant Tyler Hugh clerk & parson of St Lawrence church 685455 685455 Tyler, Hugh, of Ludlowe, Shrops, clerk & parson of St Lawrence church 1
5470820 2496201 2496201 defendant Eyneouse John walker 685455 685455 Eyneouse, John, of Ludlowe, Shrops, walker 0
5470826 2496203 2496203 defendant Honybryge or Hovybridge Walter draper 685455 685455 Honybryge or Hovybridge, Walter, of Ludlowe, Shrops, draper 0
5472624 2496779 2496779 defendant Mountgomery Hugh shoemaker 685455 685455 Mountgomery, Hugh, of Ludlowe, Shrops, shoemaker 3
5608276 2537491 2537491 plaintiff Aleyn John esq 685455 685455 Aleyn, John, of Ludlowe, Shrops, esq 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);