names

23 rows where case_id = 2242058

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4635865 2242058 2242058 plaintiff Arundell Thomas earl of   Arundell, Thomas, earl of 0
4635866 2242058 2242058 defendant atte Crofte William     atte Crofte, William 0
4635867 2242058 2242058 defendant Stydulf John     Stydulf, John 1
4635868 2242058 2242058 defendant Batewell Thomas     Batewell, Thomas 2
4635869 2242058 2242058 defendant Page John   776623 776623 Page, John, of Bukstode 3
4635870 2242058 2242058 defendant Carde John   759570 759570 Carde, John, of Maghefelde 4
4635871 2242058 2242058 defendant Staple William     Staple, William 5
4635872 2242058 2242058 defendant Shodewell William     Shodewell, William 6
4635873 2242058 2242058 defendant Bukstede John the parish clerk, in   Bukstede, John, the parish clerk, in 7
4635874 2242058 2242058 defendant Croucheman John   776624 776624 Croucheman, John, of Haukesdon 8
4635875 2242058 2242058 defendant Fordere John   759570 759570 Fordere, John, of Maghefelde 9
4635876 2242058 2242058 defendant Hocchere William carpenter 596210 596210 Hocchere, William, of Selmeston, carpenter 10
4635877 2242058 2242058 defendant Edward Simon   758963 758963 Edward, Simon, of Isefeld 11
4635878 2242058 2242058 defendant Whyte John   776625 776625 Whyte, John, of Horstede Kaynes 12
4635879 2242058 2242058 defendant Skyn John jun, of Wylyngham   Skyn, John, jun, of Wylyngham 13
4635880 2242058 2242058 defendant Wyll Richard     Wyll, Richard 14
4635881 2242058 2242058 defendant Parker John jun, of Wylyngham   Parker, John, jun, of Wylyngham 15
4635882 2242058 2242058 defendant Uphouse John jun   Uphouse, John, jun 16
4635883 2242058 2242058 defendant Webbe William millward   Webbe, William, millward 17
4635884 2242058 2242058 defendant Pope John millward   Pope, John, millward 18
4635885 2242058 2242058 defendant Saundre John     Saundre, John 19
4635886 2242058 2242058 defendant Whiteman Geoffrey     Whiteman, Geoffrey 20
4635887 2242058 2242058 defendant Tebald Richard   634683 634683 Tebald, Richard, of West Meston 21

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