names

48 rows where place_id = 602494

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650415 1910498 1910498 defendant Turtill John husbandman 602494 602494 Turtill, John, of Iklyngton, husbandman 4
3703179 1927268 1927268 plaintiff Crudd Richard yeoman 602494 602494 Crudd, Richard, of Iklyngton, yeoman 0
3703180 1927268 1927268 plaintiff Crudd John yeoman 602494 602494 Crudd, John, of Iklyngton, yeoman 1
3703183 1927269 1927269 plaintiff Crudd Richard yeoman 602494 602494 Crudd, Richard, of Iklyngton, yeoman 0
3703184 1927269 1927269 plaintiff Crudd John yeoman 602494 602494 Crudd, John, of Iklyngton, yeoman 1
3717076 1931625 1931625 defendant Atkynson Thomas husbandman 602494 602494 Atkynson, Thomas, of Iklyngton, husbandman 0
3741855 1939317 1939317 defendant Gayler Robert husbandman 602494 602494 Gayler, Robert, of Iklyngton, husbandman 0
3772134 1948976 1948976 defendant Swalder Thomas laborer 602494 602494 Swalder, Thomas, of Iklyngton, laborer 2
3789079 1954395 1954395 defendant Swalder Robert fuller 602494 602494 Swalder, Robert, of Iklyngton, fuller 0
3789080 1954395 1954395 defendant Swalder Thomas fuller 602494 602494 Swalder, Thomas, of Iklyngton, fuller 1
3901640 1990777 1990777 defendant Trappys Thomas glover 602494 602494 Trappys, Thomas, of Iklyngton, glover 0
4503314 2201607 2201607 plaintiff Paul John   602494 602494 Paul, John, of Iklyngton, on his own account 0
4503315 2201607 2201607 defendant Clerke John   602494 602494 Clerke, John, of Iklyngton 0
4555556 2217667 2217667 defendant Pye Robert   602494 602494 Pye, Robert, of Iklyngton 1
4624234 2238565 2238565 defendant Kyllulf Geoffrey   602494 602494 Kyllulf, Geoffrey, of Iklyngton 0
4666218 2250905 2250905 defendant Kyng William corwainer 602494 602494 Kyng, William, of Iklyngton, corwainer 1
4704133 2266671 2266671 defendant Walewys John husbandman 602494 602494 Walewys, John, of Iklyngton, husbandman 1
4757723 2282790 2282790 defendant Katfeld Robert husbandman 602494 602494 Katfeld, Robert, of Iklyngton, husbandman 0
4842188 2309091 2309091 defendant Frogge Henry chaplain 602494 602494 Frogge, Henry, of Iklyngton, chaplain 1
4869001 2317279 2317279 defendant Frenssh John chandler 602494 602494 Frenssh, John, of Iklyngton, chandler 0
4922734 2333524 2333524 defendant Lyon Alexander husbandman 602494 602494 Lyon, Alexander, of Iklyngton, husbandman 0
4956218 2343820 2343820 defendant Chercheman Ralph ostler 602494 602494 Chercheman, Ralph, of Iklyngton, ostler 2
4986170 2352788 2352788 defendant Brabson Thomas butcher 602494 602494 Brabson, Thomas, of Iklyngton, butcher 0
5020594 2362913 2362913 defendant Munde John (legal representative) 602494 602494 Munde, John, of Iklyngton, executors of 0
5020595 2362913 2362913 defendant Munde John husbandman 602494 602494 (Munde, John, of Iklyngton, husbandman 1
5020596 2362913 2362913 defendant Munde Joan widow 602494 602494 Munde, Joan, of Iklyngton, widow 2
5048151 2371073 2371073 plaintiff Pyrry Alice   602494 602494 Pyrry, Alice, of Iklyngton, prioress 0
5063595 2375644 2375644 defendant Brabson Thomas butcher 602494 602494 Brabson, Thomas, of Iklyngton, butcher 3
5063604 2375647 2375647 defendant Brabson Thomas butcher 602494 602494 Brabson, Thomas, of Iklyngton, butcher 3
5103385 2387419 2387419 defendant Heyward Richard husbandman 602494 602494 Heyward, Richard, of Iklyngton, husbandman 0
5103388 2387419 2387419 defendant Fuller John husbandman 602494 602494 Fuller, John, of Iklyngton, husbandman 3
5114456 2390626 2390626 defendant Louton John yeoman 602494 602494 Louton, John, of Iklyngton, yeoman 2
5154907 2402594 2402594 defendant Payn John miller 602494 602494 Payn, John, of Iklyngton, miller 4
5171761 2407462 2407462 defendant Payn John miller 602494 602494 Payn, John, of Iklyngton, miller 4
5187870 2412166 2412166 defendant Brabson Thomas husbandman 602494 602494 Brabson, Thomas, of Iklyngton, husbandman 0
5190481 2412960 2412960 defendant Payn John miller 602494 602494 Payn, John, of Iklyngton, miller 4
5205772 2417427 2417427 defendant Brabson Thomas husbandman 602494 602494 Brabson, Thomas, of Iklyngton, husbandman 0
5206955 2417770 2417770 defendant Payn John miller 602494 602494 Payn, John, of Iklyngton, miller 2
5240167 2427327 2427327 defendant Gerveys John   602494 602494 Gerveys, John, of Iklyngton, shepherd 2
5247380 2429390 2429390 defendant Garde Thomas husbandman 602494 602494 Garde, Thomas, of Iklyngton, husbandman 3
5277734 2438574 2438574 defendant Aunflete Robert carpenter 602494 602494 Aunflete, Robert, of Iklyngton, carpenter 0
5277735 2438574 2438574 defendant Gardyner Thomas husbandman 602494 602494 Gardyner, Thomas, of Iklyngton, husbandman 1
5284395 2440454 2440454 defendant Fuller William husbandman 602494 602494 Fuller, William, of Iklyngton, husbandman 3
5284401 2440455 2440455 defendant Fuller William husbandman 602494 602494 Fuller, William, of Iklyngton, husbandman 3
5387820 2471577 2471577 defendant Ungham John husbandman 602494 602494 Ungham, John, of Iklyngton, husbandman 3
5431636 2484420 2484420 plaintiff Kyng William   602494 602494 Kyng, William, of Iklyngton, administrators of 0
5526726 2512926 2512926 defendant Garrard Thomas yeoman 602494 602494 Garrard, Thomas, of Iklyngton, yeoman 1
5616060 2548818 2548818 defendant atte Style John   602494 602494 atte Style, John, of Iklyngton, son of Thomas 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);