names

515 rows where place_id = 588671

✎ 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
3595246 1866147 1866147 defendant Dorneys John husbandman 588671 588671 Dorneys, John, of Berkyng, husbandman 3
3603911 1868895 1868895 defendant Hasyll John husbandman 588671 588671 Hasyll, John, of Berkyng, husbandman 2
3603918 1868896 1868896 defendant Hasyll John husbandman 588671 588671 Hasyll, John, of Berkyng, husbandman 2
3604695 1869131 1869131 defendant Taylor Rose widow 588671 588671 Taylor, Rose, of Berkyng, widow 0
3605540 1869398 1869398 defendant Henley Richard gent 588671 588671 Henley, Richard, of Berkyng, gent 1
3610206 1870856 1870856 defendant Reynold John yeoman 588671 588671 Reynold, John, of Berkyng, yeoman 0
3613114 1871755 1871755 defendant Lewes John yeoman 588671 588671 Lewes, John, of Berkyng, yeoman 0
3613115 1871755 1871755 defendant Domet John yeoman 588671 588671 Domet, John, of Berkyng, yeoman 1
3613116 1871755 1871755 defendant Mynston John yeoman 588671 588671 Mynston, John, of Berkyng, yeoman 2
3613117 1871755 1871755 defendant Pykman Geoffrey yeoman 588671 588671 Pykman, Geoffrey, of Berkyng, yeoman 3
3615542 1872501 1872501 defendant Smyth Hugh husbandman 588671 588671 Smyth, Hugh, of Berkyng, husbandman 0
3615543 1872501 1872501 defendant Priour Richard smith 588671 588671 Priour, Richard, of Berkyng, smith 1
3626454 1903129 1903129 defendant Broun Robert husbandman 588671 588671 Broun, Robert, of Berkyng, husbandman 1
3626459 1903131 1903131 defendant Smyth Robert weaver 588671 588671 Smyth, Robert, of Berkyng, weaver 1
3628102 1903646 1903646 plaintiff Burre Thomas   588671 588671 Burre, Thomas, of Berkyng 0
3628651 1903835 1903835 defendant Typlyn John yeoman 588671 588671 Typlyn, John, of Berkyng, yeoman 0
3631492 1904663 1904663 defendant Fysshe Thomas laborer 588671 588671 Fysshe, Thomas, of Berkyng, laborer 0
3635755 1905983 1905983 defendant Burre Thomas tanner 588671 588671 Burre, Thomas, of Berkyng, tanner 0
3638580 1906883 1906883 defendant Petyt William gent 588671 588671 Petyt, William, of Berkyng, gent 0
3638581 1906883 1906883 defendant Hyll Thomas husbandman 588671 588671 Hyll, Thomas, of Berkyng, husbandman 1
3639810 1907263 1907263 defendant Bramley Ralph tailor 588671 588671 Bramley, Ralph, of Berkyng, tailor 0
3650244 1910448 1910448 plaintiff Rygby George (legal representative) 588671 588671 Rygby, George, of Berkyng, gent, executors of 0
3653899 1911483 1911483 defendant Pulford William husbandman 588671 588671 Pulford, William, of Berkyng, husbandman 1
3653900 1911483 1911483 defendant Bugge Robert husbandman 588671 588671 Bugge, Robert, of Berkyng, husbandman 2
3671727 1917143 1917143 plaintiff Colyns John (legal representative) 588671 588671 Colyns, John, of Berkyng, porter, executrix of 0
3677143 1918893 1918893 defendant Chapman William yeoman 588671 588671 Chapman, William, of Berkyng, yeoman 3
3709507 1929279 1929279 plaintiff Rande William gent 588671 588671 Rande, William, of Berkyng, gent 0
3730956 1935913 1935913 defendant Humfre John carpenter 588671 588671 Humfre, John, of Berkyng, carpenter 0
3730958 1935914 1935914 defendant Barrowe Thomas tanner 588671 588671 Barrowe, Thomas, of Berkyng, tanner 0
3741992 1939364 1939364 defendant Valentyne Andrew husbandman 588671 588671 Valentyne, Andrew, of Berkyng, husbandman 0
3741995 1939365 1939365 defendant Valentyne Andrew husbandman 588671 588671 Valentyne, Andrew, of Berkyng, husbandman 0
3798589 1957463 1957463 defendant Humfrey John carpenter 588671 588671 Humfrey, John, of Berkyng, carpenter 1
3798590 1957463 1957463 defendant Halle William yeoman 588671 588671 Halle, William, of Berkyng, yeoman 2
3810175 1961072 1961072 defendant Parkynson Henry butcher 588671 588671 Parkynson, Henry, of Berkyng, butcher 0
3811811 1961595 1961595 defendant Costone Richard yeoman 588671 588671 Costone, Richard, of Berkyng, yeoman 0
3825918 1965954 1965954 defendant Humfrey John yeoman 588671 588671 Humfrey, John, of Berkyng, yeoman 1
3825919 1965954 1965954 defendant Hollyk John yeoman 588671 588671 Hollyk, John, of Berkyng, yeoman 2
3835190 1968946 1968946 defendant West alias Hegger Richard husbandman 588671 588671 West alias Hegger, Richard, of Berkyng, husbandman 0
3835191 1968946 1968946 defendant Ewyn Thomas husbandman 588671 588671 Ewyn, Thomas, of Berkyng, husbandman 1
3837375 1969601 1969601 plaintiff Smyth William   588671 588671 Smyth, William, of Berkyng 0
3843044 1971352 1971352 defendant Nicholas John yeoman 588671 588671 Nicholas, John, of Berkyng, yeoman 1
3847391 1972745 1972745 defendant Lylbard John innholder 588671 588671 Lylbard, John, of Berkyng, innholder 0
3850341 1973695 1973695 defendant Bryan Robert chaplain 588671 588671 Bryan, Robert, of Berkyng, chaplain 0
3853023 1974565 1974565 defendant Saunder William fuller 588671 588671 Saunder, William, of Berkyng, fuller 0
3855546 1975377 1975377 defendant Batty William gent 588671 588671 Batty, William, of Berkyng, gent 0
3863497 1977988 1977988 defendant Norden Robert laborer 588671 588671 Norden, Robert, of Berkyng, laborer 0
3863498 1977988 1977988 defendant Clerke William laborer 588671 588671 Clerke, William, of Berkyng, laborer 1
3863499 1977988 1977988 defendant Hollyck John thatcher 588671 588671 Hollyck, John, of Berkyng, thatcher 2
3863500 1977988 1977988 defendant Pett Matthew fisher 588671 588671 Pett, Matthew, of Berkyng, fisher 3
3866185 1978918 1978918 defendant Peerson John tanner 588671 588671 Peerson, John, of Berkyng, tanner 0
3866186 1978918 1978918 defendant Marshall John tanner 588671 588671 Marshall, John, of Berkyng, tanner 1
3866187 1978918 1978918 defendant Woodland alias Egham Richard smith 588671 588671 Woodland alias Egham, Richard, of Berkyng, smith 2
3866188 1978918 1978918 defendant Fysshe Richard tailor 588671 588671 Fysshe, Richard, of Berkyng, tailor 3
3866425 1979002 1979002 defendant Estbroke John husbandman 588671 588671 Estbroke, John, of Berkyng, husbandman 0
3867546 1979382 1979382 defendant Wyncham Thomas butcher 588671 588671 Wyncham, Thomas, of Berkyng, butcher 0
3867547 1979382 1979382 defendant Goldyng Thomas butcher 588671 588671 Goldyng, Thomas, of Berkyng, butcher 1
3871855 1980825 1980825 defendant Marshall John tanner 588671 588671 Marshall, John, of Berkyng, tanner 0
3880057 1983589 1983589 defendant Severn William butcher 588671 588671 Severn, William, of Berkyng, butcher 0
3892133 1987622 1987622 plaintiff Marshe Thomas butcher 588671 588671 Marshe, Thomas, of Berkyng, butcher 0
3894461 1988354 1988354 plaintiff Brykett John   588671 588671 Brykett, John, of Berkyng 2
3894462 1988354 1988354 plaintiff Pownsett William   588671 588671 Pownsett, William, of Berkyng 3
3905656 1992164 1992164 defendant Cleypole William husbandman 588671 588671 Cleypole, William, of Berkyng, husbandman 0
3933622 2001532 2001532 defendant Gyle alias Capper John husbandman 588671 588671 Gyle alias Capper, John, of Berkyng, husbandman 0
4072134 2050333 2050333 plaintiff Nutbrowne William gent 588671 588671 Nutbrowne, William, of Berkyng, gent 0
4433417 2175213 2175213 plaintiff Gaunt John (legal representative) 588671 588671 Gaunt, John, of Berkyng, draper, formerly of London, executor of 0
4452834 2185898 2185898 defendant Daures Stephen   588671 588671 Daures, Stephen, of Berkyng 0
4452847 2185903 2185903 defendant Doures Stephen   588671 588671 Doures, Stephen, of Berkyng 0
4468893 2190951 2190951 defendant Bene John   588671 588671 Bene, John, of Berkyng 1
4472575 2192093 2192093 plaintiff Colman Joan   588671 588671 Colman, Joan, of Berkyng, formerly wife of Thomas Colman 0
4477335 2193576 2193576 defendant Lechom Richard   588671 588671 Lechom, Richard, of Berkyng, vicar, or of the east part of the church 0
4486538 2196501 2196501 plaintiff Sampkyn Thomas   588671 588671 Sampkyn, Thomas, of Berkyng 0
4487151 2196708 2196708 plaintiff Shipwright John   588671 588671 Shipwright, John, of Berkyng 0
4488490 2197121 2197121 plaintiff Strete Robert   588671 588671 Strete, Robert, of Berkyng 0
4492446 2198318 2198318 defendant Bocher John   588671 588671 Bocher, John, of Berkyng 0
4498825 2200267 2200267 defendant Noloth William   588671 588671 Noloth, William, of Berkyng 0
4520209 2206657 2206657 plaintiff Felton Sibyl de   588671 588671 Felton, Sibyl de, of Berkyng, abbess 0
4520211 2206658 2206658 plaintiff Felton Sibyl de   588671 588671 Felton, Sibyl de, of Berkyng, abbess 0
4527592 2208908 2208908 defendant Sparwe John   588671 588671 Sparwe, John, of Berkyng 0
4536201 2211598 2211598 defendant Berdevyle John   588671 588671 Berdevyle, John, of Berkyng 0
4536496 2211691 2211691 plaintiff Standon William   588671 588671 Standon, William, of Berkyng 0
4553864 2217131 2217131 defendant Geslyn John   588671 588671 Geslyn, John, of Berkyng 0
4553865 2217131 2217131 defendant Hamond John   588671 588671 Hamond, John, of Berkyng 1
4554830 2217436 2217436 defendant Prot Thomas   588671 588671 Prot, Thomas, of Berkyng 0
4556569 2217990 2217990 defendant Spark John   588671 588671 Spark, John, of Berkyng 0
4565621 2220817 2220817 defendant Burgh William   588671 588671 Burgh, William, of Berkyng 0
4574451 2223539 2223539 defendant Clerk Walter   588671 588671 Clerk, Walter, of Berkyng 0
4600148 2231272 2231272 defendant Snowe Ralph   588671 588671 Snowe, Ralph, of Berkyng 0
4600990 2231539 2231539 defendant Snowe Ralph   588671 588671 Snowe, Ralph, of Berkyng 0
4621537 2237725 2237725 defendant Pioworth John   588671 588671 Pioworth, John, of Berkyng 0
4622761 2238095 2238095 plaintiff Makeioye John   588671 588671 Makeioye, John, of Berkyng, vicar 0
4623454 2238310 2238310 defendant Tyler William   588671 588671 Tyler, William, of Berkyng 1
4623457 2238311 2238311 defendant Tyler William   588671 588671 Tyler, William, of Berkyng 1
4653258 2246958 2246958 defendant Snowe Ralph   588671 588671 Snowe, Ralph, of Berkyng, bailiff 2
4653435 2247005 2247005 defendant Aspall Thomas esq 588671 588671 Aspall, Thomas, of Berkyng, esq 0
4656508 2247931 2247931 defendant Stotfold John husbandman 588671 588671 Stotfold, John, of Berkyng, husbandman 0
4665862 2250799 2250799 defendant Longe Richard yeoman 588671 588671 Longe, Richard, of Berkyng, yeoman 1
4666247 2250914 2250914 defendant Moor Roger esq 588671 588671 Moor, Roger, of Berkyng, esq 0
4668579 2255882 2255882 defendant Aspall Thomas esq 588671 588671 Aspall, Thomas, of Berkyng, esq 0
4686379 2261345 2261345 defendant Colyer William, junior laborer 588671 588671 Colyer, William, junior, of Berkyng, laborer 1
4714832 2269972 2269972 plaintiff Doye Robert   588671 588671 Doye, Robert, of Berkyng 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);