names

117 rows where place_id = 613341

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
3697868 1925554 1925554 defendant Horseley John butcher 613341 613341 Horseley, John, of Upton on Severn, butcher 0
3697871 1925554 1925554 defendant Jonson Robert carpenter 613341 613341 Jonson, Robert, of Upton on Severn, carpenter 3
3703149 1927257 1927257 defendant Bacheler Thomas husbandman 613341 613341 Bacheler, Thomas, of Upton on Severn, husbandman 1
3899891 1990178 1990178 defendant Pynocke John butcher 613341 613341 Pynocke, John, of Upton on Severn, butcher 0
3937183 2002768 2002768 defendant Hancokys John laborer 613341 613341 Hancokys, John, of Upton on Severn, laborer 1
3938519 2003226 2003226 defendant ap Rice John yeoman 613341 613341 ap Rice, John, of Upton on Severn, yeoman 0
3998384 2024162 2024162 defendant Smyth Grace widow 613341 613341 Smyth, Grace, of Upton on Severn, widow 0
3998385 2024162 2024162 defendant Floyd Evan yeoman 613341 613341 Floyd, Evan, of Upton on Severn, yeoman 1
3998386 2024162 2024162 defendant Trewman John yeoman 613341 613341 Trewman, John, of Upton on Severn, yeoman 2
4150025 2078144 2078144 defendant Baker alias Williams Francis yeoman 613341 613341 Baker alias Williams, Francis, of Upton on Severn, yeoman 0
4150027 2078145 2078145 defendant Baker Francis yeoman 613341 613341 Baker, Francis, of Upton on Severn, yeoman 0
4246907 2111939 2111939 defendant Powes William butcher 613341 613341 Powes, William, of Upton on Severn, butcher 0
4287223 2125488 2125488 defendant Oliver William shoemaker 613341 613341 Oliver, William, of Upton on Severn, shoemaker 0
4409575 2167800 2167800 defendant Jackson Ralph yeoman 613341 613341 Jackson, Ralph, of Upton on Severn, yeoman 0
4414810 2169536 2169536 defendant Avery Robert   613341 613341 Avery, Robert, of Upton on Severn 0
4422658 2171941 2171941 defendant Avery Robert   613341 613341 Avery, Robert, of Upton on Severn 0
4427959 2173585 2173585 plaintiff Spenser Robert le   613341 613341 Spenser, Robert le, of Upton on Severn, son of Geoffrey 0
4427960 2173585 2173585 defendant Spenser Geoffrey le   613341 613341 Spenser, Geoffrey le, of Upton on Severn 0
4436533 2176163 2176163 plaintiff Spenser Geoffrey le   613341 613341 Spenser, Geoffrey le, of Upton on Severn 0
4436535 2176164 2176164 plaintiff Spenser Geoffrey le   613341 613341 Spenser, Geoffrey le, of Upton on Severn 0
4617817 2236576 2236576 defendant Grove Richard   613341 613341 Grove, Richard, of Upton on Severn 0
4627965 2239671 2239671 defendant ap Yerward Hugh   613341 613341 ap Yerward, Hugh, of Upton on Severn 1
4627972 2239672 2239672 defendant ap Yerward Hugh   613341 613341 ap Yerward, Hugh, of Upton on Severn 1
4663924 2250200 2250200 defendant Grove Richard   613341 613341 Grove, Richard, of Upton on Severn 0
4706457 2267400 2267400 defendant Cokkes John butcher 613341 613341 Cokkes, John, of Upton on Severn, butcher 1
4708749 2268107 2268107 defendant Kerdyf Thomas husbandman 613341 613341 Kerdyf, Thomas, of Upton on Severn, husbandman 0
4718369 2271085 2271085 defendant Crokes John husbandman 613341 613341 Crokes, John, of Upton on Severn, husbandman 1
4738669 2277185 2277185 defendant Pillaby Hugh husbandman 613341 613341 Pillaby, Hugh, of Upton on Severn, husbandman 0
4738670 2277185 2277185 defendant Spenser alias Sockes Robert yeoman 613341 613341 Spenser alias Sockes, Robert, of Upton on Severn, yeoman 1
4747991 2279923 2279923 defendant Cokkes John husbandman 613341 613341 Cokkes, John, of Upton on Severn, husbandman 0
4838887 2308094 2308094 plaintiff Grove Nicholas   613341 613341 Grove, Nicholas, of Upton on Severn 0
4860524 2314647 2314647 defendant Freman Thomas husbandman 613341 613341 Freman, Thomas, of Upton on Severn, husbandman 0
4868899 2317249 2317249 defendant Kerdyf Thomas (legal representative) 613341 613341 Kerdyf, Thomas, of Upton on Severn, executrix of 0
4868900 2317249 2317249 defendant Kerdyf Alice widow 613341 613341 Kerdyf, Alice, of Upton on Severn, widow 1
4953624 2343050 2343050 defendant Galbyssh Walter husbandman 613341 613341 Galbyssh, Walter, of Upton on Severn, husbandman 2
4953625 2343050 2343050 defendant Galbyssh Ellem widow 613341 613341 Galbyssh, Ellem, of Upton on Severn, widow 3
4985140 2352484 2352484 defendant Grove Nicholas husbandman 613341 613341 Grove, Nicholas, of Upton on Severn, husbandman 0
5045838 2370388 2370388 defendant Simondys William yeoman 613341 613341 Simondys, William, of Upton on Severn, yeoman 3
5055400 2373198 2373198 defendant Symondys William yeoman 613341 613341 Symondys, William, of Upton on Severn, yeoman 2
5059579 2374435 2374435 defendant Cokkys Nicholas butcher 613341 613341 Cokkys, Nicholas, of Upton on Severn, butcher 0
5100435 2386566 2386566 defendant Grove Nicholas husbandman 613341 613341 Grove, Nicholas, of Upton on Severn, husbandman 1
5100436 2386566 2386566 defendant Symondes William husbandman 613341 613341 Symondes, William, of Upton on Severn, husbandman 2
5100437 2386566 2386566 defendant Baker Geoffrey baker 613341 613341 Baker, Geoffrey, of Upton on Severn, baker 3
5100438 2386566 2386566 defendant Emson William husbandman 613341 613341 Emson, William, of Upton on Severn, husbandman 4
5100439 2386566 2386566 defendant Heyward John laborer 613341 613341 Heyward, John, of Upton on Severn, laborer 5
5100440 2386566 2386566 defendant Grygge William fisher 613341 613341 Grygge, William, of Upton on Severn, fisher 6
5100441 2386566 2386566 defendant Dekyn Thomas husbandman 613341 613341 Dekyn, Thomas, of Upton on Severn, husbandman 7
5100442 2386566 2386566 defendant Pakker Geoffrey husbandman 613341 613341 Pakker, Geoffrey, of Upton on Severn, husbandman 8
5100443 2386566 2386566 defendant Smyth John smith 613341 613341 Smyth, John, of Upton on Severn, smith 9
5100444 2386566 2386566 defendant Drewe John butcher 613341 613341 Drewe, John, of Upton on Severn, butcher 10
5100445 2386566 2386566 defendant Pynnok John butcher 613341 613341 Pynnok, John, of Upton on Severn, butcher 11
5100446 2386566 2386566 defendant Cokkys Nicholas butcher 613341 613341 Cokkys, Nicholas, of Upton on Severn, butcher 12
5100447 2386566 2386566 defendant Carpenter John carpenter 613341 613341 Carpenter, John, of Upton on Severn, carpenter 13
5100448 2386566 2386566 defendant Batte William husbandman 613341 613341 Batte, William, of Upton on Severn, husbandman 14
5100449 2386566 2386566 defendant Paccheford John cordwainer 613341 613341 Paccheford, John, of Upton on Severn, cordwainer 15
5100450 2386566 2386566 defendant Poule John cordwainer 613341 613341 Poule, John, of Upton on Severn, cordwainer 16
5100451 2386566 2386566 defendant Kynges John husbandman 613341 613341 Kynges, John, of Upton on Severn, husbandman 17
5100452 2386566 2386566 defendant Yeman John weaver 613341 613341 Yeman, John, of Upton on Severn, weaver 18
5100453 2386566 2386566 defendant Berkley John yeoman 613341 613341 Berkley, John, of Upton on Severn, yeoman 19
5100454 2386566 2386566 defendant Berkley William husbandman 613341 613341 Berkley, William, of Upton on Severn, husbandman 20
5100455 2386566 2386566 defendant Pyncher John husbandman 613341 613341 Pyncher, John, of Upton on Severn, husbandman 21
5100456 2386566 2386566 defendant Pyncher William husbandman 613341 613341 Pyncher, William, of Upton on Severn, husbandman 22
5100457 2386566 2386566 defendant Cokkes Thomas husbandman 613341 613341 Cokkes, Thomas, of Upton on Severn, husbandman 23
5100458 2386566 2386566 defendant Payn Thomas husbandman 613341 613341 Payn, Thomas, of Upton on Severn, husbandman 24
5100459 2386566 2386566 defendant Felde Walter husbandman 613341 613341 Felde, Walter, of Upton on Severn, husbandman 25
5100460 2386566 2386566 defendant Broughton William fisher 613341 613341 Broughton, William, of Upton on Severn, fisher 26
5100461 2386566 2386566 defendant Grayell Nicholas husbandman 613341 613341 Grayell, Nicholas, of Upton on Severn, husbandman 27
5100462 2386566 2386566 defendant Turnour John yeoman 613341 613341 Turnour, John, of Upton on Severn, yeoman 28
5100463 2386566 2386566 defendant Racche Thomas laborer 613341 613341 Racche, Thomas, of Upton on Severn, laborer 29
5100464 2386566 2386566 defendant Racche John tailor 613341 613341 Racche, John, of Upton on Severn, tailor 30
5100465 2386566 2386566 defendant Mody John husbandman 613341 613341 Mody, John, of Upton on Severn, husbandman 31
5100466 2386566 2386566 defendant Underwode Richard yeoman 613341 613341 Underwode, Richard, of Upton on Severn, yeoman 32
5100469 2386567 2386567 defendant Grove Nicholas husbandman 613341 613341 Grove, Nicholas, of Upton on Severn, husbandman 1
5100470 2386567 2386567 defendant Symondes William husbandman 613341 613341 Symondes, William, of Upton on Severn, husbandman 2
5100471 2386567 2386567 defendant Baker Geoffrey baker 613341 613341 Baker, Geoffrey, of Upton on Severn, baker 3
5100472 2386567 2386567 defendant Emson William husbandman 613341 613341 Emson, William, of Upton on Severn, husbandman 4
5100473 2386567 2386567 defendant Heyward John laborer 613341 613341 Heyward, John, of Upton on Severn, laborer 5
5100474 2386567 2386567 defendant Grygge William fisher 613341 613341 Grygge, William, of Upton on Severn, fisher 6
5100475 2386567 2386567 defendant Dekyn Thomas husbandman 613341 613341 Dekyn, Thomas, of Upton on Severn, husbandman 7
5100476 2386567 2386567 defendant Pakker Geoffrey husbandman 613341 613341 Pakker, Geoffrey, of Upton on Severn, husbandman 8
5100477 2386567 2386567 defendant Smyth John smith 613341 613341 Smyth, John, of Upton on Severn, smith 9
5100478 2386567 2386567 defendant Drewe John butcher 613341 613341 Drewe, John, of Upton on Severn, butcher 10
5100479 2386567 2386567 defendant Pynnok John butcher 613341 613341 Pynnok, John, of Upton on Severn, butcher 11
5100480 2386567 2386567 defendant Cokkys Nicholas butcher 613341 613341 Cokkys, Nicholas, of Upton on Severn, butcher 12
5100481 2386567 2386567 defendant Carpenter John carpenter 613341 613341 Carpenter, John, of Upton on Severn, carpenter 13
5100482 2386567 2386567 defendant Batte William husbandman 613341 613341 Batte, William, of Upton on Severn, husbandman 14
5100483 2386567 2386567 defendant Paccheford John cordwainer 613341 613341 Paccheford, John, of Upton on Severn, cordwainer 15
5100484 2386567 2386567 defendant Poule John cordwainer 613341 613341 Poule, John, of Upton on Severn, cordwainer 16
5100485 2386567 2386567 defendant Kynges John husbandman 613341 613341 Kynges, John, of Upton on Severn, husbandman 17
5100486 2386567 2386567 defendant Yeman John waver 613341 613341 Yeman, John, of Upton on Severn, waver 18
5100487 2386567 2386567 defendant Berkley John yeoman 613341 613341 Berkley, John, of Upton on Severn, yeoman 19
5100488 2386567 2386567 defendant Berkley William husbandman 613341 613341 Berkley, William, of Upton on Severn, husbandman 20
5100489 2386567 2386567 defendant Pyncher John husbandman 613341 613341 Pyncher, John, of Upton on Severn, husbandman 21
5100490 2386567 2386567 defendant Pyncher William husbandman 613341 613341 Pyncher, William, of Upton on Severn, husbandman 22
5100491 2386567 2386567 defendant Cokkes Thomas husbandman 613341 613341 Cokkes, Thomas, of Upton on Severn, husbandman 23
5100492 2386567 2386567 defendant Payn Thomas husbandman 613341 613341 Payn, Thomas, of Upton on Severn, husbandman 24
5100493 2386567 2386567 defendant Felde Walter husbandman 613341 613341 Felde, Walter, of Upton on Severn, husbandman 25
5100494 2386567 2386567 defendant Pynnok Richard yeoman 613341 613341 Pynnok, Richard, of Upton on Severn, yeoman 26
5100495 2386567 2386567 defendant Ormes William husbandman 613341 613341 Ormes, William, of Upton on Severn, husbandman 27
5100496 2386567 2386567 defendant Broughton William fisher 613341 613341 Broughton, William, of Upton on Severn, fisher 28

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