names

23 rows where case_id = 2241286

✎ 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
4633334 2241286 2241286 plaintiff Warwick Richard earl of   Warwick, Richard, earl of 0
4633335 2241286 2241286 defendant Sexteyne Richard   587826 587826 Sexteyne, Richard, of Lychefeld 0
4633336 2241286 2241286 defendant Geyne William     Geyne, William 1
4633337 2241286 2241286 defendant Taverner John   588037 588037 Taverner, John, of Lichefeld 2
4633338 2241286 2241286 defendant Barker Thomas   588037 588037 Barker, Thomas, of Lichefeld 3
4633339 2241286 2241286 defendant Aston Richard de     Aston, Richard de 4
4633340 2241286 2241286 defendant tuttebury William de     tuttebury, William de 5
4633341 2241286 2241286 defendant Bryd William     Bryd, William 6
4633342 2241286 2241286 defendant Hurst Robert     Hurst, Robert 7
4633343 2241286 2241286 defendant Holdenne Agnes     Holdenne, Agnes 8
4633344 2241286 2241286 defendant Graven John     Graven, John 9
4633345 2241286 2241286 defendant (not given) Robert his brother   Robert, his brother 10
4633346 2241286 2241286 defendant Taillour John   592855 592855 Taillour, John, of colshull 11
4633347 2241286 2241286 defendant Gylon John   753662 753662 Gylon, John,of Little sutton 12
4633348 2241286 2241286 defendant Busbury Henry     Busbury, Henry 13
4633349 2241286 2241286 defendant Aleyn Henry   776398 776398 Aleyn, Henry, of Allerwyche 14
4633350 2241286 2241286 defendant Abell Thomas jun, of Castle Bronwych   Abell, Thomas, jun, of Castle Bronwych 15
4633351 2241286 2241286 defendant Chattok Henry     Chattok, Henry 16
4633352 2241286 2241286 defendant Chattok John     Chattok, John 17
4633353 2241286 2241286 defendant Cappe Thomas   596795 596795 Cappe, Thomas, of Mynworth 18
4633354 2241286 2241286 defendant Baker John servant of John Ynge   Baker, John, servant of John Ynge 19
4633355 2241286 2241286 defendant Foster John servant of William Neuport   Foster, John, servant of William Neuport 20
4633356 2241286 2241286 defendant Ayle John   776399 776399 Ayle, John, of Hyntes 21

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