names

51 rows where place_id = 595628

✎ 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
3621239 1874182 1874182 defendant Wilde Thomas laborer 595628 595628 Wilde, Thomas, of Appulton, laborer 5
3621240 1874182 1874182 defendant Spenser Christopher laborer 595628 595628 Spenser, Christopher, of Appulton, laborer 6
3796374 1956732 1956732 defendant Sharpe John yeoman 595628 595628 Sharpe, John, of Appulton, yeoman 2
3859730 1976755 1976755 defendant Danyell Robert gent 595628 595628 Danyell, Robert, of Appulton, gent 0
3859732 1976756 1976756 defendant Danyell Robert gent 595628 595628 Danyell, Robert, of Appulton, gent 0
3859734 1976757 1976757 defendant Danyell Robert gent 595628 595628 Danyell, Robert, of Appulton, gent 0
3860437 1976985 1976985 defendant Coket Edward esq 595628 595628 Coket, Edward, of Appulton, esq 0
3913385 1994811 1994811 defendant Cokkett Anthony esq 595628 595628 Cokkett, Anthony, of Appulton, esq 0
3934594 2001863 2001863 defendant Cokett Anne widow 595628 595628 Cokett, Anne, of Appulton, widow 0
3934595 2001863 2001863 defendant Cokitt George gent 595628 595628 Cokitt, George, of Appulton, gent 1
4065188 2047832 2047832 defendant Charters Edmund gent 595628 595628 Charters, Edmund, of Appulton, gent 0
4653136 2246917 2246917 defendant FitzWaryn William gent 595628 595628 FitzWaryn, William, of Appulton, gent 0
4718280 2271055 2271055 defendant Heynes John   595628 595628 Heynes, John, of Appulton, parson 0
4801594 2296682 2296682 defendant Irmynglond Gregory gent 595628 595628 Irmynglond, Gregory, of Appulton, gent 0
4801600 2296683 2296683 defendant Irmynglond Gregory gent 595628 595628 Irmynglond, Gregory, of Appulton, gent 0
4811988 2299862 2299862 defendant Mercham Thomas husbandman 595628 595628 Mercham, Thomas, of Appulton, husbandman 0
4812353 2299977 2299977 defendant Irmynglond George esq 595628 595628 Irmynglond, George, of Appulton, esq 0
4826096 2304194 2304194 defendant Mercham Thomas husbandman 595628 595628 Mercham, Thomas, of Appulton, husbandman 0
4840030 2308430 2308430 defendant Irmynglond Richard gent 595628 595628 Irmynglond, Richard, of Appulton, gent 2
4840034 2308431 2308431 defendant Irmynglond John gent 595628 595628 Irmynglond, John, of Appulton, gent 2
4848588 2311032 2311032 defendant Dysse Richard yeoman 595628 595628 Dysse, Richard, of Appulton, yeoman 1
4861210 2314871 2314871 defendant Ermynglond Gregory gent 595628 595628 Ermynglond, Gregory, of Appulton, gent 2
4896425 2325548 2325548 defendant Durant William clerk 595628 595628 Durant, William, of Appulton, clerk 2
4974966 2349484 2349484 defendant Clerk Nicholas husbandman 595628 595628 Clerk, Nicholas, of Appulton, husbandman 3
5060468 2374710 2374710 plaintiff Freston Denis clerk 595628 595628 Freston, Denis, of Appulton, clerk 0
5060470 2374710 2374710 defendant FitzWaren Fulk yeoman 595628 595628 FitzWaren, Fulk, of Appulton, yeoman 1
5060471 2374710 2374710 defendant Baron Richard yeoman 595628 595628 Baron, Richard, of Appulton, yeoman 2
5060472 2374711 2374711 plaintiff Freston Denis clerk 595628 595628 Freston, Denis, of Appulton, clerk 0
5060474 2374711 2374711 defendant FitzWaren Fulk yeoman 595628 595628 FitzWaren, Fulk, of Appulton, yeoman 1
5060475 2374711 2374711 defendant Baron Richard yeoman 595628 595628 Baron, Richard, of Appulton, yeoman 2
5082235 2381179 2381179 defendant Turtevyle Edward gent 595628 595628 Turtevyle, Edward, of Appulton, gent 1
5128445 2394795 2394795 defendant Neugate William yeoman 595628 595628 Neugate, William, of Appulton, yeoman 0
5147542 2400423 2400423 defendant Neugate William yeoman 595628 595628 Neugate, William, of Appulton, yeoman 0
5167194 2406139 2406139 defendant Neugate William yeoman 595628 595628 Neugate, William, of Appulton, yeoman 0
5262116 2433900 2433900 plaintiff Newegate William   595628 595628 Newegate, William, of Appulton 0
5322747 2451880 2451880 defendant Morley Richard husbandman 595628 595628 Morley, Richard, of Appulton, husbandman 1
5322752 2451881 2451881 defendant Morley Richard husbandman 595628 595628 Morley, Richard, of Appulton, husbandman 1
5326947 2453133 2453133 defendant Asmolle alias Melcheburn Nicholas gent 595628 595628 Asmolle alias Melcheburn, Nicholas, of Appulton, or of Hyllyngton, gent 0
5332519 2454789 2454789 defendant Newegate William yeoman 595628 595628 Newegate, William, of Appulton, yeoman 5
5362914 2464048 2464048 defendant Newegate William yeoman 595628 595628 Newegate, William, of Appulton, yeoman 0
5362916 2464049 2464049 defendant Newegate William yeoman 595628 595628 Newegate, William, of Appulton, yeoman 0
5394182 2473396 2473396 plaintiff Broket William yeoman 595628 595628 Broket, William, of Appulton, yeoman 2
5407318 2477156 2477156 plaintiff Broket William yeoman 595628 595628 Broket, William, of Appulton, yeoman 2
5420564 2481074 2481074 plaintiff Broket William yeoman 595628 595628 Broket, William, of Appulton, yeoman 2
5420571 2481075 2481075 plaintiff Broket William yeoman 595628 595628 Broket, William, of Appulton, yeoman 2
5453354 2490888 2490888 defendant Ludyngton William clerk 595628 595628 Ludyngton, William, of Appulton, clerk 0
5462446 2493670 2493670 defendant Cade John husbandman 595628 595628 Cade, John, of Appulton, husbandman 0
5634371 2554741 2554741 defendant Warde William husbandman 595628 595628 Warde, William, of Appulton, husbandman 0
5634372 2554741 2554741 defendant Aubyn Richard husbandman 595628 595628 Aubyn, Richard, of Appulton, husbandman 1
5634373 2554741 2554741 defendant Marcham Thomas husbandman 595628 595628 Marcham, Thomas, of Appulton, husbandman 2
5634374 2554741 2554741 defendant Vevyan John husbandman 595628 595628 Vevyan, John, of Appulton, husbandman 3

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