names

78 rows where place_id = 588554

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594914 1866037 1866037 defendant Aleyn Henry yeoman 588554 588554 Aleyn, Henry, of Shipton, yeoman 2
3594915 1866037 1866037 defendant Smyth Henry yeoman 588554 588554 Smyth, Henry, of Shipton, yeoman 3
3644695 1908749 1908749 defendant Arnold Robert husbandman 588554 588554 Arnold, Robert, of Shipton, husbandman 0
3652888 1911229 1911229 defendant Chamberleyn Richard yeoman 588554 588554 Chamberleyn, Richard, of Shipton under Wychewode, yeoman 1
3686483 1921924 1921924 defendant Mays Thomas husbandman 588554 588554 Mays, Thomas, of Shipton, husbandman 0
3686484 1921924 1921924 defendant Dunstable William husbandman 588554 588554 Dunstable, William, of Shipton, husbandman 1
3686485 1921924 1921924 defendant Tonesend John husbandman 588554 588554 Tonesend, John, of Shipton, husbandman 2
3686486 1921924 1921924 defendant Tonesend William husbandman 588554 588554 Tonesend, William, of Shipton, husbandman 3
3686487 1921924 1921924 defendant Perot William husbandman 588554 588554 Perot, William, of Shipton, husbandman 4
3686488 1921924 1921924 defendant Michell Richard husbandman 588554 588554 Michell, Richard, of Shipton, husbandman 5
3686489 1921924 1921924 defendant Pheppys John husbandman 588554 588554 Pheppys, John, of Shipton, husbandman 6
3718020 1931931 1931931 defendant Bayley Henry laborer 588554 588554 Bayley, Henry, of Shipton Berynger, laborer 0
3718021 1931931 1931931 defendant More John laborer 588554 588554 More, John, of Shipton Berynger, laborer 1
3718022 1931931 1931931 defendant Dyrok William laborer 588554 588554 Dyrok, William, of Shipton Berynger, laborer 2
3718023 1931931 1931931 defendant Cully John laborer 588554 588554 Cully, John, of Shipton Berynger, laborer 3
3731615 1936116 1936116 plaintiff Chapman John (legal representative) 588554 588554 Chapman, John, of Shipton, yeoman, executors of 0
3739596 1938598 1938598 defendant Spencer Roger yeoman 588554 588554 Spencer, Roger, of Shipton, yeoman 0
3784017 1952780 1952780 defendant Teryngton Thomas husbandman 588554 588554 Teryngton, Thomas, of Shipton, husbandman 0
3784122 1952817 1952817 defendant Spenser Roger yeoman 588554 588554 Spenser, Roger, of Shipton, yeoman 0
3826738 1966213 1966213 defendant Shipton James gent 588554 588554 Shipton, James, of Shipton, gent 0
3955761 2009089 2009089 defendant Paramor William yeoman 588554 588554 Paramor, William, of Shipton, yeoman 0
3955762 2009089 2009089 defendant Castell William husbandman 588554 588554 Castell, William, of Shipton, husbandman 1
4006068 2026940 2026940 plaintiff Laurens Robert   588554 588554 Laurens, Robert, of Shipton 0
4097130 2059295 2059295 defendant Coke Thomas husbandman 588554 588554 Coke, Thomas, of Shipton, husbandman 1
4103059 2061384 2061384 defendant Jurden Joan widow 588554 588554 Jurden, Joan, of Shipton, widow 0
4116589 2066223 2066223 defendant Smyth Richard gent 588554 588554 Smyth, Richard, of Shipton, gent 0
4128598 2070519 2070519 defendant Spensor Richard husbandman 588554 588554 Spensor, Richard, of Shipton, husbandman 1
4151369 2078601 2078601 defendant Churchman John clerk 588554 588554 Churchman, John, of Shipton, clerk 0
4156518 2080355 2080355 defendant Jurden William husbandman 588554 588554 Jurden, William, of Shipton, husbandman 0
4156519 2080355 2080355 defendant Muslow Edward husbandman 588554 588554 Muslow, Edward, of Shipton, husbandman 1
4157232 2080597 2080597 defendant Peramore Edward husbandman 588554 588554 Peramore, Edward, of Shipton, husbandman 0
4230494 2106162 2106162 defendant Graye Walter gent 588554 588554 Graye, Walter, of Shipton, gent 0
4290135 2126540 2126540 defendant Clarke Nicholas husbandman 588554 588554 Clarke, Nicholas, of Shipton, husbandman 0
4290136 2126540 2126540 defendant Wood Richard husbandman 588554 588554 Wood, Richard, of Shipton, husbandman 1
4298738 2129649 2129649 defendant Clarke Nicholas husbandman 588554 588554 Clarke, Nicholas, of Shipton, husbandman 0
4298739 2129649 2129649 defendant Wood Richard husbandman 588554 588554 Wood, Richard, of Shipton, husbandman 1
4386692 2160226 2160226 defendant Allanson Christopher   588554 588554 Allanson, Christopher, of Shipton, woollen weaver 1
4413717 2169184 2169184 defendant Humbre John   588554 588554 Humbre, John, of Shipton 0
4482523 2195236 2195236 plaintiff Millyngton John de   588554 588554 Millyngton, John de, of Shipton, on his own account 0
4506488 2202526 2202526 defendant Cartwryght Robert   588554 588554 Cartwryght, Robert, of Shipton 0
4527601 2208910 2208910 defendant Walker John   588554 588554 Walker, John, of Shipton 5
4547658 2215208 2215208 defendant Osteler Thomas   588554 588554 Osteler, Thomas, of Shipton 2
4561782 2219619 2219619 plaintiff Perkyn John   588554 588554 Perkyn, John, of Shipton 0
4564887 2220581 2220581 defendant Short William   588554 588554 Short, William, of Shipton 0
4575979 2223982 2223982 defendant Mundy Nicholas   588554 588554 Mundy, Nicholas, of Shipton Belgier 0
4575980 2223982 2223982 defendant Cole Richard   588554 588554 Cole, Richard, of Shipton Belgier 1
4611759 2234741 2234741 defendant Cole John, sen   588554 588554 Cole, John, sen, of Shipton 0
4659572 2248845 2248845 defendant Shipton John forester 588554 588554 Shipton, John, of Shipton, forester 0
4667940 2255675 2255675 defendant Ponteys Robert ploughman 588554 588554 Ponteys, Robert, of Shipton, ploughman 0
4667942 2255676 2255676 defendant Ponteys Robert ploughman 588554 588554 Ponteys, Robert, of Shipton, ploughman 0
4673014 2257204 2257204 defendant Wydeforde Thomas   588554 588554 Wydeforde, Thomas, of Shipton shepherd 0
4691633 2262916 2262916 defendant Bolour Richard husbandman 588554 588554 Bolour, Richard, of Shipton, husbandman 0
4715174 2270074 2270074 defendant Perkyn William husbandman 588554 588554 Perkyn, William, of Shipton, husbandman 0
4727953 2273987 2273987 plaintiff Hopton Richard   588554 588554 Hopton, Richard, of Shipton 0
4765334 2285141 2285141 defendant Petyte William yeoman 588554 588554 Petyte, William, of Shipton, yeoman 3
4798243 2295644 2295644 defendant Petyte William yeoman 588554 588554 Petyte, William, of Shipton, yeoman 3
4811951 2299850 2299850 defendant Whyther John butcher 588554 588554 Whyther, John, of Shipton, butcher 1
4821833 2302903 2302903 defendant Gilmyn Thomas husbandman 588554 588554 Gilmyn, Thomas, of Shipton, husbandman 1
4933757 2336936 2336936 defendant Tomlyns William husbandman 588554 588554 Tomlyns, William, of Shipton, husbandman 0
4966745 2346988 2346988 plaintiff Dubber John Berynger 588554 588554 Dubber, John, of Shipton, Berynger 0
4966746 2346988 2346988 plaintiff Monsprot Richard   588554 588554 Monsprot, Richard, of Shipton Berynger 1
5028957 2365338 2365338 defendant Dubbere John   588554 588554 Dubbere, John, of Shipton, husbandman, executotrs of 1
5028961 2365339 2365339 defendant Dubbere John (legal representative) 588554 588554 Dubbere, John, of Shipton, husbandman, son of Dubbere, Thomas, executors of 1
5028962 2365339 2365339 defendant Clyveden Richard gent 588554 588554 (Clyveden, Richard, of Shipton, gent 2
5052243 2372275 2372275 defendant Tetnale Roger carpenter 588554 588554 Tetnale, Roger, of Shipton, carpenter 0
5071278 2377906 2377906 defendant Tetnale Roger carpenter 588554 588554 Tetnale, Roger, of Shipton, carpenter 0
5089916 2383430 2383430 defendant Muspret Robert husbandman 588554 588554 Muspret, Robert, of Shipton, husbandman 0
5108014 2388782 2388782 defendant Burman Robert husbandman 588554 588554 Burman, Robert, of Shipton, husbandman 1
5108016 2388783 2388783 defendant Aleyns William fisher 588554 588554 Aleyns, William, of Shipton, or of Crowmere, Norf, fisher 0
5135148 2396779 2396779 defendant Fraunceys John clerk 588554 588554 Fraunceys, John, of Shipton under Wychewode, clerk 0
5207096 2417815 2417815 defendant Fraunceys John clerk 588554 588554 Fraunceys, John, of Shipton under Wychewode, clerk 0
5255401 2431806 2431806 defendant Sclatter Thomas yeoman 588554 588554 Sclatter, Thomas, of Shipton under Wychewode, yeoman 0
5354103 2461349 2461349 defendant Sessons Thomas yeoman 588554 588554 Sessons, Thomas, of Shipton under Whichewode, yeoman 1
5441108 2487252 2487252 defendant Estcourt John gent 588554 588554 Estcourt, John, of Shipton, gent 0
5485958 2500690 2500690 defendant Chyken Richard clerk 588554 588554 Chyken, Richard, of Shipton Berynger, clerk 4
5485959 2500690 2500690 defendant Cole Roger husbandman 588554 588554 Cole, Roger, of Shipton Berynger, husbandman 5
5559577 2522762 2522762 defendant Fabian Hugh husbandman 588554 588554 Fabian, Hugh, of Shipton Benger, husbandman 2
5559674 2522790 2522790 defendant Lynton John husbandman 588554 588554 Lynton, John, of Shipton Berynger, 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);