names

549 rows where place_id = 586779

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589605 1864389 1864389 defendant Houchons Peter husbandman 586779 586779 Houchons, Peter, of Brampton, husbandman 0
3594056 1865782 1865782 defendant Howechon Peter husbandman 586779 586779 Howechon, Peter, of Brampton, husbandman 0
3595122 1866105 1866105 defendant Salwys Geoffrey yeoman 586779 586779 Salwys, Geoffrey, of Brampton, yeoman 0
3596414 1866508 1866508 defendant Salwys Geoffrey husbandman 586779 586779 Salwys, Geoffrey, of Brampton, husbandman 2
3599049 1867337 1867337 defendant Pounte John husbandman 586779 586779 Pounte, John, of Brampton, husbandman 0
3601634 1868167 1868167 defendant Depden Roger yeoman 586779 586779 Depden, Roger, of Brampton, yeoman 0
3611009 1871121 1871121 defendant Assh Elizabeth widow 586779 586779 Assh, Elizabeth, of Brampton, widow 0
3611010 1871121 1871121 defendant Assh John laborer 586779 586779 Assh, John, of Brampton, laborer 1
3611016 1871122 1871122 defendant Asshe Elizabeth widow 586779 586779 Asshe, Elizabeth, of Brampton, widow 2
3611017 1871122 1871122 defendant Asshe John laborer 586779 586779 Asshe, John, of Brampton, laborer 3
3615074 1872360 1872360 defendant Depden Roger yeoman 586779 586779 Depden, Roger, of Brampton, yeoman 0
3617334 1873044 1873044 defendant Croft William husbandman 586779 586779 Croft, William, of Brampton, husbandman 4
3617335 1873044 1873044 defendant Croft Thomas husbandman 586779 586779 Croft, Thomas, of Brampton, husbandman 5
3617341 1873045 1873045 defendant Croft William husbandman 586779 586779 Croft, William, of Brampton, husbandman 4
3617342 1873045 1873045 defendant Croft Thomas husbandman 586779 586779 Croft, Thomas, of Brampton, husbandman 5
3617729 1873169 1873169 defendant Asshe Richard chaplain 586779 586779 Asshe, Richard, of Brampton, chaplain 0
3620736 1874061 1874061 defendant Freman William husbandman 586779 586779 Freman, William, of Brampton, husbandman 1
3622715 1874633 1874633 defendant Depden Roger yeoman 586779 586779 Depden, Roger, of Brampton, yeoman 0
3625941 1902970 1902970 defendant Lokecok John husbandman 586779 586779 Lokecok, John, of Brampton, husbandman 0
3629726 1904149 1904149 plaintiff Debden John   586779 586779 Debden, John, of Brampton 0
3629750 1904155 1904155 plaintiff Deldon John   586779 586779 Deldon, John, of Brampton 0
3633676 1905343 1905343 defendant Torre William laborer 586779 586779 Torre, William, of Brampton, laborer 2
3644056 1908571 1908571 defendant Grene Edmund husbandman 586779 586779 Grene, Edmund, of Brampton, husbandman 0
3644057 1908571 1908571 defendant Grene Richard husbandman 586779 586779 Grene, Richard, of Brampton, husbandman 1
3644058 1908571 1908571 defendant Codlyng William painter 586779 586779 Codlyng, William, of Brampton, painter 2
3645118 1908879 1908879 defendant Payn Thomas (legal representative) 586779 586779 Payn, Thomas, of Brampton, executrix of 0
3647644 1909649 1909649 defendant Moore James husbandman 586779 586779 Moore, James, of Brampton, husbandman 0
3647645 1909649 1909649 defendant More Robert husbandman 586779 586779 More, Robert, of Brampton, husbandman 1
3651637 1910872 1910872 defendant Pygott Roger husbandman 586779 586779 Pygott, Roger, of Brampton, husbandman 0
3672661 1917452 1917452 plaintiff Debden John   586779 586779 Debden, John, of Brampton 0
3677044 1918861 1918861 defendant Lancastre Thomas gent 586779 586779 Lancastre, Thomas, of Brampton, gent 0
3677045 1918861 1918861 defendant Gollen Thomas yeoman 586779 586779 Gollen, Thomas, of Brampton, yeoman 1
3677046 1918861 1918861 defendant Clert Hugh yeoman 586779 586779 Clert, Hugh, of Brampton, yeoman 2
3677047 1918861 1918861 defendant Sheperd John, senior yeoman 586779 586779 Sheperd, John, senior, of Brampton, yeoman 3
3677048 1918861 1918861 defendant Sheperd Henry yeoman 586779 586779 Sheperd, Henry, of Brampton, yeoman 4
3685752 1921700 1921700 defendant Womwell Roger gent 586779 586779 Womwell, Roger, of Brampton, gent 0
3688715 1922631 1922631 defendant Leny or Levy William husbandman 586779 586779 Leny or Levy, William, of Brampton, husbandman 0
3691567 1923519 1923519 defendant Warne John husbandman 586779 586779 Warne, John, of Brampton, husbandman 0
3697630 1925483 1925483 defendant Carman William husbandman 586779 586779 Carman, William, of Brampton, husbandman 1
3702024 1926887 1926887 defendant Rowesley Christopher gent 586779 586779 Rowesley, Christopher, of Brampton, gent 1
3702025 1926887 1926887 defendant Calton William husbandman 586779 586779 Calton, William, of Brampton, husbandman 2
3702026 1926887 1926887 defendant Grevis John husbandman 586779 586779 Grevis, John, of Brampton, husbandman 3
3704283 1927639 1927639 defendant Shawe Thomas clerk 586779 586779 Shawe, Thomas, of Brampton, clerk 0
3705683 1928059 1928059 defendant Warne John husbandman 586779 586779 Warne, John, of Brampton, husbandman 0
3708521 1928961 1928961 defendant Skygge Walter clerk 586779 586779 Skygge, Walter, of Brampton, clerk 0
3718268 1931999 1931999 defendant Boler William husbandman 586779 586779 Boler, William, of Brampton, husbandman 1
3718269 1931999 1931999 defendant Lees Elizabeth widow 586779 586779 Lees, Elizabeth, of Brampton, widow 2
3718270 1931999 1931999 defendant Lees Margaret spinster 586779 586779 Lees, Margaret, of Brampton, spinster 3
3729827 1935584 1935584 defendant Fuliambe Roger esq 586779 586779 Fuliambe, Roger, of Brampton, esq 0
3731196 1935981 1935981 defendant Legge Thomas husbandman 586779 586779 Legge, Thomas, of Brampton, husbandman 0
3731464 1936067 1936067 defendant Pegot Roger (legal representative) 586779 586779 Pegot, Roger, of Brampton, executors of 1
3732417 1936372 1936372 defendant Wyllyams Richard yeoman 586779 586779 Wyllyams, Richard, of Brampton, yeoman 0
3737709 1938015 1938015 defendant Stephan John husbandman 586779 586779 Stephan, John, of Brampton, husbandman 3
3742004 1939368 1939368 defendant Pyke Agnes widow 586779 586779 Pyke, Agnes, of Brampton, widow 0
3743547 1939857 1939857 defendant Henson John husbandman 586779 586779 Henson, John, of Brampton, husbandman 0
3750377 1942038 1942038 defendant Forde Henry butcher 586779 586779 Forde, Henry, of Brampton, butcher 0
3751546 1942399 1942399 defendant Marshall Thomas husbandman 586779 586779 Marshall, Thomas, of Brampton, husbandman 0
3751547 1942399 1942399 defendant Warnet John husbandman 586779 586779 Warnet, John, of Brampton, husbandman 1
3752503 1942707 1942707 defendant Ford Henry butcher 586779 586779 Ford, Henry, of Brampton, butcher 1
3752863 1942819 1942819 defendant Forthe Henry butcher 586779 586779 Forthe, Henry, of Brampton, butcher 0
3753081 1942902 1942902 defendant Schaa Richard laborer 586779 586779 Schaa, Richard, of Brampton, laborer 1
3753082 1942902 1942902 defendant Schaa Thomas laborer 586779 586779 Schaa, Thomas, of Brampton, laborer 2
3755481 1943667 1943667 defendant Ford Henry butcher 586779 586779 Ford, Henry, of Brampton, butcher 1
3755482 1943667 1943667 defendant Ford John butcher 586779 586779 Ford, John, of Brampton, butcher 2
3757395 1944294 1944294 defendant Forde Henry butcher 586779 586779 Forde, Henry, of Brampton, butcher 1
3757396 1944294 1944294 defendant Forde John butcher 586779 586779 Forde, John, of Brampton, butcher 2
3759193 1944863 1944863 plaintiff Charnok Thomas (legal representative) 586779 586779 Charnok, Thomas, of Brampton, administrator of 0
3764014 1946388 1946388 defendant Hall John yeoman 586779 586779 Hall, John, of Brampton, yeoman 0
3764015 1946388 1946388 defendant Wyld Thomas husbandman 586779 586779 Wyld, Thomas, of Brampton, husbandman 1
3765346 1946823 1946823 defendant Bocle James husbandman 586779 586779 Bocle, James, of Brampton, husbandman 0
3766152 1947066 1947066 defendant More James husbandman 586779 586779 More, James, of Brampton, husbandman 0
3766153 1947066 1947066 defendant Crofte Humphrey yeoman 586779 586779 Crofte, Humphrey, of Brampton, yeoman 1
3770090 1948308 1948308 defendant Cosby Richard husbandman 586779 586779 Cosby, Richard, of Brampton, husbandman 2
3770944 1948597 1948597 defendant Tybton John carpenter 586779 586779 Tybton, John, of Brampton, carpenter 0
3773332 1949372 1949372 defendant Ford John butcher 586779 586779 Ford, John, of Brampton, butcher 0
3774280 1949676 1949676 defendant Moldson John husbandman 586779 586779 Moldson, John, of Brampton, husbandman 0
3774281 1949676 1949676 defendant Moldson George husbandman 586779 586779 Moldson, George, of Brampton, husbandman 1
3779944 1951453 1951453 defendant Boker William husbandman 586779 586779 Boker, William, of Brampton, husbandman 1
3779945 1951453 1951453 defendant Lees Elizabeth spinster 586779 586779 Lees, Elizabeth, of Brampton, spinster 2
3779946 1951453 1951453 defendant Lees Margaret spinster 586779 586779 Lees, Margaret, of Brampton, spinster 3
3783732 1952675 1952675 defendant Shawe Robert   586779 586779 Shawe, Robert, of Brampton 2
3784402 1952902 1952902 defendant Anton John husbandman 586779 586779 Anton, John, of Brampton, husbandman 0
3789854 1954654 1954654 defendant Forde John butcher 586779 586779 Forde, John, of Brampton, butcher 0
3791121 1955057 1955057 defendant Warnett John husbandman 586779 586779 Warnett, John, of Brampton, husbandman 2
3791122 1955057 1955057 defendant Marshall Thomas husbandman 586779 586779 Marshall, Thomas, of Brampton, husbandman 3
3797476 1957099 1957099 defendant Stevyns John husbandman 586779 586779 Stevyns, John, of Brampton, husbandman 0
3797478 1957100 1957100 defendant Stevyns John husbandman 586779 586779 Stevyns, John, of Brampton, husbandman 0
3799855 1957871 1957871 defendant Whithede Richard   586779 586779 Whithede, Richard, of Brampton, yeoman, Joan his wife 0
3803556 1959019 1959019 defendant Newham William husbandman 586779 586779 Newham, William, of Brampton, husbandman 1
3809635 1960901 1960901 defendant Heyward Walter husbandman 586779 586779 Heyward, Walter, of Brampton, husbandman 0
3810415 1961148 1961148 defendant Leke Thomas gent 586779 586779 Leke, Thomas, of Brampton, gent 0
3818130 1963584 1963584 defendant Shawe John Derbs, yeoman 586779 586779 Shawe John, of Brampton, Derbs, yeoman 1
3818134 1963585 1963585 defendant Shawe John Derbs, yeoman 586779 586779 Shawe John, of Brampton, Derbs, yeoman 1
3820929 1964440 1964440 defendant Newham William husbandman 586779 586779 Newham, William, of Brampton, husbandman 1
3824920 1965672 1965672 defendant Coo William miller 586779 586779 Coo, William, of Brampton, miller 1
3824967 1965682 1965682 defendant Stevyns John husbandman 586779 586779 Stevyns, John, of Brampton, husbandman 0
3828155 1966673 1966673 defendant Pantre John husbandman 586779 586779 Pantre, John, of Brampton, husbandman 2
3836491 1969319 1969319 defendant Warne John husbandman 586779 586779 Warne, John, of Brampton, husbandman 0
3839090 1970146 1970146 plaintiff Warne John   586779 586779 Warne, John, of Brampton 0
3842454 1971177 1971177 defendant Lenny William yeoman 586779 586779 Lenny, William, of Brampton, yeoman 1

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