names

18 rows where case_id = 2174953

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4432585 2174953 2174953 plaintiff Daver Roger     Daver, Roger 0
4432586 2174953 2174953 defendant Prynkle Walter     Prynkle, Walter 0
4432587 2174953 2174953 defendant Batelesford John de     Batelesford, John de 1
4432588 2174953 2174953 defendant Prynkle John     Prynkle, John 2
4432589 2174953 2174953 defendant Prynkel Walter     Prynkel, Walter 3
4432590 2174953 2174953 defendant Plokter Richard     Plokter, Richard 4
4432591 2174953 2174953 defendant Aghemound Alexander     Aghemound, Alexander 5
4432592 2174953 2174953 defendant Dygoun William     Dygoun, William 6
4432593 2174953 2174953 defendant Osmound John     Osmound, John 7
4432594 2174953 2174953 defendant Ferryngg Richard     Ferryngg, Richard 8
4432595 2174953 2174953 defendant Hereberd John   755919 755919 Hereberd, John, of Rottyngge Dene 9
4432596 2174953 2174953 defendant Payn John   587374 587374 Payn, John, of Lewes 10
4432597 2174953 2174953 defendant Freshe Robert   587374 587374 Freshe, Robert, of Lewes 11
4432598 2174953 2174953 defendant Snellyng Richard   587374 587374 Snellyng, Richard, of Lewes 12
4432599 2174953 2174953 defendant Northdien William   589427 589427 Northdien, William,of Alyngton 13
4432600 2174953 2174953 defendant Brut John le   755920 755920 Brut, John le, of Wogham 14
4432601 2174953 2174953 defendant Bakere Nicholas le of Wogham     Bakere, Nicholas le of Wogham 15
4432602 2174953 2174953 defendant Burstowe John de, son of William   Burstowe, John, de, son of William 16

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