names

62 rows where place_id = 591475

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604508 1869074 1869074 defendant Godfrey Richard gent 591475 591475 Godfrey, Richard, of Hychyn, Herts, gent 1
3631662 1904715 1904715 defendant Goldsmyth Robert chapman 591475 591475 Goldsmyth, Robert, of Hychyn, herts, chapman 2
3649709 1910281 1910281 defendant Butte Walter gent 591475 591475 Butte, Walter, of Hychyn, Herts, gent 2
3663681 1914576 1914576 defendant Bocher alias Perkes Henry yeoman 591475 591475 Bocher alias Perkes, Henry, of Hychyn, Herts, yeoman 0
3676660 1918739 1918739 defendant Perlys alias Bocher Henry butcher 591475 591475 Perlys alias Bocher, Henry, of Hychyn, Herts, butcher 0
3693102 1924050 1924050 defendant Blake John barber 591475 591475 Blake, John, of Hychyn, Herts, barber 0
3693105 1924051 1924051 defendant Goldsmyth Thomas innholder 591475 591475 Goldsmyth, Thomas, of Hychyn, Herts, innholder 0
3707387 1928601 1928601 defendant Blake John barber 591475 591475 Blake, John, of Hychyn, Herts, barber 0
3707390 1928602 1928602 defendant Goldsmyth Thomas innholder 591475 591475 Goldsmyth, Thomas, of Hychyn, Herts, innholder 0
3723330 1933567 1933567 defendant White Thomas smith 591475 591475 White, Thomas, of Hychyn, Herts, smith 0
3724513 1933952 1933952 defendant Barker John tailor 591475 591475 Barker, John, of Hychyn, Herts, tailor 0
3748102 1941331 1941331 defendant Lorkyn Thomas husbandman 591475 591475 Lorkyn, Thomas, of Hychyn, Herts, husbandman 0
3781369 1951915 1951915 defendant Goldsmyth Robert   591475 591475 Goldsmyth, Robert, of Hychyn, Herts, tallow chandler 1
3796244 1956690 1956690 defendant Clerke William   591475 591475 Clerke, William, of Hychyn, Herts, tallow chandler 0
3848693 1973179 1973179 defendant Faghe William husbandman 591475 591475 Faghe, William, of Hychyn, Herts, husbandman 0
3862170 1977533 1977533 defendant Thorowgood John yeoman 591475 591475 Thorowgood, John, of Hychyn, Herts, yeoman 0
3864156 1978200 1978200 defendant Thorowgood John yeoman 591475 591475 Thorowgood, John, of Hychyn, Herts, yeoman 0
3864158 1978201 1978201 defendant Thorowgood John yeoman 591475 591475 Thorowgood, John, of Hychyn, Herts, yeoman 0
3869862 1980166 1980166 defendant Thorogood John yeoman 591475 591475 Thorogood, John, of Hychyn, Herts, yeoman 0
3906411 1992435 1992435 defendant Teesdale William beer brewer 591475 591475 Teesdale, William, of Hychyn, Herts, beer brewer 0
3906476 1992459 1992459 defendant Yate Thomas mercer 591475 591475 Yate, Thomas, of Hychyn, Herts, mercer 1
3908980 1993297 1993297 defendant Daws Richard chapman 591475 591475 Daws, Richard, of Hychyn, Herts, chapman 3
3928167 1999756 1999756 defendant Selyng John husbandman 591475 591475 Selyng, John, of Hychyn, Herts, husbandman 1
3936085 2002390 2002390 defendant Love John (legal representative) 591475 591475 Love, John, of Hychyn, Herts, wheeler, executors of 0
3936086 2002390 2002390 defendant Parys John yeoman 591475 591475 (Parys, John, of Hychyn, Herts, yeoman 1
4043754 2040219 2040219 defendant Statham Henry chapman 591475 591475 Statham, Henry, of Hychyn, Herts, chapman 1
4051998 2043136 2043136 defendant Kympton John chapman 591475 591475 Kympton, John, of Hychyn, Herts, chapman 0
4296220 2128747 2128747 defendant French Richard chapman 591475 591475 French, Richard, of Hychyn, Herts, chapman 3
4918437 2332284 2332284 defendant Catworth Thomas chapman 591475 591475 Catworth, Thomas, of Hychyn, Herts, chapman 0
4983856 2352096 2352096 defendant Sturgeon John gent 591475 591475 Sturgeon, John, of Hychyn, Herts, gent 1
5036585 2367565 2367565 defendant Enderby John gent 591475 591475 Enderby, John, of Hychyn, Herts, gent 0
5052955 2372475 2372475 defendant Baker John yeoman 591475 591475 Baker, John, of Hychyn, Herts, yeoman 1
5066300 2376447 2376447 defendant Mathewe William stainer 591475 591475 Mathewe, William, of Hychyn, Herts, stainer 3
5195174 2414332 2414332 defendant Mathewe Roger chapman 591475 591475 Mathewe, Roger, of Hychyn, Herts, chapman 1
5209139 2418401 2418401 defendant Mathewe Roger chapman 591475 591475 Mathewe, Roger, of Hychyn, Herts, chapman 1
5209161 2418408 2418408 defendant Parker William husbandman 591475 591475 Parker, William, of Hychyn, Herts, husbandman 2
5230240 2424463 2424463 defendant Besteney Thomas chapman 591475 591475 Besteney, Thomas, of Hychyn, Herts, chapman 2
5232036 2424941 2424941 defendant Alken John butcher 591475 591475 Alken, John, of Hychyn, Herts, butcher 0
5244475 2428566 2428566 defendant Bradwater Richard yeoman 591475 591475 Bradwater, Richard, of Hychyn, Herts, yeoman 0
5244478 2428567 2428567 defendant Bradwater Richard yeoman 591475 591475 Bradwater, Richard, of Hychyn, Herts, yeoman 0
5250350 2430221 2430221 defendant Jurdon Edmund yeoman 591475 591475 Jurdon, Edmund, of Hychyn, Herts, yeoman 2
5253431 2431175 2431175 defendant Sturgeon John esq 591475 591475 Sturgeon, John, of Hychyn, Herts, esq 0
5253676 2431262 2431262 defendant Bonham Henry tiler 591475 591475 Bonham, Henry, of Hychyn, Herts, tiler 0
5253683 2431263 2431263 defendant Bonham Henry tiler 591475 591475 Bonham, Henry, of Hychyn, Herts, tiler 0
5303402 2446012 2446012 defendant fitz Water Thomas   591475 591475 fitz Water, Thomas, of Hychyn, Herts, tile maker 1
5326897 2453119 2453119 defendant Catworth John chapman 591475 591475 Catworth, John, of Hychyn, Herts, chapman 4
5368334 2465712 2465712 defendant Colyn William tanner 591475 591475 Colyn, William, of Hychyn, Herts, tanner 0
5368968 2465885 2465885 defendant Gent Edmund yeoman 591475 591475 Gent, Edmund, of Hychyn, Herts, yeoman 0
5368981 2465890 2465890 defendant Gent Edmund yeoman 591475 591475 Gent, Edmund, of Hychyn, Herts, yeoman 0
5371158 2466566 2466566 defendant Purse John smith 591475 591475 Purse, John, of Hychyn, Herts, smith 0
5395594 2473819 2473819 defendant Phares William husbandman 591475 591475 Phares, William, of Hychyn, Herts, husbandman 2
5400749 2475278 2475278 defendant Smyth John husbandman 591475 591475 Smyth, John, of Hychyn, Herts, husbandman 1
5402581 2475812 2475812 defendant Tyler William yeoman 591475 591475 Tyler, William, of Hychyn, Herts, yeoman 1
5408624 2477544 2477544 defendant Gent Edmund yeoman 591475 591475 Gent, Edmund, of Hychyn, Herts, yeoman 0
5467472 2495209 2495209 defendant Neweman Richard   591475 591475 Neweman, Richard, of Hychyn, Herts 4
5482523 2499715 2499715 defendant Chanceller John smith 591475 591475 Chanceller, John, of Hychyn, Herts, smith 0
5521398 2511508 2511508 defendant Garde Henry butcher 591475 591475 Garde, Henry, of Hychyn, Herts, butcher 0
5543968 2518222 2518222 defendant Strenger William chapman 591475 591475 Strenger, William, of Hychyn, Herts, chapman 1
5546188 2518877 2518877 defendant Webbe Roger mercer 591475 591475 Webbe, Roger, of Hychyn, Herts, mercer 0
5546190 2518878 2518878 defendant Webbe Roger mercer 591475 591475 Webbe, Roger, of Hychyn, Herts, mercer 0
5602339 2535627 2535627 defendant Slote John butcher 591475 591475 Slote, John, of Hychyn, Herts, butcher 2
5608940 2537697 2537697 defendant Purser John smith 591475 591475 Purser, John, of Hychyn, Herts, smith 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);