names

10 rows where place_id = 620597

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3736480 1937657 1937657 defendant Somers Christopher butcher 620597 620597 Somers, Christopher, of Worseworth, butcher 3
4646003 2244904 2244904 defendant Ivette Thomas   620597 620597 Ivette, Thomas, of Worseworth 0
4989295 2353731 2353731 defendant Choo Roger husbandman 620597 620597 Choo, Roger, of Worseworth, husbandman 0
5392401 2472912 2472912 defendant Barker Richard tanner 620597 620597 Barker, Richard, of Worseworth, tanner 1
5392402 2472912 2472912 defendant Robynson James shoemaker 620597 620597 Robynson, James, of Worseworth, shoemaker 2
5392403 2472912 2472912 defendant Fryth Robert laborer 620597 620597 Fryth, Robert, of Worseworth, laborer 3
5392404 2472912 2472912 defendant Mecok Robert walker 620597 620597 Mecok, Robert, of Worseworth, walker 4
5392407 2472912 2472912 defendant Fouke Nicholas laborer 620597 620597 Fouke, Nicholas, of Worseworth, laborer 7
5589832 2531805 2531805 defendant Barstowe Roger miner 620597 620597 Barstowe, Roger, of Worseworth, miner 15
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);