names

212 rows where place_id = 587449

✎ 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
3591444 1864951 1864951 defendant Verdon Nicholas husbandman 587449 587449 Verdon, Nicholas, of Felmyngham, husbandman 0
3603423 1868739 1868739 defendant Camond William yeoman 587449 587449 Camond, William, of Felmyngham, yeoman 12
3610725 1871018 1871018 defendant Bakon Thomas husbandman 587449 587449 Bakon, Thomas, of Felmyngham, husbandman 4
3626728 1903205 1903205 defendant Rede Margaret widow 587449 587449 Rede, Margaret, of Felmyngham, widow 2
3630576 1904392 1904392 defendant Foster John husbandman 587449 587449 Foster, John, of Felmyngham, husbandman 1
3630638 1904412 1904412 defendant Trace John husbandman 587449 587449 Trace, John, of Felmyngham, husbandman 0
3655129 1911865 1911865 defendant Bretwyn Thomas gent 587449 587449 Bretwyn, Thomas, of Felmyngham, gent 2
3671824 1917185 1917185 defendant Blakborne William   587449 587449 Blakborne, William, of Felmyngham, worsted weaver 0
3671825 1917185 1917185 defendant Rede John butcher 587449 587449 Rede, John, of Felmyngham, butcher 1
3672262 1917324 1917324 defendant Evered John husbandman 587449 587449 Evered, John, of Felmyngham, husbandman 0
3674735 1918142 1918142 defendant Rede John butcher 587449 587449 Rede, John, of Felmyngham, butcher 2
3680801 1920077 1920077 defendant Evarard Henry butcher 587449 587449 Evarard, Henry, of Felmyngham, butcher 0
3680802 1920077 1920077 defendant Rede John butcher 587449 587449 Rede, John, of Felmyngham, butcher 1
3680807 1920078 1920078 defendant Everard Henry butcher 587449 587449 Everard, Henry, of Felmyngham, butcher 0
3705036 1927864 1927864 defendant Stryke John husbandman 587449 587449 Stryke, John, of Felmyngham, husbandman 4
3733658 1936768 1936768 defendant Wulcy John shoemaker 587449 587449 Wulcy, John, of Felmyngham, shoemaker 1
3769844 1948224 1948224 defendant Midelton Alan husbandman 587449 587449 Midelton, Alan, of Felmyngham, husbandman 1
3774060 1949602 1949602 defendant Ryches John husbandman 587449 587449 Ryches, John, of Felmyngham, husbandman 0
3814772 1962533 1962533 defendant Sadler John yeoman 587449 587449 Sadler, John, of Felmyngham, yeoman 0
3820366 1964248 1964248 defendant Heyer John husbandman 587449 587449 Heyer, John, of Felmyngham, husbandman 2
3822939 1965081 1965081 defendant Myddelton Alan husbandman 587449 587449 Myddelton, Alan, of Felmyngham, husbandman 0
3836572 1969341 1969341 defendant Russell Robert   587449 587449 Russell, Robert, of Felmyngham, worsted weaver 0
3839544 1970292 1970292 defendant Pyxston Thomas pedder 587449 587449 Pyxston, Thomas, of Felmyngham, pedder 5
3840154 1970492 1970492 defendant Sadler John yeoman 587449 587449 Sadler, John, of Felmyngham, yeoman 2
3841018 1970761 1970761 defendant Sadeller John husbandman 587449 587449 Sadeller, John, of Felmyngham, husbandman 0
3852327 1974330 1974330 plaintiff Rede John, senior   587449 587449 Rede, John, senior, of Felmyngham 0
3857722 1976051 1976051 defendant Pyxton Thomas husbandman 587449 587449 Pyxton, Thomas, of Felmyngham, husbandman 1
3857723 1976051 1976051 defendant Sadeller John yeoman 587449 587449 Sadeller, John, of Felmyngham, yeoman 2
3859050 1976517 1976517 plaintiff Bury John husbandman 587449 587449 Bury, John, of Felmyngham, husbandman 0
3861742 1977391 1977391 defendant Everard Robert butcher 587449 587449 Everard, Robert, of Felmyngham, butcher 0
3866118 1978898 1978898 defendant Everard Robert butcher 587449 587449 Everard, Robert, of Felmyngham, butcher 2
3873198 1981250 1981250 defendant Bury John husbandman 587449 587449 Bury, John, of Felmyngham, husbandman 0
3876653 1982436 1982436 defendant Assekewe John husbandman 587449 587449 Assekewe, John, of Felmyngham, husbandman 0
3876654 1982436 1982436 defendant Skevyn John   587449 587449 Skevyn, John, of Felmyngham, worsted weaver 1
3879851 1983518 1983518 defendant Marshall Hugh chaplain 587449 587449 Marshall, Hugh, of Felmyngham, chaplain 2
3881945 1984219 1984219 plaintiff Spencer James gent 587449 587449 Spencer, James, of Felmyngham, gent 0
3884023 1984926 1984926 defendant Pykton Thomas pedder 587449 587449 Pykton, Thomas, of Felmyngham, pedder 0
3885813 1985507 1985507 defendant Everard Robert butcher 587449 587449 Everard, Robert, of Felmyngham, butcher 1
3896753 1989126 1989126 plaintiff Waller John   587449 587449 Waller, John, of Felmyngham 0
3899626 1990093 1990093 defendant Everedd Robert butcher 587449 587449 Everedd, Robert, of Felmyngham, butcher 1
3906921 1992603 1992603 plaintiff Mykelyng Robert   587449 587449 Mykelyng, Robert, of Felmyngham 0
3916944 1996034 1996034 defendant Ives William   587449 587449 Ives, William, of Felmyngham, worsted weaver 0
3924651 1998559 1998559 defendant Kempe Adam husbandman 587449 587449 Kempe, Adam, of Felmyngham, husbandman 0
3925677 1998901 1998901 defendant Tylierd John, junior carpenter 587449 587449 Tylierd, John, junior, of Felmyngham, carpenter 0
3925680 1998901 1998901 defendant Grene John laborer 587449 587449 Grene, John, of Felmyngham, laborer 3
3941402 2004132 2004132 defendant Russell William gent 587449 587449 Russell, William, of Felmyngham, gent 3
3981530 2018154 2018154 plaintiff Rede Richard   587449 587449 Rede, Richard, of Felmyngham 0
3981951 2018308 2018308 defendant Lestrange Henry gent 587449 587449 Lestrange, Henry, of Felmyngham, gent 0
4003175 2025896 2025896 defendant le Straunge Henry gent 587449 587449 le Straunge, Henry, of Felmyngham, gent 0
4029737 2035276 2035276 defendant Rumpe John husbandman 587449 587449 Rumpe, John, of Felmyngham, husbandman 1
4029738 2035276 2035276 defendant Cooke Nicholas husbandman 587449 587449 Cooke, Nicholas, of Felmyngham, husbandman 2
4031544 2035946 2035946 defendant Buntynge Robert gent 587449 587449 Buntynge, Robert, of Felmyngham, gent 1
4045864 2040966 2040966 defendant Here Thomas husbandman 587449 587449 Here, Thomas, of Felmyngham, husbandman 2
4046966 2041366 2041366 defendant Here Thomas husbandman 587449 587449 Here, Thomas, of Felmyngham, husbandman 2
4060713 2046235 2046235 defendant Smyth Thomas miller 587449 587449 Smyth, Thomas, of Felmyngham, miller 1
4075951 2051697 2051697 defendant Buntyng Robert, senior gent 587449 587449 Buntyng, Robert, senior, of Felmyngham, gent 8
4076035 2051724 2051724 defendant Buntyng Henry gent 587449 587449 Buntyng, Henry, of Felmyngham, gent 6
4111779 2064462 2064462 defendant Smyth Thomas yeoman 587449 587449 Smyth, Thomas, of Felmyngham, yeoman 3
4121489 2067979 2067979 defendant Grene Robert clerk 587449 587449 Grene, Robert, of Felmyngham, clerk 2
4127910 2070272 2070272 defendant Grene Robert gent 587449 587449 Grene, Robert, of Felmyngham, gent 0
4135302 2072945 2072945 defendant Smyth John gent 587449 587449 Smyth, John, of Felmyngham, gent 0
4143990 2076061 2076061 defendant Botevante Thomas yeoman 587449 587449 Botevante, Thomas, of Felmyngham, yeoman 1
4145949 2076738 2076738 defendant Bretten Thomas gent 587449 587449 Bretten, Thomas, of Felmyngham, gent 0
4172639 2085890 2085890 defendant Moone Robert husbandman 587449 587449 Moone, Robert, of Felmyngham, husbandman 0
4172641 2085891 2085891 defendant Grene John husbandman 587449 587449 Grene, John, of Felmyngham, husbandman 0
4176064 2087103 2087103 defendant Bretton Humphrey gent 587449 587449 Bretton, Humphrey, of Felmyngham, gent 0
4182713 2089433 2089433 defendant Smythe John gent 587449 587449 Smythe, John, of Felmyngham, gent 0
4206746 2097901 2097901 defendant Smyth John gent 587449 587449 Smyth, John, of Felmyngham, gent 0
4210476 2099220 2099220 defendant Plane Thomas yeoman 587449 587449 Plane, Thomas, of Felmyngham, or of Kings lenne, yeoman 0
4217613 2101654 2101654 defendant Crofte William gent 587449 587449 Crofte, William, of Felmyngham, gent 1
4251331 2113423 2113423 defendant Armestronge Philip blacksmith 587449 587449 Armestronge, Philip, of Felmyngham, blacksmith 3
4277414 2122021 2122021 defendant Croftes Richard gent 587449 587449 Croftes, Richard, of Felmyngham, gent 3
4343980 2145172 2145172 defendant Younger Adam yeoman 587449 587449 Younger, Adam, of Felmyngham, yeoman 3
4348960 2146899 2146899 defendant Mettam Robert innholder 587449 587449 Mettam, Robert, of Felmyngham, innholder 3
4354833 2148912 2148912 defendant Colles Robert husbandman 587449 587449 Colles, Robert, of Felmyngham, husbandman 1
4387661 2160510 2160510 defendant Hodgson Edmund laborer 587449 587449 Hodgson, Edmund, of Felmyngham, laborer 0
4412036 2168616 2168616 defendant Croft or Croftes Richard gent 587449 587449 Croft or Croftes, Richard, of Felmyngham, gent 2
4412902 2168909 2168909 defendant Colles Robert husbandman 587449 587449 Colles, Robert, of Felmyngham, husbandman 2
4439568 2181639 2181639 defendant Keg John   587449 587449 Keg, John, of Felmyngham 1
4448846 2184579 2184579 defendant Leg John   587449 587449 Leg, John, of Felmyngham 1
4454016 2186268 2186268 defendant Hert Paganus   587449 587449 Hert, Paganus, of Felmyngham 13
4464985 2189711 2189711 defendant Dyngle Gilbert   587449 587449 Dyngle, Gilbert, of Felmyngham 12
4494428 2198955 2198955 plaintiff Botes John   587449 587449 Botes, John, of Felmyngham 0
4494429 2198955 2198955 defendant Sibbes William   587449 587449 Sibbes, William, of Felmyngham 0
4495939 2199407 2199407 plaintiff Clere Stephen   587449 587449 Clere, Stephen, of Felmyngham 0
4498124 2200068 2200068 defendant Crane Henry   587449 587449 Crane, Henry, of Felmyngham 0
4550170 2215997 2215997 defendant Wryghte Adam   587449 587449 Wryghte, Adam, of Felmyngham 0
4578435 2224742 2224742 plaintiff Clerk Thomas   587449 587449 Clerk, Thomas, of Felmyngham 0
4578436 2224742 2224742 defendant Camond John   587449 587449 Camond, John, of Felmyngham 0
4578437 2224742 2224742 defendant Clerk Adam   587449 587449 Clerk, Adam, of Felmyngham 1
4582773 2226048 2226048 defendant Smyth Thomas   587449 587449 Smyth, Thomas, of Felmyngham, vicar 0
4602903 2232123 2232123 plaintiff Whitewelle John   587449 587449 Whitewelle, John, of Felmyngham 0
4605843 2232941 2232941 defendant atte Wode Gregory   587449 587449 atte Wode, Gregory, of Felmyngham 0
4605847 2232941 2232941 defendant Ropere John   587449 587449 Ropere, John, of Felmyngham 4
4623679 2238382 2238382 defendant Molys John   587449 587449 Molys, John, of Felmyngham 0
4634273 2241560 2241560 defendant Gunnes Adam   587449 587449 Gunnes, Adam, of Felmyngham 0
4650392 2246138 2246138 defendant Gunnys Adam   587449 587449 Gunnys, Adam, of Felmyngham 0
4654650 2247333 2247333 defendant Taillour John tailor 587449 587449 Taillour, John, of Felmyngham, tailor 3
4670613 2256489 2256489 plaintiff Bullok Ralph   587449 587449 Bullok, Ralph, of Felmyngham, 0
4687106 2261571 2261571 defendant Clerk William yeoman 587449 587449 Clerk, William, of Felmyngham, 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);