names

144 rows where place_id = 589972

✎ 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
3594929 1866042 1866042 plaintiff Lolsmyth Robert (legal representative) 589972 589972 Lolsmyth, Robert, of Borden, executors of 0
3599424 1867459 1867459 defendant Chapman William yeoman 589972 589972 Chapman, William, of Borden, yeoman 1
3606516 1869710 1869710 defendant Partrich Thomas husbandman 589972 589972 Partrich, Thomas, of Borden, husbandman 0
3624328 1875142 1875142 defendant Godewatte John husbandman 589972 589972 Godewatte, John, of Borden, husbandman 4
3628822 1903888 1903888 defendant Lee Thomas laborer 589972 589972 Lee, Thomas, of Borden, laborer 0
3634217 1905501 1905501 defendant Smyth John wheeler 589972 589972 Smyth, John, of Borden, wheeler 3
3642126 1907986 1907986 defendant Chapman Thomas gent 589972 589972 Chapman, Thomas, of Borden, gent 0
3658804 1913011 1913011 defendant Wyng Robert tailor 589972 589972 Wyng, Robert, of Borden, tailor 0
3679672 1919708 1919708 defendant Grangeman William husbandman 589972 589972 Grangeman, William, of Borden, husbandman 0
3685146 1921503 1921503 defendant Edwardys William husbandman 589972 589972 Edwardys, William, of Borden, husbandman 1
3688985 1922713 1922713 defendant Smyth John   589972 589972 Smyth, John, of Borden, wheelwright 5
3690975 1923340 1923340 defendant A Pett William husbandman 589972 589972 A Pett, William, of Borden, husbandman 1
3706356 1928277 1928277 defendant Partriche Thomas yeoman 589972 589972 Partriche, Thomas, of Borden, yeoman 0
3718961 1932211 1932211 defendant Lokesmyth Thomas husbandman 589972 589972 Lokesmyth, Thomas, of Borden, husbandman 0
3720467 1932684 1932684 defendant Partryche Thomas yeoman 589972 589972 Partryche, Thomas, of Borden, yeoman 0
3722104 1933176 1933176 defendant Petynden Thomas husbandman 589972 589972 Petynden, Thomas, of Borden, husbandman 2
3722108 1933176 1933176 defendant Tomleyn John husbandman 589972 589972 Tomleyn, John, of Borden, husbandman 6
3728829 1935263 1935263 defendant Grangeman William husbandman 589972 589972 Grangeman, William, of Borden, husbandman 0
3737002 1937819 1937819 defendant Graungeman William husbandman 589972 589972 Graungeman, William, of Borden, husbandman 0
3738767 1938334 1938334 defendant Pett William husbandman 589972 589972 Pett, William, of Borden, husbandman 0
3751353 1942342 1942342 defendant Pett William husbandman 589972 589972 Pett, William, of Borden, husbandman 0
3766683 1947241 1947241 defendant Strangbowe William husbandman 589972 589972 Strangbowe, William, of Borden, husbandman 0
3766688 1947242 1947242 defendant Strangbowe William husbandman 589972 589972 Strangbowe, William, of Borden, husbandman 0
3767621 1947512 1947512 defendant Pete William husbandman 589972 589972 Pete, William, of Borden, husbandman 0
3771354 1948732 1948732 defendant Graungeman John (legal representative) 589972 589972 Graungeman, John, of Borden, executor of 0
3771355 1948732 1948732 defendant Graungeman William husbandman 589972 589972 Graungeman, William, of Borden, husbandman 1
3772902 1949223 1949223 defendant Wyng Robert husbandman 589972 589972 Wyng, Robert, of Borden, husbandman 0
3777210 1950622 1950622 defendant Wynge Robert tailor 589972 589972 Wynge, Robert, of Borden, tailor 3
3784015 1952779 1952779 defendant Grangeman William husbandman 589972 589972 Grangeman, William, of Borden, husbandman 0
3796441 1956758 1956758 defendant Lokesmyth Thomas husbandman 589972 589972 Lokesmyth, Thomas, of Borden, husbandman 0
3796442 1956758 1956758 defendant Graungeman William husbandman 589972 589972 Graungeman, William, of Borden, husbandman 1
3802101 1958553 1958553 defendant Terrenden Reginald carpenter 589972 589972 Terrenden, Reginald, of Borden, carpenter 0
3802102 1958553 1958553 defendant Hennacre Walter husbandman 589972 589972 Hennacre, Walter, of Borden, husbandman 1
3802103 1958553 1958553 defendant Kennet Thomas husbandman 589972 589972 Kennet, Thomas, of Borden, husbandman 2
3814243 1962361 1962361 defendant Bekett John husbandman 589972 589972 Bekett, John, of Borden, husbandman 4
3822925 1965076 1965076 defendant Swyfte John shoemaker 589972 589972 Swyfte, John,of Borden, shoemaker 0
3840710 1970660 1970660 defendant Glasier John husbandman 589972 589972 Glasier, John, of Borden, husbandman 0
3842381 1971150 1971150 defendant Petenden John husbandman 589972 589972 Petenden, John, of Borden, husbandman 1
3849950 1973571 1973571 defendant Pett Richard husbandman 589972 589972 Pett, Richard, of Borden, husbandman 3
3857461 1975968 1975968 defendant Glasier John husbandman 589972 589972 Glasier, John, of Borden, husbandman 0
3863895 1978098 1978098 defendant Patynden John husbandman 589972 589972 Patynden, John, of Borden, husbandman 0
3878947 1983210 1983210 defendant Bans John husbandman 589972 589972 Bans, John, of Borden, husbandman 2
3882173 1984295 1984295 defendant Butt William husbandman 589972 589972 Butt, William, of Borden, husbandman 1
3890390 1987039 1987039 defendant Bernard John husbandman 589972 589972 Bernard, John, of Borden, husbandman 1
3909130 1993351 1993351 defendant Bekett John laborer 589972 589972 Bekett, John, of Borden, laborer 3
3988131 2020500 2020500 defendant Butt William yeoman 589972 589972 Butt, William, of Borden, yeoman 0
4012877 2029332 2029332 plaintiff Reder William gent 589972 589972 Reder, William, of Borden, gent 0
4012879 2029333 2029333 plaintiff Reder William gent 589972 589972 Reder, William, of Borden, gent 0
4012881 2029334 2029334 plaintiff Reder William gent 589972 589972 Reder, William, of Borden, gent 0
4024743 2033532 2033532 defendant Pett John   589972 589972 Pett, John, of Borden, mason 0
4044429 2040462 2040462 plaintiff Reader or Reyther William gent 589972 589972 Reader or Reyther, William, of Borden, or of Newyngton, Surrey, gent 0
4126617 2069805 2069805 defendant Nethersole George gent 589972 589972 Nethersole, George, of Borden, gent 2
4163369 2082714 2082714 defendant Richardson John butcher 589972 589972 Richardson, John, of Borden, butcher 0
4166139 2083663 2083663 defendant Coche Anne tailor 589972 589972 Coche, Anne, of Borden, tailor 2
4202619 2096459 2096459 defendant Fynche Christopher gent 589972 589972 Fynche, Christopher, of Borden, gent 0
4222387 2103321 2103321 defendant Pett Henry   589972 589972 Pett, Henry, of Borden, yeoman, ploughwright 0
4223552 2103728 2103728 defendant Cranmer Christopher yeoman 589972 589972 Cranmer, Christopher, of Borden, yeoman 1
4223667 2103763 2103763 defendant Harrys Thomas yeoman 589972 589972 Harrys, Thomas, of Borden, yeoman 1
4226159 2104621 2104621 defendant Pett Thomas husbandman 589972 589972 Pett, Thomas, of Borden, husbandman 1
4275716 2121453 2121453 defendant Tomlyn Walter merchant 589972 589972 Tomlyn, Walter, of Borden, or of Sandwich, merchant 0
4283501 2124133 2124133 defendant Tomlyn Walter merchant 589972 589972 Tomlyn, Walter, of Borden, merchant 0
4299889 2130051 2130051 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4300102 2130133 2130133 defendant Fynche Christopher gent 589972 589972 Fynche, Christopher, of Borden, gent 2
4308478 2133119 2133119 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4309354 2133430 2133430 defendant Tomlyn Walter merchant 589972 589972 Tomlyn, Walter, of Borden, merchant 0
4309355 2133430 2133430 defendant Pettenden Robert yeoman 589972 589972 Pettenden, Robert, of Borden, yeoman 1
4312168 2134395 2134395 defendant Harris Thomas yeoman 589972 589972 Harris, Thomas, of Borden, yeoman 0
4314031 2135017 2135017 defendant Homan Ralph   589972 589972 Homan, Ralph, of Borden, husbandman, administrsatrix of 0
4314032 2135017 2135017 defendant Homan Denise widow 589972 589972 Homan, Denise, of Borden, widow 1
4314138 2135050 2135050 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4317065 2136082 2136082 defendant Tomlyn Walter merchant 589972 589972 Tomlyn, Walter, of Borden, or of Sandwich, merchant 0
4323241 2138188 2138188 defendant Tomlyn Walter merchant 589972 589972 Tomlyn, Walter, of Borden, merchant 0
4346267 2145950 2145950 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4370038 2154341 2154341 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4370040 2154341 2154341 defendant Pett Andrew husbandman 589972 589972 Pett, Andrew, of Borden, husbandman 2
4379512 2157757 2157757 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4379964 2157936 2157936 defendant Tomlyn Walter yeoman 589972 589972 Tomlyn, Walter, of Borden, yeoman 0
4389790 2161209 2161209 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4389791 2161209 2161209 defendant Pett Andrew yeoman 589972 589972 Pett, Andrew, of Borden, yeoman 1
4393307 2162364 2162364 defendant Pett Thomas yeoman 589972 589972 Pett, Thomas, of Borden, yeoman 0
4393308 2162364 2162364 defendant Tomlyn Walter yeoman 589972 589972 Tomlyn, Walter, of Borden, yeoman 1
4449741 2184870 2184870 defendant Poser Richard   589972 589972 Poser, Richard, of Borden 0
4552429 2216713 2216713 defendant Roger John   589972 589972 Roger, John, of Borden 2
4554209 2217242 2217242 defendant Mekote Thomas chaplain & priest of Richard Mekote 589972 589972 Mekote, Thomas, of Borden, chaplain & priest of Richard Mekote 0
4556253 2217896 2217896 defendant Graungeman William   589972 589972 Graungeman, William, of Borden 0
4566190 2220987 2220987 defendant Wymond Thomas   589972 589972 Wymond, Thomas, of Borden 1
4587890 2227613 2227613 defendant Bryggeham Thomas   589972 589972 Bryggeham, Thomas, of Borden 0
4599865 2231187 2231187 plaintiff Taillour William   589972 589972 Taillour, William, of Borden 0
4686667 2261441 2261441 defendant Godwot thoasm yeoman 589972 589972 Godwot, thoasm, of Borden, yeoman 1
4708051 2267893 2267893 defendant atte Pette Edmund husbandman 589972 589972 atte Pette, Edmund, of Borden, husbandman 0
4708052 2267893 2267893 defendant atte Pette John husbandman 589972 589972 atte Pette, John, of Borden, husbandman 1
4719429 2271421 2271421 defendant Shelyngheld John husbandman 589972 589972 Shelyngheld, John, of Borden, husbandman 3
4725932 2273398 2273398 defendant Shelyngheld John laborer 589972 589972 Shelyngheld, John, of Borden, laborer 0
4726118 2273457 2273457 defendant Hare Stephen husbandman 589972 589972 Hare, Stephen, of Borden, husbandman 0
4730854 2274849 2274849 defendant Gate Nicholas   589972 589972 Gate, Nicholas, of Borden, rope maker 0
4737847 2276941 2276941 defendant Grangeman Alice   589972 589972 (Grangeman, Alice, of Borden, widow, formerly wife of William 1
4830142 2305468 2305468 defendant Heydon Peter farmer 589972 589972 Heydon, Peter, of Borden, farmer 0
4830651 2305609 2305609 defendant Heydon Peter husbandman 589972 589972 Heydon, Peter, of Borden, husbandman 0
4846495 2310413 2310413 defendant Haydon Peter husbandman 589972 589972 Haydon, Peter, of Borden, husbandman 0
4847272 2310648 2310648 defendant Heydon Peter husbandman 589972 589972 Heydon, Peter, of Borden, husbandman 0

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