names

80 rows where place_id = 587798

✎ 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
3592470 1865260 1865260 defendant Maye Robert clothman 587798 587798 (Maye, Robert, of Bokkyng, Essex, clothman 2
3619713 1873736 1873736 defendant Cowman Tendryng clothier 587798 587798 Cowman, Tendryng, of Bokkyng, Essex, clothier 1
3619717 1873737 1873737 defendant Cowman Tendryng clothier 587798 587798 Cowman, Tendryng, of Bokkyng, Essex, clothier 1
3676009 1918534 1918534 defendant Purcas John yeoman 587798 587798 Purcas, John, of Bokkyng, Essex, yeoman 0
3738093 1938133 1938133 plaintiff May Julia widow 587798 587798 May, Julia, of Bokkyng, Essex, widow 0
3861002 1977163 1977163 defendant Debnom Robert fuller 587798 587798 Debnom, Robert, of Bokkyng, Essex, fuller 2
3894525 1988378 1988378 plaintiff Newman Richard yeoman 587798 587798 Newman, Richard, of Bokkyng, Essex, yeoman 1
3917223 1996120 1996120 plaintiff Goodwyn William clothier 587798 587798 Goodwyn, William, of Bokkyng, Essex, clothier 0
4696309 2264328 2264328 defendant Kyng John   587798 587798 Kyng, John, of Bokkyng, Essex, parson 1
4696313 2264329 2264329 defendant Kyng John   587798 587798 Kyng, John, of Bokkyng, Essex, parson 1
4782483 2290531 2290531 defendant Sturyon Stephen carpenter 587798 587798 Sturyon, Stephen, of Bokkyng, Essex, carpenter 0
4830858 2305677 2305677 defendant Curteys John   587798 587798 Curteys, John, of Bokkyng, Essex 5
4836715 2307450 2307450 defendant Curteys John husbandman 587798 587798 Curteys, John, of Bokkyng, Essex, husbandman 0
4836718 2307451 2307451 defendant Curteys John husbandman 587798 587798 Curteys, John, of Bokkyng, Essex, husbandman 0
4844689 2309855 2309855 defendant Risseley John husbandman 587798 587798 Risseley, John, of Bokkyng, Essex, husbandman 2
4852814 2312297 2312297 defendant Curteys John husbandman 587798 587798 Curteys, John, of Bokkyng, Essex, husbandman 1
4917230 2331896 2331896 defendant Bolthode John laborer 587798 587798 Bolthode, John, of Bokkyng, Essex, laborer 0
4934402 2337151 2337151 defendant Boter Robert dyer 587798 587798 Boter, Robert, of Bokkyng, Essex, dyer 1
4972273 2348651 2348651 defendant Doreward John esq 587798 587798 Doreward, John, of Bokkyng, Essex, esq 0
4984535 2352305 2352305 defendant Goter Robert dyer 587798 587798 Goter, Robert, of Bokkyng, Essex, dyer 0
4987503 2353220 2353220 defendant Curteys John yeoman 587798 587798 Curteys, John, of Bokkyng, Essex, yeoman 0
4998620 2356473 2356473 defendant Durward John esq 587798 587798 Durward, John, of Bokkyng, Essex, esq 0
5008511 2359386 2359386 defendant Goter Robert dyer 587798 587798 Goter, Robert, of Bokkyng, Essex, dyer 0
5008702 2359438 2359438 defendant Goter Robert dyer 587798 587798 Goter, Robert, of Bokkyng, Essex, dyer 0
5008895 2359497 2359497 defendant Symond Robert   587798 587798 Symond, Robert, of Bokkyng, Essex, servant 1
5010259 2359864 2359864 defendant Gutter Robert dyer 587798 587798 Gutter, Robert, of Bokkyng, Essex, dyer 2
5011612 2360254 2360254 defendant Gutter Robert dyer 587798 587798 Gutter, Robert, of Bokkyng, Essex, dyer 2
5054559 2372936 2372936 defendant Claryon William fuller 587798 587798 Claryon, William, of Bokkyng, Essex, fuller 0
5077391 2379737 2379737 defendant Dereward Richard esq 587798 587798 Dereward, Richard, of Bokkyng, Essex, esq 0
5088346 2382966 2382966 defendant Doreward John gent 587798 587798 Doreward, John, of Bokkyng, Essex, gent 0
5117841 2391645 2391645 defendant Doreward John, junior esq 587798 587798 Doreward, John, junior, of Bokkyng, Essex, esq 0
5120642 2392465 2392465 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 0
5123503 2393326 2393326 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5123541 2393338 2393338 defendant Doreward John, senior esq 587798 587798 Doreward, John, senior, of Bokkyng, Essex, esq 0
5128346 2394768 2394768 defendant Northfoke Thomas   587798 587798 Northfoke, Thomas, of Bokkyng, Essex, scaldere 3
5132740 2396070 2396070 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 1
5135909 2397015 2397015 defendant (illegible) William weaver 587798 587798 ----, William, of Bokkyng, Essex, weaver 4
5146388 2400074 2400074 defendant Norffolk Thomas dyer 587798 587798 Norffolk, Thomas, of Bokkyng, Essex, dyer 1
5149285 2400921 2400921 defendant Norfolk Thomas dyer 587798 587798 Norfolk, Thomas, of Bokkyng, Essex, dyer 1
5166293 2405863 2405863 defendant Wryght Richard tanner 587798 587798 Wryght, Richard, of Bokkyng, Essex, tanner 3
5195962 2414565 2414565 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5195964 2414566 2414566 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5202668 2416540 2416540 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5202671 2416541 2416541 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5209473 2418510 2418510 defendant Doreward William esq 587798 587798 Doreward, William, of Bokkyng, Essex, esq 0
5210568 2418827 2418827 defendant Hoberd William husbandman 587798 587798 Hoberd, William, of Bokkyng, Essex, husbandman 3
5219126 2421319 2421319 defendant Durward John esq 587798 587798 Durward, John, of Bokkyng, Essex, esq 0
5219618 2421471 2421471 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 0
5219620 2421472 2421472 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 0
5224924 2422962 2422962 defendant Doreward William gent 587798 587798 Doreward, William, of Bokkyng, Essex, gent 4
5257751 2432543 2432543 defendant Durward John   587798 587798 Durward, John, of Bokkyng, Essex, knight 0
5277317 2438444 2438444 defendant Auncell John yeoman 587798 587798 Auncell, John, of Bokkyng, Essex, yeoman 1
5295325 2443628 2443628 defendant Helder Robert (legal representative) 587798 587798 Helder, Robert, of Bokkyng, Essex, husbandman, executors of 0
5295331 2443629 2443629 defendant Helder Robert (legal representative) 587798 587798 Helder, Robert, of Bokkyng, Essex, husbandman, executors of 0
5305914 2446754 2446754 defendant Doreward John   587798 587798 Doreward, John, of Bokkyng, Essex, knight 1
5312984 2448914 2448914 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 0
5353326 2461117 2461117 defendant Durward John gent 587798 587798 Durward, John, of Bokkyng, Essex, gent 0
5353328 2461118 2461118 defendant Durward John gent 587798 587798 Durward, John, of Bokkyng, Essex, gent 0
5360927 2463443 2463443 defendant Doreward Richard esq 587798 587798 Doreward, Richard, of Bokkyng, Essex, esq 3
5360933 2463444 2463444 defendant Dorreward Richard esq 587798 587798 Dorreward, Richard, of Bokkyng, Essex, esq 4
5370764 2466444 2466444 defendant Clerk William chapman 587798 587798 Clerk, William, of Bokkyng, Essex, chapman 0
5371598 2466702 2466702 defendant Clerk William chapman 587798 587798 Clerk, William, of Bokkyng, Essex, chapman 0
5372929 2467123 2467123 defendant Strecthe Richard yeoman 587798 587798 Strecthe, Richard, of Bokkyng, Essex, yeoman 0
5376348 2468200 2468200 defendant Freman Richard husbandman 587798 587798 Freman, Richard, of Bokkyng, Essex, husbandman 0
5379019 2469030 2469030 defendant Aleyn Richard clothier 587798 587798 Aleyn, Richard, of Bokkyng, Essex, clothier 0
5379024 2469031 2469031 defendant Gerold Thomas maker of nails 587798 587798 Gerold, Thomas, of Bokkyng, Essex, maker of nails 1
5405335 2476609 2476609 defendant Buksted John husbandman 587798 587798 Buksted, John, of Bokkyng, Essex, husbandman 1
5418408 2480434 2480434 defendant Buksted John husbandman 587798 587798 Buksted, John, of Bokkyng, Essex, husbandman 0
5454078 2491114 2491114 defendant Swalowe (illegible) dyer 587798 587798 Swalowe, _, of Bokkyng, Essex, dyer 1
5464003 2494150 2494150 defendant Eyre Richard shoemaker 587798 587798 Eyre, Richard, of Bokkyng, Essex, shoemaker 2
5468088 2495397 2495397 defendant Freman Richard husbandman 587798 587798 Freman, Richard, of Bokkyng, Essex, husbandman 0
5486458 2500841 2500841 defendant Freman Richard husbandman 587798 587798 Freman, Richard, of Bokkyng, Essex, husbandman 1
5490839 2502156 2502156 defendant Balles Thomas clerk 587798 587798 Balles, Thomas, of Bokkyng, Essex, clerk 2
5497953 2504335 2504335 defendant Freman Thomas yeoman 587798 587798 Freman, Thomas, of Bokkyng, Essex, yeoman 0
5527938 2513304 2513304 defendant Loveday Thomas clothman 587798 587798 Loveday, Thomas, of Bokkyng, Essex, clothman 1
5534883 2515453 2515453 defendant Bate William clothmaker 587798 587798 Bate, William, of Bokkyng, Essex, clothmaker 1
5539755 2516914 2516914 defendant Bate William haberdasher 587798 587798 Bate, William, of Bokkyng, Essex, haberdasher 0
5551686 2520534 2520534 defendant Bedyll William fuller 587798 587798 Bedyll, William, of Bokkyng, Essex, fuller 0
5561540 2523358 2523358 defendant Freman Thomas yeoman 587798 587798 Freman, Thomas, of Bokkyng, Essex, yeoman 0
5592350 2532592 2532592 defendant Bereman William weaver 587798 587798 Bereman, William, of Bokkyng, Essex, weaver 4

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);