names

27 rows where case_id = 1910939

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651862 1910939 1910939 plaintiff Throkmerton Robert knight   Throkmerton, Robert, knight 0
3651863 1910939 1910939 defendant James John yeoman 602804 602804 James, John, of Chepyng Campden, Glos, yeoman 0
3651864 1910939 1910939 defendant Stokys William yeoman 602805 602805 Stokys, William, of Chepyng Campden, yeoman 1
3651865 1910939 1910939 defendant Welsheman Thomas     Welsheman, Thomas 2
3651866 1910939 1910939 defendant Jarward Christopher     Jarward, Christopher 3
3651867 1910939 1910939 defendant North John     North, John 4
3651868 1910939 1910939 defendant Clerk William     Clerk, William 5
3651869 1910939 1910939 defendant Bosworth William     Bosworth, William 6
3651870 1910939 1910939 defendant Bonar William     Bonar, William 7
3651871 1910939 1910939 defendant Bonar Thomas     Bonar, Thomas 8
3651872 1910939 1910939 defendant Luter John     Luter, John 9
3651873 1910939 1910939 defendant Kynman John   602806 602806 Kynman, John, of Honyborn 10
3651874 1910939 1910939 defendant Cornell Thomas     Cornell, Thomas 11
3651875 1910939 1910939 defendant Cornell William     Cornell, William 12
3651876 1910939 1910939 defendant Webbe William     Webbe, William 13
3651877 1910939 1910939 defendant James John   602807 602807 James, John, of Myculton 14
3651878 1910939 1910939 defendant Yong John     Yong, John 15
3651879 1910939 1910939 defendant Herehyll Henry     Herehyll, Henry 16
3651880 1910939 1910939 defendant Lyncoln Nicholas     Lyncoln, Nicholas 17
3651881 1910939 1910939 defendant Wyllyams mathew     Wyllyams, mathew 18
3651882 1910939 1910939 defendant Broderer Wedward     Broderer, Wedward 19
3651883 1910939 1910939 defendant Freman Richard     Freman, Richard 20
3651884 1910939 1910939 defendant Herehyll Thomas     Herehyll, Thomas 21
3651885 1910939 1910939 defendant Tyll Richard     Tyll, Richard 22
3651886 1910939 1910939 defendant Heggys William     Heggys, William 23
3651887 1910939 1910939 defendant Seggebarowe Peter     Seggebarowe, Peter 24
3651888 1910939 1910939 defendant Skasset John     Skasset, John 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);