names

56 rows where place_id = 609542

✎ 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
3678921 1919476 1919476 defendant Padley Roger yeoman 609542 609542 Padley, Roger, of Rotheram, Yorks, yeoman 0
3695656 1924872 1924872 defendant Brodehurst George ironmonger 609542 609542 Brodehurst, George, of Rotheram, Yorks, ironmonger 0
3719436 1932353 1932353 defendant Woller Roger tailor 609542 609542 Woller, Roger, of Rotheram, Yorks, tailor 0
3720896 1932830 1932830 defendant Colyer William   609542 609542 Colyer, William, of Rotheram, Yorks, clerk, fellow of St Johns College, Cambridge 1
3720900 1932831 1932831 defendant Colyer William   609542 609542 Colyer, William, of Rotheram, Yorks, clerk, fellow of St Johns College, Cambridge 1
3774898 1949878 1949878 defendant Gyll Thomas dyer 609542 609542 Gyll, Thomas, of Rotheram, Yorks, dyer 0
3784385 1952894 1952894 defendant Ellys William chapman 609542 609542 Ellys, William, of Rotheram, Yorks, chapman 1
3786720 1953645 1953645 defendant Rawlynson Richard chapman 609542 609542 Rawlynson, Richard, of Rotheram, Yorks, chapman 0
3837980 1969790 1969790 defendant Blyton Edward chapman 609542 609542 Blyton, Edward, of Rotheram, Yorks, chapman 0
3857129 1975860 1975860 defendant Padley Roger chapman 609542 609542 Padley, Roger, of Rotheram, Yorks, chapman 1
3857135 1975861 1975861 defendant Padley Roger chapman 609542 609542 Padley, Roger, of Rotheram, Yorks, chapman 1
3880550 1983753 1983753 defendant Rawlynson Richard clerk 609542 609542 Rawlynson, Richard, of Rotheram, Yorks, clerk 0
3901669 1990786 1990786 defendant Rawlynson Richard chapman 609542 609542 Rawlynson, Richard, of Rotheram, Yorks, chapman 1
3901680 1990788 1990788 defendant Rawlynson Richard yeoman 609542 609542 Rawlynson, Richard, of Rotheram, Yorks, yeoman 0
3934420 2001806 2001806 defendant Cleyton Robert chapman 609542 609542 Cleyton, Robert, of Rotheram, Yorks, chapman 1
3940385 2003803 2003803 defendant Cleyton Hugh chapman 609542 609542 Cleyton, Hugh, of Rotheram, Yorks, chapman 2
3963335 2011777 2011777 defendant Wylson Cuthbert yeoman 609542 609542 Wylson, Cuthbert, of Rotheram, Yorks, yeoman 0
3975303 2015931 2015931 defendant Hyndeman alias Inman Thomas mercer 609542 609542 Hyndeman alias Inman, Thomas, of Rotheram, Yorks, mercer 0
3990514 2021359 2021359 defendant Lyllye henry mercer 609542 609542 Lyllye, henry, of Rotheram, Yorks, mercer 0
4012792 2029298 2029298 defendant Whytmore Richard gent 609542 609542 Whytmore, Richard, of Rotheram, Yorks, gent 0
4014060 2029759 2029759 plaintiff Sapcote Margaret widow 609542 609542 Margaret his wife, alias Margaret Swyft, of Rotheram, Yorks, widow 1
4029795 2035299 2035299 defendant Whitmore Richard gent 609542 609542 Whitmore, Richard, of Rotheram, Yorks, gent 0
4029797 2035300 2035300 defendant Whitmore Richard gent 609542 609542 Whitmore, Richard, of Rotheram, Yorks, gent 0
4088794 2056294 2056294 defendant Cutforthay John cutler 609542 609542 Cutforthay, John, of Rotheram, Yorks, cutler 1
4093405 2057958 2057958 defendant Swifte Robert gent 609542 609542 Swifte, Robert, of Rotheram, Yorks, gent 2
4093417 2057962 2057962 defendant Swift Henry yeoman 609542 609542 Swift, Henry, of Rotheram, Yorks, yeoman 0
4101126 2060716 2060716 defendant Cutforth John chapman 609542 609542 Cutforth, John, of Rotheram, Yorks, chapman 1
4111185 2064252 2064252 defendant Tomlinson Richard chapman 609542 609542 Tomlinson, Richard, of Rotheram, Yorks, chapman 0
4203689 2096848 2096848 defendant Clythe William chapman 609542 609542 Clythe, William, of Rotheram, Yorks, chapman 1
4227694 2105168 2105168 defendant Dickenson Thomas pewterer 609542 609542 Dickenson, Thomas, of Rotheram, Yorks, pewterer 0
4291751 2127126 2127126 defendant Blackenhall Richard gent 609542 609542 Blackenhall, Richard, of Rotheram, Yorks, or of Drayton, Staffs, gent 2
4327300 2139456 2139456 defendant Letchworth John (legal representative) 609542 609542 Letchworth, John, of Rotheram, Yorks, gent, administrator of 3
4899032 2326339 2326339 defendant Barnbe Hugh chapman 609542 609542 Barnbe, Hugh, of Rotheram, Yorks, chapman 0
5247950 2429540 2429540 defendant Flecher Richard husbandman 609542 609542 Flecher, Richard, of Rotheram, Yorks, husbandman 1
5267238 2435516 2435516 defendant Hynkersall John chapman 609542 609542 Hynkersall, John, of Rotheram, Yorks, chapman 1
5267244 2435517 2435517 defendant Hynkyrsall John chapman 609542 609542 Hynkyrsall, John, of Rotheram, Yorks, chapman 1
5285652 2440827 2440827 defendant Oke William yeoman 609542 609542 Oke, William, of Rotheram, Yorks, yeoman 1
5311700 2448521 2448521 defendant Oke William dyer 609542 609542 Oke, William, of Rotheram, Yorks, dyer 0
5383799 2470451 2470451 defendant Holden Robert mercer 609542 609542 Holden, Robert, of Rotheram, Yorks, mercer 0
5395633 2473832 2473832 defendant Holden Robert mercer 609542 609542 Holden, Robert, of Rotheram, Yorks, mercer 0
5408934 2477633 2477633 defendant Holden Robert mercer 609542 609542 Holden, Robert, of Rotheram, Yorks, mercer 0
5422266 2481609 2481609 defendant Holden Robert mercer 609542 609542 Holden, Robert, of Rotheram, Yorks, mercer 0
5442430 2487653 2487653 defendant Payly Richard dyer 609542 609542 Payly, Richard, of Rotheram, Yorks, dyer 0
5493670 2503019 2503019 defendant Taillour William chapman 609542 609542 Taillour, William, of Rotheram, Yorks, chapman 2
5499408 2504763 2504763 defendant Padley William chapman 609542 609542 Padley, William, of Rotheram, Yorks, chapman 2
5499413 2504764 2504764 defendant Padley William chapman 609542 609542 Padley, William, of Rotheram, Yorks, chapman 2
5520614 2511270 2511270 defendant Gurrey William, junior chapman 609542 609542 Gurrey, William, junior, of Rotheram, Yorks, chapman 0
5534163 2515219 2515219 defendant Parker William yeoman 609542 609542 Parker, William, of Rotheram, Yorks, yeoman 0
5545709 2518734 2518734 defendant Carnebull Henry clerk 609542 609542 Carnebull, Henry, of Rotheram, Yorks, clerk 0
5548382 2519561 2519561 defendant Padley Roger chapman 609542 609542 Padley, Roger, of Rotheram, Yorks, chapman 0
5548399 2519566 2519566 defendant Padley Roger chapman 609542 609542 Padley, Roger, of Rotheram, Yorks, chapman 2
5555669 2521653 2521653 defendant Padley Roger chercer 609542 609542 Padley, Roger, of Rotheram, Yorks, chercer 0
5557569 2522168 2522168 defendant Hygdon Ralph pewterer 609542 609542 Hygdon, Ralph, of Rotheram, Yorks, pewterer 0
5557572 2522169 2522169 defendant Hygdon Ralph pewterer 609542 609542 Hygdon, Ralph, of Rotheram, Yorks, pewterer 0
5566589 2524823 2524823 defendant Hanson John innholder 609542 609542 Hanson, John, of Rotheram, Yorks, innholder 0
5593830 2533055 2533055 defendant Gore William innholder 609542 609542 Gore, William, of Rotheram, Yorks, innholder 3

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