names

20 rows where case_id = 2421520

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5219820 2421520 2421520 plaintiff Hilton Godfrey esq   Hilton, Godfrey, esq 0
5219821 2421520 2421520 defendant More John rector of Stoke   More, John, rector of Stoke 0
5219822 2421520 2421520 defendant Boteller William yeoman 860711 860711 Boteller, William, of Codynore, Serbs, yeoman 1
5219823 2421520 2421520 defendant Parker John yeoman 860712 860712 Parker, John, of Codynore, yeoman 2
5219824 2421520 2421520 defendant Wright Roger yeoman 860712 860712 Wright, Roger, of Codynore, yeoman 3
5219825 2421520 2421520 defendant Coke Oliver yeoman 860712 860712 Coke, Oliver, of Codynore, yeoman 4
5219826 2421520 2421520 defendant Hamson Robert yeoman 860712 860712 Hamson, Robert, of Codynore, yeoman 5
5219827 2421520 2421520 defendant Vesy William yeoman 624357 624357 Vesy, William, of Castel Bytham, yeoman 6
5219828 2421520 2421520 defendant Martyn John   624357 624357 Martyn, John, of Castel Bytham, wright 7
5219829 2421520 2421520 defendant Frayne John yeoman 624357 624357 Frayne, John, of Castel Bytham, yeoman 8
5219830 2421520 2421520 defendant Inglond John laborer 589808 589808 Inglond, John, of Swafeld, laborer 9
5219831 2421520 2421520 defendant Northfolk Thomas clerk 607716 607716 Northfolk, Thomas, of Corby, clerk 10
5219832 2421520 2421520 defendant Emlyn Robert laborer 591835 591835 Emlyn, Robert, of Osgodby, laborer 11
5219833 2421520 2421520 defendant Campas Robert   860714 860714 Campas, Robert, of Qwadrynge, wright 12
5219834 2421520 2421520 defendant Taylour John, junior tailor 607716 607716 Taylour, John, junior, of Corby, tailor 13
5219835 2421520 2421520 defendant Margotson William weaver 607716 607716 Margotson, William, of Corby, weaver 14
5219836 2421520 2421520 defendant Salforth Thomas yeoman 624357 624357 Salforth, Thomas, of Castel Bytham, yeoman 15
5219837 2421520 2421520 defendant Rande Thomas yeoman 860715 860715 together with Rande, Thomas, of Swafeld, Derbs, yeoman 16
5219838 2421520 2421520 defendant Thorp John yeoman 607716 607716 Thorp, John, of Corby, yeoman 17
5219839 2421520 2421520 defendant Holme Bartholomew yeoman 607716 607716 Holme, Bartholomew, of Corby, yeoman 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);