names

21 rows where place_id = 603097

✎ 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
3653086 1911295 1911295 defendant Parsons William husbandman 603097 603097 Parsons, William, of Wyly, husbandman 0
3709069 1929136 1929136 defendant Scote Thomas   603097 603097 Scote, Thomas, of Wyly, shepherd 0
3722242 1933213 1933213 defendant Walsheman Thomas yeoman 603097 603097 Walsheman, Thomas, of Wyly, yeoman 0
3722247 1933214 1933214 defendant Walsheman Thomas yeoman 603097 603097 Walsheman, Thomas, of Wyly, yeoman 0
3723896 1933753 1933753 defendant Wyllyams Thomas yeoman 603097 603097 Wyllyams, Thomas, of Wyly, yeoman 0
3752208 1942616 1942616 defendant Hylman John laborer 603097 603097 Hylman, John, of Wyly, laborer 2
3768836 1947899 1947899 defendant Colen Robert   603097 603097 Colen, Robert, of Wyly, shepherd 2
3786637 1953615 1953615 defendant Colen Robert   603097 603097 Colen, Robert, of Wyly, shepherd 2
3802899 1958804 1958804 defendant Williams Thomas yeoman 603097 603097 Williams, Thomas, of Wyly, yeoman 0
3802901 1958804 1958804 defendant Colen Robert   603097 603097 Colen, Robert, of Wyly, shepherd 2
4545111 2214390 2214390 defendant Symme Thomas   603097 603097 Symme, Thomas, of Wyly 0
4683867 2260564 2260564 plaintiff Gyles Henry   603097 603097 Gyles, Henry, of Wyly, parson 1
4918884 2332419 2332419 defendant Knight William, junior husbandman 603097 603097 Knight, William, junior, of Wyly, husbandman 0
5011193 2360128 2360128 defendant atte Welle Robert husbandman 603097 603097 atte Welle, Robert, of Wyly, husbandman 3
5037358 2367799 2367799 defendant Lokyer Robert husbandman 603097 603097 Lokyer, Robert, of Wyly, husbandman 0
5135777 2396977 2396977 defendant Carneburn John clerk 603097 603097 Carneburn, John, of Wyly, clerk 0
5156029 2402921 2402921 defendant Carneburn John clerk 603097 603097 Carneburn, John, of Wyly, clerk 0
5172370 2407644 2407644 defendant Carneburn John clerk 603097 603097 Carneburn, John, of Wyly, clerk 0
5212244 2419320 2419320 defendant Selke Edmund husbandman 603097 603097 Selke, Edmund, of Wyly, husbandman 0
5230726 2424596 2424596 defendant Colyn John husbandman 603097 603097 Colyn, John, of Wyly, husbandman 0
5252144 2430783 2430783 defendant Smart Thomas husbandman 603097 603097 Smart, Thomas, of Wyly, husbandman 3

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