names

85 rows where place_id = 591159

✎ 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
3603530 1868772 1868772 defendant Fryday Johnm husbandman 591159 591159 Fryday, Johnm, of Hycchyn, husbandman 0
3612540 1871556 1871556 defendant Lone or Love John   591159 591159 Lone or Love, John, of Hycchyn, wheel wright 0
3616278 1872733 1872733 plaintiff de Mynto Robert sawyer 591159 591159 de Mynto, Robert, of Hycchyn, sawyer 0
3625970 1902980 1902980 defendant Chambre William tanner 591159 591159 Chambre, William, of Hycchyn, tanner 0
3643118 1908290 1908290 defendant Toly Thomas   591159 591159 Toly, Thomas, of Hycchyn, tile maker 0
3671283 1916993 1916993 plaintiff Chetam James gent 591159 591159 Chetam, James, of Hycchyn, gent 0
3671285 1916993 1916993 defendant Gutter William maltman 591159 591159 Gutter, William, of Hycchyn, maltman 1
3681208 1920204 1920204 defendant Hyll Valentine tiler 591159 591159 Hyll, Valentine, of Hycchyn, tiler 3
3708633 1928997 1928997 defendant Gaddysdon William yeoman 591159 591159 Gaddysdon, William, of Hycchyn, yeoman 1
3802692 1958736 1958736 defendant Noddyng Christopher husbandman 591159 591159 Noddyng, Christopher, of Hycchyn, husbandman 1
4777905 2289077 2289077 defendant Sturgeon John husbandman 591159 591159 Sturgeon, John, of Hycchyn, husbandman 1
4777912 2289078 2289078 defendant Sturgeon John husbandman 591159 591159 Sturgeon, John, of Hycchyn, husbandman 1
4792607 2293777 2293777 defendant Love William butcher 591159 591159 Love, William, of Hycchyn, butcher 1
4825849 2304119 2304119 defendant Ruddok John   591159 591159 Ruddok, John, of Hycchyn, bailiff 3
4948884 2341635 2341635 defendant Benet John tiler 591159 591159 Benet, John, of Hycchyn, tiler 0
4999892 2356846 2356846 plaintiff Wynche John   591159 591159 Wynche, John, of Hycchyn 2
4999893 2356846 2356846 defendant Prexist Thomas husbandman 591159 591159 Prexist, Thomas, of Hycchyn, husbandman 0
5021140 2363080 2363080 defendant Taillour John butcher 591159 591159 Taillour, John, of Hycchyn, butcher 0
5084373 2381836 2381836 defendant Catworth Thomas chandler 591159 591159 Catworth, Thomas, of Hycchyn, chandler 0
5107883 2388742 2388742 plaintiff Edward John husbandman 591159 591159 Edward, John, of Hycchyn, husbandman 0
5150241 2401204 2401204 defendant Herts William husbandman 591159 591159 Herts, William, of Hycchyn, husbandman 0
5154909 2402595 2402595 defendant Boson Richard painter 591159 591159 Boson, Richard, of Hycchyn, painter 0
5154910 2402595 2402595 defendant Mussell Thomas dyer 591159 591159 Mussell, Thomas, of Hycchyn, dyer 1
5170430 2407080 2407080 defendant Bossahan Richard carver 591159 591159 Bossahan, Richard, of Hycchyn, carver 0
5176632 2408849 2408849 defendant Chertesey Thomas miller 591159 591159 Chertesey, Thomas, of Hycchyn, miller 0
5188142 2412247 2412247 defendant Bossahan Richard carver 591159 591159 Bossahan, Richard, of Hycchyn, carver 0
5188218 2412267 2412267 defendant Bossahan Richard carver 591159 591159 Bossahan, Richard, of Hycchyn, carver 0
5239158 2427042 2427042 defendant Sybern John husbandman 591159 591159 Sybern, John, of Hycchyn, husbandman 0
5245253 2428767 2428767 defendant Gelowe Thomas yeoman 591159 591159 Gelowe, Thomas, of Hycchyn, yeoman 0
5249158 2429875 2429875 defendant Martyn Thomas husbandman 591159 591159 Martyn, Thomas, of Hycchyn, husbandman 0
5256473 2432147 2432147 defendant Bestney Thomas, senior yeoman or chapman 591159 591159 Bestney, Thomas, senior, of Hycchyn, yeoman or chapman 1
5363648 2464285 2464285 defendant Dawer or Dalker Richard yeoman 591159 591159 Dawer or Dalker, Richard, of Hycchyn, yeoman 2
5363650 2464286 2464286 defendant Taylour William yeoman 591159 591159 Taylour, William, of Hycchyn, yeoman 0
5363652 2464286 2464286 defendant Dalker Richard yeoman 591159 591159 Dalker, Richard, of Hycchyn, yeoman 2
5364013 2464402 2464402 plaintiff Wyseberd John   591159 591159 Wyseberd, John, of Hycchyn 0
5364015 2464403 2464403 plaintiff Wyseberd John   591159 591159 Wyseberd, John, of Hycchyn 0
5385380 2470895 2470895 defendant Lawe William tilemaker 591159 591159 Lawe, William, of Hycchyn, tilemaker 2
5386404 2471182 2471182 defendant fitz Water Thomas tilemaker 591159 591159 fitz Water, Thomas, of Hycchyn, tilemaker 1
5387626 2471528 2471528 defendant Dyer John yeoman 591159 591159 Dyer, John, of Hycchyn, yeoman 2
5392998 2473068 2473068 plaintiff Snowe John   591159 591159 Snowe, John, of Hycchyn 0
5400230 2475140 2475140 defendant Dyer John yeoman 591159 591159 Dyer, John, of Hycchyn, yeoman 2
5413232 2478884 2478884 defendant Tayller William yeoman 591159 591159 Tayller, William, of Hycchyn, yeoman 0
5413234 2478884 2478884 defendant Dyer John yeoman 591159 591159 Dyer, John, of Hycchyn, yeoman 2
5419702 2480807 2480807 defendant Fellys William yeoman 591159 591159 Fellys, William, of Hycchyn, yeoman 0
5419703 2480807 2480807 defendant (illegible) Thomas tailor 591159 591159 _, Thomas, of Hycchyn, tailor 1
5419704 2480807 2480807 defendant Tayllour William tailor 591159 591159 Tayllour, William, of Hycchyn, tailor 2
5429542 2483773 2483773 defendant Burre John husbandman 591159 591159 Burre, John, of Hycchyn, husbandman 0
5429544 2483773 2483773 defendant Malyn William tilemaker 591159 591159 Malyn, William, of Hycchyn, tilemaker 2
5429546 2483773 2483773 defendant Love John husbandman 591159 591159 Love, John, of Hycchyn, husbandman 4
5429617 2483796 2483796 defendant Burre John husbandman 591159 591159 Burre, John, of Hycchyn, husbandman 0
5429618 2483796 2483796 defendant Lawe William tilemaker 591159 591159 Lawe, William, of Hycchyn, tilemaker 1
5429619 2483796 2483796 defendant Malyn William tilemaker 591159 591159 Malyn, William, of Hycchyn, tilemaker 2
5429620 2483796 2483796 defendant Dykerleder Henry shoemaker 591159 591159 Dykerleder, Henry, of Hycchyn, shoemaker 3
5429621 2483796 2483796 defendant Love John husbandman 591159 591159 Love, John, of Hycchyn, husbandman 4
5436573 2485871 2485871 defendant Tayllour William yeoman 591159 591159 Tayllour, William, of Hycchyn, yeoman 0
5436574 2485871 2485871 defendant Fellys William yeoman 591159 591159 Fellys, William, of Hycchyn, yeoman 1
5436575 2485871 2485871 defendant Dyer John yeoman 591159 591159 Dyer, John, of Hycchyn, yeoman 2
5438147 2486344 2486344 defendant Fellys William yeoman 591159 591159 Fellys, William, of Hycchyn, yeoman 0
5438148 2486344 2486344 defendant Tayllour Thomas tailor 591159 591159 Tayllour, Thomas, of Hycchyn, tailor 1
5438149 2486344 2486344 defendant Tayllour William tailor 591159 591159 Tayllour, William, of Hycchyn, tailor 2
5438157 2486346 2486346 defendant Fellys William yeoman 591159 591159 Fellys, William, of Hycchyn, yeoman 0
5438158 2486346 2486346 defendant Taillour Thomas tailor 591159 591159 Taillour, Thomas, of Hycchyn, tailor 1
5442409 2487650 2487650 defendant Clerk Lewis   591159 591159 Clerk, Lewis, of Hycchyn 0
5445532 2488560 2488560 defendant Hokyll Richard carpenter 591159 591159 Hokyll, Richard, of Hycchyn, carpenter 1
5446558 2488857 2488857 defendant Lawe William   591159 591159 Lawe, William, of Hycchyn, tile maker 1
5446559 2488857 2488857 defendant Mabye William   591159 591159 Mabye, William, of Hycchyn, tile maker 2
5446560 2488857 2488857 defendant Dykerleder Henry cordwainer 591159 591159 Dykerleder, Henry, of Hycchyn, cordwainer 3
5446561 2488857 2488857 defendant Love John husbandman 591159 591159 Love, John, of Hycchyn, husbandman 4
5462606 2493727 2493727 defendant Crosby William chandler 591159 591159 Crosby, William, of Hycchyn, chandler 2
5462611 2493728 2493728 defendant Crosby William chandler 591159 591159 Crosby, William, of Hycchyn, chandler 2
5471172 2496314 2496314 defendant Carder John husbandman 591159 591159 Carder, John, of Hycchyn, husbandman 0
5472076 2496608 2496608 defendant Tayllour William yeoman 591159 591159 Tayllour, William, of Hycchyn, yeoman 1
5474854 2497462 2497462 defendant Dyer John yeoman 591159 591159 Dyer, John, of Hycchyn, yeoman 2
5479737 2498950 2498950 plaintiff Coke John   591159 591159 Coke, John, of Hycchyn 0
5483070 2499878 2499878 defendant Crosby William chandler 591159 591159 Crosby, William, of Hycchyn, chandler 2
5483504 2500013 2500013 defendant Taillour William husbandman 591159 591159 Taillour, William, of Hycchyn, husbandman 0
5483507 2500014 2500014 defendant Tayllour William yeoman 591159 591159 Tayllour, William, of Hycchyn, yeoman 0
5498640 2504537 2504537 defendant Bele John gent 591159 591159 Bele, John, of Hycchyn, gent 0
5513318 2509017 2509017 defendant Copcote Richard yeoman 591159 591159 (Copcote, Richard, of Hycchyn, yeoman 1
5514105 2509260 2509260 plaintiff Pulter John (legal representative) 591159 591159 Pulter, John, of Hycchyn, executors of 0
5551896 2520598 2520598 defendant Funche John husbandman 591159 591159 Funche, John, of Hycchyn, husbandman 0
5594800 2533344 2533344 defendant Baker William baker 591159 591159 Baker, William, of Hycchyn, baker 1
5597624 2534155 2534155 defendant Toly Thomas husbandman 591159 591159 Toly, Thomas, of Hycchyn, husbandman 0
5597625 2534155 2534155 defendant Hurst Christopher tilemaker 591159 591159 Hurst, Christopher, of Hycchyn, tilemaker 1
5608895 2537682 2537682 defendant Lawe William   591159 591159 Lawe, William, of Hycchyn, tile maker 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);