names

53 rows where place_id = 594237

✎ 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
3615188 1872396 1872396 defendant Mason Andrew   594237 594237 Mason, Andrew, of Frome Selwode, freemason 0
3615189 1872396 1872396 defendant Badcok John laborer 594237 594237 Badcok, John, of Frome Selwode, laborer 1
3642451 1908082 1908082 defendant Aysshe John gent 594237 594237 Aysshe, John, of Frome Selwode, gent 0
3656407 1912249 1912249 defendant Taillour John clerk 594237 594237 Taillour, John, of Frome Selwode, clerk 0
3673608 1917775 1917775 defendant Twynyho John gent 594237 594237 Twynyho, John, of Frome Selwode, gent 1
3674943 1918193 1918193 defendant Kyrton Thomas gent 594237 594237 Kyrton, Thomas, of Frome Selwode, gent 0
3674944 1918193 1918193 defendant Champnes Thomas gent 594237 594237 Champnes, Thomas, of Frome Selwode, gent 1
3675289 1918311 1918311 defendant Crace John gent 594237 594237 Crace, John, of Frome Selwode, gent 0
3675290 1918311 1918311 defendant Catcott William yeoman 594237 594237 Catcott, William, of Frome Selwode, yeoman 1
3727582 1934909 1934909 defendant Champneys Joan widow 594237 594237 Champneys, Joan, of Frome Selwode, widow 0
3794275 1956082 1956082 defendant Jorden Edward butcher 594237 594237 Jorden, Edward, of Frome Selwode, butcher 0
3813112 1962011 1962011 defendant Haway John husbandman 594237 594237 Haway, John, of Frome Selwode, husbandman 1
3813569 1962162 1962162 defendant Jones William dyer 594237 594237 Jones, William, of Frome Selwode, dyer 0
3813570 1962162 1962162 defendant Gay John husbandman 594237 594237 Gay, John, of Frome Selwode, husbandman 1
3840127 1970484 1970484 defendant Burton Vincent shoemaker 594237 594237 Burton, Vincent, of Frome Selwode, shoemaker 0
3857702 1976043 1976043 defendant Abradford John, junior glover 594237 594237 Abradford, John, junior, of Frome Selwode, glover 0
3857704 1976044 1976044 defendant Abradford John, junior glover 594237 594237 Abradford, John, junior, of Frome Selwode, glover 0
3865715 1978756 1978756 defendant Androwe Thomas husbandman 594237 594237 Androwe, Thomas, of Frome Selwode, husbandman 0
3871787 1980800 1980800 defendant Hochecocke Thomas mercer 594237 594237 Hochecocke, Thomas, of Frome Selwode, mercer 0
3871788 1980800 1980800 defendant Hawkyns Thomas fisher 594237 594237 Hawkyns, Thomas, of Frome Selwode, fisher 1
3871790 1980801 1980801 defendant Schowyll Leonard husbandman 594237 594237 Schowyll, Leonard, of Frome Selwode, husbandman 0
3889538 1986733 1986733 plaintiff Gray Robert   594237 594237 Gray, Robert, of Frome Selwode, chantry chaplain 0
3924331 1998445 1998445 plaintiff Thycke John clothier 594237 594237 Thycke, John, of Frome Selwode, clothier 0
3924332 1998445 1998445 defendant Pyke Edward husbandman 594237 594237 Pyke, Edward, of Frome Selwode, husbandman 0
3986033 2019774 2019774 defendant Hutchyns John miller 594237 594237 Hutchyns, John, of Frome Selwode, miller 0
3986034 2019774 2019774 defendant Hadmot or Hadinot John miller 594237 594237 Hadmot or Hadinot, John, of Frome Selwode, miller 1
4930843 2336049 2336049 defendant Hedman John fuller 594237 594237 Hedman, John, of Frome Selwode, fuller 1
4978653 2350564 2350564 defendant Norton William skinner 594237 594237 Norton, William, of Frome Selwode, skinner 0
5051512 2372068 2372068 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 2
5073437 2378540 2378540 defendant Stokton John, junior clothmaker 594237 594237 Stokton, John, junior, of Frome Selwode, clothmaker 0
5092883 2384300 2384300 defendant Hervy William husbandman 594237 594237 Hervy, William, of Frome Selwode, husbandman 0
5123449 2393306 2393306 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 1
5132157 2395896 2395896 defendant Nicoll Thomas   594237 594237 Nicoll, Thomas, of Frome Selwode, cloth maker 1
5142322 2398873 2398873 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 1
5163621 2405097 2405097 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 1
5177186 2409021 2409021 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 1
5200036 2415762 2415762 defendant Osteler Thomas dyer 594237 594237 Osteler, Thomas, of Frome Selwode, dyer 1
5201118 2416088 2416088 defendant Terrynton William   594237 594237 Terrynton, William, of Frome Selwode, husbandman, brother of John Terryton, spice seller & husbandman 1
5226644 2423456 2423456 defendant Faukener Thomas weaver 594237 594237 Faukener, Thomas, of Frome Selwode, weaver 0
5226645 2423456 2423456 defendant Broun Henry tucker 594237 594237 Broun, Henry, of Frome Selwode, tucker 1
5239623 2427176 2427176 defendant Taunton William butcher 594237 594237 Taunton, William, of Frome Selwode, butcher 0
5239624 2427176 2427176 defendant Bocher Thomas butcher 594237 594237 Bocher, Thomas, of Frome Selwode, butcher 1
5264159 2434550 2434550 defendant Fyssher John yeoman 594237 594237 Fyssher, John, of Frome Selwode, yeoman 1
5264218 2434567 2434567 defendant Fyssher John yeoman 594237 594237 Fyssher, John, of Frome Selwode, yeoman 1
5300794 2445196 2445196 defendant Leversegge William gent 594237 594237 Leversegge, William, of Frome Selwode, gent 0
5300795 2445196 2445196 defendant Touker Walter yeoman 594237 594237 together with Touker, Walter, of Frome Selwode, yeoman 1
5385846 2471023 2471023 defendant Crocker Richard husbandman 594237 594237 Crocker, Richard, of Frome Selwode, husbandman 0
5385847 2471023 2471023 defendant Webbe John husbandman 594237 594237 Webbe, John, of Frome Selwode, husbandman 1
5398155 2474541 2474541 defendant Croker Richard yeoman 594237 594237 Croker, Richard, of Frome Selwode, yeoman 0
5400661 2475249 2475249 defendant Osborn Margaret widow 594237 594237 Osborn, Margaret, of Frome Selwode, widow 8
5411159 2478295 2478295 defendant Crase Thomas gent 594237 594237 Crase, Thomas, of Frome Selwode, gent 0
5425319 2482544 2482544 defendant Crase Thomas gent 594237 594237 Crase, Thomas, of Frome Selwode, gent 0
5546690 2519031 2519031 defendant Jamys William husbandman 594237 594237 Jamys, William, of Frome Selwode, 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);