names

142 rows where place_id = 612266

✎ 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
3692407 1923803 1923803 defendant Peke John yeoman 612266 612266 Peke, John, of Blythe, yeoman 0
3846166 1972357 1972357 defendant Warynar William husbandman 612266 612266 Warynar, William, of Blythe, husbandman 0
3864306 1978256 1978256 defendant Byngley Richard yeoman 612266 612266 Byngley, Richard, of Blythe, yeoman 2
3879618 1983436 1983436 defendant Pogmore Gregory carpenter 612266 612266 Pogmore, Gregory, of Blythe, carpenter 0
3879619 1983436 1983436 defendant Harrott John butcher 612266 612266 Harrott, John, of Blythe, butcher 1
3890415 1987050 1987050 defendant Eyer Robert gent 612266 612266 Eyer, Robert, of Blythe, gent 0
4001748 2025401 2025401 defendant Llewelyn John David yeoman 612266 612266 Llewelyn, John David, of Blythe, yeoman 1
4004222 2026287 2026287 plaintiff Ingleby George mercer 612266 612266 Ingleby, George, of Blythe, mercer 0
4026415 2034092 2034092 plaintiff Byngley George yeoman 612266 612266 Byngley, George, of Blythe, yeoman 0
4280993 2123254 2123254 defendant Ingleby Robert vintner 612266 612266 Ingleby, Robert, of Blythe, vintner 1
4361931 2151424 2151424 defendant Ingleby George innholder 612266 612266 Ingleby, George, of Blythe, innholder 0
4381094 2158353 2158353 defendant Welles Agnes widow 612266 612266 Welles, Agnes, of Blythe, widow 2
4420936 2171444 2171444 plaintiff Chapman Richard le   612266 612266 Chapman, Richard le, of Blythe 0
4428256 2173668 2173668 defendant Fissher John   612266 612266 Fissher, John, of Blythe 3
4512563 2204369 2204369 defendant Smyth John   612266 612266 Smyth, John, of Blythe 0
4546946 2214977 2214977 defendant Watson Adam   612266 612266 Watson, Adam, of Blythe 2
4569282 2221981 2221981 defendant Maples Thomas   612266 612266 Maples, Thomas, of Blythe 0
4576819 2224258 2224258 defendant Bagley Thomas de   612266 612266 Bagley, Thomas de, of Blythe 0
4592154 2228901 2228901 defendant Roteland Robert   612266 612266 Roteland, Robert, of Blythe 1
4598814 2230858 2230858 defendant Barker William   612266 612266 Barker, William, of Blythe 3
4602341 2231948 2231948 defendant Maples Thomas   612266 612266 Maples, Thomas, of Blythe 2
4606334 2233097 2233097 plaintiff Bagley Thomas draper 612266 612266 Bagley, Thomas, of Blythe, draper 0
4606339 2233098 2233098 plaintiff Bagley Thomas draper 612266 612266 Bagley, Thomas, of Blythe, draper 0
4615726 2235918 2235918 plaintiff Ferrour Thomas   612266 612266 Ferrour, Thomas, of Blythe 0
4629356 2240112 2240112 defendant Baggeley Thomas   612266 612266 Baggeley, Thomas, of Blythe 4
4630604 2240482 2240482 defendant Litster Richard   612266 612266 Litster, Richard, of Blythe 0
4653002 2246870 2246870 defendant Rygmayden William yeoman 612266 612266 Rygmayden, William, of Blythe, yeoman 1
4675399 2257915 2257915 defendant Hegyn Richard yeoman 612266 612266 Hegyn, Richard, of Blythe, yeoman 1
4680198 2259415 2259415 defendant Baytclyf Thomas yeoman 612266 612266 Baytclyf, Thomas, of Blythe, yeoman 3
4685539 2261071 2261071 defendant Savage Thomas yeoman 612266 612266 Savage, Thomas, of Blythe, yeoman 0
4688179 2261869 2261869 plaintiff Taillour Edmund   612266 612266 Taillour, Edmund, of Blythe 0
4721619 2272092 2272092 defendant Fox Thomas (legal representative) 612266 612266 Fox, Thomas, of Blythe, executors of 0
4721620 2272092 2272092 defendant Wryght William husbandman 612266 612266 (Wryght, William, of Blythe, husbandman 1
4721621 2272092 2272092 defendant Taillour Edmund tailor 612266 612266 Taillour, Edmund, of Blythe, tailor 2
4729486 2274435 2274435 defendant Rygmayden William yeoman 612266 612266 Rygmayden, William, of Blythe, yeoman 0
4729878 2274551 2274551 defendant Stokes Elizabeth widow 612266 612266 Stokes, Elizabeth, of Blythe, widow 0
4743091 2278501 2278501 defendant Bageley Thomas merchant 612266 612266 Bageley, Thomas, of Blythe, merchant 0
4744982 2279046 2279046 defendant Belhous Thomas yeoman 612266 612266 Belhous, Thomas, of Blythe, yeoman 2
4754826 2281889 2281889 defendant Belous or Belons Thomas yeoman 612266 612266 Belous or Belons, Thomas, of Blythe, yeoman 1
4759115 2283199 2283199 defendant Bagley Thomas merchant 612266 612266 Bagley, Thomas, of Blythe, merchant 0
4772358 2287320 2287320 defendant Baglay Thomas merchant 612266 612266 Baglay, Thomas, of Blythe, merchant 0
4772360 2287321 2287321 defendant Baglay Thomas merchant 612266 612266 Baglay, Thomas, of Blythe, merchant 0
4778899 2289376 2289376 defendant Barbour Richard barber 612266 612266 Barbour, Richard, of Blythe, barber 0
4781228 2290142 2290142 defendant Bagley Thomas merchant 612266 612266 Bagley, Thomas, of Blythe, merchant 0
4788394 2292432 2292432 defendant Knolles William yeoman 612266 612266 Knolles, William, of Blythe, yeoman 0
4788395 2292432 2292432 defendant Bagley Thomas merchant 612266 612266 Bagley, Thomas, of Blythe, merchant 1
4791577 2293459 2293459 defendant Boswell Thomas clerk 612266 612266 Boswell, Thomas, of Blythe, clerk 2
4800670 2296392 2296392 defendant Knolles William yeoman 612266 612266 Knolles, William, of Blythe, yeoman 0
4804652 2297651 2297651 plaintiff Boswell Thomas   612266 612266 Boswell, Thomas, of Blythe, vicar 0
4808337 2298784 2298784 defendant Palfreyman Robert yeoman 612266 612266 Palfreyman, Robert, of Blythe, yeoman 0
4808339 2298785 2298785 defendant Palfreyman Robert yeoman 612266 612266 Palfreyman, Robert, of Blythe, yeoman 0
4828979 2305106 2305106 defendant Skynner Ellis   612266 612266 Skynner, Ellis, of Blythe, fish monger 1
4828980 2305106 2305106 defendant Mayre William butcher 612266 612266 Mayre, William, of Blythe, butcher 2
4828981 2305106 2305106 defendant Hudson Richard yeoman 612266 612266 Hudson, Richard, of Blythe, yeoman 3
4828982 2305106 2305106 defendant Forest John husbandman 612266 612266 Forest, John, of Blythe, husbandman 4
4830685 2305622 2305622 defendant Bagley Thomas yeoman 612266 612266 Bagley, Thomas, of Blythe, yeoman 1
4832210 2306106 2306106 defendant Forest John husbandman 612266 612266 Forest, John, of Blythe, husbandman 3
4835633 2307136 2307136 defendant Barbour Richard husbandman 612266 612266 Barbour, Richard, of Blythe, husbandman 2
4837544 2307677 2307677 defendant Brase William laborer 612266 612266 Brase, William, of Blythe, laborer 4
4837554 2307680 2307680 defendant Brase William laborer 612266 612266 Brase, William, of Blythe, laborer 4
4842722 2309261 2309261 defendant Lincoln John butcher 612266 612266 Lincoln, John, of Blythe, butcher 3
4843083 2309366 2309366 defendant Hudson Richard yeoman 612266 612266 Hudson, Richard, of Blythe, yeoman 0
4843086 2309367 2309367 defendant Hudson Richard yeoman 612266 612266 Hudson, Richard, of Blythe, yeoman 0
4843090 2309368 2309368 defendant Hudson Richard yeoman 612266 612266 Hudson, Richard, of Blythe, yeoman 0
4848669 2311055 2311055 defendant Barbour Richard barber 612266 612266 Barbour, Richard, of Blythe, barber 0
4855742 2313171 2313171 defendant Peese Elias ostler 612266 612266 Peese, Elias, of Blythe, ostler 0
4855743 2313171 2313171 defendant Forest John husbandman 612266 612266 Forest, John, of Blythe, husbandman 1
4870138 2317627 2317627 defendant Lyncoln John butcher 612266 612266 Lyncoln, John, of Blythe, butcher 4
4871248 2317981 2317981 defendant Smyth William smith 612266 612266 Smyth, William, of Blythe, smith 3
4871276 2317986 2317986 defendant Skynner Elias fisher 612266 612266 Skynner, Elias, of Blythe, fisher 4
4871277 2317986 2317986 defendant Bocher William butcher 612266 612266 Bocher, William, of Blythe, butcher 5
4871282 2317988 2317988 defendant Skennare John skinner 612266 612266 Skennare, John, of Blythe, skinner 0
4898712 2326248 2326248 defendant Boweland William yeoman 612266 612266 Boweland, William, of Blythe, yeoman 1
4902650 2327448 2327448 defendant Snowe John butcher 612266 612266 Snowe, John, of Blythe, butcher 1
4905326 2328259 2328259 defendant Hudson Richard yeoman 612266 612266 Hudson, Richard, of Blythe, yeoman 0
4905327 2328259 2328259 defendant Hudson Thomas yeoman 612266 612266 Hudson, Thomas, of Blythe, yeoman 1
4905328 2328259 2328259 defendant Dowene John yeoman 612266 612266 Dowene, John, of Blythe, yeoman 2
4905329 2328259 2328259 defendant Watson Hugh yeoman 612266 612266 Watson, Hugh, of Blythe, yeoman 3
4915463 2331337 2331337 plaintiff Doncastre Agnes (legal representative) 612266 612266 Doncastre, Agnes, of Blythe, executrix of 0
4915466 2331337 2331337 defendant Smyth John smith 612266 612266 Smyth, John, of Blythe, smith 1
4920049 2332782 2332782 defendant Tapster Alice widow 612266 612266 Tapster, Alice, of Blythe, widow 0
4947673 2341260 2341260 defendant Lyndesey John dyer 612266 612266 Lyndesey, John, of Blythe, dyer 1
4965443 2346580 2346580 defendant Candeler William husbandman 612266 612266 Candeler, William, of Blythe, husbandman 0
4965445 2346581 2346581 plaintiff Craven Henry (legal representative) 612266 612266 Craven, Henry, of Blythe, chaplain, executors of 0
4971559 2348423 2348423 defendant Tapster Margery tapster 612266 612266 Tapster, Margery, of Blythe, tapster 0
4980135 2351010 2351010 defendant Sadeler William saddler 612266 612266 together with Sadeler, William, of Blythe, saddler 1
4994914 2355333 2355333 plaintiff Frost Thomas   612266 612266 Frost, Thomas, of Blythe, son of John Frost 0
4994915 2355333 2355333 defendant Ruston Thomas tailor 612266 612266 Ruston, Thomas, of Blythe, tailor 0
5000047 2356896 2356896 defendant Sparge William shoemaker 612266 612266 Sparge, William, of Blythe, shoemaker 1
5010786 2360008 2360008 defendant Snowe Robert yeoman 612266 612266 Snowe, Robert, of Blythe, yeoman 2
5018800 2362386 2362386 defendant Taylour Edmund yeoman 612266 612266 Taylour, Edmund, of Blythe, yeoman 0
5018801 2362386 2362386 defendant Banery William draper 612266 612266 Banery, William, of Blythe, draper 1
5018802 2362386 2362386 defendant Watson John barker 612266 612266 Watson, John, of Blythe, barker 2
5018803 2362386 2362386 defendant Hancok Robert yeoman 612266 612266 Hancok, Robert, of Blythe, yeoman 3
5022583 2363510 2363510 defendant Banerhey or Baverhey William draper 612266 612266 Banerhey or Baverhey, William, of Blythe, draper 0
5032808 2366483 2366483 defendant Banerhey William draper 612266 612266 Banerhey, William, of Blythe, draper 0
5032809 2366483 2366483 defendant Cotyngham William ostler 612266 612266 Cotyngham, William, of Blythe, ostler 1
5032811 2366483 2366483 defendant de Lyndesay John husbandman 612266 612266 de Lyndesay, John, of Blythe, husbandman 3
5048718 2371253 2371253 defendant Tulker Henry   612266 612266 Tulker, Henry, of Blythe, wright 0
5048719 2371253 2371253 defendant Bocher Robert butcher 612266 612266 Bocher, Robert, of Blythe, butcher 1

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