names

73 rows where place_id = 588338

✎ 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
3594153 1865814 1865814 defendant Glover Simon glover 588338 588338 Glover, Simon, of Walyngford, Berks, glover 0
3613247 1871797 1871797 defendant Wykam Edward gent 588338 588338 Wykam, Edward, of Walyngford, Berks, gent 4
3858031 1976161 1976161 defendant Evyott Thomas butcher 588338 588338 Evyott, Thomas, of Walyngford, Berks, butcher 0
3893627 1988096 1988096 plaintiff Pollyngton Ralph mercer 588338 588338 Pollyngton, Ralph, of Walyngford, Berks, mercer 0
4519822 2206554 2206554 defendant Colham John   588338 588338 Colham, John, of Walyngford, Berks 4
4552543 2216748 2216748 defendant Diere Richard   588338 588338 Diere, Richard, of Walyngford, Berks 0
4578174 2224671 2224671 defendant Bakere Roger   588338 588338 Bakere, Roger, of Walyngford, Berks 5
4656435 2247907 2247907 defendant Porter William porter 588338 588338 Porter, William, of Walyngford, Berks, porter 0
4690378 2262549 2262549 defendant Feysaunt Robert hostiler 588338 588338 Feysaunt, Robert, of Walyngford, Berks, hostiler 0
4717962 2270957 2270957 defendant Wolf Hugh   588338 588338 Wolf, Hugh, of Walyngford, Berks, knight 0
4725230 2273184 2273184 defendant Godswayn alias Chapman John husbandman 588338 588338 Godswayn alias Chapman, John, of Walyngford, Berks, husbandman 0
4819331 2302122 2302122 defendant Warweld John gent 588338 588338 Warweld, John, of Walyngford, Berks, gent 1
4819336 2302123 2302123 defendant Warweld John gent 588338 588338 Warweld, John, of Walyngford, Berks, gent 1
4845634 2310145 2310145 defendant Fesaunt John hosteller 588338 588338 Fesaunt, John, of Walyngford, Berks, hosteller 3
4883470 2321748 2321748 defendant Bovyndon William husbandman 588338 588338 Bovyndon, William, of Walyngford, Berks, husbandman 0
4897256 2325800 2325800 defendant Petevyn Stephen chapman 588338 588338 Petevyn, Stephen, of Walyngford, Berks, chapman 1
4913775 2330809 2330809 defendant Berewell Richard butcher 588338 588338 Berewell, Richard, of Walyngford, Berks, butcher 2
4924484 2334095 2334095 defendant Sely John husbandman 588338 588338 Sely, John, of Walyngford, Berks, husbandman 2
4929326 2335590 2335590 defendant Robbekyn John weaver 588338 588338 Robbekyn, John, of Walyngford, Berks, weaver 0
4937528 2338112 2338112 defendant Randolf Geoffrey chandler 588338 588338 (Randolf, Geoffrey, of Walyngford, Berks, chandler 3
4968544 2347559 2347559 defendant Lussell Thomas yeoman 588338 588338 Lussell, Thomas, of Walyngford, Berks, yeoman 4
4968550 2347560 2347560 defendant Lussell Thomas yeoman 588338 588338 Lussell, Thomas, of Walyngford, Berks, yeoman 4
4978809 2350612 2350612 defendant Crill John, senior   588338 588338 Crill, John, senior, of Walyngford, Berks, servant 0
4986421 2352865 2352865 plaintiff Doyly William   588338 588338 Doyly, William, of Walyngford, Berks 1
4986424 2352866 2352866 plaintiff Doyly William   588338 588338 Doyly, William, of Walyngford, Berks 1
4986425 2352866 2352866 defendant Warfeld John gent 588338 588338 Warfeld, John, of Walyngford, Berks, gent 0
4987391 2353180 2353180 defendant Lussell John yeoman 588338 588338 Lussell, John, of Walyngford, Berks, yeoman 0
4989502 2353795 2353795 defendant Randolf Geoffrey husbandman 588338 588338 Randolf, Geoffrey, of Walyngford, Berks, husbandman 0
4998525 2356440 2356440 defendant Breweode John fishmonger 588338 588338 Breweode, John, of Walyngford, Berks, fishmonger 2
5004180 2358114 2358114 defendant Bodyngton William husbandman 588338 588338 Bodyngton, William, of Walyngford, Berks, husbandman 0
5008533 2359392 2359392 defendant Flexmere John clerk 588338 588338 Flexmere, John, of Walyngford, Berks, clerk 1
5048280 2371120 2371120 defendant Bodyngton John chapman 588338 588338 (Bodyngton, John, of Walyngford, Berks, chapman 1
5052718 2372409 2372409 defendant Boton John yeoman 588338 588338 Boton, John, of Walyngford, Berks, yeoman 0
5076370 2379433 2379433 defendant Romwode William butcher 588338 588338 Romwode, William, of Walyngford, Berks, butcher 0
5083502 2381567 2381567 defendant Boton John chapman 588338 588338 Boton, John, of Walyngford, Berks, chapman 1
5097552 2385714 2385714 defendant Sharp William husbandman 588338 588338 Sharp, William, of Walyngford, Berks, husbandman 0
5098195 2385901 2385901 defendant Sharpe John   588338 588338 Sharpe, John, of Walyngford, Berks, franklin 1
5100253 2386517 2386517 defendant Abselon Thomas husbandman 588338 588338 Abselon, Thomas, of Walyngford, Berks, husbandman 0
5116009 2391109 2391109 defendant Boton Thomas husbandman 588338 588338 Boton, Thomas, of Walyngford, Berks, husbandman 0
5137926 2397604 2397604 defendant Lychefeld John chaplain 588338 588338 Lychefeld, John, of Walyngford, Berks, chaplain 2
5158644 2403649 2403649 defendant Lychefeld John chaplain 588338 588338 Lychefeld, John, of Walyngford, Berks, chaplain 2
5173402 2407926 2407926 defendant Gilbert John chapman 588338 588338 Gilbert, John, of Walyngford, Berks, chapman 3
5197215 2414923 2414923 defendant Dons John   588338 588338 Dons, John, of Walyngford, Berks, chapm 5
5252367 2430851 2430851 defendant Porter Hugh yeoman 588338 588338 Porter, Hugh, of Walyngford, Berks, yeoman 0
5258057 2432639 2432639 defendant Absolon Thomas yeoman 588338 588338 Absolon, Thomas, of Walyngford, Berks, yeoman 0
5258061 2432640 2432640 defendant Absolon Thomas yeoman 588338 588338 Absolon, Thomas, of Walyngford, Berks, yeoman 0
5258083 2432646 2432646 defendant Button John ostler 588338 588338 Button, John, of Walyngford, Berks, ostler 1
5275733 2437965 2437965 defendant Nesse Thomas yeoman 588338 588338 Nesse, Thomas, of Walyngford, Berks, yeoman 1
5275736 2437966 2437966 defendant Nesse Thomas yeoman 588338 588338 Nesse, Thomas, of Walyngford, Berks, yeoman 1
5276980 2438346 2438346 defendant Wheler William shoemaker 588338 588338 Wheler, William, of Walyngford, Berks, shoemaker 3
5294362 2443325 2443325 defendant Nesse Thomas yeoman 588338 588338 Nesse, Thomas, of Walyngford, Berks, yeoman 1
5294365 2443326 2443326 defendant Nesse Thomas yeoman 588338 588338 Nesse, Thomas, of Walyngford, Berks, yeoman 1
5309389 2447846 2447846 defendant Rede Thomas yeoman 588338 588338 Rede, Thomas, of Walyngford, Berks, yeoman 3
5312768 2448852 2448852 defendant Playstowe John mercer 588338 588338 Playstowe, John, of Walyngford, Berks, mercer 3
5312794 2448856 2448856 defendant Weston Henry yeoman 588338 588338 Weston, Henry, of Walyngford, Berks, yeoman 2
5344390 2458425 2458425 defendant Botun John (legal representative) 588338 588338 Botun, John, of Walyngford, Berks, yeoman, executrix of 0
5352094 2460763 2460763 defendant Glaswas William gent 588338 588338 Glaswas, William, of Walyngford, Berks, gent 0
5447591 2489152 2489152 defendant Gander Richard dyer 588338 588338 Gander, Richard, of Walyngford, Berks, dyer 1
5498894 2504607 2504607 defendant Weston Thomas mercer 588338 588338 (Weston, Thomas, of Walyngford, Berks, mercer 4
5498901 2504608 2504608 defendant Weston Thomas mercer 588338 588338 (Weston, Thomas, of Walyngford, Berks, mercer 5
5519414 2510919 2510919 defendant Wilson Lawrence yeoman 588338 588338 Wilson, Lawrence, of Walyngford, Berks, yeoman 2
5519419 2510920 2510920 defendant Wilson Lawrence yeoman 588338 588338 Wilson, Lawrence, of Walyngford, Berks, yeoman 3
5528926 2513566 2513566 defendant Born Richard yeoman 588338 588338 Born, Richard, of Walyngford, Berks, yeoman 0
5545391 2518638 2518638 defendant Bocher John butcher 588338 588338 Bocher, John, of Walyngford, Berks, butcher 1
5547095 2519159 2519159 defendant A Dene William innholder 588338 588338 A Dene, William, of Walyngford, Berks, innholder 0
5547100 2519160 2519160 defendant A Dene William innholder 588338 588338 A Dene, William, of Walyngford, Berks, innholder 0
5551326 2520422 2520422 defendant Rede William   588338 588338 Rede, William, of Walyngford, Berks, knight 1
5551329 2520423 2520423 defendant Rede William   588338 588338 Rede, William, of Walyngford, Berks, knight 1
5563106 2523807 2523807 defendant Richardson John yeoman 588338 588338 Richardson, John, of Walyngford, Berks, yeoman 4
5563116 2523808 2523808 defendant Richardson John yeoman 588338 588338 Richardson, John, of Walyngford, Berks, yeoman 4
5588007 2531260 2531260 defendant Beseworth Stephen clerk 588338 588338 Beseworth, Stephen, of Walyngford, Berks, clerk 0
5589136 2531611 2531611 defendant Bereworth Stephen clerk 588338 588338 Bereworth, Stephen, of Walyngford, Berks, clerk 0
5636911 2555487 2555487 defendant Wolf Hugh   588338 588338 Wolf, Hugh, of Walyngford, Berks, knight 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);