names

77 rows where place_id = 609829

✎ 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
3680541 1919995 1919995 defendant Phelips Richard gent 609829 609829 Phelips, Richard, of Poole, Dorset, gent 4
3708020 1928806 1928806 defendant Philips Richard gent 609829 609829 Philips, Richard, of Poole, Dorset, gent 0
3824736 1965612 1965612 plaintiff Whyte Thomas merchant 609829 609829 Whyte, Thomas, of Poole, Dorset, merchant 0
3921456 1997520 1997520 defendant Lobbe Edward merchant 609829 609829 Lobbe, Edward, of Poole, Dorset, merchant 0
3948205 2006435 2006435 plaintiff Croke John merchant 609829 609829 Croke, John, of Poole, Dorset, merchant 0
3962882 2011610 2011610 defendant Colston Robert merchant 609829 609829 Colston, Robert, of Poole, Dorset, merchant 0
3966416 2012887 2012887 defendant Cowper William gent 609829 609829 Cowper, William, of Poole, Dorset, gent 0
3968861 2013737 2013737 defendant Gylford John merchant 609829 609829 Gylford, John, of Poole, Dorset, merchant 0
3973215 2015203 2015203 plaintiff Grene David merchant 609829 609829 Grene, David, of Poole, Dorset, merchant 0
3978735 2017139 2017139 defendant Constantyne William merchant 609829 609829 Constantyne, William, of Poole, Dorset, merchant, son, factor and attorney to Philip a Constandyne, of Chester, merchant 0
3981904 2018288 2018288 plaintiff Rogers John merchant 609829 609829 Rogers, John, of Poole, Dorset, merchant 0
3995679 2023199 2023199 plaintiff Croke John gent 609829 609829 Croke, John, of Poole, Dorset, gent 0
4000577 2024976 2024976 plaintiff Grene William merchant 609829 609829 Grene, William, of Poole, Dorset, merchant 0
4002746 2025749 2025749 plaintiff Hill Peter merchant 609829 609829 Hill, Peter, of Poole, Dorset, merchant 0
4003229 2025916 2025916 defendant Dicker William merchant 609829 609829 Dicker, William, of Poole, Dorset, merchant 0
4003231 2025917 2025917 defendant Dicker William merchant 609829 609829 Dicker, William, of Poole, Dorset, merchant 0
4003233 2025918 2025918 defendant Dycker William merchant 609829 609829 Dycker, William, of Poole, Dorset, merchant 0
4005300 2026675 2026675 defendant Rose Christopher merchant 609829 609829 Rose, Christopher, of Poole, Dorset, merchant 0
4006078 2026945 2026945 plaintiff Laver William merchant 609829 609829 Laver, William, of Poole, Dorset, merchant 0
4006386 2027061 2027061 defendant Hancoke John merchant 609829 609829 Hancoke, John, of Poole, Dorset, merchant 0
4010550 2028546 2028546 defendant Coulston Robert merchant 609829 609829 Coulston, Robert, of Poole, Dorset, merchant 0
4016412 2030571 2030571 defendant Constantyne William gent 609829 609829 Constantyne, William, of Poole, Dorset, gent 0
4018100 2031193 2031193 plaintiff Tuppe Thomas draper 609829 609829 Tuppe, Thomas, of Poole, Dorset, draper 0
4023888 2033247 2033247 defendant Alyson Walter tailor 609829 609829 Alyson, Walter, of Poole, Dorset, tailor 0
4023900 2033252 2033252 defendant Alyson Walter tailor 609829 609829 Alyson, Walter, of Poole, Dorset, tailor 0
4024976 2033596 2033596 defendant Allyson Walter tailor 609829 609829 Allyson, Walter, of Poole, Dorset, tailor 0
4024984 2033599 2033599 defendant Allyson Walter tailor 609829 609829 Allyson, Walter, of Poole, Dorset, tailor 0
4026372 2034075 2034075 plaintiff Byddelcome William merchant 609829 609829 Byddelcome, William, of Poole, Dorset, merchant 0
4032910 2036420 2036420 defendant Reade William merchant 609829 609829 Reade, William, of Poole, Dorset, merchant 0
4035652 2037427 2037427 defendant Bungaley William merchant 609829 609829 Bungaley, William, of Poole, Dorset, merchant 0
4035654 2037428 2037428 defendant Bungeley William merchant 609829 609829 Bungeley, William, of Poole, Dorset, merchant 0
4040138 2038976 2038976 defendant Grene David merchant 609829 609829 Grene, David, of Poole, Dorset, merchant 0
4040140 2038977 2038977 defendant Grene David merchant 609829 609829 Grene, David, of Poole, Dorset, merchant 0
4040143 2038978 2038978 defendant Grene David merchant 609829 609829 Grene, David, of Poole, Dorset, merchant 0
4061455 2046496 2046496 defendant Meryett William merchant 609829 609829 Meryett, William, of Poole, Dorset, merchant 0
4078791 2052709 2052709 defendant Harward Joan widow 609829 609829 Harward, Joan, of Poole, Dorset, widow 1
4084721 2054806 2054806 defendant Dyker William merchant 609829 609829 Dyker, William, of Poole, Dorset, merchant 0
4094469 2058361 2058361 defendant Skutte William beer brewer 609829 609829 Skutte, William, of Poole, Dorset, beer brewer 0
4094471 2058362 2058362 defendant Skutte William brewer 609829 609829 Skutte, William, of Poole, Dorset, brewer 0
4100326 2060450 2060450 defendant Newman John merchant 609829 609829 Newman, John, of Poole, Dorset, merchant 0
4115367 2065787 2065787 defendant Bennett Eleanor widow 609829 609829 (Bennett, Eleanor, of Poole, Dorset, widow 1
4115390 2065792 2065792 defendant Rose Christopher merchant 609829 609829 Rose, Christopher, of Poole, Dorset, merchant 0
4115395 2065793 2065793 defendant Grene Roger mariner 609829 609829 Grene, Roger, of Poole, Dorset, mariner 1
4120532 2067620 2067620 defendant Bedlecombe William merchant 609829 609829 Bedlecombe, William, of Poole, Dorset, merchant 0
4120564 2067632 2067632 defendant Bodelcombe William merchant 609829 609829 Bodelcombe, William, of Poole, Dorset, merchant 0
4125279 2069327 2069327 defendant Dicker William merchant 609829 609829 Dicker, William, of Poole, Dorset, merchant 0
4125755 2069494 2069494 defendant Robson Robert mariner 609829 609829 Robson, Robert, of Poole, Dorset, mariner 0
4135808 2073135 2073135 defendant Laycolt Richard gent 609829 609829 Laycolt, Richard, of Poole, Dorset, gent 0
4144565 2076258 2076258 defendant Goddard Grace widow 609829 609829 Goddard, Grace, of Poole, Dorset, widow 2
4173841 2086305 2086305 defendant Constantyne William Customer of port of Poole 609829 609829 Constantyne, William, of Poole, Dorset, gent, Customer of port of Poole 0
4173859 2086312 2086312 defendant Robson Robert mariner 609829 609829 Robson, Robert, of Poole, Dorset, mariner 0
4196275 2094242 2094242 defendant Reade James merchant 609829 609829 Reade, James, of Poole, Dorset, merchant 1
4208099 2098391 2098391 defendant Havye Michael mariner 609829 609829 Havye, Michael, of Poole, Dorset, mariner 2
4253037 2114008 2114008 defendant Gregorye Robert merchant 609829 609829 Gregorye, Robert, of Poole, Dorset, merchant 0
4294606 2128154 2128154 defendant Dobyns John merchant 609829 609829 Dobyns, John, of Poole, Dorset, or of Bristol, merchant 0
4299711 2129983 2129983 defendant Newes Thomas mariner 609829 609829 Newes, Thomas, of Poole, Dorset, mariner 2
4328065 2139704 2139704 defendant Havylond John yeoman 609829 609829 Havylond, John, of Poole, Dorset, yeoman 1
4332592 2141188 2141188 defendant Dobbyns John merchant 609829 609829 Dobbyns, John, of Poole, Dorset, merchant 0
4333139 2141370 2141370 defendant Newes Thomas mariner 609829 609829 Newes, Thomas, of Poole, Dorset, mariner 2
4350860 2147555 2147555 defendant Dobbyns John merchant 609829 609829 Dobbyns, John, of Poole, Dorset, merchant 0
4352135 2147980 2147980 defendant Robert Thomas mercer 609829 609829 Robert, Thomas, of Poole, Dorset, mercer 0
4693186 2263371 2263371 defendant Waryner William merchant 609829 609829 Waryner, William, of Poole, Dorset, merchant 0
4693508 2263472 2263472 defendant Gyle Laurence shipman 609829 609829 Gyle, Laurence, of Poole, Dorset, shipman 0
4695881 2264196 2264196 defendant Warner William   609829 609829 Warner, William, of Poole, Dorset, burgess & merchant 0
4772118 2287252 2287252 defendant Warner William merchant 609829 609829 Warner, William, of Poole, Dorset, merchant 2
4774734 2288089 2288089 plaintiff Warner William   609829 609829 Warner, William, of Poole, Dorset 0
4832391 2306165 2306165 defendant Warner William merchant 609829 609829 Warner, William, of Poole, Dorset, merchant 0
4846957 2310554 2310554 defendant Davy John merchant 609829 609829 Davy, John, of Poole, Dorset, merchant 0
4908959 2329346 2329346 defendant Rede Robert merchant 609829 609829 Rede, Robert, of Poole, Dorset, merchant 0
4914399 2331022 2331022 defendant Baylyf Thomas butcher 609829 609829 Baylyf, Thomas, of Poole, Dorset, butcher 0
5156896 2403165 2403165 defendant Lambard Robert yeoman 609829 609829 Lambard, Robert, of Poole, Dorset, yeoman 1
5172941 2407808 2407808 defendant Lambard Robert yeoman 609829 609829 Lambard, Robert, of Poole, Dorset, yeoman 1
5194840 2414235 2414235 defendant Lambard Robert yeoman 609829 609829 Lambard, Robert, of Poole, Dorset, yeoman 0
5282526 2439949 2439949 defendant Thomas John (legal representative) 609829 609829 Thomas, John, of Poole, Dorset, executrix of 0
5300843 2445212 2445212 defendant Broke John merchant 609829 609829 Broke, John, of Poole, Dorset, merchant 0
5304875 2446462 2446462 defendant Whyte William husbandman 609829 609829 Whyte, William, of Poole, Dorset, husbandman 0
5428286 2483384 2483384 defendant Nanby John gent 609829 609829 Nanby, John, of Poole, Dorset, 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);