names

83 rows where place_id = 591983

✎ 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
3606192 1869606 1869606 defendant Danyell John butcher 591983 591983 Danyell, John, of Ramesey, butcher 1
3632567 1905003 1905003 defendant Dayly John clerk 591983 591983 Dayly, John, of Ramesey, clerk 0
3632568 1905003 1905003 defendant Goselowe William baker 591983 591983 Goselowe, William, of Ramesey, baker 1
3632570 1905004 1905004 defendant Goslowe William baker 591983 591983 Goslowe, William, of Ramesey, baker 0
3632734 1905051 1905051 defendant Holbeme Hugh yeoman 591983 591983 Holbeme, Hugh, of Ramesey, yeoman 0
3677196 1918910 1918910 defendant Marshall Hugh yeoman 591983 591983 Marshall, Hugh, of Ramesey, yeoman 0
3694423 1924460 1924460 defendant Somerby John yeoman 591983 591983 Somerby, John, of Ramesey, yeoman 0
3895987 1988863 1988863 defendant Nelson Robert beer brewer 591983 591983 Nelson, Robert, of Ramesey, beer brewer 0
4434649 2175601 2175601 defendant Nassyngton Robert de   591983 591983 Nassyngton, Robert de, of Ramesey, abbot of the monastery 0
4464669 2189617 2189617 defendant Pakerell Andrew   591983 591983 Pakerell, Andrew, of Ramesey 0
4524625 2208036 2208036 defendant Godefrey John   591983 591983 Godefrey, John, of Ramesey 0
4579298 2225008 2225008 defendant Barker Robert   591983 591983 Barker, Robert, of Ramesey 0
4626859 2239342 2239342 defendant Brouse William   591983 591983 Brouse, William, of Ramesey 3
4626861 2239342 2239342 defendant Turnour William   591983 591983 Turnour, William, of Ramesey 5
4681820 2259925 2259925 defendant Mayk John husbandman 591983 591983 Mayk, John, of Ramesey, husbandman 0
4681821 2259925 2259925 defendant Barbour Roger barber 591983 591983 Barbour, Roger, of Ramesey, barber 1
4718976 2271282 2271282 plaintiff Bekeswell John   591983 591983 Bekeswell, John, of Ramesey 0
4740838 2277836 2277836 plaintiff Bekyswelle John   591983 591983 Bekyswelle, John, of Ramesey, on his own account 0
4740841 2277836 2277836 defendant Plomer John plumber 591983 591983 Plomer, John, of Ramesey, plumber 2
4755287 2282041 2282041 defendant Levenoth John (legal representative) 591983 591983 Levenoth, John, of Ramesey, butcher, executor of 0
4785626 2291531 2291531 defendant Sawyere John husbandman 591983 591983 Sawyere, John, of Ramesey, husbandman 0
4786909 2291967 2291967 defendant Wakke John laborer 591983 591983 Wakke, John, of Ramesey, laborer 0
4788299 2292412 2292412 defendant Wakke John laborer 591983 591983 Wakke, John, of Ramesey, laborer 0
4788636 2292502 2292502 defendant Edenham Richard shoemaker 591983 591983 Edenham, Richard, of Ramesey, shoemaker 0
4788637 2292502 2292502 defendant Skynner John husbandman 591983 591983 Skynner, John, of Ramesey, husbandman 1
4791480 2293429 2293429 defendant Lister William dyer 591983 591983 Lister, William, of Ramesey, or of St Neots, dyer 0
4823145 2303326 2303326 defendant Roydon John gent 591983 591983 Roydon, John, of Ramesey, gent 2
4836887 2307495 2307495 plaintiff Faunt William   591983 591983 Faunt, William, of Ramesey 0
4861485 2314961 2314961 plaintiff Crispe John   591983 591983 Crispe, John, of Ramesey 0
4889053 2323367 2323367 defendant Faunt William yeoman 591983 591983 Faunt, William, of Ramesey, yeoman 0
4889055 2323368 2323368 defendant Lode Robert yeoman 591983 591983 Lode, Robert, of Ramesey, yeoman 0
4897228 2325789 2325789 plaintiff Brigge Thomas (legal representative) 591983 591983 Brigge, Thomas, of Ramesey, executors of 0
4897230 2325789 2325789 defendant Barbour Thomas yeoman 591983 591983 Barbour, Thomas, of Ramesey, yeoman 0
4898188 2326094 2326094 plaintiff Brygge Thomas (legal representative) 591983 591983 Brygge, Thomas, of Ramesey, executors of 0
4898190 2326094 2326094 defendant Barbour Thomas yeoman 591983 591983 Barbour, Thomas, of Ramesey, yeoman 0
4906061 2328492 2328492 plaintiff Fisshere John   591983 591983 Fisshere, John, of Ramesey 0
4935437 2337478 2337478 defendant Cotiller Henry (legal representative) 591983 591983 Cotiller, Henry, of Ramesey, administratrix of 3
4967625 2347258 2347258 defendant Bereford John husbandman 591983 591983 Bereford, John, of Ramesey, husbandman 1
5026854 2364722 2364722 plaintiff Lone or Love John   591983 591983 Lone or Love, John, of Ramesey 0
5044487 2369982 2369982 defendant Gosse William husbandman 591983 591983 Gosse, William, of Ramesey, husbandman 0
5044489 2369982 2369982 defendant Sawyer John husbandman 591983 591983 Sawyer, John, of Ramesey, husbandman 2
5057447 2373795 2373795 defendant Halle John chaplain 591983 591983 Halle, John, of Ramesey, chaplain 3
5059891 2374524 2374524 defendant Witfeld Walter shoemaker 591983 591983 Witfeld, Walter, of Ramesey, shoemaker 3
5059892 2374524 2374524 defendant Grenelane John shoemaker 591983 591983 Grenelane, John, of Ramesey, shoemaker 4
5065065 2376080 2376080 defendant Boner or Bouer Thomas smith 591983 591983 Boner or Bouer, Thomas, of Ramesey, smith 0
5100543 2386584 2386584 defendant Wotton Thomas fisher 591983 591983 Wotton, Thomas, of Ramesey, fisher 0
5100544 2386584 2386584 defendant Berford John butcher 591983 591983 Berford, John, of Ramesey, butcher 1
5100545 2386584 2386584 defendant Baveyn John husbandman 591983 591983 Baveyn, John, of Ramesey, husbandman 2
5100546 2386584 2386584 defendant Harpour Richard   591983 591983 Harpour, Richard, of Ramesey, mason 3
5100547 2386584 2386584 defendant Clerk Gilbert stainer 591983 591983 Clerk, Gilbert, of Ramesey, stainer 4
5118059 2391712 2391712 defendant Berford John butcher 591983 591983 Berford, John, of Ramesey, butcher 0
5118060 2391712 2391712 defendant Bave- John husbandman 591983 591983 Bave-, John, of Ramesey, husbandman 1
5118061 2391712 2391712 defendant Harpour Richard   591983 591983 Harpour, Richard, of Ramesey, mason 2
5118062 2391712 2391712 defendant Clerk Gilbert stainer 591983 591983 Clerk, Gilbert, of Ramesey, stainer 3
5129696 2395173 2395173 defendant Cony Giles gent 591983 591983 Cony, Giles, of Ramesey, gent 0
5157241 2403258 2403258 defendant Cony Giles gent 591983 591983 Cony, Giles, of Ramesey, gent 0
5157244 2403259 2403259 defendant Cony Giles gent 591983 591983 Cony, Giles, of Ramesey, gent 0
5182135 2410529 2410529 defendant Symmes John   591983 591983 Symmes, John, of Ramesey, boat wright 1
5212699 2419463 2419463 defendant West Walter fisher 591983 591983 West, Walter, of Ramesey, fisher 0
5212701 2419464 2419464 defendant West Walter fisher 591983 591983 West, Walter, of Ramesey, fisher 0
5265456 2434957 2434957 defendant Nicolas Henry husbandman 591983 591983 Nicolas, Henry, of Ramesey, husbandman 0
5265457 2434957 2434957 defendant Denys Thomas husbandman 591983 591983 Denys, Thomas, of Ramesey, husbandman 1
5265458 2434957 2434957 defendant Baneyne or Baveyne John, junior husbandman 591983 591983 Baneyne or Baveyne, John, junior, of Ramesey, husbandman 2
5265459 2434957 2434957 defendant Belle John shoemaker 591983 591983 Belle, John, of Ramesey, shoemaker 3
5320062 2451092 2451092 defendant Toly Thomas yeoman 591983 591983 Toly, Thomas, of Ramesey, yeoman 1
5340505 2457230 2457230 defendant Moteley John laborer 591983 591983 Moteley, John, of Ramesey, laborer 2
5340506 2457230 2457230 defendant Daweby Richard laborer 591983 591983 Daweby, Richard, of Ramesey, laborer 3
5340507 2457230 2457230 defendant Freman William laborer 591983 591983 Freman, William, of Ramesey, laborer 4
5358037 2462582 2462582 defendant Moteley John laborer 591983 591983 Moteley, John, of Ramesey, laborer 2
5358038 2462582 2462582 defendant Daweby Richard laborer 591983 591983 Daweby, Richard, of Ramesey, laborer 3
5358039 2462582 2462582 defendant Freman William laborer 591983 591983 Freman, William, of Ramesey, laborer 4
5499983 2504948 2504948 defendant Newman Richard husbandman 591983 591983 Newman, Richard, of Ramesey, husbandman 0
5540690 2517218 2517218 defendant Aynesworth William laborer 591983 591983 Aynesworth, William, of Ramesey, laborer 0
5565587 2524527 2524527 defendant Smyth Henry yeoman 591983 591983 Smyth, Henry, of Ramesey, yeoman 0
5626409 2552231 2552231 defendant Barbour Roger barber 591983 591983 Barbour, Roger, of Ramesey, barber 0
5626410 2552231 2552231 defendant Chaundeler Robert chandler 591983 591983 Chaundeler, Robert, of Ramesey, chandler 1
5626411 2552231 2552231 defendant Clayton William fisher 591983 591983 Clayton, William, of Ramesey, fisher 2
5626412 2552231 2552231 defendant Clayton John fisher 591983 591983 Clayton, John, of Ramesey, fisher 3
5626413 2552231 2552231 defendant Leghton John barker 591983 591983 Leghton, John, of Ramesey, barker 4
5626414 2552231 2552231 defendant Heryng Richard barker 591983 591983 Heryng, Richard, of Ramesey, barker 5
5631388 2553821 2553821 plaintiff Smyth Henry   591983 591983 Smyth, Henry, of Ramesey 0
5631389 2553821 2553821 defendant Claxton John fisher 591983 591983 Claxton, John, of Ramesey, fisher 0
5631390 2553821 2553821 defendant North John husbandman 591983 591983 North, John, of Ramesey, husbandman 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);