names

75 rows where place_id = 589556

✎ 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
3597976 1866991 1866991 defendant Stotevyle Richard   589556 589556 Stotevyle, Richard, of Dalham 0
3630076 1904255 1904255 defendant Crople John husbandman 589556 589556 Crople, John, of Dalham, husbandman 0
3632058 1904843 1904843 defendant Cropley John husbandman 589556 589556 Cropley, John, of Dalham, husbandman 3
3645835 1909102 1909102 defendant Croppele John husbandman 589556 589556 Croppele, John, of Dalham, husbandman 0
3686879 1922059 1922059 defendant Cropley John husbandman 589556 589556 Cropley, John, of Dalham, husbandman 0
3725202 1934170 1934170 defendant Thyng John laborer 589556 589556 Thyng, John, of Dalham, laborer 0
3730864 1935879 1935879 defendant Lyes Roger butcher 589556 589556 Lyes, Roger, of Dalham, butcher 0
3757927 1944463 1944463 defendant Cadman Robert cooper 589556 589556 Cadman, Robert, of Dalham, cooper 3
3760041 1945136 1945136 defendant Burman John glover 589556 589556 Burman, John, of Dalham, glover 2
3780503 1951633 1951633 defendant Pye William husbandman 589556 589556 Pye, William, of Dalham, husbandman 0
3812396 1961768 1961768 defendant Borman John husbandman 589556 589556 Borman, John, of Dalham, husbandman 2
3837972 1969788 1969788 defendant Slyngesby Christopher (legal representative) 589556 589556 Slyngesby, Christopher, of Dalham, esq, administrator of 0
3844220 1971741 1971741 defendant Crople John yeoman 589556 589556 Crople, John, of Dalham, yeoman 2
3847132 1972656 1972656 defendant Cropley John husbandman 589556 589556 Cropley, John, of Dalham, husbandman 0
3862449 1977635 1977635 defendant Cropley John husbandman 589556 589556 Cropley, John, of Dalham, husbandman 0
3870343 1980331 1980331 defendant Paske Thomas shoemaker 589556 589556 Paske, Thomas, of Dalham, shoemaker 0
3906742 1992549 1992549 defendant Cropley John husbandman 589556 589556 Cropley, John, of Dalham, husbandman 0
3906743 1992549 1992549 defendant Glover Thomas laborer 589556 589556 Glover, Thomas, of Dalham, laborer 1
3914384 1995153 1995153 defendant Cropeley John yeoman 589556 589556 Cropeley, John, of Dalham, yeoman 0
3915363 1995505 1995505 defendant Crople John husbandman 589556 589556 Crople, John, of Dalham, husbandman 1
3981945 2018305 2018305 defendant Plesans Robert yeoman 589556 589556 Plesans, Robert, of Dalham, yeoman 0
4025756 2033866 2033866 defendant Plumer Robert yeoman 589556 589556 Plumer, Robert, of Dalham, yeoman 1
4075417 2051510 2051510 defendant Cropley William husbandman 589556 589556 Cropley, William, of Dalham, husbandman 1
4406860 2166863 2166863 defendant Pricke Robert husbandman 589556 589556 Pricke, Robert, of Dalham, husbandman 0
4411371 2168393 2168393 defendant Pricke Robert yeoman 589556 589556 Pricke, Robert, of Dalham, yeoman 1
4442898 2182739 2182739 plaintiff Byntre Ellis   589556 589556 Byntre, Ellis, of Dalham, formerly parson 0
4520852 2206864 2206864 defendant Melleman Nicholas   589556 589556 Melleman, Nicholas, of Dalham 3
4546301 2214777 2214777 defendant Clak John   589556 589556 Clak, John, of Dalham 0
4546303 2214778 2214778 defendant Clak John   589556 589556 Clak, John, of Dalham, parson 0
4555278 2217586 2217586 defendant Meleman Nicholas   589556 589556 Meleman, Nicholas, of Dalham 1
4560691 2219291 2219291 defendant Sompter John   589556 589556 Sompter, John, of Dalham, parson 0
4565446 2220762 2220762 defendant Croplee Robert   589556 589556 Croplee, Robert, of Dalham 0
4565447 2220762 2220762 defendant Wysman Thomas   589556 589556 Wysman, Thomas, of Dalham 1
4568632 2221768 2221768 defendant Makyn John   589556 589556 Makyn, John, of Dalham 3
4611423 2234635 2234635 defendant Braas William   589556 589556 Braas, William, of Dalham 0
4640655 2243375 2243375 defendant Geyston John   589556 589556 Geyston, John, of Dalham 2
4640662 2243376 2243376 defendant Goyston John   589556 589556 Goyston, John, of Dalham 2
4666222 2250906 2250906 defendant Barkere John ploughman 589556 589556 Barkere, John, of Dalham, ploughman 0
4715814 2270262 2270262 defendant Dyke Thomas chaplain 589556 589556 Dyke, Thomas, of Dalham, chaplain 0
4715815 2270262 2270262 defendant Dyke Thomas husbandman 589556 589556 Dyke, Thomas, of Dalham, husbandman 1
4740521 2277739 2277739 defendant Predyngton John yeoman 589556 589556 Predyngton, John, of Dalham, yeoman 2
4763311 2284511 2284511 defendant Hygham John   589556 589556 Hygham, John, of Dalham 0
4763925 2284710 2284710 plaintiff Halle William   589556 589556 Halle, William, of Dalham, parson 0
4763926 2284710 2284710 defendant Berde John husbandman 589556 589556 Berde, John, of Dalham, husbandman 0
4763927 2284711 2284711 plaintiff Halle William   589556 589556 Halle, William, of Dalham, parson 0
4763928 2284711 2284711 defendant Berde John husbandman 589556 589556 Berde, John, of Dalham, husbandman 0
4787739 2292233 2292233 defendant Berde John husbandman 589556 589556 Berde, John, of Dalham, husbandman 0
4788755 2292539 2292539 defendant Follere William laborer 589556 589556 Follere, William, of Dalham, laborer 3
4788756 2292539 2292539 defendant Hikrys Richard laborer 589556 589556 Hikrys, Richard, of Dalham, laborer 4
4788971 2292604 2292604 defendant Dykes Thomas yeoman 589556 589556 Dykes, Thomas, of Dalham, yeoman 1
4871052 2317922 2317922 defendant Dyke Henry clerk 589556 589556 Dyke, Henry, of Dalham, clerk 1
5091984 2384035 2384035 defendant Motte Richard husbandman 589556 589556 Motte, Richard, of Dalham, husbandman 2
5115442 2390943 2390943 plaintiff Mot John (legal representative) 589556 589556 Mot, John, of Dalham, administrator of 0
5131812 2395790 2395790 defendant Roger William husbandman 589556 589556 Roger, William, of Dalham, husbandman 0
5131813 2395790 2395790 defendant Rose Robert husbandman 589556 589556 Rose, Robert, of Dalham, husbandman 1
5246655 2429181 2429181 defendant Yonge John (legal representative) 589556 589556 Yonge, John, of Dalham, mercer, executors of 0
5246656 2429181 2429181 defendant Colman Richard   589556 589556 (Colman, Richard, of Dalham, shepherd 1
5286739 2441129 2441129 defendant Boorse Henry blacksmith 589556 589556 Boorse, Henry, of Dalham, blacksmith 0
5361530 2463629 2463629 defendant Lancastre Thomas gent 589556 589556 Lancastre, Thomas, of Dalham, gent 0
5382112 2469943 2469943 plaintiff Godard William   589556 589556 Godard, William, of Dalham 1
5387034 2471358 2471358 defendant Tyrll John (legal representative) 589556 589556 Tyrll, John, of Dalham, butcher, executor of 0
5387035 2471358 2471358 defendant Tyrll John husbandman 589556 589556 Tyrll, John, of Dalham, husbandman 1
5390680 2472398 2472398 plaintiff Godard William   589556 589556 Godard, William, of Dalham 1
5403606 2476103 2476103 plaintiff Godard William   589556 589556 Godard, William, of Dalham 1
5416710 2479917 2479917 plaintiff Godard William   589556 589556 Godard, William, of Dalham 1
5547613 2519319 2519319 defendant Wymark Thomas husbandman 589556 589556 Wymark, Thomas, of Dalham, husbandman 3
5549793 2519971 2519971 defendant Wymark John, junior husbandman 589556 589556 Wymark, John, junior, of Dalham, husbandman 1
5550326 2520114 2520114 defendant Wymark John butcher 589556 589556 Wymark, John, of Dalham, butcher 5
5551792 2520570 2520570 defendant Taylour John husbandman 589556 589556 Taylour, John, of Dalham, husbandman 1
5553846 2521163 2521163 defendant Wymark John, senior husbandman 589556 589556 Wymark, John, senior, of Dalham, husbandman 2
5553847 2521163 2521163 defendant Wymark John, junior husbandman 589556 589556 Wymark, John, junior, of Dalham, husbandman 3
5555783 2521680 2521680 defendant Wymark John butcher 589556 589556 Wymark, John, of Dalham, butcher 1
5567238 2524994 2524994 defendant Taillour John yeoman 589556 589556 Taillour, John, of Dalham, yeoman 3
5584748 2530303 2530303 defendant Lancaster Thomas gent 589556 589556 Lancaster, Thomas, of Dalham, gent 0
5584750 2530304 2530304 defendant Lancaster Thomas gent 589556 589556 Lancaster, Thomas, of Dalham, gent 0

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