names

16 rows where case_id = 2449041

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5313381 2449041 2449041 plaintiff Bonham Walter esq   Bonham, Walter, esq 0
5313382 2449041 2449041 defendant Tege John husbandman 609035 609035 Tege, John, of Portbury, husbandman 0
5313383 2449041 2449041 defendant Dyker John chapman 609035 609035 Dyker, John, of Portbury, chapman 1
5313384 2449041 2449041 defendant Stanbrigge Robert husbandman 609035 609035 Stanbrigge, Robert, of Portbury, husbandman 2
5313385 2449041 2449041 defendant Stevenys John husbandman 609035 609035 Stevenys, John, of Portbury, husbandman 3
5313386 2449041 2449041 defendant Kyng Thomas husbandman 609035 609035 Kyng, Thomas, of Portbury, husbandman 4
5313387 2449041 2449041 defendant Baker Robert husbandman 609035 609035 Baker, Robert, of Portbury, husbandman 5
5313388 2449041 2449041 defendant Passer John, junior husbandman 609035 609035 Passer, John, junior, of Portbury, husbandman 6
5313389 2449041 2449041 defendant Passer John, senior husbandman 609035 609035 Passer, John, senior, of Portbury, husbandman 7
5313390 2449041 2449041 defendant Savage Thomas husbandman 609035 609035 Savage, Thomas, of Portbury, husbandman 8
5313391 2449041 2449041 defendant Savage John husbandman 609035 609035 Savage, John, of Portbury, husbandman 9
5313392 2449041 2449041 defendant Saymour William, senior husbandman 609035 609035 Saymour, William, senior, of Portbury, husbandman 10
5313393 2449041 2449041 defendant Hill John husbandman 609035 609035 Hill, John, of Portbury, husbandman 11
5313394 2449041 2449041 defendant Moule Thomas husbandman 609035 609035 Moule, Thomas, of Portbury, husbandman 12
5313395 2449041 2449041 defendant Jacob Roger   609035 609035 Jacob, Roger, of Portbury, millward 13
5313396 2449041 2449041 defendant Baker John yeoman 609035 609035 Baker, John, of Portbury, yeoman 14

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