names

37 rows where case_id = 2474170

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5396771 2474170 2474170 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5396772 2474170 2474170 defendant Neuman William   595014 595014 Neuman, William, of South Reppys 0
5396773 2474170 2474170 defendant Heyward Thomas   882900 882900 Heyward, Thomas, of Beston by Mylham 1
5396774 2474170 2474170 defendant Stacy Robert   764913 764913 Stacy, Robert, of Fakynham 2
5396775 2474170 2474170 defendant Toly Robert laborer 611520 611520 Toly, Robert, of Bryston, laborer 3
5396776 2474170 2474170 defendant Pepyr William yeoman 587172 587172 Pepyr, William, of East Derham, yeoman 4
5396777 2474170 2474170 defendant Blover Thomas butcher 596744 596744 Blover, Thomas, of Crowmer, butcher 5
5396778 2474170 2474170 defendant Frauncys Adam   882901 882901 Frauncys, Adam, of Croft Wheyte 6
5396779 2474170 2474170 defendant Whall Thomas   617565 617565 Whall, Thomas, of Erpyngham 7
5396780 2474170 2474170 defendant Batche William   589625 589625 Batche, William, of Betelee 8
5396781 2474170 2474170 defendant Trycok John   587935 587935 Trycok, John, of Colby 9
5396782 2474170 2474170 defendant Salman William   589927 589927 Salman, William, of Paston 10
5396783 2474170 2474170 defendant Rede Thomas   586471 586471 Rede, Thomas, of Aylesham 11
5396784 2474170 2474170 defendant Godfrey John   641532 641532 Godfrey, John, of Potter Heigham 12
5396785 2474170 2474170 defendant White William   644180 644180 White, William, of Costesey 13
5396786 2474170 2474170 defendant Trendyll Thomas   611830 611830 Trendyll, Thomas, of Bylney 14
5396787 2474170 2474170 defendant Wattys Thomas laborer 587166 587166 Wattys, Thomas, of Salle, laborer 15
5396788 2474170 2474170 defendant Kelyngham William   588930 588930 Kelyngham, William, of Honyng 16
5396789 2474170 2474170 defendant Plumbe Thomas   882902 882902 Plumbe, Thomas, of Foksham 17
5396790 2474170 2474170 defendant Platfote Walter   605070 605070 Platfote, Walter, of Shipdham 18
5396791 2474170 2474170 defendant Phippis Richard   588926 588926 Phippis, Richard, of North Elmham 19
5396792 2474170 2474170 defendant Gowty Thomas   598083 598083 Gowty, Thomas, of Ketylston 20
5396793 2474170 2474170 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5396794 2474170 2474170 defendant Omondys William yeoman 586471 586471 Omondys, William, of Aylesham, yeoman 22
5396795 2474170 2474170 defendant Jekkys Clement   586471 586471 Jekkys, Clement, of Aylesham 23
5396796 2474170 2474170 defendant Tylly Henry   586471 586471 Tylly, Henry, of Aylesham 24
5396797 2474170 2474170 defendant Kerre William   589705 589705 Kerre, William, of Hyndryngham 25
5396798 2474170 2474170 defendant Okys Alexander   602135 602135 Okys, Alexander, of Henyngham 26
5396799 2474170 2474170 defendant Taverham Thomas gent 587166 587166 Taverham, Thomas, of Salle, gent 27
5396800 2474170 2474170 defendant Elvered John   586471 586471 Elvered, John, of Aylesham 28
5396801 2474170 2474170 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, yeoman, administrators of 29
5396802 2474170 2474170 defendant Clerk John   595014 595014 (Clerk, John, of South Reppys 30
5396803 2474170 2474170 defendant Clerk Joan     Joan, his wife 31
5396804 2474170 2474170 defendant Langewade Thomas esq 611520 611520 Langewade, Thomas, of Bryston, yeoman, administrator of John Bryston, senior, of Bryston, esq 32
5396805 2474170 2474170 defendant Langwade John yeoman 611520 611520 (Langwade, John, of Bryston, yeoman 33
5396806 2474170 2474170 defendant Marion Langwade   611520 611520 Marion, Langwade, of Bryston 34
5396807 2474170 2474170 defendant each a husbandman except where indicated     each a husbandman, except where indicated 35

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