names

24 rows where case_id = 2174013

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4429436 2174013 2174013 plaintiff Waleys Roger   755587 755587 Waleys, Roger, of Swythelond 0
4429437 2174013 2174013 defendant Roule John de     Roule, John de 0
4429438 2174013 2174013 defendant Mardefeld Richard de     Mardefeld, Richard de 1
4429439 2174013 2174013 defendant Welaton Roger de     Welaton, Roger de 2
4429440 2174013 2174013 defendant Herynge Robert   621763 621763 Herynge, Robert, of Melburne 3
4429441 2174013 2174013 defendant Abard Thomas     Abard, Thomas 4
4429442 2174013 2174013 defendant Norreys Henry   755588 755588 Norreys, Henry, of Twycros 5
4429443 2174013 2174013 defendant Martyn John   754588 754588 Martyn, John, of Hynkele 6
4429444 2174013 2174013 defendant Chacombe Dalby Robert de     Chacombe Dalby, Robert de 7
4429445 2174013 2174013 defendant Cragge Henry     Cragge, Henry 8
4429446 2174013 2174013 defendant Stones John de     Stones, John de 9
4429447 2174013 2174013 defendant Clerk John le   696100 696100 Clerk, John le, of Reresby 10
4429448 2174013 2174013 defendant Barnesby Roger de     Barnesby, Roger de 11
4429449 2174013 2174013 defendant Mayster William   755589 755589 Mayster, William,of Barnesby 12
4429450 2174013 2174013 defendant Cryk John   602351 602351 Cryk, John, of Stretton 13
4429451 2174013 2174013 defendant Hengham William de     Hengham, William de 14
4429452 2174013 2174013 defendant Belegrave James de     Belegrave, James de 15
4429453 2174013 2174013 defendant Burstall John de     Burstall, John de 16
4429454 2174013 2174013 defendant Rakedale Richard   755590 755590 Rakedale, Richard, of Ramemerston 17
4429455 2174013 2174013 defendant Maunsel Thomas     Maunsel, Thomas 18
4429456 2174013 2174013 defendant Balle John     Balle, John 19
4429457 2174013 2174013 defendant Freynsh Edmund     Freynsh, Edmund 20
4429458 2174013 2174013 defendant Chapman Adam   588658 588658 Chapman, Adam, of Boresworth 21
4429459 2174013 2174013 defendant Seynzere Robert     Seynzere, Robert 22

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