names

20 rows where place_id = 596403

✎ 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
3624584 1875225 1875225 defendant Lunch Andrew husbandman 596403 596403 Lunch, Andrew, of Maydeford, husbandman 0
4537276 2211929 2211929 defendant Byfeld Richard   596403 596403 Byfeld, Richard, of Maydeford 0
4681431 2259812 2259812 defendant Seyton John   596403 596403 Seyton, John, of Maydeford, bailiff 2
4773257 2287605 2287605 defendant Couper John husbandman 596403 596403 Couper, John, of Maydeford, husbandman 0
4801776 2296737 2296737 defendant Trist William gent 596403 596403 Trist, William, of Maydeford, gent 0
5050051 2371638 2371638 defendant Tryste William yeoman 596403 596403 Tryste, William, of Maydeford, yeoman 0
5254574 2431550 2431550 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5300038 2444975 2444975 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5314656 2449416 2449416 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5321023 2451381 2451381 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5321025 2451382 2451382 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5325493 2452706 2452706 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5329708 2453953 2453953 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5330142 2454092 2454092 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5331869 2454611 2454611 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5350859 2460381 2460381 defendant Triste John gent 596403 596403 Triste, John, of Maydeford, gent 0
5402414 2475762 2475762 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 1
5415358 2479528 2479528 defendant Tr_ John gent 596403 596403 Tr_, John, of Maydeford, gent 2
5479088 2498770 2498770 defendant Tryst John gent 596403 596403 Tryst, John, of Maydeford, gent 0
5613079 2547867 2547867 plaintiff Colyns John   596403 596403 Colyns, John, of Maydeford 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);