names

16 rows where place_id = 784672

✎ 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
4688371 2261929 2261929 defendant Wyet John husbandman 784672 784672 Wyet, John, of felgham, husbandman 0
4693330 2263417 2263417 plaintiff Baron John   784672 784672 Baron, John, of Felgham 0
4693332 2263418 2263418 plaintiff Baron John   784672 784672 Baron, John, of Felgham 0
4708900 2268150 2268150 defendant Kytte Thomas clerk 784672 784672 Kytte, Thomas, of Felgham, clerk 1
4714215 2269775 2269775 defendant Morell Henry husbandman 784672 784672 Morell, Henry, of Felgham, husbandman 0
4753677 2281523 2281523 defendant Peryng John shipman 784672 784672 Peryng, John, of Felgham, shipman 0
4777833 2289057 2289057 defendant Boys John husbandman 784672 784672 Boys, John, of Felgham, husbandman 0
4839045 2308140 2308140 defendant Clerk Robert seaman 784672 784672 Clerk, Robert, of Felgham, seaman 0
4840572 2308592 2308592 defendant Peryng John shipman 784672 784672 Peryng, John, of Felgham, shipman 0
4941653 2339410 2339410 defendant Goffe or Gosse William butcher 784672 784672 Goffe or Gosse, William, of Felgham, butcher 2
4958803 2344605 2344605 defendant Goffe William butcher 784672 784672 Goffe, William, of Felgham, butcher 2
4967461 2347210 2347210 defendant Gosse William butcher 784672 784672 Gosse, William, of Felgham, butcher 2
4975559 2349646 2349646 defendant tte Stokke William husbandman 784672 784672 tte Stokke, William, of Felgham, husbandman 0
4975560 2349646 2349646 defendant Derby John husbandman 784672 784672 Derby, John, of Felgham, husbandman 1
5189921 2412794 2412794 plaintiff Lende Richard   784672 784672 Lende, Richard, of Felgham 0
5189922 2412794 2412794 defendant Mylle William husbandman 784672 784672 Mylle, William, of Felgham, husbandman 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);