names

18 rows where case_id = 2390258

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5113200 2390258 2390258 plaintiff Knotte John, senior   586986 586986 Knotte, John, senior, of Lewys, attorney 0
5113201 2390258 2390258 defendant atte Melle Robert butcher 587695 587695 atte Melle, Robert,of Buxsted, butcher 0
5113202 2390258 2390258 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 1
5113203 2390258 2390258 defendant atte Stone Richard husbandman 616296 616296 atte Stone, Richard, of Isfeld, husbandman 2
5113204 2390258 2390258 defendant Broket Richard husbandman 593519 593519 Broket, Richard, of Est Grensted, husbandman 3
5113205 2390258 2390258 defendant atte Wode Robert husbandman 593312 593312 atte Wode, Robert, of Seford, husbandman 4
5113206 2390258 2390258 defendant Lecche Roger husbandman 596221 596221 Lecche, Roger, of Lytlyngton, husbandman 5
5113207 2390258 2390258 defendant Hendyman William tailor 591037 591037 Hendyman, William, of Westham, tailor 6
5113208 2390258 2390258 defendant Webbe William husbandman 589813 589813 Webbe, William, of Camerwell, Surrey, husbandman 7
5113209 2390258 2390258 defendant Mason Thomas husbandman 588882 588882 Mason, Thomas, of Retherfeld, husbandman 8
5113210 2390258 2390258 defendant Cheseman Thomas chapman 586986 586986 Cheseman, Thomas, of Lewys, chapman 9
5113211 2390258 2390258 defendant atte Hole John husbandman 799055 799055 atte Hole, John, of West Hertyng, husbandman 10
5113212 2390258 2390258 defendant Bryghtnot Thomas husbandman 589163 589163 Bryghtnot, Thomas, of Boreham, husbandman 11
5113213 2390258 2390258 defendant Benke John husbandman 753056 753056 Benke, John, of West-, husbandman 12
5113214 2390258 2390258 defendant Pylgrym John sherman 586986 586986 Pylgrym, John, of Lewys, sherman 13
5113215 2390258 2390258 defendant Cooke John draper 636419 636419 Cooke, John, of Chytynglegh, draper 14
5113216 2390258 2390258 defendant Mone John dyer 595192 595192 Mone, John, of Lee, dyer 15
5113217 2390258 2390258 defendant Freke John clerk 603399 603399 Freke, John, of Marsfeld, clerk 16

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