names

42 rows where place_id = 664141

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3971604 2014629 2014629 defendant Greneweye John husbandman 664141 664141 Greneweye, John, of Kington, husbandman 0
4025944 2033928 2033928 plaintiff Bulcott Meredith yeoman 664141 664141 Bulcott, Meredith, of Kington, yeoman 0
4025945 2033928 2033928 defendant Harper Oliver yeoman 664141 664141 Harper, Oliver, of Kington, yeoman 0
4025947 2033929 2033929 plaintiff Bulcott Meredith yeoman 664141 664141 Bulcott, Meredith, of Kington, yeoman 0
4054232 2043899 2043899 defendant Baker John butcher 664141 664141 Baker, John, of Kington, butcher 0
4054234 2043900 2043900 defendant Baker John butcher 664141 664141 Baker, John, of Kington, butcher 0
4077179 2052123 2052123 plaintiff Snell or Suell Nicholas esq 664141 664141 Snell or Suell, Nicholas, of Kington, esq 0
4084780 2054832 2054832 defendant Goughe Edward yeoman 664141 664141 Goughe, Edward, of Kington, yeoman 0
4125400 2069369 2069369 defendant Maylard Thomas capper 664141 664141 Maylard, Thomas, of Kington, capper 0
4139737 2074573 2074573 defendant Burgwyn Jevan yeoman 664141 664141 Burgwyn, Jevan, of Kington, yeoman 3
4139738 2074573 2074573 defendant Powell Richard yeoman 664141 664141 Powell, Richard, of Kington, yeoman 4
4139739 2074573 2074573 defendant Lewys Thomas husbandman 664141 664141 Lewys, Thomas, of Kington, husbandman 5
4139743 2074573 2074573 defendant Meredith Richard yeoman 664141 664141 Meredith, Richard, of Kington, yeoman 9
4139744 2074573 2074573 defendant Scaundrett Richard yeoman 664141 664141 Scaundrett, Richard, of Kington, yeoman 10
4139745 2074573 2074573 defendant Heywood Richard yeoman 664141 664141 Heywood, Richard, of Kington, yeoman 11
4143776 2075983 2075983 defendant Beyos Walter cordwainer 664141 664141 Beyos, Walter, of Kington, cordwainer 0
4148024 2077441 2077441 defendant Bassett William yeoman 664141 664141 Bassett, William, of Kington, yeoman 2
4148634 2077647 2077647 defendant Maylard Thomas capper 664141 664141 Maylard, Thomas, of Kington, capper 0
4151704 2078709 2078709 defendant Basset Charles yeoman 664141 664141 Basset, Charles, of Kington, yeoman 1
4159422 2081363 2081363 defendant Goughe Edward drover 664141 664141 Goughe, Edward, of Kington, drover 0
4159423 2081363 2081363 defendant Maylerd Thomas capper 664141 664141 Maylerd, Thomas, of Kington, capper 1
4164533 2083109 2083109 defendant Meredithe Richard yeoman 664141 664141 Meredithe, Richard, of Kington, yeoman 1
4164534 2083109 2083109 defendant Staundrett or Scaundrett Richard yeoman 664141 664141 Staundrett or Scaundrett, Richard, of Kington, yeoman 2
4164535 2083109 2083109 defendant Hewood Richard yeoman 664141 664141 Hewood, Richard, of Kington, yeoman 3
4164536 2083109 2083109 defendant Heywood Richard yeoman 664141 664141 Heywood, Richard, of Kington, yeoman 4
4164539 2083109 2083109 defendant Tayler Thomas husbandman 664141 664141 Tayler, Thomas, of Kington, husbandman 7
4164540 2083109 2083109 defendant Powell John yeoman 664141 664141 Powell, John, of Kington, yeoman 8
4164541 2083109 2083109 defendant Burgwyn Jevan   664141 664141 Burgwyn, Jevan, of Kington 9
4164542 2083109 2083109 defendant Powell Richard yeoman 664141 664141 Powell, Richard, of Kington, yeoman 10
4164545 2083109 2083109 defendant Turner John yeoman 664141 664141 Turner, John, of Kington, yeoman 13
4170563 2085201 2085201 defendant ap Jevan Meredith butcher 664141 664141 ap Jevan, Meredith, of Kington, butcher 0
4170564 2085201 2085201 defendant ap Meredith Rice butcher 664141 664141 ap Meredith, Rice, of Kington, butcher 1
4293292 2127661 2127661 defendant Saveydge Thomas yeoman 664141 664141 Saveydge, Thomas, of Kington, yeoman 0
4327913 2139660 2139660 defendant Saire James (legal representative) 664141 664141 Saire, James, of Kington, yeoman, executors of 0
4381783 2158589 2158589 defendant Heywood Richard butcher 664141 664141 Heywood, Richard, of Kington, butcher 0
4381784 2158589 2158589 defendant Stones John butcher 664141 664141 Stones, John, of Kington, butcher 1
4381785 2158589 2158589 defendant Taylor Walter yeoman 664141 664141 Taylor, Walter, of Kington, yeoman 2
4390071 2161299 2161299 defendant Maylard Thomas husbandman 664141 664141 Maylard, Thomas, of Kington, husbandman 3
4399689 2164486 2164486 defendant Stringham Hugh yeoman 664141 664141 Stringham, Hugh, of Kington, yeoman 0
4399691 2164486 2164486 defendant Baker Walter yeoman 664141 664141 Baker, Walter, of Kington, yeoman 2
4399868 2164543 2164543 defendant Lilwalle John yeoman 664141 664141 Lilwalle, John, of Kington, or of Rushucke, yeoman 0
4399869 2164543 2164543 defendant Crofte Barnard yeoman 664141 664141 Crofte, Barnard, of Kington, 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);