names

94 rows where place_id = 602384

✎ 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
3649885 1910327 1910327 defendant Heron William esq 602384 602384 Heron, William, of Forde, esq 0
3699767 1926151 1926151 defendant Cholles John husbandman 602384 602384 Cholles, John, of Forde, husbandman 0
3705534 1928014 1928014 defendant Russell Edward yeoman 602384 602384 Russell, Edward, of Forde, yeoman 1
3719788 1932452 1932452 defendant Croft Richard esq 602384 602384 Croft, Richard, of Forde, esq 0
3732639 1936440 1936440 defendant Veale Henry husbandman 602384 602384 Veale, Henry, of Forde, husbandman 0
3732640 1936440 1936440 defendant Veale John husbandman 602384 602384 Veale, John, of Forde, husbandman 1
3733197 1936615 1936615 defendant Coby John husbandman 602384 602384 Coby, John, of Forde, husbandman 0
3799279 1957689 1957689 defendant Kebyll John gent 602384 602384 Kebyll, John, of Forde, gent 0
3811992 1961658 1961658 plaintiff Cole John   602384 602384 Cole, John, of Forde 0
3812478 1961791 1961791 defendant Wartore Thomas, senior chapman 602384 602384 Wartore, Thomas, senior, of Forde, chapman 0
3812479 1961791 1961791 defendant Wartore Thomas, junior chapman 602384 602384 Wartore, Thomas, junior, of Forde, chapman 1
3817100 1963262 1963262 defendant Carpenter William yeoman 602384 602384 Carpenter, William, of Forde, yeoman 1
3818585 1963715 1963715 defendant Downer Edward husbandman 602384 602384 Downer, Edward, of Forde, husbandman 0
3861922 1977447 1977447 defendant Hyll Roger gent 602384 602384 Hyll, Roger, of Forde, gent 1
3875276 1981972 1981972 defendant Chudley John gent 602384 602384 Chudley, John, of Forde, gent 0
3942781 2004589 2004589 plaintiff Wylde Richard   602384 602384 Wylde, Richard, of Forde 0
3963215 2011737 2011737 plaintiff Wylde William yeoman 602384 602384 Wylde, William, of Forde, yeoman 0
4050261 2042521 2042521 defendant Berysford John husbandman 602384 602384 Berysford, John, of Forde, husbandman 0
4050262 2042521 2042521 defendant Berisforde Margaret widow 602384 602384 Berisforde, Margaret, of Forde, widow 1
4050264 2042522 2042522 defendant Berysforde John husbandman 602384 602384 Berysforde, John, of Forde, husbandman 0
4050265 2042522 2042522 defendant Berysforde Margaret widow 602384 602384 Berysforde, Margaret, of Forde, widow 1
4082782 2054145 2054145 defendant Carre William gent 602384 602384 Carre, William, of Forde, Cumber, gent 0
4158340 2080988 2080988 defendant Knyght Richard yeoman 602384 602384 Knyght, Richard, of Forde, yeoman 0
4177245 2087509 2087509 defendant Patehall William gent 602384 602384 Patehall, William, of Forde, gent 0
4217682 2101677 2101677 defendant Olyver Thomas husbandman 602384 602384 Olyver, Thomas, of Forde, husbandman 2
4234340 2107547 2107547 defendant Ellice John clerk 602384 602384 Ellice, John, of Forde, clerk 2
4234891 2107756 2107756 defendant Napper John husbandman 602384 602384 Napper, John, of Forde, husbandman 0
4285195 2124755 2124755 defendant Ambler Robert yeoman 602384 602384 Ambler, Robert, of Forde, yeoman 0
4294431 2128092 2128092 defendant Bowden Thomas husbandman 602384 602384 Bowden, Thomas, of Forde, husbandman 1
4297910 2129353 2129353 defendant Slacke William husbandman 602384 602384 Slacke, William, of Forde, husbandman 2
4316652 2135941 2135941 defendant Williams Richard yeoman 602384 602384 Williams, Richard, of Forde, yeoman 1
4321826 2137719 2137719 defendant Knyghte Richard husbandman 602384 602384 Knyghte, Richard, of Forde, husbandman 2
4327747 2139606 2139606 defendant Napper John husbandman 602384 602384 Napper, John, of Forde, husbandman 1
4471321 2191695 2191695 defendant Coupere William   602384 602384 Coupere, William, of Forde 3
4486637 2196531 2196531 defendant Opy Joan daughter of John Opy 602384 602384 Opy, Joan, of Forde, daughter of John Opy 3
4491592 2198055 2198055 defendant Cuttyng William   602384 602384 Cuttyng, William, of Forde 0
4555273 2217584 2217584 defendant Burgeys John   602384 602384 Burgeys, John, of Forde 0
4577297 2224417 2224417 defendant Broke William   602384 602384 Broke, William, of Forde 0
4581050 2225552 2225552 defendant Waltham John   602384 602384 Waltham, John, of Forde 1
4584921 2226716 2226716 defendant Duyk William   602384 602384 Duyk, William, of Forde 0
4602330 2231944 2231944 defendant Screveyn William   602384 602384 Screveyn, William, of Forde 2
4605659 2232889 2232889 defendant Cook William   602384 602384 Cook, William, of Forde 1
4617097 2236355 2236355 defendant Vele Thomas   602384 602384 Vele, Thomas, of Forde 0
4617100 2236356 2236356 defendant Vela John   602384 602384 Vela, John, of Forde 0
4629590 2240181 2240181 defendant Palmer Richard   602384 602384 Palmer, Richard, of Forde 1
4647901 2245455 2245455 defendant Duyk Peter   602384 602384 Duyk, Peter, of Forde 0
4647902 2245455 2245455 defendant Thorn Richard   602384 602384 Thorn, Richard, of Forde 1
4647903 2245455 2245455 defendant Rykon Nicholas   602384 602384 Rykon, Nicholas, of Forde 2
4648051 2245497 2245497 plaintiff St Quintin Anthony de   602384 602384 St Quintin, Anthony de, of Forde, rector 0
4656339 2247876 2247876 defendant Ricon Nicholas husbandman 602384 602384 Ricon, Nicholas, of Forde, husbandman 0
4656876 2248047 2248047 defendant Verby William   602384 602384 Verby, William, of Forde, millward 0
4674373 2257594 2257594 plaintiff Duke Peter   602384 602384 Duke, Peter, of Forde 0
4687485 2261681 2261681 defendant Pery John husbandman 602384 602384 Pery, John, of Forde, husbandman 0
4691656 2262924 2262924 defendant Duyk John weaver 602384 602384 Duyk, John, of Forde, weaver 0
4719797 2271537 2271537 defendant Forde Richard (legal representative) 602384 602384 Forde, Richard, of Forde, chapman, executors of 0
4740438 2277718 2277718 defendant Parker Thomas gent 602384 602384 Parker, Thomas, of Forde, gent 1
4743228 2278546 2278546 defendant Bacon John, junior husbandman 602384 602384 Bacon, John, junior, of Forde, husbandman 0
4748432 2280045 2280045 defendant Baker Henry husbandman 602384 602384 Baker, Henry, of Forde, husbandman 0
4781495 2290223 2290223 defendant Palmer John   602384 602384 Palmer, John, of Forde, ploughwright 0
4785455 2291470 2291470 defendant Swaddyng Thomas yeoman 602384 602384 Swaddyng, Thomas, of Forde, yeoman 1
4785948 2291642 2291642 defendant Ford William husbandman 602384 602384 Ford, William, of Forde, husbandman 1
4831066 2305747 2305747 defendant Odeham John yeoman 602384 602384 Odeham, John, of Forde, yeoman 1
4834551 2306814 2306814 defendant atte Forde Thomas husbandman 602384 602384 atte Forde, Thomas, of Forde, husbandman 2
4855243 2312994 2312994 defendant Grene William chaplain 602384 602384 Grene, William, of Forde, chaplain 0
4930592 2335974 2335974 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
4946052 2340751 2340751 defendant Couper Thomas husbandman 602384 602384 Couper, Thomas, of Forde, husbandman 0
4956052 2343775 2343775 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
4956054 2343776 2343776 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
4975393 2349600 2349600 defendant Pury Thomas yeoman 602384 602384 Pury, Thomas, of Forde, yeoman 2
4980341 2351065 2351065 defendant Poules Richard yeoman 602384 602384 Poules, Richard, of Forde, yeoman 0
4982470 2351675 2351675 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
4982472 2351676 2351676 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
4987019 2353060 2353060 defendant Fichet Philip   602384 602384 Fichet, Philip, of Forde, bailiff 0
5017732 2362062 2362062 defendant Heron John esq 602384 602384 Heron, John, of Forde, esq 0
5040318 2368705 2368705 plaintiff Broun Thomas   602384 602384 Broun, Thomas, of Forde 0
5040321 2368706 2368706 plaintiff Broun Thomas   602384 602384 Broun, Thomas, of Forde 0
5045536 2370293 2370293 defendant Broun Thomas husbandman 602384 602384 Broun, Thomas, of Forde, husbandman 0
5082827 2381369 2381369 defendant Moys John husbandman 602384 602384 Moys, John, of Forde, husbandman 1
5105768 2388135 2388135 plaintiff Cook John   602384 602384 Cook, John, of Forde, or of Fordyngbrygge, "londman" 0
5106771 2388406 2388406 defendant Wattys John husbandman 602384 602384 Wattys, John, of Forde, husbandman 3
5108341 2388875 2388875 defendant Hunte John   602384 602384 Hunte, John, of Forde 1
5130945 2395531 2395531 defendant Smyth Henry smith 602384 602384 Smyth, Henry, of Forde, smith 1
5146039 2399965 2399965 defendant Pernellekyl servant John   602384 602384 Pernellekyl servant, John, of Forde, servant 0
5150394 2401249 2401249 defendant Smyth Henry smith 602384 602384 Smyth, Henry, of Forde, smith 0
5156973 2403181 2403181 defendant Yonge John yeoman 602384 602384 Yonge, John, of Forde, yeoman 0
5162138 2404660 2404660 defendant Power Michael gent 602384 602384 Power, Michael, of Forde, gent 0
5238645 2426897 2426897 defendant Wynneshurst William yeoman 602384 602384 Wynneshurst, William, of Forde, yeoman 0
5371694 2466737 2466737 defendant Dowener John husbandman 602384 602384 Dowener, John, of Forde, husbandman 0
5398714 2474697 2474697 defendant Gylle William   602384 602384 Gylle, William, of Forde, groom 3
5416858 2479962 2479962 defendant Pygot John husbandman 602384 602384 Pygot, John, of Forde, husbandman 2
5421517 2481367 2481367 defendant Pigot John husbandman 602384 602384 Pigot, John, of Forde, husbandman 2
5433843 2485091 2485091 defendant Pygot John husbandman 602384 602384 Pygot, John, of Forde, husbandman 2
5615131 2548524 2548524 plaintiff Fullere Agnes   602384 602384 Fullere, Agnes, of Forde, on her own account 0
5632184 2554091 2554091 defendant Mourton John yeoman 602384 602384 Mourton, John, of Forde, yeoman 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);