names

34 rows where case_id = 2219162

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4560273 2219162 2219162 plaintiff Naulton William     Naulton, William 0
4560274 2219162 2219162 defendant Mitton John de   608894 608894 Mitton, John de, of Allerton 0
4560275 2219162 2219162 defendant Plastere Thomas   608894 608894 Plastere, Thomas, of Allerton 1
4560276 2219162 2219162 defendant Wryght Robert   769614 769614 Wryght, Robert, of Syggeswyk 2
4560277 2219162 2219162 defendant Warton Simon de   769615 769615 Warton, Simon de, of Hawenby 3
4560278 2219162 2219162 defendant Gower William   769615 769615 Gower, William, of Hawenby 4
4560279 2219162 2219162 defendant Milner William   769615 769615 Milner, William, of Hawenby 5
4560280 2219162 2219162 defendant Sissotson John   769616 769616 Sissotson, John, of Aldbyland 6
4560281 2219162 2219162 defendant Syssotson Thomas   769616 769616 Syssotson, Thomas, of Aldbyland 7
4560282 2219162 2219162 defendant sissotson Roger   769617 769617 sissotson, Roger, of Ald Byland 8
4560283 2219162 2219162 defendant Trudale William   769618 769618 Trudale, William, of Grenehow 9
4560284 2219162 2219162 defendant del Hall Peter   618556 618556 del Hall, Peter, of Sylton 10
4560285 2219162 2219162 defendant Bulmer Walter   618556 618556 Bulmer, Walter, of Sylton 11
4560286 2219162 2219162 defendant Bulmer John   618556 618556 Bulmer, John, of Sylton 12
4560287 2219162 2219162 defendant Garbote William   769619 769619 Garbote, William, of Bildesdak 13
4560288 2219162 2219162 defendant Hudson Wiliam   769620 769620 Hudson, Wiliam, of Erneclyff 14
4560289 2219162 2219162 defendant del Stabyll John   769620 769620 del Stabyll, John, of Erneclyff 15
4560290 2219162 2219162 defendant Hoggalon Roger   629548 629548 Hoggalon, Roger, of Whorleton 16
4560291 2219162 2219162 defendant Coke William   629548 629548 Coke, William, of Whorleton 17
4560292 2219162 2219162 defendant Thomson John   629548 629548 Thomson, John, of Whorleton 18
4560293 2219162 2219162 defendant del Clay Robert   761129 761129 del Clay, Robert, of Cleveland 19
4560294 2219162 2219162 defendant Watton William de   769621 769621 Watton, William de, of Bildesda_ 20
4560295 2219162 2219162 defendant Parcour Thomas   761129 761129 Parcour, Thomas, of Cleveland 21
4560296 2219162 2219162 defendant Wryghtson R_   769622 769622 Wryghtson, R_, of Allertonshir 22
4560297 2219162 2219162 defendant Scathelok Roger   761129 761129 Scathelok, Roger, of Cleveland 23
4560298 2219162 2219162 defendant Bell John   602968 602968 Bell, John, of Thirsk 24
4560299 2219162 2219162 defendant Sandes William   769623 769623 Sandes, William, of Bildsdale 25
4560300 2219162 2219162 defendant Parmoule Thomas son of John   Parmoule, Thomas, son of John 26
4560301 2219162 2219162 defendant Traynholme William     Traynholme, William 27
4560302 2219162 2219162 defendant Traynholme John de     Traynholme, John de 28
4560303 2219162 2219162 defendant Welbery John     Welbery, John 29
4560304 2219162 2219162 defendant R_howe John     R_howe, John 30
4560305 2219162 2219162 defendant Lokweod Thmas   586183 586183 Lokweod, Thmas, of Broghton 31
4560306 2219162 2219162 defendant Marton William   593153 593153 Marton, William, of Middelton 32

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