names

22 rows where place_id = 643570

✎ 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
3831822 1967850 1967850 plaintiff Harrys Humphrey (legal representative) 643570 643570 Harrys, Humphrey, of Kynfare, chapman, executors of 0
3874604 1981727 1981727 defendant Ryge Roger carver 643570 643570 Ryge, Roger, of Kynfare, carver 3
3934170 2001721 2001721 defendant Jurden William husbandman 643570 643570 Jurden, William, of Kynfare, husbandman 0
4217075 2101466 2101466 defendant Mowseley William glover 643570 643570 Mowseley, William, of Kynfare, glover 0
4217462 2101601 2101601 defendant Wakelen John yeoman 643570 643570 Wakelen, John, of Kynfare, yeoman 0
4238566 2109103 2109103 defendant Briscott Robert butcher 643570 643570 Briscott, Robert, of Kynfare, butcher 0
4573001 2223090 2223090 plaintiff Baker Robert   643570 643570 Baker, Robert, of Kynfare 0
4585575 2226910 2226910 defendant Lowe John   643570 643570 Lowe, John, of Kynfare 1
4783416 2290831 2290831 defendant Hynchesley John smith 643570 643570 Hynchesley, John, of Kynfare, smith 1
4783417 2290831 2290831 defendant Lyende Richard tanner 643570 643570 Lyende, Richard, of Kynfare, tanner 2
4783418 2290831 2290831 defendant atte Yate John drover 643570 643570 atte Yate, John, of Kynfare, drover 3
4783419 2290831 2290831 defendant Bredhull William   643570 643570 Bredhull, William, of Kynfare, board hewer 4
4783420 2290831 2290831 defendant atte Lowe John   643570 643570 atte Lowe, John, of Kynfare, card maker 5
4929617 2335678 2335678 defendant Baylly John yeoman 643570 643570 Baylly, John, of Kynfare or Kinver, yeoman 0
5270372 2436436 2436436 defendant Herrys Richard husbandman 643570 643570 Herrys, Richard, of Kynfare, husbandman 0
5270373 2436436 2436436 defendant Hilton John husbandman 643570 643570 Hilton, John, of Kynfare or Kinver, husbandman 1
5438541 2486463 2486463 defendant Blokley John yeoman 643570 643570 Blokley, John, of Kynfare, yeoman 0
5452543 2490642 2490642 defendant Blokley John   643570 643570 Blokley, John, of Kynfare 0
5464430 2494277 2494277 defendant Blokley John yeoman 643570 643570 Blokley, John, of Kynfare, yeoman 0
5491772 2502439 2502439 defendant Bowelond John yeoman 643570 643570 Bowelond, John, of Kynfare, yeoman 0
5519824 2511038 2511038 defendant Welford William glover 643570 643570 Welford, William, of Kynfare, glover 0
5579427 2528644 2528644 plaintiff Harrys Humphrey merchant 643570 643570 Harrys, Humphrey, of Kynfare, merchant 1

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