names

223 rows where place_id = 588732

✎ 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
3595404 1866195 1866195 defendant Strode James husbandman 588732 588732 Strode, James, of Acle, husbandman 0
3604382 1869037 1869037 defendant Hendy William, junior yeoman 588732 588732 Hendy, William, junior, of Acle, yeoman 1
3604383 1869037 1869037 defendant Mawnfrey Thomas husbandman 588732 588732 Mawnfrey, Thomas, of Acle, husbandman 2
3607056 1869872 1869872 defendant Reynes Robert yeoman 588732 588732 Reynes, Robert, of Acle, yeoman 1
3607398 1869975 1869975 defendant Calthorp Robert laborer 588732 588732 Calthorp. Robert, of Acle, laborer 1
3607403 1869976 1869976 defendant Calthorp Robert laborer 588732 588732 Calthorp, Robert, of Acle, laborer 0
3622933 1874701 1874701 defendant Culthorp Robert laborer 588732 588732 Culthorp, Robert, of Acle, laborer 1
3625713 1875580 1875580 defendant Dowenyng Henry butcher 588732 588732 Dowenyng, Henry, of Acle, butcher 0
3634169 1905489 1905489 defendant Roper Robert fuller 588732 588732 Roper, Robert, of Acle, fuller 0
3635307 1905835 1905835 defendant Beynham William gent 588732 588732 Beynham, William, of Acle, gent 0
3635310 1905836 1905836 defendant Beynham William gent 588732 588732 Beynham, William, of Acle, gent 0
3635519 1905908 1905908 defendant Gyles John laborer 588732 588732 Gyles, John, of Acle, laborer 0
3642054 1907966 1907966 defendant Downyng John yeoman 588732 588732 Downyng, John, of Acle, yeoman 0
3642225 1908016 1908016 defendant Ederyche Robert yeoman 588732 588732 Ederyche, Robert, of Acle, yeoman 0
3646052 1909163 1909163 defendant Swan John yeoman 588732 588732 Swan, John, of Acle, yeoman 0
3646976 1909454 1909454 defendant Downyng John butcher 588732 588732 Downyng, John, of Acle, butcher 0
3660958 1913699 1913699 defendant Sendell George   588732 588732 Sendell, George, of Acle, worsted weaver 0
3668771 1916169 1916169 defendant Cotis Cecilia widow 588732 588732 Cotis, Cecilia, of Acle, widow 1
3678120 1919207 1919207 defendant Garrard Thomas pedder 588732 588732 Garrard, Thomas, of Acle, pedder 1
3678121 1919207 1919207 defendant Fen John husbandman 588732 588732 Fen, John, of Acle, husbandman 2
3690886 1923313 1923313 defendant Multon Henry husbandman 588732 588732 Multon, Henry, of Acle, husbandman 1
3690891 1923314 1923314 defendant Multon Henry husbandman 588732 588732 Multon, Henry, of Acle, husbandman 1
3694740 1924559 1924559 defendant Clere Thomas gent 588732 588732 Clere, Thomas, of Acle, gent 0
3697627 1925482 1925482 defendant Fen John husbandman 588732 588732 Fen, John, of Acle, husbandman 0
3706984 1928467 1928467 defendant Barbor John husbandman 588732 588732 Barbor, John, of Acle, husbandman 1
3720096 1932561 1932561 defendant Robynson Robert husbandman 588732 588732 Robynson, Robert, of Acle, husbandman 1
3720099 1932562 1932562 defendant Robynson Robert husbandman 588732 588732 Robynson, Robert, of Acle, husbandman 1
3725979 1934397 1934397 defendant Reynes Henry husbandman 588732 588732 Reynes, Henry, of Acle, husbandman 0
3731806 1936178 1936178 defendant Robynson alias Roper Robert yeoman 588732 588732 Robynson alias Roper, Robert, of Acle, yeoman 1
3734645 1937081 1937081 defendant Jacob John   588732 588732 Jacob, John, of Acle, yeoman, itinerant bailiff 0
3755825 1943774 1943774 defendant Roper Robert yeoman 588732 588732 Roper, Robert, of Acle, yeoman 0
3764407 1946529 1946529 defendant Algor Henry husbandman 588732 588732 Algor, Henry, of Acle, husbandman 1
3773823 1949525 1949525 defendant Roper Robert yeoman 588732 588732 Roper, Robert, of Acle, yeoman 0
3776755 1950475 1950475 defendant Robynson alias Roper Robert yeoman 588732 588732 Robynson alias Roper, Robert, of Acle, yeoman 0
3777341 1950658 1950658 plaintiff Clere Thomas esq 588732 588732 Clere, Thomas, of Acle, esq 0
3782332 1952228 1952228 defendant Hall George   588732 588732 Hall, George, of Acle, worsted weaver 0
3789300 1954473 1954473 defendant Walker John husbandman 588732 588732 Walker, John, of Acle, husbandman 0
3805641 1959707 1959707 defendant Downyng John butcher 588732 588732 Downyng, John, of Acle, butcher 1
3807586 1960278 1960278 defendant Whelpydale Thomas smith 588732 588732 Whelpydale, Thomas, of Acle, smith 1
3809470 1960843 1960843 defendant Robynson Robert yeoman 588732 588732 Robynson, Robert, of Acle, yeoman 3
3812771 1961888 1961888 defendant Dounhyll John butcher 588732 588732 Dounhyll, John, of Acle, butcher 0
3831491 1967735 1967735 defendant Clere Thomas esq 588732 588732 Clere, Thomas, of Acle, esq 0
3831492 1967735 1967735 defendant Spenluffe Henry carpenter 588732 588732 Spenluffe, Henry, of Acle, carpenter 1
3835510 1969046 1969046 defendant Clere Thomas esq 588732 588732 Clere, Thomas, of Acle, esq 0
3837687 1969698 1969698 defendant Calbar Thomas baker 588732 588732 Calbar, Thomas, of Acle, baker 0
3839669 1970333 1970333 defendant Robynson alias Roper Robert yeoman 588732 588732 Robynson alias Roper, Robert, of Acle, yeoman 0
3840486 1970584 1970584 defendant Twychet Richard husbandman 588732 588732 Twychet, Richard, of Acle, husbandman 0
3840958 1970740 1970740 defendant Fenne John husbandman 588732 588732 Fenne, John, of Acle, husbandman 1
3841290 1970856 1970856 defendant Roper Robert husbandman 588732 588732 Roper, Robert, of Acle, husbandman 3
3842174 1971101 1971101 defendant Hogan Walter tailor 588732 588732 Hogan, Walter, of Acle, tailor 1
3843943 1971644 1971644 defendant Hacsam Christopher tailor 588732 588732 Hacsam, Christopher, of Acle, tailor 1
3843959 1971649 1971649 defendant Chamber Thomas yeoman 588732 588732 Chamber, Thomas, of Acle, yeoman 2
3844480 1971818 1971818 defendant Chamber Thomas husbandman 588732 588732 Chamber, Thomas, of Acle, husbandman 0
3844744 1971899 1971899 defendant Chamber Thomas yeoman 588732 588732 Chamber, Thomas, of Acle, yeoman 0
3854396 1975012 1975012 defendant Sheryngham Henry husbandman 588732 588732 Sheryngham, Henry, of Acle, husbandman 0
3858888 1976460 1976460 defendant Spendlove Henry carpenter 588732 588732 Spendlove, Henry, of Acle, carpenter 0
3864081 1978170 1978170 defendant Chamber Thomas husbandman 588732 588732 Chamber, Thomas, of Acle, husbandman 0
3865030 1978504 1978504 defendant Chamber Thomas merchant 588732 588732 Chamber, Thomas, of Acle, merchant 0
3865032 1978505 1978505 defendant Chayme alias Chamber Thomas merchant 588732 588732 Chayme alias Chamber, Thomas, of Acle, merchant 0
3866116 1978898 1978898 defendant Breton Robert gent 588732 588732 Breton, Robert, of Acle, gent 0
3866446 1979008 1979008 defendant Waller Christopher   588732 588732 Waller, Christopher, of Acle 1
3871516 1980717 1980717 defendant Yorke John   588732 588732 Yorke, John, of Acle, wheelwright 2
3872588 1981051 1981051 defendant Wyllyams Edward smith 588732 588732 Wyllyams, Edward, of Acle, smith 3
3875343 1981998 1981998 defendant Exham Christopher husbandman 588732 588732 Exham, Christopher, of Acle, husbandman 1
3878912 1983199 1983199 defendant Robynson alias Roper Robert yeoman 588732 588732 Robynson alias Roper, Robert, of Acle, yeoman 0
3883977 1984910 1984910 defendant Williams Edward smith 588732 588732 Williams, Edward, of Acle, smith 0
3897552 1989394 1989394 defendant Plumbe Charles smith 588732 588732 Plumbe, Charles, of Acle, smith 1
3905169 1991992 1991992 defendant Cady John smith 588732 588732 Cady, John, of Acle, smith 0
3910567 1993848 1993848 defendant Palmer Robert tanner 588732 588732 Palmer, Robert, of Acle, tanner 0
3930096 2000412 2000412 defendant Todde John tailor 588732 588732 Todde, John, of Acle, tailor 0
3931443 2000815 2000815 defendant Durrant Simon carpenter 588732 588732 Durrant, Simon, of Acle, carpenter 0
3931444 2000815 2000815 defendant Ne John husbandman 588732 588732 Ne, John, of Acle, husbandman 1
3931445 2000815 2000815 defendant Cook Henry carpenter 588732 588732 Cook, Henry, of Acle, carpenter 2
3931449 2000816 2000816 defendant Burges John beller or botler 588732 588732 Burges, John, of Acle, beller or botler 2
3931450 2000816 2000816 defendant Todde John tailor 588732 588732 Todde, John, of Acle, tailor 3
3956806 2009451 2009451 plaintiff Palmer Leonard gent 588732 588732 Palmer, Leonard, of Acle, gent 0
3970659 2014326 2014326 plaintiff Dey William yeoman 588732 588732 Dey, William, of Acle, yeoman 0
3970660 2014326 2014326 plaintiff Downyng Peter yeoman 588732 588732 Downyng, Peter, of Acle, yeoman 1
3970661 2014326 2014326 plaintiff Bockyng Clement yeoman 588732 588732 Bockyng, Clement, of Acle, yeoman 2
3993981 2022598 2022598 defendant Gray John laborer 588732 588732 Gray, John, of Acle, laborer 1
3993982 2022598 2022598 defendant Munnes William laborer 588732 588732 Munnes, William, of Acle, laborer 2
3996743 2023597 2023597 plaintiff Dey William husbandman 588732 588732 Dey, William, of Acle, husbandman 0
4014569 2029932 2029932 defendant Clarke John husbandman 588732 588732 Clarke, John, of Acle, husbandman 0
4021610 2032455 2032455 defendant Cubytt John butcher 588732 588732 Cubytt, John, of Acle, butcher 1
4024059 2033306 2033306 defendant Reder William yeoman 588732 588732 Reder, William, of Acle, yeoman 0
4029851 2035319 2035319 plaintiff Dey William yeoman 588732 588732 Dey, William, of Acle, yeoman 0
4029853 2035320 2035320 plaintiff Dey William yeoman 588732 588732 Dey, William, of Acle, yeoman 0
4033001 2036453 2036453 defendant Halydaye Robert   588732 588732 Halydaye, Robert, of Acle, mason 1
4037069 2037922 2037922 defendant Plumme John smith 588732 588732 Plumme, John, of Acle, smith 1
4047704 2041624 2041624 defendant Clerke John sherman 588732 588732 Clerke, John, of Acle, sherman 1
4060873 2046295 2046295 plaintiff Dey William yeoman 588732 588732 Dey, William, of Acle, yeoman 0
4076934 2052037 2052037 defendant Buttyvant Richard yeoman 588732 588732 Buttyvant, Richard, of Acle, yeoman 1
4096758 2059171 2059171 defendant Duffyld John clerk 588732 588732 Duffyld, John, of Acle, clerk 0
4096759 2059171 2059171 defendant Abbs Thomas husbandman 588732 588732 Abbs, Thomas, of Acle, husbandman 1
4096760 2059171 2059171 defendant Buttyvant John husbandman 588732 588732 Buttyvant, John, of Acle, husbandman 2
4105158 2062117 2062117 defendant Exham Francis husbandman 588732 588732 Exham, Francis, of Acle, husbandman 0
4114076 2065316 2065316 defendant Johnsons William glover 588732 588732 Johnsons, William, of Acle, glover 1
4129230 2070757 2070757 defendant Johnson William glover 588732 588732 Johnson, William, of Acle, glover 3
4129244 2070760 2070760 defendant Abbes Thomas grocer 588732 588732 Abbes, Thomas, of Acle, grocer 2
4152627 2079033 2079033 defendant Ashe John butcher 588732 588732 Ashe, John, of Acle, butcher 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);