names

76 rows where place_id = 590574

✎ 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
3601658 1868176 1868176 plaintiff Barton Thomas, senior (legal representative) 590574 590574 Barton, Thomas, senior, of Webbeley, executors of 0
3601661 1868176 1868176 defendant Kymrowe Thomas carpenter 590574 590574 Kymrowe, Thomas, of Webbeley, carpenter 0
3832660 1968139 1968139 defendant Mascall Thomas yeoman 590574 590574 Mascall, Thomas, of Webbeley, yeoman 2
3850041 1973601 1973601 defendant Hepkyns John butcher 590574 590574 Hepkyns, John, of Webbeley, butcher 2
3885376 1985364 1985364 defendant Lewys John husbandman 590574 590574 Lewys, John, of Webbeley, husbandman 4
4007011 2027282 2027282 plaintiff Lye alias Aley Thomas   590574 590574 Lye alias Aley, Thomas, of Webbeley, gent, attorney of the bench 0
4548520 2215479 2215479 defendant Pyper William   590574 590574 Pyper, William, of Webbeley 2
4590025 2228241 2228241 plaintiff Lunteley Margery   590574 590574 Lunteley, Margery, of Webbeley, formerly wife of Hugh 0
4590029 2228242 2228242 plaintiff Lunteley Margery   590574 590574 Lunteley, Margery, of Webbeley, formerly wife of Hugh 0
4590032 2228242 2228242 defendant Drayton Walter   590574 590574 Drayton, Walter, of Webbeley, vicar 2
4590034 2228242 2228242 defendant Bolt John   590574 590574 Bolt, John, of Webbeley 4
4703354 2266427 2266427 defendant Braytone Walter clerk 590574 590574 Braytone, Walter, of Webbeley, clerk 1
4718342 2271076 2271076 defendant Clerk Richard husbandman 590574 590574 Clerk, Richard, of Webbeley, husbandman 0
4720126 2271638 2271638 defendant Beynon John   590574 590574 Beynon, John, of Webbeley 3
4753169 2281374 2281374 plaintiff Ussher Walter   590574 590574 Ussher, Walter, of Webbeley, on his own account 0
4827133 2304532 2304532 defendant Bady Thomas shoemaker 590574 590574 Bady, Thomas, of Webbeley, shoemaker 0
4840654 2308616 2308616 defendant Miton John   590574 590574 Miton, John, of Webbeley, pedlar 0
4846882 2310531 2310531 defendant Dyer John dyer 590574 590574 Dyer, John, of Webbeley, dyer 1
4855248 2312996 2312996 defendant Body William yeoman 590574 590574 Body, William, of Webbeley, yeoman 0
4862965 2315397 2315397 defendant Henkyns William clerk 590574 590574 Henkyns, William, of Webbeley, clerk 3
4886438 2322617 2322617 defendant Smyth Thomas gent 590574 590574 Smyth, Thomas, of Webbeley, gent 1
4894326 2324908 2324908 defendant Harryes Richard ironmonger 590574 590574 Harryes, Richard, of Webbeley, ironmonger 6
4896586 2325599 2325599 defendant Harryes Richard ironmonger 590574 590574 Harryes, Richard, of Webbeley, ironmonger 6
4906759 2328696 2328696 defendant Body William yeoman 590574 590574 Body, William, of Webbeley, yeoman 0
4906761 2328697 2328697 defendant Bayly Richard tanner 590574 590574 Bayly, Richard, of Webbeley, tanner 0
4913251 2330645 2330645 defendant Garston John tanner 590574 590574 Garston, John, of Webbeley, tanner 0
4918873 2332416 2332416 defendant Garston John tanner 590574 590574 Garston, John, of Webbeley, tanner 0
4929459 2335632 2335632 defendant Feld Thomas skinner 590574 590574 Feld, Thomas, of Webbeley, skinner 0
4988883 2353627 2353627 defendant Payn John   590574 590574 Payn, John, of Webbeley, vicar, alias John ap Gruffith 2
5017275 2361937 2361937 defendant Halle Richard tanner 590574 590574 Halle, Richard, of Webbeley, tanner 0
5017276 2361937 2361937 defendant ap Adam John butcher 590574 590574 ap Adam, John, of Webbeley, butcher 1
5019497 2362585 2362585 defendant Bysswall Walter yeoman 590574 590574 Bysswall, Walter, of Webbeley, yeoman 0
5039091 2368340 2368340 defendant Mymme Thomas gent 590574 590574 Mymme, Thomas, of Webbeley, gent 0
5049138 2371377 2371377 defendant Tewe John crover 590574 590574 Tewe, John, of Webbeley, crover 0
5066135 2376395 2376395 plaintiff Merbury John   590574 590574 Merbury, John, of Webbeley, esq, exeutor of 0
5075638 2379213 2379213 defendant Baby Richard yeoman 590574 590574 Baby, Richard, of Webbeley, yeoman 0
5075639 2379213 2379213 defendant Smythe Thomas yeoman 590574 590574 Smythe, Thomas, of Webbeley, yeoman 1
5075640 2379213 2379213 defendant Dysshewall Walter yeoman 590574 590574 Dysshewall, Walter, of Webbeley, yeoman 2
5075645 2379215 2379215 defendant Baby Richard yeoman 590574 590574 Baby, Richard, of Webbeley, yeoman 0
5075646 2379215 2379215 defendant Smythe Thomas yeoman 590574 590574 Smythe, Thomas, of Webbeley, yeoman 1
5075647 2379215 2379215 defendant Dysshewall Walter yeoman 590574 590574 Dysshewall, Walter, of Webbeley, yeoman 2
5090849 2383715 2383715 plaintiff Milleson Richard (legal representative) 590574 590574 Milleson, Richard, of Webbeley, cordwainer, executors of 0
5101040 2386717 2386717 defendant Baker Geoffrey baker 590574 590574 Baker, Geoffrey, of Webbeley, baker 1
5101041 2386717 2386717 defendant Baker John hosier 590574 590574 Baker, John, of Webbeley, hosier 2
5107370 2388585 2388585 defendant Berton Walter fuller 590574 590574 Berton, Walter, of Webbeley, fuller 0
5107371 2388585 2388585 defendant Garston John tanner 590574 590574 Garston, John, of Webbeley, tanner 1
5107388 2388591 2388591 defendant Halle Richard husbandman 590574 590574 Halle, Richard, of Webbeley, husbandman 0
5107389 2388591 2388591 defendant Thornbury Thomas husbandman 590574 590574 Thornbury, Thomas, of Webbeley, husbandman 1
5115604 2390993 2390993 plaintiff Mymme Thomas   590574 590574 Mymme, Thomas, of Webbeley 0
5115607 2390993 2390993 plaintiff Smyth Thomas   590574 590574 Smyth, Thomas, of Webbeley 3
5116505 2391260 2391260 defendant Halle Richard yeoman 590574 590574 Halle, Richard, of Webbeley, yeoman 0
5116506 2391260 2391260 defendant Smyth Thomas yeoman 590574 590574 Smyth, Thomas, of Webbeley, yeoman 1
5132507 2395999 2395999 plaintiff Hayes John   590574 590574 Hayes, John, of Webbeley 0
5132508 2395999 2395999 defendant Glover John glover 590574 590574 Glover, John, of Webbeley, glover 0
5150607 2401324 2401324 plaintiff Frysour Philip (legal representative) 590574 590574 Frysour, Philip, of Webbeley, yeoman, executors of 0
5150610 2401324 2401324 defendant Sherman John yeoman 590574 590574 Sherman, John, of Webbeley, yeoman 0
5155907 2402889 2402889 defendant ap Richard John clerk 590574 590574 ap Richard, John, of Webbeley, clerk 0
5172589 2407708 2407708 defendant ap Richard John clerk 590574 590574 ap Richard, John, of Webbeley, clerk 0
5185515 2411515 2411515 plaintiff Frysour Philip (legal representative) 590574 590574 Frysour, Philip, of Webbeley, executors of 0
5185518 2411515 2411515 defendant Sherman John yeoman 590574 590574 Sherman, John, of Webbeley, yeoman 0
5185519 2411516 2411516 plaintiff Frysour Philip (legal representative) 590574 590574 Frysour, Philip, of Webbeley, yeoman, executors of 0
5185522 2411516 2411516 defendant Sherman John yeoman 590574 590574 Sherman, John, of Webbeley, yeoman 0
5230571 2424555 2424555 defendant Ley William yeoman 590574 590574 Ley, William, of Webbeley, yeoman 0
5230572 2424555 2424555 defendant Ley Thomas yeoman 590574 590574 Ley, Thomas, of Webbeley, yeoman 1
5232187 2424990 2424990 defendant ap Rychard John clerk 590574 590574 ap Rychard, John, of Webbeley, clerk 0
5283052 2440104 2440104 defendant Ley John glover 590574 590574 Ley, John, of Webbeley, glover 1
5318565 2450648 2450648 defendant Halle Thomas tanner 590574 590574 Halle, Thomas, of Webbeley, tanner 0
5318570 2450649 2450649 defendant Halle Thomas tanner 590574 590574 Halle, Thomas, of Webbeley, tanner 0
5328077 2453466 2453466 defendant Mores William yeoman 590574 590574 Mores, William, of Webbeley, yeoman 1
5328078 2453466 2453466 defendant Corveser Philip cordwainer 590574 590574 Corveser, Philip, of Webbeley, cordwainer 2
5364245 2464476 2464476 defendant Peter Thomas husbandman 590574 590574 Peter, Thomas, of Webbeley, husbandman 1
5441683 2487430 2487430 plaintiff ap Adam John butcher 590574 590574 ap Adam, John, of Webbeley, butcher 0
5499028 2504645 2504645 defendant Sherman John yeoman 590574 590574 Sherman, John, of Webbeley, or of Rosse, yeoman 0
5586460 2530803 2530803 defendant Baker John baker 590574 590574 Baker, John, of Webbeley, baker 0
5614559 2548350 2548350 defendant Smyth William   590574 590574 Smyth, William, of Webbeley 0
5616435 2548938 2548938 plaintiff Hod John   590574 590574 Hod, John, of Webbeley 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);