names

79 rows where place_id = 589558

✎ 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
3597994 1866997 1866997 defendant Rychardson Thomas yeoman 589558 589558 Rychardson, Thomas, of Messyngham, yeoman 0
3618393 1873386 1873386 defendant Brounlys William yeoman 589558 589558 Brounlys, William, of Messyngham, yeoman 0
3685502 1921618 1921618 defendant Markham Alexander chaplain 589558 589558 Markham, Alexander, of Messyngham, chaplain 0
3685503 1921618 1921618 defendant Warde Nicholas husbandman 589558 589558 Warde, Nicholas, of Messyngham, husbandman 1
3685504 1921618 1921618 defendant Barkeworth William husbandman 589558 589558 Barkeworth, William, of Messyngham, husbandman 2
3685506 1921619 1921619 defendant Markham Alexander chaplain 589558 589558 Markham, Alexander, of Messyngham, chaplain 0
3685507 1921619 1921619 defendant Warde Nicholas husbandman 589558 589558 Warde, Nicholas, of Messyngham, husbandman 1
3685508 1921619 1921619 defendant Barkeworth William husbandman 589558 589558 Barkeworth, William, of Messyngham, husbandman 2
3723872 1933745 1933745 defendant Lakan Andrew (legal representative) 589558 589558 Lakan, Andrew, of Messyngham, gent, executors of 0
3723873 1933745 1933745 defendant Max Lawrence gent 589558 589558 (Max, Lawrence, of Messyngham, gent 1
3735220 1937251 1937251 defendant Dryver John mercer 589558 589558 Dryver, John, of Messyngham, mercer 3
3745287 1940434 1940434 defendant Kenryke John yeoman 589558 589558 Kenryke, John, of Messyngham, yeoman 0
3745288 1940434 1940434 defendant Barbour William husbandman 589558 589558 Barbour, William, of Messyngham, husbandman 1
3921689 1997597 1997597 defendant Gray Nicholas miller 589558 589558 Gray, Nicholas, of Messyngham, miller 1
3921690 1997597 1997597 defendant Gray Alice laborer 589558 589558 Gray, Alice, of Messyngham, laborer 2
4046980 2041369 2041369 defendant Hopkynson Edward gent 589558 589558 Hopkynson, Edward, of Messyngham, gent 0
4152634 2079036 2079036 defendant Freeman Gerrard yeoman 589558 589558 Freeman, Gerrard, of Messyngham, yeoman 0
4152635 2079036 2079036 defendant Duckle William yeoman 589558 589558 Duckle, William, of Messyngham, yeoman 1
4165126 2083310 2083310 defendant Steper Christopher laborer 589558 589558 Steper, Christopher, of Messyngham, laborer 1
4172879 2085968 2085968 defendant Sewrsbe Andrew smith 589558 589558 Sewrsbe, Andrew, of Messyngham, smith 1
4463575 2189302 2189302 defendant Bilay Richard   589558 589558 Bilay, Richard, of Messyngham 1
4485576 2196194 2196194 defendant Gamson John   589558 589558 Gamson, John, of Messyngham 0
4501721 2201139 2201139 defendant Whytelam John   589558 589558 Whytelam, John, of Messyngham 6
4501756 2201145 2201145 defendant Whytelambe John   589558 589558 Whytelambe, John, of Messyngham 4
4509782 2203544 2203544 defendant Whitelam John   589558 589558 Whitelam, John, of Messyngham 0
4540907 2213063 2213063 plaintiff Whtelame John   589558 589558 Whtelame, John, of Messyngham 0
4610124 2234251 2234251 defendant Grey Thomas   589558 589558 Grey, Thomas, of Messyngham 10
4617710 2236539 2236539 defendant Dogull John   589558 589558 Dogull, John, of Messyngham 0
4617712 2236540 2236540 defendant Dogull John   589558 589558 Dogull, John, of Messyngham 0
4617714 2236541 2236541 defendant Dogull John   589558 589558 Dogull, John, of Messyngham 0
4663689 2250126 2250126 plaintiff Grave Thomas   589558 589558 Grave, Thomas, of Messyngham 0
4664386 2250342 2250342 defendant Wade John husbandman 589558 589558 Wade, John, of Messyngham, husbandman 0
4664387 2250342 2250342 defendant Smyth John yeoman 589558 589558 together with Smyth, John, of Messyngham, yeoman 1
4727007 2273713 2273713 plaintiff Grane Thomas   589558 589558 Grane, Thomas, of Messyngham 3
4753710 2281533 2281533 defendant Aleyn Richard fisher 589558 589558 Aleyn, Richard, of Messyngham, fisher 2
4816296 2301181 2301181 defendant Grave Thomas   589558 589558 Grave, Thomas, of Messyngham 0
4873395 2318636 2318636 plaintiff Crave Thomas   589558 589558 Crave, Thomas, of Messyngham 1
4935033 2337364 2337364 defendant German John tailor 589558 589558 German, John, of Messyngham, tailor 0
4943512 2339940 2339940 defendant atte Esshe Walter husbansdman 589558 589558 atte Esshe, Walter, of Messyngham, husbansdman 0
4949172 2341730 2341730 defendant Grave Thomas gent 589558 589558 Grave, Thomas, of Messyngham, gent 0
4949173 2341730 2341730 defendant Bonour Thomas laborer 589558 589558 Bonour, Thomas, of Messyngham, laborer 1
4954011 2343162 2343162 defendant Whitgift John husbandman 589558 589558 Whitgift, John, of Messyngham, husbandman 0
5159852 2403980 2403980 plaintiff Walles William   589558 589558 Walles, William, of Messyngham 1
5243494 2428292 2428292 defendant Tyrell George   589558 589558 Tyrell, George, of Messyngham 0
5262911 2434141 2434141 defendant Granger John husbandman 589558 589558 Granger, John, of Messyngham juxta Scoter, husbandman 0
5293196 2442989 2442989 defendant Granger John husbandman 589558 589558 Granger, John, of Messyngham, husbandman 0
5293198 2442990 2442990 defendant Granger John husbandman 589558 589558 Granger, John, of Messyngham, husbandman 0
5293200 2442991 2442991 defendant Roper John laborer 589558 589558 Roper, John, of Messyngham, laborer 0
5293202 2442992 2442992 defendant Roper John laborer 589558 589558 Roper, John, of Messyngham, laborer 0
5341694 2457596 2457596 defendant Graunger John husbandman 589558 589558 Graunger, John, of Messyngham, husbandman 1
5341695 2457596 2457596 defendant Whitefote John husbandman 589558 589558 Whitefote, John, of Messyngham, husbandman 2
5341696 2457596 2457596 defendant Whitefote Thomas husbandman 589558 589558 Whitefote, Thomas, of Messyngham, husbandman 3
5341697 2457596 2457596 defendant Barkworth John husbandman 589558 589558 Barkworth, John, of Messyngham, husbandman 4
5341698 2457596 2457596 defendant Barkworth William husbandman 589558 589558 Barkworth, William, of Messyngham, husbandman 5
5341700 2457596 2457596 defendant Magotson Robert husbandman 589558 589558 Magotson, Robert, of Messyngham, husbandman 7
5373218 2467218 2467218 defendant Wort Thomas draper 589558 589558 Wort, Thomas, of Messyngham, draper 0
5380147 2469371 2469371 defendant Brounles William yeoman 589558 589558 Brounles, William, of Messyngham, yeoman 0
5380148 2469371 2469371 defendant Graunger John, junior draper 589558 589558 Graunger, John, junior, of Messyngham, draper 1
5384229 2470578 2470578 defendant Brounles William yeoman 589558 589558 Brounles, William, of Messyngham, yeoman 0
5387868 2471589 2471589 defendant Post John mercer 589558 589558 Post, John, of Messyngham, mercer 1
5387869 2471589 2471589 defendant Bronlate William chapman 589558 589558 Bronlate, William, of Messyngham, chapman 2
5389290 2471981 2471981 defendant Walles John clerk 589558 589558 Walles, John, of Messyngham, clerk 1
5391038 2472507 2472507 defendant Wrote Thomas draper 589558 589558 Wrote, Thomas, of Messyngham, draper 0
5398258 2474572 2474572 defendant Graunger John draper 589558 589558 Graunger, John, of Messyngham, draper 1
5400488 2475207 2475207 defendant Bronlace William chapman 589558 589558 Bronlace, William, of Messyngham, chapman 2
5413481 2478957 2478957 defendant Post John mercer 589558 589558 Post, John, of Messyngham, mercer 1
5413482 2478957 2478957 defendant Bronlace William chapman 589558 589558 Bronlace, William, of Messyngham, chapman 2
5432439 2484673 2484673 defendant Brounles William mercer 589558 589558 Brounles, William, of Messyngham, mercer 2
5448550 2489464 2489464 defendant Brounles William mercer 589558 589558 Brounles, William, of Messyngham, mercer 2
5469349 2495762 2495762 defendant Richardson William draper 589558 589558 Richardson, William, of Messyngham, draper 0
5479128 2498782 2498782 defendant Graunger John, junior draper 589558 589558 Graunger, John, junior, of Messyngham, draper 2
5506138 2506838 2506838 defendant Graunger John, senior husbandman 589558 589558 Graunger, John, senior, of Messyngham, husbandman 0
5506139 2506838 2506838 defendant Graunger John, junior husbandman 589558 589558 Graunger, John, junior, of Messyngham, husbandman 1
5556264 2521828 2521828 defendant Graynger John yeoman 589558 589558 Graynger, John, of Messyngham, yeoman 1
5556276 2521831 2521831 defendant Granger John yeoman 589558 589558 Granger, John, of Messyngham, yeoman 1
5561969 2523481 2523481 defendant Johnson John husbandman 589558 589558 Johnson, John, of Messyngham, husbandman 0
5585437 2530514 2530514 defendant Graunger John draper 589558 589558 Graunger, John, of Messyngham, draper 0
5589436 2531698 2531698 defendant Wroote Thomas yeoman 589558 589558 Wroote, Thomas, of Messyngham, yeoman 0
5589439 2531699 2531699 defendant Wroote Thomas yeoman 589558 589558 Wroote, Thomas, of Messyngham, yeoman 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);