names

25 rows where place_id = 590465

✎ 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
3601291 1868069 1868069 defendant Watford Ralph gent 590465 590465 Watford, Ralph, of Eyton, Beds, gent 2
3613134 1871761 1871761 defendant Watford Ralph husbandman 590465 590465 Watford, Ralph, of Eyton, Beds, husbandman 1
3620733 1874060 1874060 defendant Watforde Ralph gent 590465 590465 Watforde, Ralph, of Eyton, Beds, gent 0
3837748 1969721 1969721 defendant Bray Reginald esq 590465 590465 Bray, Reginald, of Eyton, Beds, esq 1
3853860 1974839 1974839 defendant Braye Reginald esq 590465 590465 Braye, Reginald, of Eyton, Beds, esq 0
3880417 1983706 1983706 defendant Bray Reginald gent 590465 590465 Bray, Reginald, of Eyton, Beds, gent 1
4011416 2028861 2028861 defendant Whitton John gent 590465 590465 Whitton, John, of Eyton, Beds, gent 0
4258246 2115731 2115731 defendant Jenkyns John yeoman 590465 590465 Jenkyns, John, of Eyton, Beds, yeoman 0
4272534 2120390 2120390 defendant Genkyns John yeoman 590465 590465 Genkyns, John, of Eyton, Beds, yeoman 1
4295636 2128523 2128523 defendant Jenkyns John yeoman 590465 590465 Jenkyns, John, of Eyton, Beds, yeoman 1
4670121 2256357 2256357 plaintiff Broke William maltman 590465 590465 Broke, William, of Eyton, Beds, maltman 0
4670123 2256358 2256358 plaintiff Broke Willim maltman 590465 590465 Broke, Willim, of Eyton, Beds, maltman 0
4717968 2270960 2270960 plaintiff atte Brook William   590465 590465 atte Brook, William, of Eyton, Beds 0
4717973 2270961 2270961 plaintiff atte Brook William   590465 590465 atte Brook, William, of Eyton, Beds 0
5066939 2376636 2376636 defendant Burre John husbandman 590465 590465 Burre, John, of Eyton, Beds, husbandman 1
5305229 2446568 2446568 defendant Freman Thomas smith 590465 590465 Freman, Thomas, of Eyton, Beds, smith 2
5318134 2450515 2450515 defendant Catbery John yeoman 590465 590465 Catbery, John, of Eyton, Beds, yeoman 0
5318136 2450516 2450516 defendant Catebery John yeoman 590465 590465 Catebery, John, of Eyton, Beds, yeoman 0
5340022 2457088 2457088 defendant Fox William yeoman 590465 590465 Fox, William, of Eyton, Beds, yeoman 0
5369514 2466057 2466057 defendant Watford Ralph gent 590465 590465 Watford, Ralph, of Eyton, Beds, gent 0
5463920 2494128 2494128 defendant Wale Robert gent 590465 590465 Wale, Robert, of Eyton, Beds, gent 0
5543797 2518167 2518167 defendant Watford Ralph gent 590465 590465 Watford, Ralph, of Eyton, Beds, gent 0
5557496 2522146 2522146 defendant Watford Ralph gent 590465 590465 Watford, Ralph, of Eyton, Beds, gent 0
5557501 2522148 2522148 defendant Watford Ralph gent 590465 590465 Watford, Ralph, of Eyton, Beds, gent 0
5592847 2532763 2532763 defendant Aleyn Hugh husbandman 590465 590465 Aleyn, Hugh, of Eyton, Beds, 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);