names

63 rows where place_id = 586390

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588606 1864081 1864081 defendant Strangward William clerk 586390 586390 Strangward, William, of Dylwyn, clerk 0
3739701 1938629 1938629 defendant Frysour Thomas husbandman 586390 586390 Frysour, Thomas, of Dylwyn, husbandman 0
3739702 1938629 1938629 defendant Frysour Philip husbandman 586390 586390 Frysour, Philip, of Dylwyn, husbandman 1
3752164 1942605 1942605 defendant Frysour Thomas husbandman 586390 586390 Frysour, Thomas, of Dylwyn, husbandman 0
3752165 1942605 1942605 defendant Frysour Philip husbandman 586390 586390 Frysour, Philip, of Dylwyn, husbandman 1
3753328 1942979 1942979 defendant Rosse John husbandman 586390 586390 Rosse, John, of Dylwyn, husbandman 0
3753329 1942979 1942979 defendant Rosse Thomas husbandman 586390 586390 Rosse, Thomas, of Dylwyn, husbandman 1
3760256 1945210 1945210 defendant Madocke David husbandman 586390 586390 Madocke, David, of Dylwyn, husbandman 1
3763223 1946134 1946134 defendant Madok David husbandman 586390 586390 Madok, David, of Dylwyn, husbandman 0
3770488 1948452 1948452 defendant Madok David husbandman 586390 586390 Madok, David, of Dylwyn, husbandman 0
3772587 1949118 1949118 defendant Moris William yeoman 586390 586390 Moris, William, of Dylwyn, yeoman 2
3838171 1969854 1969854 defendant Marchaunt John husbandman 586390 586390 Marchaunt, John, of Dylwyn, husbandman 0
3872348 1980974 1980974 defendant Smythe Lawrence smith 586390 586390 Smythe, Lawrence, of Dylwyn, smith 3
3872679 1981079 1981079 defendant Nycolls Walter yeoman 586390 586390 Nycolls, Walter, of Dylwyn, yeoman 0
3873899 1981489 1981489 defendant Rosse Thomas yeoman 586390 586390 Rosse, Thomas, of Dylwyn, yeoman 0
3885101 1985276 1985276 defendant Colcome Thomas husbandman 586390 586390 Colcome, Thomas, of Dylwyn, husbandman 0
3905148 1991985 1991985 defendant Bowyer Richard husbandman 586390 586390 Bowyer, Richard, of Dylwyn, husbandman 0
3912058 1994356 1994356 defendant Rosse Joan widow 586390 586390 Rosse, Joan, of Dylwyn, widow 0
3912059 1994356 1994356 defendant Rosse Thomas husbandman 586390 586390 Rosse, Thomas, of Dylwyn, husbandman 1
3913240 1994759 1994759 defendant Mores Hugh husbandman 586390 586390 Mores, Hugh, of Dylwyn, husbandman 0
3918005 1996389 1996389 defendant Grene Walter husbandman 586390 586390 Grene, Walter, of Dylwyn, husbandman 0
3954017 2008474 2008474 defendant Hughes John yeoman 586390 586390 Hughes, John, of Dylwyn, yeoman 0
3970667 2014328 2014328 defendant Morrys Richard yeoman 586390 586390 Morrys, Richard, of Dylwyn, yeoman 1
4008507 2027811 2027811 defendant Stevyns alias Taylor Henry tailor 586390 586390 Stevyns alias Taylor, Henry, of Dylwyn, tailor 2
4019710 2031780 2031780 defendant Colcombe John husbandman 586390 586390 Colcombe, John, of Dylwyn, husbandman 0
4027930 2034639 2034639 defendant Colcombe John yeoman 586390 586390 Colcombe, John, of Dylwyn, yeoman 1
4032426 2036252 2036252 defendant Morrys Ralph yeoman 586390 586390 Morrys, Ralph, of Dylwyn, yeoman 2
4032427 2036252 2036252 defendant Baylye John husbandman 586390 586390 Baylye, John, of Dylwyn, husbandman 3
4032428 2036252 2036252 defendant Morrys John husbandman 586390 586390 Morrys, John, of Dylwyn, husbandman 4
4032445 2036253 2036253 defendant Morys Ralph yeoman 586390 586390 Morys, Ralph, of Dylwyn, yeoman 3
4032446 2036253 2036253 defendant Baylye John yeoman 586390 586390 Baylye, John, of Dylwyn, yeoman 4
4032447 2036253 2036253 defendant Morys John husbandman 586390 586390 Morys, John, of Dylwyn, husbandman 5
4032459 2036253 2036253 defendant Baylye Henry yeoman 586390 586390 ((Baylye, Henry, of Dylwyn, yeoman 17
4040627 2039144 2039144 defendant Stevens alias Taylor Henry yeoman 586390 586390 Stevens alias Taylor, Henry, of Dylwyn, yeoman 2
4040632 2039145 2039145 defendant Stevens alias Taylor Henry yeoman 586390 586390 Stevens alias Taylor, Henry, of Dylwyn, yeoman 2
4052698 2043396 2043396 defendant Mounford Hugh yeoman 586390 586390 Mounford, Hugh, of Dylwyn, yeoman 4
4073366 2050764 2050764 defendant Crosse John yeoman 586390 586390 Crosse, John, of Dylwyn, yeoman 1
4073367 2050764 2050764 defendant Blether Thomas yeoman 586390 586390 Blether, Thomas, of Dylwyn, yeoman 2
4080951 2053500 2053500 defendant ap Jenkyn David yeoman 586390 586390 ap Jenkyn, David, of Dylwyn, yeoman 1
4148825 2077708 2077708 defendant Dewall alias Hewes Thomas husbandman 586390 586390 Dewall alias Hewes, Thomas, of Dylwyn, husbandman 0
4167931 2084270 2084270 defendant Davies Hugh yeoman 586390 586390 Davies, Hugh, of Dylwyn, yeoman 1
4185465 2090425 2090425 defendant Byforde Henry gent 586390 586390 Byforde, Henry, of Dylwyn, gent 1
4227655 2105157 2105157 defendant ap David Thomas yeoman 586390 586390 ap David, Thomas, of Dylwyn, yeoman 0
4227656 2105157 2105157 defendant Jenkyn Richard yeoman 586390 586390 Jenkyn, Richard, of Dylwyn, yeoman 1
4227657 2105157 2105157 defendant Meyryowe Richard yeoman 586390 586390 Meyryowe, Richard, of Dylwyn, yeoman 2
4237994 2108892 2108892 defendant Parker Walter yeoman 586390 586390 Parker, Walter, of Dylwyn, yeoman 0
4311797 2134263 2134263 defendant Bedford Walter yeoman 586390 586390 Bedford, Walter, of Dylwyn, yeoman 1
4317798 2136336 2136336 defendant Nurse Richard husbandman 586390 586390 Nurse, Richard, of Dylwyn, husbandman 1
4318569 2136607 2136607 defendant Bowyer John yeoman 586390 586390 Bowyer, John, of Dylwyn, yeoman 0
4359503 2150557 2150557 defendant Byford Henry gent 586390 586390 Byford, Henry, of Dylwyn, gent 0
4386137 2160046 2160046 defendant Rawlyns Hugh yeoman 586390 586390 Rawlyns, Hugh, of Dylwyn, yeoman 0
4387907 2160587 2160587 defendant Bedford Walter yeoman 586390 586390 Bedford, Walter, of Dylwyn, yeoman 2
4395666 2163137 2163137 defendant Blyther John husbandman 586390 586390 Blyther, John, of Dylwyn, husbandman 1
4404157 2165960 2165960 defendant Bedford Hugh yeoman 586390 586390 Bedford, Hugh, of Dylwyn, yeoman 1
4404158 2165960 2165960 defendant Bedford William yeoman 586390 586390 Bedford, William, of Dylwyn, yeoman 2
4913254 2330645 2330645 defendant Hamme John laborer 586390 586390 Hamme, John, of Dylwyn, laborer 3
4986520 2352896 2352896 defendant Plummer Joan widow 586390 586390 Plummer, Joan, of Dylwyn, widow 0
4986689 2352952 2352952 defendant Plummer Joan widow 586390 586390 Plummer, Joan, of Dylwyn, widow 0
5092577 2384205 2384205 defendant Penfynch John husbandman 586390 586390 Penfynch, John, of Dylwyn, husbandman 1
5284988 2440632 2440632 defendant ap Phylyppe Richard laborer 586390 586390 ap Phylyppe, Richard, of Dylwyn, laborer 0
5507907 2507371 2507371 defendant Strangford Richard husbandman 586390 586390 Strangford, Richard, of Dylwyn, husbandman 1
5608645 2537605 2537605 defendant ap Thomas Richard husbandman 586390 586390 ap Thomas, Richard, of Dylwyn, husbandman 0
5608650 2537606 2537606 defendant ap Thomas Richard husbandman 586390 586390 ap Thomas, Richard, of Dylwyn, husbandman 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);