names

52 rows where place_id = 597026

✎ 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
3626976 1903294 1903294 defendant Bartlot Henry clothier 597026 597026 Bartlot, Henry, of Batcombe, clothier 0
3641166 1907687 1907687 defendant Catcote Thomas clothier 597026 597026 Catcote, Thomas, of Batcombe, clothier 0
3641167 1907687 1907687 defendant Walsshe Walter yeoman 597026 597026 Walsshe, Walter, of Batcombe, yeoman 1
3641168 1907687 1907687 defendant Bartelotte William clothier 597026 597026 Bartelotte, William, of Batcombe, clothier 2
3687107 1922139 1922139 defendant Catcote John yeoman of the crown 597026 597026 Catcote, John, of Batcombe, yeoman of the crown 0
3709980 1929431 1929431 defendant Elys John husbandman 597026 597026 Elys, John, of Batcombe, husbandman 1
3812060 1961682 1961682 defendant Arnoll William clothman 597026 597026 Arnoll, William, of Batcombe, clothman 0
3812067 1961684 1961684 defendant Arnoll William clothman 597026 597026 Arnoll, William, of Batcombe, clothman 3
3816893 1963188 1963188 defendant Norvall William dyer 597026 597026 Norvall, William, of Batcombe, dyer 0
3883243 1984658 1984658 defendant Thatcher William caryer 597026 597026 Thatcher, William, of Batcombe, caryer 0
3890413 1987049 1987049 defendant Catcott John yeoman 597026 597026 Catcott, John, of Batcombe, yeoman 0
3913316 1994787 1994787 defendant Evererd Reginald husbandman 597026 597026 Evererd, Reginald, of Batcombe, husbandman 0
3940732 2003907 2003907 defendant Mynterne John husbandman 597026 597026 Mynterne, John, of Batcombe, husbandman 0
3957814 2009793 2009793 defendant Yerberye John husbandman or clothier 597026 597026 Yerberye, John, of Batcombe, husbandman or clothier 0
4000813 2025059 2025059 defendant Parsons Thomas butcher 597026 597026 Parsons, Thomas, of Batcombe, butcher 0
4096830 2059199 2059199 defendant Baylye Robert husbandman 597026 597026 Baylye, Robert, of Batcombe, husbandman 0
4185504 2090439 2090439 defendant Mynterne John husbandman 597026 597026 Mynterne, John, of Batcombe, husbandman 1
4189937 2091984 2091984 defendant Mynterne John husbandman 597026 597026 Mynterne, John, of Batcombe, husbandman, son of Henry Minterne, husbandman 0
4192348 2092880 2092880 defendant Mynterne John husbandman 597026 597026 Mynterne, John, of Batcombe, husbandman 3
4200893 2095869 2095869 defendant Coxe Richard husbandman 597026 597026 Coxe, Richard, of Batcombe, husbandman 1
4240102 2109662 2109662 defendant Bampfilde James clerk 597026 597026 Bampfilde, James, of Batcombe, clerk 3
4258672 2115862 2115862 defendant Howper William husbandman 597026 597026 Howper, William, of Batcombe, husbandman 0
4273469 2120684 2120684 defendant Bampfilde James clerk 597026 597026 Bampfilde, James, of Batcombe, clerk 2
4305352 2132013 2132013 defendant Kete Mathew gent 597026 597026 Kete, Mathew, of Batcombe, gent 0
4306123 2132281 2132281 defendant Toogood John carrier 597026 597026 Toogood, John, of Batcombe, carrier 0
4307915 2132910 2132910 defendant Pillard Robert butcher 597026 597026 Pillard, Robert, of Batcombe, butcher 0
4374730 2156017 2156017 defendant Togood John carrier 597026 597026 Togood, John, of Batcombe, carrier 3
4381058 2158341 2158341 defendant Williams William yeoman 597026 597026 Williams, William, of Batcombe, yeoman 0
4817204 2301472 2301472 defendant Roule John husbandman 597026 597026 Roule, John, of Batcombe, husbandman 1
4826902 2304450 2304450 defendant Boddon John husbandman 597026 597026 Boddon, John, of Batcombe, husbandman 4
4826903 2304450 2304450 defendant Boddon Thomas husbandman 597026 597026 Boddon, Thomas, of Batcombe, husbandman 5
4873765 2318731 2318731 defendant Bedford John husbandman 597026 597026 Bedford, John, of Batcombe, husbandman 0
4873769 2318732 2318732 defendant Bedford John husbandman 597026 597026 Bedford, John, of Batcombe, husbandman 0
4963856 2346102 2346102 defendant Plussh William (legal representative) 597026 597026 Plussh, William, of Batcombe, husbandman, executors of 1
5106806 2388418 2388418 defendant Amys Richard butcher 597026 597026 Amys, Richard, of Batcombe, butcher 0
5138254 2397697 2397697 defendant Milleward Thomas   597026 597026 Milleward, Thomas, of Batcombe, cloth maker 4
5159046 2403760 2403760 defendant Milleward Thomas   597026 597026 Milleward, Thomas, of Batcombe, cloth maker 4
5236207 2426176 2426176 defendant Dyer John dyer 597026 597026 Dyer, John, of Batcombe, dyer 1
5314678 2449425 2449425 defendant Erbyry Henry clothier 597026 597026 Erbyry, Henry, of Batcombe, Soms, clothier, son of Erbyry, Lawrence, of Batcombe, clothier 0
5314682 2449426 2449426 defendant Erbyry Henry clothier 597026 597026 Erbyry, Henry, of Batcombe, Soms, clothier, son of Erbyry, Lawrence, of Batcome, clothier 0
5332981 2454932 2454932 defendant Yerdury John clothier 597026 597026 Yerdury, John, of Batcombe, clothier 0
5344726 2458525 2458525 defendant Dyer Henry woolmonger 597026 597026 Dyer, Henry, of Batcombe, woolmonger 0
5352566 2460899 2460899 defendant Yeardbury Gebnry yeoman 597026 597026 Yeardbury, Gebnry, of Batcombe, yeoman 0
5353376 2461133 2461133 defendant Dyer Henry   597026 597026 Dyer, Henry, of Batcombe, wool monger 0
5443628 2488013 2488013 defendant Nutholl John barber 597026 597026 Nutholl, John, of Batcombe, barber 4
5456422 2491840 2491840 defendant Nicholl John barber 597026 597026 Nicholl, John, of Batcombe, barber 4
5478243 2498520 2498520 defendant Nicoll John barber 597026 597026 Nicoll, John, of Batcombe, barber 4
5504808 2506424 2506424 defendant Andrewe Walter smith 597026 597026 Andrewe, Walter, of Batcombe, smith 0
5535084 2515503 2515503 defendant Dyer Thomas yeoman 597026 597026 Dyer, Thomas, of Batcombe, yeoman 8
5589519 2531720 2531720 defendant Baby John clothier 597026 597026 Baby, John, of Batcombe, clothier 0
5594265 2533182 2533182 defendant Yarborow John clothman 597026 597026 Yarborow, John, of Batcombe, clothman 0
5594267 2533183 2533183 defendant Yarborow John clothman 597026 597026 Yarborow, John, of Batcombe, clothman 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);