names

92 rows where place_id = 590699

✎ 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
3602028 1868295 1868295 defendant Benet Peter butcher 590699 590699 Benet, Peter, of New Thame, butcher 0
3602030 1868295 1868295 defendant Aley Roger chandler 590699 590699 Aley, Roger, of New Thame, chandler 2
3635439 1905880 1905880 defendant Stokdale John chapman 590699 590699 Stokdale, John, of New Thame, chapman 1
3637837 1906651 1906651 defendant Smyth Robert chapman 590699 590699 Smyth, Robert, of New Thame, chapman 1
3641388 1907760 1907760 defendant Baten Henry butcher 590699 590699 Baten, Henry, of New Thame, butcher 0
3641390 1907760 1907760 defendant Saunders Robert husbandman 590699 590699 Saunders, Robert, of New Thame, husbandman 2
3660110 1913422 1913422 defendant Smerte Richard fuller 590699 590699 Smerte, Richard, of New Thame, fuller 1
3663281 1914441 1914441 defendant Myxbury Christopher tailor 590699 590699 Myxbury, Christopher, of New Thame, tailor 0
3675243 1918293 1918293 defendant Smarte Richard fuller 590699 590699 Smarte, Richard, of New Thame, fuller 1
3679117 1919536 1919536 defendant Strybylhyll Thomas yeoman 590699 590699 Strybylhyll, Thomas, of New Thame, yeoman 0
3689895 1922999 1922999 defendant Chyche Thomas husbandman 590699 590699 Chyche, Thomas, of New Thame, husbandman 4
3692976 1924003 1924003 defendant Elys John smith 590699 590699 Elys, John, of New Thame, smith 0
3692977 1924003 1924003 defendant Wheler William smith 590699 590699 Wheler, William, of New Thame, smith 1
3704356 1927666 1927666 defendant Elys Richard   590699 590699 Elys, Richard, of New Thame 0
3708752 1929034 1929034 defendant Bysshop Alice widow 590699 590699 Bysshop, Alice, of New Thame, widow 1
3724027 1933798 1933798 defendant Mortymer Thomas, senior husbandman 590699 590699 Mortymer, Thomas, senior, of New Thame, husbandman 1
3724028 1933798 1933798 defendant Mortymer Thomas, junior husbandman 590699 590699 Mortymer, Thomas, junior, of New Thame, husbandman 2
3779484 1951305 1951305 defendant Ray Richard yeoman 590699 590699 Ray, Richard, of New Thame, yeoman 0
3779487 1951306 1951306 defendant Ray Richard yeoman 590699 590699 Ray, Richard, of New Thame, yeoman 0
3779490 1951307 1951307 defendant Ray Richard yeoman 590699 590699 Ray, Richard, of New Thame, yeoman 0
3780056 1951487 1951487 defendant Elly John tailor 590699 590699 Elly, John, of New Thame, tailor 0
3780057 1951487 1951487 defendant Whyte Richard mercer 590699 590699 Whyte, Richard, of New Thame, mercer 1
3780058 1951487 1951487 defendant Hester John husbandman 590699 590699 Hester, John, of New Thame, husbandman 2
3780059 1951487 1951487 defendant Hester Thomas husbandman 590699 590699 Hester, Thomas, of New Thame, husbandman 3
3780064 1951488 1951488 defendant Elly John tailor 590699 590699 Elly, John, of New Thame, tailor 0
3780065 1951488 1951488 defendant Whyte Richard mercer 590699 590699 Whyte, Richard, of New Thame, mercer 1
3780066 1951488 1951488 defendant Hester John husbandman 590699 590699 Hester, John, of New Thame, husbandman 2
3780067 1951488 1951488 defendant Hester Thomas husbandman 590699 590699 Hester, Thomas, of New Thame, husbandman 3
3786860 1953689 1953689 defendant Gom or Gomer alias Cowper John husbandman 590699 590699 Gom or Gomer alias Cowper, John, of New Thame, husbandman 0
3857810 1976081 1976081 defendant Whyte John miller 590699 590699 Whyte, John, of New Thame, miller 1
3879922 1983543 1983543 defendant Drynkwater John glover 590699 590699 Drynkwater, John, of New Thame, glover 0
3887936 1986214 1986214 defendant Bunce Richard, senior fletcher 590699 590699 Bunce, Richard, senior, of New Thame, fletcher 0
3887937 1986214 1986214 defendant Bunce William yeoman 590699 590699 Bunce, William, of New Thame, yeoman 1
4743320 2278573 2278573 defendant Elys John tanner 590699 590699 Elys, John, of New Thame, tanner 1
4749047 2280205 2280205 plaintiff Nasshe William   590699 590699 Nasshe, William, of New Thame, servant of John Elys 0
4803462 2297270 2297270 defendant Powelyn William ironmonger 590699 590699 Powelyn, William, of New Thame, ironmonger 0
4803463 2297270 2297270 defendant Smyth William husbandman 590699 590699 Smyth, William, of New Thame, husbandman 1
4816620 2301291 2301291 defendant Myxbery John husbadman 590699 590699 Myxbery, John, of New Thame, husbadman 0
4816621 2301291 2301291 defendant Bailly alias Josep Giles husbandman 590699 590699 Bailly alias Josep, Giles, of New Thame, husbandman 1
4817359 2301515 2301515 defendant Plotte Thomas laborer 590699 590699 Plotte, Thomas, of New Thame, laborer 1
4817849 2301665 2301665 defendant Welles Thomas husbandman 590699 590699 Welles, Thomas, of New Thame, husbandman 0
5066696 2376567 2376567 defendant Benet John hosteler 590699 590699 Benet, John, of New Thame, hosteler 0
5112635 2390083 2390083 defendant Grene Thomas tailor 590699 590699 Grene, Thomas, of New Thame, tailor 0
5131029 2395561 2395561 defendant Bates William (legal representative) 590699 590699 Bates, William, of New Thame, gent, executor of 0
5142063 2398801 2398801 defendant Cotteswold John husbandman 590699 590699 Cotteswold, John, of New Thame, husbandman 1
5142065 2398801 2398801 defendant Falley William   590699 590699 Falley, William, of New Thame 3
5142069 2398802 2398802 defendant Cotteswold John husbandman 590699 590699 Cotteswold, John, of New Thame, husbandman 1
5142071 2398802 2398802 defendant Falley William   590699 590699 Falley, William, of New Thame 3
5150535 2401296 2401296 defendant Bates William (legal representative) 590699 590699 Bates, William, of New Thame, gent, executor of 0
5231579 2424819 2424819 defendant Stokys John roper 590699 590699 Stokys, John, of New Thame, roper 0
5256082 2432027 2432027 plaintiff Dawense John   590699 590699 Dawense, John, of New Thame 0
5274535 2437632 2437632 defendant Erberd William smith 590699 590699 Erberd, William, of New Thame, smith 0
5287222 2441282 2441282 defendant Mixbury John husbandman 590699 590699 Mixbury, John, of New Thame, husbandman 0
5291788 2442607 2442607 defendant Marmyon Peter gent 590699 590699 Marmyon, Peter, of New Thame, gent 0
5291789 2442607 2442607 defendant Doyle Robert gent 590699 590699 Doyle, Robert, of New Thame, gent 1
5291790 2442607 2442607 defendant Marmyon Robert gent 590699 590699 Marmyon, Robert, of New Thame, gent 2
5291791 2442607 2442607 defendant Marmyon George gent 590699 590699 Marmyon, George, of New Thame, gent 3
5291792 2442607 2442607 defendant Marmyon John gent 590699 590699 Marmyon, John, of New Thame, gent 4
5316493 2450015 2450015 plaintiff Derynall or Deryvall Nichlolas yeoman 590699 590699 Derynall or Deryvall, Nichlolas, of New Thame, yeoman 0
5316494 2450015 2450015 defendant Cotys John roper 590699 590699 Cotys, John, of New Thame, roper 0
5316495 2450016 2450016 plaintiff Derynall Nicholas yeoman 590699 590699 Derynall, Nicholas, of New Thame, yeoman 0
5316496 2450016 2450016 defendant Cotys John roper 590699 590699 Cotys, John, of New Thame, roper 0
5351751 2460648 2460648 defendant Batis John gent 590699 590699 Batis, John, of New Thame, gent 0
5351798 2460664 2460664 defendant Baret John tailor 590699 590699 Baret, John, of New Thame, tailor 0
5351799 2460664 2460664 defendant Touresey John laborer 590699 590699 together with Touresey, John, of New Thame, laborer 1
5351801 2460665 2460665 defendant Touresey John laborer 590699 590699 Touresey, John, of New Thame, laborer 0
5351802 2460665 2460665 defendant Baret John tailor 590699 590699 together with Baret, John, of New Thame, tailor 1
5352844 2460978 2460978 defendant Water Hugh husbandman 590699 590699 Water, Hugh, of New Thame, husbandman 0
5355652 2461843 2461843 defendant Gryffyn Richard tailor 590699 590699 Gryffyn, Richard, of New Thame, tailor 0
5362126 2463819 2463819 defendant Chapman John, senior chandler 590699 590699 Chapman, John, senior, of New Thame, chandler 0
5369791 2466142 2466142 defendant Benet Peter butcher 590699 590699 Benet, Peter, of New Thame, butcher 0
5385265 2470861 2470861 plaintiff Bunse Nicholas   590699 590699 Bunse, Nicholas, of New Thame, arrow maker 0
5385267 2470861 2470861 defendant Tendeley Thomas yeoman 590699 590699 Tendeley, Thomas, of New Thame, yeoman 1
5397331 2474322 2474322 plaintiff Bunse alias Bunce Nicholas fisher 590699 590699 Bunse alias Bunce, Nicholas, of New Thame, fisher 0
5397333 2474322 2474322 defendant Trendeley Thomas yeoman 590699 590699 Trendeley, Thomas, of New Thame, yeoman 1
5410547 2478100 2478100 plaintiff Bunse Nicholas   590699 590699 Bunse, Nicholas, of New Thame, arrow maker 0
5424436 2482276 2482276 defendant Trendley Thomas yeoman 590699 590699 Trendley, Thomas, of New Thame, yeoman 1
5455991 2491704 2491704 plaintiff Bunse Nicholas fletcher 590699 590699 Bunse, Nicholas, of New Thame, fletcher 0
5455992 2491704 2491704 defendant Trendeley Thomas yeoman 590699 590699 Trendeley, Thomas, of New Thame, yeoman 0
5455993 2491705 2491705 plaintiff Bunse Nicholas fletcher 590699 590699 Bunse, Nicholas, of New Thame, fletcher 0
5455996 2491706 2491706 defendant Trendeley Thomas yeoman 590699 590699 Trendeley, Thomas, of New Thame, yeoman 0
5476568 2497984 2497984 defendant Verder John husbandman 590699 590699 Verder, John, of New Thame, husbandman 0
5480795 2499214 2499214 defendant Chapman John, junior mercer 590699 590699 Chapman, John, junior, of New Thame, mercer 0
5493261 2502893 2502893 defendant Buntyng John yeoman 590699 590699 Buntyng, John, of New Thame, yeoman 4
5498543 2504509 2504509 plaintiff Nunce Nicholas   590699 590699 Nunce, Nicholas, of New Thame 0
5498545 2504509 2504509 defendant Trendeley Thomas yeoman 590699 590699 Trendeley, Thomas, of New Thame, yeoman 1
5504091 2506195 2506195 defendant Wyxton John husbandman 590699 590699 Wyxton, John, of New Thame, husbandman 1
5520872 2511348 2511348 defendant Benet Peter yeoman 590699 590699 Benet, Peter, of New Thame, yeoman 0
5568528 2525345 2525345 defendant Triplet William   590699 590699 Triplet, William, of New Thame, tallow chandler 0
5583553 2529928 2529928 defendant Bunce Nicholas fletcher 590699 590699 Bunce, Nicholas, of New Thame, fletcher 0
5583555 2529929 2529929 defendant Bunce Nicholas fletcher 590699 590699 Bunce, Nicholas, of New Thame, fletcher 0
5602787 2535751 2535751 defendant Baten Henry butcher 590699 590699 Baten, Henry, of New Thame, butcher 2

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