names

32 rows where case_id = 2353634

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4988919 2353634 2353634 plaintiff Broun Joan formerly wife of Richard   Broun, Joan, formerly wife of Richard 0
4988920 2353634 2353634 defendant Creweker John   696193 696193 Creweker, John, of Leicestershire 0
4988921 2353634 2353634 defendant atte Ovyn Henry husbandman 831279 831279 atte Ovyn, Henry, of Hertylshorn, husbandman 1
4988922 2353634 2353634 defendant atte Ovyn Thomas jun, of Hertshorn, husbandman   atte Ovyn, Thomas, jun, of Hertshorn, husbandman 2
4988923 2353634 2353634 defendant Sterre William husbandman 833547 833547 Sterre. William, of Wynsehill, husbandman 3
4988924 2353634 2353634 defendant Lovot John husbandman 770992 770992 Lovot, John, of Herteshorn, husbandman 4
4988925 2353634 2353634 defendant Sterre John baker 760291 760291 Sterre, John, of Repyngton, baker 5
4988926 2353634 2353634 defendant Reynold John husbandman 760291 760291 Reynold, John, of Repyngton, husbandman 6
4988927 2353634 2353634 defendant Nyk John husbandman 760291 760291 Nyk, John, of Repyngton, husbandman 7
4988928 2353634 2353634 defendant Dedyk Thomas gent 831280 831280 Dedyk, Thomas, of Stanton by Newehall, gent 8
4988929 2353634 2353634 defendant Bedyl Hugh gent 770992 770992 Bedyl, Hugh, of Herteshorn, gent 9
4988930 2353634 2353634 defendant Smyth John husbandman 586852 586852 Smyth, John, of Twyford, husbandman 10
4988931 2353634 2353634 defendant Chamberleyn William tailor 760291 760291 Chamberleyn, William, of Repyngton, tailor 11
4988932 2353634 2353634 defendant Hether Richard tanner 760291 760291 Hether, Richard, of Repyngton, tanner 12
4988933 2353634 2353634 defendant Boteler John yeoman 760291 760291 Boteler, John, of Repyngton, yeoman 13
4988934 2353634 2353634 defendant Halle John weaver 760291 760291 Halle, John, of Repyngton, weaver 14
4988935 2353634 2353634 defendant Dawes Robert husbandman 818901 818901 Dawes, Robert, of Ingulby, husbandman 15
4988936 2353634 2353634 defendant Mathewson Henry husbandman 831281 831281 Mathewson, Henry, of Fornewerk, husbandman 16
4988937 2353634 2353634 defendant Gresley Thomas yeoman 831281 831281 Gresley, Thomas, of Fornewerk, yeoman 17
4988938 2353634 2353634 defendant Atton John yeoman 831281 831281 Atton, John, of Fornewerk, yeoman 18
4988939 2353634 2353634 defendant Leycestre Robert husbandman 831282 831282 Leycestre, Robert, of Smethesby, husbandman 19
4988940 2353634 2353634 defendant Turnour John, sen turner 831283 831283 Turnour, John, sen, of Tekenale, turner 20
4988941 2353634 2353634 defendant Turnour John jun, of Tekenale, laborer   Turnour, John, jun, of Tekenale, laborer 21
4988942 2353634 2353634 defendant Reynold William laborer 760291 760291 Reynold, William, of Repyngton, laborer 22
4988943 2353634 2353634 defendant Shardelowe Thomas husbandman 626408 626408 Shardelowe, Thomas, of Bulton, husbandman 23
4988944 2353634 2353634 defendant Broun John husbandman 818901 818901 Broun, John, of Ingulby, husbandman 24
4988945 2353634 2353634 defendant Netknytter William husbandman 597770 597770 Netknytter, William, of Chaddesden, husbandman 25
4988946 2353634 2353634 defendant Coton Robert laborer 586682 586682 Coton, Robert, of Mylton, laborer 26
4988947 2353634 2353634 defendant Cartwryght Ralph husbandman 831281 831281 Cartwryght, Ralph, of Fornewerk, husbandman 27
4988948 2353634 2353634 defendant Smyth John husbandman 590284 590284 Smyth, John, of Melburn, husbandman 28
4988949 2353634 2353634 defendant Abell John yeoman 831283 831283 Abell, John, of Tekenale, yeoman 29
4988950 2353634 2353634 defendant atte Ovyn Wiliam jun, of Hertshorn, husbandman   atte Ovyn, Wiliam, jun, of Hertshorn, husbandman 30

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