names

21 rows where place_id = 616597

✎ 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
3715239 1931053 1931053 defendant Grove Richard laborer 616597 616597 Grove, Richard, of Feccham, laborer 0
3715240 1931053 1931053 defendant Man Richard laborer 616597 616597 Man, Richard, of Feccham, laborer 1
3715241 1931053 1931053 defendant Cheynell William laborer 616597 616597 Cheynell, William, of Feccham, laborer 2
3746529 1940826 1940826 defendant Edsawe Thomas husbandman 616597 616597 Edsawe, Thomas, of Feccham, husbandman 1
3749457 1941743 1941743 defendant Blundell Henry husbandman 616597 616597 Blundell, Henry, of Feccham, husbandman 4
3749458 1941743 1941743 defendant Man John husbandman 616597 616597 Man, John, of Feccham, husbandman 5
3749459 1941743 1941743 defendant Smyth Philip laborer 616597 616597 Smyth, Philip, of Feccham, laborer 6
3749460 1941743 1941743 defendant Gryffyn John laborer 616597 616597 Gryffyn, John, of Feccham, laborer 7
3749461 1941743 1941743 defendant Grove Richard laborer 616597 616597 Grove, Richard, of Feccham, laborer 8
3749462 1941743 1941743 defendant Hamond Henry laborer 616597 616597 Hamond, Henry, of Feccham, laborer 9
3749463 1941743 1941743 defendant Cheynell William laborer 616597 616597 Cheynell, William, of Feccham, laborer 10
3749464 1941743 1941743 defendant Neell homas laborer 616597 616597 Neell, homas, of Feccham, laborer 11
3749465 1941743 1941743 defendant Lamston Richard laborer 616597 616597 Lamston, Richard, of Feccham, laborer 12
3749466 1941743 1941743 defendant Tayllour Thomas laborer 616597 616597 Tayllour, Thomas, of Feccham, laborer 13
3749467 1941743 1941743 defendant Baylly Robert laborer 616597 616597 Baylly, Robert, of Feccham, laborer 14
5081926 2381090 2381090 defendant Mayhu John husbandman 616597 616597 Mayhu, John, of Feccham, husbandman 1
5081929 2381090 2381090 defendant Shepherd Richard husbandman 616597 616597 Shepherd, Richard, of Feccham, husbandman 4
5106905 2388448 2388448 defendant Mayhu John husbandman 616597 616597 Mayhu, John, of Feccham, husbandman 1
5106908 2388448 2388448 defendant Shepherd Richard husbandman 616597 616597 Shepherd, Richard, of Feccham, husbandman 4
5314311 2449299 2449299 defendant Oxton John   616597 616597 Oxton, John, of Feccham, collar maker 1
5350480 2460269 2460269 defendant Monke Henry carpenter 616597 616597 Monke, Henry, of Feccham, carpenter 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);