names

18 rows where place_id = 599034

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634926 1905724 1905724 defendant Pye Richard butcher 599034 599034 Pye, Richard, of Bawtre, Yorks, butcher 1
3670092 1916592 1916592 defendant Bradshawe John gent 599034 599034 Bradshawe, John, of Bawtre, Yorks, gent 1
3670096 1916593 1916593 defendant Bradshawe John gent 599034 599034 Bradshawe, John, of Bawtre, Yorks, gent 1
3683175 1920856 1920856 defendant Morton Charles gent 599034 599034 Morton, Charles, of Bawtre, Yorks, gent 0
3694134 1924370 1924370 defendant Wryghtson William mercer 599034 599034 Wryghtson, William, of Bawtre, Yorks, mercer 0
3743102 1939697 1939697 defendant Hobson Thomas butcher 599034 599034 Hobson, Thomas, of Bawtre, Yorks, butcher 0
3743215 1939742 1939742 defendant Morton Charles esq 599034 599034 Morton, Charles, of Bawtre, Yorks, esq 0
3755286 1943607 1943607 defendant Morton Charles esq 599034 599034 Morton, Charles, of Bawtre, Yorks, esq 0
3797054 1956959 1956959 defendant Morton Charles gent 599034 599034 Morton, Charles, of Bawtre, Yorks, gent 0
3814291 1962379 1962379 defendant Morton Charles gent 599034 599034 Morton, Charles, of Bawtre, Yorks, gent 0
3844441 1971810 1971810 defendant Morton Charles esq 599034 599034 Morton, Charles, of Bawtre, Yorks, esq 0
4658626 2248573 2248573 defendant Morton Robert esq 599034 599034 Morton, Robert, of Bawtre, Yorks, esq 4
4775452 2288319 2288319 defendant Morton Robert esq 599034 599034 Morton, Robert, of Bawtre, Yorks, esq 0
4957482 2344208 2344208 defendant Multon Robert gent 599034 599034 Multon, Robert, of Bawtre, Yorks, gent 1
5106476 2388326 2388326 defendant Hudson Roger yeoman 599034 599034 Hudson, Roger, of Bawtre, Yorks, yeoman 4
5189484 2412665 2412665 defendant Dugmanton John chapman 599034 599034 Dugmanton, John, of Bawtre, Yorks, chapman 0
5206520 2417639 2417639 defendant Dugmanton John chapman 599034 599034 Dugmanton, John, of Bawtre, Yorks, chapman 0
5470966 2496251 2496251 plaintiff Hall John yeoman 599034 599034 Hall, John, of Bawtre, Yorks, yeoman 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);