names

27 rows where place_id = 681097

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4043449 2040118 2040118 defendant Spyller John gent 681097 681097 Spyller, John, of Shaftsbury, Dorset, gent 0
4062037 2046707 2046707 defendant Heyson Henry draper 681097 681097 Heyson, Henry, of Shaftsbury, Dorset, draper 0
4082119 2053903 2053903 defendant Burbage Richard husbandman 681097 681097 Burbage, Richard, of Shaftsbury, Dorset, husbandman 3
4127156 2070001 2070001 defendant Pearsye Nicholas gent 681097 681097 Pearsye, Nicholas, of Shaftsbury, Dorset, gent 0
4182195 2089251 2089251 defendant Burge John butcher 681097 681097 Burge, John, of Shaftsbury, Dorset, butcher 3
4184780 2090185 2090185 defendant Zouche Charles gent 681097 681097 Zouche, Charles, of Shaftsbury, Dorset, gent 1
4199685 2095439 2095439 defendant Cole Charles yeoman 681097 681097 Cole, Charles, of Shaftsbury, Dorset, yeoman 0
4204098 2096986 2096986 defendant Pearsey Nicholas gent 681097 681097 Pearsey, Nicholas, of Shaftsbury, Dorset, gent 1
4208386 2098481 2098481 defendant Cole Charles goldsmith 681097 681097 Cole, Charles, of Shaftsbury, Dorset, goldsmith 0
4247017 2111977 2111977 defendant Watkyns Humphrey gent 681097 681097 Watkyns, Humphrey, of Shaftsbury, Dorset, gent 0
4255229 2114734 2114734 defendant Anketell Christopher esq 681097 681097 Anketell, Christopher, of Shaftsbury, Dorset, esq 0
4324539 2138598 2138598 defendant Senyor John merchant 681097 681097 Senyor, John, of Shaftsbury, Dorset, merchant 0
4325783 2138998 2138998 defendant Barnard Randolph husbandman 681097 681097 Barnard, Randolph, of Shaftsbury, Dorset, husbandman 0
4328745 2139925 2139925 defendant Anketill Christopher esq 681097 681097 Anketill, Christopher, of Shaftsbury, Dorset, esq 0
4339425 2143555 2143555 defendant Senyor John chapman 681097 681097 Senyor, John, of Shaftsbury, Dorset, chapman 0
4347865 2146504 2146504 defendant Morgan Thomas   681097 681097 Morgan, Thomas, of Shaftsbury, Dorset, woollen draper 0
4356435 2149480 2149480 defendant Morgan Thomas   681097 681097 Morgan, Thomas, of Shaftsbury, Dorset, woollen draper 0
4362775 2151745 2151745 defendant Senyor John chapman 681097 681097 Senyor, John, of Shaftsbury, Dorset, chapman 0
4380581 2158163 2158163 defendant Morgan Thomas draper 681097 681097 Morgan, Thomas, of Shaftsbury, Dorset, draper 0
4380632 2158180 2158180 defendant Senyor John mercer 681097 681097 Senyor, John, of Shaftsbury, Dorset, mercer 0
4396111 2163273 2163273 defendant Bastard Robert cutler 681097 681097 Bastard, Robert, of Shaftsbury, Dorset, cutler 0
4935906 2337621 2337621 defendant Baker Edward baker 681097 681097 Baker, Edward, of Shaftsbury, Dorset, baker 1
5255259 2431761 2431761 defendant Walbrond alias Burley John mercer 681097 681097 Walbrond alias Burley, John, of Shaftsbury, Dorset, mercer 1
5283730 2440285 2440285 defendant Fraunceys John drover 681097 681097 Fraunceys, John, of Shaftsbury, Dorset, drover 7
5346526 2459062 2459062 defendant Legge Robert clerk 681097 681097 Legge, Robert, of Shaftsbury, Dorset, clerk 0
5350487 2460272 2460272 defendant Shoyle or Shayll John chapman 681097 681097 Shoyle or Shayll, John, of Shaftsbury, Dorset, chapman 0
5497818 2504289 2504289 defendant Cornage William cordwainer 681097 681097 (Cornage, William, of Shaftsbury, Dorset, cordwainer 4

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