names

59 rows where place_id = 586144

✎ 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
3588028 1863909 1863909 defendant Cobberley Adam gent 586144 586144 Cobberley, Adam, of Eryth, gent 0
3589180 1864260 1864260 defendant Wyder William   586144 586144 Wyder, William, of Eryth, shipwright 0
3589181 1864260 1864260 defendant Sampson William fisher 586144 586144 Sampson, William, of Eryth, fisher 1
3589182 1864260 1864260 defendant Myller Thomas   586144 586144 Myller, Thomas, of Eryth, shipwright 2
3596473 1866526 1866526 defendant Wyder William   586144 586144 Wyder, William, of Eryth, shipwright 0
3600419 1867776 1867776 plaintiff Wyder William   586144 586144 Wyder, William, of Eryth, shipwright 0
3600420 1867776 1867776 defendant Myller Thomas   586144 586144 Myller, Thomas, of Eryth, shipwright 0
3674387 1918035 1918035 defendant Thornay James mariner 586144 586144 Thornay, James, of Eryth, mariner 1
3706406 1928291 1928291 defendant Walden Richard   586144 586144 Walden, Richard, of Eryth, or of Swannescomp, knight 0
3778485 1950988 1950988 defendant Whyte James mariner 586144 586144 Whyte, James, of Eryth, mariner 0
3804178 1959239 1959239 defendant Sampson Adam yeoman 586144 586144 Sampson, Adam, of Eryth, yeoman 0
3804179 1959239 1959239 defendant Pemesey John yeoman 586144 586144 Pemesey, John, of Eryth, yeoman 1
3808124 1960436 1960436 plaintiff Abell William (legal representative) 586144 586144 Abell, William, of Eryth, yeoman, executors of 0
3821637 1964651 1964651 defendant Pemsey John yeoman 586144 586144 Pemsey, John, of Eryth, yeoman 0
3821639 1964652 1964652 defendant Pemsey John yeoman 586144 586144 Pemsey, John, of Eryth, yeoman 0
3821641 1964653 1964653 defendant Sampson Adam yeoman 586144 586144 Sampson, Adam, of Eryth, yeoman 0
3854553 1975067 1975067 defendant Webbe William gent 586144 586144 Webbe, William, of Eryth, gent 0
3858936 1976479 1976479 defendant Gabriell Francis blacksmith 586144 586144 Gabriell, Francis, of Eryth, blacksmith 0
3868272 1979626 1979626 defendant Fyssher Thomas   586144 586144 Fyssher, Thomas, of Eryth, shipwright 0
3868783 1979800 1979800 defendant Webbe William gent 586144 586144 Webbe, William, of Eryth, gent 0
3883876 1984878 1984878 defendant Churche Thomas yeoman 586144 586144 Churche, Thomas, of Eryth, yeoman 1
3898232 1989616 1989616 defendant Gryme Robert butcher 586144 586144 Gryme, Robert, of Eryth, butcher 1
3917190 1996110 1996110 defendant Luke William yeoman 586144 586144 Luke, William, of Eryth, yeoman 1
3917196 1996111 1996111 defendant Luke William yeoman 586144 586144 Luke, William, of Eryth, yeoman 1
4301004 2130463 2130463 defendant Perr Mark husbandman 586144 586144 Perr, Mark, of Eryth, or of Wilberton, Isle of Ely, Cams, husbandman 0
4301005 2130463 2130463 defendant Harryson Thomas husbandman 586144 586144 Harryson, Thomas, of Eryth, or of Sutton, Isle of Ely, husbandman 1
4491878 2198140 2198140 defendant Daye William   586144 586144 Daye, William, of Eryth 0
4491882 2198141 2198141 defendant Daye William   586144 586144 Daye, William, of Eryth 0
4553984 2217165 2217165 defendant Jolyf William   586144 586144 Jolyf, William, of Eryth 0
4746686 2279522 2279522 defendant Sathereth Robert yeoman 586144 586144 Sathereth, Robert, of Eryth, yeoman 0
4810876 2299522 2299522 defendant Dorset- John husbandman 586144 586144 Dorset-, John, of Eryth, husbandman 0
4810877 2299522 2299522 defendant Nicholas Robert husbandman 586144 586144 Nicholas, Robert, of Eryth, husbandman 1
4810878 2299522 2299522 defendant Clerke John husbandman 586144 586144 Clerke, John, of Eryth, husbandman 2
4893756 2324742 2324742 defendant Segood John husbandman 586144 586144 Segood, John, of Eryth, husbandman 0
4894664 2325001 2325001 defendant Stoteville John, senior husbandman 586144 586144 Stoteville, John, senior, of Eryth, husbandman 0
4894665 2325001 2325001 defendant Stoteville John, junior husbandman 586144 586144 Stoteville, John, junior, of Eryth, husbandman 1
4894666 2325001 2325001 defendant Stoteville Robert, junior husbandman 586144 586144 Stoteville, Robert, junior, of Eryth, husbandman 2
4903879 2327829 2327829 defendant Chauntor William husbandman 586144 586144 Chauntor, William, of Eryth, husbandman 1
4905430 2328290 2328290 defendant Chauntour William yeoman 586144 586144 Chauntour, William, of Eryth, yeoman 1
4950754 2342205 2342205 defendant Draper Thomas yeoman 586144 586144 Draper, Thomas, of Eryth, yeoman 0
5029984 2365645 2365645 defendant Whyte William carpenter 586144 586144 Whyte, William, of Eryth, carpenter 0
5048648 2371234 2371234 defendant Rokesley Thomas husbandman 586144 586144 Rokesley, Thomas, of Eryth, husbandman 2
5055365 2373190 2373190 defendant Johnson Thomas yeoman 586144 586144 Johnson, Thomas, of Eryth, yeoman 2
5055369 2373191 2373191 defendant Johnson Thomas yeoman 586144 586144 Johnson, Thomas, of Eryth, yeoman 2
5099284 2386218 2386218 defendant Segode John, senior husbandman 586144 586144 Segode, John, senior, of Eryth, husbandman 0
5211901 2419220 2419220 defendant Forth Thomas husbandman 586144 586144 Forth, Thomas, of Eryth, husbandman 0
5457692 2492199 2492199 defendant Busshop John husbandman 586144 586144 Busshop, John, of Eryth, husbandman 1
5469538 2495813 2495813 defendant Busshop John husbandman 586144 586144 Busshop, John, of Eryth, husbandman 1
5479307 2498827 2498827 defendant Teband John chaplain 586144 586144 Teband, John, of Eryth, chaplain 0
5480810 2499219 2499219 defendant Busshop John husbandman 586144 586144 Busshop, John, of Eryth, husbandman 2
5482121 2499592 2499592 defendant Danyell John fisher 586144 586144 Danyell, John, of Eryth, fisher 1
5482122 2499592 2499592 defendant Spencer Edmund yeoman 586144 586144 Spencer, Edmund, of Eryth, yeoman 2
5500560 2505105 2505105 defendant Porlond John barber 586144 586144 Porlond, John, of Eryth, barber 1
5500561 2505105 2505105 defendant Couper John mariner 586144 586144 Couper, John, of Eryth, mariner 2
5536946 2516042 2516042 defendant Middelton William husbandman 586144 586144 Middelton, William, of Eryth, husbandman 0
5555168 2521514 2521514 defendant Sygarson Thomas husbandman 586144 586144 Sygarson, Thomas, of Eryth, husbandman 11
5557641 2522192 2522192 defendant Bell John yeoman 586144 586144 Bell, John, of Eryth, yeoman 0
5602514 2535679 2535679 defendant Myller David mariner 586144 586144 Myller, David, of Eryth, mariner 2
5604857 2536387 2536387 defendant Clerk Isebrand husbandman 586144 586144 Clerk, Isebrand, of Eryth, husbandman 2

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