names

20 rows where place_id = 595043

✎ 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
3618621 1873448 1873448 defendant Smyth Thomas smith 595043 595043 Smyth, Thomas, of Claredon, smith 0
3622794 1874660 1874660 defendant Smyth John smith 595043 595043 Smyth, John, of Claredon, smith 0
3718970 1932213 1932213 defendant Bette John salter 595043 595043 Bette, John, of Claredon, salter 2
3725242 1934184 1934184 plaintiff Smyth John   595043 595043 Smyth, John, of Claredon 0
4553957 2217158 2217158 defendant Wylmyns John   595043 595043 Wylmyns, John, of Claredon 2
4590890 2228503 2228503 defendant Drover William   595043 595043 Drover, William, of Claredon 0
4739180 2277348 2277348 defendant Wylmyn John butcher 595043 595043 Wylmyn, John, of Claredon, butcher 0
4909144 2329403 2329403 defendant Smyth Thomas smith 595043 595043 Smyth, Thomas, of Claredon, smith 0
4909145 2329403 2329403 defendant Lynde Thomas husbandman 595043 595043 Lynde, Thomas, of Claredon, husbandman 1
4996650 2355851 2355851 defendant Brikhill John yeoman 595043 595043 Brikhill, John, of Claredon, yeoman 2
5265825 2435064 2435064 defendant Lancastre Thoms yeoman 595043 595043 Lancastre, Thoms, of Claredon, yeoman 0
5313465 2449057 2449057 defendant Hamond Thomas husbandman 595043 595043 Hamond, Thomas, of Claredon, husbandman 2
5359675 2463063 2463063 defendant Knyght William husbandman 595043 595043 Knyght, William, of Claredon, husbandman 2
5364566 2464578 2464578 defendant Smyth John husbandman 595043 595043 Smyth, John, of Claredon, husbandman 0
5364567 2464578 2464578 defendant Smyth Isabel widow 595043 595043 Smyth, Isabel, of Claredon, widow 1
5389649 2472103 2472103 defendant Rogers William   595043 595043 Rogers, William, of Claredon, plough wright 0
5402410 2475761 2475761 defendant Rogerts William   595043 595043 Rogerts, William, of Claredon, plough wright 0
5415350 2479526 2479526 defendant Rogeres William   595043 595043 Rogeres, William, of Claredon, plough wright 0
5415353 2479527 2479527 defendant Rogers William husbandman 595043 595043 Rogers, William, of Claredon, husbandman 0
5484235 2500210 2500210 defendant Ruttour William husbandman 595043 595043 Ruttour, William, of Claredon, 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);