names

30 rows where place_id = 603080

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652987 1911265 1911265 defendant Bonyface John husbandman 603080 603080 Bonyface, John, of Bradworthy, husbandman 0
3652988 1911265 1911265 defendant Wode John, senior husbandman 603080 603080 Wode, John, senior, of Bradworthy, husbandman 1
3674836 1918158 1918158 defendant Collyn John chaplain 603080 603080 Collyn, John, of Bradworthy, chaplain 1
3733509 1936725 1936725 defendant Hanger John yeoman 603080 603080 Hanger, John, of Bradworthy, yeoman 2
3803011 1958842 1958842 defendant Braddon Roger husbandman 603080 603080 Braddon, Roger, of Bradworthy, husbandman 1
4053942 2043786 2043786 defendant Yeo Thomas merchant 603080 603080 Yeo, Thomas, of Bradworthy, merchant 2
5357805 2462512 2462512 defendant Blanchard Richard husbandman 603080 603080 Blanchard, Richard, of Bradworthy, husbandman 0
5429370 2483720 2483720 defendant Yeo William gent 603080 603080 Yeo, William, of Bradworthy, gent 0
5429371 2483720 2483720 defendant Wode John husbandman 603080 603080 Wode, John, of Bradworthy, husbandman 1
5429372 2483720 2483720 defendant Parkman Thomas husbandman 603080 603080 Parkman, Thomas, of Bradworthy, husbandman 2
5429373 2483720 2483720 defendant Hurde Robert   603080 603080 Hurde, Robert, of Bradworthy, groom 3
5457662 2492192 2492192 defendant Cory Walter husbandman 603080 603080 Cory, Walter, of Bradworthy, husbandman 0
5457663 2492192 2492192 defendant Holygrave William husbandman 603080 603080 Holygrave, William, of Bradworthy, husbandman 1
5457664 2492192 2492192 defendant Fotys Thomas husbandman 603080 603080 Fotys, Thomas, of Bradworthy, husbandman 2
5457665 2492192 2492192 defendant Gene Robert, sen   603080 603080 Gene, Robert, sen, of Bradworthy, groom 3
5457666 2492192 2492192 defendant Gene Robert   603080 603080 Gene, Robert, of Bradworthy, groom 4
5457668 2492192 2492192 defendant Beauford John   603080 603080 Beauford, John, of Bradworthy 6
5457669 2492192 2492192 defendant Trenman William husbandman 603080 603080 Trenman, William, of Bradworthy, husbandman 7
5457670 2492192 2492192 defendant Holygrave John husbandman 603080 603080 Holygrave, John, of Bradworthy, husbandman 8
5507030 2507110 2507110 defendant Blauncherd Richard husbandman 603080 603080 Blauncherd, Richard, of Bradworthy, husbandman, son of Blauncherd, Otto, husbandman 0
5527347 2513133 2513133 defendant Yoo Richard yeoman 603080 603080 Yoo, Richard, of Bradworthy, yeoman 2
5527349 2513134 2513134 defendant Yeo Richard yeoman 603080 603080 Yeo, Richard, of Bradworthy, yeoman 0
5527697 2513244 2513244 defendant Wode John husbandman 603080 603080 Wode, John, of Bradworthy, husbandman 0
5527699 2513245 2513245 defendant Wode John husbandman 603080 603080 Wode, John, of Bradworthy, husbandman 0
5527702 2513246 2513246 defendant Elyot Nicholas husbandman 603080 603080 Elyot, Nicholas, of Bradworthy, husbandman 0
5527703 2513246 2513246 defendant Elyot John laborer 603080 603080 Elyot, John, of Bradworthy, laborer 1
5537534 2516227 2516227 defendant Lorymer John husbandman 603080 603080 Lorymer, John, of Bradworthy, husbandman 0
5576379 2527665 2527665 defendant Ley William husbandman 603080 603080 Ley, William, of Bradworthy, husbandman 0
5578287 2528278 2528278 defendant Balamy John husbandman 603080 603080 Balamy, John, of Bradworthy, husbandman 1
5599126 2534610 2534610 defendant Saunder John husbandman 603080 603080 Saunder, John, of Bradworthy, husbandman 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);