names

21 rows where place_id = 671978

✎ 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
4003851 2026143 2026143 plaintiff Hunte George clothoer 671978 671978 Hunte, George, of Bradfeild, clothoer 0
4011150 2028754 2028754 defendant Hunt George clothier 671978 671978 Hunt, George, of Bradfeild, clothier 0
4107277 2062894 2062894 defendant Riche Peter carpenter 671978 671978 Riche, Peter, of Bradfeild, carpenter 1
4168090 2084327 2084327 defendant Bacon Robert yeoman 671978 671978 Bacon, Robert, of Bradfeild, or of Ughill Woodside, Yorks, yeoman 2
4177287 2087527 2087527 defendant Howe Edmund husbandman 671978 671978 Howe, Edmund, of Bradfeild, husbandman 0
4205940 2097620 2097620 defendant Barnes William yeoman 671978 671978 Barnes, William, of Bradfeild, yeoman 0
4205941 2097620 2097620 defendant Barnes Thomas yeoman 671978 671978 Barnes, Thomas, of Bradfeild, yeoman 1
4223367 2103666 2103666 defendant Brooker Walter yeoman 671978 671978 Brooker, Walter, of Bradfeild, yeoman 1
4274451 2121010 2121010 defendant Fabyan Anne widow 671978 671978 Fabyan, Anne, of Bradfeild, widow 2
4279084 2122615 2122615 defendant Jennyng Bartholomew yeoman 671978 671978 Jennyng, Bartholomew, of Bradfeild, yeoman 0
4341422 2144277 2144277 defendant Greaves Robert yeoman 671978 671978 Greaves, Robert, of Bradfeild, yeoman 1
4360548 2150940 2150940 defendant Turner William   671978 671978 Turner, William, of Bradfeild husbandman 3
4365056 2152557 2152557 defendant Greaves Robert yeoman 671978 671978 Greaves, Robert, of Bradfeild, yeoman 1
4382056 2158683 2158683 defendant Wilson Christopher yeoman 671978 671978 Wilson, Christopher, of Bradfeild, yeoman 0
4382057 2158683 2158683 defendant Greene William yeoman 671978 671978 Greene, William, of Bradfeild, yeoman 1
4393893 2162557 2162557 defendant Burges Edward beer brewer 671978 671978 Burges, Edward, of Bradfeild, beer brewer 1
4396567 2163421 2163421 defendant Hollowaye Edmund yeoman 671978 671978 Hollowaye, Edmund, of Bradfeild, yeoman 1
4404303 2166009 2166009 defendant Ashwell William yeoman 671978 671978 Ashwell, William, of Bradfeild, yeoman 2
4404304 2166009 2166009 defendant Ashwell Thomas yeoman 671978 671978 Ashwell, Thomas, of Bradfeild, yeoman 3
4404988 2166238 2166238 defendant Bromehead Thomas husbandman 671978 671978 Bromehead, Thomas, of Bradfeild, husbandman 0
4406252 2166655 2166655 defendant Cole John husbandman 671978 671978 Cole John, of Bradfeild, 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);