names

64 rows where place_id = 600198

✎ 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
3617891 1873219 1873219 defendant Broun William   600198 600198 Broun, William, of Mynchynhampton, Glos smith 0
3640144 1907364 1907364 defendant Browne William smith 600198 600198 Browne, William, of Mynchynhampton, smith 3
3656664 1912334 1912334 defendant Hynde Philip carrier 600198 600198 Hynde, Philip, of Mynchynhampton, carrier 7
3674913 1918184 1918184 defendant Strynger John butcher 600198 600198 Strynger, John, of Mynchynhampton, butcher 0
3674918 1918184 1918184 defendant Lewes Thomas weaver 600198 600198 Lewes, Thomas, of Mynchynhampton, weaver 5
3696848 1925237 1925237 defendant Stringar John butcher 600198 600198 Stringar, John, of Mynchynhampton, butcher 2
3741330 1939154 1939154 defendant Taylour John carrier 600198 600198 Taylour, John, of Mynchynhampton, carrier 0
3748008 1941296 1941296 defendant Davys Juliana widow 600198 600198 Davys, Juliana, of Mynchynhampton, widow 0
3753208 1942945 1942945 defendant Tayler Richard innholder 600198 600198 Tayler, Richard, of Mynchynhampton, innholder 0
3761965 1945750 1945750 defendant Davys Julia widow 600198 600198 Davys, Julia, of Mynchynhampton, widow 0
3761969 1945751 1945751 defendant Davys Julia widow 600198 600198 Davys, Julia, of Mynchynhampton, widow 0
3831169 1967636 1967636 defendant Davys Richard tucker 600198 600198 Davys, Richard, of Mynchynhampton, tucker 0
3883607 1984786 1984786 defendant Davyes Julia widow 600198 600198 Davyes, Julia, of Mynchynhampton, widow 1
3896749 1989124 1989124 defendant Henley John husbandman 600198 600198 Henley, John, of Mynchynhampton, husbandman 1
3913087 1994707 1994707 defendant Edwardys Richard clerk 600198 600198 Edwardys, Richard, of Mynchynhampton, clerk 0
3999716 2024660 2024660 defendant Kynne Thomas gent 600198 600198 Kynne, Thomas, of Mynchynhampton, gent 2
4050637 2042659 2042659 defendant Elkyngton Thomas clothier 600198 600198 Elkyngton, Thomas, of Mynchynhampton, clothier 0
4176241 2087167 2087167 defendant Dutton Thomas (legal representative) 600198 600198 Dutton, Thomas, of Mynchynhampton, tucker, executrix of 0
4176242 2087167 2087167 defendant Dutton Elizabeth widow 600198 600198 Dutton, Elizabeth, of Mynchynhampton, widow 1
4655828 2247702 2247702 defendant Bakere Richard laborer 600198 600198 Bakere, Richard, of Mynchynhampton, laborer 0
4655829 2247702 2247702 defendant Bakere John butcher 600198 600198 Bakere, John, of Mynchynhampton, butcher 1
4655832 2247703 2247703 defendant Bakere Richard laborer 600198 600198 Bakere, Richard, of Mynchynhampton, laborer 0
4655833 2247703 2247703 defendant Bakere John butcher 600198 600198 Bakere, John, of Mynchynhampton, butcher 1
4667669 2255599 2255599 defendant Baker John ostler 600198 600198 Baker, John, of Mynchynhampton, butcher Feld, John, of Mynchynhampton, ostler 2
4676424 2258238 2258238 defendant Laurence Thomas husbandman 600198 600198 Laurence, Thomas, of Mynchynhampton, husbandman 0
4676425 2258238 2258238 defendant Horseley John husbandman 600198 600198 Horseley, John, of Mynchynhampton, husbandman 1
4720357 2271705 2271705 defendant Laurence Thomas   600198 600198 Laurence, Thomas, of Mynchynhampton, ash burner 0
4748830 2280145 2280145 plaintiff Moris John   600198 600198 Moris, John, of Mynchynhampton, on his own account 0
4748831 2280145 2280145 defendant Webbe Nicholas   600198 600198 Webbe, Nicholas, of Mynchynhampton, plough man 0
4782471 2290526 2290526 defendant Shepherd Thomas husbandman 600198 600198 Shepherd, Thomas, of Mynchynhampton, husbandman 0
4787435 2292142 2292142 plaintiff Grymour Thomas   600198 600198 Grymour, Thomas, of Mynchynhampton 0
4787437 2292142 2292142 defendant Smyth Thomas, senior smith 600198 600198 Smyth, Thomas, senior, of Mynchynhampton, smith 1
4793346 2294017 2294017 defendant Warlowe Richard husbandman 600198 600198 Warlowe, Richard, of Mynchynhampton, husbandman 1
4863440 2315535 2315535 defendant Hampton John gent 600198 600198 Hampton, John, of Mynchynhampton, gent 0
4866602 2316514 2316514 defendant Clerk John husbandman 600198 600198 Clerk, John, of Mynchynhampton, husbandman 0
4866603 2316514 2316514 defendant Webbe Nicholas husbandman 600198 600198 Webbe, Nicholas, of Mynchynhampton, husbandman 1
4887070 2322798 2322798 defendant Redehode William husbandman 600198 600198 Redehode, William, of Mynchynhampton, husbandman 0
4915172 2331252 2331252 defendant Hampton John   600198 600198 Hampton, John, of Mynchynhampton 0
4925944 2334546 2334546 defendant Lower Robert   600198 600198 Lower, Robert, of Mynchynhampton, parson 0
4925945 2334546 2334546 defendant Shyre Richard husbandman 600198 600198 Shyre, Richard, of Mynchynhampton, husbandman 1
5065639 2376251 2376251 defendant Webbe Nicholas husbandman 600198 600198 Webbe, Nicholas, of Mynchynhampton, husbandman 0
5065640 2376251 2376251 defendant Webbe John husbandman 600198 600198 Webbe John, of Mynchynhampton, husbandman 1
5065643 2376252 2376252 defendant Webbe Nicholas husbandman 600198 600198 Webbe, Nicholas, of Mynchynhampton, husbandman 0
5065644 2376252 2376252 defendant Webbe John husbandman 600198 600198 Webbe John, of Mynchynhampton, husbandman 1
5184849 2411317 2411317 defendant Horshale Thomas fuller 600198 600198 Horshale, Thomas, of Mynchynhampton, fuller 0
5314458 2449352 2449352 defendant Pope William tucker 600198 600198 Pope, William, of Mynchynhampton, tucker 0
5314459 2449352 2449352 defendant Pope Thomas tucker 600198 600198 Pope, Thomas, of Mynchynhampton, tucker 1
5314460 2449352 2449352 defendant Pope John, junior tucker 600198 600198 Pope, John, junior, of Mynchynhampton, tucker 2
5314462 2449353 2449353 defendant Pope William tucker 600198 600198 Pope, William, of Mynchynhampton, tucker 0
5314463 2449353 2449353 defendant Pope Thomas tucker 600198 600198 Pope, Thomas, of Mynchynhampton, tucker 1
5314464 2449353 2449353 defendant Pope John, junior tucker 600198 600198 Pope, John, junior, of Mynchynhampton, tucker 2
5333254 2455018 2455018 defendant Avenell John yeoman 600198 600198 Avenell, John, of Mynchynhampton, yeoman 0
5336458 2455971 2455971 defendant Dutton Thomas fuller 600198 600198 Dutton, Thomas, of Mynchynhampton, fuller 0
5336464 2455974 2455974 defendant Dutton Thomas fuller 600198 600198 Dutton, Thomas, of Mynchynhampton, fuller 0
5354147 2461363 2461363 defendant Feld John husbandman 600198 600198 Feld, John, of Mynchynhampton, husbandman 0
5401199 2475404 2475404 defendant Broun William smith 600198 600198 Broun, William, of Mynchynhampton, smith 2
5518896 2510748 2510748 defendant Poope Richard tucker 600198 600198 Poope, Richard, of Mynchynhampton, tucker 0
5518897 2510748 2510748 defendant Browene William husbandman 600198 600198 Browene, William, of Mynchynhampton, husbandman 1
5518898 2510748 2510748 defendant Day John husbandman 600198 600198 Day, John, of Mynchynhampton, husbandman 2
5568573 2525360 2525360 defendant Strynger John butcher 600198 600198 Strynger, John, of Mynchynhampton, butcher 1
5580322 2528928 2528928 defendant Strynger John butcher 600198 600198 Strynger, John, of Mynchynhampton, butcher 0
5585706 2530599 2530599 defendant Hale Robert tyeoman 600198 600198 Hale, Robert, of Mynchynhampton, tyeoman 2
5585710 2530600 2530600 defendant Halle Robert yeoman 600198 600198 Halle, Robert, of Mynchynhampton, yeoman 2
5589064 2531586 2531586 defendant Halyday Edward clothier 600198 600198 Halyday, Edward, of Mynchynhampton, clothier 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);