names

22 rows where case_id = 2222807

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4571963 2222807 2222807 plaintiff Armeston William     Armeston, William 0
4571964 2222807 2222807 defendant Holand Nicholas de     Holand, Nicholas de 0
4571965 2222807 2222807 defendant Willeson John   605693 605693 Willeson, John, of Chapell 1
4571966 2222807 2222807 defendant Thornhull Roger de   770849 770849 Thornhull, Roger de, of Chastelton 2
4571967 2222807 2222807 defendant Bagshawe Thomas son of William   Bagshawe, Thomas, son of William 3
4571968 2222807 2222807 defendant Halghns Geoffrey   770850 770850 Halghns, Geoffrey, of Castelton in the Peak, vicar 4
4571969 2222807 2222807 defendant Sale Roger de son of John   Sale, Roger de, son of John 5
4571970 2222807 2222807 defendant Burton John de son of Nicholas   Burton, John de, son of Nicholas 6
4571971 2222807 2222807 defendant Taillour Robert   770851 770851 Taillour, Robert, of Hairefeld 7
4571972 2222807 2222807 defendant Holilegh Thomas de   626733 626733 Holilegh, Thomas de, of Tyddeswell 8
4571973 2222807 2222807 defendant Dykson Hugh son of William   Dykson, Hugh, son of William 9
4571974 2222807 2222807 defendant Aleyn William son of Nicholas   Aleyn, William, son of Nicholas 10
4571975 2222807 2222807 defendant Hull Roger de   685531 685531 Hull, Roger de, of Chesterfield 11
4571976 2222807 2222807 defendant Fotur John   591227 591227 Fotur, John, of Hope 12
4571977 2222807 2222807 defendant del Hyde Nicholas     del Hyde, Nicholas 13
4571978 2222807 2222807 defendant Prestwyche Edmund de     Prestwyche, Edmund de 14
4571979 2222807 2222807 defendant del Birchus William     del Birchus, William 15
4571980 2222807 2222807 defendant Workusley John de son of John   Workusley, John de, son of John 16
4571981 2222807 2222807 defendant del Kyrke John son of William   del Kyrke, John, son of William 17
4571982 2222807 2222807 defendant Hally Ralph   770852 770852 Hally, Ralph, of Milveton 18
4571983 2222807 2222807 defendant Menrell John   770853 770853 Menrell, John, of Calnore 19
4571984 2222807 2222807 defendant Clementson John son of Richard   Clementson, John, son of Richard 20

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