names

45 rows where place_id = 590898

✎ 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
3602660 1868497 1868497 defendant Skerne John husbandman 590898 590898 Skerne, John, of Kyllom, husbandman 0
3602661 1868497 1868497 defendant Lame John husbandman 590898 590898 Lame, John, of Kyllom, husbandman 1
3602662 1868497 1868497 defendant Wraughan Robert husbandman 590898 590898 Wraughan, Robert, of Kyllom, husbandman 2
3602663 1868497 1868497 defendant Scayffe John husbandman 590898 590898 Scayffe, John, of Kyllom, husbandman 3
3683263 1920886 1920886 defendant Brekham John yeoman 590898 590898 Brekham, John, of Kyllom, yeoman 0
3781847 1952069 1952069 defendant Howe William husbandman 590898 590898 Howe, William, of Kyllom, husbandman 0
3831702 1967816 1967816 defendant Moldson William yeoman 590898 590898 Moldson, William, of Kyllom, yeoman 0
3943781 2004936 2004936 defendant Bawne George gent 590898 590898 Bawne, George, of Kyllom, gent 2
3944582 2005204 2005204 defendant See Sebastian gent 590898 590898 See, Sebastian, of Kyllom, gent 0
3944584 2005204 2005204 defendant Nicholson Thomas weaver 590898 590898 Nicholson, Thomas, of Kyllom, weaver 2
3944585 2005204 2005204 defendant Fusdale John miller 590898 590898 Fusdale, John, of Kyllom, miller 3
3944586 2005204 2005204 defendant Pickeryng Roger laborer 590898 590898 Pickeryng, Roger, of Kyllom, laborer 4
3944593 2005205 2005205 defendant Sharper Thomas yeoman 590898 590898 Sharper, Thomas, of Kyllom, yeoman 0
3986605 2019947 2019947 defendant Fenby Thomas yeoman 590898 590898 Fenby, Thomas, of Kyllom, yeoman 0
3998004 2024045 2024045 defendant Bawne George yeoman 590898 590898 Bawne, George, of Kyllom, yeoman 0
4110555 2064037 2064037 plaintiff Scothorpe Thomas yeoman 590898 590898 Scothorpe, Thomas, of Kyllom, yeoman 0
4251721 2113565 2113565 defendant Gryme Christopher chapman 590898 590898 Gryme, Christopher, of Kyllom, chapman 0
4515123 2205144 2205144 plaintiff Chapman William   590898 590898 Chapman, William, of Kyllom 0
4515124 2205144 2205144 defendant Alanson Thomas   590898 590898 Alanson, Thomas, of Kyllom 0
4750057 2280487 2280487 defendant Proctor John yeoman 590898 590898 Proctor, John, of Kyllom, yeoman 1
4751002 2280773 2280773 defendant Sjkyrne Robert yeoman 590898 590898 Sjkyrne, Robert, of Kyllom, yeoman 0
4770154 2286635 2286635 defendant Kelke Thomas laborer 590898 590898 Kelke, Thomas, of Kyllom, laborer 0
4772495 2287361 2287361 defendant Edus Richard husbandman 590898 590898 Edus, Richard, of Kyllom, husbandman 0
4778446 2289237 2289237 defendant Hustethwayte Agnes widow 590898 590898 Hustethwayte, Agnes, of Kyllom, widow 3
4787447 2292144 2292144 defendant Redhed Agnes widow 590898 590898 Redhed, Agnes, of Kyllom, widow 4
4846698 2310475 2310475 defendant Crosse Robert husbandman 590898 590898 Crosse, Robert, of Kyllom, husbandman 2
4878740 2320288 2320288 defendant Bewyke John laborer 590898 590898 Bewyke, John, of Kyllom, laborer 2
4898592 2326206 2326206 defendant Schowefe Alan husbandman 590898 590898 Schowefe, Alan, of Kyllom, husbandman 0
4922566 2333474 2333474 defendant Louthorp John couper 590898 590898 Louthorp, John, of Kyllom, couper 0
4939234 2338658 2338658 defendant Damyot William gent 590898 590898 Damyot, William, of Kyllom, gent 0
4939235 2338658 2338658 defendant Swale George gent 590898 590898 Swale, George, of Kyllom, gent 1
4939237 2338658 2338658 defendant Delyng John husbandman 590898 590898 Delyng, John, of Kyllom, husbandman 3
4939238 2338658 2338658 defendant Randolfe John husbandman 590898 590898 Randolfe, John, of Kyllom, husbandman 4
4939240 2338659 2338659 defendant Hall Margaret widow 590898 590898 Hall, Margaret, of Kyllom, widow 0
5003101 2357810 2357810 defendant Dryng William yeoman 590898 590898 Dryng, William, of Kyllom, yeoman 1
5006033 2358652 2358652 defendant Waryn Thomas husbandman 590898 590898 Waryn, Thomas, of Kyllom, husbandman 3
5032436 2366369 2366369 defendant Grendall john chaplain 590898 590898 Grendall, john, of Kyllom, chaplain 1
5032438 2366370 2366370 defendant Makhay Robert   590898 590898 Makhay, Robert, of Kyllom, parish clerk 0
5032443 2366372 2366372 defendant Norman William husbandman 590898 590898 Norman, William, of Kyllom, husbandman 0
5048580 2371217 2371217 defendant How John husbandman 590898 590898 How, John, of Kyllom, husbandman 0
5124450 2393611 2393611 defendant Schap--an William   590898 590898 Schap--an, William, of Kyllom 0
5124451 2393611 2393611 defendant Wyghton Joan widow 590898 590898 Wyghton, Joan, of Kyllom, widow 1
5270018 2436339 2436339 defendant D--- John husbandman 590898 590898 D---, John, of Kyllom, husbandman 2
5394360 2473454 2473454 defendant Foster William yeoman 590898 590898 Foster, William, of Kyllom, yeoman 0
5491536 2502353 2502353 defendant Hylle John yeoman 590898 590898 Hylle, John, of Kyllom, yeoman 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);