names

87 rows where place_id = 593209

✎ 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
3610918 1871090 1871090 defendant Syr Thomas husbandman 593209 593209 Syr, Thomas, of Moreton, husbandman 0
3610919 1871090 1871090 defendant Mathewe Edmund husbandman 593209 593209 Mathewe, Edmund, of Moreton, husbandman 1
3610920 1871090 1871090 defendant Henoden John husbandman 593209 593209 Henoden, John, of Moreton, husbandman 2
3610921 1871090 1871090 defendant Blower Richard husbandman 593209 593209 Blower, Richard, of Moreton, husbandman 3
3610922 1871090 1871090 defendant Cosyn Thomas husbandman 593209 593209 Cosyn, Thomas, of Moreton, husbandman 4
3610923 1871090 1871090 defendant Cosyn John husbandman 593209 593209 Cosyn, John, of Moreton, husbandman 5
3612186 1871454 1871454 defendant Rocke Walter carpenter 593209 593209 Rocke, Walter, of Moreton, carpenter 0
3660529 1913554 1913554 defendant St Hill William husbandman 593209 593209 St Hill, William, of Moreton, husbandman 0
3689893 1922999 1922999 defendant Aleyn John husbandman 593209 593209 Aleyn, John, of Moreton, husbandman 2
3689894 1922999 1922999 defendant Juell William husbandman 593209 593209 Juell, William, of Moreton, husbandman 3
3693264 1924103 1924103 defendant Reynold John clerk 593209 593209 Reynold, John, of Moreton, clerk 1
3704358 1927666 1927666 defendant Aleyn John husbandman 593209 593209 Aleyn, John, of Moreton, husbandman 2
3704359 1927666 1927666 defendant Juell or Inell William husbandman 593209 593209 Juell or Inell, William, of Moreton, husbandman 3
3707466 1928628 1928628 defendant Chaundeler Thomas husbandman 593209 593209 Chaundeler, Thomas, of Moreton, husbandman 3
3714205 1930741 1930741 defendant Tydeman James yeoman 593209 593209 Tydeman, James, of Moreton, yeoman 0
3740993 1939042 1939042 plaintiff Shurley Thomas   593209 593209 Shurley, Thomas, of Moreton, wool packer 0
3760147 1945170 1945170 defendant Chesten Richard husbandman 593209 593209 Chesten, Richard, of Moreton, husbandman 0
3879873 1983527 1983527 defendant Bodemere Thomas husbandman 593209 593209 Bodemere, Thomas, of Moreton, husbandman 1
3932344 2001120 2001120 defendant Warde William gent 593209 593209 Warde, William, of Moreton, gent 1
3956870 2009473 2009473 defendant Kyng Robert husbandman 593209 593209 Kyng, Robert, of Moreton, husbandman 0
3997258 2023790 2023790 plaintiff Duncombe John gent 593209 593209 Duncombe, John, of Moreton, gent 0
4035010 2037204 2037204 defendant Frampton Robert esq 593209 593209 Frampton, Robert, of Moreton, esq 0
4067058 2048516 2048516 defendant Stene or Steve alias Pole Thomas laborer 593209 593209 Stene or Steve alias Pole, Thomas, of Moreton, laborer 0
4071206 2050005 2050005 defendant Stene or Steve Thomas laborer 593209 593209 Stene or Steve, Thomas, of Moreton, laborer 1
4071295 2050037 2050037 defendant Fuberer Richard husbandman 593209 593209 Fuberer, Richard, of Moreton, husbandman 2
4116456 2066174 2066174 defendant Caseley Thomas husbandman 593209 593209 Caseley, Thomas, of Moreton, husbandman 0
4167901 2084259 2084259 defendant Oredyche alias Oleryshe Robert yeoman 593209 593209 Oredyche alias Oleryshe, Robert, of Moreton, yeoman 0
4181320 2088948 2088948 defendant Kynge Andrew, junior yeoman 593209 593209 Kynge, Andrew, junior, of Moreton, yeoman 0
4213832 2100357 2100357 defendant Pychar Richard husbsndman 593209 593209 Pychar, Richard, of Moreton, husbsndman 0
4236415 2108308 2108308 defendant Pitcher Richard husbandman 593209 593209 Pitcher, Richard, of Moreton, husbandman 0
4243779 2110899 2110899 defendant Skoggen John tailor 593209 593209 Skoggen, John, of Moreton, tailor 1
4309187 2133368 2133368 defendant Frampton Charles gent 593209 593209 Frampton, Charles, of Moreton, gent 2
4334394 2141781 2141781 defendant Muddle Ambrose yeoman 593209 593209 Muddle, Ambrose, of Moreton, yeoman 1
4380218 2158029 2158029 defendant Parker Edward husbandman 593209 593209 Parker, Edward, of Moreton, husbandman 3
4383786 2159283 2159283 defendant Edward John yeoman 593209 593209 Edward, John, of Moreton, yeoman 0
4383787 2159283 2159283 defendant White Richard yeoman 593209 593209 White, Richard, of Moreton, yeoman 1
4480318 2194509 2194509 plaintiff Kynges William   593209 593209 Kynges, William, of Moreton 0
4564006 2220316 2220316 defendant Brut John   593209 593209 Brut, John, of Moreton 0
4598591 2230799 2230799 plaintiff Spyry John   593209 593209 Spyry, John, of Moreton 0
4639460 2243058 2243058 plaintiff Corbet Robert   593209 593209 Corbet, Robert, of Moreton 0
4653273 2246964 2246964 defendant Bates John husbandman 593209 593209 Bates, John, of Moreton, husbandman 0
4653275 2246964 2246964 defendant Colyns Alice widow 593209 593209 Colyns, Alice, of Moreton, widow 2
4668591 2255885 2255885 defendant Kynton John yeoman 593209 593209 Kynton, John, of Moreton, yeoman 0
4700551 2265583 2265583 defendant Phelipp John smith 593209 593209 Phelipp, John, of Moreton, smith 1
4732150 2275239 2275239 defendant Smyth John smith 593209 593209 Smyth, John, of Moreton, smith 0
4742207 2278212 2278212 defendant Trussell Richard husbandman 593209 593209 Trussell, Richard, of Moreton, husbandman 0
4758324 2282978 2282978 defendant Halle Nicholas husbandman 593209 593209 Halle, Nicholas, of Moreton, husbandman 1
4802653 2297017 2297017 defendant Philippes John husbandman 593209 593209 Philippes, John, of Moreton, husbandman 1
4824099 2303611 2303611 defendant Selman Richard gent 593209 593209 Selman, Richard, of Moreton, gent 0
4826496 2304324 2304324 defendant Tyberton John   593209 593209 Tyberton, John, of Moreton, single man 0
4834928 2306926 2306926 defendant Busshe Richard husbandman 593209 593209 Busshe, Richard, of Moreton, husbandman 2
4861559 2314985 2314985 defendant Acclom Henry gent 593209 593209 Acclom, Henry, of Moreton, gent 1
4869286 2317361 2317361 defendant Trussell John husbandman 593209 593209 Trussell, John, of Moreton, husbandman 0
4878536 2320233 2320233 defendant Hoky John clerk 593209 593209 Hoky, John, of Moreton, clerk 1
4899698 2326538 2326538 defendant Oky John clerk 593209 593209 Oky, John, of Moreton, clerk 2
4954704 2343361 2343361 defendant Coppysfull William yeoman 593209 593209 Coppysfull, William, of Moreton, yeoman 2
4965928 2346740 2346740 defendant Harry William husbandman 593209 593209 Harry, William, of Moreton, husbandman 1
4968568 2347565 2347565 defendant Byrtby Thomas butcher 593209 593209 Byrtby, Thomas, of Moreton, butcher 0
4968570 2347565 2347565 defendant Barbour John barber 593209 593209 Barbour, John, of Moreton, barber 2
4973304 2348954 2348954 defendant Skynner William husbandman 593209 593209 Skynner, William, of Moreton, husbandman 0
5002529 2357652 2357652 defendant Hunt Richard husbandman 593209 593209 Hunt, Richard, of Moreton, husbandman 0
5003497 2357919 2357919 defendant Fereby Robert clerk 593209 593209 Fereby, Robert, of Moreton, clerk 0
5006273 2358731 2358731 defendant Estoft Walter gent 593209 593209 Estoft, Walter, of Moreton, gent 0
5006274 2358731 2358731 defendant Halle John gent 593209 593209 Halle, John, of Moreton, gent 1
5018520 2362297 2362297 plaintiff Corbet Roger esq 593209 593209 Corbet, Roger, of Moreton, esq 0
5050508 2371776 2371776 defendant Barry William husbandman 593209 593209 Barry, William, of Moreton, husbandman 1
5058216 2374014 2374014 plaintiff Cryour Thomas   593209 593209 Cryour, Thomas, of Moreton 0
5080662 2380705 2380705 defendant Selnsby or Selusby Giles gent 593209 593209 Selnsby or Selusby, Giles, of Moreton, gent 1
5120467 2392412 2392412 defendant Lamborn Nicholas husbandman 593209 593209 Lamborn, Nicholas, of Moreton, husbandman 0
5134372 2396550 2396550 defendant Corbert Roger   593209 593209 Corbert, Roger, of Moreton 0
5159736 2403949 2403949 plaintiff Sandbach William clerk & parson 593209 593209 Sandbach, William, of Moreton, clerk & parson 0
5196441 2414711 2414711 defendant Parsely Walter shoemaker 593209 593209 Parsely, Walter, of Moreton, shoemaker 0
5212127 2419285 2419285 defendant Churche William husbandman 593209 593209 Churche, William, of Moreton, husbandman 2
5212132 2419286 2419286 defendant Churche William husbandman 593209 593209 Churche, William, of Moreton, husbandman 2
5214292 2419913 2419913 defendant Baldewyn John brewer 593209 593209 Baldewyn, John, of Moreton, brewer 1
5218068 2421020 2421020 defendant Ward John, senior husbandman 593209 593209 Ward, John, senior, of Moreton, husbandman 0
5220643 2421733 2421733 defendant Corbet Roger   593209 593209 Corbet, Roger, of Moreton 0
5250085 2430133 2430133 plaintiff Warde John   593209 593209 Warde, John, of Moreton 0
5267353 2435555 2435555 defendant Chirche William yeoman 593209 593209 Chirche, William, of Moreton, yeoman 0
5272780 2437115 2437115 defendant Kyng William yeoman 593209 593209 Kyng, William, of Moreton, yeoman 0
5272782 2437116 2437116 defendant Kyng William (legal representative) 593209 593209 Kyng, William, of Moreton, yeoman, executors of 0
5272783 2437116 2437116 defendant Kyng Margaret widow 593209 593209 (Kyng, Margaret, of Moreton, widow 1
5296189 2443876 2443876 defendant Chirch William husbandman 593209 593209 Chirch, William, of Moreton, husbandman 0
5296191 2443877 2443877 defendant Chirch William husbandman 593209 593209 Chirch, William, of Moreton, husbandman 0
5362123 2463818 2463818 defendant Bayly Robert husbandman 593209 593209 Bayly, Robert, of Moreton, husbandman 0
5362124 2463818 2463818 defendant Cornesse William husbandman 593209 593209 Cornesse, William, of Moreton, husbandman 1
5517419 2510292 2510292 defendant Wellyngton Thomas husbandman 593209 593209 Wellyngton, Thomas, of Moreton, husbandman 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);