names

20 rows where case_id = 2345253

✎ 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
4960995 2345253 2345253 plaintiff Berkeley Maurice knight   Berkeley, Maurice, knight 0
4960996 2345253 2345253 defendant Clerk Elias parson of Northfeld   Clerk, Elias, parson of Northfeld 0
4960997 2345253 2345253 defendant Clerk William smith 586125 586125 Clerk, William, of Dudley, smith 1
4960998 2345253 2345253 defendant Colshull John glasier 586125 586125 Colshull, John, of Dudley, glasier 2
4960999 2345253 2345253 defendant Tyll Thomas nailer 586125 586125 Tyll, Thomas, of Dudley, nailer 3
4961000 2345253 2345253 defendant Page Henry glasier 586125 586125 Page, Henry, of Dudley, glasier 4
4961001 2345253 2345253 defendant Yerdley John laborer 586125 586125 Yerdley, John, of Dudley, laborer 5
4961002 2345253 2345253 defendant Walker Thomas nailer 586125 586125 Walker, Thomas, of Dudley, nailer 6
4961003 2345253 2345253 defendant Balle William nailer 586125 586125 Balle, William, of Dudley, nailer 7
4961004 2345253 2345253 defendant atte Parke Roger laborer 586125 586125 atte Parke, Roger, of Dudley, laborer 8
4961005 2345253 2345253 defendant Fote John laborer 586125 586125 Fote, John, of Dudley, laborer 9
4961006 2345253 2345253 defendant Puggemore Thomas smith 586125 586125 Puggemore, Thomas, of Dudley, smith 10
4961007 2345253 2345253 defendant Crompe John smith 586125 586125 Crompe, John, of Dudley, smith 11
4961008 2345253 2345253 defendant Maddok Nicholas butcher 586125 586125 Maddok, Nicholas, of Dudley, butcher 12
4961009 2345253 2345253 defendant Smyth Richard smith 790690 790690 Smyth, Richard, of Dorleston, Staffs, smith 13
4961010 2345253 2345253 defendant Perte John smith 737736 737736 Perte, John, of Dorleston, smith 14
4961011 2345253 2345253 defendant Bowell John smith 737736 737736 Bowell, John, of Dorleston, smith 15
4961012 2345253 2345253 defendant Heywode Roger   827729 827729 Heywode, Roger, of Dorleston, sharesmith 16
4961013 2345253 2345253 defendant Goreton Thomas nailer 737736 737736 Goreton, Thomas, of Dorleston, nailer 17
4961014 2345253 2345253 defendant Hogettes John collier 608950 608950 Hogettes, John, of Seggeley, collier 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);