names

40 rows where place_id = 622940

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749801 1941848 1941848 defendant Jaggar William yeoman 622940 622940 Jaggar, William, of Horbury, yeoman 1
3751348 1942341 1942341 defendant Langfeld Thomas yeoman 622940 622940 Langfeld, Thomas, of Horbury, yeoman 1
3805471 1959649 1959649 defendant Gaster John husbandman 622940 622940 Gaster, John, of Horbury, husbandman 4
3834032 1968584 1968584 defendant Bolles Robert yeoman 622940 622940 Bolles, Robert, of Horbury, yeoman 2
3973925 2015450 2015450 defendant Jagger Robert clothier 622940 622940 Jagger, Robert, of Horbury, clothier 0
3989939 2021158 2021158 plaintiff Beamount Peter   622940 622940 Beamount, Peter, of Horbury 0
4094551 2058387 2058387 defendant Jagger William, junior laborer 622940 622940 Jagger, William, junior, of Horbury, laborer 2
4097983 2059608 2059608 plaintiff Baynes Roger yeoman 622940 622940 Baynes, Roger, of Horbury, yeoman 1
4309641 2133530 2133530 defendant Lee Peter yeoman 622940 622940 Lee, Peter, of Horbury, yeoman 1
4727968 2273993 2273993 defendant Baker John laborer 622940 622940 Baker, John, of Horbury, laborer 0
4890513 2323795 2323795 defendant Darcy Margaret   622940 622940 Darcy, Margaret, of Horbury, widow of Darcy, Richard 1
4892581 2324406 2324406 defendant Halyfax John husbandman 622940 622940 Halyfax, John, of Horbury, husbandman 1
5060701 2374780 2374780 defendant Gybson Ellen widow 622940 622940 Gybson, Ellen, of Horbury, widow 0
5060702 2374780 2374780 defendant Gybson John laborer 622940 622940 Gybson, John, of Horbury, laborer 1
5060703 2374780 2374780 defendant Dyche Robert tailor 622940 622940 Dyche, Robert, of Horbury, tailor 2
5060704 2374780 2374780 defendant Gryffyn John nailer 622940 622940 Gryffyn, John, of Horbury, nailer 3
5216477 2420550 2420550 defendant Richardson John nailer 622940 622940 Richardson, John, of Horbury, nailer 1
5281522 2439661 2439661 defendant Amyas Ralph gent 622940 622940 Amyas, Ralph, of Horbury, gent 0
5281524 2439662 2439662 defendant Amyas Ralph gent 622940 622940 Amyas, Ralph, of Horbury, gent 0
5319847 2451027 2451027 defendant Pelle John husbandman 622940 622940 Pelle, John, of Horbury, husbandman 6
5319848 2451027 2451027 defendant Swaynson William husbandman 622940 622940 Swaynson, William, of Horbury, husbandman 7
5319849 2451027 2451027 defendant Whitehed Richard husbandman 622940 622940 Whitehed, Richard, of Horbury, husbandman 8
5319850 2451027 2451027 defendant Goodale Robert   622940 622940 Goodale, Robert, of Horbury, parish clerk 9
5319851 2451027 2451027 defendant Metheley John husbandman 622940 622940 Metheley, John, of Horbury, husbandman 10
5319861 2451028 2451028 defendant Pelle John husbandman 622940 622940 Pelle, John, of Horbury, husbandman 8
5319862 2451028 2451028 defendant Swaynson William husbandman 622940 622940 Swaynson, William, of Horbury, husbandman 9
5319863 2451028 2451028 defendant Whithed Richard husbandman 622940 622940 Whithed, Richard, of Horbury, husbandman 10
5319864 2451028 2451028 defendant Goodale Robert   622940 622940 Goodale, Robert, of Horbury, parish clerk 11
5319865 2451028 2451028 defendant Metheley John husbandman 622940 622940 Metheley, John, of Horbury, husbandman 12
5431974 2484532 2484532 defendant Kynsley John yeoman 622940 622940 Kynsley, John, of Horbury, yeoman 3
5443221 2487888 2487888 defendant Kynneslay John yeoman 622940 622940 Kynneslay, John, of Horbury, yeoman 2
5448201 2489355 2489355 defendant Kynsley John yeoman 622940 622940 Kynsley, John, of Horbury, yeoman 3
5448207 2489356 2489356 defendant Kynsley John yeoman 622940 622940 Kynsley, John, of Horbury, yeoman 3
5455942 2491686 2491686 defendant Kynnesley John yeoman 622940 622940 Kynnesley, John, of Horbury, yeoman 1
5467790 2495304 2495304 defendant Kynnerslay John yeoman 622940 622940 Kynnerslay, John, of Horbury, yeoman 1
5467793 2495305 2495305 defendant Kynnersley John yeoman 622940 622940 Kynnersley, John, of Horbury, yeoman 1
5540652 2517205 2517205 defendant Pel- Robert yeoman 622940 622940 Pel-, Robert, of Horbury, yeoman 0
5604869 2536391 2536391 defendant Rous Peter yeoman 622940 622940 Rous, Peter, of Horbury, yeoman 0
5604871 2536392 2536392 defendant Rous Peter yeoman 622940 622940 Rous, Peter, of Horbury, yeoman 0
5624673 2551654 2551654 defendant Metheley William husbandman 622940 622940 Metheley, William, of Horbury, husbandman 1

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