names

41 rows where place_id = 586942

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590043 1864525 1864525 defendant Byrde Thomas yeoman 586942 586942 Byrde, Thomas, of Stoke Naylond, yeoman 1
3624206 1875103 1875103 defendant Grene John husbandman 586942 586942 Grene, John, of Stoke Naylond, husbandman 3
3667911 1915905 1915905 plaintiff Abell John, junior merchant 586942 586942 Abell, John, junior, of Stoke Naylond, merchant 0
3702738 1927128 1927128 defendant Culpak John husbandman 586942 586942 Culpak, John, of Stoke Naylond, husbandman 1
3710329 1929547 1929547 defendant Hewett John merchant 586942 586942 Hewett, John, of Stoke Naylond, merchant 0
3727355 1934830 1934830 defendant Nicoll Thomas weaver 586942 586942 Nicoll, Thomas, of Stoke Naylond, weaver 1
3728797 1935254 1935254 plaintiff Abell Anne widow 586942 586942 Abell, Anne, of Stoke Naylond, widow 0
3739895 1938694 1938694 defendant Turnyr John butcher 586942 586942 Turnyr, John, of Stoke Naylond, butcher 0
3739897 1938695 1938695 defendant Turnyr John butcher 586942 586942 Turnyr, John, of Stoke Naylond, butcher 0
3739898 1938696 1938696 plaintiff Pygott Richard clothmaker 586942 586942 Pygott, Richard, of Stoke Naylond, clothmaker 0
3743961 1940000 1940000 plaintiff Abell Anne widow 586942 586942 Abell, Anne, of Stoke Naylond, widow 0
3755988 1943827 1943827 plaintiff Abell Anne widow 586942 586942 Abell, Anne, of Stoke Naylond, widow 0
3773977 1949577 1949577 plaintiff Abell John, senior (legal representative) 586942 586942 Abell, John, senior, of Stoke Naylond, clothier, executor of 0
3780333 1951580 1951580 defendant Smyth John laborer 586942 586942 Smyth, John, of Stoke Naylond, laborer 2
3837913 1969771 1969771 defendant Frethe Thomas (legal representative) 586942 586942 Frethe, Thomas, of Stoke Naylond, clothier, administratrix of 3
3837919 1969772 1969772 defendant Frethe Thomas (legal representative) 586942 586942 Frethe, Thomas, of Stoke Naylond, clothier, administratrix of 3
3844161 1971723 1971723 plaintiff Cowper Robert clothman 586942 586942 Cowper, Robert, of Stoke Naylond, clothman 0
3872672 1981076 1981076 defendant Smythe Thomas clothmaker 586942 586942 Smythe, Thomas, of Stoke Naylond, clothmaker 3
3885098 1985275 1985275 plaintiff Baker George   586942 586942 Baker, George, of Stoke Naylond 0
3912996 1994679 1994679 defendant Smyth Thomas clothier 586942 586942 Smyth, Thomas, of Stoke Naylond, clothier 3
3946375 2005804 2005804 defendant Abbys John grocer 586942 586942 Abbys, John, of Stoke Naylond, yeoman, or of Norwich, grocer 0
3989640 2021038 2021038 defendant Abbys John grocer 586942 586942 Abbys, John, of Stoke Naylond, grocer 0
4062285 2046800 2046800 defendant Baker Peter yeoman 586942 586942 Baker, Peter, of Stoke Naylond, yeoman 3
4104895 2062027 2062027 plaintiff Moyle Geoffrey (legal representative) 586942 586942 Moyle, Geoffrey, of Stoke Naylond, gent, executor of 0
4448538 2184473 2184473 plaintiff Freman Robert   586942 586942 Freman, Robert, of Stoke Naylond 0
4554821 2217433 2217433 defendant Rysyng James   586942 586942 Rysyng, James, of Stoke Naylond, wool monger 3
4611382 2234619 2234619 defendant Rigge Robert   586942 586942 Rigge, Robert, of Stoke Naylond 3
4611389 2234620 2234620 defendant Rigge Robert   586942 586942 Rigge, Robert, of Stoke Naylond 3
4759788 2283396 2283396 defendant Colman Andrew   586942 586942 Colman, Andrew, of Stoke Naylond, bailiff 1
4915366 2331314 2331314 defendant Gybon John butcher 586942 586942 Gybon, John, of Stoke Naylond, butcher 0
4922508 2333456 2333456 plaintiff Lord alias Ken John (legal representative) 586942 586942 Lord alias Ken, John, of Stoke Naylond, executors of 0
5439196 2486649 2486649 defendant Debenham John weaver 586942 586942 Debenham, John, of Stoke Naylond, weaver 0
5439197 2486649 2486649 defendant Brygge Thomas weaver 586942 586942 Brygge, Thomas, of Stoke Naylond, weaver 1
5452949 2490762 2490762 defendant Terry Robert   586942 586942 Terry, Robert, of Stoke Naylond, cloth maker 0
5453034 2490789 2490789 defendant Debenham John weaver 586942 586942 Debenham, John, of Stoke Naylond, weaver 0
5453035 2490789 2490789 defendant Brygge Thomas weaver 586942 586942 Brygge, Thomas, of Stoke Naylond, weaver 1
5471002 2496264 2496264 defendant Bolthode William   586942 586942 Bolthode, William, of Stoke Naylond, woad man 1
5487550 2501169 2501169 defendant Palgrave William yeoman 586942 586942 Palgrave, William, of Stoke Naylond, yeoman 3
5489628 2501779 2501779 defendant Page Richard clothmaker 586942 586942 Page, Richard, of Stoke Naylond, clothmaker 0
5529536 2513736 2513736 defendant Lambart William carrier 586942 586942 Lambart, William, of Stoke Naylond, carrier 1
5564116 2524121 2524121 defendant Spyrlyng Robert husbandman 586942 586942 Spyrlyng, Robert, of Stoke Naylond, husbandman 2

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