names

32 rows where case_id = 2403726

✎ 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
5158888 2403726 2403726 plaintiff Restwold Richard esq   Restwold, Richard, esq 0
5158889 2403726 2403726 defendant Tylyoll William esq 854457 854457 Tylyoll, William, of Scotby, esq 0
5158890 2403726 2403726 defendant Howe John yeoman 854457 854457 Howe, John, of Scotby, yeoman 1
5158891 2403726 2403726 defendant Atkynson John yeoman 854457 854457 Atkynson, John, of Scotby, yeoman 2
5158892 2403726 2403726 defendant Morton William yeoman 854457 854457 Morton, William, of Scotby, yeoman 3
5158893 2403726 2403726 defendant Robynson John yeoman 854457 854457 Robynson, John, of Scotby, yeoman 4
5158894 2403726 2403726 defendant Morton John yeoman 854457 854457 Morton, John, of Scotby, yeoman 5
5158895 2403726 2403726 defendant Nevynson John yeoman 854457 854457 Nevynson, John, of Scotby, yeoman 6
5158896 2403726 2403726 defendant Blakelokke Robert yeoman 854458 854458 Blakelokke, Robert, of Bronstath, yeoman 7
5158897 2403726 2403726 defendant Patonson John yeoman 854459 854459 Patonson, John, of Holberby, yeoman 8
5158898 2403726 2403726 defendant Morton John yeoman 854459 854459 Morton, John, of Holberby, yeoman 9
5158899 2403726 2403726 defendant Paton John yeoman 761568 761568 Paton, John, of Scaleby, yeoman 10
5158900 2403726 2403726 defendant ap Dale Robert yeoman 761568 761568 ap Dale, Robert, of Scaleby, yeoman 11
5158901 2403726 2403726 defendant Sewell William yeoman 781138 781138 Sewell, William, of Bochardby, yeoman 12
5158902 2403726 2403726 defendant Woldehane Henry yeoman 781138 781138 Woldehane, Henry, of Bochardby, yeoman 13
5158903 2403726 2403726 defendant Holme John yeoman 781138 781138 Holme, John, of Bochardby, yeoman 14
5158904 2403726 2403726 defendant Holme Robert yeoman 781138 781138 Holme, Robert, of Bochardby, yeoman 15
5158905 2403726 2403726 defendant Holme Henry yeoman 781138 781138 Holme, Henry, of Bochardby, yeoman 16
5158906 2403726 2403726 defendant Rayleston Henry yeoman 781138 781138 Rayleston, Henry, of Bochardby, yeoman 17
5158907 2403726 2403726 defendant Rayleton William yeoman 781138 781138 Rayleton, William, of Bochardby, yeoman 18
5158908 2403726 2403726 defendant Rygge Richard yeoman 779136 779136 Rygge, Richard, of Briscowe, yeoman 19
5158909 2403726 2403726 defendant Walby John yeoman 779136 779136 Walby, John, of Briscowe, yeoman 20
5158910 2403726 2403726 defendant Miller William yeoman 854460 854460 Miller, William, of Caldowehill, yeoman 21
5158911 2403726 2403726 defendant Tyngate Richard yeoman 854461 854461 Tyngate, Richard, of Bochergate, yeoman 22
5158912 2403726 2403726 defendant Alenson James yeoman 783178 783178 Alenson, James, of Ricardby, yeoman 23
5158913 2403726 2403726 defendant Nevynson John yeoman 854462 854462 Nevynson, John, of Langthwayt Weyte, yeoman 24
5158914 2403726 2403726 defendant Nevynson Mathew yeoman 854457 854457 Nevynson, Mathew, of Scotby, yeoman 25
5158915 2403726 2403726 defendant Coke Nicholas yeoman 854463 854463 Coke, Nicholas, of Great Corkeby, yeoman 26
5158916 2403726 2403726 defendant Storke Thomas yeoman 854463 854463 Storke, Thomas, of Great Corkeby, yeoman 27
5158917 2403726 2403726 defendant Hope Richard yeoman 776576 776576 Hope, Richard, of Croseby, yeoman 28
5158918 2403726 2403726 defendant Levyngton William   776576 776576 Levyngton, William, of Croseby 29
5158919 2403726 2403726 defendant Sclate William yeoman 854464 854464 Sclate, William, of Woderyll, yeoman 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);