names

78 rows where place_id = 630114

✎ 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
3792507 1955513 1955513 defendant Burton Elizabeth spinster 630114 630114 Burton, Elizabeth, of Doore, spinster 8
3792508 1955513 1955513 defendant Burton Margaret spinster 630114 630114 Burton, Margaret, of Doore, spinster 9
3792509 1955513 1955513 defendant Cot Cecilia widow 630114 630114 Cot, Cecilia, of Doore, widow 10
3792510 1955513 1955513 defendant Cot Joan spinster 630114 630114 Cot, Joan, of Doore, spinster 11
3792511 1955513 1955513 defendant Adamson Joan spinster 630114 630114 Adamson, Joan, of Doore, spinster 12
3792512 1955513 1955513 defendant Adamson John husbandman 630114 630114 Adamson, John, of Doore, husbandman 13
3913919 1995002 1995002 defendant ap Henry Richard husbandman 630114 630114 ap Henry, Richard, of Doore, husbandman 1
3913920 1995002 1995002 defendant ap Henry John husbandman 630114 630114 ap Henry, John, of Doore, husbandman 2
3943503 2004844 2004844 defendant Sycill John gent 630114 630114 Sycill, John, of Doore, gent 2
3943507 2004845 2004845 defendant Sycill John gent 630114 630114 Sycill, John, of Doore, gent 2
3966915 2013061 2013061 defendant Bythell John yeoman 630114 630114 Bythell, John, of Doore, yeoman 2
3972523 2014966 2014966 defendant Lewys John husbandman 630114 630114 Lewys, John, of Doore, husbandman 0
3977909 2016847 2016847 defendant Berrowe William yeoman 630114 630114 Berrowe, William, of Doore, yeoman 1
3977910 2016847 2016847 defendant Johns William husbandman 630114 630114 Johns, William, of Doore, husbandman 2
3977911 2016847 2016847 defendant ap John John William laborer 630114 630114 ap John, John William, of Doore, laborer 3
3977912 2016847 2016847 defendant Morgan David cordwainer 630114 630114 Morgan, David, of Doore, cordwainer 4
3977913 2016847 2016847 defendant Lewys John, senior laborer 630114 630114 Lewys, John, senior, of Doore, laborer 5
3977915 2016847 2016847 defendant Lewys John, junior laborer 630114 630114 Lewys, John, junior, of Doore, laborer 7
3977916 2016847 2016847 defendant William Lewis laborer 630114 630114 William, Lewis, of Doore, laborer 8
3980570 2017815 2017815 defendant Connok John husbandman 630114 630114 Connok, John, of Doore, husbandman 2
4014477 2029903 2029903 defendant Tew Thomas Philip yeoman 630114 630114 Tew, Thomas Philip, of Doore, yeoman 0
4032383 2036245 2036245 defendant Thomas David sawyer 630114 630114 Thomas, David, of Doore, sawyer 12
4032402 2036248 2036248 defendant Thomas David sawyer 630114 630114 Thomas, David, of Doore, sawyer 8
4053614 2043667 2043667 defendant Taylor John Harry tailor 630114 630114 Taylor, John Harry, of Doore, tailor 0
4063200 2047135 2047135 defendant Lloyd Joan widow 630114 630114 Lloyd, Joan, of Doore, widow 3
4063201 2047135 2047135 defendant Lloyd Thomas laborer 630114 630114 Lloyd, Thomas, of Doore, laborer 4
4063204 2047135 2047135 defendant Harpe or Harper Jevan laborer 630114 630114 Harpe or Harper, Jevan, of Doore, laborer 7
4063213 2047136 2047136 defendant Madock Philip yeoman 630114 630114 Madock, Philip, of Doore, yeoman 7
4079320 2052904 2052904 defendant Bythell John yeoman 630114 630114 Bythell, John, of Doore, yeoman 2
4081451 2053677 2053677 defendant Berrowe John gent 630114 630114 Berrowe, John, of Doore, gent 0
4082916 2054189 2054189 defendant Lawrence John yeoman 630114 630114 Lawrence, John, of Doore, yeoman 1
4091490 2057248 2057248 defendant Phillipp Richard Philip yeoman 630114 630114 Phillipp, Richard Philip, of Doore, yeoman 0
4102512 2061196 2061196 defendant Connocke John husbandman 630114 630114 Connocke, John, of Doore, husbandman 0
4102513 2061196 2061196 defendant Tucker Jenkin tucker 630114 630114 Tucker, Jenkin, of Doore, tucker 1
4117410 2066524 2066524 defendant Meredithe John yeoman 630114 630114 Meredithe, John, of Doore, yeoman 0
4134501 2072670 2072670 defendant Gytto Thomas husbandman 630114 630114 Gytto, Thomas, of Doore, husbandman 0
4154376 2079621 2079621 defendant Connocke John husbandman 630114 630114 Connocke, John, of Doore, husbandman 0
4158493 2081042 2081042 defendant Gitto Thomas husbadman 630114 630114 Gitto, Thomas, of Doore, husbadman 0
4176661 2087305 2087305 defendant Bythell John, senior yeoman 630114 630114 Bythell, John, senior, of Doore, yeoman 3
4182784 2089458 2089458 defendant Meyrycke Thomas husbandman 630114 630114 Meyrycke, Thomas, of Doore, husbandman 0
4182785 2089458 2089458 defendant Gytton John Thomas yeoman 630114 630114 Gytton, John Thomas, of Doore, yeoman 1
4182786 2089458 2089458 defendant ap Jevan Rice yeoman 630114 630114 ap Jevan, Rice, of Doore, yeoman 2
4182787 2089458 2089458 defendant ap John Richard laborer 630114 630114 ap John, Richard, of Doore, laborer 3
4185515 2090442 2090442 defendant Meyrycke John yeoman 630114 630114 Meyrycke, John, of Doore, yeoman 3
4189440 2091802 2091802 defendant Conog or Kennocke John   630114 630114 Conog or Kennocke, John, of Doore yeoman 0
4189800 2091927 2091927 defendant Berowe John gent 630114 630114 Berowe, John, of Doore, gent 0
4189802 2091928 2091928 defendant Berowe John gent 630114 630114 Berowe, John, of Doore, gent 0
4214369 2100532 2100532 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 1
4218222 2101876 2101876 defendant Spencer Edward yeoman 630114 630114 Spencer, Edward, of Doore, yeoman 3
4218755 2102060 2102060 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 1
4222185 2103250 2103250 defendant Popkyn William, junior yeoman 630114 630114 Popkyn, William, junior, of Doore, yeoman 0
4223110 2103572 2103572 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 0
4223936 2103858 2103858 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 1
4227463 2105086 2105086 defendant Spencer Edward yeoman 630114 630114 Spencer, Edward, of Doore, yeoman 3
4227875 2105232 2105232 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 1
4235984 2108160 2108160 defendant Bythell John yeoman 630114 630114 Bythell, John, of Doore, yeoman 0
4239357 2109383 2109383 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 0
4239363 2109385 2109385 defendant Popkyn William, junior yeoman 630114 630114 Popkyn, William, junior, of Doore, yeoman 0
4240634 2109849 2109849 defendant Meiricke Walter yeoman 630114 630114 Meiricke, Walter, of Doore, yeoman 0
4246420 2111780 2111780 defendant Harrys Thomas butcher 630114 630114 Harrys, Thomas, of Doore, butcher 0
4261568 2116834 2116834 defendant Popkyn William, junior yeoman 630114 630114 Popkyn, William, junior, of Doore, yeoman 0
4280799 2123188 2123188 defendant Hill Richard gent 630114 630114 Hill, Richard, of Doore, gent 0
4292528 2127390 2127390 defendant Popkyn William, junior husbandman 630114 630114 Popkyn, William, junior, of Doore, husbandman 1
4293123 2127606 2127606 defendant Spencer Edward yeoman 630114 630114 Spencer, Edward, of Doore, yeoman 1
4293124 2127606 2127606 defendant Popkyn William yeoman 630114 630114 Popkyn, William, of Doore, yeoman 2
4297454 2129193 2129193 defendant Bythell John husbandman 630114 630114 Bythell, John, of Doore, husbandman 0
4301282 2130567 2130567 defendant Popkyn William, junior husbandman 630114 630114 Popkyn, William, junior, of Doore, husbandman 1
4305927 2132211 2132211 defendant Carpenter John husbandman 630114 630114 Carpenter, John, of Doore, husbandman 2
4330378 2140461 2140461 defendant Bythell John husbandman 630114 630114 Bythell, John, of Doore, husbandman 0
4375260 2156206 2156206 defendant Prichard Thomas gent 630114 630114 Prichard, Thomas, of Doore, or of Granche, Herefs, gent 0
4380071 2157976 2157976 defendant Butcher alias Harry Thomas yeoman 630114 630114 Butcher alias Harry, Thomas, of Doore, yeoman 0
4387339 2160413 2160413 defendant Madock Morgan yeoman 630114 630114 Madock, Morgan, of Doore, yeoman 1
4400642 2164805 2164805 defendant Prichard John yeoman 630114 630114 Prichard, John, of Doore, yeoman 0
4400643 2164805 2164805 defendant Larance John husbandman 630114 630114 Larance, John, of Doore, husbandman 1
4402730 2165498 2165498 defendant Thomas Howell tanner 630114 630114 Thomas, Howell, of Doore, tanner 0
4402731 2165498 2165498 defendant Duppa Thomas tanner 630114 630114 Duppa, Thomas, of Doore, tanner 1
4402733 2165499 2165499 defendant Jenynges Thomas tanner 630114 630114 Jenynges, Thomas, of Doore, tanner 0
5053747 2372720 2372720 defendant Stephens Richard husbandman 630114 630114 Stephens, Richard, of Doore, husbandman 2

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