names

35 rows where case_id = 2323911

✎ 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
4890930 2323911 2323911 plaintiff Codlyng Thomas, senior   598426 598426 Codlyng, Thomas, senior, of Wendlyng 0
4890931 2323911 2323911 plaintiff Codlyng Thomas   598426 598426 Codlyng, Thomas, of Wendlyng 1
4890932 2323911 2323911 plaintiff Codlyng John, junior   598426 598426 Codlyng, John, junior, of Wendlyng 2
4890933 2323911 2323911 plaintiff Codlyng John his brother   Codlyng, John, his brother 3
4890934 2323911 2323911 plaintiff Codlyng Richard   818056 818056 Codlyng, Richard, of Bullyngford 4
4890935 2323911 2323911 plaintiff Codlyng Joan   587754 587754 Codlyng, Joan, of Byllyngford 5
4890936 2323911 2323911 plaintiff Codlyng John   586396 586396 Codlyng, John, of Yaxham 6
4890937 2323911 2323911 plaintiff Codlyng Richard   586396 586396 Codlyng, Richard, of Yaxham 7
4890938 2323911 2323911 plaintiff Codlyng Joan   586396 586396 Codlyng, Joan, of Yaxham 8
4890939 2323911 2323911 plaintiff Codlyng Roger, senior   587754 587754 Codlyng, Roger, senior, of Byllyngford 9
4890940 2323911 2323911 plaintiff Codlyng Roger, junior   587754 587754 Codlyng, Roger, junior, of Byllyngford 10
4890941 2323911 2323911 plaintiff Codlyng Simon   587754 587754 Codlyng, Simon, of Byllyngford 11
4890942 2323911 2323911 plaintiff Codlyng Thomas   587754 587754 Codlyng, Thomas, of Byllyngford 12
4890943 2323911 2323911 plaintiff Codlyng Adam   587754 587754 Codlyng, Adam, of Byllyngford 13
4890944 2323911 2323911 plaintiff Codlyng Hugh     Codlyng, Hugh 14
4890945 2323911 2323911 plaintiff Codlyng Simon his brother   Codlyng, Simon, his brother 15
4890946 2323911 2323911 plaintiff Codlyng Agnes     Codlyng, Agnes 16
4890947 2323911 2323911 plaintiff Codlyng John her brother   Codlyng, John, her brother 17
4890948 2323911 2323911 plaintiff Codlyng Rose     Codlyng, Rose 18
4890949 2323911 2323911 plaintiff Codlyng Thomas     Codlyng, Thomas 19
4890950 2323911 2323911 plaintiff Codlyng Margaret   587754 587754 Codlyng, Margaret, of Byllyngford 20
4890951 2323911 2323911 plaintiff Codlyng Joan her sister   Codlyng, Joan, her sister 21
4890952 2323911 2323911 plaintiff Codlyng William     Codlyng, William 22
4890953 2323911 2323911 plaintiff Codlyng Katherine   587754 587754 Codlyng, Katherine, of Byllyngford 23
4890954 2323911 2323911 plaintiff Codlyng Adam her brother   Codlyng, Adam, her brother 24
4890955 2323911 2323911 plaintiff Codlyng Alice     Codlyng, Alice 25
4890956 2323911 2323911 plaintiff Codlyng Christian     Codlyng, Christian 26
4890957 2323911 2323911 plaintiff Codlyng Margaret her sister   Codlyng, Margaret, her sister 27
4890958 2323911 2323911 plaintiff Heyward William     Heyward, William 28
4890959 2323911 2323911 plaintiff Heyward John     Heyward, John 29
4890960 2323911 2323911 plaintiff Heyward Thomas     Heyward, Thomas 30
4890961 2323911 2323911 plaintiff Heyward Richard     Heyward, Richard 31
4890962 2323911 2323911 defendant Erdyngton Thomas   658514 658514 Erdyngton, Thomas, of Erdyngton, Warks, knight 0
4890963 2323911 2323911 defendant Radclyf John   586233 586233 Radclyf, John, of Attylburgh, knight 1
4890964 2323911 2323911 defendant Hungerford Edmund   594851 594851 Hungerford, Edmund, of Lacok, Wilts, knight 2

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