names

22 rows where case_id = 2205858

✎ 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
4517445 2205858 2205858 plaintiff Crumwell Maud     Crumwell, Maud 0
4517446 2205858 2205858 plaintiff Newecombe William     Newecombe, William 1
4517447 2205858 2205858 plaintiff Jonesson Richard     Jonesson, Richard 2
4517448 2205858 2205858 plaintiff Williamson John     Williamson, John 3
4517449 2205858 2205858 plaintiff Rous Michael     Rous, Michael 4
4517450 2205858 2205858 defendant Hill John de   760279 760279 Hill, John de, of Mauby, parson 0
4517451 2205858 2205858 defendant William son of Thomas     William, son of Thomas 1
4517452 2205858 2205858 defendant Count William   760279 760279 Count, William, of Mauby 2
4517453 2205858 2205858 defendant Totill John   760279 760279 Totill, John, of Mauby 3
4517454 2205858 2205858 defendant Holme William de   760279 760279 Holme, William de, of Mauby 4
4517455 2205858 2205858 defendant Holme Robert   760279 760279 Holme, Robert, of Mauby 5
4517456 2205858 2205858 defendant Drowry William     Drowry, William 6
4517457 2205858 2205858 defendant Whiteheved John   765472 765472 Whiteheved, John, of Mauby, jun 7
4517458 2205858 2205858 defendant Wyot John   760279 760279 Wyot, John, of Mauby 8
4517459 2205858 2205858 defendant Wyt_ William   760279 760279 Wyt_, William, of Mauby 9
4517460 2205858 2205858 defendant Godetyme Alan   760279 760279 Godetyme, Alan, of Mauby 10
4517461 2205858 2205858 defendant Holme John of servant of William of Holme   Holme, John of, servant of William of Holme 11
4517462 2205858 2205858 defendant Peronell Thomas   760279 760279 Peronell, Thomas, of Mauby 12
4517463 2205858 2205858 defendant Hawelay Simon   760279 760279 Hawelay, Simon, of Mauby 13
4517464 2205858 2205858 defendant Harpham William   760279 760279 Harpham, William, of Mauby 14
4517465 2205858 2205858 defendant Burgh William de son of William, of Mauby   Burgh, William de, son of William, of Mauby 15
4517466 2205858 2205858 defendant Smyth Thomas   760279 760279 Smyth, Thomas, of Mauby, son of John 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);