names

22 rows where place_id = 655229

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3935461 2002170 2002170 defendant Hall Richard gent 655229 655229 Hall, Richard, of Westmorland, gent 10
3944534 2005189 2005189 plaintiff Bateman Arthur clothier 655229 655229 Bateman, Arthur, of Westmorland, clothier 0
3978530 2017068 2017068 defendant Ingram James   655229 655229 Ingram, James, of Westmorland, clerk, doctor of physic 0
4459821 2188124 2188124 defendant Strikland John de   655229 655229 Strikland, John de, of Westmorland 1
4497486 2199859 2199859 plaintiff Doweson John   655229 655229 Doweson, John, of Westmorland 0
4507464 2202798 2202798 defendant Kirkeby Thomas   655229 655229 Kirkeby, Thomas, of Westmorland 3
4513182 2204546 2204546 defendant Langton William   655229 655229 Langton, William, of Westmorland 0
4518764 2206243 2206243 plaintiff Doweson John   655229 655229 Doweson, John, of Westmorland 0
4561181 2219458 2219458 defendant Gifford William   655229 655229 Gifford, William, of Westmorland, knight 0
4565774 2220851 2220851 plaintiff Sourby John de   655229 655229 Sourby, John de, of Westmorland 0
4569465 2222037 2222037 defendant Kirkeby Thomas   655229 655229 Kirkeby, Thomas, of Westmorland 4
4569469 2222038 2222038 defendant Kirkeby Thomas   655229 655229 Kirkeby, Thomas, of Westmorland 1
4660017 2248980 2248980 defendant de Bland Richard yeoman 655229 655229 de Bland, Richard, of Westmorland, yeoman 0
4697256 2264624 2264624 plaintiff Clifford John   655229 655229 Clifford, John, of Westmorland 0
4716875 2270605 2270605 plaintiff Wyghtman John clerk 655229 655229 Wyghtman, John, of Westmorland, clerk 0
4722247 2272279 2272279 plaintiff Clyfford John   655229 655229 Clyfford, John, of Westmorland, knight 0
4739918 2277564 2277564 plaintiff Appelby John   655229 655229 Appelby, John, of Westmorland, on his own account 0
5043580 2369700 2369700 defendant Crakenthorp Robert (legal representative) 655229 655229 Crakenthorp, Robert, of Westmorland, gent, executors of 1
5125916 2394066 2394066 defendant Redmayn Richard   655229 655229 Redmayn, Richard, of Westmorland, abbot of the Monastery of --- Magdalene, of Heppa, premonstratensien order 0
5125920 2394067 2394067 defendant Redmayn Richard   655229 655229 Redmayn, Richard, of Westmorland, abbot of the Monastery of --- Magdalene, of Heppa, premonstratensien order 0
5315109 2449575 2449575 defendant Whitnay or Witney William esq 655229 655229 Whitnay or Witney, William, of Westmorland, esq 0
5535953 2515747 2515747 defendant Chambyr John gent 655229 655229 Chambyr, John, of Westmorland, gent 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);