names

16 rows where place_id = 590700

✎ 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
3602032 1868296 1868296 defendant Frank William yeoman 590700 590700 Frank, William, of Wandelesworth, Surrey, yeoman 0
3863611 1978017 1978017 defendant A Holme George husbandman 590700 590700 A Holme, George, of Wandelesworth, Surrey, husbandman 1
4573861 2223344 2223344 defendant Waterman William   590700 590700 Waterman, William, of Wandelesworth, Surrey 0
4655358 2247566 2247566 defendant Hunte John husbandman 590700 590700 Hunte, John, of Wandelesworth, Surrey, husbandman 0
4655362 2247567 2247567 defendant Hunte John husbandman 590700 590700 Hunte, John, of Wandelesworth, Surrey, husbandman 0
5074492 2378874 2378874 defendant Wheler Thomas husbandman 590700 590700 Wheler, Thomas, of Wandelesworth, Surrey, husbandman 2
5074496 2378875 2378875 defendant Wheler Thomas husbandman 590700 590700 Wheler, Thomas, of Wandelesworth, Surrey, husbandman 2
5092477 2384178 2384178 defendant Colman John husbandman 590700 590700 Colman, John, of Wandelesworth, Surrey, husbandman 0
5216760 2420638 2420638 plaintiff Dounton William gent 590700 590700 Dounton, William, of Wandelesworth, Surrey, gent 0
5340169 2457132 2457132 defendant Style Thomas husbandman 590700 590700 Style, Thomas,of Wandelesworth, Surrey, husbandman 2
5549862 2519992 2519992 defendant Samon Richard fuller 590700 590700 Samon, Richard, of Wandelesworth, Surrey, fuller 0
5592861 2532768 2532768 defendant Frank William brewer 590700 590700 Frank, William, of Wandelesworth, Surrey, brewer 0
5604120 2536149 2536149 defendant Banys Ralph yeoman 590700 590700 Banys, Ralph, of Wandelesworth, Surrey, yeoman 2
5633254 2554405 2554405 defendant atte Hethe Robert fuller 590700 590700 atte Hethe, Robert, of Wandelesworth, Surrey, fuller 2
5633258 2554406 2554406 defendant atte Hethe Robert fuller 590700 590700 atte Hethe, Robert, of Wandelesworth, Surrey, fuller 1
5633338 2554420 2554420 defendant atte Hethe Robert fuller 590700 590700 atte Hethe, Robert, of Wandelesworth, Surrey, fuller 1

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