names

36 rows where place_id = 588688

✎ 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
3595290 1866159 1866159 defendant Hunt William husbandman 588688 588688 Hunt, William, of Darley, husbandman 0
3596059 1866395 1866395 defendant Peycoke William yeoman 588688 588688 Peycoke, William, of Darley, yeoman 1
3673588 1917768 1917768 defendant Wade Richard brewer 588688 588688 Wade, Richard, of Darley, brewer 0
3756683 1944066 1944066 defendant Bagshawe Henry yeoman 588688 588688 Bagshawe, Henry, of Darley, yeoman 11
3861391 1977279 1977279 defendant Whetecroft James husbandman 588688 588688 Whetecroft, James, of Darley, husbandman 0
4277097 2121921 2121921 defendant Bradwall Thomas husbandman 588688 588688 Bradwall, Thomas, of Darley, husbandman 0
4286530 2125222 2125222 defendant Bradwell Thomas husbandman 588688 588688 Bradwell, Thomas, of Darley, husbandman 0
4407138 2166950 2166950 defendant Pydcocke William yeoman 588688 588688 Pydcocke, William, of Darley, yeoman 3
4604530 2232583 2232583 defendant Garlond William   588688 588688 Garlond, William, of Darley 2
4657859 2248345 2248345 defendant Gamull John husbandman 588688 588688 Gamull, John, of Darley, husbandman 0
4657861 2248346 2248346 defendant Johnson Aleynson Roger husbandman 588688 588688 Johnson Aleynson, Roger, of Darley, husbandman 0
4657863 2248346 2248346 defendant Loncok Robert   588688 588688 Loncok, Robert, of Darley, wright 2
4657864 2248346 2248346 defendant Rodier John husbandman 588688 588688 Rodier, John, of Darley, husbandman 3
4657865 2248346 2248346 defendant Godsalve John husbandman 588688 588688 Godsalve, John, of Darley, husbandman 4
4724130 2272842 2272842 plaintiff Elkok Robert   588688 588688 Elkok, Robert, of Darley 0
4821120 2302684 2302684 defendant More Nicholas de husbandman 588688 588688 More, Nicholas de, of Darley, husbandman 0
4821679 2302855 2302855 defendant Aleyn Richard husbandman 588688 588688 Aleyn, Richard, of Darley, husbandman 2
4821680 2302855 2302855 defendant Aleyn John husbandman 588688 588688 Aleyn, John, of Darley, husbandman 3
5129613 2395151 2395151 plaintiff de Killingsworth Henry   588688 588688 de Killingsworth, Henry, of Darley, abbot 0
5291413 2442490 2442490 defendant Columbell Henry gent 588688 588688 Columbell, Henry, of Darley, gent 0
5316241 2449944 2449944 defendant Pole Henry gent 588688 588688 Pole, Henry, of Darley, gent 0
5333532 2455102 2455102 defendant Pole Henry gent 588688 588688 Pole, Henry, of Darley, gent 0
5368539 2465768 2465768 defendant Metcalf William yeoman 588688 588688 Metcalf, William, of Darley, yeoman 18
5368540 2465768 2465768 defendant Shepard William yeoman 588688 588688 Shepard, William, of Darley, yeoman 19
5368543 2465768 2465768 defendant Shepard Henry yeoman 588688 588688 Shepard, Henry, of Darley, yeoman 22
5368544 2465768 2465768 defendant Ollerhed Robert yeoman 588688 588688 Ollerhed, Robert, of Darley, yeoman 23
5368569 2465769 2465769 defendant Metcalf William yeoman 588688 588688 Metcalf, William, of Darley, yeoman 18
5368570 2465769 2465769 defendant Shepard William yeoman 588688 588688 Shepard, William, of Darley, yeoman 19
5368573 2465769 2465769 defendant Shepard Henry yeoman 588688 588688 Shepard, Henry, of Darley, yeoman 22
5368574 2465769 2465769 defendant Ollerhed Robert yeoman 588688 588688 Ollerhed, Robert, of Darley, yeoman 23
5395454 2473776 2473776 plaintiff Ashby John   588688 588688 Ashby, John, of Darley, abbot of the Monastery of th BM 0
5431567 2484394 2484394 defendant Bastwysell Robert husbandman 588688 588688 Bastwysell, Robert, of Darley, husbandman 4
5447958 2489271 2489271 defendant Bastwysell Robert husbandman 588688 588688 Bastwysell, Robert, of Darley, husbandman 4
5460353 2493034 2493034 defendant Bastwysell Robert husbandman 588688 588688 Bastwysell, Robert, of Darley, husbandman 4
5460388 2493048 2493048 defendant Bastwysell Robert husbandman 588688 588688 Bastwysell, Robert, of Darley, husbandman 4
5492405 2502644 2502644 defendant Columbell Henry gent 588688 588688 Columbell, Henry, of Darley, gent 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);