names

17 rows where place_id = 616267

✎ 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
3713546 1930548 1930548 defendant Bone Nicholas (legal representative) 616267 616267 Bone, Nicholas, of Herfeld, gent, executrix of 0
3713547 1930548 1930548 defendant Bone Rose widow 616267 616267 Bone, Rose, of Herfeld, widow 1
3734907 1937156 1937156 defendant Bone Rose widow 616267 616267 Bone, Rose, of Herfeld, widow 1
3744587 1940203 1940203 defendant Whyte Roger laborer 616267 616267 Whyte, Roger, of herfeld, laborer 4
3841741 1971001 1971001 defendant Weden Richard husbandman 616267 616267 Weden, Richard, of Herfeld, husbandman 0
4443865 2183052 2183052 defendant Joop John   616267 616267 Joop, John, of Herfeld, senior 2
4717627 2270849 2270849 defendant Nelam Thomas husbandman 616267 616267 Nelam, Thomas, of Herfeld, husbandman 1
4734553 2275973 2275973 defendant Crowe John   616267 616267 Crowe, John, of Herfeld, Middx, ostler, formerly of Smythfeld 4
4773241 2287599 2287599 defendant Crowe John husbandman 616267 616267 Crowe, John, of Herfeld, husbandman 0
4839827 2308365 2308365 defendant Perot Margaret spinster 616267 616267 Perot, Margaret, of Herfeld, spinster 6
4974063 2349206 2349206 defendant Ketyll Richard yeoman 616267 616267 Ketyll, Richard, of Herfeld, yeoman 0
5178454 2409406 2409406 defendant Assheby George, sen gent 616267 616267 Assheby, George, sen, of Herfeld, gent 0
5252007 2430731 2430731 defendant Blakwell John husbandman 616267 616267 Blakwell, John, of Herfeld, husbandman 1
5321714 2451568 2451568 defendant James John (legal representative) 616267 616267 James, John, of Herfeld, administrator of 3
5321719 2451569 2451569 defendant Osbern George husbandman 616267 616267 Osbern, George, of Herfeld, husbandman 2
5391360 2472606 2472606 defendant Pylcher John, junior yeoman 616267 616267 Pylcher, John, junior, of Herfeld, yeoman 10
5602653 2535711 2535711 defendant Sasse Nicholas   616267 616267 Sasse, Nicholas, of Herfeld, gun maker 8

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