names

56 rows where place_id = 597398

✎ 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
3628417 1903754 1903754 defendant Thakkar Nicholas clerk 597398 597398 Thakkar, Nicholas, of Howe, clerk 0
3635176 1905798 1905798 defendant Hakon Robert husbandman 597398 597398 Hakon, Robert, of Howe, husbandman 0
3638348 1906812 1906812 defendant Cayster Thomas husbandman 597398 597398 Cayster, Thomas, of Howe, husbandman 1
3645504 1908995 1908995 defendant Malmes John husbandman 597398 597398 Malmes, John, of Howe, husbandman 0
3694903 1924615 1924615 plaintiff Pateryke Richard   597398 597398 Pateryke, Richard, of Howe 0
3694905 1924616 1924616 plaintiff Pateryke Richard   597398 597398 Pateryke, Richard, of Howe 0
3694907 1924617 1924617 plaintiff Pateryke Richard   597398 597398 Pateryke, Richard, of Howe 0
3701594 1926747 1926747 defendant Unketyll Thomas husbandman 597398 597398 Unketyll, Thomas, of Howe, husbandman 0
3701595 1926747 1926747 defendant Hacon alias Hawe John husbandman 597398 597398 Hacon alias Hawe, John, of Howe, husbandman 1
3732099 1936273 1936273 defendant Crowcher Richard husbandman 597398 597398 Crowcher, Richard, of Howe, husbandman 0
3745773 1940580 1940580 defendant Webbe William mariner 597398 597398 Webbe, William, of Howe, mariner 0
3776625 1950434 1950434 defendant Hykkys William mariner 597398 597398 Hykkys, William, of Howe, mariner 0
3803998 1959168 1959168 defendant Yong John husbandman 597398 597398 Yong, John, of Howe, husbandman 0
3803999 1959168 1959168 defendant Yong Simon husbandman 597398 597398 Yong, Simon, of Howe, husbandman 1
3833351 1968359 1968359 defendant Doraunt Walter yeoman 597398 597398 Doraunt, Walter, of Howe, yeoman 0
3836578 1969344 1969344 defendant Blyth Robert husbandman 597398 597398 Blyth, Robert, of Howe, husbandman 0
3849256 1973360 1973360 defendant Doraunt Walter husbandman 597398 597398 Doraunt, Walter, of Howe, husbandman 0
3889649 1986770 1986770 defendant Barker Richard gent 597398 597398 Barker, Richard, of Howe, gent 0
3903727 1991478 1991478 defendant Barker Richard gent 597398 597398 Barker, Richard, of Howe, gent 0
3936315 2002469 2002469 defendant Duwsbery Hugh clerk 597398 597398 Duwsbery, Hugh, of Howe, clerk 0
3948852 2006664 2006664 defendant Marker Thomas yeoman 597398 597398 Marker, Thomas, of Howe, yeoman 1
3957313 2009620 2009620 defendant Wygitt Richard husbandman 597398 597398 Wygitt, Richard, of Howe, husbandman 0
3958896 2010194 2010194 defendant Seeker Robert husbandman 597398 597398 Seeker, Robert, of Howe, husbandman 3
3963960 2012002 2012002 defendant Wygget Richard husbandman 597398 597398 Wygget, Richard, of Howe, or of Dereham, husbandman 0
3968199 2013502 2013502 defendant Brytyffe Simon   597398 597398 Brytyffe, Simon, of Howe, brick maker 2
4004749 2026474 2026474 defendant Warner Thomas gent 597398 597398 (Warner, Thomas, of Howe, gent 1
4004770 2026483 2026483 defendant Warner Thomas gent 597398 597398 (Warner, Thomas, of Howe, gent 1
4015245 2030145 2030145 defendant Boydon John, senior husbandman 597398 597398 Boydon, John, senior, of Howe, husbandman 0
4033039 2036467 2036467 plaintiff Goldsmithe Richard yeoman 597398 597398 Goldsmithe, Richard, of Howe, yeoman 0
4033041 2036468 2036468 plaintiff Goldsmithe Richard yeoman 597398 597398 Goldsmithe, Richard, of Howe, yeoman 0
4048874 2042039 2042039 defendant Mathewe Philip miller 597398 597398 Mathewe, Philip, of Howe, miller 3
4058043 2045257 2045257 defendant Beardwell James blacksmith 597398 597398 Beardwell, James, of Howe, blacksmith 1
4087823 2055938 2055938 defendant Hallman Edmund yeoman 597398 597398 Hallman, Edmund, of Howe, yeoman 0
4091873 2057389 2057389 plaintiff Dennye John esq 597398 597398 Dennye, John, of Howe, esq 0
4177163 2087485 2087485 defendant Denny Anthony gent 597398 597398 Denny, Anthony, of Howe, gent 0
4179854 2088428 2088428 defendant Smyth Henry husbandman 597398 597398 Smyth, Henry, of Howe, husbandman 1
4200320 2095666 2095666 defendant Denney Anthony gent 597398 597398 Denney, Anthony, of Howe, gent 0
4240387 2109762 2109762 defendant Moote Simon gunner 597398 597398 Moote, Simon, of Howe, gunner 0
4321785 2137707 2137707 defendant Barnard Thomas husbandman 597398 597398 Barnard, Thomas, of Howe, husbandman 0
4326144 2139113 2139113 defendant Mylmon Richard   597398 597398 Mylmon, Richard, of Howe carpenter 1
4336593 2142526 2142526 defendant Easton John clerk 597398 597398 Easton, John, of Howe, clerk 0
4395690 2163144 2163144 defendant Wigett Robert husbandman 597398 597398 Wigett, Robert, of Howe, husbandman 2
4395691 2163144 2163144 defendant Wiggett Brigit widow 597398 597398 Wiggett, Brigit, of Howe, widow 3
4591469 2228687 2228687 defendant Malmeys Thomas   597398 597398 Malmeys, Thomas, of Howe 2
4707087 2267602 2267602 plaintiff Maunde Thomas   597398 597398 Maunde, Thomas, of Howe 0
4752077 2281091 2281091 defendant Burny William yeoman 597398 597398 Burny, William, of Howe, yeoman 1
4767501 2285814 2285814 defendant Vaper Thomas husbandman 597398 597398 Vaper, Thomas, of Howe, husbandman 2
4793129 2293944 2293944 defendant Gudhale William yeoman 597398 597398 Gudhale, William, of Howe, yeoman 2
4857652 2313773 2313773 defendant Burny John husbandman 597398 597398 Burny, John, of Howe, husbandman 2
4866886 2316605 2316605 defendant Burne William yeoman 597398 597398 Burne, William, of Howe, yeoman 0
4885001 2322207 2322207 defendant Burny William yeoman 597398 597398 Burny, William, of Howe, yeoman 0
4909894 2329616 2329616 defendant Draper John gent 597398 597398 Draper, John, of Howe, gent 2
5340103 2457113 2457113 defendant Redeman Richard husbandman 597398 597398 Redeman, Richard, of Howe, husbandman 0
5504042 2506181 2506181 defendant Redale Richard husbandman 597398 597398 Redale, Richard, of Howe, husbandman 0
5541433 2517434 2517434 plaintiff Keme or Jene Robert (legal representative) 597398 597398 Keme or Jene, Robert, of Howe, chaplain, administrator of 0
5605291 2536533 2536533 defendant Symmys Stephen yeoman 597398 597398 Symmys, Stephen, of Howe, 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);