names

163 rows where place_id = 595315

✎ 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
3619990 1873823 1873823 defendant Hawe or Hagh James yeoman 595315 595315 Hawe or Hagh, James, of Ormesby, yeoman 1
3631857 1904773 1904773 defendant Beryngton Thomas husbandman 595315 595315 Beryngton, Thomas, of Ormesby, husbandman 0
3659491 1913227 1913227 defendant Buknall William husbandman 595315 595315 Buknall, William, of Ormesby, husbandman 1
3667871 1915893 1915893 defendant Manwell Simon husbandman 595315 595315 Manwell, Simon, of Ormesby, husbandman 1
3687443 1922252 1922252 defendant Mathew Robert chaplain 595315 595315 Mathew, Robert, of Ormesby, chaplain 1
3711568 1929929 1929929 plaintiff Thurston John (legal representative) 595315 595315 Thurston, John, of Ormesby, son of Thurston, Edmund, of Rendham, Suff, executors of 0
3711574 1929930 1929930 plaintiff Thurston John (legal representative) 595315 595315 Thurston, John, of Ormesby, son of Thurston, Edmund, of Rendham, Suff, executors of 0
3717088 1931629 1931629 defendant Hawe Thomas husbandman 595315 595315 Hawe, Thomas, of Ormesby, husbandman 1
3732771 1936479 1936479 defendant Hawe Thomas husbandman 595315 595315 Hawe, Thomas, of Ormesby, husbandman 1
3732775 1936480 1936480 defendant Hawe or Halke Thomas husbandman 595315 595315 Hawe or Halke, Thomas, of Ormesby, husbandman 1
3766606 1947218 1947218 defendant Brewer Thomas carpenter 595315 595315 Brewer, Thomas, of Ormesby, carpenter 5
3808946 1960679 1960679 defendant Mathue Robert chaplain 595315 595315 Mathue, Robert, of Ormesby, chaplain 0
3809555 1960874 1960874 defendant Mathewe Robert clerk 595315 595315 Mathewe, Robert, of Ormesby, clerk 0
3831494 1967735 1967735 defendant Thompson Edward yeoman 595315 595315 Thompson, Edward, of Ormesby, yeoman 3
3837734 1969716 1969716 defendant Clere John esq 595315 595315 Clere, John, of Ormesby, esq 0
3840227 1970510 1970510 defendant Chapman Henry husbandman 595315 595315 Chapman, Henry, of Ormesby, husbandman 1
3860858 1977125 1977125 defendant Bull William yeoman 595315 595315 Bull, William, of Ormesby, yeoman 0
3914821 1995304 1995304 defendant Cappys John   595315 595315 Cappys, John, of Ormesby, wheel wright 0
3958844 2010174 2010174 defendant Palmer Leonard gent 595315 595315 Palmer, Leonard, of Ormesby, gent 0
3999914 2024738 2024738 defendant Toly John yeoman 595315 595315 Toly, John, of Ormesby, yeoman 2
4025968 2033937 2033937 defendant Bretten Thomas gent 595315 595315 Bretten, Thomas, of Ormesby, gent 0
4027619 2034527 2034527 defendant Guner Roger gent 595315 595315 Guner, Roger, of Ormesby, gent 0
4027640 2034534 2034534 plaintiff Clere Edward esq 595315 595315 Clere, Edward, of Ormesby, esq 0
4027642 2034535 2034535 plaintiff Clere Edward esq 595315 595315 Clere, Edward, of Ormesby, esq 0
4047680 2041618 2041618 defendant Gonner Roger gent 595315 595315 Gonner, Roger, of Ormesby, gent 0
4063788 2047334 2047334 defendant Deeryng Robert husbandman 595315 595315 Deeryng, Robert, of Ormesby, husbandman 2
4070361 2049696 2049696 defendant Sampson George miller 595315 595315 Sampson, George, of Ormesby, miller 0
4117070 2066408 2066408 defendant Ormesby Robert gent 595315 595315 Ormesby, Robert, of Ormesby, gent 0
4216631 2101309 2101309 defendant Barker William tailor 595315 595315 Barker, William, of Ormesby, tailor 0
4265785 2118195 2118195 defendant Tayler Thomas yeoman 595315 595315 Tayler, Thomas, of Ormesby, yeoman 1
4285266 2124781 2124781 defendant Love William husbandman 595315 595315 Love, William, of Ormesby, husbandman 3
4285683 2124930 2124930 defendant Tailer Thomas yeoman 595315 595315 Tailer, Thomas, of Ormesby, yeoman 1
4363473 2152010 2152010 defendant Tailer Thomas yeoman 595315 595315 Tailer, Thomas, of Ormesby, yeoman 0
4389287 2161045 2161045 defendant Pollard William, senior husbandman 595315 595315 Pollard, William, senior, of Ormesby, husbandman 0
4411235 2168344 2168344 defendant Barker Agnes widow 595315 595315 Barker, Agnes, of Ormesby, widow 2
4422296 2171840 2171840 defendant Wryghte John   595315 595315 Wryghte, John, of Ormesby 2
4468095 2190694 2190694 defendant Mabulson Thomas   595315 595315 Mabulson, Thomas, of Ormesby 0
4521830 2207163 2207163 defendant Warde William   595315 595315 Warde, William, of Ormesby 0
4537903 2212139 2212139 defendant Kent Robert de   595315 595315 Kent, Robert de, of Ormesby 1
4539002 2212466 2212466 defendant Hugman Robert   595315 595315 Hugman, Robert, of Ormesby 1
4539003 2212466 2212466 defendant Ward Thomas   595315 595315 Ward, Thomas, of Ormesby 2
4546970 2214986 2214986 defendant Eskyrk John de   595315 595315 Eskyrk, John de, of Ormesby 0
4612036 2234829 2234829 defendant Milner Thomas   595315 595315 Milner, Thomas, of Ormesby 0
4620345 2237342 2237342 defendant Millere William   595315 595315 Millere, William, of Ormesby 3
4636382 2242215 2242215 defendant Blyth (illegible)   595315 595315 Blyth, _, of Ormesby 0
4636984 2242372 2242372 defendant Broun Henry   595315 595315 Broun, Henry, of Ormesby 0
4639413 2243041 2243041 defendant Warde Wilaim   595315 595315 Warde, Wilaim, of Ormesby 1
4657994 2248382 2248382 defendant Warde William yeoman 595315 595315 Warde, William, of Ormesby, yeoman 0
4657995 2248382 2248382 defendant Magotson William husbandman 595315 595315 Magotson, William, of Ormesby, husbandman 1
4657996 2248382 2248382 defendant del Lawe Robert husbandman 595315 595315 del Lawe, Robert, of Ormesby, husbandman 2
4657997 2248382 2248382 defendant de Coton Robert smith 595315 595315 de Coton, Robert, of Ormesby, smith 3
4657998 2248382 2248382 defendant Cornay Robert husbandman 595315 595315 Cornay, Robert, of Ormesby, husbandman 4
4657999 2248382 2248382 defendant Areson Robert husbandman 595315 595315 Areson, Robert, of Ormesby, husbandman 5
4658000 2248382 2248382 defendant Warde Thomas husbandman 595315 595315 Warde, Thomas, of Ormesby, husbandman 6
4658001 2248382 2248382 defendant Bayns Thomas husbandman 595315 595315 Bayns, Thomas, of Ormesby, husbandman 7
4658002 2248382 2248382 defendant Bayns John husbandman 595315 595315 Bayns, John, of Ormesby, husbandman 8
4658003 2248382 2248382 defendant del Lawe William husbandman 595315 595315 del Lawe, William, of Ormesby, husbandman 9
4658004 2248382 2248382 defendant del Lawe John husbandman 595315 595315 del Lawe, John, of Ormesby, husbandman 10
4658005 2248382 2248382 defendant Stevenson John husbandman 595315 595315 Stevenson, John, of Ormesby, husbandman 11
4701398 2265840 2265840 defendant Richers William miller 595315 595315 Richers, William, of Ormesby, miller 0
4707910 2267844 2267844 defendant Cook Richard husbandman 595315 595315 Cook, Richard, of Ormesby, husbandman 1
4710803 2268734 2268734 defendant Rycheris William miller 595315 595315 Rycheris, William, of Ormesby, miller 1
4729510 2274442 2274442 defendant Botery William husbandman 595315 595315 Botery, William, of Ormesby, husbandman 1
4739102 2277321 2277321 defendant Baille William yeoman 595315 595315 Baille, William, of Ormesby, yeoman 0
4752080 2281091 2281091 defendant Blythe John yeoman 595315 595315 Blythe, John, of Ormesby, yeoman 4
4766989 2285663 2285663 defendant Loundsdale Thomas yeoman 595315 595315 (Loundsdale, Thomas, of Ormesby, yeoman 3
4768899 2286253 2286253 defendant Botery Thomas yeoman 595315 595315 Botery, Thomas, of Ormesby, yeoman 0
4771497 2287067 2287067 plaintiff Scrayngham William   595315 595315 Scrayngham, William, of Ormesby, parson 0
4775312 2288270 2288270 defendant Leem Geoffrey fuller 595315 595315 Leem, Geoffrey, of Ormesby, fuller 3
4793277 2293993 2293993 plaintiff Norman Robert   595315 595315 Norman, Robert, of Ormesby 0
4830591 2305589 2305589 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 1
4835816 2307193 2307193 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 1
4840741 2308640 2308640 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 0
4840743 2308641 2308641 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 0
4856776 2313494 2313494 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 0
4858653 2314079 2314079 defendant Norman Robert butcher 595315 595315 Norman, Robert, of Ormesby, butcher 0
4876792 2319713 2319713 defendant Wyom John husbandman 595315 595315 Wyom, John, of Ormesby, husbandman 2
4892228 2324312 2324312 defendant Kebyll Thomas husbandman 595315 595315 Kebyll, Thomas, of Ormesby, husbandman 5
4895730 2325341 2325341 defendant Ide Thomas husbandman 595315 595315 Ide, Thomas, of Ormesby, husbandman 0
4904499 2328015 2328015 defendant Ide Thomas husbandman 595315 595315 Ide, Thomas, of Ormesby, husbandman 0
4924774 2334182 2334182 defendant Geyne John husbandman 595315 595315 Geyne, John, of Ormesby, husbandman 6
4925320 2334351 2334351 plaintiff Shipdam Walter   595315 595315 Shipdam, Walter, of Ormesby 2
4928648 2335389 2335389 defendant Gauntmorton William yeoman 595315 595315 Gauntmorton, William, of Ormesby, yeoman 0
4938675 2338482 2338482 defendant Cordewaner John husbandman 595315 595315 Cordewaner, John, of Ormesby, husbandman 2
4961791 2345491 2345491 defendant Carleton Richard yeoman 595315 595315 Carleton, Richard, of Ormesby, yeoman 0
4961792 2345491 2345491 defendant Dykson Thomas husbandman 595315 595315 Dykson, Thomas, of Ormesby, husbandman 1
4961845 2345498 2345498 defendant Wodde John husbandman 595315 595315 Wodde, John, of Ormesby, husbandman 8
4961846 2345498 2345498 defendant Megote William husbandman 595315 595315 Megote, William, of Ormesby, husbandman 9
4990376 2354032 2354032 defendant Goos Walter clerk 595315 595315 Goos, Walter, of Ormesby, clerk 0
4991005 2354201 2354201 plaintiff Clere Robert   595315 595315 Clere, Robert, of Ormesby 0
4991142 2354243 2354243 plaintiff Cllere Robert   595315 595315 Cllere, Robert, of Ormesby 0
5002859 2357740 2357740 defendant Graner or Graver Henry graner 595315 595315 Graner or Graver, Henry, of Ormesby, graner 0
5002860 2357740 2357740 defendant Seyve John yeoman 595315 595315 Seyve, John, of Ormesby, yeoman 1
5002861 2357740 2357740 defendant Decon William husbandman 595315 595315 Decon, William, of Ormesby, husbandman 2
5015598 2361443 2361443 defendant Horneld William husbandman 595315 595315 Horneld, William, of Ormesby, husbandman 24
5015599 2361443 2361443 defendant Megotson William husbandman 595315 595315 Megotson, William, of Ormesby, husbandman 25
5028686 2365265 2365265 defendant Rakesond Elizabeth widow 595315 595315 Rakesond, Elizabeth, of Ormesby, widow 4
5032608 2366420 2366420 defendant Beryngton Thomas yeoman 595315 595315 Beryngton, Thomas, of Ormesby, yeoman 1
5032610 2366420 2366420 defendant Kent John yeoman 595315 595315 Kent, John, of Ormesby, yeoman 3
5038175 2368051 2368051 defendant Gravour henry engraver 595315 595315 Gravour, henry, of Ormesby, engraver 4

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