names

51 rows where place_id = 617472

✎ 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
3719699 1932428 1932428 defendant Walesby Stephen laborer 617472 617472 Walesby, Stephen, of Aspeden, laborer 0
3894656 1988419 1988419 defendant Typler William husbandman 617472 617472 Typler, William, of Aspeden, husbandman 0
3971288 2014514 2014514 defendant Snowe William yeoman 617472 617472 Snowe, William, of Aspeden, yeoman 0
4141206 2075083 2075083 defendant Waters Henry maltman 617472 617472 Waters, Henry, of Aspeden, maltman 0
4172773 2085936 2085936 defendant Waters Henry maltman 617472 617472 Waters, Henry, of Aspeden, maltman 0
4172775 2085937 2085937 defendant Waters Henry maltman 617472 617472 Waters, Henry, of Aspeden, maltman 0
4179060 2088149 2088149 defendant Waters Henry maltman 617472 617472 Waters, Henry, of Aspeden, maltman 0
4214983 2100742 2100742 defendant Cherrye William yeoman 617472 617472 Cherrye, William, of Aspeden, yeoman 0
4214986 2100743 2100743 defendant Cherrye William yeoman 617472 617472 Cherrye, William, of Aspeden, yeoman 0
4417077 2170210 2170210 defendant Bryan Walter   617472 617472 Bryan, Walter, of Aspeden 1
4484927 2195983 2195983 plaintiff Scarburh John   617472 617472 Scarburh, John, of Aspeden 1
4484931 2195984 2195984 plaintiff Scarburh John   617472 617472 Scarburh, John, of Aspeden 1
4512687 2204400 2204400 defendant atte Hylle Richard   617472 617472 atte Hylle, Richard, of Aspeden 0
4520410 2206728 2206728 defendant atte Hylle Richard   617472 617472 atte Hylle, Richard, of Aspeden 0
4520412 2206729 2206729 defendant atte Hylle Richard   617472 617472 atte Hylle, Richard, of Aspeden 0
4520833 2206858 2206858 defendant atte Hylle Richard   617472 617472 atte Hylle, Richard, of Aspeden 0
4553438 2217004 2217004 defendant Cawode William   617472 617472 Cawode, William, of Aspeden 0
4553439 2217004 2217004 defendant Child Lucy or Luke   617472 617472 Child, Lucy or Luke, of Aspeden 1
4553440 2217004 2217004 defendant atte Hull William   617472 617472 atte Hull, William, of Aspeden 2
4567391 2221361 2221361 plaintiff Tebaud Robert maltman 617472 617472 Tebaud, Robert, of Aspeden, maltman 0
4573712 2223295 2223295 defendant Broy Eustace   617472 617472 Broy, Eustace, of Aspeden 0
4578001 2224625 2224625 defendant atte Ponde Walter   617472 617472 atte Ponde, Walter, of Aspeden 0
4578002 2224625 2224625 defendant Longe John   617472 617472 Longe, John, of Aspeden 1
4590956 2228526 2228526 defendant Malyn John   617472 617472 Malyn, John, of Aspeden 0
4592886 2229102 2229102 defendant Longe John   617472 617472 Longe, John, of Aspeden 1
4714000 2269706 2269706 plaintiff Tebaud Robert   617472 617472 Tebaud, Robert, of Aspeden 0
4798456 2295699 2295699 defendant Tebowt Robert husbandman 617472 617472 Tebowt, Robert, of Aspeden, husbandman 1
4801223 2296566 2296566 defendant Tebaud Robert husbandman 617472 617472 Tebaud, Robert, of Aspeden, husbandman 0
4880151 2320705 2320705 defendant Tebaud William loader 617472 617472 Tebaud, William, of Aspeden, loader 0
4895121 2325135 2325135 defendant Tebaud Ralph husbandman 617472 617472 Tebaud, Ralph, of Aspeden, husbandman 0
4895122 2325135 2325135 defendant Tebaud William maltman 617472 617472 Tebaud, William, of Aspeden, maltman 1
4959495 2344807 2344807 defendant FitzRauffe William gent 617472 617472 FitzRauffe, William, of Aspeden, gent 0
4987670 2353274 2353274 defendant fitz Raff William gent 617472 617472 fitz Raff, William, of Aspeden, gent 0
4987671 2353274 2353274 defendant Archer William barker 617472 617472 Archer, William, of Aspeden, barker 1
4987673 2353274 2353274 defendant Farneham John laborer 617472 617472 Farneham, John, of Aspeden, laborer 3
5007140 2358976 2358976 defendant fitz Raff William gent 617472 617472 fitz Raff, William, of Aspeden, gent 0
5007141 2358976 2358976 defendant Archer William baker 617472 617472 Archer, William, of Aspeden, baker 1
5007143 2358976 2358976 defendant Farneham John laborer 617472 617472 Farneham, John, of Aspeden, laborer 3
5035499 2367243 2367243 defendant Morley Thomas gent 617472 617472 Morley, Thomas, of Aspeden, gent 1
5055561 2373240 2373240 defendant Howe Robert husbandman 617472 617472 Howe, Robert, of Aspeden, husbandman 1
5055563 2373240 2373240 defendant Howe John husbandman 617472 617472 Howe, John, of Aspeden, husbandman 3
5187695 2412118 2412118 defendant Abbot Luke laborer 617472 617472 Abbot, Luke, of Aspeden, laborer 3
5205675 2417403 2417403 defendant Abbot Luke laborer 617472 617472 Abbot, Luke, of Aspeden, laborer 3
5217743 2420919 2420919 defendant Gebbe William husbandman 617472 617472 Gebbe, William, of Aspeden, husbandman 1
5220374 2421655 2421655 defendant Spycer Robert husbandman 617472 617472 Spycer, Robert, of Aspeden, husbandman 0
5220375 2421655 2421655 defendant Abbot John husbandman 617472 617472 Abbot, John, of Aspeden, husbandman 1
5296095 2443847 2443847 defendant Miles Robert barker 617472 617472 Miles, Robert, of Aspeden, barker 0
5319500 2450924 2450924 defendant Hoo William husbandman 617472 617472 Hoo, William, of Aspeden, husbandman 1
5320502 2451216 2451216 defendant Fernham Roger berker 617472 617472 Fernham, Roger, of Aspeden, berker 1
5557055 2522020 2522020 defendant Mylys Robert husbandman 617472 617472 Mylys, Robert, of Aspeden, husbandman 1
5557058 2522021 2522021 defendant Mylys Robert husbandman 617472 617472 Mylys, Robert, of Aspeden, husbandman 1

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