names

87 rows where place_id = 611406

✎ 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
3688287 1922482 1922482 defendant Hanley John yeoman 611406 611406 Hanley, John, of Bredon, yeoman 0
3702552 1927067 1927067 defendant Alen William yeoman 611406 611406 Alen, William, of Bredon, yeoman 1
3702605 1927082 1927082 defendant Hanley John yeoman 611406 611406 Hanley, John, of Bredon, yeoman 0
3702606 1927082 1927082 defendant Halen William yeoman 611406 611406 Halen, William, of Bredon, yeoman 1
3702819 1927154 1927154 defendant Salwey Robert yeoman 611406 611406 Salwey, Robert, of Bredon, yeoman 1
3702820 1927154 1927154 defendant Jenyns Robert husbandman 611406 611406 Jenyns, Robert, of Bredon, husbandman 2
3702821 1927154 1927154 defendant Turvyll Richard husbandman 611406 611406 Turvyll, Richard, of Bredon, husbandman 3
3702822 1927154 1927154 defendant Martyn William husbandman 611406 611406 Martyn, William, of Bredon, husbandman 4
3702823 1927154 1927154 defendant Holder John husbandman 611406 611406 Holder, John, of Bredon, husbandman 5
3702824 1927154 1927154 defendant Habcook Robert husbandman 611406 611406 Habcook, Robert, of Bredon, husbandman 6
3724546 1933963 1933963 defendant Parsons Robert husbandman 611406 611406 Parsons, Robert, of Bredon, husbandman 0
3746505 1940818 1940818 defendant Bitton George laborer 611406 611406 Bitton, George, of Bredon, laborer 3
3746506 1940818 1940818 defendant Tyrrell Thomas shoemaker 611406 611406 Tyrrell, Thomas, of Bredon, shoemaker 4
3759852 1945074 1945074 defendant Dytton George laborer 611406 611406 Dytton, George, of Bredon, laborer 3
3759853 1945074 1945074 defendant Tyrrell Thomas shoemaker 611406 611406 Tyrrell, Thomas, of Bredon, shoemaker 4
3759870 1945075 1945075 defendant Tyrrell Thomas shoemaker 611406 611406 Tyrrell, Thomas, of Bredon, shoemaker 4
3766140 1947061 1947061 defendant Hygyns Thomas husbandman 611406 611406 Hygyns, Thomas, of Bredon, husbandman 0
3781745 1952037 1952037 defendant Waren Thomas carver 611406 611406 Waren, Thomas, of Bredon, carver 1
3790048 1954706 1954706 defendant Parker John laborer 611406 611406 Parker, John, of Bredon, laborer 6
3798474 1957424 1957424 defendant Cacher Walter husbandman 611406 611406 Cacher, Walter, of Bredon, husbandman 4
3806191 1959862 1959862 defendant Parker John laborer 611406 611406 Parker, John, of Bredon, laborer 5
3806210 1959863 1959863 defendant Parker John laborer 611406 611406 Parker, John, of Bredon, laborer 5
3824855 1965653 1965653 defendant Compton William clerk 611406 611406 Compton, William, of Bredon, clerk 0
3825037 1965704 1965704 defendant Compton William clerk 611406 611406 Compton, William, of Bredon, clerk 0
3841814 1971022 1971022 defendant Lyghtfote William husbandman 611406 611406 Lyghtfote, William, of Bredon, husbandman 2
3844433 1971808 1971808 defendant Bodell John husbandman 611406 611406 Bodell, John, of Bredon, husbandman 0
3870283 1980311 1980311 defendant Kager Walter husbandman 611406 611406 Kager, Walter, of Bredon, husbandman 0
3870284 1980311 1980311 defendant Smythe Richard smith 611406 611406 Smythe, Richard, of Bredon, smith 1
3908877 1993261 1993261 defendant Browe Edward clerk 611406 611406 Browe, Edward, of Bredon, clerk 0
3927637 1999582 1999582 defendant Warren Thomas husbandman 611406 611406 Warren, Thomas, of Bredon, husbandman 0
4294560 2128140 2128140 defendant Butler Richard yeoman 611406 611406 Butler, Richard, of Bredon, yeoman 2
4294563 2128141 2128141 defendant Smythe George yeoman 611406 611406 Smythe, George, of Bredon, yeoman 0
4294564 2128141 2128141 defendant Parker Thomas yeoman 611406 611406 Parker, Thomas, of Bredon, or of Norton, yeoman 1
4440151 2181850 2181850 defendant Saundres John chaplain 611406 611406 Saundres, John, of Bredon, chaplain 0
4451941 2185590 2185590 defendant Erle John   611406 611406 Erle, John, of Bredon 5
4490091 2197619 2197619 plaintiff Upton John de master & parson 611406 611406 Upton, John de, of Bredon, master & parson 0
4631222 2240663 2240663 plaintiff Talkere John   611406 611406 Talkere, John, of Bredon 0
4705215 2267001 2267001 defendant Tasker John farmer 611406 611406 Tasker, John, of Bredon, farmer 0
4705217 2267002 2267002 defendant Tasker John farmer 611406 611406 Tasker, John, of Bredon, farmer 0
4708801 2268123 2268123 plaintiff Outehill William   611406 611406 Outehill, William, of Bredon 0
4748495 2280063 2280063 plaintiff Mason William   611406 611406 Mason, William, of Bredon 0
4748496 2280063 2280063 defendant Sawenay John harper 611406 611406 Sawenay, John, of Bredon, harper 0
4748497 2280063 2280063 defendant Coke William tailor 611406 611406 Coke, William, of Bredon, tailor 1
4759327 2283262 2283262 defendant Millere Alexander   611406 611406 Millere, Alexander, of Bredon 0
4760927 2283759 2283759 plaintiff Delves Thomas   611406 611406 Delves, Thomas, of Bredon 0
4784213 2291060 2291060 defendant Prest Margery   611406 611406 Prest, Margery, of Bredon, servant 1
4785328 2291429 2291429 plaintiff Ever Robert   611406 611406 Ever, Robert, of Bredon 0
4785330 2291430 2291430 plaintiff Ever Robert   611406 611406 Ever, Robert, of Bredon 0
4817392 2301526 2301526 plaintiff Millere Alexander   611406 611406 Millere, Alexander, of Bredon 0
4826853 2304437 2304437 defendant Swartlyngbote Richard yeoman 611406 611406 Swartlyngbote, Richard, of Bredon, yeoman 0
4862663 2315306 2315306 defendant Halle Thomas husbandman 611406 611406 Halle, Thomas, of Bredon, husbandman 0
4966311 2346857 2346857 defendant Colles John husbandman 611406 611406 Colles, John, of Bredon, husbandman 0
4966312 2346857 2346857 defendant Fissher John husbandman 611406 611406 Fissher, John, of Bredon, husbandman 1
4971546 2348418 2348418 defendant Colles John husbandman 611406 611406 Colles, John, of Bredon, husbandman 0
4996317 2355757 2355757 defendant Large Giles (legal representative) 611406 611406 Large, Giles, of Bredon, husbandman, executors of 0
4996318 2355757 2355757 defendant Collys John husbandman 611406 611406 (Collys, John, of Bredon, husbandman 1
5040160 2368657 2368657 defendant Fyssher John husbandman 611406 611406 Fyssher, John, of Bredon, husbandman 0
5069954 2377507 2377507 defendant Tasker John husbandman 611406 611406 Tasker, John, of Bredon, husbandman 0
5069955 2377507 2377507 defendant Thressher John husbandman 611406 611406 Thressher, John, of Bredon, husbandman 1
5071659 2378016 2378016 defendant Nevowe William yeoman 611406 611406 Nevowe, William, of Bredon, yeoman 0
5123355 2393272 2393272 defendant Saweney Thomas baker 611406 611406 Saweney, Thomas, of Bredon, baker 0
5152231 2401784 2401784 plaintiff Hawekyns Thomas clerk & rector 611406 611406 Hawekyns, Thomas, of Bredon, clerk & rector 0
5152232 2401784 2401784 defendant Taylour Henry husbandman 611406 611406 Taylour, Henry, of Bredon, husbandman 0
5342162 2457742 2457742 defendant Tasker John husbandman 611406 611406 Tasker, John, of Bredon, husbandman 0
5342163 2457742 2457742 defendant Goram John   611406 611406 Goram, John, of Bredon, husbandma 1
5409431 2477784 2477784 defendant Saweney James laborer 611406 611406 Saweney, James, of Bredon, laborer 2
5423004 2481830 2481830 defendant Saweney James laborer 611406 611406 Saweney, James, of Bredon, laborer 1
5423009 2481831 2481831 defendant Saweney James laborer 611406 611406 Saweney, James, of Bredon, laborer 1
5437043 2486018 2486018 defendant (not given) John prior of Hynderwell 611406 611406 Hynderwell, John, of Bredon, prior of St Hardulph of Bredon 0
5501459 2505390 2505390 defendant Ball John gent 611406 611406 Ball, John, of Bredon, gent 0
5501461 2505391 2505391 defendant Ball John gent 611406 611406 Ball, John, of Bredon, gent 0
5501703 2505464 2505464 defendant Beell John gent 611406 611406 Beell, John, of Bredon, gent 1
5571317 2526171 2526171 defendant Starkey Thomas gent 611406 611406 Starkey, Thomas, of Bredon, gent 0
5597058 2533991 2533991 defendant Salwey Robert gent 611406 611406 Salwey, Robert, of Bredon, gent 0
5597059 2533991 2533991 defendant Genyns Robert husbandman 611406 611406 Genyns, Robert, of Bredon, husbandman 1
5597060 2533991 2533991 defendant Turvile Richard husbandman 611406 611406 Turvile, Richard, of Bredon, husbandman 2
5597061 2533991 2533991 defendant Hyggyns John husbandman 611406 611406 Hyggyns, John, of Bredon, husbandman 3
5597062 2533991 2533991 defendant Marten William husbandman 611406 611406 Marten, William, of Bredon, husbandman 4
5597063 2533991 2533991 defendant Collys John husbandman 611406 611406 Collys, John, of Bredon, husbandman 5
5597064 2533991 2533991 defendant Hunt Thomas husbandman 611406 611406 Hunt, Thomas, of Bredon, husbandman 6
5597065 2533991 2533991 defendant Harvy Thomas husbandman 611406 611406 Harvy, Thomas, of Bredon, husbandman 7
5597066 2533991 2533991 defendant Hobbys Richard husbandman 611406 611406 Hobbys, Richard, of Bredon, husbandman 8
5597067 2533991 2533991 defendant Holder John husbandman 611406 611406 Holder, John, of Bredon, husbandman 9
5597068 2533991 2533991 defendant Tomson Thomas husbandman 611406 611406 Tomson, Thomas, of Bredon, husbandman 10
5597069 2533991 2533991 defendant Halcok Robert husbandman 611406 611406 Halcok, Robert, of Bredon, husbandman 11
5600818 2535144 2535144 defendant Lyghtfote William yeoman 611406 611406 Lyghtfote, William, of Bredon, yeoman 0
5635294 2555003 2555003 defendant Gryffyn William husbandman 611406 611406 Gryffyn, William, of Bredon, husbandman 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);