names

35 rows where place_id = 612368

✎ 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
3692885 1923971 1923971 defendant Shorte Richard yeoman 612368 612368 Shorte, Richard, of Newport Ponde, yeoman 1
3696242 1925046 1925046 defendant Norres William laborer 612368 612368 Norres, William, of Newport Ponde, laborer 0
3696243 1925046 1925046 defendant Short Richard laborer 612368 612368 Short, Richard, of Newport Ponde, laborer 1
3696244 1925046 1925046 defendant Cobler William laborer 612368 612368 Cobler, William, of Newport Ponde, laborer 2
3758819 1944746 1944746 defendant Brode John brickmaker 612368 612368 Brode, John, of Newport Ponde, brickmaker 1
3772137 1948977 1948977 defendant Shorte Robert husbandman 612368 612368 Shorte, Robert, of Newport Ponde, husbandman 1
3772860 1949205 1949205 defendant Frayday Nicholas husbandman 612368 612368 Frayday, Nicholas, of Newport Ponde, husbandman 0
3782237 1952196 1952196 defendant Pynner alias Longe William butcher 612368 612368 Pynner alias Longe, William, of Newport Ponde, butcher 0
3790463 1954838 1954838 defendant Edryche Stephen miller 612368 612368 Edryche, Stephen, of Newport Ponde, miller 0
3790993 1955019 1955019 defendant Meryffe Richard husbandman 612368 612368 Meryffe, Richard, of Newport Ponde, husbandman 3
3807267 1960170 1960170 defendant Maryff Richard husbandman 612368 612368 Maryff, Richard, of Newport Ponde, husbandman 3
3829994 1967277 1967277 defendant Martyn William husbandman 612368 612368 Martyn, William, of Newport Ponde, husbandman 1
3829995 1967277 1967277 defendant Grace Richard husbandman 612368 612368 Grace, Richard, of Newport Ponde, husbandman 2
3829996 1967277 1967277 defendant Collys John husbandman 612368 612368 Collys, John, of Newport Ponde, husbandman 3
3829998 1967278 1967278 defendant Maryff Richard husbandman 612368 612368 Maryff, Richard, of Newport Ponde, husbandman 0
3829999 1967278 1967278 defendant Sabysforth Matthew husbandman 612368 612368 Sabysforth, Matthew, of Newport Ponde, husbandman 1
3830000 1967278 1967278 defendant Walforth John husbandman 612368 612368 Walforth, John, of Newport Ponde, husbandman 2
3830001 1967278 1967278 defendant Tyllynghurst Simon cooper 612368 612368 Tyllynghurst, Simon, of Newport Ponde, cooper 3
3830002 1967278 1967278 defendant Norys William husbandman 612368 612368 Norys, William, of of Newport Ponde, husbandman 4
3842615 1971218 1971218 defendant Coole Richard baker 612368 612368 Coole, Richard, of Newport Ponde, baker 1
3846227 1972377 1972377 defendant Brod John brickmaker 612368 612368 Brod, John, of Newport Ponde, brickmaker 1
3846229 1972377 1972377 defendant Lundysshe alias Londes Agnes widow 612368 612368 Lundysshe alias Londes, Agnes, of Newport Ponde, widow 3
3846230 1972377 1972377 defendant Aldriche alias Bedell Thomas husbandman 612368 612368 Aldriche alias Bedell, Thomas, of Newport Ponde, husbandman 4
3850035 1973600 1973600 plaintiff Maryff Richard, senior husbandman 612368 612368 Maryff, Richard, senior, of Newport Ponde, husbandman 0
3862417 1977624 1977624 defendant Colles John husbandman 612368 612368 Colles, John, of Newport Ponde, husbandman 0
3889356 1986670 1986670 defendant Nytyngale Stephen tawyer 612368 612368 Nytyngale, Stephen, of Newport Ponde, tawyer 4
3899338 1989991 1989991 defendant Brande Henry glover 612368 612368 Brande, Henry, of Newport Ponde, glover 0
3899339 1989991 1989991 defendant Donham Henry yeoman 612368 612368 Donham, Henry, of Newport Ponde, yeoman 1
3908621 1993182 1993182 defendant Buck George laborer 612368 612368 Buck, George, of Newport Ponde, laborer 0
3923342 1998114 1998114 defendant Bronde Henry, senior glover 612368 612368 Bronde, Henry, senior, of Newport Ponde, glover 0
3923343 1998114 1998114 defendant Tryxover John maltman 612368 612368 Tryxover, John, of Newport Ponde, maltman 1
3961076 2010968 2010968 defendant Nightyngale William yeoman 612368 612368 Nightyngale, William, of Newport Ponde, yeoman 0
4089285 2056452 2056452 defendant Holden William gent 612368 612368 Holden, William, of Newport Ponde, or of Wenden Magna, gent 1
4329098 2140042 2140042 defendant Marten Edward husbandman 612368 612368 Marten, Edward, of Newport Ponde, husbandman 0
4395120 2162956 2162956 defendant Brond John butcher 612368 612368 Brond, John, of Newport Ponde, butcher 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);