names

34 rows where place_id = 651640

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3919029 1996689 1996689 defendant Hamson Henry yeoman 651640 651640 Hamson, Henry, of Bradewell, yeoman 0
4413858 2169232 2169232 defendant Ballard Richard   651640 651640 Ballard, Richard, of Bradewell 2
4416240 2169967 2169967 defendant Dunnyng John, junior   651640 651640 Dunnyng, John, junior, of Bradewell 0
4424550 2172515 2172515 defendant Cook John le   651640 651640 Cook, John le, of Bradewell 0
4431526 2174629 2174629 defendant Sekyn John   651640 651640 Sekyn, John, of Bradewell 0
4431570 2174643 2174643 defendant Sekyn John   651640 651640 Sekyn, John, of Bradewell 0
4434917 2175679 2175679 defendant Dunyng John, junior   651640 651640 Dunyng, John, junior, of Bradewell 0
4436635 2176197 2176197 defendant Banham William de   651640 651640 Banham, William de, of Bradewell 0
4527614 2208916 2208916 defendant Boteler John   651640 651640 Boteler, John, of Bradewell, son of Peter 0
4543389 2213820 2213820 defendant Evesham John   651640 651640 Evesham, John, of Bradewell 0
4580745 2225459 2225459 plaintiff Dersham Geoffrey   651640 651640 Dersham, Geoffrey, of Bradewell, parson 0
4609200 2233983 2233983 defendant Smyth Henry   651640 651640 Smyth, Henry, of Bradewell 0
4609202 2233984 2233984 defendant Smyth Henry   651640 651640 Smyth, Henry, of Bradewell 0
4666336 2250944 2250944 defendant Vycaryes Richard husbandman 651640 651640 Vycaryes, Richard, of Bradewell, husbandman 0
4666715 2255316 2255316 defendant Pecok John yeoman 651640 651640 Pecok, John, of Bradewell, yeoman 0
4669814 2256262 2256262 defendant Bailly Richard   651640 651640 Bailly, Richard, of Bradewell 0
4691731 2262945 2262945 defendant Brodhook Thomas husbandman 651640 651640 Brodhook, Thomas, of Bradewell, husbandman 2
4694038 2263641 2263641 defendant Baylly John husbandman 651640 651640 Baylly, John, of Bradewell, husbandman 1
4716778 2270570 2270570 defendant atte Strete Roger   651640 651640 atte Strete, Roger, of Bradewell, plough man 2
4735988 2276401 2276401 defendant Boof Thomas clerk 651640 651640 Boof, Thomas, of Bradewell, clerk 0
4754124 2281668 2281668 defendant Ruffe John, senior husbandman 651640 651640 Ruffe, John, senior, of Bradewell, husbandman 0
4758015 2282881 2282881 defendant Humbilby John husbandman 651640 651640 Humbilby, John, of Bradewell, husbandman 1
4795590 2294772 2294772 defendant Frensshe Richard clerk 651640 651640 Frensshe, Richard, of Bradewell, clerk 0
4817869 2301673 2301673 defendant Boef Thomas clerk 651640 651640 Boef, Thomas, of Bradewell, clerk 0
4846904 2310541 2310541 defendant Shipherd John laborer 651640 651640 Shipherd, John, of Bradewell, laborer 1
4954554 2343317 2343317 defendant Whitreke John (legal representative) 651640 651640 Whitreke, John, of Bradewell, fuller, administratrix of 0
4954555 2343317 2343317 defendant Whitreke Margaret widow 651640 651640 Whitreke, Margaret, of Bradewell, widow 1
4971054 2348282 2348282 defendant Bocher Simon butcher 651640 651640 Bocher, Simon, of Bradewell, butcher 2
5345869 2458842 2458842 defendant Wattys Henry husbandman 651640 651640 Wattys, Henry, of Bradewell, husbandman 1
5462038 2493541 2493541 plaintiff Packer William chaplain 651640 651640 Packer, William, of Bradewell, chaplain 0
5577337 2527970 2527970 defendant Howes John yeoman 651640 651640 Howes, John, of Bradewell, yeoman 0
5603349 2535937 2535937 defendant Jakson John yeoman 651640 651640 Jakson, John, of Bradewell, yeoman 0
5625563 2551939 2551939 defendant Vycaryes Richard husbandman 651640 651640 Vycaryes, Richard, of Bradewell, husbandman 0
5631191 2553765 2553765 defendant Hunne Richard laborer 651640 651640 Hunne, Richard, of Bradewell, laborer 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);