names

161 rows where place_id = 595562

✎ 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
3620999 1874125 1874125 defendant Walker Thomas walker 595562 595562 Walker, Thomas, of Bromesgrove, walker 2
3621000 1874125 1874125 defendant Corveser Richard cordwainer 595562 595562 Corveser, Richard, of Bromesgrove, cordwainer 3
3650691 1910583 1910583 defendant Hasylbere Thomas husbandman 595562 595562 Hasylbere, Thomas, of Bromesgrove, husbandman 1
3650692 1910583 1910583 defendant Bassy John husbandman 595562 595562 Bassy, John, of Bromesgrove, husbandman 2
3650693 1910583 1910583 defendant Bleke Richard husbandman 595562 595562 Bleke, Richard, of Bromesgrove, husbandman 3
3650694 1910583 1910583 defendant Baker Richard husbandman 595562 595562 Baker, Richard, of Bromesgrove, husbandman 4
3650695 1910583 1910583 defendant Appere William husbandman 595562 595562 Appere, William, of Bromesgrove, husbandman 5
3650698 1910583 1910583 defendant Colens John husbandman 595562 595562 Colens, John, of Bromesgrove, husbandman 8
3650736 1910594 1910594 defendant Flemmyng Walter yeoman 595562 595562 Flemmyng, Walter, of Bromesgrove, yeoman 1
3650737 1910594 1910594 defendant Hasylbere Thomas husbandman 595562 595562 Hasylbere, Thomas, of Bromesgrove, husbandman 2
3655647 1912030 1912030 defendant Colle William fuller 595562 595562 Colle, William, of Bromesgrove, fuller 0
3655648 1912030 1912030 defendant Lane John tanner 595562 595562 Lane, John, of Bromesgrove, tanner 1
3655649 1912030 1912030 defendant Bragge John laborer 595562 595562 Bragge, John, of Bromesgrove, laborer 2
3655650 1912030 1912030 defendant Pye John laborer 595562 595562 Pye, John, of Bromesgrove, laborer 3
3682477 1920621 1920621 defendant Borneford John yeoman 595562 595562 Borneford, John, of Bromesgrove, yeoman 0
3682479 1920622 1920622 defendant Borneford John yeoman 595562 595562 Borneford, John, of Bromesgrove, yeoman 0
3692127 1923707 1923707 defendant Bradley John draper 595562 595562 Bradley, John, of Bromesgrove, draper 1
3692128 1923707 1923707 defendant Baker Thomas baker 595562 595562 Baker, Thomas, of Bromesgrove, baker 2
3692446 1923816 1923816 defendant Rose John yeoman 595562 595562 Rose, John, of Bromesgrove, yeoman 0
3710192 1929503 1929503 defendant Baker John smith 595562 595562 Baker, John, of Bromesgrove, smith 0
3714013 1930681 1930681 defendant Blanket John husbandman 595562 595562 Blanket, John, of Bromesgrove, husbandman 1
3717217 1931671 1931671 defendant Chaunce John shoemaker 595562 595562 Chaunce, John, of Bromesgrove, shoemaker 1
3729018 1935324 1935324 defendant Hyll Nicholas laborer 595562 595562 Hyll, Nicholas, of Bromesgrove, laborer 0
3732145 1936290 1936290 defendant Stryngslowe Henry cordwainer 595562 595562 Stryngslowe, Henry, of Bromesgrove, cordwainer 0
3734201 1936938 1936938 defendant Wodward alias Blonket Thomas husbandman 595562 595562 Wodward alias Blonket, Thomas, of Bromesgrove, husbandman 0
3753628 1943078 1943078 defendant Hancok Richard husbandman 595562 595562 Hancok, Richard, of Bromesgrove, husbandman 0
3753783 1943123 1943123 defendant Cole Henry yeoman 595562 595562 Cole, Henry, of Bromesgrove, yeoman 3
3758636 1944695 1944695 defendant Robyns John yeoman 595562 595562 Robyns, John, of Bromesgrove, yeoman 1
3774440 1949730 1949730 defendant Chaunce Nicholas yeoman 595562 595562 Chaunce, Nicholas, of Bromesgrove, yeoman 2
3782325 1952226 1952226 defendant Lee William yeoman 595562 595562 Lee, William, of Bromesgrove, yeoman 1
3782326 1952226 1952226 defendant Bradley Richard yeoman 595562 595562 Bradley, Richard, of Bromesgrove, yeoman 2
3782327 1952226 1952226 defendant Lee Elizabeth widow 595562 595562 Lee, Elizabeth, of Bromesgrove, widow 3
3782328 1952226 1952226 defendant Rychardys John smith 595562 595562 Rychardys, John, of Bromesgrove, smith 4
3785850 1953363 1953363 defendant Blanket Thomas husbandman 595562 595562 Blanket, Thomas, of Bromesgrove, husbandman 3
3832875 1968207 1968207 defendant Blyke Thomas cooper 595562 595562 Blyke, Thomas, of Bromesgrove, cooper 0
3832876 1968207 1968207 defendant Blyke Richard mercer 595562 595562 Blyke, Richard, of Bromesgrove, mercer 1
3832877 1968207 1968207 defendant Bradley John draper 595562 595562 Bradley, John, of Bromesgrove, draper 2
3832878 1968207 1968207 defendant Darby Thomas nailer 595562 595562 Darby, Thomas, of Bromesgrove, nailer 3
3837152 1969521 1969521 defendant Blyke Richard yeoman 595562 595562 Blyke, Richard, of Bromesgrove, yeoman 1
3837153 1969521 1969521 defendant Bradeley John draper 595562 595562 Bradeley, John, of Bromesgrove, draper 2
3844133 1971712 1971712 defendant Bewpe Edward gent 595562 595562 Bewpe, Edward, of Bromesgrove, gent 1
3846664 1972512 1972512 defendant Heekys Humphrey fuller 595562 595562 Heekys, Humphrey, of Bromesgrove, fuller 1
3846665 1972512 1972512 defendant Lett Nicholas weaver 595562 595562 Lett, Nicholas, of Bromesgrove, weaver 2
3846715 1972528 1972528 defendant Daffy Humphrey yeoman 595562 595562 Daffy, Humphrey, of Bromesgrove, yeoman 0
3847275 1972710 1972710 defendant Fowke Henry husbandman 595562 595562 Fowke, Henry, of Bromesgrove, husbandman 0
3851210 1973974 1973974 defendant Persall William butcher 595562 595562 Persall, William, of Bromesgrove, butcher 1
3851267 1973994 1973994 defendant Bradeley John draper 595562 595562 Bradeley, John, of Bromesgrove, draper 0
3863672 1978034 1978034 defendant Bradeley John laborer 595562 595562 Bradeley, John, of Bromesgrove, laborer 1
3869093 1979910 1979910 defendant Mathewe alias Blokley Robert butcher 595562 595562 Mathewe alias Blokley, Robert, of Bromesgrove, butcher 1
3870876 1980512 1980512 defendant Hancocke William tanner 595562 595562 Hancocke, William, of Bromesgrove, tanner 0
3878585 1983085 1983085 defendant Burlton Roger   595562 595562 Burlton, Roger, of Bromesgrove, "siviard" 0
3912455 1994494 1994494 defendant Chaunce Roger husbandman 595562 595562 Chaunce, Roger, of Bromesgrove, husbandman 4
3912461 1994495 1994495 defendant Underhyll Richard butcher 595562 595562 Underhyll, Richard, of Bromesgrove, butcher 4
3912840 1994624 1994624 defendant Persall William butcher 595562 595562 Persall, William, of Bromesgrove, butcher 4
3916783 1995980 1995980 defendant Brace John husbandman 595562 595562 Brace, John, of Bromesgrove, husbandman 0
3916784 1995980 1995980 defendant Hykes John cooper 595562 595562 Hykes, John, of Bromesgrove, cooper 1
3918734 1996596 1996596 defendant Persall William butcher 595562 595562 Persall, William, of Bromesgrove, butcher 0
3982821 2018628 2018628 defendant Hancock William tanner 595562 595562 Hancock, William, of Bromesgrove, tanner 2
3991246 2021632 2021632 defendant Cooke William merchant tailor 595562 595562 Cooke, William, of Bromesgrove, merchant tailor 0
4009745 2028253 2028253 defendant Astmore William gent 595562 595562 Astmore, William, of Bromesgrove, gent 0
4014125 2029782 2029782 defendant Astmore William gent 595562 595562 Astmore, William, of Bromesgrove, gent 0
4014126 2029782 2029782 defendant Hewes Richard fuller 595562 595562 Hewes, Richard, of Bromesgrove, fuller 1
4022885 2032909 2032909 defendant Gracewith Thomas innholder 595562 595562 Gracewith, Thomas, of Bromesgrove, innholder 0
4022887 2032910 2032910 defendant Gracewith Thomas innholder 595562 595562 Gracewith, Thomas, of Bromesgrove, innholder 0
4039090 2038607 2038607 plaintiff Lowe George shoemaker 595562 595562 Lowe, George, of Bromesgrove, shoemaker 0
4039091 2038607 2038607 defendant Bate Mathew husbandman 595562 595562 Bate, Mathew, of Bromesgrove, husbandman 0
4039092 2038608 2038608 plaintiff Lowe George shoemaker 595562 595562 Lowe, George, of Bromesgrove, shoemaker 0
4083798 2054480 2054480 defendant Cooke William tailor 595562 595562 Cooke, William, of Bromesgrove, tailor 0
4091646 2057305 2057305 defendant Wharton Richard yeoman 595562 595562 Wharton, Richard, of Bromesgrove, yeoman 2
4132970 2072118 2072118 defendant Badger Thomas yeoman 595562 595562 Badger, Thomas, of Bromesgrove, yeoman 1
4147564 2077290 2077290 defendant Cooke Edward yeoman 595562 595562 Cooke, Edward, of Bromesgrove, yeoman 1
4172599 2085875 2085875 defendant Cocke Edward   595562 595562 Cocke, Edward, of Bromesgrove, yeoman, his son 1
4174335 2086485 2086485 defendant Wakeman Roger yeoman 595562 595562 Wakeman, Roger, of Bromesgrove, yeoman 0
4174337 2086486 2086486 defendant Wakeman Roger yeoman 595562 595562 Wakeman, Roger, of Bromesgrove, yeoman 0
4182607 2089394 2089394 defendant Haule Thomas yeoman 595562 595562 Haule, Thomas, of Bromesgrove, yeoman 0
4182609 2089395 2089395 defendant Hanle or Haule Thomas yeoman 595562 595562 Hanle or Haule, Thomas, of Bromesgrove, yeoman 0
4182664 2089418 2089418 defendant Norres William yeoman 595562 595562 Norres, William, of Bromesgrove, yeoman 0
4182665 2089418 2089418 defendant Fowlke William yeoman 595562 595562 Fowlke, William, of Bromesgrove, yeoman 1
4183685 2089782 2089782 defendant Hall Thomas husbandman 595562 595562 Hall, Thomas, of Bromesgrove, husbandman 0
4224036 2103892 2103892 defendant Bourne Hugh yeoman 595562 595562 Bourne, Hugh, of Bromesgrove, yeoman 0
4224038 2103893 2103893 defendant Wilkes Thomas yeoman 595562 595562 Wilkes, Thomas, of Bromesgrove, yeoman 0
4225537 2104396 2104396 defendant Hancoxe Thomas glover 595562 595562 Hancoxe, Thomas, of Bromesgrove, glover 0
4298152 2129439 2129439 defendant Shaylard Richard tailor 595562 595562 Shaylard, Richard, of Bromesgrove, tailor 3
4299008 2129739 2129739 defendant Bysley Thomas yeoman 595562 595562 Bysley, Thomas, of Bromesgrove, or of Morton Baggett, Warks, yeoman 0
4328640 2139893 2139893 defendant Bourne Hugh yeoman 595562 595562 Bourne, Hugh, of Bromesgrove, yeoman 1
4329551 2140185 2140185 defendant Gracewith Thomas gent 595562 595562 Gracewith, Thomas, of Bromesgrove, gent 1
4330043 2140350 2140350 defendant Baylyes William yeoman 595562 595562 Baylyes, William, of Bromesgrove, yeoman 1
4330057 2140353 2140353 defendant Baylyes William yeoman 595562 595562 Baylyes, William, of Bromesgrove, yeoman 1
4332343 2141109 2141109 defendant Bysley Thomas yeoman 595562 595562 Bysley, Thomas, of Bromesgrove, or of Morton Baggett, Warks, yeoman 0
4364645 2152413 2152413 defendant Carryngton Gervase clerk 595562 595562 Carryngton, Gervase, of Bromesgrove, clerk 0
4374020 2155779 2155779 defendant Tayler John smith 595562 595562 Tayler, John, of Bromesgrove, smith 0
4374021 2155779 2155779 defendant Pierse John miller 595562 595562 Pierse, John, of Bromesgrove, miller 1
4387694 2160520 2160520 defendant Cartwrighte Mathew clothworker 595562 595562 Cartwrighte, Mathew, of Bromesgrove, clothworker 0
4388920 2160926 2160926 defendant Parre Anne widow 595562 595562 Parre, Anne, of Bromesgrove, widow 0
4389676 2161176 2161176 defendant Norrys Henry, junior smith 595562 595562 Norrys, Henry, junior, of Bromesgrove, smith 2
4389677 2161176 2161176 defendant Ashefeilde William husbandman 595562 595562 Ashefeilde, William, of Bromesgrove, husbandman 3
4391664 2161830 2161830 defendant Stretche William husbandman 595562 595562 Stretche, William, of Bromesgrove, husbandman 1
4408134 2167290 2167290 defendant Carington Gervase   595562 595562 Carington, Gervase, of Bromesgrove, clerk, Bachelor of Law 2
4408138 2167291 2167291 defendant Carington Gervase   595562 595562 Carington, Gervase, of Bromesgrove, clerk, Bachelor of Law 2
4423797 2172290 2172290 defendant Acton John de   595562 595562 Acton, John de, of Bromesgrove, son of Roger 0

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