names

94 rows where place_id = 595456

✎ 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
3620543 1874000 1874000 defendant Frith Richard husbandman 595456 595456 Frith, Richard, of Alveley, husbandman 0
3667127 1915651 1915651 defendant Dymmok Edmund husbandman 595456 595456 Dymmok, Edmund, of Alveley, husbandman 0
3691695 1923562 1923562 defendant Dallowe John laborer 595456 595456 Dallowe, John, of Alveley, laborer 0
3703070 1927235 1927235 defendant Gravenour John butcher 595456 595456 Gravenour, John, of Alveley, butcher 0
3718881 1932184 1932184 defendant Armon Edward baker 595456 595456 Armon, Edward, of Alveley, baker 0
3728661 1935202 1935202 plaintiff Wyther Edmund bricklayer 595456 595456 Wyther, Edmund, of Alveley, bricklayer 0
3732563 1936413 1936413 defendant Bocher Henry butcher 595456 595456 Bocher, Henry, of Alveley, butcher 0
3733524 1936729 1936729 defendant Potter Thomas husbandman 595456 595456 Potter, Thomas, of Alveley, husbandman 0
3734594 1937066 1937066 defendant Armon Edward baker 595456 595456 Armon, Edward, of Alveley, baker 0
3751200 1942300 1942300 defendant Hurte Ralph husbandman 595456 595456 Hurte, Ralph, of Alveley, husbandman 0
3787690 1953933 1953933 plaintiff Rutter Hieronimus husbandman 595456 595456 Rutter, Hieronimus, of Alveley, husbandman 0
3787691 1953933 1953933 defendant Gulson Thomas yeoman 595456 595456 Gulson, Thomas, of Alveley, yeoman 0
3787692 1953933 1953933 defendant Johannes Edward gent 595456 595456 Johannes, Edward, of Alveley, gent 1
3797619 1957152 1957152 defendant Everdon Agnes spinster 595456 595456 Everdon, Agnes, of Alveley, spinster 1
3819126 1963873 1963873 defendant Maior Robert husbandman 595456 595456 Maior, Robert, of Alveley, husbandman 1
3827592 1966491 1966491 defendant Lawley John laborer 595456 595456 Lawley, John, of Alveley, laborer 0
3831798 1967845 1967845 defendant Laweley David yeoman 595456 595456 Laweley, David, of Alveley, yeoman 0
3831802 1967846 1967846 defendant Lawley David yeoman 595456 595456 Lawley, David, of Alveley, yeoman 0
3832726 1968159 1968159 defendant Johns Edward (legal representative) 595456 595456 Johns, Edward, of Alveley, gent, executrix of 0
3850658 1973794 1973794 defendant Kendalle John shoemaker 595456 595456 Kendalle, John, of Alveley, shoemaker 3
3852004 1974216 1974216 defendant Ynglysshe John clerk 595456 595456 Ynglysshe, John, of Alveley, clerk 0
3861766 1977401 1977401 plaintiff Blyke Giles gent 595456 595456 Blyke, Giles, of Alveley, gent 1
3875866 1982184 1982184 plaintiff Blyke Giles gent 595456 595456 Blyke, Giles, of Alveley, gent 1
3888622 1986450 1986450 defendant Arden John husbandman 595456 595456 Arden, John, of Alveley, husbandman 1
3938547 2003233 2003233 defendant Elkoke alias Elcoxe James yeoman 595456 595456 Elkoke alias Elcoxe, James, of Alveley, yeoman 1
3951625 2007622 2007622 defendant Longeley John yeoman 595456 595456 Longeley, John, of Alveley, yeoman 1
3952911 2008089 2008089 defendant Nycoll James husbandman 595456 595456 Nycoll, James, of Alveley, husbandman 0
3952912 2008089 2008089 defendant Watter Richard husbandman 595456 595456 Watter, Richard, of Alveley, husbandman 1
3954528 2008654 2008654 defendant Elcock alias Bradley Arthur husbandman 595456 595456 Elcock alias Bradley, Arthur, of Alveley, husbandman 1
3954813 2008752 2008752 defendant Steward John yeoman 595456 595456 Steward, John, of Alveley, yeoman 0
4006887 2027239 2027239 defendant Jurdem John husbandman 595456 595456 Jurdem John, of Alveley, husbandman 0
4061932 2046666 2046666 defendant Potter Humphrey (legal representative) 595456 595456 Potter, Humphrey, of Alveley, yeoman, executor of 0
4063897 2047370 2047370 defendant Baskerfeild Lancelot yeoman 595456 595456 Baskerfeild, Lancelot, of Alveley, yeoman 0
4065513 2047955 2047955 defendant Howelles Henry yeoman 595456 595456 Howelles, Henry, of Alveley, yeoman 0
4069104 2049241 2049241 defendant Ellyott Thomas husbandman 595456 595456 Ellyott, Thomas, of Alveley, husbandman 0
4081401 2053655 2053655 defendant Howlett George yeoman 595456 595456 Howlett, George, of Alveley, yeoman 1
4085335 2055035 2055035 defendant Howell Henry yeoman 595456 595456 Howell, Henry, of Alveley, yeoman 0
4087307 2055751 2055751 defendant Raynold Hugh husbandman 595456 595456 Raynold, Hugh, of Alveley, husbandman 0
4092492 2057621 2057621 defendant Nycoll or Nicoles John yeoman 595456 595456 Nycoll or Nicoles, John, of Alveley, yeoman 0
4144652 2076287 2076287 defendant White Roland yeoman 595456 595456 White, Roland, of Alveley, yeoman 1
4150463 2078291 2078291 defendant Lawley Arthur yeoman 595456 595456 Lawley, Arthur, of Alveley, yeoman 1
4165742 2083517 2083517 defendant Lawley Arthur yeoman 595456 595456 Lawley, Arthur, of Alveley, yeoman 0
4165744 2083518 2083518 defendant Potter Thomas, senior yeoman 595456 595456 Potter, Thomas, senior, of Alveley, yeoman 0
4184297 2090009 2090009 defendant Arden Edward laborer 595456 595456 together with Arden, Edward, of Alveley, laborer 1
4184298 2090009 2090009 defendant Arden Thomas laborer 595456 595456 Arden, Thomas, of Alveley, laborer 2
4184299 2090009 2090009 defendant Niccolls Thomas weaver 595456 595456 Niccolls, Thomas, of Alveley, weaver 3
4214480 2100574 2100574 defendant Padyam Andrew (legal representative) 595456 595456 Padyam, Andrew, of Alveley, yeoman, executors of 0
4214481 2100574 2100574 defendant Brett Robert yeoman 595456 595456 (Brett, Robert, of Alveley, yeoman 1
4232278 2106794 2106794 defendant Casall John chapman 595456 595456 Casall, John, of Alveley, chapman 0
4330966 2140657 2140657 defendant Howell John yeoman 595456 595456 Howell, John, of Alveley, yeoman 0
4330967 2140657 2140657 defendant Elcocke Henry yeoman 595456 595456 Elcocke, Henry, of Alveley, yeoman 1
4330968 2140657 2140657 defendant Hill John yeoman 595456 595456 Hill, John, of Alveley, yeoman 2
4347572 2146397 2146397 defendant Lee Arthur husbandman 595456 595456 Lee, Arthur, of Alveley, husbandman 0
4404811 2166176 2166176 defendant Nycoll Humphrey yeoman 595456 595456 Nycoll, Humphrey, of Alveley, yeoman 0
4635894 2242060 2242060 defendant Carter John   595456 595456 Carter, John, of Alveley 2
4635898 2242061 2242061 defendant Carter John   595456 595456 Carter, John, of Alveley 2
4969315 2347782 2347782 defendant Devile William tailor 595456 595456 Devile, William, of Alveley, tailor 2
4999640 2356768 2356768 defendant Spenser Richard husbandman 595456 595456 Spenser, Richard, of Alveley, husbandman 0
5034048 2366824 2366824 defendant Potter William, senior husbandman 595456 595456 Potter, William, senior, of Alveley, husbandman 1
5034049 2366824 2366824 defendant atte Lee William husbandman 595456 595456 atte Lee, William, of Alveley, husbandman 2
5034050 2366824 2366824 defendant Potter John husbandman 595456 595456 Potter, John, of Alveley, husbandman 3
5034051 2366824 2366824 defendant Unwyn Thomas weaver 595456 595456 Unwyn, Thomas, of Alveley, weaver 4
5034052 2366824 2366824 defendant Thomyns John husbandman 595456 595456 Thomyns, John, of Alveley, husbandman 5
5053500 2372651 2372651 defendant Cosyn William smith 595456 595456 Cosyn, William, of Alveley, smith 0
5075762 2379251 2379251 defendant Pert William gent 595456 595456 Pert, William,of Alveley, gent 0
5179975 2409876 2409876 defendant Wade Robert gent 595456 595456 Wade, Robert, of Alveley, gent 0
5214900 2420077 2420077 defendant Smyth William husbandman 595456 595456 Smyth, William, of Alveley, husbandman 0
5215321 2420210 2420210 defendant Smyth Thomas husbandman 595456 595456 Smyth, Thomas, of Alveley, husbandman 2
5218366 2421104 2421104 defendant Smyth Thomas yeoman 595456 595456 Smyth, Thomas, of Alveley, yeoman 0
5224483 2422831 2422831 defendant Pert William gent 595456 595456 Pert, William, of Alveley, gent 3
5247201 2429340 2429340 defendant Millener Peter miller 595456 595456 Millener, Peter, of Alveley, miller 1
5279991 2439218 2439218 defendant Stubber John butcher 595456 595456 Stubber, John, of Alveley, butcher 2
5318887 2450743 2450743 defendant Langeley Thomas yeoman 595456 595456 Langeley, Thomas, of Alveley, yeoman 0
5337353 2456243 2456243 defendant Cantelowe Thomas gent 595456 595456 Cantelowe, Thomas, of Alveley, gent 0
5337354 2456243 2456243 defendant Stevyn Gilbert   595456 595456 Stevyn, Gilbert, of Alveley 1
5337355 2456243 2456243 defendant Stevyn James laborer 595456 595456 Stevyn, James, of Alveley, laborer 2
5337357 2456243 2456243 defendant Neweman John laborer 595456 595456 Neweman, John, of Alveley, laborer 4
5356545 2462117 2462117 defendant Cantelowe Thomas gent 595456 595456 Cantelowe, Thomas, of Alveley, gent 0
5365604 2464914 2464914 defendant Reynoldys Thomas tailor 595456 595456 Reynoldys, Thomas, of Alveley, tailor 0
5390938 2472474 2472474 defendant Lowe Hugh yeoman 595456 595456 Lowe, Hugh, of Alveley, yeoman 0
5396322 2474039 2474039 defendant Reyignoldis Thomas tailor 595456 595456 Reyignoldis, Thomas, of Alveley, tailor 0
5403899 2476187 2476187 defendant Lowe Hugh yeoman 595456 595456 Lowe, Hugh, of Alveley, yeoman 0
5409635 2477851 2477851 defendant Reigholdis Thomas tailor 595456 595456 Reigholdis, Thomas, of Alveley, tailor 0
5417011 2479999 2479999 defendant Lo_ Hugh yeoman 595456 595456 Lo_, Hugh, of Alveley, yeoman 0
5425526 2482611 2482611 defendant Pert William gent 595456 595456 Pert, William, of Alveley, gent 2
5425531 2482612 2482612 defendant Pert William gent 595456 595456 Pert, William, of Alveley, gent 2
5443961 2488113 2488113 defendant Pert William gent 595456 595456 Pert, William, of Alveley, gent 1
5445858 2488649 2488649 defendant Pert William gent 595456 595456 Pert, William, of Alveley, gent 1
5467155 2495121 2495121 defendant Neysthe Jacob clerk 595456 595456 Neysthe, Jacob, of Alveley, clerk 2
5470942 2496240 2496240 defendant Lee John husbandman 595456 595456 Lee, John, of Alveley, husbandman 0
5530352 2514004 2514004 plaintiff Reed Henry yeoman 595456 595456 Reed, Henry, of Alveley, yeoman 0
5549321 2519851 2519851 defendant Fernall Humphrey chaplain 595456 595456 Fernall, Humphrey, of Alveley, chaplain 0
5549324 2519851 2519851 defendant Brynsford William husbandman 595456 595456 Brynsford, William, of Alveley, husbandman 3
5549325 2519851 2519851 defendant Fernall John husbandman 595456 595456 Fernall, John, of Alveley, husbandman 4

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