names

180 rows where place_id = 590966

✎ 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
3602843 1868559 1868559 defendant Erle John husbandman 590966 590966 Erle, John, of Byntre, husbandman 1
3662726 1914260 1914260 defendant Brose Thomas husbandman 590966 590966 Brose, Thomas, of Byntre, husbandman 0
3768778 1947885 1947885 defendant Anyell John miller 590966 590966 Anyell, John, of Byntre, miller 2
3832904 1968216 1968216 defendant Salver Hugh husbandman 590966 590966 Salver, Hugh, of Byntre, husbandman 1
3832905 1968216 1968216 defendant Frankleyn John (legal representative) 590966 590966 Frankleyn, John, of Byntre, butcher, executors of 2
3832906 1968216 1968216 defendant Frankleyn Thomas husbandman 590966 590966 (Frankleyn, Thomas, of Byntre, husbandman 3
3832907 1968216 1968216 defendant Frankleyn John husbandman 590966 590966 Frankleyn, John, of Byntre, husbandman 4
3840129 1970485 1970485 defendant Elys John   590966 590966 Elys, John, of Byntre, wheelwright 0
3950209 2007157 2007157 defendant Yarham Henry joiner 590966 590966 Yarham, Henry, of Byntre, joiner 2
3957936 2009838 2009838 defendant Francklyn Richard butcher 590966 590966 Francklyn, Richard, of Byntre, butcher 1
3990003 2021177 2021177 defendant Everard Thomas husbandman 590966 590966 Everard, Thomas, of Byntre, husbandman 0
3990068 2021202 2021202 plaintiff Beles George   590966 590966 Beles, George, of Byntre 0
3998174 2024094 2024094 defendant Francklyn John husbandman 590966 590966 Francklyn, John, of Byntre, husbandman 0
4020553 2032078 2032078 defendant Hansor John husbandman 590966 590966 Hansor, John, of Byntre, husbandman 1
4127141 2069995 2069995 defendant Francklyn Thomas yeoman 590966 590966 Francklyn, Thomas, of Byntre, yeoman 0
4225325 2104324 2104324 defendant Rook William gent 590966 590966 Rook, William, of Byntre, gent 0
4242169 2110373 2110373 defendant Rook William gent 590966 590966 Rook, William, of Byntre, gent 0
4246739 2111888 2111888 defendant Havere Gaddeus gent 590966 590966 Havere, Gaddeus, of Byntre, gent 1
4246744 2111889 2111889 defendant Havers Gabden gent 590966 590966 Havers, Gabden, of Byntre, gent 1
4250795 2113243 2113243 defendant Francklyn William yeoman 590966 590966 Francklyn, William, of Byntre, yeoman 0
4256430 2115120 2115120 defendant Westgate Richard yeoman 590966 590966 Westgate, Richard, of Byntre, yeoman 0
4318915 2136729 2136729 defendant Havers Gawdus gent 590966 590966 Havers, Gawdus, of Byntre, gent 1
4353617 2148487 2148487 defendant Francklyn William yeoman 590966 590966 Francklyn, William, of Byntre, yeoman 0
4370558 2154521 2154521 defendant Curson Thomas esq 590966 590966 Curson, Thomas, of Byntre, esq 0
4378323 2157318 2157318 defendant Hunt William gent 590966 590966 Hunt, William, of Byntre, gent 0
4396421 2163377 2163377 defendant Graye Peter husbandman 590966 590966 Graye, Peter, of Byntre, husbandman 0
4398322 2164020 2164020 defendant Curson Thomas esq 590966 590966 Curson, Thomas, of Byntre, esq 0
4407428 2167047 2167047 defendant Francklyn William yeoman 590966 590966 Francklyn, William, of Byntre, yeoman 0
4408005 2167245 2167245 defendant Hunt William gent 590966 590966 Hunt, William, of Byntre, gent 0
4421729 2171679 2171679 plaintiff Curszoun Thomas   590966 590966 Curszoun, Thomas, of Byntre 0
4442385 2182559 2182559 defendant atte Boure Henry   590966 590966 atte Boure, Henry, of Byntre 0
4445766 2183617 2183617 plaintiff Curszon Thomas   590966 590966 Curszon, Thomas, of Byntre 0
4449693 2184852 2184852 defendant Denk John   590966 590966 Denk, John, of Byntre 0
4473495 2192374 2192374 plaintiff Cursoun Thomas   590966 590966 Cursoun, Thomas, of Byntre 0
4477355 2193580 2193580 defendant Barbour John   590966 590966 Barbour, John, of Byntre 10
4498681 2200224 2200224 defendant Hastyng Edmund   590966 590966 Hastyng, Edmund, of Byntre 0
4511677 2204099 2204099 defendant Curson Thomas   590966 590966 Curson, Thomas, of Byntre 1
4555025 2217502 2217502 defendant Clerk Adam   590966 590966 Clerk, Adam, of Byntre 0
4560872 2219355 2219355 defendant Averedus Andrew   590966 590966 Averedus, Andrew, of Byntre 7
4560881 2219356 2219356 defendant Averedus Andrew   590966 590966 Averedus, Andrew, of Byntre 7
4564239 2220385 2220385 defendant Curson Thomas   590966 590966 Curson, Thomas, of Byntre 0
4570583 2222375 2222375 defendant Curson Thomas   590966 590966 Curson, Thomas, of Byntre 0
4572477 2222931 2222931 defendant Wottes Adam   590966 590966 Wottes, Adam, of Byntre 0
4585551 2226903 2226903 defendant Dedmor James   590966 590966 Dedmor, James, of Byntre 0
4594032 2229397 2229397 defendant Dedmor James   590966 590966 Dedmor, James, of Byntre 1
4598364 2230729 2230729 defendant Bedmor James   590966 590966 Bedmor, James, of Byntre 2
4600079 2231252 2231252 defendant Colyn James   590966 590966 Colyn, James, of Byntre 5
4600086 2231253 2231253 defendant Colyn James   590966 590966 Colyn, James, of Byntre 5
4615429 2235835 2235835 plaintiff Fauconer Peter   590966 590966 Fauconer, Peter, of Byntre 0
4633232 2241261 2241261 defendant Clerk Adam   590966 590966 Clerk, Adam, of Byntre 3
4676788 2258361 2258361 defendant Romle William clerk 590966 590966 Romle, William, of Byntre, clerk 1
4678449 2258867 2258867 defendant atte Bowre Hugh husbandman 590966 590966 atte Bowre, Hugh, of Byntre, husbandman 2
4681670 2259877 2259877 defendant Smyth Robert yeoman 590966 590966 Smyth, Robert, of Byntre, yeoman 0
4685272 2260990 2260990 defendant Burton John husbandman 590966 590966 Burton, John, of Byntre, husbandman 2
4688202 2261877 2261877 defendant Howes Edmun husbandman 590966 590966 Howes, Edmun, of Byntre, husbandman 3
4690579 2262606 2262606 defendant Deye John plumber 590966 590966 Deye, John, of Byntre, plumber 7
4698560 2265022 2265022 defendant atte Boure Hugh yeoman 590966 590966 atte Boure, Hugh, of Byntre, yeoman 0
4709113 2268215 2268215 defendant Cokefeld William husbandman 590966 590966 Cokefeld, William, of Byntre, husbandman 3
4730159 2274631 2274631 defendant Neweman John yeoman 590966 590966 (Neweman, John, of Byntre, yeoman 3
4731217 2274961 2274961 defendant Hastyng Alice (legal representative) 590966 590966 Hastyng, Alice, of Byntre, executor of 2
4745828 2279285 2279285 defendant Dykere Hugh yeoman 590966 590966 Dykere, Hugh, of Byntre, yeoman 3
4749148 2280234 2280234 plaintiff Neweman John   590966 590966 Neweman, John, of Byntre, on his own account 0
4754570 2281810 2281810 defendant Rous Edmund   590966 590966 Rous, Edmund, of Byntre 3
4758885 2283129 2283129 defendant Neweman John yeoman 590966 590966 Neweman, John, of Byntre, yeoman 1
4770970 2286898 2286898 defendant Hanne John husbandman 590966 590966 Hanne, John, of Byntre, husbandman 2
4785821 2291599 2291599 defendant Symmys Geoffrey   590966 590966 Symmys, Geoffrey, of Byntre, bailiff 1
4793167 2293960 2293960 defendant Boure Hugh yeoman 590966 590966 Boure, Hugh, of Byntre, yeoman 0
4793169 2293960 2293960 defendant Rous Edmund yeoman 590966 590966 Rous, Edmund, of Byntre, yeoman 2
4795797 2294834 2294834 defendant Hanne John husbandman 590966 590966 Hanne, John, of Byntre, husbandman 2
4797369 2295348 2295348 defendant Rummeley William clerk 590966 590966 Rummeley, William, of Byntre, clerk 4
4818765 2301956 2301956 defendant Rust Robert carpenter 590966 590966 Rust, Robert, of Byntre, carpenter 0
4819188 2302080 2302080 defendant Neweman John yeoman 590966 590966 Neweman, John, of Byntre, yeoman 2
4837192 2307585 2307585 defendant Neweman John yeoman 590966 590966 Neweman, John, of Byntre, yeoman 1
4839595 2308302 2308302 defendant Neweman John yeoman 590966 590966 Neweman, John, of Byntre, yeoman 1
4897826 2325984 2325984 defendant Erle John husbandman 590966 590966 Erle, John, of Byntre, husbandman 0
4930007 2335793 2335793 defendant Man William husbandman 590966 590966 Man, William, of Byntre, husbandman 2
4941600 2339392 2339392 defendant Man William husbandman 590966 590966 Man, William, of Byntre, husbandman 1
4964626 2346325 2346325 defendant Neweman John yeoman 590966 590966 Neweman, John, of Byntre, yeoman 0
5044166 2369882 2369882 defendant Erle John smith 590966 590966 Erle, John, of Byntre, smith 0
5061242 2374944 2374944 defendant Frankeleyn William husbandman 590966 590966 Frankeleyn, William, of Byntre, husbandman 0
5062468 2375342 2375342 defendant Frankeleyn William yeoman 590966 590966 Frankeleyn, William, of Byntre, yeoman 0
5079156 2380251 2380251 defendant Den Andrew clerk 590966 590966 Den, Andrew, of Byntre, clerk 2
5080487 2380655 2380655 defendant Erle John smith 590966 590966 Erle, John, of Byntre, smith 0
5081233 2380892 2380892 defendant Frankeleyn William hsbandman 590966 590966 Frankeleyn, William, of Byntre, hsbandman 0
5081234 2380892 2380892 defendant Bere William miller 590966 590966 Bere, William, of Byntre, miller 1
5091059 2383780 2383780 defendant Bere William miller 590966 590966 Bere, William, of Byntre, miller 0
5092389 2384152 2384152 defendant Mackes Reginald husbandman 590966 590966 Mackes, Reginald, of Byntre, husbandman 0
5095240 2385024 2385024 defendant Holley Robert yeoman 590966 590966 Holley, Robert, of Byntre, yeoman 3
5101032 2386715 2386715 defendant Palmer Henry husbandman 590966 590966 Palmer, Henry, of Byntre, husbandman 2
5108433 2388901 2388901 defendant Syvyer alias Athewold Ralph husbandman 590966 590966 Syvyer alias Athewold, Ralph, of Byntre, husbandman 0
5115394 2390930 2390930 defendant Bere William husbandman 590966 590966 Bere, William, of Byntre, husbandman 2
5117378 2391516 2391516 defendant Den Andrew clerk 590966 590966 Den, Andrew, of Byntre, clerk 0
5125475 2393936 2393936 defendant Den Andrew clerk 590966 590966 Den, Andrew, of Byntre, clerk 0
5131411 2395676 2395676 defendant Den Andrew clerk 590966 590966 Den, Andrew, of Byntre, clerk 0
5137370 2397443 2397443 defendant Den Andrew clerk 590966 590966 Den, Andrew, of Byntre, clerk 0
5139796 2398116 2398116 defendant Den Andrew   590966 590966 Den, Andrew, of Byntre 3
5142425 2398909 2398909 defendant Thornham William husbandman 590966 590966 (Thornham, William, of Byntre, husbandman 1
5142426 2398909 2398909 defendant Isabel formerly wife of Testator, husbandman 590966 590966 Isabel, formerly wife of Testator, of Byntre, husbandman 2
5158010 2403467 2403467 defendant Deen Andrew clerk 590966 590966 Deen, Andrew, of Byntre, clerk 0
5163722 2405125 2405125 defendant Franckelyn John, sen (legal representative) 590966 590966 Franckelyn, John, sen, of Byntre, husbandman, formerly executor of William Franckelyn, of Byntre, yeoman, executors of 0

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