names

31 rows where case_id = 2477962

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5410016 2477962 2477962 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5410017 2477962 2477962 defendant Neuman William husbandman 595014 595014 Neuman, William, of South Reppys, husbandman 0
5410018 2477962 2477962 defendant Hayward Thomas husbandman 882900 882900 Hayward, Thomas, of Beston by Mylham, husbandman 1
5410019 2477962 2477962 defendant Stacy Robert husbandman 764913 764913 Stacy, Robert, of Fakynham, husbandman 2
5410020 2477962 2477962 defendant Toly Robert laborer 626736 626736 Toly, Robert, of Briston, laborer 3
5410021 2477962 2477962 defendant Pepyr William yeoman 587172 587172 Pepyr, William, of East Derham, yeoman 4
5410022 2477962 2477962 defendant Glover Thomas butcher 632735 632735 Glover, Thomas, of Crowemer, butcher 5
5410023 2477962 2477962 defendant Fraunceys Adam husbandman 881211 881211 Fraunceys, Adam, of Crostwheyte, husbandman 6
5410024 2477962 2477962 defendant Whall Thomas husbandman 802112 802112 Whall, Thomas, of Eppyngham, husbandman 7
5410025 2477962 2477962 defendant Batche William husbandman 589625 589625 Batche, William, of Betelee, husbandman 8
5410026 2477962 2477962 defendant Tyrcok John husbandman 587935 587935 Tyrcok, John, of Colby, husbandman 9
5410027 2477962 2477962 defendant Salman William husbandman 589927 589927 Salman, William, of Paston, husbandman 10
5410028 2477962 2477962 defendant Kede Thomas husbandman 586471 586471 Kede, Thomas, of Aylesham, husbandman 11
5410029 2477962 2477962 defendant Godgrey John husbandman 641532 641532 Godgrey, John, of Potter Heigham, husbandman 12
5410030 2477962 2477962 defendant Whyte William husbandman 884671 884671 Whyte, William, of Costesesey, husbandman 13
5410031 2477962 2477962 defendant Tryndyll Thomas husbandman 611830 611830 Tryndyll, Thomas, of Bylney, husbandman 14
5410032 2477962 2477962 defendant Wattys Thomas laborer 587166 587166 Wattys, Thomas, of Salle, laborer 15
5410033 2477962 2477962 defendant Kelyngham William husbandman 588930 588930 Kelyngham, William, of Honyng, husbandman 16
5410034 2477962 2477962 defendant Plumbe Thomas husbandman 587836 587836 Plumbe, Thomas, of Folsham, husbandman 17
5410035 2477962 2477962 defendant Platfote Walter husbandman 590846 590846 Platfote, Walter, of Shipdam, husbandman 18
5410036 2477962 2477962 defendant Phyppys Richard husbandman 588926 588926 Phyppys, Richard, of North Elmham, husbandman 19
5410037 2477962 2477962 defendant Gowty Thomas husbandman 598083 598083 Gowty, Thomas, of Ketylston, husbandman 20
5410038 2477962 2477962 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5410039 2477962 2477962 defendant Edmund William yeoman 586471 586471 Edmund, William, of Aylesham, yeoman 22
5410040 2477962 2477962 defendant Tylly Henry husbandman 586471 586471 Tylly, Henry, of Aylesham, husbandman 23
5410041 2477962 2477962 defendant Okys Alexander husbandman 602135 602135 Okys, Alexander, of Henyngham, husbandman 24
5410042 2477962 2477962 defendant Taverham Thomas gent 587166 587166 Taverham, Thomas, of Salle, gent 25
5410043 2477962 2477962 defendant Elnerd John husbandman 586471 586471 Elnerd, John, of Aylesham, husbandman 26
5410044 2477962 2477962 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, administrators of 27
5410045 2477962 2477962 defendant Clerk John husbandman 595014 595014 (Clerk, John, of South Reppys, husbandman 28
5410046 2477962 2477962 defendant Clerk Joan     Joan, his wife 29

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