names

19 rows where case_id = 2531805

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5589816 2531805 2531805 plaintiff Sacheverell Richard     Sacheverell, Richard 0
5589817 2531805 2531805 defendant Typpyng John miner 593361 593361 Typpyng, John, of Derley, miner 0
5589818 2531805 2531805 defendant Pyekar William miner 593361 593361 Pyekar, William, of Derley, miner 1
5589819 2531805 2531805 defendant Meltham Giles miner 593361 593361 Meltham, Giles, of Derley, miner 2
5589820 2531805 2531805 defendant Hunt John miner 593361 593361 Hunt, John, of Derley, miner 3
5589821 2531805 2531805 defendant Holenworth William miner 593361 593361 Holenworth, William, of Derley, miner 4
5589822 2531805 2531805 defendant Wodde Charles miner 593783 593783 Wodde, Charles, of Matlok, miner 5
5589823 2531805 2531805 defendant Flent Roger miner 593783 593783 Flent, Roger, of Matlok, miner 6
5589824 2531805 2531805 defendant Wryght Ralph miner 598843 598843 Wryght, Ralph, of Bonsale, miner 7
5589825 2531805 2531805 defendant Broune Roger miner 593783 593783 Broune, Roger, of Matlok, miner 8
5589826 2531805 2531805 defendant Flynte James miner 593783 593783 Flynte, James, of Matlok, miner 9
5589827 2531805 2531805 defendant Spencer Nicholas miner 593783 593783 Spencer, Nicholas, of Matlok, miner 10
5589828 2531805 2531805 defendant Deyne Robert miner 593783 593783 Deyne, Robert, of Matlok, miner 11
5589829 2531805 2531805 defendant Knolles John miner 903410 903410 Knolles, John, of Ybyll, miner 12
5589830 2531805 2531805 defendant Adam Thomas miner 591263 591263 Adam, Thomas, of Cromford, miner 13
5589831 2531805 2531805 defendant Wylde Bartholomew miner 591263 591263 Wylde, Bartholomew, of Cromford, miner 14
5589832 2531805 2531805 defendant Barstowe Roger miner 620597 620597 Barstowe, Roger, of Worseworth, miner 15
5589833 2531805 2531805 defendant Watson Nicholas miner 903411 903411 Watson, Nicholas, of Bercheaure, miner 16
5589834 2531805 2531805 defendant Chapman Mathewe miner 620597 620597 Chapman, Mathewe, of Worseworth, miner 17

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