names

79 rows where place_id = 595169

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619210 1873609 1873609 defendant Fermer Henry barker 595169 595169 Fermer, Henry, of Olney, Bucks, barker 0
3645461 1908986 1908986 defendant Tommys Robert yeoman 595169 595169 Tommys, Robert, of Olney, Bucks, yeoman 4
3645471 1908987 1908987 defendant Tommys Robert yeoman 595169 595169 Tommys, Robert, of Olney, Bucks, yeoman 7
3689056 1922739 1922739 defendant Cheltam John miller 595169 595169 Cheltam, John, of Olney, Bucks, miller 1
3727644 1934922 1934922 defendant Throgmorton George esq 595169 595169 Throgmorton, George, of Olney, Bucks, esq 0
3754084 1943223 1943223 defendant Throkmarton George   595169 595169 Throkmarton, George, of Olney, Bucks, knight 0
3754264 1943285 1943285 defendant Throkmarton George   595169 595169 Throkmarton, George, of Olney, Bucks, knight 0
3772057 1948951 1948951 defendant Barne John butcher 595169 595169 Barne, John, of Olney, Bucks, butcher 0
3806925 1960076 1960076 defendant Throkmarton George   595169 595169 Throkmarton, George, of Olney, Bucks, knight 0
3830081 1967305 1967305 defendant Austen Robert husbandman 595169 595169 Austen, Robert, of Olney, Bucks, husbandman 0
3845205 1972062 1972062 defendant Austen Robert husbandman 595169 595169 Austen, Robert, of Olney, Bucks, husbandman 0
3861063 1977182 1977182 defendant Austen Robert husbandman 595169 595169 Austen, Robert, of Olney, Bucks, husbandman 0
3877978 1982880 1982880 defendant Alison Robert husbandman 595169 595169 Alison, Robert, of Olney, Bucks, husbandman 0
3877983 1982881 1982881 defendant Alison Robert husbandman 595169 595169 Alison, Robert, of Olney, Bucks, husbandman 0
3880716 1983815 1983815 defendant Rede William butcher 595169 595169 Rede, William, of Olney, Bucks, butcher 1
3911256 1994085 1994085 defendant Wyndesore Henry gent 595169 595169 Wyndesore, Henry, of Olney, Bucks, gent 3
3911264 1994086 1994086 defendant Wyndesore Henry gent 595169 595169 Wyndesore, Henry, of Olney, Bucks, gent 3
3949993 2007078 2007078 defendant Lawe Anthony gent 595169 595169 Lawe, Anthony, of Olney, Bucks, gent 0
3959416 2010377 2010377 defendant Holt Francis gent 595169 595169 Holt, Francis, of Olney, Bucks, gent 0
4111321 2064297 2064297 defendant Reade John yeoman 595169 595169 Reade, John, of Olney, Bucks, yeoman 2
4185971 2090582 2090582 defendant Spencer Stephen yeoman 595169 595169 Spencer, Stephen, of Olney, Bucks, innholder, or of Fylgrave, yeoman 0
4233445 2107213 2107213 defendant Taverner Thomas gent 595169 595169 Taverner, Thomas, of Olney, Bucks, gent 0
4265554 2118119 2118119 defendant Taverner Thomas gent 595169 595169 Taverner, Thomas, of Olney, Bucks, gent 0
4300089 2130128 2130128 defendant Bowlesworthe John tanner 595169 595169 Bowlesworthe, John, of Olney, Bucks, or of Layghton Bussard, Beds, tanner 0
4315884 2135664 2135664 defendant Taverner Thomas gent 595169 595169 Taverner, Thomas, of Olney, Bucks, gent 0
4341790 2144405 2144405 defendant Hynde Thomas husbandman 595169 595169 Hynde, Thomas, of Olney, Bucks, husbandman 0
4349621 2147130 2147130 defendant Stevensone Francis yeoman 595169 595169 Stevensone, Francis, of Olney, Bucks, yeoman 0
4385226 2159747 2159747 defendant Alderman Thomas chapman 595169 595169 Alderman, Thomas, of Olney, Bucks, chapman 0
4404940 2166222 2166222 defendant Pearce William gent 595169 595169 Pearce, William, of Olney, Bucks, gent 0
4771476 2287058 2287058 defendant Bayssom John clerk 595169 595169 Bayssom, John, of Olney, Bucks, clerk 0
4833729 2306558 2306558 defendant Skynner John skinner 595169 595169 Skynner, John, of Olney, Bucks, skinner 0
4910994 2329951 2329951 defendant Craas John skinner 595169 595169 Craas, John, of Olney, Bucks, skinner 0
4913203 2330627 2330627 defendant Sheman John husbandman 595169 595169 Sheman, John, of Olney, Bucks, husbandman 0
4915538 2331358 2331358 defendant Terell John husbandman 595169 595169 Terell, John, of Olney, Bucks, husbandman 0
4925106 2334283 2334283 defendant Skynner John glover 595169 595169 Skynner, John, of Olney, Bucks, glover 6
4953372 2342973 2342973 defendant Tyrell John yeoman 595169 595169 Tyrell, John, of Olney, Bucks, yeoman 1
4958716 2344573 2344573 defendant Pulter Henry pulter 595169 595169 Pulter, Henry, of Olney, Bucks, pulter 2
4970416 2348098 2348098 defendant Carpenter Thomas husbandman 595169 595169 (Carpenter, Thomas, of Olney, Bucks, husbandman 1
4970837 2348219 2348219 defendant Carpenter Thomas husbandman 595169 595169 (Carpenter, Thomas, of Olney, Bucks, husbandman 1
5063142 2375513 2375513 defendant Mayewe Thomas yeoman 595169 595169 Mayewe, Thomas, of Olney, Bucks, yeoman 0
5082152 2381155 2381155 defendant Whirlot William husbandman 595169 595169 Whirlot, William, of Olney, Bucks, husbandman 0
5082631 2381310 2381310 defendant Whirlat William gent 595169 595169 Whirlat, William, of Olney, Bucks, gent 0
5114665 2390704 2390704 defendant Whirlot William yeoman 595169 595169 Whirlot, William, of Olney, Bucks, yeoman 1
5114764 2390732 2390732 defendant Whirlot William yeoman 595169 595169 Whirlot, William, of Olney, Bucks, yeoman 1
5129519 2395121 2395121 defendant Skelton John husbandman 595169 595169 Skelton, John, of Olney, Bucks, husbandman 2
5157082 2403211 2403211 defendant Luf William yeoman 595169 595169 Luf, William, of Olney, Bucks, yeoman 1
5173138 2407854 2407854 defendant Luf William yeoman 595169 595169 Luf, William, of Olney, Bucks, yeoman 1
5178118 2409305 2409305 defendant Harvy William yeoman 595169 595169 Harvy, William, of Olney, Bucks, yeoman 0
5178121 2409306 2409306 defendant Harvy William yeoman 595169 595169 Harvy, William, of Olney, Bucks, yeoman 0
5192967 2413670 2413670 defendant Luf William yeoman 595169 595169 Luf, William, of Olney, Bucks, yeoman 1
5195807 2414521 2414521 defendant Whitlot William yeoman 595169 595169 Whitlot, William, of Olney, Bucks, yeoman 1
5195813 2414522 2414522 defendant Whitlot William yeoman 595169 595169 Whitlot, William, of Olney, Bucks, yeoman 1
5195819 2414523 2414523 defendant Whitlot William yeoman 595169 595169 Whitlot, William, of Olney, Bucks, yeoman 1
5201284 2416133 2416133 defendant Harvy William yeoman 595169 595169 Harvy, William, of Olney, Bucks, yeoman 0
5209405 2418486 2418486 defendant Whirlot William yeoman 595169 595169 Whirlot, William, of Olney, Bucks, yeoman 1
5214148 2419864 2419864 defendant Hervy William yeoman 595169 595169 Hervy, William, of Olney, Bucks, yeoman 0
5227685 2423716 2423716 defendant Whirlot William yeoman 595169 595169 Whirlot, William, of Olney, Bucks, yeoman 0
5248716 2429744 2429744 defendant Cony Thomas mercer 595169 595169 Cony, Thomas, of Olney, Bucks, mercer 0
5269612 2436221 2436221 defendant Smyth John merchant 595169 595169 Smyth, John, of Olney, Bucks, merchant 0
5269616 2436222 2436222 defendant Smyth John merchant 595169 595169 Smyth, John, of Olney, Bucks, merchant 0
5271536 2436769 2436769 defendant Smyth John yeoman & merchant 595169 595169 Smyth, John, of Olney, Bucks, yeoman & merchant 0
5271955 2436879 2436879 defendant Smyth John merchant 595169 595169 Smyth, John, of Olney, Bucks, merchant 0
5280550 2439388 2439388 defendant Percevall John glover 595169 595169 Percevall, John, of Olney, Bucks, glover 1
5286078 2440936 2440936 defendant Smyth John yeoman 595169 595169 Smyth, John, of Olney, Bucks, yeoman 0
5296674 2444013 2444013 defendant Dabley John   595169 595169 Dabley, John, of Olney, Bucks, notary 0
5296676 2444014 2444014 defendant Dalley John   595169 595169 Dalley, John, of Olney, Bucks, notary 0
5300527 2445122 2445122 defendant Danley or Dauley John   595169 595169 Danley or Dauley, John, of Olney, Bucks, notary 0
5323952 2452248 2452248 defendant Smyth John yeoman 595169 595169 Smyth, John, of Olney, Bucks, yeoman 0
5323955 2452249 2452249 defendant Smythe John yeoman 595169 595169 Smythe, John, of Olney, Bucks, yeoman 0
5352906 2460995 2460995 defendant Whyrlot William gent 595169 595169 Whyrlot, William, of Olney, Bucks, gent 0
5403508 2476073 2476073 defendant Curteis William butcher 595169 595169 Curteis, William, of Olney, Bucks, butcher 1
5403511 2476074 2476074 defendant Curteys William butcher 595169 595169 Curteys, William, of Olney, Bucks, butcher 1
5416622 2479886 2479886 defendant Curteys William butcher 595169 595169 Curteys, William, of Olney, Bucks, butcher 0
5416624 2479887 2479887 defendant Curteys William butcher 595169 595169 Curteys, William, of Olney, Bucks, butcher 0
5416627 2479888 2479888 defendant Curteys William butcher 595169 595169 Curteys, William, of Olney, Bucks, butcher 1
5472286 2496679 2496679 defendant Fermour Henry tanner 595169 595169 Fermour, Henry, of Olney, Bucks, tanner 0
5512700 2508829 2508829 defendant Forster John smith 595169 595169 Forster, John, of Olney, Bucks, smith 0
5525703 2512630 2512630 defendant Asteby Thomas pulter 595169 595169 Asteby, Thomas, of Olney, Bucks, pulter 0
5547762 2519360 2519360 defendant Farmour Henry tanner 595169 595169 Farmour, Henry, of Olney, Bucks, tanner 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);