names

69 rows where place_id = 586989

✎ 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
3590160 1864561 1864561 defendant Yermuth John gent 586989 586989 Yermuth, John, of Blundeston, gent 0
3606225 1869615 1869615 defendant Crowe John (legal representative) 586989 586989 Crowe, John, of Blundeston, executor of 4
3606226 1869615 1869615 defendant Nicolls Thomas husbandman 586989 586989 Nicolls, Thomas, of Blundeston, husbandman 5
3640551 1907482 1907482 defendant Arnold William husbandman 586989 586989 Arnold, William, of Blundeston, husbandman 0
3646909 1909432 1909432 defendant Arnolde John husbandman 586989 586989 Arnolde, John, of Blundeston, husbandman 0
3655142 1911870 1911870 plaintiff Cart Thomas   586989 586989 Cart, Thomas, of Blundeston 1
3655616 1912019 1912019 defendant Yermouth John gent 586989 586989 Yermouth, John, of Blundeston, gent 0
3663982 1914678 1914678 defendant Wynston Edmund yeoman 586989 586989 Wynston, Edmund, of Blundeston, yeoman 0
3665236 1915082 1915082 defendant Wynston Edmund yeoman 586989 586989 Wynston, Edmund, of Blundeston, yeoman 0
3693069 1924040 1924040 defendant Carman William husbandman 586989 586989 Carman, William, of Blundeston, husbandman 0
3698068 1925622 1925622 defendant Stephens Richard husbandman 586989 586989 Stephens, Richard, of Blundeston, husbandman 0
3713203 1930432 1930432 defendant Maundevile Thomas husbandman 586989 586989 Maundevile, Thomas, of Blundeston, husbandman 0
3713204 1930432 1930432 defendant Wrentham William husbandman 586989 586989 Wrentham, William, of Blundeston, husbandman 1
3742283 1939458 1939458 defendant Smyth Benedict husbandman 586989 586989 Smyth, Benedict, of Blundeston, husbandman 0
3742529 1939536 1939536 defendant Arnold William husbandman 586989 586989 Arnold, William, of Blundeston, husbandman 0
3742533 1939537 1939537 defendant Arnold William husbandman 586989 586989 Arnold, William, of Blundeston, husbandman 0
3747126 1941018 1941018 defendant Wrentham William husbandman 586989 586989 Wrentham, William, of Blundeston, husbandman 0
3747136 1941021 1941021 defendant Camell William smith 586989 586989 Camell, William, of Blundeston, smith 1
3752773 1942792 1942792 defendant Thurmede John husbandman 586989 586989 Thurmede, John, of Blundeston, husbandman 1
3771315 1948720 1948720 plaintiff Stroppe Thomas   586989 586989 Stroppe, Thomas, of Blundeston 0
3808033 1960402 1960402 defendant Starys Henry husbandman 586989 586989 Starys, Henry, of Blundeston, husbandman 4
3809852 1960969 1960969 defendant Yermouth Henry gent 586989 586989 Yermouth, Henry, of Blundeston, gent 0
3810345 1961126 1961126 defendant Smyth James husbandman or innkeeper 586989 586989 Smyth, James, of Blundeston, husbandman or innkeeper 0
3832790 1968184 1968184 defendant Thurmodo Robert husbandman 586989 586989 Thurmodo, Robert, of Blundeston, husbandman 0
3897723 1989447 1989447 defendant Camell William smith 586989 586989 Camell, William, of Blundeston, smith 0
4279197 2122656 2122656 defendant Preste Thomas husbandman 586989 586989 Preste, Thomas, of Blundeston, or of Lownde, husbandman 0
4428166 2173641 2173641 defendant Priour Roger   586989 586989 Priour, Roger, of Blundeston 6
4511667 2204098 2204098 defendant Gunville Edmund   586989 586989 Gunville, Edmund, of Blundeston 0
4511670 2204098 2204098 defendant Pye John   586989 586989 Pye, John, of Blundeston 3
4757018 2282565 2282565 defendant Chapelleyn John laborer 586989 586989 Chapelleyn, John, of Blundeston, laborer 0
4766108 2285390 2285390 defendant Seman John yeoman 586989 586989 Seman, John, of Blundeston, yeoman 1
4935518 2337506 2337506 defendant Crowe John husbandman 586989 586989 Crowe, John, of Blundeston, husbandman 0
4992701 2354699 2354699 defendant Crowe John husbandman 586989 586989 Crowe, John, of Blundeston, husbandman 0
4992702 2354699 2354699 defendant Dunswell Edmund husbandman 586989 586989 Dunswell, Edmund, of Blundeston, husbandman 1
4992703 2354699 2354699 defendant Balkborne John husbandman 586989 586989 Balkborne, John, of Blundeston, husbandman 2
5070875 2377784 2377784 defendant Yernemouth Henry gent 586989 586989 Yernemouth, Henry, of Blundeston, gent 0
5119604 2392167 2392167 defendant Yernemouth Henry gent 586989 586989 Yernemouth, Henry, of Blundeston, gent 0
5137420 2397458 2397458 defendant Yermouth Henry gent 586989 586989 Yermouth, Henry, of Blundeston, gent 0
5137422 2397459 2397459 defendant Yermouth Henry gent 586989 586989 Yermouth, Henry, of Blundeston, gent 0
5140594 2398358 2398358 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 3
5158085 2403487 2403487 defendant Yermouth Henry gent 586989 586989 Yermouth, Henry, of Blundeston, gent 0
5161700 2404526 2404526 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 2
5173788 2408030 2408030 defendant Yermouth Henry gent 586989 586989 Yermouth, Henry, of Blundeston, gent 0
5176006 2408666 2408666 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 2
5188948 2412503 2412503 defendant Wynston atte Hill John husbandman 586989 586989 Wynston atte Hill, John, of Blundeston, husbandman 0
5188951 2412504 2412504 defendant Wynston att Hill John husbandman 586989 586989 Wynston att Hill, John, of Blundeston, husbandman 0
5196794 2414812 2414812 defendant Wynston att Hyll John husbandman 586989 586989 Wynston att Hyll, John, of Blundeston, husbandman 0
5196796 2414812 2414812 defendant Neweman Margaret   586989 586989 Neweman, Margaret, of Blundeston, servant 2
5196801 2414813 2414813 defendant Wynston atte Hyll John husbandman 586989 586989 Wynston atte Hyll, John, of Blundeston, husbandman 0
5196803 2414813 2414813 defendant Neweman Margaret   586989 586989 Neweman, Margaret, of Blundeston, servant 2
5197807 2415097 2415097 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 2
5206308 2417582 2417582 defendant Wynston atte Hill John husbandman 586989 586989 Wynston atte Hill, John, of Blundeston, husbandman 0
5206309 2417582 2417582 defendant Lacebond Thomas yeoman 586989 586989 Lacebond, Thomas, of Blundeston, yeoman 1
5206311 2417583 2417583 defendant Wynston atte Hill John husbandman 586989 586989 Wynston atte Hill, John, of Blundeston, husbandman 0
5209826 2418608 2418608 defendant Wynston atte Hill John husbandman 586989 586989 Wynston atte Hill, John, of Blundeston, husbandman 0
5209828 2418608 2418608 defendant Neweman Margaret   586989 586989 Neweman, Margaret, of Blundeston, servant 2
5210291 2418736 2418736 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 2
5230392 2424505 2424505 defendant Jernemouth Henry gent 586989 586989 Jernemouth, Henry, of Blundeston, gent 0
5230395 2424505 2424505 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 3
5230396 2424505 2424505 defendant Clerk William husbandman 586989 586989 Clerk, William, of Blundeston, husbandman 4
5230400 2424506 2424506 defendant Jernemuth Henry gent 586989 586989 Jernemuth, Henry, of Blundeston, gent 0
5230403 2424506 2424506 defendant Chapeleyn John husbandman 586989 586989 Chapeleyn, John, of Blundeston, husbandman 3
5230404 2424506 2424506 defendant Clerk William husbandman 586989 586989 Clerk, William, of Blundeston, husbandman 4
5287132 2441248 2441248 defendant Yermouth John gent 586989 586989 Yermouth, John, of Blundeston, gent 0
5304750 2446420 2446420 defendant Yermouth John gent 586989 586989 Yermouth, John, of Blundeston, gent 0
5355324 2461739 2461739 defendant Yermouth John gent 586989 586989 Yermouth, John, of Blundeston, gent 0
5355327 2461740 2461740 defendant Yermouth John gent 586989 586989 Yermouth, John, of Blundeston, gent 0
5601279 2535291 2535291 defendant Arnold Thomas husbandman 586989 586989 Arnold, Thomas, of Blundeston, husbandman 0
5603248 2535900 2535900 defendant Arnold Thomas butcher 586989 586989 Arnold, Thomas, of Blundeston, butcher 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);