names

203 rows where place_id = 586724

✎ 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
3589464 1864342 1864342 defendant Asseby William husbandman 586724 586724 Asseby, William, of Waltham, husbandman 5
3610044 1870811 1870811 defendant Lupton Nicholas yeoman 586724 586724 Lupton, Nicholas, of Waltham, yeoman 9
3610045 1870811 1870811 defendant Whywall Thomas husbandman 586724 586724 Whywall, Thomas, of Waltham, husbandman 10
3610046 1870811 1870811 defendant Forman Robert husbandman 586724 586724 Forman, Robert, of Waltham, husbandman 11
3610047 1870811 1870811 defendant Smyth William smith 586724 586724 Smyth, William, of Waltham, smith 12
3610048 1870811 1870811 defendant Truke Thomas husbandman 586724 586724 Truke, Thomas, of Waltham, husbandman 13
3610049 1870811 1870811 defendant Frances Thomas husbandman 586724 586724 Frances, Thomas, of Waltham, husbandman 14
3610050 1870811 1870811 defendant Numus John husbandman 586724 586724 Numus, John, of Waltham, husbandman 15
3610051 1870811 1870811 defendant Hykson Thomas husbandman 586724 586724 Hykson, Thomas, of Waltham, husbandman 16
3610052 1870811 1870811 defendant Randoll William husbandman 586724 586724 Randoll, William, of Waltham, husbandman 17
3628381 1903743 1903743 plaintiff Carpenter Thomas   586724 586724 Carpenter, Thomas, of Waltham 0
3629306 1904025 1904025 defendant Colnet Lawrence capper or carpenter 586724 586724 Colnet, Lawrence, of Waltham, capper or carpenter 0
3638495 1906856 1906856 defendant Prowde William, senior yeoman 586724 586724 Prowde, William, senior, of Waltham, yeoman 0
3638500 1906857 1906857 defendant Prowde William, senior yeoman 586724 586724 Prowde, William, senior, of Waltham, yeoman 0
3684915 1921415 1921415 defendant Prowde William husbandman 586724 586724 Prowde, William, of Waltham, husbandman 0
3689785 1922961 1922961 defendant Prowde William, junior husbandman 586724 586724 Prowde, William, junior, of Waltham, husbandman 1
3689786 1922961 1922961 defendant A Court Thomas husbandman 586724 586724 A Court, Thomas, of Waltham, husbandman 2
3689787 1922961 1922961 defendant Swayn John husbandman 586724 586724 Swayn, John, of Waltham, husbandman 3
3695325 1924762 1924762 defendant Stopell John husbandman 586724 586724 Stopell, John, of Waltham, husbandman 3
3697625 1925481 1925481 defendant Stopell John husbandman 586724 586724 Stopell, John, of Waltham, husbandman 0
3702462 1927031 1927031 defendant Aleyn Richard husbandman 586724 586724 Aleyn, Richard, of Waltham, husbandman 0
3710773 1929687 1929687 defendant Newe Thomas shingler 586724 586724 Newe, Thomas, of Waltham, shingler 2
3719563 1932383 1932383 defendant Pybusshe Christopher smith 586724 586724 Pybusshe, Christopher, of Waltham, smith 2
3725368 1934226 1934226 defendant Newe Thomas shingler 586724 586724 Newe, Thomas, of Waltham, shingler 2
3725369 1934226 1934226 defendant Stapyll Richard husbandman 586724 586724 Stapyll, Richard, of Waltham, husbandman 3
3840564 1970611 1970611 plaintiff Archer John, senior   586724 586724 Archer, John, senior, of Waltham 0
3840565 1970611 1970611 plaintiff Archer John, junior   586724 586724 Archer, John, junior, of Waltham 1
3855585 1975390 1975390 defendant Wastell John husbandman 586724 586724 Wastell, John, of Waltham, husbandman 0
3858860 1976450 1976450 defendant Bennet Edward husbandman 586724 586724 Bennet, Edward, of Waltham, husbandman 6
3878222 1982964 1982964 defendant Fryssent William husbandman 586724 586724 Fryssent, William, of Waltham, husbandman 1
3879814 1983505 1983505 defendant Skerne Edmund gent 586724 586724 Skerne, Edmund, of Waltham, gent 0
3888018 1986244 1986244 defendant Holton William husbandman 586724 586724 Holton, William, of Waltham, husbandman 0
3902938 1991212 1991212 defendant Chylde John yeoman 586724 586724 Chylde, John, of Waltham, yeoman 0
3902939 1991212 1991212 defendant Clarke alias Warbek Richard yeoman 586724 586724 Clarke alias Warbek, Richard, of Waltham, yeoman 1
3902940 1991212 1991212 defendant Sawyer John yeoman 586724 586724 Sawyer, John, of Waltham, yeoman 2
3922345 1997789 1997789 plaintiff Robson William smith 586724 586724 Robson, William, of Waltham, smith 0
3922346 1997789 1997789 defendant Bynge John tailor 586724 586724 Bynge, John, of Waltham, tailor 0
3922347 1997789 1997789 defendant Bynge William husbandman 586724 586724 Bynge, William, of Waltham, husbandman 1
3953454 2008279 2008279 defendant Rigbye John gent 586724 586724 Rigbye, John, of Waltham, gent 0
3982952 2018682 2018682 plaintiff Skerne Thomas gent 586724 586724 Skerne, Thomas, of Waltham, gent 0
4001454 2025299 2025299 plaintiff Hansert John gent 586724 586724 Hansert, John, of Waltham, gent 0
4014920 2030051 2030051 plaintiff Skerne Thomas gent 586724 586724 Skerne, Thomas, of Waltham, gent 0
4058064 2045266 2045266 plaintiff Carpenter Thomas (legal representative) 586724 586724 Carpenter, Thomas, of Waltham, executrix of 0
4090724 2056971 2056971 defendant Whyte John husbandman 586724 586724 Whyte, John, of Waltham, husbandman 0
4090725 2056971 2056971 defendant Whyte Stephen husbandman 586724 586724 Whyte, Stephen, of Waltham, husbandman 1
4103194 2061426 2061426 defendant Whittington William yeoman 586724 586724 Whittington, William, of Waltham, yeoman 1
4103195 2061426 2061426 defendant Harryson John yeoman 586724 586724 Harryson, John, of Waltham, yeoman 2
4149772 2078045 2078045 defendant Harrison John laborer 586724 586724 Harrison, John, of Waltham, laborer 0
4153614 2079358 2079358 defendant Grene John husbandman 586724 586724 Grene, John, of Waltham, husbandman 0
4153615 2079358 2079358 defendant Walkington Francis yeoman 586724 586724 Walkington, Francis, of Waltham, yeoman 1
4232677 2106935 2106935 defendant Elvishe Thomas yeoman 586724 586724 Elvishe, Thomas, of Waltham, yeoman 0
4237458 2108692 2108692 defendant Peerson Robert yeoman 586724 586724 Peerson, Robert, of Waltham, yeoman 0
4276739 2121799 2121799 defendant Gilby Tristram gent 586724 586724 Gilby, Tristram, of Waltham, gent 1
4276740 2121799 2121799 defendant Stones William husbandman 586724 586724 Stones, William, of Waltham, husbandman 2
4297573 2129234 2129234 defendant Greene Thomas yeoman 586724 586724 Greene, Thomas, of Waltham, yeoman 3
4299014 2129742 2129742 defendant Elvishe Thomas husbandman 586724 586724 Elvishe, Thomas, of Waltham, husbandman 0
4310795 2133919 2133919 defendant Grene Robert yeoman 586724 586724 Grene, Robert, of Waltham, yeoman 0
4317608 2136272 2136272 defendant Lewes Robert yeoman 586724 586724 Lewes, Robert, of Waltham, yeoman 0
4318901 2136723 2136723 defendant Grene Robert yeoman 586724 586724 Grene, Robert, of Waltham, yeoman 0
4320461 2137253 2137253 defendant Whyte George yeoman 586724 586724 Whyte, George, of Waltham, yeoman 1
4337101 2142700 2142700 defendant Garrett William laborer 586724 586724 Garrett, William, of Waltham, laborer 1
4337102 2142700 2142700 defendant Drewrye John yeoman 586724 586724 Drewrye, John, of Waltham, yeoman 2
4364167 2152240 2152240 defendant Hawkyns William clerk 586724 586724 Hawkyns, William, of Waltham, clerk 0
4364168 2152240 2152240 defendant Lewes Robert gent 586724 586724 Lewes, Robert, of Waltham, gent 1
4364202 2152253 2152253 defendant White Robert yeoman 586724 586724 together with White, Robert, of Waltham, yeoman 1
4368243 2153692 2153692 defendant Browninge Richard   586724 586724 Browninge, Richard, of Waltham, "trendlemaker" 0
4368244 2153692 2153692 defendant Hamon John laborer 586724 586724 Hamon, John, of Waltham, laborer 1
4368245 2153692 2153692 defendant West Thomas tailor 586724 586724 West, Thomas, of Waltham, tailor 2
4371168 2154746 2154746 defendant Gilbie Tristram gent 586724 586724 Gilbie, Tristram, of Waltham, gent 2
4378667 2157440 2157440 defendant White George yeoman 586724 586724 White, George, of Waltham, yeoman 0
4441259 2182199 2182199 plaintiff Boltby William de   586724 586724 Boltby, William de, of Waltham, parson 0
4442684 2182661 2182661 plaintiff Burthelegh Thomas   586724 586724 Burthelegh, Thomas, of Waltham 0
4488795 2197216 2197216 defendant atte Courte William   586724 586724 atte Courte, William, of Waltham 1
4488803 2197217 2197217 defendant Andrewe William   586724 586724 Andrewe, William, of Waltham 5
4496674 2199626 2199626 defendant atte Hall alias Bayly William   586724 586724 atte Hall alias Bayly, William, of Waltham 0
4496676 2199627 2199627 defendant Taillour William   586724 586724 Taillour, William, of Waltham 0
4506290 2202468 2202468 plaintiff Tanner Agnes   586724 586724 Tanner, Agnes, of Waltham, on her own account 0
4507093 2202687 2202687 plaintiff Vysant William   586724 586724 Vysant, William, of Waltham 0
4514491 2204952 2204952 defendant Synyere William   586724 586724 Synyere, William, of Waltham 2
4518073 2206026 2206026 defendant Roger John   586724 586724 Roger, John, of Waltham 3
4526475 2208561 2208561 defendant Baker William   586724 586724 Baker, William, of Waltham 0
4535059 2211242 2211242 defendant Skynner John   586724 586724 Skynner, John, of Waltham 0
4541121 2213129 2213129 defendant Bolteby William   586724 586724 Bolteby, William, of Waltham 1
4541131 2213130 2213130 defendant Bolteby William   586724 586724 Bolteby, William, of Waltham 2
4547912 2215282 2215282 defendant Potell John   586724 586724 Potell, John, of Waltham 2
4550343 2216048 2216048 plaintiff Candelesby William   586724 586724 Candelesby, William, of Waltham 1
4564954 2220604 2220604 defendant Skynner John   586724 586724 Skynner, John, of Waltham 0
4565731 2220842 2220842 defendant West Henry   586724 586724 West, Henry, of Waltham 6
4571647 2222709 2222709 plaintiff Alta Ripa John de   586724 586724 Alta Ripa, John de, of Waltham 0
4580187 2225292 2225292 plaintiff Candelesby William   586724 586724 Candelesby, William, of Waltham 1
4587965 2227634 2227634 defendant Barbour Richard   586724 586724 Barbour, Richard, of Waltham 1
4598539 2230779 2230779 defendant Brounyng John   586724 586724 Brounyng, John, of Waltham 0
4603438 2232266 2232266 plaintiff Wolaston Stephen   586724 586724 Wolaston, Stephen, of Waltham, parson 0
4605817 2232932 2232932 defendant Auncell John   586724 586724 Auncell, John, of Waltham 3
4615885 2235961 2235961 defendant Whyte John   586724 586724 Whyte, John, of Waltham 2
4628503 2239835 2239835 defendant Asseby William   586724 586724 Asseby, William, of Waltham 1
4640246 2243263 2243263 defendant Hervy Richard   586724 586724 Hervy, Richard, of Waltham 0
4649882 2245982 2245982 defendant Hervy Richard   586724 586724 Hervy, Richard, of Waltham 0
4658977 2248679 2248679 defendant BrounJon Robert clerk 586724 586724 BrounJon, Robert, of Waltham, clerk 0
4675139 2257838 2257838 defendant Bravour John yeoman 586724 586724 Bravour, John, of Waltham, yeoman 2

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