names

27 rows where place_id = 765439

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4517174 2205774 2205774 defendant atte Haghe John   765439 765439 atte Haghe, John, of Covehythe 1
4551354 2216362 2216362 defendant Smyth John   765439 765439 Smyth, John, of Covehythe, son of Thomas 0
4551357 2216363 2216363 defendant Smyth John   765439 765439 Smyth, John, of Covehythe, son of Thomas 0
4575492 2223844 2223844 plaintiff Botyld John   765439 765439 Botyld, John, of Covehythe 0
4585377 2226848 2226848 defendant Mandolf Thomas   765439 765439 Mandolf, Thomas, of Covehythe 0
4590106 2228271 2228271 plaintiff Paukyn William   765439 765439 Paukyn, William, of Covehythe 1
4599816 2231170 2231170 plaintiff Taillour John   765439 765439 Taillour, John, of Covehythe 0
4610028 2234223 2234223 defendant Tokke Robert   765439 765439 Tokke, Robert, of Covehythe 2
4627595 2239563 2239563 defendant Lyme John   765439 765439 Lyme, John, of Covehythe 0
4637454 2242507 2242507 defendant Tucke Walter   765439 765439 Tucke, Walter, of Covehythe 0
4663348 2250009 2250009 defendant de Hill John shipman 765439 765439 de Hill, John, of Covehythe, shipman 0
4663349 2250009 2250009 defendant Alman Roger shipman 765439 765439 Alman, Roger, of Covehythe, shipman 1
4663350 2250009 2250009 defendant Grashoppe John shipman 765439 765439 Grashoppe, John, of Covehythe, shipman 2
4663351 2250009 2250009 defendant Pye John shipman 765439 765439 Pye, John, of Covehythe, shipman 3
4663352 2250009 2250009 defendant Bande or Baude John shipman 765439 765439 Bande or Baude, John, of Covehythe, shipman 4
4663353 2250009 2250009 defendant Holgat John shipman 765439 765439 Holgat, John, of Covehythe, shipman 5
4686497 2261384 2261384 plaintiff Smyth John   765439 765439 Smyth, John, of Covehythe 0
4686498 2261384 2261384 defendant Waryn John shipman 765439 765439 Waryn, John, of Covehythe, shipman 0
4741000 2277879 2277879 defendant Chevele John weaver 765439 765439 Chevele, John, of Covehythe, weaver 2
4742057 2278174 2278174 defendant Gilberd John butcher 765439 765439 Gilberd, John, of Covehythe, butcher 2
4778183 2289163 2289163 defendant Hope William yeoman 765439 765439 Hope, William, of Covehythe, yeoman 0
4886689 2322699 2322699 defendant Shirwode John yeoman 765439 765439 Shirwode, John, of Covehythe, yeoman 3
4892888 2324508 2324508 defendant Bygge Roger laborer 765439 765439 Bygge, Roger, of Covehythe, laborer 0
5080994 2380817 2380817 defendant Whyte Robert yeoman 765439 765439 Whyte, Robert,of Covehythe, yeoman 0
5095671 2385156 2385156 defendant Hulner or Hulver Thomas shipman 765439 765439 Hulner or Hulver, Thomas, of Covehythe, shipman 4
5234981 2425811 2425811 defendant Turnour John husbandman 765439 765439 Turnour, John, of Covehythe, husbandman 2
5375654 2467976 2467976 defendant Geryng John   765439 765439 Geryng, John, of Covehythe, shoe maker 4

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