names

30 rows where case_id = 2366005

✎ 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
5031255 2366005 2366005 plaintiff Pylkyngton Robert esq   Pylkyngton, Robert, esq 0
5031256 2366005 2366005 defendant Stansfeld Ralph gent 589469 589469 Stansfeld, Ralph, of Stansfeld, gent 0
5031257 2366005 2366005 defendant Stansfeld John gent 593697 593697 Stansfeld, John, of Hertishede, gent 1
5031258 2366005 2366005 defendant Stansfeld Nicholas gent 589469 589469 Stansfeld, Nicholas, of Stansfeld, gent 2
5031259 2366005 2366005 defendant Stansfeld Peter gent 603641 603641 Stansfeld, Peter, of Langfeld, gent 3
5031260 2366005 2366005 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 4
5031261 2366005 2366005 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 5
5031262 2366005 2366005 defendant Bryg Henry husbandman 589469 589469 Bryg, Henry, of Stansfeld, husbandman 6
5031263 2366005 2366005 defendant Bryg Robert husbandman 589469 589469 Bryg, Robert, of Stansfeld, husbandman 7
5031264 2366005 2366005 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 8
5031265 2366005 2366005 defendant Grenewode John husbandman 837309 837309 Grenewode, John, of Grenewodle, Heptonstall, husbandman 9
5031266 2366005 2366005 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 10
5031267 2366005 2366005 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 11
5031268 2366005 2366005 defendant Smyth John husbandman 781980 781980 Smyth, John, of Saureby, husbandman 12
5031269 2366005 2366005 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 13
5031270 2366005 2366005 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 14
5031271 2366005 2366005 defendant Thomas son of Robertshagh Richard, of Heptonstall, yeoman   Thomas, son of Robertshagh, Richard, of Heptonstall, yeoman 15
5031272 2366005 2366005 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 16
5031273 2366005 2366005 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 17
5031274 2366005 2366005 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 18
5031275 2366005 2366005 defendant Fournesse Ralph yeoman 595368 595368 Fournesse, Ralph, of Halyfax, yeoman 19
5031276 2366005 2366005 defendant Fournesse John yeoman 595368 595368 Fournesse, John, of Halyfax, yeoman 20
5031277 2366005 2366005 defendant Elystones Nicholas yeoman 837314 837314 Elystones, Nicholas, of Ovendon, yeoman 21
5031278 2366005 2366005 defendant Holt Thurstan yeoman 826892 826892 Holt, Thurstan, of Boterworth, Lancs, yeoman 22
5031279 2366005 2366005 defendant Holt Hugh gent 837315 837315 Holt, Hugh, of Aysshworth, Lancs, gent 23
5031280 2366005 2366005 defendant Scolefeld Hugh yeoman 826893 826893 Scolefeld, Hugh, of Boterworth, yeoman 24
5031281 2366005 2366005 defendant Stansfeld James gent 593697 593697 Stansfeld, James, of Hertishede, gent 25
5031282 2366005 2366005 defendant Tounley Miles gent 837316 837316 Tounley, Miles, of Brimlay, Lancs, gent 26
5031283 2366005 2366005 defendant Holt Peter gent 638632 638632 Holt, Peter, of Bury, Lancs, gent 27
5031284 2366005 2366005 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);