names

27 rows where case_id = 1909113

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645867 1909113 1909113 plaintiff Harvy John pensioner 601559 601559 Harvy, John, of Lincolns Inn, pensioner 0
3645868 1909113 1909113 defendant Boyngton Henry   585869 585869 Boyngton, Henry, of London, knight 0
3645869 1909113 1909113 defendant Bradbury William gent 585869 585869 Bradbury, William, of London, gent 1
3645870 1909113 1909113 defendant Bemonde William gent   Bemonde, William, gent 2
3645871 1909113 1909113 defendant Benyngfeld Edmund gent 585869 585869 Benyngfeld, Edmund, of London, gent 3
3645872 1909113 1909113 defendant Bowes Ralph   585869 585869 Bowes, Ralph, of London, knight 4
3645873 1909113 1909113 defendant Constabell Philip     Constabell, Philip 5
3645874 1909113 1909113 defendant Cokette Thomas     Cokette, Thomas 6
3645875 1909113 1909113 defendant Clere Robert     Clere, Robert 7
3645876 1909113 1909113 defendant Capell Giles     Capell, Giles 8
3645877 1909113 1909113 defendant Crakenthorp Ambrose     Crakenthorp, Ambrose 9
3645878 1909113 1909113 defendant Delaryver Thomas     Delaryver, Thomas 10
3645879 1909113 1909113 defendant Evers Ralph     Evers, Ralph 11
3645880 1909113 1909113 defendant Evers William     Evers, William 12
3645881 1909113 1909113 defendant Fortescu Adrian     Fortescu, Adrian 13
3645882 1909113 1909113 defendant Fyldyng Richard     Fyldyng, Richard 14
3645883 1909113 1909113 defendant Fynyux William     Fynyux, William 15
3645884 1909113 1909113 defendant Forcette Edward     Forcette, Edward 16
3645885 1909113 1909113 defendant Gatys Richard     Gatys, Richard 17
3645886 1909113 1909113 defendant Garneys Robert     Garneys, Robert 18
3645887 1909113 1909113 defendant Gyttons Richard     Gyttons, Richard 19
3645888 1909113 1909113 defendant Garrard Thomas     Garrard, Thomas 20
3645889 1909113 1909113 defendant Hasylden Francis     Hasylden, Francis 21
3645890 1909113 1909113 defendant Hobart Walter     Hobart, Walter 22
3645891 1909113 1909113 defendant Hare Thomas     Hare, Thomas 23
3645892 1909113 1909113 defendant Knevette Edward     Knevette, Edward 24
3645893 1909113 1909113 defendant Lanacstre Geoffrey et al   Lanacstre, Geoffrey, et al 25

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