names

89 rows where place_id = 599287

✎ 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
3627444 1903439 1903439 defendant Iremonger William clerk 599287 599287 Iremonger, William, of Belgrave, or of Wyllesword, Lincs, clerk 0
3636128 1906092 1906092 defendant Wygston William, senior gent 599287 599287 Wygston, William, senior, of Belgrave, gent 0
4416788 2170119 2170119 defendant Balle John   599287 599287 Balle, John, of Belgrave 1
4419554 2171001 2171001 plaintiff Belgrave John de   599287 599287 Belgrave, John de, of Belgrave, parson 0
4467664 2190565 2190565 plaintiff Bailly Thomas   599287 599287 Bailly, Thomas, of Belgrave 0
4479321 2194181 2194181 defendant Bailly Thomas   599287 599287 Bailly, Thomas, of Belgrave 0
4493315 2198614 2198614 plaintiff Bailly Thomas (legal representative) 599287 599287 Bailly, Thomas, of Belgrave, executors of 0
4493317 2198614 2198614 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 2
4499036 2200342 2200342 defendant Wroo John in the   599287 599287 Wroo, John in the, of Belgrave 0
4509886 2203578 2203578 plaintiff Bailly Thomas (legal representative) 599287 599287 Bailly, Thomas, of Belgrave, executors of 0
4509887 2203578 2203578 plaintiff Bailly Margaret   599287 599287 (Bailly, Margaret, of Belgrave, formerly wife of Thomas 1
4548861 2215579 2215579 defendant Swan William   599287 599287 Swan, William, of Belgrave 1
4606356 2233104 2233104 plaintiff Baillie William   599287 599287 Baillie, William, of Belgrave 0
4607490 2233454 2233454 plaintiff Berkesworth William   599287 599287 Berkesworth, William, of Belgrave 0
4624959 2238773 2238773 defendant Sclater William, sen   599287 599287 Sclater, William, sen, of Belgrave 0
4679276 2259127 2259127 defendant Milner John milner 599287 599287 Milner, John, of Belgrave, milner 0
4682968 2260288 2260288 plaintiff Longe Robert   599287 599287 Longe, Robert, of Belgrave 2
4682969 2260288 2260288 defendant Lasur John husbandman 599287 599287 Lasur, John, of Belgrave, husbandman 0
4688986 2262112 2262112 defendant Kelme William slater 599287 599287 Kelme, William, of Belgrave, slater 0
4691654 2262923 2262923 defendant Lazeur John chapman 599287 599287 Lazeur, John, of Belgrave, chapman 1
4692919 2263295 2263295 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 0
4692924 2263295 2263295 defendant Wirkesworth William husbandman 599287 599287 Wirkesworth, William, of Belgrave, husbandman 4
4693583 2263495 2263495 plaintiff Bayly William   599287 599287 Bayly, William, of Belgrave 0
4703597 2266504 2266504 plaintiff Heyne William chaplain 599287 599287 Heyne, William, of Belgrave, chaplain 0
4710045 2268497 2268497 defendant Tomson John husbandman 599287 599287 Tomson, John, of Belgrave, husbandman 0
4719024 2271297 2271297 defendant Belgrave William   599287 599287 Belgrave, William, of Belgrave 0
4728025 2274012 2274012 defendant Reve Simon husbandman 599287 599287 Reve, Simon, of Belgrave, husbandman 1
4728026 2274012 2274012 defendant Lane John in the husbandman 599287 599287 Lane, John in the, of Belgrave, husbandman 2
4735138 2276138 2276138 defendant Kyttes William husbandman 599287 599287 Kyttes, William, of Belgrave, husbandman 0
4740343 2277686 2277686 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 0
4755603 2282135 2282135 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 0
4770599 2286785 2286785 defendant Waryn William husbandman 599287 599287 Waryn, William, of Belgrave, husbandman 0
4777301 2288892 2288892 plaintiff atte Welle John   599287 599287 atte Welle, John, of Belgrave 0
4777302 2288892 2288892 defendant in the Wroo John husbandman 599287 599287 in the Wroo, John, of Belgrave, husbandman 0
4777303 2288892 2288892 defendant in the Wroo Thomas yeoman 599287 599287 in the Wroo, Thomas, of Belgrave, yeoman 1
4777304 2288892 2288892 defendant Jurdan William laborer 599287 599287 Jurdan, William, of Belgrave, laborer 2
4777305 2288892 2288892 defendant Reve Simon husbandman 599287 599287 Reve, Simon, of Belgrave, husbandman 3
4777518 2288963 2288963 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 0
4777520 2288964 2288964 plaintiff Bailly William   599287 599287 Bailly, William, of Belgrave 0
4777802 2289047 2289047 defendant Bailly William yeoman 599287 599287 Bailly, William, of Belgrave, yeoman 0
4777803 2289047 2289047 defendant Milner Robert miller 599287 599287 Milner, Robert, of Belgrave, miller 1
4803637 2297324 2297324 plaintiff Baylly William   599287 599287 Baylly, William, of Belgrave 0
4803641 2297324 2297324 defendant Bayly Peter husbandman 599287 599287 Bayly, Peter, of Belgrave, husbandman 3
4803642 2297324 2297324 defendant Long Robert husbandman 599287 599287 Long, Robert, of Belgrave, husbandman 4
4803643 2297324 2297324 defendant Ibstoke Robert husbandman 599287 599287 Ibstoke, Robert, of Belgrave, husbandman 5
4812100 2299894 2299894 defendant Fermoure Robert husbandman 599287 599287 Fermoure, Robert, of Belgrave, husbandman 0
4812570 2300048 2300048 defendant Hoton Richard   599287 599287 Hoton, Richard, of Belgrave, parson 0
4837354 2307622 2307622 defendant Reede Adam husbandman 599287 599287 Reede, Adam, of Belgrave, husbandman 4
4840693 2308627 2308627 defendant Dalby Richard husbandman 599287 599287 Dalby, Richard, of Belgrave, husbandman 3
4871963 2318210 2318210 defendant Wryght William husbandman 599287 599287 Wryght, William, of Belgrave, husbandman 4
4877965 2320062 2320062 defendant Glade John husbandman 599287 599287 Glade, John, of Belgrave, husbandman 0
4906249 2328546 2328546 defendant Belgrave William yeoman 599287 599287 Belgrave, William, of Belgrave, yeoman 0
4906251 2328546 2328546 defendant Bell Thomas husbandman 599287 599287 Bell, Thomas, of Belgrave, husbandman 2
4906252 2328546 2328546 defendant Pynchester John tailor 599287 599287 Pynchester, John, of Belgrave, tailor 3
4926825 2334814 2334814 defendant Shepey Richard husbandman 599287 599287 Shepey, Richard, of Belgrave, husbandman 3
4943313 2339882 2339882 defendant Burton William husbandman 599287 599287 Burton, William, of Belgrave, husbandman 0
4987272 2353144 2353144 plaintiff Belgrave William   599287 599287 Belgrave, William, of Belgrave 0
4989264 2353722 2353722 defendant Bramburgh John clerk 599287 599287 Bramburgh, John, of Belgrave, clerk 0
4989265 2353722 2353722 defendant Glade John yeoman 599287 599287 Glade, John, of Belgrave, yeoman 1
4989266 2353722 2353722 defendant Ould William yeoman 599287 599287 Ould, William, of Belgrave, yeoman 2
4997905 2356232 2356232 defendant Bramburgh John   599287 599287 Bramburgh, John, of Belgrave, parson 0
5002283 2357573 2357573 plaintiff Newton Robert   599287 599287 Newton, Robert, of Belgrave 0
5009243 2359587 2359587 defendant Glade John yeoman 599287 599287 Glade, John, of Belgrave, yeoman 2
5014470 2361093 2361093 defendant Longe Robert laborer 599287 599287 Longe, Robert, of Belgrave, laborer 1
5019216 2362510 2362510 plaintiff Neuton Robert   599287 599287 Neuton, Robert, of Belgrave 1
5025421 2364332 2364332 defendant Glade John yeoman 599287 599287 Glade, John, of Belgrave, yeoman 0
5026132 2364539 2364539 defendant Blade John yeoman 599287 599287 Blade, John, of Belgrave, yeoman 0
5047008 2370729 2370729 plaintiff Newton Robert   599287 599287 Newton, Robert, of Belgrave, wool man 0
5052969 2372480 2372480 defendant Glade John chaplain 599287 599287 Glade, John, of Belgrave, chaplain 0
5067631 2376813 2376813 defendant Barowe Robert husbandman 599287 599287 Barowe, Robert, of Belgrave, husbandman 1
5103543 2387462 2387462 defendant Makepes John husbandman 599287 599287 Makepes, John, of Belgrave, husbandman 0
5158312 2403555 2403555 defendant Bramburgh John   599287 599287 Bramburgh, John, of Belgrave, parson 0
5173931 2408074 2408074 defendant Bramburgh John   599287 599287 Bramburgh, John, of Belgrave, parson 0
5232611 2425118 2425118 defendant Repon Thomas yeoman 599287 599287 Repon, Thomas, of Belgrave, yeoman 0
5237084 2426430 2426430 defendant Belgrave John gent 599287 599287 Belgrave, John, of Belgrave, gent 0
5252773 2430977 2430977 defendant Belgrave John gent 599287 599287 Belgrave, John, of Belgrave, gent 0
5252774 2430977 2430977 defendant Boteler Henry husbandman 599287 599287 Boteler, Henry, of Belgrave, husbandman 1
5278398 2438789 2438789 defendant Belgrave John gent 599287 599287 Belgrave, John, of Belgrave, gent 0
5298537 2444547 2444547 defendant Belgrave John gent 599287 599287 Belgrave, John, of Belgrave, gent 0
5332614 2454822 2454822 defendant Pakyngton William smith 599287 599287 Pakyngton, William, of Belgrave, smith 0
5332615 2454822 2454822 defendant Jeffrey John husbandman 599287 599287 Jeffrey, John, of Belgrave, husbandman 1
5332617 2454823 2454823 defendant Pakyngton William smith 599287 599287 Pakyngton, William, of Belgrave, smith 0
5332618 2454823 2454823 defendant Jeffrey John husbandman 599287 599287 Jeffrey, John, of Belgrave, husbandman 1
5332620 2454824 2454824 defendant Pakyngton William smith 599287 599287 Pakyngton, William, of Belgrave, smith 0
5332621 2454824 2454824 defendant Jeffrey John husbandman 599287 599287 Jeffrey, John, of Belgrave, husbandman 1
5371778 2466760 2466760 defendant Reynold John, junior merchant 599287 599287 Reynold, John, junior, of Belgrave, merchant 1
5513285 2509005 2509005 defendant Wadelofe William laborer 599287 599287 Wadelofe, William, of Belgrave, laborer 0
5596712 2533889 2533889 defendant Shepey alias Kent Thomas husbandman 599287 599287 Shepey alias Kent, Thomas, of Belgrave, husbandman 2
5611729 2547406 2547406 defendant Belgrave Thomas   599287 599287 Belgrave, Thomas, of Belgrave 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);