names

15 rows where place_id = 595237

✎ 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
3619573 1873688 1873688 defendant Litulhey William gent 595237 595237 Litulhey, William, of West Bromwyche, Staffs, gent 0
3620998 1874125 1874125 defendant Lyttelhaye William gent 595237 595237 Lyttelhaye, William, of West Bromwyche, Staffs, gent 1
3788986 1954366 1954366 defendant Sarpylls Henry husbandman 595237 595237 Sarpylls, Henry, of West Bromwyche, Staffs, husbandman 3
3868356 1979656 1979656 defendant Russheton John   595237 595237 Russheton, John, of West Bromwyche, Staffs, horse courser 0
3868358 1979657 1979657 defendant Russheton John   595237 595237 Russheton, John, of West Bromwyche, Staffs, horse courser 0
3976770 2016441 2016441 defendant Hamson or Emson Roger husbandman 595237 595237 Hamson or Emson, Roger, of West Bromwyche, Staffs, husbandman 2
3983736 2018956 2018956 plaintiff Stanley Winifred widow 595237 595237 Stanley, Winifred, of West Bromwyche, Staffs, widow 0
3983738 2018957 2018957 plaintiff Stanley Winifred widow 595237 595237 Stanley, Winifred, of West Bromwyche, Staffs, widow 0
4033547 2036650 2036650 defendant Abbott or Abotes John cooper 595237 595237 Abbott or Abotes, John, of West Bromwyche, Staffs, cooper 0
4722506 2272356 2272356 defendant Torbyn Thomas husbandman 595237 595237 (Torbyn, Thomas, of West Bromwyche, Staffs, husbandman 1
5136616 2397229 2397229 defendant Geffeson Henry husbandman 595237 595237 Geffeson, Henry, of West Bromwyche, Staffs, husbandman 0
5157190 2403242 2403242 defendant Geffeson Henry husbandman 595237 595237 Geffeson, Henry, of West Bromwyche, Staffs, husbandman 0
5157193 2403243 2403243 defendant Geffeson Henry husbandman 595237 595237 Geffeson, Henry, of West Bromwyche, Staffs, husbandman 0
5157196 2403244 2403244 defendant Geffeson Henry husbandman 595237 595237 Geffeson, Henry, of West Bromwyche, Staffs, husbandman 0
5480728 2499198 2499198 defendant Byram Robert husbandman 595237 595237 Byram, Robert, of West Bromwyche, Staffs, husbandman 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);