names

17 rows where place_id = 615836

✎ 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
3711015 1929755 1929755 defendant Bull Thomas husbandman 615836 615836 Bull, Thomas, of Offenham, husbandman 1
4214295 2100517 2100517 defendant Slye John gent 615836 615836 Slye, John, of Offenham, gent 0
4214296 2100517 2100517 defendant Balden Thomas yeoman 615836 615836 Balden, Thomas, of Offenham, yeoman 1
4231986 2106688 2106688 defendant Slye John gent 615836 615836 Slye, John, of Offenham, gent 0
4231987 2106688 2106688 defendant Balden Thomas yeoman 615836 615836 Balden, Thomas, of Offenham, yeoman 1
4245378 2111429 2111429 defendant Pigeon Richard yeoman 615836 615836 Pigeon, Richard, of Offenham, yeoman 1
4274404 2120991 2120991 defendant Balden Thomas yeoman 615836 615836 Balden, Thomas, of Offenham, yeoman 0
4292435 2127361 2127361 defendant Slye John yeoman 615836 615836 Slye, John, of Offenham, yeoman 0
4292436 2127361 2127361 defendant Pygyn Richard yeoman 615836 615836 Pygyn, Richard, of Offenham, yeoman 1
4292438 2127361 2127361 defendant Seaton Thomas gent 615836 615836 Seaton, Thomas, of Offenham, gent 3
4309956 2133641 2133641 defendant Balden Thomas yeoman 615836 615836 Balden, Thomas, of Offenham, yeoman 0
4326308 2139164 2139164 defendant Hughes alias Page John husbandman 615836 615836 Hughes alias Page, John, of Offenham, husbandman 0
4326586 2139252 2139252 defendant Hawkyns George gent 615836 615836 Hawkyns, George, of Offenham, gent 0
4326587 2139252 2139252 defendant Buggen William yeoman 615836 615836 Buggen, William, of Offenham, yeoman 1
4330234 2140415 2140415 defendant Hawkyns George gent 615836 615836 Hawkyns, George, of Offenham, gent 0
5596799 2533918 2533918 defendant Bull Thomas husbandman 615836 615836 Bull, Thomas, of Offenham, husbandman 1
5596800 2533918 2533918 defendant Best Thomas husbandman 615836 615836 Best, Thomas, of Offenham, husbandman 2

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