names

30 rows where case_id = 2366004

✎ 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
5031225 2366004 2366004 plaintiff Pylkyngton Robert esq   Pylkyngton, Robert, esq 0
5031226 2366004 2366004 defendant Stansfeld Ralph gent 589469 589469 Stansfeld, Ralph, of Stansfeld, gent 0
5031227 2366004 2366004 defendant Stansfeld John gent 593697 593697 Stansfeld, John, of Hertishede, gent 1
5031228 2366004 2366004 defendant Stansfeld Nicholas gent 589469 589469 Stansfeld, Nicholas, of Stansfeld, gent 2
5031229 2366004 2366004 defendant Stansfeld Peter gent 603641 603641 Stansfeld, Peter, of Langfeld, gent 3
5031230 2366004 2366004 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 4
5031231 2366004 2366004 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 5
5031232 2366004 2366004 defendant Bryg Henry husbandman 589469 589469 Bryg, Henry, of Stansfeld, husbandman 6
5031233 2366004 2366004 defendant Bryg Robert husbandman 589469 589469 Bryg, Robert, of Stansfeld, husbandman 7
5031234 2366004 2366004 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 8
5031235 2366004 2366004 defendant Grenewode John husbandman 837309 837309 Grenewode, John, of Grenewodle, Heptonstall, husbandman 9
5031236 2366004 2366004 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 10
5031237 2366004 2366004 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 11
5031238 2366004 2366004 defendant Smyth John husbandman 781980 781980 Smyth, John, of Saureby, husbandman 12
5031239 2366004 2366004 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 13
5031240 2366004 2366004 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 14
5031241 2366004 2366004 defendant Thomas son of Robertshagh Richard, of Heptonstall, yeoman   Thomas, son of Robertshagh, Richard, of Heptonstall, yeoman 15
5031242 2366004 2366004 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 16
5031243 2366004 2366004 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 17
5031244 2366004 2366004 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 18
5031245 2366004 2366004 defendant Fournesse Ralph yeoman 595368 595368 Fournesse, Ralph, of Halyfax, yeoman 19
5031246 2366004 2366004 defendant Fournesse John yeoman 595368 595368 Fournesse, John, of Halyfax, yeoman 20
5031247 2366004 2366004 defendant Elystones Nicholas yeoman 837314 837314 Elystones, Nicholas, of Ovendon, yeoman 21
5031248 2366004 2366004 defendant Holt Thurstan yeoman 826892 826892 Holt, Thurstan, of Boterworth, Lancs, yeoman 22
5031249 2366004 2366004 defendant Holt Hugh gent 837315 837315 Holt, Hugh, of Aysshworth, Lancs, gent 23
5031250 2366004 2366004 defendant Scolefeld Hugh yeoman 826893 826893 Scolefeld, Hugh, of Boterworth, yeoman 24
5031251 2366004 2366004 defendant Stansfeld James gent 593697 593697 Stansfeld, James, of Hertishede, gent 25
5031252 2366004 2366004 defendant Tounley Miles gent 837316 837316 Tounley, Miles, of Brimlay, Lancs, gent 26
5031253 2366004 2366004 defendant Holt Peter gent 638632 638632 Holt, Peter, of Bury, Lancs, gent 27
5031254 2366004 2366004 defendant Haworth Thomas yeoman 837317 837317 Haworth, Thomas, of Honersfeld, Lancs, yeoman 28

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