names

45 rows where place_id = 761920

✎ 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
4483034 2195389 2195389 defendant Mykelton Robert   761920 761920 Mykelton, Robert, of Campeden 0
4484441 2195826 2195826 defendant Cosyn John   761920 761920 Cosyn, John, of Campeden 4
4484442 2195826 2195826 defendant Draper Nicholas   761920 761920 Draper, Nicholas, of Campeden 5
4496709 2199639 2199639 plaintiff Culne William   761920 761920 Culne, William, of Campeden, vicar 0
4497523 2199869 2199869 defendant Chapman John   761920 761920 Chapman, John, of Campeden 0
4570906 2222467 2222467 plaintiff Wynger Robert   761920 761920 Wynger, Robert, of Campeden 0
4608352 2233724 2233724 defendant Faireford William   761920 761920 Faireford, William, of Campeden 1
4608353 2233724 2233724 defendant Lynger Thomas   761920 761920 Lynger, Thomas, of Campeden 2
4628124 2239725 2239725 defendant Barbour John   761920 761920 Barbour, John, of Campeden 1
4644295 2244421 2244421 defendant Wyngere Robert   761920 761920 Wyngere, Robert, of Campeden 2
4660845 2249218 2249218 defendant Webbe Henry weaver 761920 761920 Webbe, Henry, of Campeden, weaver 2
4669594 2256200 2256200 defendant Grevill John esq 761920 761920 Grevill, John, of Campeden, esq 0
4671336 2256686 2256686 defendant Barbour Thomas barber 761920 761920 Barbour, Thomas, of Campeden, barber 0
4679917 2259324 2259324 defendant William Hycokkes gent 761920 761920 William, Hycokkes, of Campeden, gent 0
4694552 2263792 2263792 defendant Smyth William smith 761920 761920 Smyth, William, of Campeden, smith 0
4694553 2263792 2263792 defendant Webbe Henry chaloner 761920 761920 Webbe, Henry, of Campeden, chaloner 1
4694554 2263792 2263792 defendant Bother John butcher 761920 761920 Bother, John, of Campeden, butcher 2
4745333 2279145 2279145 defendant Houton John yeoman 761920 761920 Houton, John, of Campeden, yeoman 0
4752453 2281179 2281179 defendant Stokes John hosteller 761920 761920 Stokes, John, of Campeden, hosteller 0
4772911 2287498 2287498 defendant Marewell Richard tailor 761920 761920 Marewell, Richard, of Campeden, tailor 4
4790111 2292985 2292985 plaintiff Kene William carpenter 761920 761920 Kene, William, of Campeden, carpenter 0
4798176 2295623 2295623 defendant Marewell Richard tailor 761920 761920 Marewell, Richard, of Campeden, tailor 4
4816426 2301230 2301230 defendant Smyth Roger yeoman 761920 761920 Smyth, Roger, of Campeden, yeoman 2
4861024 2314806 2314806 defendant Bradewey John bytcher 761920 761920 Bradewey, John, of Campeden, bytcher 1
4891443 2324055 2324055 defendant Pursare John tailor 761920 761920 Pursare, John, of Campeden, tailor 1
4891987 2324231 2324231 defendant Felowe Robert cordwainer 761920 761920 Felowe, Robert, of Campeden, cordwainer 1
4908437 2329194 2329194 defendant Damysell Walter chapman 761920 761920 Damysell, Walter, of Campeden, chapman 2
4918181 2332207 2332207 defendant Bonefaunt John yeoman 761920 761920 Bonefaunt, John, of Campeden, yeoman 0
4961592 2345429 2345429 plaintiff Bonyfaunt John mercer 761920 761920 Bonyfaunt, John, of Campeden, mercer 0
4981631 2351421 2351421 defendant Couper Hugh cordwainer 761920 761920 Couper, Hugh, of Campeden, cordwainer 1
4992909 2354759 2354759 defendant Prodehome Thomas gent 761920 761920 Prodehome, Thomas, of Campeden, gent 0
5012108 2360391 2360391 plaintiff Wylley William   761920 761920 Wylley, William, of Campeden 0
5014622 2361142 2361142 defendant Weoley William woolman 761920 761920 Weoley, William, of Campeden, woolman 2
5014640 2361147 2361147 defendant Woeley William woolman 761920 761920 Woeley, William, of Campeden, woolman 2
5022769 2363572 2363572 plaintiff Wecley William   761920 761920 Wecley, William, of Campeden 2
5022774 2363573 2363573 plaintiff Wecley William   761920 761920 Wecley, William, of Campeden 2
5025740 2364430 2364430 defendant Dyer Cecily widow 761920 761920 (Dyer, Cecily, of Campeden, widow 1
5025741 2364430 2364430 defendant Bowyer Richard bowyer 761920 761920 Bowyer, Richard, of Campeden, bowyer 2
5025742 2364430 2364430 defendant Baker John baker 761920 761920 Baker, John, of Campeden, baker 3
5034119 2366844 2366844 defendant Bonefaunt William weaver 761920 761920 Bonefaunt, William, of Campeden, weaver 0
5034120 2366844 2366844 defendant Bovy William, junior weaver 761920 761920 Bovy, William, junior, of Campeden, weaver 1
5036809 2367643 2367643 plaintiff Weclay William   761920 761920 Weclay, William, of Campeden 0
5073991 2378708 2378708 plaintiff Weley William (legal representative) 761920 761920 Weley, William, of Campeden, executrix of 0
5119843 2392238 2392238 defendant Torton Richard draper 761920 761920 Torton, Richard, of Campeden, draper 0
5532902 2514832 2514832 defendant Botte John, junior husbandman 761920 761920 Botte, John, junior, of Campeden, husbandman 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);