names

17 rows where place_id = 597179

✎ 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
3627566 1903479 1903479 defendant Emerson Ralph husbandman 597179 597179 Emerson, Ralph, of Silton, husbandman 0
4533496 2210746 2210746 plaintiff Robynson Robert   597179 597179 Robynson, Robert, of Silton 0
4561426 2219515 2219515 defendant del Hall Peter   597179 597179 del Hall, Peter, of Silton 24
4561427 2219515 2219515 defendant Bulmer Walter   597179 597179 Bulmer, Walter, of Silton 25
4561428 2219515 2219515 defendant Bulmer John   597179 597179 Bulmer, John, of Silton 26
4581542 2225674 2225674 defendant Cokes Robert   597179 597179 Cokes, Robert, of Silton 0
4611620 2234697 2234697 defendant Bulmer John   597179 597179 Bulmer, John, of Silton 1
4611621 2234697 2234697 defendant Bradfeld John   597179 597179 Bradfeld, John, of Silton 2
4626756 2239311 2239311 defendant Bulmer John   597179 597179 Bulmer, John, of Silton 4
4668285 2255794 2255794 plaintiff Barton Thomas   597179 597179 Barton, Thomas, of Silton 0
4668887 2255970 2255970 plaintiff Berton Thomas   597179 597179 Berton, Thomas, of Silton 0
4755812 2282201 2282201 defendant Baldewene John yeoman 597179 597179 Baldewene, John, of Silton, yeoman 0
4912456 2330401 2330401 plaintiff Carent John esq 597179 597179 Carent, John, of Silton, esq 0
5088447 2382996 2382996 defendant Baron John husbandman 597179 597179 Baron, John, of Silton, husbandman 1
5141565 2398644 2398644 plaintiff Silton Ralph   597179 597179 Silton, Ralph, of Silton 3
5450051 2489905 2489905 defendant Sanger Stephen husbandman 597179 597179 Sanger, Stephen, of Silton, husbandman 0
5622052 2550808 2550808 plaintiff Topclyf Walter de chaplain 597179 597179 Topclyf, Walter de, of Silton, chaplain 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);