names

171 rows where place_id = 591141

✎ 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
3603455 1868746 1868746 defendant Canwold John tailor 591141 591141 Canwold, John, of Loddon, tailor 0
3603456 1868746 1868746 defendant Sponer John yeoman 591141 591141 Sponer, John, of Loddon, yeoman 1
3619835 1873780 1873780 defendant Clerk John yeoman 591141 591141 Clerk, John, of Loddon, yeoman 0
3657869 1912710 1912710 defendant Holme Thomas husbandman 591141 591141 Holme, Thomas, of Loddon, husbandman 2
3660461 1913532 1913532 defendant Riston Robert yeoman 591141 591141 Riston, Robert, of Loddon, yeoman 0
3661190 1913775 1913775 defendant Stannard Henry gent 591141 591141 Stannard, Henry, of Loddon, gent 2
3669967 1916551 1916551 plaintiff Boty Thomas   591141 591141 Boty, Thomas, of Loddon 0
3670205 1916628 1916628 defendant Ryston Robert husbandman 591141 591141 Ryston, Robert, of Loddon, husbandman 1
3675888 1918495 1918495 defendant Phephyr John painter 591141 591141 Phephyr, John, of Loddon, painter 2
3682255 1920548 1920548 plaintiff Styntwary Richard yeoman 591141 591141 Styntwary, Richard, of Loddon, yeoman 0
3684254 1921209 1921209 plaintiff Wulffe Ralph gent 591141 591141 Wulffe, Ralph, of Loddon, gent 0
3691685 1923558 1923558 defendant Seyntwary Richard yeoman 591141 591141 Seyntwary, Richard, of Loddon, yeoman 0
3692268 1923752 1923752 defendant Molle Edward   591141 591141 Molle, Edward, of Loddon, worsted weaver 1
3700625 1926442 1926442 defendant Smyth Richard butcher 591141 591141 Smyth, Richard, of Loddon, butcher 0
3700626 1926442 1926442 defendant Boty Thomas husbandman 591141 591141 Boty, Thomas, of Loddon, husbandman 1
3700771 1926493 1926493 defendant Sparke William husbandman 591141 591141 Sparke, William, of Loddon, husbandman 1
3705041 1927865 1927865 defendant Feld John mercer 591141 591141 Feld, John, of Loddon, mercer 3
3705960 1928152 1928152 defendant Holme Thomas yeoman 591141 591141 Holme, Thomas, of Loddon, yeoman 1
3710625 1929645 1929645 defendant Greystok Richard husbandman 591141 591141 Greystok, Richard, of Loddon, husbandman 0
3713251 1930452 1930452 defendant Westgate Andrew yeoman 591141 591141 Westgate, Andrew, of Loddon, yeoman 0
3744760 1940260 1940260 defendant Sparke William husbandman 591141 591141 Sparke, William, of Loddon, husbandman 0
3794576 1956183 1956183 defendant Hobart Walter esq 591141 591141 Hobart, Walter, of Loddon, esq 0
3799052 1957612 1957612 defendant Ryston Robert yeoman 591141 591141 Ryston, Robert, of Loddon, yeoman 0
3831450 1967721 1967721 defendant Reston Robert husbandman 591141 591141 Reston, Robert, of Loddon, husbandman 0
3832368 1968041 1968041 defendant Ryston Robert husbandman 591141 591141 Ryston, Robert, of Loddon, husbandman 1
3843503 1971504 1971504 defendant Dawson Richard smith 591141 591141 Dawson, Richard, of Loddon, smith 0
3865409 1978645 1978645 defendant Hoberd Walter   591141 591141 Hoberd, Walter, of Loddon, knight 0
3876421 1982358 1982358 defendant Humffrey John yeoman 591141 591141 Humffrey, John, of Loddon, yeoman 3
3880791 1983842 1983842 defendant Humfrey John tanner 591141 591141 Humfrey, John, of Loddon, tanner 0
3881906 1984203 1984203 defendant Wymont Robert   591141 591141 Wymont, Robert, of Loddon, worsted weaver 0
3885356 1985358 1985358 defendant Adde Robert mercer 591141 591141 Adde, Robert, of Loddon, mercer 0
3885358 1985359 1985359 defendant Adde Robert mercer 591141 591141 Adde, Robert, of Loddon, mercer 0
3889852 1986845 1986845 defendant Manneclerke William yeoman 591141 591141 (Manneclerke, William, of Loddon, yeoman 5
3893968 1988205 1988205 defendant Ade Robert raffman 591141 591141 Ade, Robert, of Loddon, raffman 0
3893974 1988206 1988206 defendant Ade Robert raffman 591141 591141 Ade, Robert, of Loddon, raffman 0
3908237 1993052 1993052 defendant Ade Robert mercer 591141 591141 Ade, Robert, of Loddon, mercer 3
3911706 1994241 1994241 plaintiff Whyk John   591141 591141 Whyk, John, of Loddon 0
3911709 1994241 1994241 defendant Bradley Robert husbandman 591141 591141 Bradley, Robert, of Loddon, husbandman 2
3963606 2011881 2011881 defendant Barfote John husbandman 591141 591141 Barfote, John, of Loddon, husbandman 1
3965653 2012602 2012602 plaintiff Belamy John   591141 591141 Belamy, John, of Loddon 0
3965656 2012603 2012603 plaintiff Belamy John   591141 591141 Belamy, John, of Loddon 0
3974605 2015681 2015681 defendant Barfutte John husbandman 591141 591141 Barfutte, John, of Loddon, husbandman 0
3980498 2017793 2017793 defendant Molle Richard tailor 591141 591141 Molle, Richard, of Loddon, tailor 0
4017570 2030990 2030990 defendant Mendham John tailor 591141 591141 Mendham, John, of Loddon, tailor 0
4021307 2032347 2032347 defendant Knight Roger grocer 591141 591141 Knight, Roger, of Loddon, or of Norwich, grocer 0
4025217 2033681 2033681 defendant Homerston John gent 591141 591141 Homerston, John, of Loddon, gent 1
4037740 2038149 2038149 defendant Westgate Edmund yeoman 591141 591141 Westgate, Edmund, of Loddon, yeoman 2
4041116 2039315 2039315 defendant Hummerston John gent 591141 591141 Hummerston, John, of Loddon, gent 0
4048726 2041989 2041989 defendant Humberston John gent 591141 591141 Humberston, John, of Loddon, gent 0
4055065 2044210 2044210 defendant Westgate Edmund yeoman 591141 591141 Westgate, Edmund, of Loddon, yeoman 0
4056387 2044667 2044667 defendant Osborne Thomas yeoman 591141 591141 Osborne, Thomas, of Loddon, yeoman 0
4064056 2047425 2047425 defendant Meeke Richard innolder 591141 591141 Meeke, Richard, of Loddon, innolder 0
4069939 2049532 2049532 plaintiff Lynsey William husbandman 591141 591141 Lynsey, William, of Loddon, husbandman 0
4091056 2057091 2057091 defendant Belson Thomas yeoman 591141 591141 Belson, Thomas, of Loddon, yeoman 0
4129213 2070751 2070751 defendant Osborne Thomas yeoman 591141 591141 Osborne, Thomas, of Loddon, yeoman 0
4142199 2075448 2075448 defendant Meke Richard innholder 591141 591141 Meke, Richard, of Loddon, innholder 1
4148357 2077557 2077557 defendant Westoe or Wescoe Henry clerk 591141 591141 Westoe or Wescoe, Henry, of Loddon, clerk 0
4150130 2078182 2078182 defendant Clarke John yeoman 591141 591141 Clarke, John, of Loddon, yeoman 0
4150243 2078216 2078216 defendant Clarke John yeoman 591141 591141 Clarke, John, of Loddon, yeoman 0
4153495 2079318 2079318 defendant Codde John yeoman 591141 591141 Codde, John, of Loddon, yeoman 2
4158787 2081147 2081147 defendant Godbolde Thomas yeoman 591141 591141 Godbolde, Thomas, of Loddon, yeoman 1
4158788 2081147 2081147 defendant Clarke Thomas singleman 591141 591141 Clarke, Thomas, of Loddon, yeoman, singleman 2
4163942 2082918 2082918 defendant Fylbye William yeoman 591141 591141 Fylbye, William, of Loddon, yeoman 0
4167563 2084150 2084150 defendant Codd John yeoman 591141 591141 Codd, John, of Loddon, yeoman 0
4171518 2085502 2085502 defendant Aldryche Robert yeoman 591141 591141 Aldryche, Robert, of Loddon, yeoman 0
4185178 2090323 2090323 defendant Synderton Henry yeoman 591141 591141 Synderton, Henry, of Loddon, yeoman 1
4192406 2092898 2092898 defendant Dey Richard yeoman 591141 591141 Dey, Richard, of Loddon, yeoman 3
4194373 2093582 2093582 defendant Wooddyard John yeoman 591141 591141 Wooddyard, John, of Loddon, yeoman 0
4201183 2095966 2095966 defendant Clarke John yeoman 591141 591141 Clarke, John, of Loddon, yeoman 0
4201185 2095966 2095966 defendant Mickelborowe Robert husbandman 591141 591141 Mickelborowe Robert, of Loddon, husbandman 2
4201186 2095966 2095966 defendant Hill Ralph husbandman 591141 591141 Hill, Ralph, of Loddon, husbandman 3
4205572 2097501 2097501 defendant Felde John grocer 591141 591141 Felde, John, of Loddon, grocer 0
4215960 2101075 2101075 defendant Wade Thomas miller 591141 591141 Wade, Thomas, of Loddon, miller 0
4216294 2101192 2101192 defendant Dun Silvester yeoman 591141 591141 Dun, Silvester, of Loddon, yeoman 3
4218423 2101945 2101945 defendant Browne Robert yeoman 591141 591141 Browne, Robert, of Loddon, yeoman 0
4218424 2101945 2101945 defendant Cowper Alexander yeoman 591141 591141 Cowper, Alexander, of Loddon, yeoman 1
4218425 2101945 2101945 defendant Dode Hamond yeoman 591141 591141 Dode, Hamond, of Loddon, yeoman 2
4218426 2101945 2101945 defendant Poolle John yeoman 591141 591141 Poolle, John, of Loddon, yeoman 3
4218432 2101948 2101948 defendant Dunne Silvester   591141 591141 Dunne, Silvester, of Loddon husbandman 0
4233020 2107056 2107056 defendant Chelles Leonard butcher 591141 591141 Chelles, Leonard, of Loddon, butcher 1
4245127 2111357 2111357 defendant Whyte John haberdasher 591141 591141 Whyte, John, of Loddon, haberdasher 0
4251122 2113354 2113354 defendant Gales Robert husbandman 591141 591141 Gales, Robert, of Loddon, husbandman 1
4251124 2113354 2113354 defendant Shreve William sawyer 591141 591141 Shreve, William, of Loddon, sawyer 3
4259529 2116164 2116164 defendant Davy John husbandman 591141 591141 Davy, John, of Loddon, husbandman 0
4259530 2116164 2116164 defendant Johnson Richard husbandman 591141 591141 Johnson, Richard, of Loddon, husbandman 1
4260702 2116546 2116546 defendant Dunne Silvester husbandman 591141 591141 Dunne, Silvester, of Loddon, husbandman 2
4265867 2118224 2118224 defendant Wood Thomas miller 591141 591141 Wood, Thomas, of Loddon, miller 0
4290792 2126763 2126763 defendant Preston Thomas husbandman 591141 591141 Preston, Thomas, of Loddon, husbandman 2
4318478 2136573 2136573 defendant Weste Henry clerk 591141 591141 Weste, Henry, of Loddon, clerk 2
4318481 2136574 2136574 defendant Davy John yeoman 591141 591141 Davy, John, of Loddon, or of Norton Subcorse, yeoman 0
4322342 2137887 2137887 defendant Larke John husbandman 591141 591141 Larke, John, of Loddon, husbandman 0
4324468 2138577 2138577 defendant More John butcher 591141 591141 More, John, of Loddon, butcher 0
4324469 2138577 2138577 defendant Cabeck George carpenter 591141 591141 Cabeck, George, of Loddon, carpenter 1
4324470 2138577 2138577 defendant Pounde Simon husbandman 591141 591141 Pounde, Simon, of Loddon, husbandman 2
4330121 2140373 2140373 defendant Westoe Henry clerk 591141 591141 Westoe, Henry, of Loddon, clerk 0
4330122 2140373 2140373 defendant Cottie Joel laborer 591141 591141 Cottie, Joel, of Loddon, laborer 1
4335242 2142060 2142060 defendant Tony Lewis yeoman 591141 591141 Tony, Lewis, of Loddon, yeoman 0
4348539 2146741 2146741 defendant Barnham Thomas husbandman 591141 591141 Barnham, Thomas, of Loddon, husbandman 1
4348540 2146741 2146741 defendant Molle Richard innholder 591141 591141 Molle, Richard, of Loddon, innholder 2
4349155 2146965 2146965 defendant Aldrige Robert gent 591141 591141 Aldrige, Robert, of Loddon, gent 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);