names

20 rows where case_id = 2488831

✎ 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
5446453 2488831 2488831 plaintiff Greng_ John     Greng_, John 0
5446454 2488831 2488831 defendant Bloodwell Richard clerk 586395 586395 Bloodwell, Richard, of Alderton, clerk 0
5446455 2488831 2488831 defendant Humebathe Thomas   888407 888407 Humebathe, Thomas, of Codyngton, Worcs 1
5446456 2488831 2488831 defendant Scoyte Thomas   646705 646705 Scoyte, Thomas, of Dyxton 2
5446457 2488831 2488831 defendant Se_yte Robert   646705 646705 Se_yte, Robert, of Dyxton 3
5446458 2488831 2488831 defendant Whytyng John   646705 646705 Whytyng, John, of Dyxton 4
5446459 2488831 2488831 defendant Stanley   husbandman   _, Stanley, husbandman 5
5446460 2488831 2488831 defendant Fyscher John   586395 586395 Fyscher, John, of Alderton 6
5446461 2488831 2488831 defendant (illegible) of Alderton     _, of Alderton 7
5446462 2488831 2488831 defendant Wykys William   586395 586395 Wykys, William, of Alderton 8
5446463 2488831 2488831 defendant Spencer (illegible)   586395 586395 Spencer, _, of Alderton 9
5446464 2488831 2488831 defendant Hyggens John   586395 586395 Hyggens, John, of Alderton 10
5446465 2488831 2488831 defendant Taunton John, sen   586395 586395 Taunton, John, sen, of Alderton 11
5446466 2488831 2488831 defendant Tawndon John jun, of Alderton   Tawndon, John, jun, of Alderton 12
5446467 2488831 2488831 defendant Cryse Thomas   586395 586395 Cryse, Thomas, of Alderton 13
5446468 2488831 2488831 defendant Reve Thomas   585995 585995 Reve,Thomas, of Neweton 14
5446469 2488831 2488831 defendant Mason Thomas   596691 596691 Mason, Thomas, of Stanley St Leonard 15
5446470 2488831 2488831 defendant Creese John, sen   586395 586395 Creese, John, sen, of Alderton 16
5446471 2488831 2488831 defendant Hyggens William   586395 586395 Hyggens, William, of Alderton 17
5446472 2488831 2488831 defendant all husbandman but the first     all husbandman, but the first 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);