names

57 rows where place_id = 592718

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608625 1870359 1870359 defendant Halle John husbandman 592718 592718 Halle, John, of South Mymmes, Middx, husbandman 1
3747388 1941098 1941098 defendant Dey Thomas yeoman 592718 592718 Dey, Thomas, of South Mymmes, Middx, yeoman 2
3768664 1947844 1947844 defendant Gilberd John laborer 592718 592718 Gilberd, John, of South Mymmes, Middx, laborer 6
3779357 1951266 1951266 defendant Bell Henry yeoman 592718 592718 Bell, Henry, of South Mymmes, Middx, yeoman 0
3802982 1958832 1958832 defendant Day Thomas yeoman 592718 592718 Day, Thomas, of South Mymmes, Middx, yeoman 0
3893116 1987944 1987944 defendant Cerlys John carpenter 592718 592718 Cerlys, John, of South Mymmes, Middx, carpenter 0
3947406 2006167 2006167 defendant Robsart Arthur gent 592718 592718 (Robsart, Arthur, of South Mymmes, Middx, gent 1
3955403 2008955 2008955 defendant Robsert Arthur gent 592718 592718 Robsert, Arthur, of South Mymmes, Middx, gent 1
3979279 2017337 2017337 defendant Robsart Arthur gent 592718 592718 Robsart, Arthur, of South Mymmes, Middx, gent 0
4074277 2051098 2051098 defendant Howe William collier 592718 592718 (Howe, William, of South Mymmes, Middx, collier 2
4099281 2060068 2060068 defendant Boden John yeoman 592718 592718 Boden, John, of South Mymmes, Middx, yeoman 1
4309131 2133349 2133349 defendant Gruble Edward yeoman 592718 592718 Gruble, Edward, of South Mymmes, Middx, yeoman 1
4729046 2274318 2274318 defendant West Andrew   592718 592718 West, Andrew, of South Mymmes, Middx, vicar 0
4764840 2284983 2284983 defendant Coupewode William maltman 592718 592718 Coupewode, William, of South Mymmes, Middx, maltman 0
4788937 2292594 2292594 defendant Coupewode William maltman 592718 592718 Coupewode, William, of South Mymmes, Middx, maltman 0
4879701 2320569 2320569 defendant Rutlond John drover 592718 592718 Rutlond, John, of South Mymmes, Middx, drover 4
4896067 2325428 2325428 defendant Crane John smith 592718 592718 Crane, John, of South Mymmes, Middx, smith 0
5041741 2369132 2369132 defendant Dey John husbandman 592718 592718 Dey, John, of South Mymmes, Middx, husbandman 1
5102407 2387107 2387107 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5102598 2387167 2387167 defendant Carpenter Richard husbandman 592718 592718 Carpenter, Richard, of South Mymmes, Middx, husbandman 1
5105605 2388090 2388090 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5109165 2389103 2389103 defendant Vernown Thomas yeoman 592718 592718 Vernown, Thomas, of South Mymmes, Middx, yeoman 0
5123586 2393354 2393354 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5137779 2397560 2397560 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5137782 2397561 2397561 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5141541 2398641 2398641 defendant Rotelond William laborer 592718 592718 Rotelond, William, of South Mymmes, Middx, laborer 2
5158475 2403598 2403598 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5162652 2404797 2404797 defendant Rotelond William laborer 592718 592718 Rotelond, William, of South Mymmes, Middx, laborer 2
5174035 2408104 2408104 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5174038 2408105 2408105 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5194351 2414079 2414079 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5194354 2414080 2414080 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5198939 2415443 2415443 defendant Frowyke Henry esq 592718 592718 Frowyke, Henry, of South Mymmes, Middx, esq 0
5208713 2418273 2418273 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5220431 2421672 2421672 defendant Hebbenge William clerk 592718 592718 Hebbenge, William, of South Mymmes, Middx, clerk 1
5250581 2430291 2430291 defendant Graunt John gent 592718 592718 Graunt, John, of South Mymmes, Middx, gent 0
5278441 2438801 2438801 defendant Warner John tailor 592718 592718 Warner, John, of South Mymmes, Middx, tailor 2
5287751 2441441 2441441 defendant Wryght Richard husbandman 592718 592718 Wryght, Richard, of South Mymmes, Middx, husbandman 0
5295918 2443795 2443795 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5300284 2445044 2445044 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5310641 2448219 2448219 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5319543 2450940 2450940 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5319545 2450941 2450941 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5325939 2452847 2452847 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5326891 2453118 2453118 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5332102 2454678 2454678 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5336690 2456043 2456043 defendant Spencer William   592718 592718 Spencer, William, of South Mymmes, Middx, tile maker 1
5382436 2470036 2470036 defendant Michell James collier 592718 592718 Michell, James, of South Mymmes, Middx, collier 0
5388958 2471899 2471899 defendant Chyld Philip husbandman 592718 592718 Chyld, Philip, of South Mymmes, Middx, husbandman 4
5395098 2473666 2473666 defendant Canon William   592718 592718 Canon, William, of South Mymmes, Middx, malt man 3
5399080 2474808 2474808 defendant Canon William laborer 592718 592718 Canon, William, of South Mymmes, Middx, laborer 2
5400422 2475191 2475191 defendant Frowyk Henry esq 592718 592718 Frowyk, Henry, of South Mymmes, Middx, esq 0
5401628 2475533 2475533 defendant Chyld Philip husbandman 592718 592718 Chyld, Philip, of South Mymmes, Middx, husbandman 4
5419941 2480880 2480880 defendant Nycoll Thomas wheeler 592718 592718 Nycoll, Thomas, of South Mymmes, Middx, wheeler 7
5419942 2480880 2480880 defendant Fynmore John collier 592718 592718 Fynmore, John, of South Mymmes, Middx, collier 8
5459018 2492590 2492590 defendant Smyth Thomas husbandman 592718 592718 Smyth, Thomas, of South Mymmes, Middx, husbandman 1
5501214 2505318 2505318 defendant Frowyk Thomas esq 592718 592718 Frowyk, Thomas, of South Mymmes, Middx, esq 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);