names

24 rows where place_id = 606446

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3665221 1915078 1915078 defendant Trent William miller 606446 606446 Trent, William, of Northover, miller 0
3951012 2007420 2007420 defendant Bull Thomas husbandman 606446 606446 Bull, Thomas, of Northover, husbandman 0
4120438 2067586 2067586 defendant Hobbes Thomas miller 606446 606446 Hobbes, Thomas, of Northover, miller 0
4130170 2071098 2071098 defendant Hopkyns Richard yeoman 606446 606446 Hopkyns, Richard, of Northover, or of Norton by Ivelchester, yeoman 1
4160341 2081691 2081691 defendant Golde Edward yeoman 606446 606446 Golde, Edward, of Northover, yeoman 0
4183862 2089848 2089848 defendant Gold Edward yeoman 606446 606446 Gold, Edward, of Northover, yeoman 0
4513090 2204529 2204529 defendant Smyth Thomas   606446 606446 Smyth, Thomas, of Northover 2
4518985 2206295 2206295 defendant Smyth Thomas   606446 606446 Smyth, Thomas, of Northover 2
4525458 2208296 2208296 defendant Dyer Richard   606446 606446 Dyer, Richard, of Northover 2
4533968 2210895 2210895 plaintiff Russell John   606446 606446 Russell, John, of Northover 0
4535051 2211239 2211239 defendant Smyth Thomas   606446 606446 Smyth, Thomas, of Northover 6
4609319 2234015 2234015 defendant Russell John   606446 606446 Russell, John, of Northover 0
4609320 2234015 2234015 defendant Smyth John   606446 606446 Smyth, John, of Northover 1
4622169 2237911 2237911 defendant Russell John   606446 606446 Russell, John, of Northover 1
4712516 2269232 2269232 defendant Grene William husbandman 606446 606446 Grene, William, of Northover by Yevelchester, husbandman 0
4715655 2270224 2270224 defendant Crukern John weaver 606446 606446 Crukern, John, of Northover, weaver 1
4823350 2303390 2303390 defendant Pyry Richard milner 606446 606446 Pyry, Richard, of Northover, milner 2
4823351 2303390 2303390 defendant Ryston John tailor 606446 606446 Ryston, John, of Northover, tailor 3
5176349 2408772 2408772 defendant Gybbys Richard chaplain 606446 606446 Gybbys, Richard, of Northover by Yevelchester, chaplain 0
5209299 2418453 2418453 defendant Page Robert merchant 606446 606446 Page, Robert, of Northover, merchant 0
5210497 2418804 2418804 defendant Gybbys Richard chaplain 606446 606446 Gybbys, Richard, of Northover by Yevelchester, chaplain 0
5451091 2490218 2490218 defendant Pax Thomas smith 606446 606446 Pax, Thomas, of Northover by Yevelchester, smith 0
5463238 2493920 2493920 defendant Pay Thomas smith 606446 606446 Pay, Thomas, of Northover by Yevechester, smith 0
5486388 2500815 2500815 defendant Pax Thomas smith 606446 606446 Pax, Thomas, of Northover juxta Tevelchester, smith 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);