names

35 rows where place_id = 677046

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4025255 2033695 2033695 defendant Harvard Thomas mercer 677046 677046 Harvard, Thomas, of Castle Combe, mercer 0
4268456 2119052 2119052 defendant Harford Thomas   677046 677046 Harford, Thomas, of Castle Combe, linen draper 0
4353172 2148337 2148337 defendant Moone Robert clothier 677046 677046 Moone, Robert, of Castle Combe, clothier 0
4372621 2155281 2155281 defendant Moone Robert clothier 677046 677046 Moone, Robert, of Castle Combe, clothier 0
4377508 2157033 2157033 defendant Scroope George esq 677046 677046 Scroope, George, of Castle Combe, esq 0
4380970 2158308 2158308 defendant Otes Richard butcher 677046 677046 Otes, Richard, of Castle Combe, butcher 0
4466937 2190331 2190331 plaintiff Assheton Henry   677046 677046 Assheton, Henry, of Castle Combe, parson 0
4571144 2222545 2222545 defendant Brasyer John   677046 677046 Brasyer, John, of Castle Combe 0
4630346 2240399 2240399 defendant Grange John   677046 677046 Grange, John, of Castle Combe 1
4700505 2265573 2265573 defendant Brounstile Henry fuller 677046 677046 together with Brounstile, Henry, of Castle Combe, fuller 1
4700506 2265573 2265573 defendant Galton Nicholas fuller 677046 677046 Galton, Nicholas, of Castle Combe, fuller 2
4700507 2265573 2265573 defendant Bogeler William fuller 677046 677046 Bogeler, William, of Castle Combe, fuller 3
4700508 2265573 2265573 defendant Tomelyns William weaver 677046 677046 Tomelyns, William, of Castle Combe, weaver 4
4738152 2277033 2277033 defendant Spenser Robert laborer 677046 677046 Spenser, Robert, of Castle Combe, laborer 0
4738177 2277039 2277039 defendant Crompe Thomas husbandman 677046 677046 Crompe, Thomas, of Castle Combe, husbandman 2
4738185 2277041 2277041 defendant Crompe Thomas husbandman 677046 677046 Crompe, Thomas, of Castle Combe, husbandman 4
4738995 2277286 2277286 defendant Vyncent John weaver 677046 677046 Vyncent, John, of Castle Combe, weaver 0
4805778 2298012 2298012 defendant Stykylwey Richard fuller 677046 677046 Stykylwey, Richard, of Castle Combe, fuller 8
4816907 2301390 2301390 defendant Hulle Adam dyer 677046 677046 Hulle, Adam, of Castle Combe, dyer 0
4828898 2305080 2305080 defendant Bokeler John fuller 677046 677046 Bokeler, John, of Castle Combe, fuller 0
4835115 2306982 2306982 defendant Pyppyng John baker 677046 677046 Pyppyng, John, of Castle Combe, baker 1
4838163 2307859 2307859 defendant Cosyn William fuller 677046 677046 Cosyn, William, of Castle Combe, fuller 0
4841441 2308856 2308856 defendant Wattes John laborer 677046 677046 Wattes, John, of Castle Combe, laborer 0
4841442 2308856 2308856 defendant Hirne Richard husbandman 677046 677046 Hirne, Richard, of Castle Combe, husbandman 1
4842975 2309345 2309345 defendant Lacok John fuller 677046 677046 Lacok, John, of Castle Combe, fuller 2
4844505 2309797 2309797 defendant Cussyn William fuller 677046 677046 Cussyn, William, of Castle Combe, fuller 0
4920769 2333010 2333010 defendant Pulhare Nicholas yeoman 677046 677046 Pulhare, Nicholas, of Castle Combe, yeoman 0
4929232 2335559 2335559 defendant Haynes Thomas dyer 677046 677046 Haynes, Thomas, of Castle Combe, dyer 0
5009719 2359725 2359725 defendant Lowekyn Thomas carpenter 677046 677046 Lowekyn, Thomas, of Castle Combe, carpenter 0
5009720 2359725 2359725 defendant Harryes John weaver 677046 677046 Harryes, John, of Castle Combe, weaver 1
5009823 2359749 2359749 defendant Lonakyn Thomas   677046 677046 Lonakyn, Thomas, of Castle Combe, husb 6
5124889 2393754 2393754 defendant Botiller John   677046 677046 Botiller, John, of Castle Combe, servant 0
5143516 2399238 2399238 defendant Botiller John   677046 677046 Botiller, John, of Castle Combe, servant 0
5308489 2447575 2447575 plaintiff Wellys John   677046 677046 Wellys, John, of Castle Combe, parson of the church 2
5455372 2491523 2491523 defendant Hall William husbandman 677046 677046 Hall, William, of Castle Combe, husbandman 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);