names

17 rows where place_id = 597531

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628931 1903925 1903925 defendant Palmer William smith 597531 597531 Palmer, William, of Horebrigge, smith 2
3700140 1926275 1926275 defendant Palmer William smith 597531 597531 Palmer, William, of Horebrigge, smith 1
3700141 1926275 1926275 defendant Palmer Nicholas smith 597531 597531 Palmer, Nicholas, of Horebrigge, smith 2
3706203 1928227 1928227 defendant Cole William husbandman 597531 597531 Cole, William, of Horebrigge, husbandman 1
3707055 1928494 1928494 defendant Warder William yeoman 597531 597531 Warder, William, of Horebrigge, yeoman 0
3794964 1956288 1956288 defendant Talbot alias Stephyn Roger laborer 597531 597531 Talbot alias Stephyn, Roger, of Horebrigge, laborer 4
4651559 2246488 2246488 defendant Bugge Richard   597531 597531 Bugge, Richard, of Horebrigge, bailiff 4
4663874 2250186 2250186 defendant Dyker John mercer 597531 597531 (Dyker, John, of Horebrigge, mercer 1
4789071 2292638 2292638 defendant Webber John tailor 597531 597531 Webber, John, of Horebrigge, tailor 0
5030235 2365712 2365712 defendant Jagge John husbandman 597531 597531 Jagge, John, of Horebrigge, husbandman 1
5128956 2394953 2394953 defendant Brok John yeoman 597531 597531 Brok, John, of Horebrigge, yeoman 2
5135626 2396930 2396930 defendant Webbe Henry   597531 597531 Webbe, Henry, of Horebrigge 0
5155875 2402880 2402880 defendant Webbe Henry butcher 597531 597531 Webbe, Henry, of Horebrigge, butcher 0
5189433 2412647 2412647 defendant Jagge John, sen husbandman 597531 597531 Jagge, John, sen, of Horebrigge, husbandman 0
5206497 2417633 2417633 defendant Jagge John, sen husbandman 597531 597531 Jagge, John, sen, of Horebrigge, husbandman 0
5207632 2417972 2417972 defendant Webbe Henry butcher 597531 597531 Webbe, Henry, of Horebrigge, butcher 0
5318993 2450772 2450772 defendant Pacchecote John yeoman 597531 597531 Pacchecote, John, of Horebrigge, yeoman 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);