names

23 rows where place_id = 600494

✎ 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
3641239 1907712 1907712 defendant Wilcok Thomas husbandman 600494 600494 Wilcok, Thomas, of Barnburgh, husbandman 2
3701490 1926712 1926712 defendant Bereford Edward gent 600494 600494 Bereford, Edward, of Barnburgh, gent 0
4030738 2035656 2035656 defendant Kendall John gent 600494 600494 Kendall, John, of Barnburgh, gent 0
4717311 2270747 2270747 defendant Keworth John   600494 600494 Keworth, John, of Barnburgh, parson & clerk 0
4818823 2301970 2301970 defendant Hatscale John yeoman 600494 600494 Hatscale, John, of Barnburgh by Doncaster, yeoman 4
4838794 2308062 2308062 defendant Spenser Roger   600494 600494 Spenser, Roger, of Barnburgh, parson 2
4838795 2308062 2308062 defendant Spenser Thomas yeoman 600494 600494 Spenser, Thomas, of Barnburgh, yeoman 3
4865988 2316333 2316333 defendant Spenser Thomas yeoman 600494 600494 Spenser, Thomas, of Barnburgh, yeoman 2
4954358 2343271 2343271 defendant Hothcoll John husbandman 600494 600494 Hothcoll, John, of Barnburgh, husbandman 1
4954359 2343271 2343271 defendant Trewelufe Thomas husbandman 600494 600494 Trewelufe, Thomas, of Barnburgh, husbandman 2
4954360 2343271 2343271 defendant Mauger William husbandman 600494 600494 Mauger, William, of Barnburgh, husbandman 3
4965470 2346590 2346590 defendant Hotecole John husbandman 600494 600494 Hotecole, John, of Barnburgh, husbandman 0
4965478 2346591 2346591 defendant Hotecole John husbandman 600494 600494 Hotecole, John, of Barnburgh, husbandman 3
4965483 2346592 2346592 defendant Hotecole John husbandman 600494 600494 together with Hotecole, John, of Barnburgh, husbandman 3
5012569 2360517 2360517 defendant Spencer William yeoman 600494 600494 Spencer, William, of Barnburgh, yeoman 0
5012570 2360517 2360517 defendant Spencer Roger   600494 600494 Spencer, Roger, of Barnburgh, parson 1
5060336 2374665 2374665 defendant Knoll Thomas husbandman 600494 600494 Knoll, Thomas, of Barnburgh, husbandman 0
5060338 2374666 2374666 defendant Knoll Thomas husbandman 600494 600494 Knoll, Thomas, of Barnburgh, husbandman 0
5061468 2375021 2375021 plaintiff Gresaker Percival esq 600494 600494 Gresaker, Percival, of Barnburgh, esq 0
5319254 2450852 2450852 defendant Gresacre Percival esq 600494 600494 Gresacre, Percival, of Barnburgh, esq 0
5348355 2459628 2459628 defendant Hough Robert husbandman 600494 600494 Hough, Robert, of Barnburgh, husbandman 1
5353772 2461246 2461246 plaintiff Gresacre Percival (legal representative) 600494 600494 Gresacre, Percival, of Barnburgh, esq, executors of 0
5602527 2535684 2535684 plaintiff Milns Richard chaplain 600494 600494 Milns, Richard, of Barnburgh, chaplain 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);