names

55 rows where place_id = 633390

✎ 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
3812482 1961791 1961791 defendant Corbet Thomas gent 633390 633390 Corbet, Thomas, of Shropshire, gent 4
4415704 2169798 2169798 plaintiff Hulion Richard (legal representative) 633390 633390 Hulion, Richard, of Shropshire, merchant, executors of 0
4453537 2186115 2186115 defendant Cates Thomas   633390 633390 Cates, Thomas, of Shropshire 0
4453543 2186117 2186117 defendant Cotes Thomas   633390 633390 Cotes, Thomas, of Shropshire 0
4464892 2189690 2189690 defendant Carlel John   633390 633390 Carlel, John, of Shropshire 1
4469796 2191226 2191226 defendant Muwelton Robert de esq 633390 633390 Muwelton, Robert de, of Shropshire, esq 4
4496573 2199602 2199602 defendant Cheyne Roger   633390 633390 Cheyne, Roger, of Shropshire 6
4531215 2210040 2210040 defendant Mowethe John   633390 633390 Mowethe, John, of Shropshire 0
4534103 2210935 2210935 defendant Stephenes Thomas esq 633390 633390 Stephenes, Thomas, of Shropshire, esq 0
4534106 2210936 2210936 defendant Stephenes Thomas esq 633390 633390 Stephenes, Thomas, of Shropshire, esq 0
4537173 2211897 2211897 defendant Godwyn John clerk 633390 633390 Godwyn, John, of Shropshire, clerk 0
4547397 2215115 2215115 defendant Leyghton Richard   633390 633390 Leyghton, Richard, of Shropshire 0
4547464 2215136 2215136 plaintiff Byryton William de   633390 633390 Byryton, William de, of Shropshire 0
4552899 2216851 2216851 defendant Yonge Thomas le   633390 633390 Yonge, Thomas le, of Shropshire 0
4554014 2217175 2217175 defendant Waryng Richard   633390 633390 Waryng, Richard, of Shropshire 0
4559797 2219018 2219018 defendant Betton Thomas   633390 633390 Betton, Thomas, of Shropshire 0
4559798 2219018 2219018 defendant Ryketon John   633390 633390 Ryketon, John, of Shropshire 1
4566974 2221232 2221232 defendant Starky John   633390 633390 Starky, John, of Shropshire 0
4568720 2221800 2221800 defendant Orlton Thomas   633390 633390 Orlton, Thomas, of Shropshire 0
4571539 2222676 2222676 defendant Beraston William   633390 633390 Beraston, William, of Shropshire 0
4571541 2222677 2222677 defendant Boraston William   633390 633390 Boraston, William, of Shropshire 0
4579956 2225218 2225218 defendant Acton Roger   633390 633390 Acton, Roger, of Shropshire, knight, formerly esquire 0
4583195 2226167 2226167 defendant Chapell John   633390 633390 Chapell, John, of Shropshire 2
4590889 2228503 2228503 plaintiff Becok Richard   633390 633390 Becok, Richard, of Shropshire 1
4591734 2228768 2228768 defendant Boraston William   633390 633390 Boraston, William, of Shropshire 0
4604408 2232548 2232548 defendant Wyke Thomas   633390 633390 Wyke, Thomas, of Shropshire 2
4607835 2233565 2233565 defendant Glover John   633390 633390 Glover, John, of Shropshire 0
4619290 2237027 2237027 defendant Banastre William (legal representative) 633390 633390 Banastre, William, of Shropshire, esq, executrix of 2
4619296 2237028 2237028 defendant Banastre William (legal representative) 633390 633390 Banastre, William, of Shropshire, executrix of 2
4622154 2237906 2237906 defendant Wyke Thomas   633390 633390 Wyke, Thomas, of Shropshire 0
4629702 2240211 2240211 defendant Cornewaill John   633390 633390 Cornewaill, John, of Shropshire, knight 1
4629708 2240213 2240213 defendant Cornewaill John   633390 633390 Cornewaill, John, of Shropshire, knight 0
4632907 2241164 2241164 defendant Haburley John   633390 633390 Haburley, John, of Shropshire 2
4632973 2241185 2241185 plaintiff Waller John   633390 633390 Waller, John, of Shropshire 0
4638589 2242823 2242823 defendant Acton Roger   633390 633390 Acton, Roger, of Shropshire, knight 0
4638600 2242827 2242827 defendant Acton Roger   633390 633390 Acton, Roger, of Shropshire, knight 0
4639157 2242969 2242969 defendant Straunge Ibill esq 633390 633390 Straunge, Ibill, of Shropshire, esq 0
4639159 2242970 2242970 defendant Straunge Ivill esq 633390 633390 Straunge, Ivill, of Shropshire, esq 0
4641958 2243752 2243752 defendant Caunville John   633390 633390 Caunville, John, of Shropshire 2
4642517 2243936 2243936 defendant Pygot Robert esq 633390 633390 Pygot, Robert, of Shropshire, esq 1
4642518 2243936 2243936 defendant Kynaston John (legal representative) 633390 633390 Kynaston, John, of Shropshire, executor of 2
4649548 2245901 2245901 defendant Styches William   633390 633390 Styches, William, of Shropshire 2
4650200 2246080 2246080 defendant Bradston John esq 633390 633390 Bradston, John, of Shropshire, esq 2
4695631 2264114 2264114 defendant Acton Roger (legal representative) 633390 633390 Acton, Roger, of Shropshire, knight, executors of 0
4729001 2274307 2274307 plaintiff Kyrkeham William   633390 633390 Kyrkeham, William, of Shropshire 0
4837072 2307553 2307553 plaintiff fitz Peyers John esq 633390 633390 fitz Peyers, John, of Shropshire, esq 0
5010683 2359991 2359991 defendant Lacon Richard   633390 633390 Lacon, Richard, of Shropshire, knight 4
5038949 2368295 2368295 plaintiff Banastur Richard gent 633390 633390 Banastur, Richard, of Shropshire, gent 0
5040164 2368658 2368658 plaintiff Brigge Joan   633390 633390 Brigge, Joan, of Shropshire 0
5136803 2397284 2397284 defendant White Rober   633390 633390 White, Rober, of Shropshire, shoe maker 1
5303194 2445947 2445947 defendant Burley Richard gent 633390 633390 Burley, Richard, of Shropshire, gent 2
5451181 2490242 2490242 defendant Kermsmey John gent 633390 633390 Kermsmey, John, of Shropshire, gent 0
5459824 2492868 2492868 defendant Pontesbury Roger (legal representative) 633390 633390 Pontesbury, Roger, of Shropshire, mercer, executors of 0
5472625 2496779 2496779 defendant More Roger chapman 633390 633390 More, Roger, of Shropshire, chapman 4
5612213 2547559 2547559 defendant Cotes Thomas de   633390 633390 Cotes, Thomas de, of Shropshire 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);