names

71 rows where place_id = 679678

✎ 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
4037236 2037981 2037981 defendant Pates John gent 679678 679678 Pates, John, of Buckingham, Bucks, gent 0
4141380 2075142 2075142 defendant Mylling Richard chapman 679678 679678 Mylling, Richard, of Buckingham, Bucks, chapman 0
4258589 2115838 2115838 plaintiff Pates John (legal representative) 679678 679678 Pates, John, of Buckingham, Bucks, gent, administrator of 0
4258593 2115839 2115839 plaintiff Pates John (legal representative) 679678 679678 Pates, John, of Buckingham, Bucks, gent, administrator of 0
4298459 2129551 2129551 defendant Ethersage Hugh cordwainer 679678 679678 Ethersage, Hugh, of Buckingham, Bucks, cordwainer 0
4304290 2131639 2131639 defendant Kyme Thomas dyer 679678 679678 Kyme, Thomas, of Buckingham, Bucks, dyer 0
4327165 2139413 2139413 defendant Rowbottome Lawrence butcher 679678 679678 Rowbottome, Lawrence, of Buckingham, Bucks, butcher 0
4666909 2255381 2255381 defendant Bisckeley John chapman 679678 679678 Bisckeley, John, of Buckingham, Bucks, chapman 0
4687565 2261696 2261696 defendant Blocle John chapman 679678 679678 Blocle, John, of Buckingham, Bucks, chapman 2
4693973 2263623 2263623 defendant Taillour Hugh fisher 679678 679678 Taillour, Hugh, of Buckingham, Bucks, fisher 1
4693981 2263625 2263625 defendant Taillour Hugh fishmonger 679678 679678 Taillour, Hugh, of Buckingham, Bucks, fishmonger 1
4700067 2265443 2265443 defendant Glover William glover maker 679678 679678 Glover, William, of Buckingham, Bucks, glover maker 3
4712606 2269261 2269261 defendant Taillour Richard tailor 679678 679678 Taillour, Richard, of Buckingham, Bucks, tailor 1
4828671 2305010 2305010 defendant Bedewynde John husbandman 679678 679678 Bedewynde, John, of Buckingham, Bucks, husbandman 3
4828677 2305011 2305011 defendant Bedewynde John husbandman 679678 679678 Bedewynde, John, of Buckingham, Bucks, husbandman 3
4830397 2305541 2305541 defendant Preket John husbandman 679678 679678 Preket, John, of Buckingham, Bucks, husbandman 2
4835765 2307182 2307182 defendant Bekle Richard   679678 679678 Bekle, Richard, of Buckingham, Bucks, servant 0
4846722 2310482 2310482 defendant Smyth John yeoman 679678 679678 Smyth, John, of Buckingham, Bucks, yeoman 0
4854035 2312670 2312670 defendant Webbe Robert yeoman 679678 679678 Webbe, Robert, of Buckingham, Bucks, yeoman 0
4909511 2329511 2329511 defendant Worlat William laborer 679678 679678 Worlat, William, of Buckingham, Bucks, laborer 0
4909514 2329512 2329512 defendant Worlat William laborer 679678 679678 Worlat, William, of Buckingham, Bucks, laborer 0
4909520 2329514 2329514 defendant Whorlat William laborer 679678 679678 Whorlat, William, of Buckingham, Bucks, laborer 0
4916774 2331751 2331751 defendant Yonge John taverner 679678 679678 Yonge, John, of Buckingham, Bucks, taverner 0
4920601 2332957 2332957 defendant Wodeward Thomas husbandman 679678 679678 Wodeward, Thomas, of Buckingham, Bucks, husbandman 0
4932796 2336643 2336643 defendant Albon Getyg sadler 679678 679678 Albon, Getyg, of Buckingham, Bucks, sadler 0
4985978 2352724 2352724 defendant Floure William esq 679678 679678 Floure, William, of Buckingham, Bucks, esq 0
4992237 2354570 2354570 defendant Foulere William gent 679678 679678 Foulere, William, of Buckingham, Bucks, gent 0
4992906 2354758 2354758 defendant Bedewynd John, sen husbandman 679678 679678 Bedewynd, John, sen, of Buckingham, Bucks, husbandman 0
4999995 2356880 2356880 defendant Fowler William gent 679678 679678 Fowler, William, of Buckingham, Bucks, gent 0
5038977 2368303 2368303 defendant Fouler William esq 679678 679678 Fouler, William, of Buckingham, Bucks, esq 0
5039364 2368418 2368418 defendant Alwey William, junior   679678 679678 Alwey, William, junior, of Buckingham, Bucks, servant 0
5046577 2370614 2370614 defendant Jones Simon chapman 679678 679678 Jones, Simon, of Buckingham, Bucks, chapman 2
5173137 2407854 2407854 defendant Sambroke William gent 679678 679678 Sambroke, William, of Buckingham, Bucks, gent 0
5188502 2412356 2412356 defendant Sambroke William gent 679678 679678 Sambroke, William, of Buckingham, Bucks, gent 0
5192961 2413669 2413669 defendant Sambroke William gent 679678 679678 Sambroke, William, of Buckingham, Bucks, gent 0
5192966 2413670 2413670 defendant Sambroke William gent 679678 679678 Sambroke, William, of Buckingham, Bucks, gent 0
5204902 2417185 2417185 defendant Bekley Richard carpetner 679678 679678 Bekley, Richard, of Buckingham, Bucks, carpetner 0
5206077 2417511 2417511 defendant Sambroke William gent 679678 679678 Sambroke, William, of Buckingham, Bucks, gent 0
5270075 2436353 2436353 defendant Fox Richard dyer 679678 679678 Fox, Richard, of Buckingham, Bucks, dyer 0
5271999 2436892 2436892 defendant Benet Thomas chapman 679678 679678 Benet, Thomas, of Buckingham, Bucks, chapman 4
5300337 2445058 2445058 defendant Daysun William yeoman alias merchant 679678 679678 Daysun, William, of Buckingham, Bucks, yeoman alias merchant 0
5302272 2445642 2445642 defendant Dayson William woolman 679678 679678 Dayson, William, of Buckingham, Bucks, woolman 0
5304165 2446254 2446254 defendant Dayson William yeoman 679678 679678 Dayson, William, of Buckingham, Bucks, yeoman 0
5365390 2464850 2464850 defendant Terry John chapman 679678 679678 Terry, John, of Buckingham, Bucks, chapman 1
5365808 2464960 2464960 defendant Henkyns Robert chapman 679678 679678 Henkyns, Robert, of Buckingham, Bucks, chapman 2
5380177 2469378 2469378 defendant Horwode Hugh dyer 679678 679678 Horwode, Hugh, of Buckingham, Bucks, dyer 1
5385161 2470830 2470830 defendant Terry William woolman 679678 679678 Terry, William, of Buckingham, Bucks, woolman 0
5391827 2472737 2472737 defendant Terry John chapman 679678 679678 Terry, John, of Buckingham, Bucks, chapman 0
5422979 2481824 2481824 defendant Attelbury William dyer 679678 679678 Attelbury, William, of Buckingham, Bucks, dyer 0
5423420 2481965 2481965 defendant Haukyns Robert yeoman 679678 679678 Haukyns, Robert, of Buckingham, Bucks, yeoman 3
5433384 2484943 2484943 defendant Terry William   679678 679678 Terry, William, of Buckingham, Bucks, wool man 0
5433387 2484944 2484944 defendant Terry William woolman 679678 679678 Terry, William, of Buckingham, Bucks, woolman 0
5434126 2485162 2485162 defendant Tarre John mercer 679678 679678 (Tarre, John, of Buckingham, Bucks, mercer 2
5434131 2485163 2485163 defendant Tarre John mercer 679678 679678 (Tarre, John, of Buckingham, Bucks, mercer 2
5439226 2486660 2486660 defendant Vaux Edmund draper 679678 679678 Vaux, Edmund, of Buckingham, Bucks, draper 1
5442388 2487645 2487645 defendant Terry John, junior mercer 679678 679678 Terry, John, junior, of Buckingham, Bucks, mercer 1
5442401 2487648 2487648 defendant Terry John, junior mercer 679678 679678 Terry, John, junior, of Buckingham, Bucks, mercer 1
5442727 2487737 2487737 defendant Haukyns Robert yeoman 679678 679678 Haukyns, Robert, of Buckingham, Bucks, yeoman 0
5449602 2489773 2489773 defendant Tarre John   679678 679678 Tarre, John, of Buckingham, Bucks 1
5455153 2491459 2491459 defendant Terry John mercer 679678 679678 Terry, John, of Buckingham, Bucks, mercer 2
5456889 2491966 2491966 defendant Fowe_ Thomas esq 679678 679678 Fowe_, Thomas, of Buckingham, Bucks, esq 0
5456893 2491967 2491967 defendant Foweler Thomas esq 679678 679678 Foweler, Thomas, of Buckingham, Bucks, esq 0
5456897 2491968 2491968 defendant Foweler Thomas esq 679678 679678 Foweler, Thomas, of Buckingham, Bucks, esq 0
5456901 2491969 2491969 defendant Fowler Thomas esq 679678 679678 Fowler, Thomas, of Buckingham, Bucks, esq 0
5457679 2492195 2492195 defendant Fox Richard dyer 679678 679678 Fox, Richard, of Buckingham, Bucks, dyer 2
5466983 2495072 2495072 defendant Terry John mercer 679678 679678 Terry, John, of Buckingham, Bucks, mercer 2
5469507 2495803 2495803 defendant Fox Richard dyer 679678 679678 Fox, Richard, of Buckingham, Bucks, dyer 2
5472009 2496588 2496588 defendant Fouler Thomas esq 679678 679678 Fouler, Thomas, of Buckingham, Bucks, esq 2
5568114 2525221 2525221 defendant Gomerey alias Strenger William chapman 679678 679678 Gomerey alias Strenger, William, of Buckingham, Bucks, chapman 0
5608834 2537664 2537664 defendant Terre John, junior chapman 679678 679678 Terre, John, junior, of Buckingham, Bucks, chapman 1
5609339 2537820 2537820 defendant Benet Thomas chapman 679678 679678 Benet, Thomas, of Buckingham, Bucks, chapman 4

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