names

41 rows where place_id = 591588

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604912 1869202 1869202 defendant Hoke Guy yeoman 591588 591588 Hoke, Guy, of Newent, Glos, yeoman 0
3606243 1869619 1869619 defendant Flewelyn Thomas husbandman 591588 591588 Flewelyn, Thomas, of Newent, Glos, husbandman 0
3606247 1869620 1869620 defendant Flewelyn Thomas husbandman 591588 591588 Flewelyn, Thomas, of Newent, Glos, husbandman 0
3702830 1927157 1927157 defendant Porter Roger (legal representative) 591588 591588 Porter, Roger, of Newent, Glos, gent, executor of 0
3801523 1958387 1958387 defendant Porter Roger   591588 591588 Porter, Roger, of Newent, Glos 0
3859471 1976656 1976656 defendant Dobyns Guy yeoman 591588 591588 Dobyns, Guy, of Newent, Glos, yeoman 0
3883343 1984694 1984694 defendant Dobbyns Ellen widow 591588 591588 Dobbyns, Ellen, of Newent, Glos, widow 5
3896892 1989172 1989172 defendant Dobbyns Guy yeoman 591588 591588 Dobbyns, Guy, of Newent, Glos, yeoman 0
3898890 1989833 1989833 defendant Lucas John husbandman 591588 591588 Lucas, John, of Newent, Glos, husbandman 3
3898896 1989834 1989834 defendant Lucas John husbandman 591588 591588 Lucas, John, of Newent, Glos, husbandman 4
4011008 2028712 2028712 defendant Dekyns William yeoman 591588 591588 Dekyns, William, of Newent, Glos, yeoman 1
4011699 2028919 2028919 defendant Collyns Ciprian yeoman 591588 591588 Collyns, Ciprian, of Newent, Glos, yeoman 0
4036979 2037899 2037899 defendant Jowldyng William carpenter 591588 591588 Jowldyng, William, of Newent, Glos, carpenter 1
4121113 2067842 2067842 defendant Lambe John glover 591588 591588 Lambe, John, of Newent, Glos, glover 4
4142419 2075522 2075522 defendant Wattes William shoemaker 591588 591588 Wattes, William, of Newent, Glos, shoemaker 0
4165424 2083410 2083410 defendant Kyrle James gent 591588 591588 Kyrle, James, of Newent, Glos, gent 0
4168471 2084457 2084457 defendant Yames or Ennes or Eimes James gent 591588 591588 Yames or Ennes or Eimes, James, of Newent, Glos, gent 1
4192492 2092935 2092935 defendant Lambe John glover 591588 591588 Lambe, John, of Newent, Glos, glover 0
4218609 2102006 2102006 defendant Bate Richard gent 591588 591588 Bate, Richard, of Newent, Glos, gent 0
4239781 2109545 2109545 defendant Bate Richard gent 591588 591588 Bate, Richard, of Newent, Glos, gent 0
4243916 2110945 2110945 defendant Hooper Margaret widow 591588 591588 Hooper, Margaret, of Newent, Glos, widow 1
4255081 2114694 2114694 defendant Hooper John (legal representative) 591588 591588 Hooper, John, of Newent, Glos, yeoman, administratrix of 0
4262200 2117030 2117030 defendant Bate Richard gent 591588 591588 Bate, Richard, of Newent, Glos, gent 0
4294834 2128237 2128237 defendant Hill John gent 591588 591588 Hill, John, of Newent, Glos, gent 0
4295813 2128596 2128596 defendant Hill John gent 591588 591588 Hill, John, of Newent, Glos, gent 0
4303291 2131279 2131279 defendant Hill John alias Richard gent 591588 591588 Hill, John alias Richard, of Newent, Glos, gent 0
4362570 2151666 2151666 defendant Dunne Henry clerk 591588 591588 Dunne, Henry, of Newent, Glos, clerk 0
4366531 2153078 2153078 defendant Brayne Richard gent 591588 591588 Brayne, Richard, of Newent, Glos, gent 0
4411129 2168310 2168310 defendant Donne or Doune Christopher gent 591588 591588 Donne or Doune, Christopher, of Newent, Glos, gent 0
5253771 2431294 2431294 defendant Eylond John esq 591588 591588 Eylond, John, of Newent, Glos, esq 0
5359729 2463081 2463081 defendant Portyr Thomas gent 591588 591588 Portyr, Thomas, of Newent, Glos, gent 3
5362613 2463954 2463954 defendant Porter John gent 591588 591588 Porter, John, of Newent, Glos, gent 0
5362615 2463955 2463955 defendant Porter Thomas gent 591588 591588 Porter, Thomas, of Newent, Glos, gent 0
5483227 2499925 2499925 defendant Stokes John dyer 591588 591588 Stokes, John, of Newent, Glos, dyer 4
5495616 2503589 2503589 defendant Hoke Guy yeoman 591588 591588 Hoke, Guy, of Newent, Glos, yeoman 0
5537181 2516115 2516115 defendant Saunders John yeoman 591588 591588 Saunders, John, of Newent, Glos, yeoman 0
5558739 2522508 2522508 defendant Porter Richard gent 591588 591588 Porter, Richard, of Newent, Glos, gent 1
5558743 2522509 2522509 defendant Porter Richard gent 591588 591588 Porter, Richard, of Newent, Glos, gent 1
5583159 2529807 2529807 defendant Porter Roger gent 591588 591588 Porter, Roger, of Newent, Glos, gent 0
5583161 2529808 2529808 defendant Porter Roger gent 591588 591588 Porter, Roger, of Newent, Glos, gent 0
5599831 2534833 2534833 defendant Hoke Richard yeoman 591588 591588 Hoke, Richard, of Newent, Glos, yeoman 4

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