names

101 rows where place_id = 601387

✎ 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
3645123 1908881 1908881 defendant Palmer Henry gent 601387 601387 Palmer, Henry, of Moulton, gent 0
3645125 1908882 1908882 defendant Skutter William laborer 601387 601387 Skutter, William, of Moulton, laborer 0
3645126 1908882 1908882 defendant Wellys John laborer 601387 601387 Wellys, John, of Moulton, laborer 1
3895416 1988677 1988677 defendant Sherman John, senior yeoman 601387 601387 Sherman, John, senior, of Moulton, yeoman 0
3895418 1988678 1988678 defendant Sherman John, senior yeoman 601387 601387 Sherman, John, senior, of Moulton, yeoman 0
3927162 1999419 1999419 defendant Wellys Thomas clerk 601387 601387 Wellys, Thomas, of Moulton, clerk 2
3927168 1999420 1999420 defendant Wellys Thomas clerk 601387 601387 Wellys, Thomas, of Moulton, clerk 2
3929940 2000356 2000356 defendant Ryxe Robert butcher 601387 601387 Ryxe, Robert, of Moulton, butcher 0
3971823 2014705 2014705 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4018438 2031327 2031327 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4024513 2033443 2033443 defendant Smyth Thomas yeoman 601387 601387 Smyth, Thomas, of Moulton, yeoman 0
4046302 2041119 2041119 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4052892 2043470 2043470 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4052998 2043505 2043505 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 3
4056984 2044880 2044880 defendant Tyte Richard husbandman 601387 601387 Tyte, Richard, of Moulton, husbandman 0
4059567 2045814 2045814 defendant Maye William sherman 601387 601387 Maye, William, of Moulton, sherman 0
4069311 2049308 2049308 defendant Grymsby John shoemaker 601387 601387 Grymsby, John, of Moulton, shoemaker 0
4073406 2050774 2050774 defendant Stanton Nicholas yeoman 601387 601387 Stanton, Nicholas, of Moulton, yeoman 3
4076027 2051723 2051723 defendant Farmor John husbandman 601387 601387 Farmor, John, of Moulton, husbandman 2
4078186 2052501 2052501 defendant Beamont Francis gent 601387 601387 Beamont, Francis, of Moulton, gent 0
4083768 2054469 2054469 defendant Stansby Richard yeoman 601387 601387 Stansby, Richard, of Moulton, yeoman 0
4086686 2055527 2055527 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4141918 2075338 2075338 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4141920 2075339 2075339 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4141922 2075340 2075340 defendant Palmer Edward gent 601387 601387 Palmer, Edward, of Moulton, gent 0
4144828 2076350 2076350 defendant Fryer William weaver 601387 601387 Fryer, William, of Moulton, weaver 4
4144829 2076350 2076350 defendant Clement Roger yeoman 601387 601387 Clement, Roger, of Moulton, yeoman 5
4190781 2092338 2092338 defendant Brymston Edmund yeoman 601387 601387 Brymston, Edmund, of Moulton, yeoman 0
4196344 2094263 2094263 defendant Chapman William   601387 601387 Chapman, William, of Moulton, yeoman, bachelor 1
4206088 2097678 2097678 defendant Wolsey John yeoman 601387 601387 Wolsey, John, of Moulton, yeoman 0
4217989 2101785 2101785 defendant Nubye John yeoman 601387 601387 Nubye, John, of Moulton, yeoman 1
4219709 2102398 2102398 defendant Billitout or Bullitont Ralph yeoman 601387 601387 Billitout or Bullitont, Ralph, of Moulton, yeoman 0
4221026 2102849 2102849 defendant Bun Richard carpenter 601387 601387 Bun, Richard, of Moulton, carpenter 3
4228290 2105376 2105376 defendant Sparrowe Richard yeoman 601387 601387 Sparrowe, Richard, of Moulton, yeoman 0
4228291 2105376 2105376 defendant Dyckson Anthony yeoman 601387 601387 Dyckson, Anthony, of Moulton, yeoman 1
4228292 2105376 2105376 defendant Collyer William yeoman 601387 601387 Collyer, William, of Moulton, yeoman 2
4230650 2106218 2106218 defendant Garrard William husbandman 601387 601387 Garrard, William, of Moulton, husbandman 0
4236630 2108385 2108385 defendant Kelwyn Thomas husbandman 601387 601387 Kelwyn, Thomas, of Moulton, husbandman 0
4236631 2108385 2108385 defendant Layne John husbandman 601387 601387 Layne, John, of Moulton, husbandman 1
4237815 2108827 2108827 defendant Newton John (legal representative) 601387 601387 Newton, John, of Moulton, husbandman, executrix of 1
4237816 2108827 2108827 defendant Newton Beatrice widow 601387 601387 Newton, Beatrice, of Moulton, widow 2
4238469 2109070 2109070 defendant Biggott John yeoman 601387 601387 Biggott, John, of Moulton, yeoman 0
4238482 2109073 2109073 defendant Chinocke Thomas   601387 601387 Chinocke, Thomas, of Moulton, yeoman, bailiff of wapentake of Ello 0
4238510 2109081 2109081 defendant Marshall James weaver 601387 601387 Marshall, James, of Moulton, weaver 1
4239011 2109263 2109263 defendant Stansby Richard yeoman 601387 601387 Stansby, Richard, of Moulton, yeoman 0
4241554 2110159 2110159 defendant Horne John   601387 601387 Horne, John, of Moulton, wheelwright 3
4245717 2111547 2111547 defendant Bulletonte John   601387 601387 Bulletonte, John, of Moulton yeoman 1
4251080 2113340 2113340 defendant Browne Thomas yeoman 601387 601387 Browne, Thomas, of Moulton, yeoman 1
4255942 2114963 2114963 defendant Bullytout or Bullytont John husbandman 601387 601387 Bullytout or Bullytont, John, of Moulton, husbandman 0
4255943 2114963 2114963 defendant Tite Richard   601387 601387 Tite, Richard, of Moulton, linen weaver 1
4257305 2115420 2115420 defendant Sparrowe Richard yeoman 601387 601387 Sparrowe, Richard, of Moulton, yeoman 0
4257306 2115420 2115420 defendant Dickson Anthony yeoman 601387 601387 Dickson, Anthony, of Moulton, yeoman 1
4257307 2115420 2115420 defendant Collyer William yeoman 601387 601387 Collyer, William, of Moulton, yeoman 2
4267522 2118772 2118772 defendant Biggott John yeoman 601387 601387 Biggott, John, of Moulton, yeoman 1
4275340 2121309 2121309 defendant Clarke Edward husbandman 601387 601387 together with Clarke, Edward, of Moulton, husbandman 1
4275369 2121322 2121322 defendant Cullyn Richard weaver 601387 601387 Cullyn, Richard, of Moulton, weaver 0
4275370 2121322 2121322 defendant Reve Thomas husbandman 601387 601387 together with Reve, Thomas, of Moulton, husbandman 1
4275372 2121322 2121322 defendant Tyte Edmund husbandman 601387 601387 Tyte, Edmund, of Moulton, husbandman 3
4276222 2121627 2121627 defendant Baxter John husbandman 601387 601387 Baxter, John, of Moulton, husbandman 2
4281680 2123497 2123497 defendant Trasye John gent 601387 601387 Trasye, John, of Moulton, gent 0
4281807 2123542 2123542 defendant Lynsey William yeoman 601387 601387 Lynsey, William, of Moulton, yeoman 0
4281808 2123542 2123542 defendant Lynsey John yeoman 601387 601387 Lynsey, John, of Moulton, yeoman 1
4290629 2126706 2126706 defendant Ryvett John gent 601387 601387 Ryvett, John, of Moulton, gent 0
4296492 2128847 2128847 defendant Crowe William husbandman 601387 601387 Crowe, William, of Moulton, husbandman 1
4296493 2128847 2128847 defendant Assye James husbandman 601387 601387 Assye, James, of Moulton, husbandman 2
4299034 2129751 2129751 defendant Lyndsey William yeoman 601387 601387 Lyndsey, William, of Moulton, yeoman 0
4312785 2134601 2134601 defendant Tyte Roger weaver 601387 601387 Tyte, Roger, of Moulton, weaver 0
4315453 2135516 2135516 defendant Crowe William husbandman 601387 601387 Crowe, William, of Moulton, husbandman 1
4315454 2135516 2135516 defendant Assye James husbandman 601387 601387 Assye, James, of Moulton, husbandman 2
4316540 2135902 2135902 defendant Ingram Nicholas husbandman 601387 601387 Ingram, Nicholas, of Moulton, husbandman 0
4320030 2137112 2137112 defendant Alexander Thomas yeoman 601387 601387 Alexander, Thomas, of Moulton, yeoman 0
4328879 2139971 2139971 defendant Knight alias Kett John yeoman 601387 601387 Knight alias Kett, John, of Moulton, yeoman 0
4342369 2144604 2144604 defendant Knight alias Kett John yeoman 601387 601387 Knight alias Kett, John, of Moulton, yeoman 1
4342480 2144643 2144643 defendant Clarke Edward laborer 601387 601387 Clarke, Edward, of Moulton, laborer 1
4344391 2145317 2145317 defendant Striet or Strete William husbandman 601387 601387 Striet or Strete, William, of Moulton, husbandman 1
4345243 2145613 2145613 defendant Palmer John gent 601387 601387 Palmer, John, of Moulton, gent 3
4345432 2145672 2145672 defendant Holbeche John husbandman 601387 601387 Holbeche, John, of Moulton, husbandman 0
4347594 2146406 2146406 defendant Street William husbandman 601387 601387 Street, William, of Moulton, husbandman 0
4352596 2148144 2148144 defendant Knyght alias Kett John yeoman 601387 601387 Knyght alias Kett, John, of Moulton, yeoman 0
4358481 2150199 2150199 defendant Baxter John   601387 601387 Baxter, John, of Moulton, mason 0
4362649 2151700 2151700 defendant Bullitout or Bullitont Thomas husbandman 601387 601387 Bullitout or Bullitont, Thomas, of Moulton, husbandman 1
4374071 2155797 2155797 defendant Peake Robert laborer 601387 601387 Peake, Robert, of Moulton, laborer 1
4374072 2155797 2155797 defendant Hardwicke William husbandman 601387 601387 Hardwicke, William, of Moulton, husbandman 2
4376217 2156560 2156560 defendant Lindsey Thomas yeoman 601387 601387 Lindsey, Thomas, of Moulton, yeoman 0
4377952 2157186 2157186 defendant Marche Robert husbandman 601387 601387 Marche, Robert, of Moulton, husbandman 0
4378249 2157287 2157287 defendant Heydon John gent 601387 601387 Heydon, John, of Moulton, gent 1
4379459 2157735 2157735 defendant Holbeche John husbandman 601387 601387 Holbeche, John, of Moulton, husbandman 0
4387598 2160490 2160490 defendant Horne John yeoman 601387 601387 Horne, John, of Moulton, yeoman 3
4388714 2160859 2160859 defendant Bullant Thomas husbandman 601387 601387 Bullant, Thomas, of Moulton, husbandman 1
4390228 2161355 2161355 defendant Hubberd Edmund gent 601387 601387 Hubberd, Edmund, of Moulton, gent 0
4393646 2162479 2162479 defendant Brodhouse Roger clerk 601387 601387 Brodhouse, Roger, of Moulton, clerk 0
4394457 2162743 2162743 defendant Bunne Richard, junior yeoman 601387 601387 Bunne, Richard, junior, of Moulton, yeoman 0
4397026 2163574 2163574 defendant Baxter John   601387 601387 Baxter, John, of Moulton, mason 0
4397027 2163574 2163574 defendant Fryer William weaver 601387 601387 Fryer, William, of Moulton, weaver 1
4397028 2163574 2163574 defendant Clement Thomas husbandman 601387 601387 Clement, Thomas, of Moulton, husbandman 2
4412470 2168761 2168761 defendant Randes William husbandman 601387 601387 Randes, William, of Moulton, husbandman 0
5018039 2362160 2362160 defendant Broun Thomas butcher 601387 601387 Broun, Thomas, of Moulton, butcher 0
5287344 2441321 2441321 defendant Porter William husbandman 601387 601387 Porter, William, of Moulton, husbandman 1
5287347 2441322 2441322 defendant Porter William husbandman 601387 601387 Porter, William, of Moulton, husbandman 1
5358770 2462801 2462801 defendant Skynner John husbandman 601387 601387 Skynner, John, of Moulton, husbandman 3

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