names

126 rows where place_id = 589732

✎ 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
3598562 1867176 1867176 defendant Glascok Geoffrey butcher 589732 589732 Glascok, Geoffrey, of High Ester, butcher 1
3598896 1867281 1867281 defendant Glascok John husbandman 589732 589732 Glascok, John, of High Ester, husbandman 1
3617945 1873237 1873237 defendant Galscok or Glascok John husbandman 589732 589732 Galscok or Glascok, John, of High Ester, husbandman 2
3641911 1907924 1907924 defendant Lokyn John husbandman 589732 589732 Lokyn, John, of High Ester, husbandman 1
3642727 1908171 1908171 defendant Bysshope John husbandman 589732 589732 Bysshope, John, of High Ester, husbandman 0
3648985 1910072 1910072 defendant Eve William yeoman 589732 589732 Eve, William, of High Ester, yeoman 0
3673366 1917687 1917687 defendant Godfrey Richard husbandman 589732 589732 Godfrey, Richard, of High Ester, husbandman 0
3687037 1922117 1922117 defendant Steylman Edmund clerk 589732 589732 (Steylman, Edmund, of High Ester, clerk 1
3687038 1922117 1922117 defendant Steylman John husbandman 589732 589732 Steylman, John, of High Ester, husbandman 2
3687039 1922117 1922117 defendant Goche William husbandman 589732 589732 Goche, William, of High Ester, husbandman 3
3704858 1927813 1927813 defendant Eve William butcher 589732 589732 Eve, William, of High Ester, butcher 2
3725743 1934340 1934340 defendant Adlome Robert husbandman 589732 589732 Adlome, Robert, of High Ester, husbandman 0
3725744 1934340 1934340 defendant Adlome Geoffrey husbandman 589732 589732 Adlome, Geoffrey, of High Ester, husbandman 1
3725745 1934340 1934340 defendant Adlome George husbandman 589732 589732 Adlome, George, of High Ester, husbandman 2
3725746 1934340 1934340 defendant Adlome Thomas, junior husbandman 589732 589732 Adlome, Thomas, junior, of High Ester, husbandman 3
3729286 1935410 1935410 defendant Weyberd John yeoman 589732 589732 Weyberd, John, of High Onger, yeoman 0
3729287 1935410 1935410 defendant Weyberd Elizabeth widow 589732 589732 Weyberd, Elizabeth, of High Onger, widow 1
3736176 1937557 1937557 defendant Holden John husbandman 589732 589732 Holden, John, of High Ester, husbandman 1
3736597 1937698 1937698 defendant Fernam John husbandman 589732 589732 Fernam, John, of High Ester, husbandman 0
3737856 1938059 1938059 defendant Wybard Elizabeth widow 589732 589732 (Wybard, Elizabeth, of High Onger, widow 1
3737857 1938059 1938059 defendant Wybard John yeoman 589732 589732 Wybard, John, of High Onger, yeoman 2
3739524 1938571 1938571 defendant Luke John carpenter 589732 589732 Luke, John, of High Lauffer, carpenter 0
3750502 1942071 1942071 defendant Colyn William maltman 589732 589732 Colyn, William, of High Onger, maltman 0
3756801 1944099 1944099 defendant Noryce Robert husbandman 589732 589732 Noryce, Robert, of High Onger, husbandman 0
3761879 1945724 1945724 defendant Colyn William husbandman 589732 589732 Colyn, William, of High Onger, husbandman 0
3786588 1953601 1953601 defendant Stephyn Thomas husbandman 589732 589732 Stephyn, Thomas, of High Onger, husbandman 1
3786589 1953601 1953601 defendant Horne William husbandman 589732 589732 Horne, William, of High Onger, husbandman 2
3787500 1953879 1953879 defendant Wyat William laborer 589732 589732 Wyat, William, of High Ester, laborer 2
3836875 1969432 1969432 defendant Barrett William husbandman 589732 589732 Barrett, William, of High Onger, husbandman 1
3836950 1969463 1969463 defendant Coole John husbandman 589732 589732 Coole, John, of High Ester, husbandman 1
3842560 1971201 1971201 defendant Eve John husbandman 589732 589732 Eve, John, of High Ester, husbandman 2
3856704 1975725 1975725 defendant Barrett John husbandman 589732 589732 Barrett, John, of High Onger, husbandman 0
3867944 1979513 1979513 defendant Stane Andrew husbandman 589732 589732 Stane, Andrew, of High Ester, husbandman 0
3868153 1979587 1979587 defendant Salyng William yeoman 589732 589732 Salyng, William, of High Onger, yeoman 0
3872984 1981179 1981179 defendant Eve John husbandman 589732 589732 Eve, John, of High Easter, husbandman 0
3872986 1981180 1981180 defendant Eve John husbandman 589732 589732 Eve, John, of High Easter, husbandman 0
3944393 2005137 2005137 defendant Barrett Richard husbandman 589732 589732 Barrett, Richard, of High Onger, husbandman 0
3949502 2006897 2006897 plaintiff Ellys John   589732 589732 Ellys, John, of High Ester, administrators of 0
3952315 2007880 2007880 defendant Claye Thomas husbandman 589732 589732 Claye, Thomas, of High Laver, husbandman 0
3957984 2009856 2009856 defendant Radley Thomas husbandman 589732 589732 Radley, Thomas, of High Onger, husbandman 0
3961812 2011232 2011232 defendant Kennett John husbandman 589732 589732 Kennett, John, of High Ester, or of Good Hester, husbandman 0
3988216 2020533 2020533 defendant Hode Richard husbandman 589732 589732 Hode, Richard, of High Onger, husbandman 1
4132786 2072052 2072052 defendant Hyde Michael husbandman 589732 589732 Hyde, Michael, of High Ester, husbandman 0
4179589 2088336 2088336 defendant Poole William turner 589732 589732 Poole, William, of High Easter, turner 0
4240438 2109779 2109779 defendant Shipton Anne widow 589732 589732 Shipton, Anne, of High Laver, widow 1
4249414 2112790 2112790 defendant Robioute or Robionte William yeoman 589732 589732 Robioute or Robionte, William, of High Easter, yeoman 0
4275436 2121345 2121345 defendant Horne Thomas yeoman 589732 589732 Horne, Thomas, of High Onger, yeoman 0
4279839 2122865 2122865 defendant Robgeant Thomas yeoman 589732 589732 Robgeant, Thomas, of High Ester, yeoman 0
4279840 2122865 2122865 defendant Woodde Thomas yeoman 589732 589732 Woodde, Thomas, of High Ester, yeoman 1
4280058 2122936 2122936 defendant Robgoante Thomas yeoman 589732 589732 Robgoante, Thomas, of High Ester, yeoman 0
4280059 2122936 2122936 defendant Woodde Thomas yeoman 589732 589732 Woodde, Thomas, of High Ester, yeoman 1
4281926 2123580 2123580 defendant Magett Thomas laborer 589732 589732 Magett, Thomas, of High Ester, laborer 6
4282178 2123668 2123668 defendant Burre George yeoman 589732 589732 Burre, George, of High Ester, yeoman 0
4282274 2123701 2123701 defendant Stileman Richard yeoman 589732 589732 Stileman, Richard, of High Ester, yeoman 0
4282275 2123701 2123701 defendant Wood Thomas yeoman 589732 589732 Wood, Thomas, of High Ester, yeoman 1
4290983 2126838 2126838 defendant Burre George yeoman 589732 589732 Burre, George, of High Easter, yeoman 0
4309874 2133609 2133609 defendant Robiaunt Rgomas yeoman 589732 589732 Robiaunt, Rgomas, of High Ester, yeoman 0
4333684 2141545 2141545 defendant Hogge Thomas yeoman 589732 589732 Hogge, Thomas, of High Onger, yeoman 1
4376382 2156623 2156623 defendant Bingham Lawrence gent 589732 589732 Bingham, Lawrence, of High Onger, gent 1
4377215 2156925 2156925 defendant Clere William husbandman 589732 589732 Clere, William, of High Easter, husbandman 0
4393928 2162570 2162570 defendant Roberd Edmund butcher 589732 589732 Roberd, Edmund, of High Ester, butcher 0
4393932 2162571 2162571 defendant Roberd Edmund butcher 589732 589732 Roberd, Edmund, of High Ester, butcher 0
4408116 2167285 2167285 defendant Johnson Charles gent 589732 589732 Johnson, Charles, of High Onger, gent 0
4418200 2170573 2170573 defendant Lytlebourn Edmund de clerk 589732 589732 Lytlebourn, Edmund de, of High Easter, clerk 0
4440489 2181935 2181935 defendant Styward Thomas   589732 589732 Styward, Thomas, of High Easter 0
4522414 2207350 2207350 defendant Benyngton William   589732 589732 Benyngton, William, of High Easter 0
4526010 2208434 2208434 defendant Baker John   589732 589732 Baker, John, of High Easter 4
4548443 2215451 2215451 defendant Noun John   589732 589732 Noun, John, of High Easter 0
4548446 2215452 2215452 defendant _n Stephen   589732 589732 _n, Stephen, of High Easter 0
4548449 2215453 2215453 defendant Noon Stephen   589732 589732 Noon, Stephen, of High Easter 0
4563046 2220009 2220009 plaintiff Ram Thomas   589732 589732 Ram, Thomas, of High Easter 0
4563047 2220009 2220009 defendant Lynstede William maltster 589732 589732 Lynstede, William, of High Easter, maltster 0
4574522 2223562 2223562 defendant Swerdere John   589732 589732 Swerdere, John, of High Easter 0
4577254 2224405 2224405 defendant Bourde Walter   589732 589732 Bourde, Walter, of High Easter 0
4580407 2225356 2225356 plaintiff Davy William   589732 589732 Davy, William, of High Easter 0
4692991 2263318 2263318 defendant Maryoun Richard draper 589732 589732 Maryoun, Richard, of High Easter, draper 0
4700312 2265515 2265515 plaintiff Everard William husbandman 589732 589732 Everard, William, of High Easter, husbandman 0
4723266 2272587 2272587 defendant Horwode William yeoman 589732 589732 Horwode, William, of High Easter, yeoman 1
4732321 2275287 2275287 defendant Lenyng John husbandman 589732 589732 Lenyng, John, of High Laver, husbandman 0
4736193 2276455 2276455 defendant Maryon Richard husbandman 589732 589732 Maryon, Richard, of High Easter, husbandman 0
4758018 2282881 2282881 defendant Horwode William husbandman 589732 589732 Horwode, William, of High Easter, husbandman 4
4761887 2284062 2284062 plaintiff Eve John   589732 589732 Eve, John, of High Easter 1
4770746 2286829 2286829 plaintiff Roberd John   589732 589732 Roberd, John, of High Easter 0
4770748 2286830 2286830 plaintiff Roberd John   589732 589732 Roberd, John, of High Easter 0
4770750 2286831 2286831 plaintiff Roberd John   589732 589732 Roberd, John, of High Easter 0
4770764 2286835 2286835 plaintiff Robert John   589732 589732 Robert, John, of High Easter 0
4850531 2311628 2311628 defendant Glovere William husbandman 589732 589732 Glovere, William, of High Laver, husbandman 0
4850535 2311629 2311629 defendant Parmenter John tailor 589732 589732 Parmenter, John, of High Laver, tailor 2
4857842 2313821 2313821 defendant Honden Lawrence butcher 589732 589732 Honden, Lawrence, of High, butcher 2
4991544 2354354 2354354 defendant Athelham Geoffrey husbandman 589732 589732 Athelham, Geoffrey, of High Easter, husbandman 0
5009786 2359741 2359741 defendant Folkys John husbandman 589732 589732 Folkys, John, of High Easter, husbandman 1
5010294 2359875 2359875 defendant Chalk Thomas husbandman 589732 589732 Chalk, Thomas, of High Easter, husbandman 0
5010296 2359876 2359876 defendant Copde John gent 589732 589732 Copde, John, of High Easter, gent 0
5010300 2359878 2359878 defendant Trenchaunt William husbandman 589732 589732 Trenchaunt, William, of High Easter, husbandman 0
5239868 2427236 2427236 defendant Crushe John, junior husbandman 589732 589732 Crushe, John, junior, of High Laver, husbandman 2
5240157 2427325 2427325 defendant Croshe John, junior husbandman 589732 589732 Croshe, John, junior, of High Laver, husbandman 2
5254108 2431405 2431405 defendant Tropenell John chaplain 589732 589732 Tropenell, John, of High Onger, chaplain 0
5301053 2445270 2445270 defendant Crampe William yeoman 589732 589732 Crampe, William, of High Easter, yeoman 1
5332870 2454899 2454899 plaintiff Coppedo Joan widow 589732 589732 Coppedo, Joan, of High Ester, widow 0
5332871 2454899 2454899 plaintiff Bury Henry gent 589732 589732 Bury, Henry, of High Ester, gent 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);