names

48 rows where place_id = 594640

✎ 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
3616957 1872926 1872926 defendant Gylis Thomas chapman 594640 594640 Gylis, Thomas, of Axbrigge, Soms, chapman 0
3625838 1875615 1875615 defendant Gyles Thomas chapman 594640 594640 Gyles, Thomas, of Axbrigge, Soms, chapman 2
3625842 1875616 1875616 defendant Gyles Thomas chapman 594640 594640 Gyles, Thomas, of Axbrigge, Soms, chapman 2
3630870 1904475 1904475 defendant Hye John tucker 594640 594640 Hye, John, of Axbrigge, Soms, tucker 0
3632207 1904889 1904889 defendant Cutler Thomas clothman 594640 594640 Cutler, Thomas, of Axbrigge, Soms, clothman 0
3647805 1909707 1909707 defendant Otter William clothier 594640 594640 Otter, William, of Axbrigge, Soms, clothier 2
3647812 1909709 1909709 defendant Otter William clothier 594640 594640 Otter, William, of Axbrigge, Soms, clothier 3
3730573 1935798 1935798 defendant Coker Edward draper 594640 594640 Coker, Edward, of Axbrigge, Soms, draper 1
3734649 1937083 1937083 defendant Butler Thomas clothier 594640 594640 Butler, Thomas, of Axbrigge, Soms, clothier 0
3734651 1937084 1937084 defendant Cutler Thomas clothier 594640 594640 Cutler, Thomas, of Axbrigge, Soms, clothier 0
3742646 1939569 1939569 defendant Arcoll William yeoman 594640 594640 (Arcoll, William, of Axbrigge, Soms, or of Heyworth, Wilts, yeoman 1
4665025 2250540 2250540 defendant Tapele Thomas esq 594640 594640 Tapele, Thomas, of Axbrigge, Soms, esq 0
4707542 2267728 2267728 defendant Heyne Thomas chapman 594640 594640 Heyne, Thomas, of Axbrigge, Soms, chapman 0
4751572 2280946 2280946 defendant Skorlok John dyer 594640 594640 Skorlok, John, of Axbrigge, Soms, dyer 2
4963641 2346038 2346038 defendant Crodmedowe John clothmaker 594640 594640 Crodmedowe, John, of Axbrigge, Soms, clothmaker 3
4981374 2351350 2351350 defendant Smok Thomas chapman 594640 594640 Smok, Thomas, of Axbrigge, Soms, chapman 2
4981380 2351351 2351351 defendant Smok Thomas chapman 594640 594640 Smok, Thomas, of Axbrigge, Soms, chapman 2
4996103 2355692 2355692 defendant Pryse William chapman 594640 594640 Pryse, William, of Axbrigge, Soms, chapman 4
5029457 2365489 2365489 defendant Pryce William chapman 594640 594640 Pryce, William, of Axbrigge, Soms, chapman 0
5069611 2377408 2377408 defendant Smok Thomas chapman 594640 594640 Smok, Thomas, of Axbrigge, Soms, chapman 0
5105775 2388136 2388136 defendant Whyther John clothier 594640 594640 Whyther, John, of Axbrigge, Soms, clothier 2
5105780 2388137 2388137 defendant Whyther John clothier 594640 594640 Whyther, John, of Axbrigge, Soms, clothier 2
5108483 2388917 2388917 defendant Payne Thomas chapman 594640 594640 Payne, Thomas, of Axbrigge, Soms, chapman 1
5178252 2409343 2409343 defendant Payn John chapman 594640 594640 Payn, John, of Axbrigge, Soms, chapman 1
5178259 2409344 2409344 defendant Nethir John fuller 594640 594640 Nethir, John, of Axbrigge, Soms, fuller 2
5201367 2416156 2416156 defendant Nethir John fuller 594640 594640 Nethir, John, of Axbrigge, Soms, fuller 2
5217428 2420833 2420833 defendant Pryce William chapman 594640 594640 Pryce, William, of Axbrigge, Soms, chapman 1
5227340 2423622 2423622 defendant Philipps John chapman 594640 594640 Philipps, John, of Axbrigge, Soms, chapman 0
5227346 2423624 2423624 defendant Philipps John chapman 594640 594640 Philipps, John, of Axbrigge, Soms, chapman 1
5256453 2432141 2432141 defendant Payne John yeoman 594640 594640 Payne, John, of Axbrigge, Soms, yeoman 2
5259770 2433179 2433179 defendant Fevyan William weaver 594640 594640 Fevyan, William, of Axbrigge, Soms, weaver 0
5270436 2436453 2436453 defendant Cadell Walter   594640 594640 Cadell, Walter, of Axbrigge, Soms, clothmanm 2
5350002 2460129 2460129 defendant Caddell Walter clothier 594640 594640 Caddell, Walter, of Axbrigge, Soms, clothier 0
5359925 2463144 2463144 defendant Happer Roger clothier 594640 594640 Happer, Roger, of Axbrigge, Soms, clothier 0
5360591 2463344 2463344 defendant Harper Roger clothier 594640 594640 Harper, Roger, of Axbrigge, Soms, clothier 0
5382681 2470107 2470107 defendant Harper Roger clothman 594640 594640 Harper, Roger, of Axbrigge, Soms, clothman 1
5392845 2473027 2473027 defendant Happer Roger clothman 594640 594640 Happer, Roger, of Axbrigge, Soms, clothman 1
5393912 2473319 2473319 defendant Gylys Thomas chapman 594640 594640 Gylys, Thomas, of Axbrigge, Soms, chapman 0
5476382 2497940 2497940 defendant Symondys William chapman 594640 594640 Symondys, William, of Axbrigge, Soms, chapman 0
5477626 2498325 2498325 defendant Gilys Thomas chapman 594640 594640 Gilys, Thomas, of Axbrigge, Soms, chapman 2
5485941 2500686 2500686 defendant mainpernors for Gylys Thomas chapman 594640 594640 mainpernors for Gylys, Thomas, of Axbrigge, Soms, chapman 3
5506560 2506962 2506962 defendant Harper Roger yeoman 594640 594640 Harper, Roger, of Axbrigge, Soms, yeoman 2
5522075 2511720 2511720 defendant Symondes William mercer 594640 594640 Symondes, William, of Axbrigge, Soms, mercer 0
5522077 2511721 2511721 defendant Symondes William mercer 594640 594640 Symondes, William, of Axbrigge, Soms, mercer 0
5526123 2512746 2512746 defendant Benyng William weaver 594640 594640 Benyng, William, of Axbrigge, Soms, weaver 3
5531325 2514318 2514318 defendant Dyer John clothman 594640 594640 Dyer, John, of Axbrigge, Soms, clothman 0
5545080 2518567 2518567 defendant Dyer John clothman 594640 594640 Dyer, John, of Axbrigge, Soms, clothman 1
5609493 2537865 2537865 defendant Harper Roger clothman 594640 594640 Harper, Roger, of Axbrigge, Soms, clothman 1

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);