names

83 rows where place_id = 595081

✎ 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
3618833 1873501 1873501 defendant Donell or Dovell William husbandman 595081 595081 Donell or Dovell, William, of Misterton, husbandman 0
3627622 1903501 1903501 defendant Spore William gent 595081 595081 Spore, William, of Misterton, gent 1
3627627 1903501 1903501 defendant Geffray Philip butcher 595081 595081 Geffray, Philip, of Misterton, butcher 6
3641623 1907840 1907840 defendant Spore William gent 595081 595081 Spore, William, of Misterton, gent 0
3641630 1907840 1907840 defendant Gyffrey Philip butcher 595081 595081 Gyffrey, Philip, of Misterton, butcher 7
3664667 1914901 1914901 defendant Parsons Robert miller 595081 595081 Parsons, Robert, of Misterton, miller 4
3771189 1948679 1948679 defendant Clerke William husbandman 595081 595081 Clerke, William, of Misterton, husbandman 0
3773215 1949331 1949331 defendant Poge Thomas   595081 595081 Poge, Thomas, of Misterton, gent, son of Poge, Thomas 0
3868820 1979812 1979812 defendant Poge John esq 595081 595081 Poge, John, of Misterton, esq 0
4188314 2091416 2091416 defendant Pulman Adam husbandman 595081 595081 Pulman, Adam, of Misterton, husbandman 3
4219145 2102192 2102192 defendant Tonge Thomas yeoman 595081 595081 Tonge, Thomas, of Misterton, yeoman 1
4277210 2121961 2121961 defendant Farneham Hugh husbandman 595081 595081 Farneham, Hugh, of Misterton, husbandman 0
4334363 2141769 2141769 defendant Garlande Robert yeoman 595081 595081 Garlande, Robert, of Misterton, yeoman 0
4341426 2144279 2144279 defendant Baxenden Robert yeoman 595081 595081 Baxenden, Robert, of Misterton, yeoman 0
4359598 2150595 2150595 defendant Tonge Thomas yeoman 595081 595081 Tonge, Thomas, of Misterton, yeoman 1
4359599 2150595 2150595 defendant Tonge Robert yeoman 595081 595081 Tonge, Robert, of Misterton, yeoman 2
4360495 2150920 2150920 defendant Podge George gent 595081 595081 Podge, George, of Misterton, gent 0
4365382 2152683 2152683 defendant Farnham Hugh husbandman 595081 595081 Farnham, Hugh, of Misterton, husbandman 0
4365820 2152810 2152810 defendant Clarke William yeoman 595081 595081 Clarke, William, of Misterton, or of Fletchamsted, Warks, yeoman 0
4367082 2153282 2153282 defendant Baxenden John yeoman 595081 595081 Baxenden, John, of Misterton, yeoman 1
4368094 2153645 2153645 defendant Reynoldes William tailor 595081 595081 Reynoldes, William, of Misterton, tailor, Geare, George, of Haselbeare Plucknett, tailor 0
4374968 2156106 2156106 defendant Clerke William yeoman 595081 595081 Clerke, William, of Misterton, yeoman 0
4385961 2159995 2159995 defendant Baxenden Robert yeoman 595081 595081 Baxenden, Robert, of Misterton, yeoman 1
4385962 2159995 2159995 defendant Dawson Richard yeoman 595081 595081 Dawson, Richard, of Misterton, yeoman 2
4391068 2161633 2161633 defendant Dawson Richard yeoman 595081 595081 Dawson, Richard, of Misterton, yeoman 0
4391069 2161633 2161633 defendant Tonge Thomas yeoman 595081 595081 Tonge, Thomas, of Misterton, yeoman 1
4417616 2170395 2170395 plaintiff Howeles Richard chaplain 595081 595081 Howeles, Richard, of Misterton, chaplain 1
4427997 2173597 2173597 plaintiff Houles Richard chaplain 595081 595081 Houles, Richard, of Misterton, chaplain 1
4428250 2173667 2173667 defendant Levesham Richard de   595081 595081 Levesham, Richard de, of Misterton 0
4488201 2197024 2197024 defendant Selby William   595081 595081 Selby, William, of Misterton, son of Walter Selby 0
4574313 2223496 2223496 plaintiff Benman William esq 595081 595081 Benman, William, of Misterton, esq 0
4585733 2226961 2226961 defendant Byggyng William butcher 595081 595081 Byggyng, William, of Misterton, butcher 0
4633360 2241288 2241288 plaintiff Waryn John   595081 595081 Waryn, John, of Misterton 0
4677934 2258715 2258715 defendant Roggerson William husbandman 595081 595081 Roggerson, William, of Misterton, husbandman 2
4727130 2273745 2273745 defendant Be_ Peter yeoman 595081 595081 together with Be_, Peter, of Misterton, yeoman 1
4799987 2296178 2296178 defendant Coker William laborer 595081 595081 Coker, William, of Misterton, laborer 0
4801290 2296592 2296592 defendant Golsby Robert   595081 595081 Golsby, Robert, of Misterton 0
4805792 2298017 2298017 defendant Pulteney Thomas gent 595081 595081 Pulteney, Thomas, of Misterton, gent 0
4858581 2314059 2314059 defendant Hoggekynson William husbandman 595081 595081 Hoggekynson, William, of Misterton, husbandman 0
4858887 2314158 2314158 defendant Hogkynson William husbandman 595081 595081 Hogkynson, William, of Misterton, husbandman 0
4862052 2315142 2315142 defendant Lynderyk William yeoman 595081 595081 Lynderyk, William, of Misterton, yeoman 0
4875514 2319295 2319295 defendant Hogekynson William   595081 595081 Hogekynson, William, of Misterton, franklin 4
4886549 2322656 2322656 defendant Hogekynson William yeoman 595081 595081 Hogekynson, William, of Misterton, yeoman 0
4913662 2330770 2330770 defendant Hogekynson William husbandman 595081 595081 Hogekynson, William, of Misterton, husbandman 0
4913663 2330770 2330770 defendant Haynson Richard husbandman 595081 595081 Haynson, Richard, of Misterton, husbandman 1
4913664 2330770 2330770 defendant Coryngham John husbandman 595081 595081 Coryngham, John, of Misterton, husbandman 2
4913665 2330770 2330770 defendant Dommell John husbandman 595081 595081 Dommell, John, of Misterton, husbandman 3
4938983 2338584 2338584 defendant Rogerson William husbandman 595081 595081 Rogerson, William, of Misterton, husbandman 3
4987395 2353182 2353182 defendant Denman Thomas gent 595081 595081 Denman, Thomas, of Misterton, gent 0
5016730 2361785 2361785 defendant Gryme William husbandman 595081 595081 Gryme, William, of Misterton, husbandman 0
5097377 2385662 2385662 defendant Pulteney John esq 595081 595081 Pulteney, John, of Misterton, esq 0
5150664 2401344 2401344 defendant Pulteney John esq 595081 595081 Pulteney, John, of Misterton, esq 0
5150667 2401345 2401345 defendant Pulteney John esq 595081 595081 Pulteney, John, of Misterton, esq 0
5228592 2423970 2423970 defendant Clerke John husbandman 595081 595081 Clerke, John, of Misterton, husbandman 0
5228593 2423970 2423970 defendant Clerke William husbandman 595081 595081 Clerke, William, of Misterton, husbandman 1
5245027 2428719 2428719 defendant Gansill Robert yeoman 595081 595081 Gansill, Robert, of Misterton, yeoman 5
5245040 2428720 2428720 defendant Gansell Robert yeoman 595081 595081 Gansell, Robert, of Misterton, yeoman 5
5279098 2438996 2438996 defendant Pulteney Thomas gent 595081 595081 Pulteney, Thomas, of Misterton, gent 0
5279099 2438996 2438996 defendant Wyndell William yeoman 595081 595081 Wyndell, William, of Misterton, yeoman 1
5279100 2438996 2438996 defendant Gamell or Gancell Philip yeoman 595081 595081 Gamell or Gancell, Philip, of Misterton, yeoman 2
5279101 2438996 2438996 defendant Broun William yeoman 595081 595081 Broun, William, of Misterton, yeoman 3
5279102 2438996 2438996 defendant Kendale Robert yeoman 595081 595081 Kendale, Robert, of Misterton, yeoman 4
5279106 2438997 2438997 defendant Gancell or Gamel Philip yeoman 595081 595081 Gancell or Gamel, Philip, of Misterton, yeoman 2
5279107 2438997 2438997 defendant Broun William yeoman 595081 595081 Broun, William, of Misterton, yeoman 3
5279108 2438997 2438997 defendant Kendale Robert yeoman 595081 595081 Kendale, Robert, of Misterton, yeoman 4
5279109 2438997 2438997 defendant Bamford William yeoman 595081 595081 Bamford, William, of Misterton, yeoman 5
5354473 2461471 2461471 defendant Poge John gent 595081 595081 Poge, John, of Misterton, gent 0
5416382 2479816 2479816 defendant Lussell William   595081 595081 Lussell, William, of Misterton, husbandman, son & heir of Henry 0
5448974 2489588 2489588 defendant Pulteney Thomas   595081 595081 Pulteney, Thomas, of Misterton 0
5484000 2500149 2500149 defendant Payne Edmund chaplain 595081 595081 Payne, Edmund, of Misterton, chaplain 0
5503435 2505985 2505985 defendant Poge John gent 595081 595081 Poge, John, of Misterton, gent 0
5518948 2510765 2510765 defendant Hane John husbandman 595081 595081 Hane, John,of Misterton, husbandman 0
5525286 2512501 2512501 defendant Poge Thomas gent 595081 595081 Poge, Thomas, of Misterton, gent 0
5536963 2516046 2516046 defendant Clyderowe Robert gent 595081 595081 Clyderowe, Robert, of Misterton, gent 3
5552751 2520853 2520853 defendant Sharpe William yeoman 595081 595081 Sharpe, William, of Misterton, yeoman 2
5558829 2522537 2522537 plaintiff Pulteney Thomas   595081 595081 Pulteney, Thomas, of Misterton, knight 0
5560996 2523186 2523186 defendant Poge Thomas gent 595081 595081 Poge, Thomas, of Misterton, gent 0
5593116 2532831 2532831 defendant Poge Thomas gent 595081 595081 Poge, Thomas, of Misterton, gent 0
5601247 2535280 2535280 defendant Massendale Christopher husbandman 595081 595081 Massendale, Christopher, of Misterton, husbandman 0
5601248 2535280 2535280 defendant Donnell Robert husbandman 595081 595081 Donnell, Robert, of Misterton, husbandman 1
5627840 2552676 2552676 defendant Rider Robert butcher 595081 595081 Rider, Robert, of Misterton, butcher 0
5627842 2552676 2552676 defendant Taillour William husbandman 595081 595081 Taillour, William, of Misterton, husbandman 2
5628619 2552918 2552918 defendant Golsby Robert laborer 595081 595081 Golsby, Robert, of Misterton, laborer 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);