names

30 rows where case_id = 2366003

✎ 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
5031195 2366003 2366003 plaintiff Pylkyngton Robert esq   Pylkyngton, Robert, esq 0
5031196 2366003 2366003 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 0
5031197 2366003 2366003 defendant Fournesse Ralph yeoman 600094 600094 Fournesse, Ralph, of Halifax, yeoman 1
5031198 2366003 2366003 defendant Elystones or Glystones Nicholas yeoman 609409 609409 Elystones or Glystones, Nicholas, of Ovenden, yeoman 2
5031199 2366003 2366003 defendant Staunsfeld Ralph gent 589469 589469 together with Staunsfeld, Ralph, of Stansfeld, gent 3
5031200 2366003 2366003 defendant Staunsfeld Nicholas gent 589469 589469 Staunsfeld, Nicholas, of Stansfeld, gent 4
5031201 2366003 2366003 defendant Stansfeld Peter gent 603641 603641 Stansfeld, Peter, of Langfeld, gent 5
5031202 2366003 2366003 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 6
5031203 2366003 2366003 defendant Brig Henry husbandman 589469 589469 Brig, Henry, of Stansfeld, husbandman 7
5031204 2366003 2366003 defendant Brig Robert husbandman 589469 589469 Brig, Robert, of Stansfeld, husbandman 8
5031205 2366003 2366003 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 9
5031206 2366003 2366003 defendant Grenewode John husbandman 837309 837309 Grenewode, John, of Grenewodle, Heptonstall, husbandman 10
5031207 2366003 2366003 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 11
5031208 2366003 2366003 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 12
5031209 2366003 2366003 defendant Smyth John husbandman 781980 781980 Smyth, John, of Saureby, husbandman 13
5031210 2366003 2366003 defendant Robertshagh Richard husbandman 586074 586074 Robertshagh, Richard, of Heptonstall, husbandman 14
5031211 2366003 2366003 defendant Richard son of Robertshagh Richard husbandman 586074 586074 Richard son of Robertshagh, Richard, of Heptonstall, husbandman 15
5031212 2366003 2366003 defendant Thomas son of Robertshagh Richard yeoman 586074 586074 Thomas son of Robertshagh, Richard, of Heptonstall, yeoman 16
5031213 2366003 2366003 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 17
5031214 2366003 2366003 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 18
5031215 2366003 2366003 defendant Aykrode William, junior yeoman 591222 591222 Aykrode, William, junior, of Waddesworth, yeoman 19
5031216 2366003 2366003 defendant Fournesse John yeoman 600094 600094 Fournesse, John, of Halifax, yeoman 20
5031217 2366003 2366003 defendant Holt Thurstan yeoman 826892 826892 Holt, Thurstan, of Boterworth, Lancs, yeoman 21
5031218 2366003 2366003 defendant Holt Hugh gent 837310 837310 Holt, Hugh, of Asshworth, Lancs, gent 22
5031219 2366003 2366003 defendant Scolefeld Hugh yeoman 826893 826893 Scolefeld, Hugh, of Boterworth, yeoman 23
5031220 2366003 2366003 defendant Stansfeld John gent 837311 837311 Stansfeld, John, of Hertished, gent 24
5031221 2366003 2366003 defendant Stansfeld James gent 613063 613063 Stansfeld, James, of Hertyshed, gent 25
5031222 2366003 2366003 defendant Tounley Miles gent 837312 837312 Tounley, Miles, of Brunley, Lancs, gent 26
5031223 2366003 2366003 defendant Holt Peter gent 638632 638632 Holt, Peter, of Bury, Lancs, gent 27
5031224 2366003 2366003 defendant Haworth Robert yeoman 837313 837313 Haworth, Robert, of Hoversfeld, 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);