names

29 rows where place_id = 588414

✎ 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
3594413 1865889 1865889 defendant Colyns Thomas, senior butcher 588414 588414 Colyns, Thomas, senior, of Brewod, butcher 1
3594414 1865889 1865889 defendant Colyns Thomas, junior yeoman 588414 588414 Colyns, Thomas, junior, of Brewod, yeoman 2
3664631 1914891 1914891 plaintiff (not given) Margaret prioress of Sandford 588414 588414 Sandford, Margaret, of Brewod, prioress of the monastery 0
3673826 1917844 1917844 defendant Vessy Richard tanner 588414 588414 Vessy, Richard, of Brewod, tanner 2
3687649 1922306 1922306 defendant Northall Roger yeoman 588414 588414 Northall, Roger, of Brewod, yeoman 3
3688184 1922453 1922453 defendant Vesse Richard tanner 588414 588414 Vesse, Richard, of Brewod, tanner 2
3710691 1929664 1929664 defendant Whytefeld Thomas pardoner 588414 588414 Whytefeld, Thomas, of Brewod, pardoner 0
3712058 1930091 1930091 defendant Smyth John butcher 588414 588414 Smyth, John, of Brewod, butcher 0
3712059 1930091 1930091 defendant Vesey Richard laborer 588414 588414 Vesey, Richard, of Brewod, laborer 1
3712060 1930091 1930091 defendant Northall Roger yeoman 588414 588414 Northall, Roger, of Brewod, yeoman 2
3718377 1932031 1932031 defendant Vesse Richard laborer 588414 588414 Vesse, Richard, of Brewod, laborer 3
3741290 1939137 1939137 defendant Colyns William butcher 588414 588414 Colyns, William, of Brewod, butcher 0
3742946 1939644 1939644 defendant Gough Henry husbandman 588414 588414 Gough, Henry, of Brewod, husbandman 0
3742947 1939644 1939644 defendant Smyth John butcher 588414 588414 Smyth, John, of Brewod, butcher 1
3742948 1939644 1939644 defendant Vessy Richard tanner 588414 588414 Vessy, Richard, of Brewod, tanner 2
3749443 1941742 1941742 defendant Vesse Richard tanner 588414 588414 Vesse, Richard, of Brewod, tanner 0
3822425 1964911 1964911 defendant Vesse Richard husbandman 588414 588414 Vesse, Richard, of Brewod, husbandman 3
4054640 2044048 2044048 defendant Goughe William yeoman 588414 588414 Goughe, William, of Brewod, yeoman 0
4054641 2044048 2044048 defendant Nourthalle Thomas yeoman 588414 588414 Nourthalle, Thomas, of Brewod, yeoman 1
4385369 2159797 2159797 defendant Collyns William carpenter 588414 588414 Collyns, William, of Brewod, carpenter 1
4542072 2213412 2213412 defendant Brocton John   588414 588414 Brocton, John, of Brewod, bailiff 0
4826948 2304467 2304467 defendant Wroukeslowe Henry tanner 588414 588414 Wroukeslowe, Henry, of Brewod, tanner 0
4846715 2310479 2310479 defendant Walker Alan husbandman 588414 588414 Walker, Alan, of Brewod, husbandman 0
4891957 2324221 2324221 defendant Belyngton Thomas yeoman 588414 588414 Belyngton, Thomas, of Brewod, yeoman 1
5126605 2394256 2394256 defendant Nicols Thomas yeoman 588414 588414 Nicols, Thomas, of Brewod, yeoman 4
5400267 2475149 2475149 defendant Harper William yeoman 588414 588414 Harper, William,of Brewod, yeoman 0
5428408 2483422 2483422 defendant Harper William   588414 588414 Harper, William, of Brewod 0
5453234 2490846 2490846 defendant Bykford Henry   588414 588414 Bykford, Henry, of Brewod 0
5531928 2514530 2514530 defendant Griffyth Robert painter 588414 588414 Griffyth, Robert, of Brewod, painter 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);