names

29 rows where place_id = 628246

✎ 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
3781309 1951896 1951896 plaintiff Halse William gent 628246 628246 Halse, William, of heverynglond, gent 0
3903957 1991562 1991562 plaintiff Halfe or Halse Thomas esq 628246 628246 Halfe or Halse, Thomas, of Heverynglond, esq 0
3904018 1991585 1991585 plaintiff Halse Thomas esq 628246 628246 Halse, Thomas, of Heverynglond, esq 0
4440249 2181862 2181862 defendant Taillour Andrew   628246 628246 Taillour, Andrew, of Heverynglond 4
4486623 2196528 2196528 defendant Brigate Simon draper 628246 628246 Brigate, Simon, of Heverynglond, draper 1
4511637 2204090 2204090 defendant Bryggate Simon   628246 628246 Bryggate, Simon, of Heverynglond 0
4522130 2207264 2207264 defendant Draper Simon   628246 628246 Draper, Simon, of Heverynglond 0
4560074 2219096 2219096 defendant Smyth Henry   628246 628246 Smyth, Henry, of Heverynglond 5
4563860 2220267 2220267 defendant Blakeman Walter   628246 628246 Blakeman, Walter, of Heverynglond 0
4582739 2226040 2226040 defendant Draper Simon   628246 628246 Draper, Simon, of Heverynglond 0
4582740 2226040 2226040 defendant Draper John   628246 628246 Draper, John, of Heverynglond, son of Simon 1
4659379 2248794 2248794 plaintiff de Brygate John   628246 628246 de Brygate, John, of Heverynglond 0
4733442 2275634 2275634 defendant Howes Reginald laborer 628246 628246 Howes, Reginald, of Heverynglond, laborer 3
4745827 2279285 2279285 defendant Adams Peter   628246 628246 Adams, Peter, of Heverynglond, wool wright 2
4834952 2306936 2306936 defendant (not given) Edmund prior of Walsyngham 628246 628246 Walsyngham, Edmund, of Heverynglond, prior of the church of St Laurence of Monte Gaudij or Mount Joy 0
5252420 2430866 2430866 defendant Pykerell John husbandman 628246 628246 Pykerell, John, of Heverynglond, husbandman 3
5440776 2487153 2487153 plaintiff Yermoth John (legal representative) 628246 628246 Yermoth, John, of Heverynglond, executors of 0
5453992 2491086 2491086 plaintiff Yermoth John (legal representative) 628246 628246 Yermoth, John, of Heverynglond, executors of 0
5453996 2491087 2491087 plaintiff Yermouth John (legal representative) 628246 628246 Yermouth, John, of Heverynglond, executors of 0
5465880 2494713 2494713 plaintiff Yermouth John (legal representative) 628246 628246 Yermouth, John, of Heverynglond, executors of 0
5489048 2501599 2501599 defendant Baldewyn Edmund   628246 628246 Baldewyn, Edmund, of Heverynglond, shepherd 1
5497237 2504112 2504112 defendant Baldewyn Edmund   628246 628246 Baldewyn, Edmund, of Heverynglond, shepherd 1
5497238 2504112 2504112 defendant Redyng Robert husbandman 628246 628246 Redyng, Robert, of Heverynglond, husbandman 2
5497239 2504112 2504112 defendant Doffe Robert husbandman 628246 628246 Doffe, Robert, of Heverynglond, husbandman 3
5497246 2504113 2504113 defendant Baldewyn Edmund   628246 628246 Baldewyn, Edmund, of Heverynglond, shepherd 2
5518560 2510636 2510636 defendant Bawedewyn Edmund   628246 628246 Bawedewyn, Edmund, of Heverynglond, shepherd 0
5518562 2510637 2510637 defendant Redyng William husbandman 628246 628246 Redyng, William, of Heverynglond, husbandman 0
5518563 2510637 2510637 defendant Peyntour Geoffrey husbandman 628246 628246 Peyntour, Geoffrey, of Heverynglond, husbandman 1
5533669 2515079 2515079 defendant Baudewyn Edmund husbandman 628246 628246 Baudewyn, Edmund, of Heverynglond, husbandman 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);