names

418 rows where place_id = 586818

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589726 1864426 1864426 defendant Thorp William mercer 586818 586818 Thorp, William, of Stowemarket, mercer 1
3590612 1864706 1864706 defendant Bettys Robert sherman 586818 586818 Bettys, Robert, of Stowemarket, sherman 1
3593461 1865588 1865588 defendant Symond Richard dyer 586818 586818 Symond, Richard, of Stowemarket, dyer 0
3595610 1866255 1866255 plaintiff Milis Robert   586818 586818 Milis, Robert, of Stowemarket 0
3595612 1866255 1866255 defendant Truste John dyer 586818 586818 Truste, John, of Stowemarket, dyer 1
3595643 1866263 1866263 plaintiff Milys Robert   586818 586818 Milys, Robert, of Stowemarket 0
3595645 1866263 1866263 defendant Truste John dyer 586818 586818 Truste, John, of Stowemarket, dyer 1
3595952 1866364 1866364 defendant Dowe John clothmaker 586818 586818 Dowe, John, of Stowemarket, clothmaker 0
3598285 1867095 1867095 defendant Vyncent Robert clerk 586818 586818 Vyncent, Robert, of Stowemarket, clerk 0
3599167 1867376 1867376 defendant Grene Robert butcher 586818 586818 Grene, Robert, of Stowemarket, butcher 0
3600523 1867810 1867810 defendant Bole Thomas husbandman 586818 586818 Bole, Thomas, of Stowemarket, husbandman 4
3601414 1868102 1868102 defendant Grene Robert butcher 586818 586818 Grene, Robert, of Stowemarket, butcher 1
3601415 1868102 1868102 defendant Markes John husbandman 586818 586818 Markes, John, of Stowemarket, husbandman 2
3604162 1868968 1868968 defendant Cake Edward dyer 586818 586818 Cake, Edward, of Stowemarket, dyer 0
3608065 1870175 1870175 defendant Garard John clothmaker 586818 586818 Garard, John, of Stowemarket, clothmaker 0
3608066 1870175 1870175 defendant Cake Robert clothmaker 586818 586818 Cake, Robert, of Stowemarket, clothmaker 1
3613302 1871810 1871810 defendant Turnour Philip clothmaker 586818 586818 Turnour, Philip, of Stowemarket, clothmaker 1
3613304 1871810 1871810 defendant Cake Robert clothmaker 586818 586818 Cake, Robert, of Stowemarket, clothmaker 3
3616412 1872769 1872769 defendant South Thomas dyer 586818 586818 South, Thomas, of Stowemarket, dyer 3
3617534 1873105 1873105 defendant Lane John yeoman 586818 586818 Lane, John, of Stowemarket, yeoman 0
3618821 1873496 1873496 plaintiff Hemston William husbandman 586818 586818 Hemston, William, of Stowemarket, husbandman 0
3622654 1874616 1874616 defendant Cake Robert clothmaker 586818 586818 Cake, Robert, of Stowemarket, clothmaker 0
3650334 1910480 1910480 defendant Kebyll Thomas butcher 586818 586818 Kebyll, Thomas, of Stowemarket, butcher 0
3710602 1929639 1929639 defendant Cooke William mercer 586818 586818 Cooke, William, of Stowemarket, mercer 2
3742166 1939416 1939416 defendant Wage John husbandman 586818 586818 Wage, John, of Stowemarket, husbandman 1
3746192 1940717 1940717 defendant Andrewe John clothmaker 586818 586818 Andrewe, John, of Stowemarket, clothmaker 0
3760611 1945317 1945317 defendant Thorpe John mercer 586818 586818 Thorpe, John, of Stowemarket, mercer 0
3760613 1945318 1945318 defendant Wage John yeoman 586818 586818 Wage, John, of Stowemarket, yeoman 0
3787039 1953741 1953741 defendant Andrewe Thomas husbandman 586818 586818 Andrewe, Thomas, of Stowemarket, husbandman 0
3787040 1953741 1953741 defendant Andrewe John dyer 586818 586818 Andrewe, John, of Stowemarket, dyer 1
3801043 1958241 1958241 defendant Edward Robert shoemaker 586818 586818 Edward, Robert, of Stowemarket, shoemaker 3
3805878 1959779 1959779 defendant Simond Robert clothmaker 586818 586818 Simond, Robert, of Stowemarket, clothmaker 0
3807948 1960375 1960375 defendant Newport John husbandman 586818 586818 Newport, John, of Stowemarket, husbandman 0
3814721 1962517 1962517 defendant Markys William sherman 586818 586818 Markys, William, of Stowemarket, sherman 1
3824464 1965522 1965522 defendant Newport John dyer 586818 586818 Newport, John, of Stowemarket, dyer 0
3848688 1973177 1973177 defendant Kebyll John (legal representative) 586818 586818 Kebyll, John, of Stowemarket, butcher, administratrix of 0
3854496 1975045 1975045 defendant Pytman Richard dyer 586818 586818 Pytman, Richard, of Stowemarket, dyer 3
3863134 1977872 1977872 defendant Bryggys John yeoman 586818 586818 Bryggys, John, of Stowemarket, yeoman 0
3876749 1982467 1982467 defendant Studde Richard cooper 586818 586818 Studde, Richard, of Stowemarket, cooper 0
3893914 1988188 1988188 plaintiff Howe John carpenter 586818 586818 (Howe, John, of Stowemarket, carpenter 1
3893915 1988188 1988188 defendant Studde Richard cooper 586818 586818 Studde, Richard, of Stowemarket, cooper 0
3948733 2006624 2006624 defendant Morris Ralph gent 586818 586818 Morris, Ralph, of Stowemarket, gent 0
3948734 2006624 2006624 defendant Camplond alias Wryght Thomas husbandman 586818 586818 Camplond alias Wryght, Thomas, of Stowemarket, husbandman 1
4074857 2051308 2051308 defendant Dixon Thomas   586818 586818 Dixon, Thomas, of Stowemarket, carpet weaver 0
4325385 2138870 2138870 defendant Scalpie Thomas butcher 586818 586818 Scalpie, Thomas, of Stowemarket, butcher 0
4325386 2138870 2138870 defendant Smarte Nicholas potter 586818 586818 Smarte, Nicholas, of Stowemarket, potter 1
4325387 2138870 2138870 defendant Mosse Thomas laborer 586818 586818 Mosse, Thomas, of Stowemarket, laborer 2
4325388 2138870 2138870 defendant Gruimsi John laborer 586818 586818 Gruimsi, John, of Stowemarket, laborer 3
4469018 2190982 2190982 defendant Frend Robert   586818 586818 Frend, Robert, of Stowemarket 5
4500637 2200820 2200820 defendant Reed John chaplain 586818 586818 Reed, John, of Stowemarket, chaplain 6
4502470 2201355 2201355 defendant Padenhale John   586818 586818 Padenhale, John, of Stowemarket 1
4520881 2206872 2206872 defendant Skynnere Richard   586818 586818 Skynnere, Richard, of Stowemarket 9
4520891 2206873 2206873 defendant Skynnere Richard   586818 586818 Skynnere, Richard, of Stowemarket 3
4541800 2213325 2213325 defendant Wokys John fuller 586818 586818 Wokys, John, of Stowemarket, fuller 2
4559227 2218839 2218839 defendant Nene Edmund   586818 586818 Nene, Edmund, of Stowemarket 4
4566207 2220994 2220994 defendant Frost Roger clerk 586818 586818 Frost, Roger, of Stowemarket, clerk 0
4566209 2220995 2220995 defendant Frost Roger clerk 586818 586818 Frost, Roger, of Stowemarket, clerk 0
4593041 2229131 2229131 defendant Clerk Hugh   586818 586818 Clerk, Hugh, of Stowemarket 0
4618769 2236872 2236872 defendant Spicer John   586818 586818 Spicer, John, of Stowemarket 2
4618781 2236874 2236874 defendant Spicer John   586818 586818 Spicer, John, of Stowemarket 4
4623168 2238219 2238219 defendant del Hoo John   586818 586818 del Hoo, John, of Stowemarket 0
4645206 2244668 2244668 defendant Hotot John   586818 586818 Hotot, John, of Stowemarket 1
4664150 2250274 2250274 defendant Myles John husbandman 586818 586818 Myles, John, of Stowemarket, husbandman 3
4665835 2250790 2250790 defendant Spicer John chapman 586818 586818 Spicer, John, of Stowemarket, chapman 0
4665836 2250790 2250790 defendant Ch- John laborer 586818 586818 Ch-, John, of Stowemarket, laborer 1
4665837 2250790 2250790 defendant Brook Thomas laborer 586818 586818 Brook, Thomas, of Stowemarket, laborer 2
4665838 2250790 2250790 defendant Caleys Simon laborer 586818 586818 Caleys, Simon, of Stowemarket, laborer 3
4665839 2250790 2250790 defendant Curteys John fuller 586818 586818 Curteys, John, of Stowemarket, fuller 4
4665840 2250790 2250790 defendant Coo John laborer 586818 586818 Coo, John, of Stowemarket, laborer 5
4666258 2250918 2250918 plaintiff Ingham Thomas wooder 586818 586818 Ingham, Thomas, of Stowemarket, wooder 0
4679119 2259076 2259076 defendant Foster Richard fuller 586818 586818 Foster, Richard, of Stowemarket, fuller 0
4681607 2259860 2259860 defendant Spycer John yeoman 586818 586818 Spycer, John, of Stowemarket, yeoman 1
4704581 2266810 2266810 defendant Nene Edmund husbandman 586818 586818 Nene, Edmund, of Stowemarket, husbandman 0
4725293 2273202 2273202 plaintiff Frost Roger   586818 586818 Frost, Roger, of Stowemarket 0
4730254 2274667 2274667 plaintiff Magges Richard   586818 586818 Magges, Richard, of Stowemarket 0
4730255 2274667 2274667 defendant Fullere John fuller 586818 586818 Fullere, John, of Stowemarket, fuller 0
4783141 2290742 2290742 defendant Glover Thomas glover 586818 586818 Glover, Thomas, of Stowemarket, glover 0
4784147 2291041 2291041 defendant Ingham Thomas wooder 586818 586818 Ingham, Thomas, of Stowemarket, wooder 0
4787049 2292013 2292013 defendant Barbour Walter yeoman 586818 586818 Barbour, Walter, of Stowemarket, yeoman 0
4787050 2292013 2292013 defendant Eston William yeoman 586818 586818 Eston, William, of Stowemarket, yeoman 1
4787051 2292013 2292013 defendant Bylle Robert yeoman 586818 586818 Bylle, Robert, of Stowemarket, yeoman 2
4787054 2292015 2292015 plaintiff Goodhows William chaplain 586818 586818 Goodhows, William, of Stowemarket, chaplain 0
4787056 2292015 2292015 plaintiff Furbeshour Thomas   586818 586818 Furbeshour, Thomas, of Stowemarket 2
4789281 2292709 2292709 defendant Dryver Simon ploughman 586818 586818 Dryver, Simon, of Stowemarket, ploughman 0
4790366 2293068 2293068 defendant Austyn William glover 586818 586818 Austyn, William, of Stowemarket, glover 3
4796977 2295212 2295212 defendant Neve Edmund yeoman 586818 586818 Neve, Edmund, of Stowemarket, yeoman 0
4801976 2296802 2296802 defendant Thurston John spicer 586818 586818 Thurston, John, of Stowemarket, spicer 0
4826684 2304379 2304379 defendant Plombe John husbandman 586818 586818 Plombe, John, of Stowemarket, husbandman 0
4835254 2307026 2307026 plaintiff Ady John   586818 586818 Ady, John, of Stowemarket 1
4835359 2307054 2307054 defendant Hotot John esq 586818 586818 Hotot, John, of Stowemarket, esq 0
4835360 2307054 2307054 defendant Hoto Robert   586818 586818 Hoto, Robert, of Stowemarket, gent, son of John 1
4837921 2307786 2307786 defendant Dallyng Thomas chapman 586818 586818 Dallyng, Thomas, of Stowemarket, chapman 0
4838168 2307861 2307861 defendant Dallyng Thomas chapman 586818 586818 Dallyng, Thomas, of Stowemarket, chapman 0
4838963 2308116 2308116 defendant Draper John weaver 586818 586818 Draper, John, of Stowemarket, weaver 0
4841071 2308743 2308743 defendant Draper John yeoman 586818 586818 Draper, John, of Stowemarket, yeoman 0
4841368 2308835 2308835 defendant Ady John yeoman 586818 586818 Ady, John, of Stowemarket, yeoman 0
4848333 2310948 2310948 defendant Purs John smith 586818 586818 Purs, John, of Stowemarket, smith 1
4851429 2311894 2311894 defendant Thorpe John yeoman 586818 586818 Thorpe, John, of Stowemarket, yeoman 0
4858363 2313987 2313987 defendant Purs John smith 586818 586818 Purs, John, of Stowemarket, smith 0
4867699 2316868 2316868 defendant Dallyng Thomas yeoman 586818 586818 Dallyng, Thomas, of Stowemarket, yeoman 1

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