names

46 rows where place_id = 621057

✎ 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
3739264 1938500 1938500 defendant Gough David ap Rees yeoman 621057 621057 Gough, David ap Rees, of Brylley, yeoman 5
3739276 1938501 1938501 defendant Cough David ap Rees yeoman 621057 621057 Cough, David ap Rees, of Brylley, yeoman 5
3890029 1986901 1986901 defendant Jenkyn Thomas gent 621057 621057 Jenkyn, Thomas, of Brylley, gent 1
3890030 1986901 1986901 defendant Rychard James husbandman 621057 621057 Rychard, James, of Brylley, husbandman 2
3899145 1989921 1989921 defendant Willyam Thomas ap Hoell husbandman 621057 621057 Willyam, Thomas ap Hoell, of Brylley, husbandman 0
3929607 2000251 2000251 defendant Maholand John husbandman 621057 621057 Maholand, John, of Brylley, husbandman 2
3929608 2000251 2000251 defendant ap Thomas Jevaun husbandman 621057 621057 ap Thomas, Jevaun, of Brylley, husbandman 3
3950596 2007279 2007279 defendant Bromyche Thomas gent 621057 621057 Bromyche, Thomas, of Brylley, gent 0
3957158 2009568 2009568 defendant Smythe Richard smith 621057 621057 Smythe, Richard, of Brylley, smith 0
3957159 2009568 2009568 defendant Turnor Thomas ap John smith 621057 621057 Turnor, Thomas ap John, of Brylley, smith 1
4005020 2026579 2026579 defendant Hunt Hugh gent 621057 621057 Hunt, Hugh, of Brylley, gent 1
4034386 2036970 2036970 defendant Jones alias Stevens Anne widow 621057 621057 Jones alias Stevens, Anne, of Brylley, widow 1
4043152 2040018 2040018 defendant Powell Thomas yeoman 621057 621057 Powell, Thomas, of Brylley, yeoman 1
4043153 2040018 2040018 defendant Phelpott Lewis Powell yeoman 621057 621057 Phelpott, Lewis Powell, of Brylley, yeoman 2
4054133 2043865 2043865 defendant ap Lewys John yeoman 621057 621057 ap Lewys, John, of Brylley, yeoman 1
4065073 2047795 2047795 defendant ap Owen David, junior yeoman 621057 621057 ap Owen, David, junior, of Brylley, yeoman 0
4065074 2047795 2047795 defendant Wynston John gent 621057 621057 Wynston, John, of Brylley, gent 1
4070727 2049827 2049827 defendant Hunte Hugh gent 621057 621057 Hunte, Hugh, of Brylley, gent 1
4071054 2049948 2049948 defendant Pryce Thomas yeoman 621057 621057 Pryce, Thomas, of Brylley, yeoman 0
4072681 2050528 2050528 defendant Stephens alias James Anne widow 621057 621057 Stephens alias James, Anne, of Brylley, widow 1
4072689 2050529 2050529 defendant Hunt Hugh gent 621057 621057 Hunt, Hugh, of Brylley, gent 1
4075292 2051468 2051468 defendant Hunt James gent 621057 621057 Hunt, James, of Brylley, gent 2
4084788 2054835 2054835 defendant Dansey Simon gent 621057 621057 Dansey, Simon, of Brylley, gent 0
4084792 2054836 2054836 defendant Gwyn John ap Jevan husbandman 621057 621057 Gwyn, John ap Jevan, of Brylley, husbandman 2
4088015 2056009 2056009 defendant Gwynne John David yeoman 621057 621057 Gwynne, John David, of Brylley, yeoman 1
4088016 2056009 2056009 defendant Maholam John yeoman 621057 621057 Maholam, John, of Brylley, yeoman 2
4091374 2057204 2057204 defendant Bromwyche James gent 621057 621057 Bromwyche, James, of Brylley, gent 0
4095143 2058591 2058591 defendant Water John ap William yeoman 621057 621057 Water, John ap William, of Brylley, yeoman 1
4118558 2066931 2066931 defendant Farnoll John William yeoman 621057 621057 Farnoll, John William, of Brylley, yeoman 1
4118559 2066931 2066931 defendant Maholome John yeoman 621057 621057 Maholome, John, of Brylley, yeoman 2
4142623 2075588 2075588 defendant ap Jevan Rice yeoman 621057 621057 ap Jevan, Rice, of Brylley, yeoman 0
4143660 2075938 2075938 defendant Harper Philip husbandman 621057 621057 Harper, Philip, of Brylley, husbandman 3
4164526 2083108 2083108 defendant Gqynne John ap Jevan husbandman 621057 621057 Gqynne, John ap Jevan, of Brylley, husbandman 5
4164528 2083108 2083108 defendant Phelippe Thomas laborer 621057 621057 Phelippe, Thomas, of Brylley, laborer 7
4164529 2083108 2083108 defendant ap William William laborer 621057 621057 ap William, William, of Brylley, laborer 8
4167459 2084116 2084116 defendant Wynston John gent 621057 621057 Wynston, John, of Brylley, gent 0
4168525 2084477 2084477 defendant Lewys John gent 621057 621057 Lewys, John, of Brylley, gent 0
4176624 2087298 2087298 defendant Approsser Thomas husbandman 621057 621057 Approsser, Thomas, of Brylley, husbandman 0
4176625 2087298 2087298 defendant Approsser James yeoman 621057 621057 Approsser, James, of Brylley, yeoman 1
4248426 2112461 2112461 defendant William John yeoman 621057 621057 William, John, of Brylley, yeoman 0
4248427 2112461 2112461 defendant vergh John Sybil spinster 621057 621057 vergh John, Sybil, of Brylley, spinster 1
4309602 2133518 2133518 defendant Harper Philip yeoman 621057 621057 Harper, Philip, of Brylley, yeoman 0
4316890 2136023 2136023 defendant Harper Philip yeoman 621057 621057 Harper, Philip, of Brylley, yeoman 0
4395164 2162971 2162971 defendant Price John husbandman 621057 621057 Price, John, of Brylley, husbandman 0
4395165 2162971 2162971 defendant Nokes Thomas husbandman 621057 621057 Nokes, Thomas, of Brylley, husbandman 1
4399335 2164366 2164366 defendant Williams Walter laborer 621057 621057 Williams, Walter, of Brylley, laborer 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);