names

21 rows where place_id = 587416

✎ 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
3591342 1864919 1864919 defendant Reve Katherine widow 587416 587416 (Reve, Katherine, of Hyndercle, widow 1
3591343 1864919 1864919 defendant Baseley John husbandman 587416 587416 Baseley, John, of Hyndercle, husbandman 2
3712911 1930359 1930359 defendant Peny John husbandman 587416 587416 Peny, John, of Hyndercle, husbandman 0
3781328 1951903 1951903 defendant Loke Nicholas porter 587416 587416 Loke, Nicholas, of Hyndercle, porter 0
3811751 1961574 1961574 defendant Waren Robert thatcher 587416 587416 Waren, Robert, of Hyndercle, thatcher 0
3815498 1962762 1962762 defendant Cleydon Lawrence clerk 587416 587416 Cleydon, Lawrence, of Hyndercle, clerk 0
4442637 2182647 2182647 defendant Clerke Robert   587416 587416 Clerke, Robert, of Hyndercle 0
4452848 2185904 2185904 plaintiff Kyng Robert   587416 587416 Kyng, Robert, of Hyndercle 0
4452855 2185905 2185905 plaintiff Kyng Robert   587416 587416 Kyng, Robert, of Hyndercle 0
4774248 2287928 2287928 plaintiff Tybbe B_   587416 587416 Tybbe, B_, of Hyndercle 0
4799612 2296060 2296060 plaintiff Tubbe William   587416 587416 Tubbe, William, of Hyndercle 0
4799614 2296061 2296061 plaintiff Tubbe William   587416 587416 Tubbe, William, of Hyndercle 0
4862717 2315323 2315323 defendant Tubby William yeoman 587416 587416 Tubby, William, of Hyndercle, yeoman 4
5049228 2371403 2371403 defendant Clerke John carpenter 587416 587416 Clerke, John, of Hyndercle, carpenter 0
5184035 2411064 2411064 defendant Underwode Hugh clerk 587416 587416 Underwode, Hugh, of Hyndercle, clerk 0
5204108 2416954 2416954 defendant Underwode Hugh clerk 587416 587416 Underwode, Hugh, of Hyndercle, clerk 0
5216719 2420624 2420624 defendant Underwode Hugh clerk 587416 587416 Underwode, Hugh, of Hyndercle, clerk 0
5271330 2436708 2436708 defendant Underwode Hugh clerk 587416 587416 Underwode, Hugh, of Hyndercle, clerk 1
5508280 2507473 2507473 defendant Loonde William yeoman 587416 587416 Loonde, William, of Hyndercle, yeoman 1
5520796 2511325 2511325 defendant Story Thomas husbandman 587416 587416 Story, Thomas, of Hyndercle, husbandman 1
5520799 2511325 2511325 defendant Vyer or Byer Thomas clerk 587416 587416 Vyer or Byer, Thomas, of Hyndercle, clerk 4

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