names

246 rows where place_id = 586918

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589982 1864507 1864507 defendant Purches John husbandman 586918 586918 Purches, John, of Stanford, husbandman 2
3594002 1865763 1865763 defendant Copley William yeoman 586918 586918 Copley, William, of Stanford, yeoman 0
3598924 1867291 1867291 defendant Illyngworth Ralph esq 586918 586918 Illyngworth, Ralph, of Stanford, esq 0
3598927 1867292 1867292 defendant Illyngworth Ralph esq 586918 586918 Illyngworth, Ralph, of Stanford, esq 0
3622626 1874606 1874606 defendant Spiseley Thomas laborer 586918 586918 Spiseley, Thomas, of Stanford, laborer 0
3631061 1904538 1904538 plaintiff Fyccys Thomas woolman 586918 586918 Fyccys, Thomas, of Stanford, woolman 0
3633057 1905152 1905152 defendant Edmundys Robert yeoman 586918 586918 Edmundys, Robert, of Stanford, yeoman 1
3642250 1908024 1908024 plaintiff Cane or Cave Richard gent 586918 586918 Cane or Cave, Richard, of Stanford, gent 0
3642530 1908106 1908106 plaintiff Cave Richard gent 586918 586918 Cave, Richard, of Stanford, gent 0
3644973 1908836 1908836 defendant Turnor William husbandman 586918 586918 Turnor, William, of Stanford, husbandman 2
3660153 1913435 1913435 defendant Lyngwode Robert yeoman 586918 586918 Lyngwode, Robert, of Stanford, yeoman 1
3666099 1915341 1915341 defendant Fekeys Thomas   586918 586918 Fekeys, Thomas, of Stanford, wool man 1
3671155 1916948 1916948 plaintiff Cave Richard gent 586918 586918 Cave, Richard, of Stanford, gent 0
3676818 1918788 1918788 plaintiff Knollys Roger yeoman 586918 586918 Knollys, Roger, of Stanford, yeoman 0
3680159 1919864 1919864 defendant Morecote Thomas husbandman 586918 586918 Morecote, Thomas, of Stanford, husbandman 0
3680164 1919866 1919866 defendant Morecote Thomas husbandman 586918 586918 Morecote, Thomas, of Stanford, husbandman 0
3680275 1919905 1919905 plaintiff Reve Martin yeoman 586918 586918 Reve, Martin, of Stanford, yeoman 0
3717882 1931893 1931893 defendant Fykes Thomas husbandman 586918 586918 Fykes, Thomas, of Stanford, husbandman 1
3721158 1932915 1932915 defendant Wytton Matthew glover 586918 586918 Wytton, Matthew, of Stanford, glover 0
3726859 1934670 1934670 plaintiff Tyng William   586918 586918 Tyng, William, of Stanford 0
3727446 1934858 1934858 defendant Hodgeson Richard draper 586918 586918 Hodgeson, Richard, of Stanford, draper 0
3730318 1935714 1935714 plaintiff Bloundell Richard   586918 586918 Bloundell, Richard, of Stanford 2
3733636 1936761 1936761 defendant Fykys Thomas husbandman 586918 586918 Fykys, Thomas, of Stanford, husbandman 1
3743404 1939811 1939811 defendant Turnour William husbandman 586918 586918 Turnour, William, of Stanford, husbandman 0
3745567 1940519 1940519 defendant Wryght Richard baker 586918 586918 Wryght, Richard, of Stanford, baker 0
3750868 1942191 1942191 defendant Kylborn John husbandman 586918 586918 Kylborn, John, of Stanford, husbandman 0
3760252 1945209 1945209 defendant Hewys alias Weldon Robert husbandman 586918 586918 Hewys alias Weldon, Robert, of Stanford, husbandman 2
3763635 1946266 1946266 defendant Parre Richard husbandman 586918 586918 Parre, Richard, of Stanford, husbandman 1
3766742 1947259 1947259 defendant Kylborn John husbandman 586918 586918 Kylborn, John, of Stanford, husbandman 0
3778777 1951078 1951078 defendant Lupton William chaplain 586918 586918 Lupton, William, of Stanford, chaplain 0
3779060 1951175 1951175 defendant Fowler William chaplain 586918 586918 Fowler, William, of Stanford, chaplain 0
3781748 1952038 1952038 plaintiff Hedworth Ralph clerk 586918 586918 Hedworth, Ralph, of Stanford, clerk 0
3781751 1952038 1952038 defendant Kylborn Robert husbandman 586918 586918 Kylborn, Robert, of Stanford, husbandman 2
3781752 1952038 1952038 defendant Nicholson John laborer 586918 586918 Nicholson, John, of Stanford, laborer 3
3803991 1959165 1959165 defendant Stone William laborer 586918 586918 Stone, William, of Stanford, laborer 0
3807317 1960189 1960189 defendant Tomson John   586918 586918 Tomson, John, of Stanford, tile burner 1
3807961 1960379 1960379 defendant Turner William husbandman 586918 586918 Turner, William, of Stanford, husbandman 0
3818683 1963747 1963747 defendant Anger or Auger Thomas husbandman 586918 586918 Anger or Auger, Thomas, of Stanford, husbandman 0
3818684 1963747 1963747 defendant Turnour Christopher laborer 586918 586918 Turnour, Christopher, of Stanford, laborer 1
3828615 1966828 1966828 defendant Bronde John husbandman 586918 586918 Bronde, John, of Stanford, husbandman 0
3831725 1967824 1967824 defendant Don John husbandman 586918 586918 Don, John, of Stanford, husbandman 0
3843211 1971409 1971409 defendant Tompson Robert slater 586918 586918 Tompson, Robert, of Stanford, slater 1
3853478 1974712 1974712 defendant Churche Roger laborer 586918 586918 Churche, Roger, of Stanford, laborer 0
3853564 1974741 1974741 defendant Bele Roger husbandman 586918 586918 Bele, Roger, of Stanford, husbandman 0
3863541 1978001 1978001 defendant Gardyner William husbandman 586918 586918 Gardyner, William, of Stanford, husbandman 0
3869197 1979943 1979943 defendant Spicer Thomas husbandman 586918 586918 Spicer, Thomas, of Stanford, husbandman 0
3873544 1981371 1981371 plaintiff Cave Richard esq 586918 586918 Cave, Richard, of Stanford, esq 0
3877008 1982550 1982550 plaintiff Hedworthe Ralph (legal representative) 586918 586918 Hedworthe, Ralph, of Stanford, clerk, executor of 0
3881554 1984092 1984092 defendant Spycer John husbandman 586918 586918 Spycer, John, of Stanford, husbandman 0
3883533 1984764 1984764 defendant Sewall Thomas laborer 586918 586918 Sewall, Thomas, of Stanford, laborer 2
3896215 1988940 1988940 defendant Haykoxe Thomas husbandman 586918 586918 Haykoxe, Thomas, of Stanford, husbandman 0
3903626 1991444 1991444 plaintiff Graunt George   586918 586918 Graunt, George, of Stanford Ryver 0
3904296 1991684 1991684 defendant Knyfton Thomas gent 586918 586918 Knyfton, Thomas, of Stanford, gent 0
3906112 1992334 1992334 defendant Mytchell John husbandman 586918 586918 Mytchell, John, of Stanford, husbandman 4
3940531 2003844 2003844 defendant Yonger William husbandman 586918 586918 Yonger, William, of Stanford, husbandman 0
3965665 2012606 2012606 defendant Adcoke Clement yeoman 586918 586918 Adcoke, Clement, of Stanford, yeoman 1
3965666 2012606 2012606 defendant Bayll Henry yeoman 586918 586918 Bayll, Henry, of Stanford, yeoman 2
3965667 2012606 2012606 defendant Freman Thomas yeoman 586918 586918 Freman, Thomas, of Stanford, yeoman 3
3965668 2012606 2012606 defendant Jamson Robert yeoman 586918 586918 Jamson, Robert, of Stanford, yeoman 4
3965669 2012606 2012606 defendant Clerke Richard yeoman 586918 586918 Clerke, Richard, of Stanford, yeoman 5
3974108 2015515 2015515 defendant Asten Richard laborer 586918 586918 Asten, Richard, of Stanford, laborer 0
3974109 2015515 2015515 defendant Wynne John laborer 586918 586918 Wynne, John, of Stanford, laborer 1
4022535 2032785 2032785 defendant Clarke Robert   586918 586918 Clarke, Robert, of Stanford, shepherd 0
4074775 2051279 2051279 plaintiff Reynes Robert, junior gent 586918 586918 Reynes, Robert, junior, of Stanford, gent 0
4078450 2052591 2052591 defendant Fenton John yeoman 586918 586918 Fenton, John, of Stanford, yeoman 0
4144323 2076174 2076174 defendant Blunte Thomas husbandman 586918 586918 Blunte, Thomas, of Stanford, husbandman 0
4236026 2108172 2108172 defendant Revell Robert vintener 586918 586918 Revell, Robert, of Stanford, vintener 1
4274288 2120952 2120952 defendant Estgate Richard husbandman 586918 586918 Estgate, Richard, of Stanford, husbandman 2
4334118 2141689 2141689 defendant Higges John yeoman 586918 586918 Higges, John, of Stanford, yeoman 0
4335261 2142065 2142065 defendant Albon Thomas, junior husbandman 586918 586918 Albon, Thomas, junior, of Stanford, husbandman 0
4335262 2142065 2142065 defendant Albon Hugh husbandman 586918 586918 Albon, Hugh, of Stanford, husbandman 1
4348254 2146638 2146638 defendant Porter William chapman 586918 586918 together with Porter, William, of Stanford, chapman 1
4366112 2152923 2152923 defendant Randoll Thomas   586918 586918 Randoll, Thomas, of Stanford, Beds yeoman 2
4389910 2161251 2161251 defendant Holland Richard yeoman 586918 586918 Holland, Richard, of Stanford, yeoman 0
4404515 2166077 2166077 defendant Hawys Robert yeoman 586918 586918 Hawys, Robert, of Stanford, yeoman 0
4413612 2169149 2169149 plaintiff Botelshalve William de   586918 586918 Botelshalve, William de, of Stanford 0
4413614 2169150 2169150 plaintiff Botelsham William de   586918 586918 Botelsham, William de, of Stanford 0
4427154 2173318 2173318 defendant Thomas William   586918 586918 Thomas, William, of Stanford 1
4431283 2174546 2174546 plaintiff Bigge William (legal representative) 586918 586918 Bigge, William, of Stanford, executors of 0
4431284 2174546 2174546 plaintiff Somurvill Hugh de   586918 586918 Somurvill, Hugh de, of Stanford 1
4431435 2174600 2174600 plaintiff Botelsham William de   586918 586918 Botelsham, William de, of Stanford 0
4437687 2176544 2176544 plaintiff Wynwyk John de   586918 586918 (Wynwyk, John de, of Stanford, parson 1
4442297 2182525 2182525 plaintiff Broun John   586918 586918 Broun, John, of Stanford 0
4474547 2192700 2192700 defendant del Grene John   586918 586918 del Grene, John, of Stanford 0
4482598 2195259 2195259 defendant Clerk John   586918 586918 Clerk, John, of Stanford 0
4488761 2197210 2197210 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford, parson 6
4488769 2197211 2197211 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford, parson 6
4495616 2199312 2199312 defendant Machon Hugh   586918 586918 Machon, Hugh, of Stanford 0
4513405 2204610 2204610 defendant Nywemarchant John   586918 586918 Nywemarchant, John, of Stanford 0
4513406 2204610 2204610 defendant Bonde Ralph   586918 586918 Bonde, Ralph, of Stanford 1
4513407 2204610 2204610 defendant Grofham Lawrence   586918 586918 Grofham, Lawrence, of Stanford 2
4522495 2207376 2207376 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford, parson 2
4566928 2221219 2221219 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford, parson 4
4566935 2221220 2221220 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford, parson 4
4573191 2223151 2223151 plaintiff Banes John   586918 586918 Banes, John, of Stanford 0
4573193 2223151 2223151 defendant North Thomas   586918 586918 North, Thomas, of Stanford 1
4583332 2226207 2226207 plaintiff Fox Henry   586918 586918 Fox, Henry, of Stanford 0
4584765 2226659 2226659 defendant Sherere Andrew   586918 586918 Sherere, Andrew, of Stanford 2
4589084 2227965 2227965 defendant Roke Henry   586918 586918 Roke, Henry, of Stanford 0
4595391 2229815 2229815 plaintiff Redman Thomas   586918 586918 Redman, Thomas, of Stanford, parson 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);