names

61 rows where place_id = 586418

✎ 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
3588680 1864104 1864104 plaintiff Bole John   586418 586418 Bole, John, of Garboldesham 0
3596647 1866586 1866586 defendant Leveryngton William yeoman 586418 586418 Leveryngton, William, of Garboldesham, yeoman 0
3616031 1872648 1872648 defendant Northclyff Richard yeoman 586418 586418 Northclyff, Richard, of Garboldesham, yeoman 2
3716916 1931577 1931577 defendant Crane Richard husbandman 586418 586418 Crane, Richard, of Garboldesham, husbandman 0
3732602 1936426 1936426 defendant Crane Richard husbandman 586418 586418 Crane, Richard, of Garboldesham, husbandman 0
3813901 1962259 1962259 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 0
3857006 1975824 1975824 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 0
3861271 1977239 1977239 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 0
3865672 1978738 1978738 defendant Cawdell John husbandman 586418 586418 Cawdell, John, of Garboldesham, husbandman 0
3880462 1983721 1983721 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 3
3885320 1985344 1985344 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 0
3885323 1985345 1985345 defendant Bolton William gent 586418 586418 Bolton, William, of Garboldesham, gent 0
3889229 1986635 1986635 defendant Johnson William yeoman 586418 586418 Johnson, William, of Garboldesham, yeoman 1
3903415 1991367 1991367 defendant Jhonson William, senior yeoman 586418 586418 Jhonson, William,senior, of Garboldesham, yeoman 1
3903416 1991367 1991367 defendant Curteys Robert yeoman 586418 586418 Curteys, Robert, of Garboldesham, yeoman 2
3920859 1997320 1997320 defendant Cawdell John husbandman 586418 586418 Cawdell, John, of Garboldesham, husbandman 0
3986710 2019986 2019986 defendant Marten John blacksmith 586418 586418 Marten, John, of Garboldesham, blacksmith 3
4059692 2045860 2045860 defendant Harrys Gilbert yeoman 586418 586418 Harrys, Gilbert, of Garboldesham, yeoman 0
4275650 2121428 2121428 defendant Brooke Richard clerk 586418 586418 Brooke, Richard, of Garboldesham, clerk 0
4325831 2139013 2139013 defendant Vyncent William husbandman 586418 586418 Vyncent, William, of Garboldesham, husbandman 0
4336835 2142611 2142611 defendant Launer Henry   586418 586418 Launer, Henry, of Garboldesham, shepherd 1
4405886 2166532 2166532 defendant Parkyn William yeoman 586418 586418 Parkyn, William, of Garboldesham, yeoman 1
4405887 2166532 2166532 defendant Osborne Robert husbandman 586418 586418 Osborne, Robert, of Garboldesham, husbandman 2
4407359 2167023 2167023 defendant Pulham Robert gent 586418 586418 Pulham, Robert, of Garboldesham, gent 0
4407360 2167023 2167023 defendant Woodwarde Richard gent 586418 586418 Woodwarde, Richard, of Garboldesham, gent 1
4458203 2187605 2187605 defendant Golde Adam   586418 586418 Golde, Adam, of Garboldesham 0
4569549 2222061 2222061 defendant Colman John   586418 586418 Colman, John, of Garboldesham 3
4737505 2276843 2276843 defendant Love Thomas yeoman 586418 586418 Love, Thomas, of Garboldesham, yeoman 2
4796843 2295169 2295169 plaintiff Shepherd Edmund   586418 586418 Shepherd, Edmund, of Garboldesham 0
4796844 2295169 2295169 plaintiff Beybey John   586418 586418 Beybey, John, of Garboldesham 1
4796845 2295169 2295169 defendant atte Cherche John, senior yeoman 586418 586418 atte Cherche, John, senior, of Garboldesham, yeoman 0
4796846 2295169 2295169 defendant Beton Denis carpenter 586418 586418 Beton, Denis, of Garboldesham, carpenter 1
4885113 2322235 2322235 defendant Steyne Richard butcher 586418 586418 Steyne, Richard, of Garboldesham, butcher 1
4889748 2323588 2323588 defendant Steyne Richard butcher 586418 586418 Steyne, Richard, of Garboldesham, butcher 1
4935775 2337581 2337581 defendant Wryght William carpenter 586418 586418 Wryght, William, of Garboldesham, carpenter 0
4945145 2340462 2340462 defendant Burgeys John yeoman 586418 586418 Burgeys, John, of Garboldesham, yeoman 1
4977142 2350118 2350118 defendant Steyne John husbandman 586418 586418 Steyne, John, of Garboldesham, husbandman 1
4984807 2352387 2352387 defendant Bettys John dyer 586418 586418 Bettys, John, of Garboldesham, dyer 0
4998533 2356443 2356443 defendant Bettes John dyer 586418 586418 Bettes, John, of Garboldesham, dyer 0
5003034 2357792 2357792 defendant Scalpy John husbandman 586418 586418 Scalpy, John, of Garboldesham, husbandman 0
5003036 2357793 2357793 defendant Scalpy John husbandman 586418 586418 Scalpy, John, of Garboldesham, husbandman 0
5014563 2361126 2361126 defendant Smyth John, senior yeoman 586418 586418 Smyth, John, senior, of Garboldesham, yeoman 0
5014565 2361126 2361126 defendant Smyth Robert yeoman 586418 586418 Smyth, Robert, of Garboldesham, yeoman 2
5014566 2361126 2361126 defendant Bole John, junior   586418 586418 Bole, John, junior, of Garboldesham, wright 3
5014567 2361126 2361126 defendant Baxter John, junior smith 586418 586418 Baxter, John, junior, of Garboldesham, smith 4
5033423 2366657 2366657 plaintiff Smyth John   586418 586418 Smyth, John, of Garboldesham 0
5186945 2411921 2411921 plaintiff Halle John   586418 586418 Halle, John, of Garboldesham, parson 0
5201498 2416195 2416195 defendant Nortclyff Ralph husbandman 586418 586418 Nortclyff, Ralph, of Garboldesham, husbandman 2
5275782 2437984 2437984 defendant Boole John   586418 586418 Boole, John, of Garboldesham 0
5278863 2438929 2438929 plaintiff Bole John   586418 586418 Bole, John, of Garboldesham 0
5313332 2449026 2449026 defendant Grene William husbandman 586418 586418 Grene, William, of Garboldesham, husbandman 0
5313333 2449026 2449026 defendant Bole William carpenter 586418 586418 Bole, William, of Garboldesham, carpenter 1
5313334 2449026 2449026 defendant Baxter John smith 586418 586418 Baxter, John, of Garboldesham, smith 2
5362031 2463790 2463790 defendant Cowper John butcher 586418 586418 Cowper, John, of Garboldesham, butcher 1
5372205 2466900 2466900 defendant Coweper John butcher 586418 586418 Coweper, John, of Garboldesham, butcher 1
5469263 2495738 2495738 defendant N_ Richard husbandman 586418 586418 N_, Richard, of Garboldesham, husbandman 1
5499404 2504762 2504762 defendant Leveryngton William yeoman 586418 586418 Leveryngton, William, of Garboldesham, yeoman 0
5513957 2509213 2509213 defendant Leveryngton William yeoman 586418 586418 Leveryngton, William, of Garboldesham, yeoman 0
5538039 2516384 2516384 defendant Bole John (legal representative) 586418 586418 Bole, John, of Garboldesham, yeoman, executors of 7
5545441 2518656 2518656 defendant Lyng or Byng John smith 586418 586418 Lyng or Byng, John, of Garboldesham, smith 0
5575326 2527372 2527372 defendant Baxter John husbandman 586418 586418 Baxter, John, of Garboldesham, husbandman 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);