names

50 rows where place_id = 591978

✎ 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
3606185 1869605 1869605 defendant Baker William yeoman 591978 591978 Baker, William, of Lutton, yeoman 0
3621794 1874355 1874355 defendant Broun John   591978 591978 Broun, John, of Lutton, salt weller 1
3646371 1909258 1909258 defendant Alwarde Richard (legal representative) 591978 591978 Alwarde, Richard, of Lutton, executors of 0
3657015 1912455 1912455 defendant Heigham John clerk 591978 591978 Heigham, John, of Lutton, clerk 0
3663821 1914619 1914619 defendant Broun Robert   591978 591978 Broun, Robert, of Lutton 1
3854905 1975179 1975179 plaintiff Cony Roger   591978 591978 (Cony, Roger, of Lutton 1
3895317 1988641 1988641 plaintiff Smyth Robert (legal representative) 591978 591978 Smyth, Robert, of Lutton, yeoman, executor of 0
3916222 1995810 1995810 defendant Lutton alias Lupton Thomas gent 591978 591978 Lutton alias Lupton, Thomas, of Lutton, gent 10
4051369 2042910 2042910 plaintiff Wigmor Richard esq 591978 591978 Wigmor, Richard, of Lutton, esq 0
4071916 2050255 2050255 defendant Chattris John husbandman 591978 591978 Chattris, John, of Lutton, husbandman 0
4456632 2187098 2187098 defendant Lyvon John de   591978 591978 Lyvon, John de, of Lutton 0
4497242 2199787 2199787 defendant Craven Thomas de   591978 591978 Craven, Thomas de, of lutton 2
4497243 2199787 2199787 defendant Lutton William de   591978 591978 Lutton, William de, of Lutton 3
4548637 2215517 2215517 plaintiff Clerk Robert   591978 591978 Clerk, Robert, of Lutton 0
4548638 2215517 2215517 defendant Alger Robert   591978 591978 Alger, Robert, of Lutton 0
4617460 2236472 2236472 defendant Robynson William   591978 591978 Robynson, William, of Lutton 3
4645003 2244611 2244611 defendant Everard James   591978 591978 Everard, James, of Lutton 1
4668042 2255713 2255713 defendant Chateris John husbandman 591978 591978 Chateris, John, of Lutton, husbandman 1
4668043 2255713 2255713 defendant Chateris William, senior husbandman 591978 591978 Chateris, William, senior, of Lutton, husbandman 2
4668044 2255713 2255713 defendant Chateris William, junior husbandman 591978 591978 Chateris, William, junior, of Lutton, husbandman 3
4668078 2255721 2255721 defendant Hebbes William husbandman 591978 591978 Hebbes, William, of lUtton, husbandman 0
4668079 2255721 2255721 defendant Lutton John husbandman 591978 591978 Lutton, John, of Lutton, husbandman 1
4668080 2255721 2255721 defendant Chaters William husbandman 591978 591978 Chaters, William, of Lutton, husbandman 2
4685307 2261000 2261000 defendant Hekkes William husbandman 591978 591978 Hekkes, William, of Lutton, husbandman 0
4765170 2285087 2285087 plaintiff Howes Robert   591978 591978 Howes, Robert, of Lutton, parson 0
4818844 2301977 2301977 defendant Bukworth John husbandman 591978 591978 Bukworth, John, of Lutton, husbandman 0
4828559 2304971 2304971 defendant Poweler Richard clerk 591978 591978 Poweler, Richard, of Lutton, clerk 0
4855378 2313038 2313038 defendant Powele Richard clerk 591978 591978 Powele, Richard, of Lutton, clerk 0
4875551 2319307 2319307 defendant Chateris Robert   591978 591978 Chateris, Robert, of Lutton, husbandman, his brother 1
4912275 2330338 2330338 defendant Neweman Richard husbandman 591978 591978 Neweman, Richard, of Lutton, husbandman 2
4935051 2337370 2337370 defendant Hervy William, senior husbandman 591978 591978 Hervy, William, senior, of Lutton, husbandman 0
4991620 2354375 2354375 defendant Chaterys William husbandman 591978 591978 Chaterys, William, of Lutton, husbandman 0
4992714 2354702 2354702 defendant Hode John husbandman 591978 591978 Hode, John, of Lutton, husbandman 3
5032802 2366480 2366480 defendant Clerke Walter husbandman 591978 591978 Clerke, Walter, of Lutton, husbandman 0
5032804 2366481 2366481 defendant Clerke Walter husbandman 591978 591978 Clerke, Walter, of Lutton, husbandman 0
5097583 2385723 2385723 defendant Mym Robert husbandman 591978 591978 Mym, Robert, of Lutton, husbandman 2
5097584 2385723 2385723 defendant Newesom William husbandman 591978 591978 Newesom, William, of Lutton, husbandman 3
5133136 2396175 2396175 defendant Wyggemore Walter esq 591978 591978 Wyggemore, Walter, of Lutton, esq 1
5186736 2411869 2411869 defendant Maddok William   591978 591978 Maddok, William, of Lutton 2
5290154 2442125 2442125 defendant Lutton Thomas yeoman 591978 591978 Lutton, Thomas, of Lutton, yeoman 3
5360070 2463188 2463188 defendant Deyn Richard husbandman 591978 591978 Deyn, Richard, of Lutton, husbandman 1
5395307 2473733 2473733 defendant Baker Robert husbandman 591978 591978 Baker, Robert, of Lutton, husbandman 0
5395308 2473733 2473733 defendant Deyn Robert husbandman 591978 591978 Deyn, Robert, of Lutton, husbandman 1
5427108 2483046 2483046 defendant Bocher John husbandman 591978 591978 Bocher, John, of Lutton, husbandman 4
5457609 2492175 2492175 defendant Bocher John husbandman 591978 591978 Bocher, John, of Lutton, husbandman 2
5466627 2494961 2494961 plaintiff Baker William   591978 591978 Baker, William, of Lutton 0
5504643 2506371 2506371 plaintiff Baker William   591978 591978 Baker, William, of Lutton 0
5504645 2506371 2506371 defendant Wyttelsey Thomas husbandman 591978 591978 Wyttelsey, Thomas, of Lutton, husbandman 1
5504646 2506371 2506371 defendant Alward Richard, junior husbandman 591978 591978 Alward, Richard, junior, of Lutton, husbandman 2
5528097 2513353 2513353 defendant Baker William yeoman 591978 591978 Baker, William, of Lutton, yeoman 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);