names

51 rows where place_id = 589109

✎ 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
3596569 1866561 1866561 defendant Jakson John husbandman 589109 589109 Jakson, John, of Alburgh, husbandman 0
3596570 1866561 1866561 defendant Johnson Robert husbandman 589109 589109 Johnson, Robert, of Alburgh, husbandman 1
3596571 1866561 1866561 defendant Thirdband William husbandman 589109 589109 Thirdband, William, of Alburgh, husbandman 2
3632009 1904828 1904828 defendant Peryng Nicholas beer brewer 589109 589109 Peryng, Nicholas, of Alburgh, beer brewer 0
3642774 1908188 1908188 defendant Harward Robert gent 589109 589109 Harward, Robert, of Alburgh, gent 5
3655130 1911865 1911865 defendant Lomnour Thomas gent 589109 589109 Lomnour, Thomas, of Alburgh, gent 3
3655221 1911890 1911890 defendant Crokys John husbandman 589109 589109 Crokys, John, of Alburgh, husbandman 2
3661871 1914000 1914000 defendant Corbold Richard butcher 589109 589109 Corbold, Richard, of Alburgh, butcher 0
3665940 1915282 1915282 defendant Huntrodys Thomas glover 589109 589109 Huntrodys, Thomas, of Alburgh, glover 0
3670515 1916740 1916740 defendant Taverner Richard husbandman 589109 589109 Taverner, Richard, of Alburgh, husbandman 1
3676514 1918698 1918698 defendant Lumnour Thomas gent 589109 589109 Lumnour, Thomas, of Alburgh, gent 0
3676518 1918699 1918699 defendant Lumnour Thomas gent 589109 589109 Lumnour, Thomas, of Alburgh, gent 0
3679575 1919681 1919681 plaintiff Plumbe John   589109 589109 Plumbe, John, of Alburgh 0
3684462 1921273 1921273 defendant Mody Richard tanner 589109 589109 Mody, Richard, of Alburgh, tanner 0
3686596 1921959 1921959 defendant Harward Robert gent 589109 589109 Harward, Robert, of Alburgh, gent 1
3687419 1922243 1922243 defendant Harward Robert gent 589109 589109 Harward, Robert, of Alburgh, gent 0
3699799 1926163 1926163 defendant Wright Richard husbandman 589109 589109 Wright, Richard, of Alburgh, husbandman 0
3704640 1927737 1927737 defendant Wryght Richard husbandman 589109 589109 Wryght, Richard, of Alburgh, husbandman 0
3735249 1937259 1937259 defendant Sutton John yeoman 589109 589109 Sutton, John, of Alburgh, yeoman 0
3735250 1937259 1937259 defendant Smythes John yeoman 589109 589109 Smythes, John, of Alburgh, yeoman 1
3744039 1940029 1940029 defendant Hunt Richard smith 589109 589109 Hunt, Richard, of Alburgh, smith 0
3791665 1955237 1955237 defendant Plumbe John yeoman 589109 589109 Plumbe, John, of Alburgh, yeoman 0
3794585 1956184 1956184 defendant Areton Christopher husbandman 589109 589109 Areton, Christopher, of Alburgh, husbandman 1
3813904 1962259 1962259 defendant Herward Robert gent 589109 589109 Herward, Robert, of Alburgh, gent 3
3826930 1966274 1966274 plaintiff Benche Edmund mariner 589109 589109 Benche, Edmund, of Alburgh, mariner 0
3841177 1970818 1970818 defendant Warne William shoemkaer 589109 589109 Warne, William, of Alburgh, shoemkaer 2
3843422 1971478 1971478 defendant Herward Robert gent 589109 589109 Herward, Robert, of Alburgh, gent 0
3847560 1972804 1972804 defendant Harward Robert esq 589109 589109 Harward, Robert, of Alburgh, esq 0
3895412 1988675 1988675 defendant Hooker John yeoman 589109 589109 Hooker, John, of Alburgh, yeoman 1
3912192 1994405 1994405 defendant Harward Robert gent 589109 589109 Harward, Robert, of Alburgh, gent 0
3920686 1997268 1997268 defendant Harward Robert esq 589109 589109 Harward, Robert, of Alburgh, esq 4
4003100 2025870 2025870 plaintiff Holland Robert (legal representative) 589109 589109 Holland, Robert, of Alburgh, or of Pulham Mary, Norf, administrator of 0
4003103 2025871 2025871 plaintiff Holland Robert (legal representative) 589109 589109 Holland, Robert, of Alburgh, or of Pulham Mary, Norf, mercer, Norf, administrator of 0
4045420 2040813 2040813 defendant Calver Robert yeoman 589109 589109 Calver, Robert, of Alburgh, yeoman 4
4053268 2043548 2043548 defendant Marys William husbandman 589109 589109 Marys, William, of Alburgh, husbandman 8
4091893 2057395 2057395 defendant Propheit Robert mariner 589109 589109 Propheit, Robert, of Alburgh, mariner 1
4140430 2074821 2074821 defendant Warren John yeoman 589109 589109 Warren, John, of Alburgh, yeoman 0
4457408 2187329 2187329 defendant Mowe Robert   589109 589109 Mowe, Robert, of Alburgh 0
4457409 2187329 2187329 defendant Deye John   589109 589109 Deye, John, of Alburgh, formerly servant of Robert Hereward 1
4514190 2204855 2204855 defendant Watt Thomas   589109 589109 Watt, Thomas, of Alburgh 4
4865617 2316212 2316212 defendant Copper William yeoman 589109 589109 Copper, William, of Alburgh, yeoman 6
4959598 2344829 2344829 defendant Tuke Thomas husbandman 589109 589109 Tuke, Thomas, of Alburgh, husbandman 2
4977909 2350354 2350354 plaintiff Randes Robert   589109 589109 Randes, Robert, of Alburgh 0
5315915 2449835 2449835 defendant Albon Thomas husbandman 589109 589109 Albon, Thomas, of Alburgh, husbandman 1
5338147 2456498 2456498 defendant Lucas John husbandman 589109 589109 Lucas, John, of Alburgh, husbandman 1
5338150 2456499 2456499 defendant Lucas John husbandman 589109 589109 Lucas, John, of Alburgh, husbandman 1
5512522 2508776 2508776 defendant Berebrewer Nicholas beer brewer 589109 589109 Berebrewer, Nicholas, of Alburgh, beer brewer 2
5519015 2510791 2510791 defendant Alwedyr Robert clerk 589109 589109 Alwedyr, Robert, of Alburgh, clerk 0
5566467 2524785 2524785 defendant Wynter Henry esq 589109 589109 Wynter, Henry, of Alburgh, esq 0
5598506 2534418 2534418 defendant Barthram Roger tailor 589109 589109 Barthram, Roger, of Alburgh, tailor 1
5598566 2534436 2534436 defendant Herward Robert gent 589109 589109 Herward, Robert, of Alburgh, gent 4

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