names

19 rows where case_id = 2478820

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5412948 2478820 2478820 plaintiff Ferrers Martin     Ferrers, Martin, on his own account 0
5412949 2478820 2478820 defendant Shelley John gent 585869 585869 Shelley, John, of London, gent 0
5412950 2478820 2478820 defendant Plowfeld William   653439 653439 Plowfeld, William, of London, scrivenor 1
5412951 2478820 2478820 defendant Middelton Nicholas gent 585869 585869 Middelton, Nicholas, of London, gent 2
5412952 2478820 2478820 defendant Gernes John gent 585869 585869 Gernes, John, of London, gent 3
5412953 2478820 2478820 defendant Manfeld Robert gent 585869 585869 Manfeld, Robert, of London, gent 4
5412954 2478820 2478820 defendant Paston Edmund gent 585869 585869 Paston, Edmund, of London, gent 5
5412955 2478820 2478820 defendant Lynsted William gent 585869 585869 Lynsted, William, of London, gent 6
5412956 2478820 2478820 defendant Haynes Richard gent 604018 604018 Haynes, Richard, of Colchester, Essex, gent 7
5412957 2478820 2478820 defendant Spyce Humphrey gent 585869 585869 Spyce, Humphrey, of London, gent 8
5412958 2478820 2478820 defendant Barton William gent 604131 604131 Barton, William, of Winchester, Hants, gent 9
5412959 2478820 2478820 defendant Forde Lawrence gent 585869 585869 Forde, Lawrence, of London, gent 10
5412960 2478820 2478820 defendant Fetiplace Anthony gent 585869 585869 Fetiplace, Anthony, of London, gent 11
5412961 2478820 2478820 defendant Gage Roger gent 585869 585869 Gage, Roger, of London, gent 12
5412962 2478820 2478820 defendant Mykelfeld Robert gent 585869 585869 Mykelfeld, Robert, of London, gent 13
5412963 2478820 2478820 defendant Derby John gent 604018 604018 Derby, John, of Colchester, Essex, gent 14
5412964 2478820 2478820 defendant Brygham William gent 585869 585869 Brygham, William, of London, gent 15
5412965 2478820 2478820 defendant Dagges John gent 585869 585869 Dagges, John, of London, gent 16
5412966 2478820 2478820 defendant Lathom John gent 654876 654876 Lathom, John, of Southampton, Hants, gent 17

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