names

60 rows where place_id = 607903

✎ 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
3671379 1917025 1917025 defendant Talant John husbandman 607903 607903 Talant, John, of Bishops Castle, husbandman 0
3678128 1919210 1919210 defendant Talant John, senior yeoman 607903 607903 Talant, John, senior, of Bishops Castle, yeoman 0
3678129 1919210 1919210 defendant Talant John, junior yeoman 607903 607903 Talant, John, junior, of Bishops Castle, yeoman 1
3678130 1919210 1919210 defendant Talant Thomas, senior yeoman 607903 607903 Talant, Thomas, senior, of Bishops Castle, yeoman 2
3678131 1919210 1919210 defendant Talant Thomas, junior yeoman 607903 607903 Talant, Thomas, junior, of Bishops Castle, yeoman 3
3678135 1919211 1919211 defendant Talant John, senior yeoman 607903 607903 Talant, John, senior, of Bishops Castle, yeoman 1
3678136 1919211 1919211 defendant Talant Thomas, junior yeoman 607903 607903 Talant, Thomas, junior, of Bishops Castle, yeoman 2
3857283 1975913 1975913 defendant ap Meryke Thomas gent 607903 607903 ap Meryke, Thomas, of Bishops Castle, gent 0
3857284 1975913 1975913 defendant ap Powell Richard gent 607903 607903 ap Powell, Richard, of Bishops Castle, gent 1
3857285 1975913 1975913 defendant ap Meredith Meryke gent 607903 607903 ap Meredith, Meryke, of Bishops Castle, gent 2
3937413 2002847 2002847 defendant Wyglblod Thomas   607903 607903 Wyglblod, Thomas, of Bishops Castle, fish monger 1
3949439 2006876 2006876 defendant Okelay Richard yeoman 607903 607903 Okelay, Richard, of Bishops Castle, yeoman 2
3969249 2013854 2013854 defendant ap Howell Mathew tailor 607903 607903 ap Howell, Mathew, of Bishops Castle, tailor 1
3969251 2013854 2013854 defendant Ap John William mercer 607903 607903 Ap John, William, of Bishops Castle, mercer 3
3988438 2020608 2020608 plaintiff ap Thomas John, junior mercer 607903 607903 ap Thomas, John, junior, of Bishops Castle, mercer 0
3988440 2020609 2020609 plaintiff ap Thomas John, junior mercer 607903 607903 ap Thomas, John, junior, of Bishops Castle, mercer 0
3994898 2022926 2022926 defendant Watters David yeoman 607903 607903 Watters, David, of Bishops Castle, yeoman 0
4023269 2033029 2033029 defendant ap John Lewis joiner 607903 607903 ap John, Lewis, of Bishops Castle, joiner 0
4041478 2039442 2039442 defendant Mason Hugh   607903 607903 Mason, Hugh, of Bishops Castle 1
4041479 2039442 2039442 defendant Marcer alias Jones William mercer 607903 607903 Marcer alias Jones, William, of Bishops Castle, mercer 2
4053542 2043642 2043642 defendant ap Owen Edward gent 607903 607903 ap Owen, Edward, of Bishops Castle, gent 0
4053543 2043642 2043642 defendant Russell John mercer 607903 607903 Russell, John, of Bishops Castle, mercer 1
4053594 2043659 2043659 defendant Lloid Mathew gent 607903 607903 Lloid, Mathew, of Bishops Castle, gent 1
4068838 2049145 2049145 defendant Waters David yeoman 607903 607903 Waters, David, of Bishops Castle, yeoman 0
4116581 2066219 2066219 defendant Gawen William yeoman 607903 607903 Gawen, William, of Bishops Castle, yeoman 0
4143021 2075727 2075727 defendant Ockeley Hugh (legal representative) 607903 607903 Ockeley, Hugh, of Bishops Castle, gent, executrix of 0
4143022 2075727 2075727 defendant Ockeley Katherine widow 607903 607903 Ockeley, Katherine, of Bishops Castle, widow 1
4157631 2080742 2080742 defendant Mason Humphrey yeoman 607903 607903 Mason, Humphrey, of Bishops Castle, yeoman 0
4157632 2080742 2080742 defendant Gawen William yeoman 607903 607903 Gawen, William, of Bishops Castle, yeoman 1
4157633 2080742 2080742 defendant Ockley John yeoman 607903 607903 Ockley, John, of Bishops Castle, yeoman 2
4157634 2080742 2080742 defendant Ockley Francis yeoman 607903 607903 Ockley, Francis, of Bishops Castle, yeoman 3
4190948 2092396 2092396 defendant Bleshe John yeoman 607903 607903 Bleshe, John, of Bishops Castle, yeoman 2
4231763 2106606 2106606 defendant ap Owen David gent 607903 607903 ap Owen, David, of Bishops Castle, gent 1
4270710 2119781 2119781 defendant ap Owen David gent 607903 607903 ap Owen, David, of Bishops Castle, gent 1
4295016 2128300 2128300 defendant Ockley John (legal representative) 607903 607903 Ockley, John, of Bishops Castle, gent, administrator of 0
4305017 2131896 2131896 defendant Lloyd Robert gent 607903 607903 Lloyd, Robert, of Bishops Castle, gent 0
4305019 2131897 2131897 defendant Lloyd Robert gent 607903 607903 Lloyd, Robert, of Bishops Castle, gent 0
4305021 2131898 2131898 defendant Lloyd Robert gent 607903 607903 Lloyd, Robert, of Bishops Castle, gent 0
4305023 2131899 2131899 defendant Mason Edward gent 607903 607903 Mason, Edward, of Bishops Castle, gent 0
4305025 2131900 2131900 defendant Mason Edward gent 607903 607903 Mason, Edward, of Bishops Castle, gent 0
4315393 2135495 2135495 defendant Midleton Robert gent 607903 607903 Midleton, Robert, of Bishops Castle, gent 0
4315399 2135496 2135496 defendant Midleton Roland gent 607903 607903 Midleton, Roland, of Bishops Castle, gent 2
4328592 2139879 2139879 defendant Myddleton Roland gent 607903 607903 Myddleton, Roland, of Bishops Castle, gent 2
4328597 2139880 2139880 defendant ap Robert of Maurice yeoman 607903 607903 ap Robert, of Maurice, of Bishops Castle, yeoman 2
4328599 2139881 2139881 defendant Middleton Robert gent 607903 607903 Middleton, Robert, of Bishops Castle, gent 0
4338153 2143085 2143085 defendant Owen Edmund (legal representative) 607903 607903 Owen, Edmund, of Bishops Castle, mercer, executors of 0
4655525 2247623 2247623 defendant ap Gruffyth John   607903 607903 ap Gruffyth, John, of Bishops Castle 0
4849261 2311245 2311245 defendant Benthall John yeoman 607903 607903 Benthall, John, of Bishops Castle, yeoman 0
5019292 2362530 2362530 defendant Taillour William tailor 607903 607903 Taillour, William, of Bishops Castle, tailor 0
5037878 2367958 2367958 defendant Okeley Robert yeoman 607903 607903 Okeley, Robert, of Bishops Castle, yeoman 0
5037879 2367958 2367958 defendant Taland John husbandman 607903 607903 Taland, John, of Bishops Castle, husbandman 1
5037880 2367958 2367958 defendant ap John David husbandman 607903 607903 ap John, David, of Bishops Castle, husbandman 2
5053741 2372719 2372719 defendant Smyth John husbandman 607903 607903 Smyth, John, of Bishops Castle, husbandman 2
5053742 2372719 2372719 defendant Smyth Lewis husbandman 607903 607903 Smyth, Lewis, of Bishops Castle, husbandman 3
5053743 2372719 2372719 defendant Tayllour William husbandman 607903 607903 Tayllour, William, of Bishops Castle, husbandman 4
5244639 2428613 2428613 defendant Rede Richard husbandman 607903 607903 Rede, Richard, of Bishops Castle, husbandman 9
5548217 2519507 2519507 defendant Brigge John gent 607903 607903 Brigge, John, of Bishops Castle, gent 0
5548220 2519507 2519507 defendant Gryffyth Reginald ap Sur gent 607903 607903 Gryffyth, Reginald ap Sur, of Bishops Castle, gent 3
5561570 2523370 2523370 plaintiff Valgh David ap Richard yeoman 607903 607903 Valgh, David ap Richard, of Bishops Castle, yeoman 0
5561571 2523370 2523370 plaintiff Valgh Reginald yeoman 607903 607903 Valgh, Reginald, of Bishops Castle, 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);