names

28 rows where place_id = 589681

✎ 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
3598405 1867130 1867130 defendant Swan William husbandman 589681 589681 Swan, William, of Haughle, husbandman 2
3836350 1969276 1969276 defendant Nune James clothmaker 589681 589681 Nune, James, of Haughle, clothmaker 0
4737395 2276812 2276812 defendant Manaunt Peter husbandman 589681 589681 Manaunt, Peter, of Haughle, husbandman 1
4792563 2293765 2293765 plaintiff Wolleman Edmund   589681 589681 Wolleman, Edmund, of Haughle 1
4815333 2300903 2300903 defendant Wolleman Edmund yeoman 589681 589681 Wolleman, Edmund, of Haughle, yeoman 0
4815334 2300903 2300903 defendant Howard William yeoman 589681 589681 Howard, William, of Haughle, yeoman 1
4919793 2332696 2332696 defendant Wolleman Edmund baker 589681 589681 Wolleman, Edmund, of Haughle, baker 0
4926091 2334588 2334588 defendant Spaggy John yeoman 589681 589681 Spaggy, John, of Haughle, yeoman 1
4984641 2352337 2352337 defendant Ronde John yeoman 589681 589681 Ronde, John, of Haughle, yeoman 0
5003094 2357809 2357809 defendant Maraunt peter yeoman 589681 589681 Maraunt, peter, of Haughle, yeoman 0
5003095 2357809 2357809 defendant Bacon John husbandman 589681 589681 Bacon, John, of Haughle, husbandman 1
5022703 2363550 2363550 defendant Whitopp William yeoman 589681 589681 Whitopp, William, of Haughle, yeoman 0
5055714 2373278 2373278 defendant Punder William husbandman 589681 589681 Punder, William, of Haughle, husbandman 1
5072537 2378272 2378272 defendant Denys John husbandman 589681 589681 Denys, John, of Haughle, husbandman 0
5088998 2383160 2383160 defendant Rout John butcher 589681 589681 Rout, John, of Haughle, butcher 3
5098054 2385864 2385864 plaintiff Turner William   589681 589681 Turner, William, of Haughle 0
5126033 2394099 2394099 defendant Swan William yeoman 589681 589681 Swan, William, of Haughle, yeoman 0
5144666 2399596 2399596 defendant Swan William yeoman 589681 589681 Swan, William, of Haughle, yeoman 0
5271325 2436707 2436707 defendant Turnour William smith 589681 589681 Turnour, William, of Haughle, smith 2
5271326 2436707 2436707 defendant Purche Thomas smith 589681 589681 Purche, Thomas, of Haughle, smith 3
5345363 2458724 2458724 defendant Seler Geoffrey fuller 589681 589681 Seler, Geoffrey, of Haughle, fuller 1
5368830 2465840 2465840 defendant Bette John barber 589681 589681 Bette, John, of Haughle, barber 0
5368831 2465840 2465840 defendant Wederby John butcher 589681 589681 Wederby, John, of Haughle, butcher 1
5368832 2465840 2465840 defendant Haunteyn John husbandman 589681 589681 Haunteyn, John, of Haughle, husbandman 2
5368833 2465840 2465840 defendant Shepey Thomas carpenter 589681 589681 Shepey, Thomas, of Haughle, carpenter 3
5368834 2465840 2465840 defendant Thynge Simon husbandman 589681 589681 Thynge, Simon, of Haughle, husbandman 4
5368835 2465840 2465840 defendant Thynge Thomas laborer 589681 589681 Thynge, Thomas, of Haughle, laborer 5
5465104 2494468 2494468 plaintiff Wage John   589681 589681 Wage, John, of Haughle, son of John 0

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