names

21 rows where case_id = 1970233

✎ 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
3839343 1970233 1970233 plaintiff Westdene John     Westdene, John 0
3839344 1970233 1970233 defendant Warde John husbandman 613371 613371 Warde, John, of Sydelsham, husbandman 0
3839345 1970233 1970233 defendant Stent Richard husbandman 623549 623549 Stent, Richard, of Funtyngton, husbandman 1
3839346 1970233 1970233 defendant Stent Robert husbandman 623549 623549 Stent, Robert, of Funtyngton, husbandman 2
3839347 1970233 1970233 defendant Stent William husbandman 623549 623549 Stent, William, of Funtyngton, husbandman 3
3839348 1970233 1970233 defendant John Richard husbandman 623549 623549 John, Richard, of Funtyngton, husbandman 4
3839349 1970233 1970233 defendant Syteler William     Syteler, William 5
3839350 1970233 1970233 defendant Webbe Henry     Webbe, Henry 6
3839351 1970233 1970233 defendant Syteler Joan     Syteler, Joan 7
3839352 1970233 1970233 defendant Stent William   637917 637917 Stent, William, of West Asshelyng 8
3839353 1970233 1970233 defendant Warde William   637918 637918 Warde, William, of Fyssheborne 9
3839354 1970233 1970233 defendant Loder Richard     Loder, Richard 10
3839355 1970233 1970233 defendant Byrde Henry     Byrde, Henry 11
3839356 1970233 1970233 defendant Graveley Robert     Graveley, Robert 12
3839357 1970233 1970233 defendant Lane Richard     Lane, Richard 13
3839358 1970233 1970233 defendant Payne Richard     Payne, Richard 14
3839359 1970233 1970233 defendant Fowle Henry     Fowle, Henry 15
3839360 1970233 1970233 defendant Dyer Henry     Dyer, Henry 16
3839361 1970233 1970233 defendant Constable John     Constable, John 17
3839362 1970233 1970233 defendant Talour John     Talour, John 18
3839363 1970233 1970233 defendant Cokkys John     Cokkys, John 19

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