names

20 rows where case_id = 2245569

✎ 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
4648328 2245569 2245569 plaintiff Sturmer Henry     Sturmer, Henry 0
4648329 2245569 2245569 defendant Edrych William     Edrych, William 0
4648330 2245569 2245569 defendant Bocher Walter     Bocher, Walter 1
4648331 2245569 2245569 defendant Skot Roger clerk   Skot, Roger, clerk 2
4648332 2245569 2245569 defendant Waye William   622634 622634 Waye, William, of Tytsale 3
4648333 2245569 2245569 defendant Banyard Thomas   622634 622634 Banyard, Thomas, of Tytsale 4
4648334 2245569 2245569 defendant Banyard John   622634 622634 Banyard, John, of Tytsale 5
4648335 2245569 2245569 defendant Wynkel Thomas   586882 586882 Wynkel, Thomas, of Betele 6
4648336 2245569 2245569 defendant Heye Richard     Heye, Richard 7
4648337 2245569 2245569 defendant Rust Adam   586882 586882 Rust, Adam, of Betele 8
4648338 2245569 2245569 defendant Bauge Robert     Bauge, Robert 9
4648339 2245569 2245569 defendant Hole Robert     Hole, Robert 10
4648340 2245569 2245569 defendant Reve William   586363 586363 Reve, William, of Bungey 11
4648341 2245569 2245569 defendant Dunston John     Dunston, John 12
4648342 2245569 2245569 defendant Caudeler John   589665 589665 Caudeler, John, of Lucham 13
4648343 2245569 2245569 defendant Cok Thomas clerk   Cok, Thomas, clerk 14
4648344 2245569 2245569 defendant Launde Robert     Launde, Robert 15
4648345 2245569 2245569 defendant Esseye NIcholas   593033 593033 Esseye, NIcholas, of Hekelyng 16
4648346 2245569 2245569 defendant Grom John     Grom, John 17
4648347 2245569 2245569 defendant Wolvene John clerk   Wolvene, John, clerk 18

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