names

55 rows where place_id = 594606

✎ 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
3616808 1872886 1872886 defendant Streteley Thomas gent 594606 594606 Streteley, Thomas, of Whitfeld, gent 0
3645046 1908859 1908859 defendant Streteley Thomas gent 594606 594606 Streteley, Thomas, of Whitfeld, gent 0
3645047 1908859 1908859 defendant Streteley Edmund gent 594606 594606 Streteley, Edmund, of Whitfeld, gent 1
3645051 1908861 1908861 defendant Streitley John (legal representative) 594606 594606 Streitley, John, of Whitfeld, gent, executrix of 0
3645056 1908863 1908863 defendant Streteley Edmund gent 594606 594606 Streteley, Edmund, of Whitfeld, gent 0
3645057 1908863 1908863 defendant Streteley Thomas gent 594606 594606 Streteley, Thomas, of Whitfeld, gent 1
3647490 1909605 1909605 defendant Stretley Johm gent 594606 594606 Stretley, Johm, of Whitfeld, gent 0
3671362 1917019 1917019 defendant Osborne Thomas gent 594606 594606 Osborne, Thomas, of Whitfeld, gent 0
3675716 1918438 1918438 defendant Jacob John husbandman 594606 594606 Jacob, John, of Whitfeld, husbandman 0
3676056 1918546 1918546 defendant Osburne Thomas gent 594606 594606 Osburne, Thomas, of Whitfeld, gent 0
3683571 1920994 1920994 defendant Osborne Thomas gent 594606 594606 Osborne, Thomas, of Whitfeld, gent 0
3686604 1921963 1921963 defendant Streteley Edmund gent 594606 594606 Streteley, Edmund, of Whitfeld, gent 0
3691125 1923386 1923386 defendant Stretley Edmund gent 594606 594606 Stretley, Edmund, of Whitfeld, gent 0
3701565 1926738 1926738 defendant Streteley Edmund gent 594606 594606 Streteley, Edmund, of Whitfeld, gent 0
3705884 1928124 1928124 defendant Streteley Edmund gent 594606 594606 Streteley, Edmund, of Whitfeld, gent 0
3770950 1948599 1948599 defendant Osborn Thomas gent 594606 594606 Osborn, Thomas, of Whitfeld, gent 0
3783933 1952750 1952750 defendant Stretely Edmund gent 594606 594606 Stretely, Edmund, of Whitfeld, gent 0
3794656 1956205 1956205 plaintiff Claydon Richard   594606 594606 Claydon, Richard, of Whitfeld 0
3798974 1957591 1957591 plaintiff House Margery widow 594606 594606 House, Margery, of Whitfeld, widow 0
3806740 1960007 1960007 defendant Osburne Thomas gent 594606 594606 Osburne, Thomas, of Whitfeld, gent 0
3806741 1960007 1960007 defendant Bery Henry gent 594606 594606 Bery, Henry, of Whitfeld, gent 1
3814449 1962433 1962433 defendant Jacobbe John husbandman 594606 594606 Jacobbe, John, of Whitfeld, husbandman 0
3819281 1963920 1963920 defendant Style John laborer 594606 594606 Style, John, of Whitfeld, laborer 3
3899026 1989880 1989880 defendant Beche Ralph laborer 594606 594606 Beche, Ralph, of Whitfeld, laborer 0
3899991 1990216 1990216 defendant Holt Thomas husbandman 594606 594606 Holt, Thomas, of Whitfeld, husbandman 0
3911180 1994067 1994067 defendant Osseburne Thomas gent 594606 594606 Osseburne, Thomas, of Whitfeld, gent 0
3927674 1999592 1999592 defendant Stretley Edmund gent 594606 594606 Stretley, Edmund, of Whitfeld, gent 0
3937559 2002896 2002896 plaintiff Osburne Thomas gent 594606 594606 Osburne, Thomas, of Whitfeld, gent 0
4447773 2184232 2184232 defendant Laurence Thomas   594606 594606 Laurence, Thomas, of Whitfeld 0
4466402 2190158 2190158 defendant Colyer John, senior   594606 594606 Colyer, John, senior, of Whitfeld 0
4607281 2233389 2233389 plaintiff Belawe Henry   594606 594606 Belawe, Henry, of Whitfeld 0
4814868 2300760 2300760 defendant Bargh John gent 594606 594606 Bargh, John, of Whitfeld, gent 1
4825907 2304136 2304136 defendant Stotusbury John gent 594606 594606 Stotusbury, John, of Whitfeld, gent 0
4848093 2310871 2310871 defendant Stotesbury John gent 594606 594606 Stotesbury, John, of Whitfeld, gent 1
4851853 2312014 2312014 defendant Stotusbury John gent 594606 594606 Stotusbury, John, of Whitfeld, gent 0
4862547 2315271 2315271 defendant de Boure Robert yeoman 594606 594606 de Boure, Robert, of Whitfeld, yeoman 1
4884558 2322077 2322077 defendant Stotusbury John gent 594606 594606 Stotusbury, John, of Whitfeld, gent 0
4899977 2326632 2326632 defendant Flynt William husbandman 594606 594606 Flynt, William, of Whitfeld, husbandman 1
4967033 2347075 2347075 defendant Basset Nicholas husbandman 594606 594606 Basset, Nicholas, of Whitfeld, husbandman 0
5011404 2360198 2360198 defendant Slye William husbandman 594606 594606 Slye, William, of Whitfeld, husbandman 3
5016456 2361707 2361707 defendant Streteley John gent 594606 594606 Streteley, John, of Whitfeld, gent 0
5028073 2365088 2365088 defendant Stotesbury John gent 594606 594606 Stotesbury, John, of Whitfeld, gent 0
5044649 2370030 2370030 defendant Hepe William husbandman 594606 594606 Hepe, William, of Whitfeld, husbandman 1
5134861 2396698 2396698 defendant Wodeward Thomas yeoman 594606 594606 Wodeward, Thomas, of Whitfeld, yeoman 0
5190464 2412955 2412955 defendant Wodeward Thomas yeoman 594606 594606 Wodeward, Thomas, of Whitfeld, yeoman 0
5206939 2417765 2417765 defendant Wodeward Thomas yeoman 594606 594606 Wodeward, Thomas, of Whitfeld, yeoman 0
5335197 2455592 2455592 defendant Philip Thomas tucker 594606 594606 Philip, Thomas, of Whitfeld, tucker 1
5365524 2464891 2464891 defendant Body Robert husbandman 594606 594606 Body, Robert, of Whitfeld, husbandman 1
5365527 2464891 2464891 defendant Pytman Henry husbandman 594606 594606 Pytman, Henry, of Whitfeld, husbandman 4
5372786 2467090 2467090 defendant Conyers Henry clerk 594606 594606 Conyers, Henry, of Whitfeld, clerk 0
5390669 2472394 2472394 defendant Stretley John gent 594606 594606 Stretley, John, of Whitfeld, gent 1
5396720 2474156 2474156 defendant Cokys R---- husbandman 594606 594606 Cokys, R----, of Whitfeld, husbandman 1
5522880 2511984 2511984 defendant Streteley Thomas gent 594606 594606 Streteley, Thomas, of Whitfeld, gent 0
5582213 2529509 2529509 defendant Streteley John gent 594606 594606 Streteley, John, of Whitfeld, gent 0
5613066 2547865 2547865 defendant Inworth Thomas   594606 594606 Inworth, Thomas, of Whitfeld 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);