names

53 rows where place_id = 588357

✎ 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
3594214 1865831 1865831 defendant Stalon William barker 588357 588357 Stalon, William, of Heygham, barker 3
3729466 1935463 1935463 defendant Holl Thomas yeoman 588357 588357 Holl, Thomas, of Heygham, yeoman 3
3769403 1948087 1948087 defendant Revell Robert gent 588357 588357 Revell, Robert, of Heygham, gent 0
3772569 1949112 1949112 defendant Russell Robert tanner 588357 588357 Russell, Robert, of Heygham, tanner 0
3820895 1964430 1964430 defendant Russell Robert tanner 588357 588357 Russell, Robert, of Heygham, tanner 0
3825727 1965899 1965899 plaintiff Acras alias Avyson William husbandman 588357 588357 Acras alias Avyson, William, of Heygham, husbandman 0
3834024 1968581 1968581 defendant Pollard Nicholas smith 588357 588357 Pollard, Nicholas, of Heygham Potter, smith 4
3924766 1998600 1998600 defendant Pye Simon laborer 588357 588357 Pye, Simon, of Heygham, laborer 4
4027820 2034600 2034600 plaintiff Cocke Edmund   588357 588357 Cocke, Edmund, of Heygham, tanner, administrators of 0
4029852 2035319 2035319 defendant Lantorn Henry husbandman 588357 588357 Lantorn, Henry, of Heygham Potter, husbandman 0
4029854 2035320 2035320 defendant Lantorn Henry husbandman 588357 588357 Lantorn, Henry, of Heygham Potter, husbandman 0
4076368 2051846 2051846 defendant Heare John husbandman 588357 588357 Heare, John, of Heygham Potter, husbandman 1
4139926 2074645 2074645 defendant Dawkyn Robert husbandman 588357 588357 Dawkyn, Robert, of Heygham, husbandman 2
4161335 2082045 2082045 defendant Browne George husbandman 588357 588357 Browne, George, of Heygham, husbandman 0
4456324 2186999 2186999 defendant Diston Alice   588357 588357 Diston, Alice, of Heygham 8
4474160 2192571 2192571 defendant Strout William   588357 588357 Strout, William, of Heygham 0
4500014 2200645 2200645 plaintiff Hole William in the   588357 588357 Hole, William in the, of Heygham 0
4543017 2213706 2213706 defendant Hacoun John spicer 588357 588357 Hacoun, John, of Heygham, spicer 2
4625506 2238942 2238942 plaintiff Peke John   588357 588357 Peke, John, of Heygham 0
4638717 2242853 2242853 defendant Melle John   588357 588357 Melle, John, of Heygham 0
4643341 2244156 2244156 defendant Strout William   588357 588357 Strout, William, of Heygham 0
4645359 2244714 2244714 defendant Cook John potter 588357 588357 Cook, John, of Heygham, potter 3
4655649 2247650 2247650 defendant Stronte or Stroute William yeoman 588357 588357 Stronte or Stroute, William, of Heygham, yeoman 0
4657755 2248308 2248308 defendant Topyas John barker 588357 588357 Topyas, John, of Heygham, barker 0
4661609 2249467 2249467 defendant Boteler Robert husbandman 588357 588357 Boteler, Robert, of Heygham, husbandman 1
4663889 2250190 2250190 defendant Middelton John husbandman 588357 588357 Middelton, John, of Heygham, husbandman 0
4665538 2250694 2250694 plaintiff Holdry Robert   588357 588357 Holdry, Robert, of Heygham 0
4665544 2250695 2250695 plaintiff Holdry Robert   588357 588357 Holdry, Robert, of Heygham 0
4736416 2276520 2276520 defendant Brounyng (illegible) baker 588357 588357 Brounyng, _, of Heygham, baker 1
4744343 2278868 2278868 defendant Cook John yeoman 588357 588357 Cook, John, of Heygham, yeoman 3
4744850 2279012 2279012 defendant Dewe Thomas potter 588357 588357 Dewe, Thomas, of Heygham, potter 2
4790928 2293254 2293254 defendant Ruddok William laborer 588357 588357 Ruddok, William, of Heygham, laborer 1
4824025 2303590 2303590 defendant Witton Thomas tanner 588357 588357 Witton, Thomas, of Heygham, tanner 1
4914102 2330922 2330922 defendant Heygham Thomas gent 588357 588357 Heygham, Thomas, of Heygham, gent 0
4919299 2332544 2332544 defendant Shadewell Thomas   588357 588357 Shadewell, Thomas, of Heygham, bailiff 0
5090083 2383470 2383470 defendant Sarowe John husbandman 588357 588357 Sarowe, John, of Heygham, husbandman 1
5099170 2386181 2386181 defendant Page John smith 588357 588357 Page, John, of Heygham, smith 2
5102265 2387081 2387081 defendant Peke Nicholas clothmaker 588357 588357 Peke, Nicholas, of Heygham, clothmaker 1
5135192 2396790 2396790 defendant Stroute John yeoman 588357 588357 Stroute John, of Heygham, yeoman 5
5135688 2396948 2396948 defendant Clerk William husbandman 588357 588357 Clerk, William, of Heygham, husbandman 1
5215889 2420378 2420378 plaintiff Couper John   588357 588357 Couper, John, of Heygham 0
5313731 2449134 2449134 defendant Aleyn John barker 588357 588357 Aleyn, John, of Heygham, barker 1
5322231 2451717 2451717 defendant Myllys John miller 588357 588357 Myllys, John, of Heygham, miller 2
5360145 2463214 2463214 defendant Skynner John yeoman 588357 588357 Skynner, John, of Heygham, yeoman 0
5479300 2498825 2498825 defendant Courby Thomas (legal representative) 588357 588357 Courby, Thomas, of Heygham carter, executors of 1
5502310 2505647 2505647 defendant Everyche Robert yeoman 588357 588357 Everyche, Robert, of Heygham, yeoman 0
5538509 2516525 2516525 defendant Grene John yeoman 588357 588357 Grene, John, of Heygham, yeoman 4
5541379 2517421 2517421 defendant Grene John yeoman 588357 588357 Grene, John, of Heygham, yeoman 1
5548430 2519575 2519575 defendant Stalon John tanner 588357 588357 Stalon, John, of Heygham, tanner 0
5560281 2522967 2522967 defendant Stalon John tanner 588357 588357 Stalon, John, of Heygham, tanner 0
5560573 2523052 2523052 plaintiff Stalon William   588357 588357 Stalon, William, of Heygham 0
5623877 2551416 2551416 defendant Berkle Adam fowler 588357 588357 Berkle, Adam, of Heygham Potter, fowler 1
5627660 2552623 2552623 defendant Strout William husbandman 588357 588357 Strout, William, of Heygham, husbandman 6

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