names

24 rows where place_id = 591914

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605958 1869525 1869525 defendant Pakman Thomas smith 591914 591914 Pakman, Thomas, of Witham, Essex, smith 0
3622566 1874593 1874593 defendant Brokeman John esq 591914 591914 Brokeman, John, of Witham, Essex, esq 1
3659470 1913219 1913219 defendant Makyn John yeoman 591914 591914 Makyn, John, of Witham, Essex, yeoman 1
3685259 1921544 1921544 defendant de Salvo John merchant 591914 591914 de Salvo, John, of Witham, Essex, merchant 0
3685262 1921545 1921545 defendant de Salvo John merchant 591914 591914 de Salvo, John, of Witham, Essex, merchant 0
3962139 2011339 2011339 defendant Songer Jerome gent 591914 591914 Songer, Jerome, of Witham, Essex, gent 1
3988533 2020643 2020643 defendant Brokeman John (legal representative) 591914 591914 Brokeman, John, of Witham, Essex, esq, executor of 0
4131239 2071493 2071493 plaintiff Lamberd Christian widow of Henry Hame or Haine 591914 591914 Christian his wife, widow of Henry Hame or Haine, of Witham, Essex 1
4133343 2072248 2072248 defendant Songer Roke gent 591914 591914 Songer, Roke, of Witham, Essex, gent 0
4341607 2144340 2144340 defendant Sammes Thomas yeoman 591914 591914 Sammes, Thomas, of Witham, Essex, yeoman 0
4720135 2271641 2271641 defendant Estcourt William clerk 591914 591914 Estcourt, William, of Witham, Essex, clerk 1
4770675 2286809 2286809 defendant Basset Thomas gent 591914 591914 Basset, Thomas, of Witham, Essex, gent 0
4814211 2300550 2300550 defendant Ilam William yeoman 591914 591914 Ilam, William, of Witham, Essex, yeoman 2
4871140 2317951 2317951 defendant atte Wode William husbandman 591914 591914 atte Wode, William, of Witham, Essex, husbandman 1
5117394 2391520 2391520 defendant Dyer Robert dyer 591914 591914 Dyer, Robert, of Witham, Essex, dyer 0
5155401 2402731 2402731 defendant Lamport Joan widow 591914 591914 Lamport, Joan, of Witham, Essex, widow 0
5300976 2445245 2445245 defendant Graveley William clothman 591914 591914 Graveley, William, of Witham, Essex, clothman 0
5461760 2493459 2493459 defendant Watir Robert husbandman 591914 591914 Watir, Robert, of Witham, Essex, husbandman 0
5473271 2496969 2496969 defendant Watir Robert husbandman 591914 591914 Watir, Robert, of Witham, Essex, husbandman 0
5473273 2496970 2496970 defendant Watyr Robert   591914 591914 Watyr, Robert, of Witham, Essex 0
5492657 2502717 2502717 defendant Clyfton Robert husbandman 591914 591914 Clyfton, Robert, of Witham, Essex, husbandman 1
5541826 2517556 2517556 defendant Grene John gent 591914 591914 Grene, John, of Witham, Essex, gent 0
5545183 2518595 2518595 defendant Tregold John yeoman 591914 591914 Tregold, John, of Witham, Essex, yeoman 2
5551380 2520439 2520439 defendant Quyk John yeoman 591914 591914 Quyk, John, of Witham, Essex, yeoman 0

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