names

18 rows where place_id = 610156

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682194 1920536 1920536 defendant David Henry chaplain 610156 610156 David, Henry, of Aldebury, Herts, chaplain 0
3701988 1926875 1926875 defendant Barlee Henry esq 610156 610156 Barlee, Henry, of Aldebury, Herts, esq 0
3733350 1936662 1936662 defendant Barley Henry esq 610156 610156 Barley, Henry, of Aldebury, Herts, esq 0
3733353 1936663 1936663 defendant Berley Henry esq 610156 610156 Berley, Henry, of Aldebury, Herts, esq 0
3733356 1936664 1936664 defendant Berley Henry esq 610156 610156 Berley, Henry, of Aldebury, Herts, esq 0
3844835 1971927 1971927 defendant Scroggys Thomas gent 610156 610156 Scroggys, Thomas, of Aldebury, Herts, gent 0
4582285 2225897 2225897 defendant Claver Walter   610156 610156 Claver, Walter, of Aldebury, Herts, vicar 0
4587990 2227641 2227641 defendant Clerk William   610156 610156 Clerk, William, of Aldebury, Herts 0
4632797 2241135 2241135 defendant Trumpe Robert   610156 610156 Trumpe, Robert, of Aldebury, Herts 3
4660308 2249054 2249054 defendant Trumpe Robert husbandman 610156 610156 Trumpe, Robert, of Aldebury, Herts, husbandman 3
4740705 2277800 2277800 defendant Heyward John husbandman 610156 610156 Heyward, John, of Aldebury, Herts, husbandman 1
4832994 2306337 2306337 defendant Berle John esq 610156 610156 Berle, John, of Aldebury, Herts, esq 0
4841595 2308906 2308906 plaintiff Kilburn John   610156 610156 Kilburn, John, of Aldebury, Herts, parson 0
4841596 2308906 2308906 defendant Randolf John husbandman 610156 610156 Randolf, John, of Aldebury, Herts, husbandman 0
4920316 2332868 2332868 defendant Barlee John esq 610156 610156 Barlee, John, of Aldebury, Herts, esq 0
4922661 2333499 2333499 defendant Barle John esq 610156 610156 Barle, John, of Aldebury, Herts, esq 0
4976288 2349862 2349862 defendant Baker John laborer 610156 610156 Baker, John, of Aldebury, Herts, laborer 0
5380080 2469352 2469352 defendant Barlee William esq 610156 610156 Barlee, William, of Aldebury, Herts, esq 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);