names

151 rows where place_id = 592983

✎ 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
3609727 1870709 1870709 defendant Helbek Christine widow 592983 592983 Helbek, Christine, of Ramsey, widow 0
3632725 1905050 1905050 defendant Holbem Hugh yeoman 592983 592983 Holbem, Hugh, of Ramsey, yeoman 0
3634662 1905639 1905639 defendant Stanley William clerk 592983 592983 Stanley, William, of Ramsey, clerk 2
3637234 1906447 1906447 defendant Turnour Thomas husbandman 592983 592983 Turnour, Thomas, of Ramsey, husbandman 0
3637750 1906622 1906622 defendant Marvyn Thomas yeoman 592983 592983 Marvyn, Thomas, of Ramsey, yeoman 2
3652292 1911057 1911057 defendant Turner Thomas yeoman 592983 592983 Turner, Thomas, of Ramsey, yeoman 0
3675892 1918496 1918496 defendant Gosley Edmund husbandman 592983 592983 Gosley, Edmund, of Ramsey, husbandman 0
3675893 1918496 1918496 defendant Meese William husbandman 592983 592983 Meese, William, of Ramsey, husbandman 1
3675894 1918496 1918496 defendant Elys Giles beer brewer 592983 592983 Elys, Giles, of Ramsey, beer brewer 2
3684614 1921320 1921320 defendant Norton Robert yeoman 592983 592983 Norton, Robert, of Ramsey, yeoman 1
3692231 1923739 1923739 defendant Mondy Peter brewer 592983 592983 Mondy, Peter, of Ramsey, brewer 0
3692232 1923739 1923739 defendant Walsheff John yeoman 592983 592983 Walsheff, John, of Ramsey, yeoman 1
3692233 1923739 1923739 defendant Atston John fisher 592983 592983 Atston, John, of Ramsey, fisher 2
3698958 1925885 1925885 defendant Richard John brewer 592983 592983 Richard, John, of Ramsey, brewer 0
3701669 1926763 1926763 defendant Mundy Peter yeoman 592983 592983 Mundy, Peter, of Ramsey, yeoman 0
3783076 1952463 1952463 defendant Stewkley Thomas gent 592983 592983 Stewkley, Thomas, of Ramsey, gent 0
3795404 1956435 1956435 defendant Bettys Thomas yeoman 592983 592983 Bettys, Thomas, of Ramsey, yeoman 0
3838113 1969834 1969834 plaintiff Talmache Hugh gent 592983 592983 Talmache, Hugh, of Ramsey, gent 0
3865153 1978549 1978549 plaintiff Merven John   592983 592983 Merven, John, of Ramsey, bachelor 1
3872542 1981037 1981037 defendant Luntley Richard husbandman 592983 592983 Luntley, Richard, of Ramsey, husbandman 0
3899705 1990116 1990116 defendant Rychemonde Robert husbandman 592983 592983 Rychemonde, Robert, of Ramsey, husbandman 2
3906075 1992322 1992322 plaintiff Lowthe Thomas gent 592983 592983 Lowthe, Thomas, of Ramsey, gent 0
3920394 1997164 1997164 plaintiff Meyney William waterman 592983 592983 Meyney, William, of Ramsey, waterman 0
3964767 2012283 2012283 defendant Jenney Edmund gent 592983 592983 Jenney, Edmund, of Ramsey, gent 0
4124185 2068939 2068939 defendant Younge Edward yeoman 592983 592983 Younge, Edward, of Ramsey, yeoman 2
4133229 2072208 2072208 defendant Whaley Walter yeoman 592983 592983 Whaley, Walter, of Ramsey, yeoman 0
4150740 2078399 2078399 defendant Marven John husbandman 592983 592983 Marven, John, of Ramsey, husbandman 2
4169674 2084884 2084884 defendant Cole John thatcher 592983 592983 Cole, John, of Ramsey, thatcher 0
4228954 2105609 2105609 defendant Baxter William yeoman 592983 592983 Baxter, William, of Ramsey, yeoman 0
4258458 2115795 2115795 defendant Baxter William yeoman 592983 592983 Baxter, William, of Ramsey, yeoman 0
4278296 2122347 2122347 defendant Coole alias Leaver Robert husbandman 592983 592983 Coole alias Leaver, Robert, of Ramsey, husbandman 0
4282387 2123739 2123739 defendant Goodding Henry yeoman 592983 592983 Goodding, Henry, of Ramsey, yeoman 1
4306592 2132442 2132442 defendant Baxter William yeoman 592983 592983 Baxter, William, of Ramsey, yeoman 0
4312179 2134398 2134398 defendant Bonham Brigit daughter of Richard Foxe, chandler 592983 592983 Brigit his wife, daughter of Richard Foxe, of Ramsey, chandler 1
4390776 2161528 2161528 defendant Aldust John (legal representative) 592983 592983 Aldust, John, of Ramsey, yeoman, executors of 0
4402956 2165574 2165574 defendant Estman John chapman 592983 592983 Estman, John, of Ramsey, chapman 0
4531883 2210236 2210236 defendant Bocher John   592983 592983 Bocher, John, of Ramsey 0
4566114 2220962 2220962 defendant Dyer John   592983 592983 Dyer, John, of Ramsey 0
4632338 2241001 2241001 defendant palmere Thomas   592983 592983 palmere, Thomas, of Ramsey 2
4680417 2259489 2259489 defendant Burgh William de shoemaker 592983 592983 Burgh, William de, of Ramsey, shoemaker 0
4684704 2260817 2260817 defendant Berford John butcher 592983 592983 Berford, John, of Ramsey, butcher 0
4685909 2261184 2261184 defendant Herford Richard chaplain 592983 592983 Herford, Richard, of Ramsey, chaplain 1
4688273 2261900 2261900 defendant Alot John butcher 592983 592983 Alot, John, of Ramsey, butcher 0
4695304 2264013 2264013 plaintiff Brigge John   592983 592983 Brigge, John, of Ramsey 0
4695678 2264128 2264128 plaintiff Brygge John   592983 592983 Brygge, John, of Ramsey 0
4697100 2264570 2264570 plaintiff Claxston William   592983 592983 Claxston, William, of Ramsey 0
4698334 2264957 2264957 defendant Meyke John chapman 592983 592983 Meyke, John, of Ramsey, chapman 0
4710493 2268640 2268640 defendant Godfrey Thomas husbandman 592983 592983 Godfrey, Thomas, of Ramsey, husbandman 1
4710494 2268640 2268640 defendant Abbot John husbandman 592983 592983 Abbot, John, of Ramsey, husbandman 2
4710505 2268643 2268643 defendant Boorell John husbandman 592983 592983 Boorell, John, of Ramsey, husbandman 0
4718981 2271283 2271283 plaintiff Kirkeby John   592983 592983 Kirkeby, John, of Ramsey 1
4718984 2271284 2271284 plaintiff Kirkeby John   592983 592983 Kirkeby, John, of Ramsey 1
4724707 2273024 2273024 defendant Fygenot Thomas yeoman 592983 592983 Fygenot, Thomas, of Ramsey, yeoman 0
4735919 2276385 2276385 defendant Somersham John husbandman 592983 592983 Somersham, John, of Ramsey, husbandman 0
4746381 2279439 2279439 defendant Sebarn Stephen yeoman 592983 592983 Sebarn, Stephen, of Ramsey, yeoman 0
4746383 2279439 2279439 defendant Wakke John yeoman 592983 592983 Wakke, John, of Ramsey, yeoman 2
4753057 2281344 2281344 defendant Barbour Thomas barber 592983 592983 Barbour, Thomas, of Ramsey, barber 0
4762161 2284144 2284144 defendant Sawyere John husbandman 592983 592983 Sawyere, John, of Ramsey, husbandman 0
4765293 2285128 2285128 defendant Kyrkeby John gent 592983 592983 Kyrkeby, John, of Ramsey, gent 0
4772695 2287431 2287431 defendant Berdwell John, sen carpenter 592983 592983 Berdwell, John, sen, of Ramsey, carpenter 0
4773028 2287535 2287535 defendant Turnour William turner 592983 592983 Turnour, William, of Ramsey, turner 0
4836281 2307325 2307325 defendant Kyng William shoemaker 592983 592983 Kyng, William, of Ramsey, shoemaker 0
4836283 2307325 2307325 defendant Edman Richard shoemaker 592983 592983 Edman, Richard, of Ramsey, shoemaker 2
4849819 2311415 2311415 defendant Neweman Richard husbandman 592983 592983 Neweman, Richard, of Ramsey, husbandman 0
4876019 2319461 2319461 defendant Malverne William husbandman 592983 592983 Malverne, William, of Ramsey, husbandman 2
4898371 2326146 2326146 defendant Grene William husbandman 592983 592983 Grene, William, of Ramsey, husbandman 0
4901782 2327163 2327163 plaintiff Faunt William   592983 592983 Faunt, William, of Ramsey 0
4901784 2327163 2327163 defendant Sutton John shoemaker 592983 592983 Sutton, John, of Ramsey, shoemaker 1
4909082 2329381 2329381 defendant Berford John husbandman 592983 592983 Berford, John, of Ramsey, husbandman 0
4915629 2331390 2331390 defendant Faunt William yeoman 592983 592983 Faunt, William, of Ramsey, yeoman 2
4928594 2335374 2335374 defendant Gayete Richard shoemaker 592983 592983 Gayete, Richard, of Ramsey, shoemaker 0
4929388 2335609 2335609 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929391 2335610 2335610 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929395 2335611 2335611 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929397 2335612 2335612 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929398 2335612 2335612 defendant Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929399 2335613 2335613 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929401 2335614 2335614 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4929406 2335615 2335615 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot 0
4951823 2342521 2342521 defendant Blanche John   592983 592983 Blanche, John, of Ramsey, mason 2
4984124 2352184 2352184 defendant Botell John husbandman 592983 592983 Botell, John, of Ramsey, husbandman 0
4987118 2353095 2353095 defendant Feelde Thomas   592983 592983 (Feelde, Thomas, of Ramsey 1
5010467 2359936 2359936 plaintiff Warde John   592983 592983 Warde, John, of Ramsey 0
5013416 2360758 2360758 defendant Somerton William laborer 592983 592983 Somerton, William, of Ramsey, laborer 0
5013417 2360758 2360758 defendant Missankyll John shoemaker 592983 592983 Missankyll, John, of Ramsey, shoemaker 1
5025826 2364453 2364453 defendant Barbour Thomas barber 592983 592983 Barbour, Thomas, of Ramsey, barber 0
5034713 2367009 2367009 defendant Faunt William yeoman 592983 592983 (Faunt, William, of Ramsey, yeoman 1
5034717 2367010 2367010 defendant Faunt William yeoman 592983 592983 Faunt, William, of Ramsey, yeoman 1
5039747 2368529 2368529 defendant Meyke John, junior chapman 592983 592983 Meyke, John, junior, of Ramsey, chapman 2
5041063 2368953 2368953 defendant Brampton Robert husbandman 592983 592983 Brampton, Robert, of Ramsey, husbandman 1
5042374 2369326 2369326 defendant Gosse William husbandman 592983 592983 Gosse, William, of Ramsey, husbandman 0
5044019 2369839 2369839 defendant Myssangylle John shoemaker 592983 592983 Myssangylle, John, of Ramsey, shoemaker 0
5045918 2370413 2370413 defendant Barbour Thomas barber 592983 592983 Barbour, Thomas, of Ramsey, barber 1
5049876 2371590 2371590 plaintiff Stow John   592983 592983 Stow, John, of Ramsey 0
5049878 2371591 2371591 plaintiff Stow John   592983 592983 Stow, John, of Ramsey, abbot of the monastery 0
5057448 2373795 2373795 defendant Meyke John (legal representative) 592983 592983 Meyke, John, of Ramsey, executrix of 4
5057449 2373795 2373795 defendant Meyke Isabel widow 592983 592983 Meyke, Isabel, of Ramsey, widow 5
5065559 2376233 2376233 defendant Stone William laborer 592983 592983 Stone, William, of Ramsey, laborer 0
5065909 2376326 2376326 defendant Mayke John, senior (legal representative) 592983 592983 Mayke, John, senior, of Ramsey, Hunts minstrel, executrix of 2
5069897 2377488 2377488 defendant Harpham William tailor 592983 592983 Harpham, William, of Ramsey, tailor 0

Next page

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);