names

20 rows where case_id = 2421521

✎ 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
5219840 2421521 2421521 plaintiff Hilton Godfrey esq   Hilton, Godfrey, esq 0
5219841 2421521 2421521 defendant More John rector of Stoke   More, John, rector of Stoke 0
5219842 2421521 2421521 defendant Botteler William yeoman 860716 860716 Botteler, William, of Codynore, Derbs, yeoman 1
5219843 2421521 2421521 defendant Parker John yeoman 860712 860712 Parker, John, of Codynore, yeoman 2
5219844 2421521 2421521 defendant Wryght Roger yeoman 860712 860712 Wryght, Roger, of Codynore, yeoman 3
5219845 2421521 2421521 defendant Coke Oliver yeoman 860712 860712 Coke, Oliver, of Codynore, yeoman 4
5219846 2421521 2421521 defendant Hamson Robert yeoman 860712 860712 Hamson, Robert, of Codynore, yeoman 5
5219847 2421521 2421521 defendant Vesy William yeoman 624357 624357 Vesy, William, of Castel Bytham, yeoman 6
5219848 2421521 2421521 defendant Martyn John   624357 624357 Martyn, John, of Castel Bytham, wright 7
5219849 2421521 2421521 defendant Frayne John yeoman 624357 624357 Frayne, John, of Castel Bytham, yeoman 8
5219850 2421521 2421521 defendant Inglond John laborer 589808 589808 Inglond, John, of Swafeld, laborer 9
5219851 2421521 2421521 defendant Northfolke Thomas clerk 607716 607716 Northfolke, Thomas, of Corby, clerk 10
5219852 2421521 2421521 defendant Emlyn Robert laborer 591835 591835 Emlyn, Robert, of Osgodby, laborer 11
5219853 2421521 2421521 defendant Campas Robert   589594 589594 Campas, Robert, of Quadryng, wright 12
5219854 2421521 2421521 defendant Salforth Thomas yeoman 624357 624357 Salforth, Thomas, of Castel Bytham, yeoman 13
5219855 2421521 2421521 defendant Rande Thomas yeoman 594332 594332 together with Rande, Thomas, of Swafelde, yeoman 14
5219856 2421521 2421521 defendant Thorp John yeoman 607716 607716 Thorp, John, of Corby, yeoman 15
5219857 2421521 2421521 defendant Holme Bartholomew yeoman 607716 607716 Holme, Bartholomew, of Corby, yeoman 16
5219858 2421521 2421521 defendant Taillour John, junior tailor 607716 607716 Taillour, John, junior, of Corby, tailor 17
5219859 2421521 2421521 defendant Margetson William weaver 607716 607716 Margetson,William, of COrby, weaver 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);