names

52 rows where place_id = 589506

✎ 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
3597816 1866934 1866934 defendant Botcete Thomas laborer 589506 589506 Botcete, Thomas, of Mockas, laborer 1
3597818 1866935 1866935 defendant Garold Thomas clerk 589506 589506 Garold, Thomas, of Mockas, clerk 0
3690224 1923101 1923101 defendant Rede William husbandman 589506 589506 Rede, William, of Mockas, husbandman 2
3720323 1932636 1932636 defendant Chambour Thomas husbandman 589506 589506 Chambour, Thomas, of Mockas, husbandman 3
3768753 1947877 1947877 defendant Goughe John ap Res, junior husbandman 589506 589506 Goughe, John ap Res, junior, of Mockas, husbandman 0
3768754 1947877 1947877 defendant Mathewe William husbandman 589506 589506 Mathewe, William, of Mockas, husbandman 1
3830983 1967574 1967574 defendant Gebons Richard husbandman 589506 589506 Gebons, Richard, of Mockas, husbandman 0
3857264 1975907 1975907 defendant Howell Thomas laborer 589506 589506 Howell, Thomas, of Mockas, laborer 0
3857265 1975907 1975907 defendant Tayler David tailor 589506 589506 Tayler, David, of Mockas, tailor 1
3857266 1975907 1975907 defendant Rede Davis laborer 589506 589506 Rede, Davis, of Mockas, laborer 2
3912607 1994549 1994549 defendant Lurkot Thomas husbandman 589506 589506 Lurkot, Thomas, of Mockas, husbandman 0
3912608 1994549 1994549 defendant ap Howell Thomas miller 589506 589506 ap Howell, Thomas, of Mockas, miller 1
3912609 1994549 1994549 defendant Preffyows Richard laborer 589506 589506 Preffyows, Richard, of Mockas, laborer 2
3912610 1994549 1994549 defendant Goughe John ap Re husbandman 589506 589506 Goughe, John ap Re, of Mockas, husbandman 3
3914578 1995221 1995221 defendant Taylour John husbandman 589506 589506 Taylour, John, of Mockas, husbandman 0
4053602 2043661 2043661 defendant Gybbons John husbandman 589506 589506 Gybbons, John, of Mockas, husbandman 0
4054197 2043887 2043887 defendant Watkyns William husbandman 589506 589506 Watkyns, William, of Mockas, husbandman 2
4109609 2063695 2063695 defendant Botcott William yeoman 589506 589506 Botcott, William, of Mockas, yeoman 2
4114633 2065522 2065522 defendant Gybbon John yeoman 589506 589506 Gybbon, John, of Mockas, yeoman 0
4145676 2076641 2076641 defendant Rogers William husbandman 589506 589506 Rogers, William, of Mockas, husbandman 0
4145688 2076645 2076645 defendant Watkyns William, junior yeoman 589506 589506 Watkyns, William, junior, of Mockas, or of Gwenddwr, Brecon, yeoman 0
4145689 2076645 2076645 defendant Watkyns William, senior yeoman 589506 589506 Watkyns, William, senior, of Mockas, or of Gwenddwr, yeoman 1
4145690 2076645 2076645 defendant Gybbons Richard yeoman 589506 589506 Gybbons, Richard, of Mockas, yeoman 2
4152064 2078832 2078832 defendant Gybon Richard yeoman 589506 589506 Gybon, Richard, of Mockas, yeoman 0
4152065 2078832 2078832 defendant Batcott William butcher 589506 589506 Batcott, William, of Mockas, butcher 1
4152819 2079094 2079094 defendant Gybbons Richard yeoman 589506 589506 Gybbons, Richard, of Mockas, yeoman 0
4152820 2079094 2079094 defendant Lorcott Richard yeoman 589506 589506 Lorcott, Richard, of Mockas, yeoman 1
4160626 2081791 2081791 defendant Colcombe William yeoman 589506 589506 Colcombe, William, of Mockas, yeoman 0
4160627 2081791 2081791 defendant Lyrott Richard yeoman 589506 589506 Lyrott, Richard, of Mockas, yeoman 1
4160628 2081791 2081791 defendant Hergeste Roger yeoman 589506 589506 Hergeste, Roger, of Mockas, yeoman 2
4160629 2081791 2081791 defendant Gibon Richard yeoman 589506 589506 Gibon, Richard, of Mockas, yeoman 3
4160631 2081792 2081792 defendant Colcombe William husbandman 589506 589506 Colcombe, William, of Mockas, husbandman 0
4160632 2081792 2081792 defendant Woowarde alias Gentle James tailor 589506 589506 Woowarde alias Gentle, James, of Mockas, tailor 1
4161087 2081953 2081953 defendant Gybbons Richard husbandman 589506 589506 Gybbons, Richard, of Mockas, husbandman 1
4161090 2081954 2081954 defendant Gybbons Richard husbandman 589506 589506 Gybbons, Richard, of Mockas, husbandman 1
4164547 2083110 2083110 defendant Prosser William singleman 589506 589506 Prosser, William, of Mockas, husbandman, singleman 0
4176620 2087297 2087297 defendant Rede Richard husbandman 589506 589506 Rede, Richard, of Mockas, husbandman 1
4180088 2088514 2088514 defendant Woodward alias Gentell James tailor 589506 589506 Woodward alias Gentell, James, of Mockas, tailor 0
4214717 2100653 2100653 defendant Lurcott William yeoman 589506 589506 Lurcott, William, of Mockas, yeoman 0
4214718 2100653 2100653 defendant Gybbons John yeoman 589506 589506 Gybbons, John, of Mockas, yeoman 1
4224235 2103965 2103965 defendant Lurcott William yeoman 589506 589506 Lurcott, William, of Mockas, yeoman 0
4224236 2103965 2103965 defendant Gibbons John yeoman 589506 589506 Gibbons, John, of Mockas, yeoman 1
4300234 2130182 2130182 defendant Geebons Alice widow 589506 589506 Geebons, Alice, of Mockas, widow 0
4300534 2130284 2130284 defendant Gybbons John yeoman 589506 589506 Gybbons, John, of Mockas, yeoman 0
4300535 2130284 2130284 defendant Gybbons Thomas   589506 589506 Gybbons, Thomas, of Mockas, yeoman, son of John 1
4308771 2133218 2133218 defendant Gibbons John yeoman 589506 589506 Gibbons, John, of Mockas, yeoman 0
4308772 2133218 2133218 defendant Gibbons Thomas   589506 589506 Gibbons, Thomas, of Mockas, yeoman, his son 1
4387732 2160532 2160532 defendant Rogers Lewis clerk 589506 589506 Rogers, Lewis, of Mockas, clerk 1
4399857 2164540 2164540 defendant Gybbon John yeoman 589506 589506 Gybbon, John, of Mockas, yeoman 0
4399858 2164540 2164540 defendant Gybbon Thomas yeoman 589506 589506 Gybbon, Thomas, of Mockas, yeoman 1
4399860 2164541 2164541 defendant Gybbon John yeoman 589506 589506 Gybbon, John, of Mockas, yeoman 0
4399861 2164541 2164541 defendant Gybbon Thomas yeoman 589506 589506 Gybbon, Thomas, of Mockas, yeoman 1

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