names

37 rows where place_id = 595691

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621483 1874258 1874258 defendant Kayton Thomas gent 595691 595691 Kayton, Thomas, of Clyvedon, gent 0
3621485 1874259 1874259 defendant Keyton Thomas gent 595691 595691 Keyton, Thomas, of Clyvedon, gent 0
4084048 2054570 2054570 defendant Bulbeck John esq 595691 595691 Bulbeck, John, of Clyvedon, esq 0
4096094 2058930 2058930 defendant Cotterell Thomas husbandman 595691 595691 Cotterell, Thomas, of Clyvedon, husbandman 2
4285878 2125001 2125001 defendant Pryce Philip husbandman 595691 595691 Pryce, Philip, of Clyvedon, or of Weston, husbandman 0
4309274 2133396 2133396 defendant Haule or Hanle Roger clerk 595691 595691 Haule or Hanle, Roger, of Clyvedon, clerk 0
4375315 2156226 2156226 defendant Maskall Edmund husbandman 595691 595691 Maskall, Edmund, of Clyvedon, husbandman 0
4461250 2188602 2188602 defendant Webbe John   595691 595691 Webbe, John, of Clyvedon 6
4470326 2191367 2191367 defendant Wytwell William   595691 595691 Wytwell, William, of Clyvedon, vicar 1
4813466 2300324 2300324 defendant Colyns John, junior husbandman 595691 595691 Colyns, John, junior, of Clyvedon, husbandman 0
4813467 2300324 2300324 defendant Doune Walter husbandman 595691 595691 Doune, Walter, of Clyvedon, husbandman 1
4826944 2304465 2304465 defendant Hill Richard husbandman 595691 595691 Hill, Richard, of Clyvedon, husbandman 0
4943808 2340028 2340028 defendant Hurne Richard husbandman 595691 595691 Hurne, Richard, of Clyvedon, husbandman 5
4943815 2340028 2340028 defendant Harryes John weaver 595691 595691 Harryes, John, of Clyvedon, weaver 12
4943816 2340028 2340028 defendant Underwode William laborer 595691 595691 Underwode, William, of Clyvedon, laborer 13
4943817 2340028 2340028 defendant Underwode John tailor 595691 595691 Underwode, John, of Clyvedon, tailor 14
4943818 2340028 2340028 defendant Dewedon Thomas laborer 595691 595691 Dewedon, Thomas, of CLyvedon, laborer 15
4943821 2340028 2340028 defendant Sylly William husbandman 595691 595691 Sylly, William, of Clyvedon, husbandman 18
4943822 2340028 2340028 defendant Brether Thomas husbandman 595691 595691 Brether, Thomas, of Clyvedon, husbandman 19
4943827 2340028 2340028 defendant Underwode Henry laborer 595691 595691 Underwode, Henry, of Clyvedon, laborer 24
4943828 2340028 2340028 defendant Kyng John husbandman 595691 595691 Kyng, John, of Clyvedon, husbandman 25
5020890 2363007 2363007 defendant Bony or Bovy John husbandman 595691 595691 Bony or Bovy, John, of Clyvedon, husbandman 0
5280897 2439485 2439485 defendant Wake Thomas esq 595691 595691 Wake, Thomas, of Clyvedon, esq 0
5280899 2439486 2439486 defendant Wake Thomas esq 595691 595691 Wake, Thomas, of Clyvedon, esq 0
5304899 2446470 2446470 defendant Sheperd William husbandman 595691 595691 Sheperd, William, of Clyvedon, husbandman 1
5325596 2452733 2452733 defendant Bacheler John yeoman 595691 595691 Bacheler, John, of Clyvedon, yeoman 0
5325597 2452733 2452733 defendant Beny William yeoman 595691 595691 Beny, William, of Clyvedon, yeoman 1
5332667 2454838 2454838 defendant Bacheler John yeoman 595691 595691 Bacheler, John, of Clyvedon, yeoman 3
5332668 2454838 2454838 defendant Colyns William yeoman 595691 595691 Colyns, William, of Clyvedon, yeoman 4
5332673 2454839 2454839 defendant Bacheler John yeoman 595691 595691 Bacheler, John, of Clyvedon, yeoman 3
5332674 2454839 2454839 defendant Colyns William yeoman 595691 595691 Colyns, William, of Clyvedon, yeoman 4
5342837 2457955 2457955 defendant Mauston or Manston John husbandman 595691 595691 Mauston or Manston, John, of Clyvedon, husbandman 0
5342838 2457955 2457955 defendant Bacheler John husbandman 595691 595691 Bacheler, John, of Clyvedon, husbandman 1
5342839 2457955 2457955 defendant Gardener William husbandman 595691 595691 Gardener, William, of Clyvedon, husbandman 2
5342840 2457955 2457955 defendant Haldon John husbandman 595691 595691 Haldon, John, of Clyvedon, husbandman 3
5342841 2457955 2457955 defendant Colyns William husbandman 595691 595691 Colyns, William, of Clyvedon, husbandman 4
5355174 2461689 2461689 defendant Tylly John yeoman 595691 595691 Tylly, John, of Clyvedon, yeoman 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);