names

22 rows where place_id = 587736

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592304 1865207 1865207 defendant Gamul Robert draper 587736 587736 Gamul, Robert, of Harborowe, Leics, draper 0
3800764 1958152 1958152 defendant Sexson Thomas mercer 587736 587736 Sexson, Thomas, of Harborowe, Leics, mercer 0
3882204 1984307 1984307 defendant Wodward William gent 587736 587736 Wodward, William, of Harborowe, Leics, gent 0
3964301 2012120 2012120 defendant Haman Richard mercer 587736 587736 Haman, Richard, of Harborowe, Leics, mercer 0
3984744 2019299 2019299 defendant Rose Edward gent 587736 587736 Rose, Edward, of Harborowe, Leics, gent 0
4087982 2055997 2055997 defendant Hamond Richard mercer 587736 587736 Hamond, Richard, of Harborowe, Leics, mercer 0
4143366 2075843 2075843 defendant Bayllies John draper 587736 587736 Bayllies, John, of Harborowe, Leics, draper 1
4187980 2091295 2091295 defendant Bailies John   587736 587736 Bailies, John, of Harborowe, Leics, woollen draper 0
4230944 2106321 2106321 defendant Burton Thomas yeoman 587736 587736 Burton, Thomas, of Harborowe, Leics, yeoman 3
4231379 2106476 2106476 defendant Satterford Francis chapman 587736 587736 Satterford, Francis, of Harborowe, Leics, chapman 2
4263201 2117357 2117357 defendant Satterforde Francis chapman 587736 587736 Satterforde, Francis, of Harborowe, Leics, chapman 2
4279315 2122694 2122694 defendant Shatterford Francis chapman 587736 587736 Shatterford, Francis, of Harborowe, Leics, chapman 0
4310330 2133767 2133767 defendant Walker Jasper innholder 587736 587736 Walker, Jasper, of Harborowe, Leics, innholder 0
4345957 2145848 2145848 defendant Booker Roger butcher 587736 587736 Booker, Roger, of Harborowe, Leics, butcher 0
4913569 2330740 2330740 defendant Page John fisher 587736 587736 Page, John, of Harborowe, Leics, fisher 2
5236169 2426166 2426166 defendant Smyth John   587736 587736 Smyth, John, of Harborowe, Leics, "glyman" 0
5489166 2501644 2501644 defendant Wever John chapman 587736 587736 Wever, John, of Harborowe, Leics, chapman 0
5489607 2501773 2501773 defendant Wever John chapman 587736 587736 Wever, John, of Harborowe, Leics, chapman 0
5489610 2501774 2501774 defendant Wever John chapman 587736 587736 Wever, John, of Harborowe, Leics, chapman 0
5528442 2513431 2513431 defendant Thomlynson William cordwainer 587736 587736 Thomlynson, William, of Harborowe, Leics, cordwainer 1
5555282 2521548 2521548 defendant Malory Simon gent 587736 587736 Malory, Simon, of Harborowe, Leics, gent 4
5586174 2530717 2530717 defendant Foxton Thomas chapman 587736 587736 Foxton, Thomas, of Harborowe, Leics, chapman 2

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