names

56 rows where place_id = 592276

✎ 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
3607166 1869906 1869906 defendant Fox Richard dyer 592276 592276 Fox, Richard, of Bukyngham, dyer 0
3609226 1870547 1870547 defendant Fox Edmund draper or hosier 592276 592276 Fox, Edmund, of Bukyngham, draper or hosier 0
3626247 1903066 1903066 defendant Isham alias Wolwynder John woolwinder 592276 592276 Isham alias Wolwynder, John, of Bukyngham, woolwinder 0
3637842 1906652 1906652 defendant Slothe William chapman 592276 592276 Slothe, William, of Bukyngham, chapman 2
3654303 1911605 1911605 defendant Grace Robert mercer 592276 592276 Grace, Robert, of Bukyngham, mercer 0
3657285 1912537 1912537 defendant Cancelar Henry   592276 592276 Cancelar, Henry, of Bukyngham, holy water clerk 1
3657286 1912537 1912537 defendant Grace Robert mercer 592276 592276 Grace, Robert, of Bukyngham, mercer 2
3657288 1912537 1912537 defendant Mowerye Peter   592276 592276 Mowerye, Peter, of Bukyngham, hat maker 4
3665156 1915055 1915055 defendant Cowper Richard yeoman 592276 592276 Cowper, Richard, of Bukyngham, yeoman 0
3665157 1915055 1915055 defendant Reve William husbandman 592276 592276 Reve, William, of Bukyngham, husbandman 1
3665618 1915197 1915197 defendant Baxter John joiner 592276 592276 Baxter, John, of Bukyngham, joiner 1
3715023 1930993 1930993 defendant Galley Robert yeoman 592276 592276 (Galley, Robert, of Bukyngham, yeoman 1
3721542 1933043 1933043 defendant Lychefeld Margaret widow 592276 592276 Lychefeld, Margaret, of Bukyngham, widow 0
3721543 1933043 1933043 defendant Lychefeld Hugh gent 592276 592276 Lychefeld, Hugh, of Bukyngham, gent 1
3721547 1933044 1933044 defendant Lychefeld Margaret widow 592276 592276 Lychefeld, Margaret, of Bukyngham, widow 0
3721548 1933044 1933044 defendant Lychefeld Hugh gent 592276 592276 Lychefeld, Hugh, of Bukyngham, gent 1
3751093 1942270 1942270 defendant Bettys John husbandman 592276 592276 Bettys, John, of Bukyngham, husbandman 0
3751096 1942270 1942270 defendant Bristo Thomas husbandman 592276 592276 Bristo, Thomas, of Bukyngham, husbandman 3
3751097 1942270 1942270 defendant brewester Robert tailor 592276 592276 brewester, Robert, of Bukyngham, tailor 4
3765718 1946943 1946943 defendant Herde William saddler 592276 592276 Herde, William, of Bukyngham, saddler 1
3774027 1949591 1949591 defendant Galley Robert yeoman 592276 592276 Galley, Robert, of Bukyngham, yeoman 0
3812900 1961929 1961929 defendant Nurse Richard butcher 592276 592276 Nurse, Richard, of Bukyngham, butcher 0
3816116 1962942 1962942 defendant Clerk Richard yeoman 592276 592276 Clerk, Richard, of Bukyngham, yeoman 0
3831427 1967716 1967716 defendant Blokley alias Adkyns Thomas yeoman 592276 592276 Blokley alias Adkyns, Thomas, of Bukyngham, yeoman 0
3845373 1972114 1972114 defendant Slye John mercer 592276 592276 Slye, John, of Bukyngham, mercer 0
3850020 1973593 1973593 defendant Smyth Richard mercer 592276 592276 Smyth, Richard, of Bukyngham, mercer 0
3852810 1974485 1974485 defendant Haward George clerk 592276 592276 Haward, George, of Bukyngham, clerk 0
3856842 1975766 1975766 defendant Grace Robert chapman 592276 592276 Grace, Robert, of Bukyngham, chapman 0
3858382 1976283 1976283 defendant Atkyns John fishmonger 592276 592276 Atkyns, John, of Bukyngham, fishmonger 0
3868884 1979834 1979834 defendant Wryght Alexander gent 592276 592276 Wryght, Alexander, of Bukyngham, gent 0
3874210 1981598 1981598 defendant Hancok William yeoman 592276 592276 Hancok, William, of Bukyngham, yeoman 2
3880077 1983596 1983596 defendant Bokys William miller 592276 592276 Bokys, William, of Bukyngham, miller 0
3898040 1989551 1989551 defendant Paynter alias Russell Christopher painter or mercer 592276 592276 Paynter alias Russell, Christopher, of Bukyngham, painter or mercer 0
3903192 1991293 1991293 defendant Josselyn John gent 592276 592276 Josselyn, John, of Bukyngham, gent 3
3921565 1997554 1997554 defendant Blockley alias Atkyns Thomas mercer 592276 592276 Blockley alias Atkyns, Thomas, of Bukyngham, mercer 0
4440245 2181862 2181862 defendant Botheman John   592276 592276 Botheman, John, of Bukyngham 0
4449446 2184771 2184771 plaintiff Goddes William   592276 592276 Goddes, William, of Bukyngham 0
4449448 2184772 2184772 plaintiff Goddes William   592276 592276 Goddes, William, of Bukyngham 0
4456835 2187149 2187149 plaintiff Oundell John   592276 592276 Oundell, John, of Bukyngham, on his own account 0
4480301 2194501 2194501 defendant Olney Nicholas   592276 592276 Olney, Nicholas, of Bukyngham 0
4561029 2219401 2219401 plaintiff Oundell John   592276 592276 Oundell, John, of Bukyngham 0
5044902 2370112 2370112 plaintiff Huet John   592276 592276 Huet, John, of Bukyngham, on his own account 0
5237916 2426675 2426675 defendant Terre William yeoman 592276 592276 Terre, William, of Bukyngham, yeoman 1
5243673 2428343 2428343 defendant Maynesford John gent 592276 592276 (Maynesford, John, of Bukyngham, gent 1
5244544 2428586 2428586 defendant Hobbys alias Daysy John grazier 592276 592276 Hobbys alias Daysy, John, of Bukyngham, grazier 2
5368113 2465653 2465653 defendant Tarre William chapman 592276 592276 Tarre, William, of Bukyngham, chapman 4
5400978 2475346 2475346 defendant Terry John chapman 592276 592276 Terry, John, of Bukyngham, yeoman, son of William Terry of Buckingham, chapman 1
5441397 2487346 2487346 defendant Jones Simon yeoman 592276 592276 Jones, Simon, of Bukyngham, yeoman 1
5441398 2487346 2487346 defendant Grene William yeoman 592276 592276 Grene, William, of Bukyngham, yeoman 2
5441400 2487347 2487347 defendant Foweler Thomas esq 592276 592276 Foweler, Thomas, of Bukyngham, esq 0
5441404 2487348 2487348 defendant Foweler Thomas esq 592276 592276 Foweler, Thomas, of Bukyngham, esq 0
5537877 2516334 2516334 defendant Vaus or Vans Edmund innholder 592276 592276 Vaus or Vans, Edmund, of Bukyngham, innholder 0
5537879 2516335 2516335 defendant Vaus or Vans Edmund innholder 592276 592276 Vaus or Vans, Edmund, of Bukyngham, innholder 0
5568521 2525342 2525342 defendant George John shoemaker 592276 592276 George, John, of Bukyngham, shoemaker 0
5613329 2547952 2547952 defendant Geddes William   592276 592276 Geddes, William, of Bukyngham 0
5615781 2548730 2548730 defendant Seman William   592276 592276 Seman, William, of Bukyngham 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);