names

15 rows where case_id = 2240500

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4630677 2240500 2240500 plaintiff Sturmer Henry     Sturmer, Henry 0
4630678 2240500 2240500 defendant Heigham John   586559 586559 Heigham, John, of Topcroft, parson 0
4630679 2240500 2240500 defendant Turnour Robert   592341 592341 Turnour, Robert, of Bergh 1
4630680 2240500 2240500 defendant Hawe Thomas   628797 628797 Hawe, Thomas, of Hacford 2
4630681 2240500 2240500 defendant Ropere Nicholas   586820 586820 Ropere, Nicholas, of Swanton 3
4630682 2240500 2240500 defendant Wolvene John   633612 633612 Wolvene, John, of Thorp Market, vicar 4
4630683 2240500 2240500 defendant Soppe Robert clerk   Soppe, Robert, clerk 5
4630684 2240500 2240500 defendant Smyth John     Smyth, John 6
4630685 2240500 2240500 defendant Wyncle Thomas   586882 586882 Wyncle, Thomas, of Betele 7
4630686 2240500 2240500 defendant Cok Thomas clerk   Cok, Thomas, clerk 8
4630687 2240500 2240500 defendant Creyk John   603370 603370 Creyk, John, of Lynne 9
4630688 2240500 2240500 defendant Sevepens Simon     Sevepens, Simon 10
4630689 2240500 2240500 defendant Lyro Thomas     Lyro, Thomas 11
4630690 2240500 2240500 defendant Colyn John   757517 757517 Colyn, John, of Brunham 12
4630691 2240500 2240500 defendant Sadeler Thomas   605374 605374 Sadeler, Thomas, of Brynton 13

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