names

61 rows where place_id = 589942

✎ 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
3599322 1867432 1867432 defendant Hoggyn William husbandman 589942 589942 Hoggyn, William, of Bobbyng, husbandman 1
3639789 1907255 1907255 defendant Broun Robert husbandman 589942 589942 Broun, Robert, of Bobbyng, husbandman 0
3650581 1910550 1910550 defendant Bayle William husbandman 589942 589942 Bayle, William, of Bobbyng, husbandman 0
3707894 1928766 1928766 defendant Catlotte Thomas husbandman 589942 589942 Catlotte, Thomas, of Bobbyng, husbandman 0
3722466 1933287 1933287 defendant Catlotte William husbandman 589942 589942 Catlotte, William, of Bobbyng, husbandman 1
3750955 1942223 1942223 defendant Bayly William husbandman 589942 589942 Bayly, William, of Bobbyng, husbandman 1
3767455 1947462 1947462 defendant Crouche Henry (legal representative) 589942 589942 Crouche, Henry, of Bobbyng, yeoman, executors of 0
3767456 1947462 1947462 defendant Crouche Elizabeth widow 589942 589942 (Crouche, Elizabeth, of Bobbyng, widow 1
3767458 1947462 1947462 defendant Master Peter husbandman 589942 589942 Master, Peter, of Bobbyng, husbandman 3
3771352 1948732 1948732 plaintiff Style John (legal representative) 589942 589942 Style, John, of Bobbyng, executor of 0
3771357 1948732 1948732 defendant Balye William husbandman 589942 589942 Balye, William, of Bobbyng, husbandman 3
3775255 1949996 1949996 defendant Bayly William husbandman 589942 589942 Bayly, William, of Bobbyng, husbandman 0
3780293 1951566 1951566 defendant Wodde William gent 589942 589942 Wodde, William, of Bobbyng, gent 0
3780297 1951567 1951567 defendant Wodde William gent 589942 589942 Wodde, William, of Bobbyng, gent 0
3821660 1964660 1964660 defendant Wodde William gent 589942 589942 Wodde, William, of Bobbyng, gent 0
3849948 1973571 1973571 defendant Hollyman John husbandman 589942 589942 Hollyman, John, of Bobbyng, husbandman 1
3849951 1973571 1973571 defendant Petynden John husbandman 589942 589942 Petynden, John, of Bobbyng, husbandman 4
3979337 2017359 2017359 defendant Buckmer George husbandman 589942 589942 Buckmer, George, of Bobbyng, husbandman 0
4008472 2027800 2027800 defendant Clifford George esq 589942 589942 Clifford, George, of Bobbyng, esq 0
4012886 2029336 2029336 defendant Sampson Christopher   589942 589942 Sampson, Christopher, of Bobbyng, Kent gent 0
4063984 2047399 2047399 defendant Jenyng John   589942 589942 Jenyng, John, of Bobbyng, wheelwright 0
4483439 2195509 2195509 defendant Michel John   589942 589942 Michel, John, of Bobbyng 0
4483441 2195510 2195510 defendant Michel John   589942 589942 Michel, John, of Bobbyng 0
4559600 2218954 2218954 defendant Cok Geoffrey   589942 589942 Cok, Geoffrey, of Bobbyng 0
4559601 2218954 2218954 defendant Tallour Richard   589942 589942 Tallour, Richard, of Bobbyng 1
4608262 2233692 2233692 defendant atte Meed John   589942 589942 atte Meed, John, of Bobbyng 0
4692361 2263129 2263129 defendant Michel Katherine widow 589942 589942 Michel, Katherine, of Bobbyng, widow 0
4693811 2263567 2263567 defendant Mudle Richard   589942 589942 Mudle, Richard, of Bobbyng, glove maker 0
4693814 2263567 2263567 defendant Halke Adam husbandman 589942 589942 Halke, Adam, of Bobbyng, husbandman 3
4712588 2269256 2269256 defendant Halke Adam husbandman 589942 589942 Halke, Adam, of Bobbyng, husbandman 0
4746025 2279340 2279340 defendant Haukyn John laborer 589942 589942 Haukyn, John, of Bobbyng, laborer 3
4776053 2288508 2288508 defendant Holte Thomas laborer 589942 589942 Holte, Thomas, of Bobbyng, laborer 0
4801880 2296772 2296772 defendant Dane John yeoman 589942 589942 Dane, John, of Bobbyng, yeoman 0
4804703 2297670 2297670 defendant Hugon Luke husbandman 589942 589942 Hugon, Luke, of Bobbyng, husbandman 0
4884204 2321968 2321968 defendant Clyfford William esq 589942 589942 Clyfford, William, of Bobbyng, esq 0
4894513 2324957 2324957 defendant Mede John husbandman 589942 589942 Mede, John, of Bobbyng, husbandman 0
5031577 2366098 2366098 defendant Wodecote Richard yeoman 589942 589942 Wodecote, Richard, of Bobbyng, yeoman 0
5061247 2374945 2374945 defendant atte Water John husbandman 589942 589942 atte Water, John, of Bobbyng, husbandman 3
5081429 2380948 2380948 defendant Bere Arnold husbandman 589942 589942 Bere, Arnold, of Bobbyng, husbandman 6
5081430 2380948 2380948 defendant Thomlyn John husbandman 589942 589942 Thomlyn, John, of Bobbyng, husbandman 7
5266583 2435299 2435299 defendant Newynton William husbandman 589942 589942 Newynton, William, of Bobbyng, husbandman 1
5275441 2437885 2437885 defendant Hillys Alan husbandman 589942 589942 Hillys, Alan, of Bobbyng, husbandman 0
5275989 2438052 2438052 defendant Newynton William yeoman 589942 589942 Newynton, William, of Bobbyng, yeoman 0
5293647 2443104 2443104 defendant Hilles William husbandman 589942 589942 Hilles, William, of Bobbyng, husbandman 0
5293656 2443107 2443107 defendant Hilles Alan husbandman 589942 589942 Hilles, Alan, of Bobbyng, husbandman 0
5315250 2449616 2449616 defendant Hylles Alan husbandman 589942 589942 Hylles, Alan, of Bobbyng, husbandman 0
5329781 2453981 2453981 defendant Lucas Henry husbandman 589942 589942 Lucas, Henry, of Bobbyng, husbandman 1
5329784 2453982 2453982 defendant Lucas Henry husbandman 589942 589942 Lucas, Henry, of Bobbyng, husbandman 1
5337998 2456449 2456449 defendant Hye Thomas smith 589942 589942 Hye, Thomas, of Bobbyng, smith 1
5351043 2460433 2460433 defendant Jakis William laborer 589942 589942 Jakis, William, of Bobbyng, laborer 1
5358593 2462748 2462748 defendant Cay Nicholas laborer 589942 589942 Cay, Nicholas, of Bobbyng, laborer 0
5455706 2491609 2491609 defendant Chamberleyn Thomas smith 589942 589942 Chamberleyn, Thomas, of Bobbyng, smith 3
5467512 2495216 2495216 defendant Chamberleyn Thomas smith 589942 589942 Chamberleyn, Thomas, of Bobbyng, smith 3
5477874 2498404 2498404 defendant Hogyn John husbandman 589942 589942 Hogyn, John, of Bobbyng, husbandman 0
5478803 2498677 2498677 defendant Chamberleyn Thomas smith 589942 589942 Chamberleyn, Thomas, of Bobbyng, smith 3
5545810 2518765 2518765 defendant Quynt John husbandman 589942 589942 Quynt, John, of Bobbyng, husbandman 0
5597498 2534120 2534120 defendant Clyfford Lewis esq 589942 589942 Clyfford, Lewis, of Bobbyng, esq 0
5617056 2549152 2549152 defendant Counsell John   589942 589942 Counsell, John, of Bobbyng 0
5617060 2549154 2549154 defendant Counseyll John   589942 589942 Counseyll, John, of Bobbyng 0
5618925 2549760 2549760 defendant Michel John   589942 589942 Michel, John, of Bobbyng 0
5633401 2554442 2554442 defendant Halke Adam husbandman 589942 589942 Halke, Adam, of Bobbyng, husbandman 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);