names

52 rows where place_id = 592518

✎ 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
3607942 1870132 1870132 defendant ap David Philip yeoman 592518 592518 ap David, Philip, of Carlyon, yeoman 2
3884736 1985169 1985169 plaintiff ap Rychard William   592518 592518 ap Rychard, William, of Carlyon 0
3891031 1987265 1987265 defendant Sayer Watkyn John weaver 592518 592518 Sayer, Watkyn John, of Carlyon, weaver 0
3898449 1989694 1989694 plaintiff ap Rychard William   592518 592518 ap Rychard, William, of Carlyon 0
3906774 1992557 1992557 defendant Sayr Walter John yeoman 592518 592518 Sayr, Walter John, of Carlyon, yeoman 1
3910016 1993657 1993657 defendant Jonys William gent 592518 592518 Jonys, William, of Carlyon, gent 0
3954706 2008710 2008710 defendant Saunders Richard shoemaker 592518 592518 Saunders, Richard, of Carlyon, shoemaker 0
3963301 2011767 2011767 defendant Warkyn Howel yeoman 592518 592518 Warkyn, Howel, of Carlyon, yeoman 0
3963302 2011767 2011767 defendant Hoell Morgan yeoman 592518 592518 Hoell, Morgan, of Carlyon, yeoman 1
3963303 2011767 2011767 defendant Lewys Hugh yeoman 592518 592518 Lewys, Hugh, of Carlyon, yeoman 2
3963304 2011767 2011767 defendant ap John John ap Jenin yeoman 592518 592518 ap John, John ap Jenin, of Carlyon, yeoman 3
3963305 2011767 2011767 defendant vergh Thomas Margaret widow 592518 592518 vergh Thomas, Margaret, of Carlyon, widow 4
3974588 2015677 2015677 defendant Robert Philip yeoman 592518 592518 Robert, Philip, of Carlyon, yeoman 3
3974589 2015677 2015677 defendant Bale Thomas yeoman 592518 592518 Bale, Thomas, of Carlyon, yeoman 4
3975946 2016150 2016150 defendant Jones William   592518 592518 Jones, William, of Carlyon, yeoman, bailiff of Kaerlyon and parish of Christchurch, Monmouth 0
3975947 2016151 2016151 plaintiff James Thomas   592518 592518 James, Thomas, of Carlyon 0
4036257 2037650 2037650 defendant Lloyd Roger Thomas tucker 592518 592518 Lloyd, Roger Thomas, of Carlyon, tucker 2
4036258 2037650 2037650 defendant Lloyd Roger Lewis butcher 592518 592518 Lloyd, Roger Lewis, of Carlyon, butcher 3
4053518 2043632 2043632 defendant Damson Peter yeoman 592518 592518 Damson, Peter, of Carlyon, yeoman 1
4097124 2059294 2059294 defendant Prychard Lewis gent 592518 592518 Prychard, Lewis, of Carlyon, gent 1
4104568 2061913 2061913 defendant Smyth Lewis gent 592518 592518 Smyth, Lewis, of Carlyon, gent 0
4104569 2061913 2061913 defendant Wylliams Walter yeoman 592518 592518 Wylliams, Walter, of Carlyon, yeoman 1
4135009 2072843 2072843 defendant Hughes John gent 592518 592518 Hughes, John, of Carlyon, gent 0
4141073 2075037 2075037 defendant Howell Robert cordwainer 592518 592518 Howell, Robert, of Carlyon, cordwainer 1
4141111 2075050 2075050 defendant ap Powell Robert shoemaker 592518 592518 ap Powell, Robert, of Carlyon, shoemaker 2
4152142 2078859 2078859 defendant ap Rychard Prichard Lewis gent 592518 592518 ap Rychard Prichard, Lewis, of Carlyon, gent 3
4153918 2079466 2079466 defendant Jones Robert gent 592518 592518 Jones, Robert, of Carlyon, gent 0
4157071 2080553 2080553 defendant Watkyn John yeoman 592518 592518 Watkyn, John, of Carlyon, yeoman 0
4157072 2080553 2080553 defendant James Thomas gent 592518 592518 James, Thomas, of Carlyon, gent 1
4157074 2080554 2080554 defendant Langeley Lewis gent 592518 592518 Langeley, Lewis, of Carlyon, gent 0
4157075 2080554 2080554 defendant Morgan Alexander gent 592518 592518 Morgan, Alexander, of Carlyon, gent 1
4157076 2080554 2080554 defendant James John yeoman 592518 592518 James, John, of Carlyon, yeoman 2
4163637 2082802 2082802 defendant Gryffyth William yeoman 592518 592518 Gryffyth, William, of Carlyon, yeoman 0
4163640 2082803 2082803 defendant James Thomas tanner 592518 592518 James, Thomas, of Carlyon, tanner 0
4163641 2082803 2082803 defendant James William Thomas yeoman 592518 592518 James, William Thomas, of Carlyon, yeoman 1
4167514 2084133 2084133 defendant ap Howell Robert shomeaker 592518 592518 ap Howell, Robert, of Carlyon, shomeaker 0
4167515 2084133 2084133 defendant Howell John yeoman 592518 592518 Howell, John, of Carlyon, yeoman 1
4167516 2084133 2084133 defendant Langley Rice gent 592518 592518 Langley, Rice, of Carlyon, gent 2
4167517 2084133 2084133 defendant William John David yeoman 592518 592518 William, John David, of Carlyon, yeoman 3
4167522 2084134 2084134 defendant Apowell Robert   592518 592518 Apowell, Robert, of Carlyon 3
4167523 2084134 2084134 defendant Langley Rice gent 592518 592518 Langley, Rice, of Carlyon, gent 4
4181134 2088877 2088877 defendant James Thomas gent 592518 592518 James, Thomas, of Carlyon, gent 0
4181136 2088878 2088878 defendant Watkyn John yeoman 592518 592518 Watkyn, John, of Carlyon, yeoman 0
4202229 2096321 2096321 defendant Powell Thomas carpenter 592518 592518 Powell, Thomas, of Carlyon, yeoman, carpenter 0
4202233 2096321 2096321 defendant Thomas Roger yeoman 592518 592518 Thomas, Roger, of Carlyon, yeoman 4
4204675 2097182 2097182 defendant Griffith Jevan mariner 592518 592518 Griffith, Jevan, of Carlyon, yeoman, mariner 0
4204676 2097182 2097182 defendant Jones William mariner 592518 592518 Jones, William, of Carlyon, yeoman, mariner 1
4209725 2098954 2098954 defendant Gunter Edward gent 592518 592518 Gunter, Edward, of Carlyon, gent 0
4209726 2098954 2098954 defendant Tannor John Morgan yeoman 592518 592518 Tannor, John Morgan, of Carlyon, yeoman 1
4210551 2099244 2099244 defendant Watkyn William cordwainer 592518 592518 Watkyn, William, of Carlyon, cordwainer 3
4210800 2099335 2099335 defendant Thomas Howell yeoman 592518 592518 Thomas, Howell, of Carlyon, yeoman 1
4220735 2102753 2102753 defendant James William Thomas yeoman 592518 592518 James, William Thomas, of Carlyon, yeoman 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);