names

72 rows where place_id = 592715

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608617 1870357 1870357 defendant Round Roger husbandman 592715 592715 Round, Roger, of Bexley, husbandman 0
3612751 1871638 1871638 defendant Round Roger husbandman 592715 592715 Round, Roger, of Bexley, husbandman 0
3617459 1873081 1873081 defendant Stodard John yeoman 592715 592715 Stodard, John, of Bexley, yeoman 0
3633351 1905244 1905244 defendant Skelton James husbandman 592715 592715 Skelton, James, of Bexley, husbandman 4
3637662 1906593 1906593 defendant Strette John husbandman 592715 592715 Strette, John, of Bexley, husbandman 0
3642993 1908257 1908257 defendant Dunmowe Roger husbandman 592715 592715 Dunmowe, Roger, of Bexley, husbandman 2
3684361 1921240 1921240 defendant Stelton James husbandman 592715 592715 Stelton, James, of Bexley, husbandman 2
3686289 1921866 1921866 defendant Smythe Mathew yeoman 592715 592715 Smythe, Mathew, of Bexley, yeoman 1
3693381 1924145 1924145 defendant Bulland John husbandman 592715 592715 Bulland, John, of Bexley, husbandman 0
3707612 1928679 1928679 defendant Hyllys John husbandman 592715 592715 Hyllys, John, of Bexley, husbandman 1
3709062 1929134 1929134 defendant Hamshire Alice widow 592715 592715 Hamshire, Alice, of Bexley, widow 0
3724173 1933846 1933846 defendant Panter alias Wever Robert husbandman 592715 592715 Panter alias Wever, Robert, of Bexley, husbandman 0
3734177 1936929 1936929 defendant Bek Robert carpenter 592715 592715 Bek, Robert, of Bexley, carpenter 4
3737919 1938078 1938078 defendant Pate Alan husbandman 592715 592715 Pate, Alan, of Bexley, husbandman 4
3750655 1942127 1942127 defendant Payne Henry husbandman 592715 592715 Payne, Henry, of Bexley, husbandman 1
3754179 1943255 1943255 defendant Sedcop Thomas husbandman 592715 592715 Sedcop, Thomas, of Bexley, husbandman 0
3765503 1946876 1946876 defendant Calard Philip carpenter 592715 592715 Calard, Philip, of Bexley, carpenter 0
3765505 1946876 1946876 defendant Goldwyn John laborer 592715 592715 Goldwyn, John, of Bexley, laborer 2
3765507 1946876 1946876 defendant Stable Richard husbandman 592715 592715 Stable, Richard, of Bexley, husbandman 4
3769232 1948031 1948031 defendant Rawlyns Richard gent 592715 592715 Rawlyns, Richard, of Bexley, gent 0
3778860 1951103 1951103 defendant Frech Henry bricklayer 592715 592715 Frech, Henry, of Bexley, bricklayer 0
3781245 1951874 1951874 defendant Hyllys John yeoman 592715 592715 Hyllys, John, of Bexley, yeoman 0
3818316 1963635 1963635 defendant Kyttyll William husbandman 592715 592715 Kyttyll, William, of Bexley, husbandman 4
3818320 1963636 1963636 defendant Graunt William husbandman 592715 592715 Graunt, William, of Bexley, husbandman 1
3858718 1976397 1976397 defendant Munke William husbandman 592715 592715 Munke, William, of Bexley, husbandman 0
3860635 1977049 1977049 defendant Pate Alan husbandman 592715 592715 Pate, Alan, of Bexley, husbandman 0
3997481 2023845 2023845 defendant Lane Henry yeoman 592715 592715 Lane, Henry, of Bexley, yeoman 0
4005259 2026662 2026662 defendant Setcoppe Thomas yeoman 592715 592715 Setcoppe, Thomas, of Bexley, yeoman 0
4005266 2026665 2026665 defendant Setcoppe Thomas yeoman 592715 592715 Setcoppe, Thomas, of Bexley, yeoman 0
4050081 2042456 2042456 defendant Frywen Richard yeoman 592715 592715 Frywen, Richard, of Bexley, yeoman 0
4050084 2042457 2042457 defendant Holland Mathew carpenter 592715 592715 Holland, Mathew, of Bexley, carpenter 1
4074212 2051076 2051076 defendant Harman William carpenter 592715 592715 Harman, William, of Bexley, or of Rolvenden, Kent, carpenter 0
4080319 2053271 2053271 defendant Crewcher Thomas husbandman 592715 592715 Crewcher, Thomas, of Bexley, husbandman 0
4080320 2053271 2053271 defendant Haynes William husbandman 592715 592715 Haynes, William, of Bexley, husbandman 1
4106416 2062587 2062587 defendant Marshall John yeoman 592715 592715 Marshall, John, of Bexley, yeoman 1
4170792 2085274 2085274 defendant Chapman Thomas yeoman 592715 592715 Chapman, Thomas, of Bexley, yeoman 3
4177545 2087622 2087622 defendant Weker Thomas husbandman 592715 592715 Weker, Thomas, of Bexley, husbandman 2
4181034 2088841 2088841 defendant Beale Robert yeoman 592715 592715 Beale, Robert, of Bexley, yeoman 3
4217006 2101444 2101444 defendant Funnell Thomas yeoman 592715 592715 Funnell, Thomas, of Bexley, yeoman 0
4229082 2105655 2105655 defendant Andrewe William husbandman 592715 592715 Andrewe, William, of Bexley, husbandman 0
4237655 2108763 2108763 defendant Wyne Mathew miller 592715 592715 Wyne, Mathew, of Bexley, miller 0
4317213 2136132 2136132 defendant Strete Thomas yeoman 592715 592715 Strete, Thomas, of Bexley, yeoman 0
4317214 2136132 2136132 defendant Wybarne Alan yeoman 592715 592715 Wybarne, Alan, of Bexley, yeoman 1
4320120 2137141 2137141 defendant Huckerby Anne widow 592715 592715 Huckerby, Anne, of Bexley, widow 0
4320122 2137141 2137141 defendant Johnson Henry husbandman 592715 592715 Johnson, Henry, of Bexley, husbandman 2
4323626 2138317 2138317 defendant Denman German clerk 592715 592715 Denman, German, of Bexley, clerk 2
4329393 2140141 2140141 defendant Kemsley Thomas   592715 592715 Kemsley, Thomas, of Bexley 2
4330132 2140378 2140378 defendant Strete Thomas yeoman 592715 592715 Strete, Thomas, of Bexley, yeoman 0
4330133 2140378 2140378 defendant Wybarne Alan yeoman 592715 592715 Wybarne, Alan, of Bexley, yeoman 1
4379554 2157776 2157776 defendant Lomas Samuel husbandman 592715 592715 Lomas, Samuel, of Bexley, husbandman 0
4381995 2158664 2158664 defendant Waynwright Francis husbandman 592715 592715 Waynwright, Francis, of Bexley, husbandman 0
5179108 2409624 2409624 defendant Morle John clerk 592715 592715 Morle, John, of Bexley, clerk 0
5179109 2409624 2409624 defendant Dowener Walter laborer 592715 592715 Dowener, Walter, of Bexley, laborer 1
5201753 2416280 2416280 defendant Morle John clerk 592715 592715 Morle, John, of Bexley, clerk 0
5201754 2416280 2416280 defendant Downer Walter laborer 592715 592715 Downer, Walter, of Bexley, laborer 1
5201755 2416280 2416280 defendant Hycokke William husbandman 592715 592715 Hycokke, William, of Bexley, husbandman 2
5289493 2441927 2441927 defendant Stonhill John husbandman 592715 592715 Stonhill, John, of Bexley, husbandman 0
5289494 2441927 2441927 defendant atte Hoo John husbandman 592715 592715 atte Hoo, John, of Bexley, husbandman 1
5360527 2463322 2463322 defendant Okynden Thomas husbandman 592715 592715 Okynden, Thomas, of Bexley, husbandman 0
5438490 2486447 2486447 defendant Dowesyng John baker 592715 592715 Dowesyng, John, of Bexley, baker 1
5507619 2507281 2507281 defendant Berd Thomas husbandman 592715 592715 Berd, Thomas, of Bexley, husbandman 0
5527788 2513263 2513263 defendant Rounde Roger husbandman 592715 592715 Rounde, Roger, of Bexley, husbandman 2
5527790 2513263 2513263 defendant Bocher John butcher 592715 592715 Bocher, John, of Bexley, butcher 4
5533064 2514883 2514883 defendant Berd Thomas husbandman 592715 592715 Berd, Thomas, of Bexley, husbandman 0
5538678 2516578 2516578 defendant Goldwyn John husbandman 592715 592715 Goldwyn, John, of Bexley, husbandman 3
5561592 2523376 2523376 defendant Breten Robert husbandman 592715 592715 Breten, Robert, of Bexley, husbandman 3
5561593 2523376 2523376 defendant Blythe John (legal representative) 592715 592715 Blythe, John, of Bexley, yeoman, executors of 4
5588522 2531416 2531416 defendant Bolton Thomas yeoman 592715 592715 Bolton, Thomas, of Bexley, yeoman 0
5588523 2531416 2531416 defendant Englyssh William yeoman 592715 592715 Englyssh, William, of Bexley, yeoman 1
5588524 2531416 2531416 defendant Kendall William yeoman 592715 592715 Kendall, William, of Bexley, yeoman 2
5597287 2534063 2534063 defendant Maryner Thomas husbandman 592715 592715 Maryner, Thomas, of Bexley, husbandman 0
5599374 2534689 2534689 defendant Bolton Thomas yeoman 592715 592715 Bolton, Thomas, of Bexley, yeoman 2

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