names

70 rows where place_id = 592797

✎ 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
3608967 1870463 1870463 defendant Unton John gent 592797 592797 Unton, John, of Mutford, gent 0
3609270 1870561 1870561 defendant Unton John gent 592797 592797 Unton, John, of Mutford, gent 0
3609276 1870562 1870562 defendant Unton John gent 592797 592797 Unton, John, of Mutford, gent 0
3613475 1871862 1871862 defendant Grevall or Grenall John husbandman 592797 592797 Grevall or Grenall, John, of Mutford, husbandman 0
3669185 1916300 1916300 defendant Rypyng Robert yeoman 592797 592797 Rypyng, Robert, of Mutford, yeoman 0
3733459 1936707 1936707 defendant Boyse William husbandman 592797 592797 Boyse, William, of Mutford, husbandman 0
3733460 1936707 1936707 defendant Bocker John husbandman 592797 592797 Bocker, John, of Mutford, husbandman 1
3745100 1940374 1940374 defendant Hakon John gent 592797 592797 Hakon, John, of Mutford, gent 2
3775724 1950156 1950156 defendant Hakon John gent 592797 592797 Hakon, John, of Mutford, gent 2
3862812 1977755 1977755 defendant Rypyng Henry yeoman 592797 592797 Rypyng, Henry, of Mutford, yeoman 0
3864253 1978237 1978237 defendant Baldwyn William yeoman 592797 592797 Baldwyn, William, of Mutford, yeoman 0
3898988 1989867 1989867 defendant Smyth Thomas yeoman 592797 592797 Smyth, Thomas, of Mutford, yeoman 3
3907149 1992681 1992681 defendant Frosten Thomas (legal representative) 592797 592797 Frosten, Thomas, of Mutford, yeoman, executor of 0
3940182 2003735 2003735 plaintiff Smyth Thomas (legal representative) 592797 592797 Smyth, Thomas, of Mutford, yeoman, executors of 0
3940186 2003736 2003736 plaintiff Smyth Thomas (legal representative) 592797 592797 Smyth, Thomas, of Mutford, yeoman, executors of 0
3943157 2004727 2004727 defendant Taylor Thomas yeoman 592797 592797 Taylor, Thomas, of Mutford, yeoman 0
3955284 2008917 2008917 defendant Haukes Thomas husbandman 592797 592797 Haukes, Thomas, of Mutford, husbandman 0
4043309 2040074 2040074 plaintiff Plater Thomas gent 592797 592797 Plater, Thomas, of Mutford, gent 0
4079001 2052788 2052788 defendant Pyncheback William yeoman 592797 592797 Pyncheback, William, of Mutford, yeoman 0
4096439 2059054 2059054 defendant Whyck Richard husbandman 592797 592797 Whyck, Richard, of Mutford, husbandman 0
4274342 2120973 2120973 defendant Barney John yeoman 592797 592797 Barney, John, of Mutford, yeoman 0
4278829 2122532 2122532 defendant Taylor Michael, senior yeoman 592797 592797 Taylor, Michael, senior, of Mutford, yeoman 0
4278830 2122532 2122532 defendant Pereson Robert husbandman 592797 592797 Pereson, Robert, of Mutford, husbandman 1
4298704 2129636 2129636 defendant Taylor Michael, senior yeoman 592797 592797 Taylor, Michael, senior, of Mutford, yeoman 0
4298705 2129636 2129636 defendant Taylor Edward husbandman 592797 592797 Taylor, Edward, of Mutford, husbandman 1
4324993 2138743 2138743 defendant Artis Francis yeoman 592797 592797 Artis, Francis, of Mutford, yeoman 1
4324994 2138743 2138743 defendant Barney John husbandman 592797 592797 Barney, John, of Mutford, husbandman 2
4324995 2138743 2138743 defendant Peryson Robert tailor 592797 592797 Peryson, Robert, of Mutford, tailor 3
4332407 2141130 2141130 defendant Barney John yeoman 592797 592797 Barney, John, of Mutford, yeoman 0
4337830 2142981 2142981 defendant Downes Robert gent 592797 592797 Downes, Robert, of Mutford, gent 1
4337832 2142981 2142981 defendant Sterry Daniel yeoman 592797 592797 Sterry, Daniel, of Mutford, yeoman 3
4387800 2160557 2160557 defendant Barney John husbandman 592797 592797 Barney, John, of Mutford, husbandman 1
4454667 2186476 2186476 defendant Lynne John   592797 592797 Lynne, John, of Mutford 8
4616754 2236240 2236240 defendant Warner Edmund   592797 592797 Warner, Edmund, of Mutford 0
4618859 2236895 2236895 defendant atte Lane Warin   592797 592797 atte Lane, Warin, of Mutford 0
4620644 2237446 2237446 defendant Bergh John   592797 592797 Bergh, John, of Mutford 0
4628724 2239910 2239910 plaintiff Sewale Ralph   592797 592797 Sewale, Ralph, of Mutford, son of Warin Sewale, sen 0
4642643 2243965 2243965 defendant Bergh John   592797 592797 Bergh, John, of Mutford 2
4642644 2243965 2243965 defendant Seman William   592797 592797 Seman, William, of Mutford 3
4642646 2243965 2243965 defendant Eneday John   592797 592797 Eneday, John, of Mutford 5
4664947 2250518 2250518 defendant atte Lane Warren   592797 592797 atte Lane, Warren, of Mutford, bailiff 0
4664954 2250520 2250520 defendant Suterton John husbandman 592797 592797 Suterton, John, of Mutford, husbandman 2
4664955 2250520 2250520 defendant Rose Thomas husbandman 592797 592797 Rose, Thomas, of Mutford, husbandman 3
4664956 2250520 2250520 defendant Grendlyng John husbandman 592797 592797 Grendlyng, John, of Mutford, husbandman 4
4676154 2258155 2258155 defendant Rose Thomas carpenter 592797 592797 Rose, Thomas, of Mutford, carpenter 2
4704295 2266719 2266719 defendant Baker Henry baker 592797 592797 Baker, Henry, of Mutford, baker 1
4739059 2277308 2277308 defendant Froste Thomas yeoman 592797 592797 Froste, Thomas, of Mutford, yeoman 2
4739060 2277308 2277308 defendant Wolde John husbandman 592797 592797 Wolde, John, of Mutford, husbandman 3
4769329 2286381 2286381 defendant Frost Thomas husbandman 592797 592797 Frost, Thomas, of Mutford, husbandman 1
4793825 2294189 2294189 defendant Frost Thomas husbandman 592797 592797 Frost, Thomas, of Mutford, husbandman 0
4805719 2297998 2297998 defendant Barker John husbandman 592797 592797 Barker, John, of Mutford, husbandman 2
4887136 2322821 2322821 defendant Sapurton John   592797 592797 Sapurton, John, of Mutford, bailiff 1
4929414 2335617 2335617 defendant Rypyng Richard yeoman 592797 592797 Rypyng, Richard, of Mutford, yeoman 0
4936120 2337696 2337696 defendant Eppes Richard yeoman 592797 592797 Eppes, Richard, of Mutford, yeoman 0
4938871 2338549 2338549 defendant Eppes Richard yeoman 592797 592797 Eppes, Richard, of Mutford, yeoman 0
4955824 2343711 2343711 defendant Birche John husbandman 592797 592797 Birche, John, of Mutford, husbandman 2
5033287 2366615 2366615 defendant atte Assh Thomas clerk 592797 592797 atte Assh, Thomas, of Mutford, clerk 0
5047365 2370829 2370829 defendant Eppys Richard yeoman 592797 592797 Eppys, Richard, of Mutford, yeoman 0
5051126 2371949 2371949 plaintiff Warnere Robert   592797 592797 Warnere, Robert, of Mutford 0
5084202 2381780 2381780 defendant Assh Thomas clerk 592797 592797 Assh, Thomas, of Mutford, clerk 0
5094866 2384915 2384915 defendant Eppys Richard yeoman 592797 592797 Eppys, Richard, of Mutford, yeoman 0
5140395 2398293 2398293 defendant Wylde John husbandman 592797 592797 Wylde, John, of Mutford, husbandman 0
5230259 2424469 2424469 plaintiff Bakere Thomas   592797 592797 Bakere, Thomas, of Mutford 0
5253661 2431256 2431256 defendant Rypyng Richard (legal representative) 592797 592797 Rypyng, Richard, of Mutford, husbandman, executor of 1
5311441 2448450 2448450 defendant Brouster Richard yeoman 592797 592797 Brouster, Richard, of Mutford, yeoman 0
5379417 2469153 2469153 defendant Hamond Thomas husbandman 592797 592797 Hamond, Thomas, of Mutford, husbandman 1
5384017 2470514 2470514 defendant Hamond Thomas husbandman 592797 592797 Hamond, Thomas, of Mutford, husbandman 3
5571137 2526120 2526120 defendant Rypyng John husbandman 592797 592797 Rypyng, John, of Mutford, husbandman 1
5607153 2537126 2537126 defendant Rypyng Richard husbandman 592797 592797 Rypyng, Richard, of Mutford, husbandman 2
5618027 2549453 2549453 defendant Fraunceys William, senior   592797 592797 Fraunceys, William, senior, of Mutford 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);