names

16 rows where place_id = 601201

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644305 1908642 1908642 defendant Tyler Thomas husbandman 601201 601201 Tyler, Thomas, of Trymley, husbandman 14
3649894 1910331 1910331 defendant Bryan John mariner 601201 601201 Bryan, John, of Trymley, mariner 0
3842819 1971287 1971287 defendant Butte John tailor 601201 601201 Butte, John, of Trymley, tailor 2
3913772 1994951 1994951 defendant Batell Robert husbnadman 601201 601201 Batell, Robert, of Trymley, husbnadman 0
3927793 1999634 1999634 defendant Bore John husbandman 601201 601201 Bore, John, of Trymley, husbandman 0
3949283 2006818 2006818 defendant Caundyshe William esq 601201 601201 Caundyshe, William, of Trymley, esq 0
4084233 2054635 2054635 defendant Galiard Edmund yeoman 601201 601201 Galiard, Edmund, of Trymley, yeoman 0
4198295 2094953 2094953 defendant Wrighte Robert yeoman 601201 601201 Wrighte, Robert, of Trymley, yeoman 0
4199973 2095540 2095540 defendant Alleyn Jerome yeoman 601201 601201 Alleyn, Jerome, of Trymley, yeoman 1
4307895 2132902 2132902 defendant Cowper George yeoman 601201 601201 Cowper, George, of Trymley, yeoman 1
4621270 2237640 2237640 plaintiff Hungarton William   601201 601201 (Hungarton, William, of Trymley, parson 1
5543066 2517950 2517950 defendant Caundyssh Richard gent 601201 601201 Caundyssh, Richard, of Trymley, gent 0
5572943 2526637 2526637 defendant Caundysshe Richard esq 601201 601201 Caundysshe, Richard, of Trymley, esq 0
5572944 2526637 2526637 defendant Bryghteve Robert gent 601201 601201 Bryghteve, Robert, of Trymley, gent 1
5599734 2534805 2534805 defendant Bryan Roger husbandman 601201 601201 Bryan, Roger, of Trymley, husbandman 2
5599735 2534805 2534805 defendant Sperman Adam husbandman 601201 601201 Sperman, Adam, of Trymley, 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);