names

51 rows where place_id = 585964

✎ 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
3587592 1863767 1863767 defendant Johnson alias Lyster Richard dyer 585964 585964 Johnson alias Lyster, Richard, of Louthe, Lincs, dyer 0
3620182 1873889 1873889 defendant Hardy Robert laborer 585964 585964 Hardy, Robert, of Louthe, Lincs, laborer 2
3709321 1929212 1929212 defendant Page William dyer 585964 585964 Page, William, of Louthe, Lincs, dyer 1
3713860 1930636 1930636 defendant Lincoln William merchant of the staple 585964 585964 Lincoln, William, of Louthe, Lincs, merchant of the staple 0
3758183 1944548 1944548 defendant Lincoln William merchant 585964 585964 Lincoln, William, of Louthe, Lincs, merchant 0
3844906 1971949 1971949 defendant Browne Robert draper 585964 585964 Browne, Robert, of Louthe, Lincs, draper 0
3883064 1984599 1984599 defendant Hebulwhate Christopher tanner 585964 585964 Hebulwhate, Christopher, of Louthe, Lincs, tanner 0
3896234 1988949 1988949 defendant Browne John yeoman 585964 585964 Browne, John, of Louthe, Lincs, yeoman 0
3972593 2014992 2014992 plaintiff Gascoigne John (legal representative) 585964 585964 Gascoigne, John, of Louthe, Lincs, esq, executors of 0
3977213 2016600 2016600 defendant Fysshe John yeoman 585964 585964 Fysshe, John, of Louthe, Lincs, yeoman 0
4029682 2035255 2035255 defendant Barnard William butcher 585964 585964 Barnard, William, of Louthe, Lincs, butcher 1
4095465 2058702 2058702 defendant Holdernes Richard merchant 585964 585964 Holdernes, Richard, of Louthe, Lincs, merchant 0
4233263 2107147 2107147 defendant Kemythorpe or Kennythorpe Oliver yeoman 585964 585964 (Kemythorpe or Kennythorpe, Oliver, of Louthe, Lincs, yeoman 1
4233267 2107148 2107148 defendant Kemythorpe or Kennythorpe Oliver yeoman 585964 585964 (Kemythorpe or Kennythorpe, Oliver, of Louthe, Lincs, yeoman 1
4295823 2128600 2128600 defendant Blancharde Gilbert vintner 585964 585964 Blancharde, Gilbert, of Louthe, Lincs, vintner 0
4341599 2144336 2144336 defendant Ogard Andrew gent 585964 585964 Ogard, Andrew, of Louthe, Lincs, gent 0
4409994 2167949 2167949 defendant Holmes Charles yeoman 585964 585964 Holmes, Charles, of Louthe, Lincs, yeoman 0
4539843 2212724 2212724 defendant Latoner John chapman 585964 585964 Latoner, John, of Louthe, Lincs, chapman 0
4539847 2212725 2212725 defendant Latoner John chapman 585964 585964 Latoner, John, of Louthe, Lincs, chapman 0
4616974 2236317 2236317 defendant Ludde Richard   585964 585964 Ludde, Richard, of Louthe, Lincs 1
4678002 2258734 2258734 defendant Elrede Nicholas   585964 585964 Elrede, Nicholas, of Louthe, Lincs, bailiff 4
4710917 2268770 2268770 defendant Argume Richard   585964 585964 Argume, Richard, of Louthe, Lincs, gent, cousin & heir of William, son & heir of Adam atte Hawe, of Louthe 0
4710920 2268771 2268771 defendant Argume Richard   585964 585964 Argume, Richard, of Louthe, Lincs, gent, cousin & heir of William, son & heir of Adam atte Hawe, of Louthe 0
4748853 2280153 2280153 defendant Burton Nicholas gent 585964 585964 Burton, Nicholas, of Louthe, Lincs, gent 0
4759241 2283231 2283231 defendant Elrede Nicholas yeoman 585964 585964 Elrede, Nicholas, of Louthe, Lincs, yeoman 1
4808824 2298926 2298926 defendant Smyth John   585964 585964 (Smyth, John, of Louthe, Lincs, bell maker or render 4
4904409 2327993 2327993 defendant Burne John chapman 585964 585964 Burne, John, of Louthe, Lincs, chapman 0
4957683 2344270 2344270 defendant Wylkynson John merchant 585964 585964 Wylkynson, John, of Louthe, Lincs, merchant 0
4967420 2347195 2347195 defendant Brouneflete William chapman 585964 585964 Brouneflete, William, of Louthe, Lincs, chapman 2
5017463 2361995 2361995 defendant Mader Robert merchant 585964 585964 Mader, Robert, of Louthe, Lincs, merchant 11
5017476 2361996 2361996 defendant Mader Robert merchant 585964 585964 Mader, Robert, of Louthe, Lincs, merchant 11
5017918 2362123 2362123 defendant Langholme John gent 585964 585964 (Langholme, John, of Louthe, Lincs, gent 1
5017925 2362124 2362124 defendant Langholme John gent 585964 585964 (Langholme, John, of Louthe, Lincs, gent 1
5029491 2365497 2365497 defendant Angewyn Bernard gent 585964 585964 Angewyn, Bernard, of Louthe, Lincs, gent 3
5029502 2365499 2365499 defendant Angewyn Bernard gent 585964 585964 Angewyn, Bernard, of Louthe, Lincs, gent 3
5035725 2367304 2367304 defendant Whiom Henry gent 585964 585964 Whiom, Henry, of Louthe, Lincs, gent 0
5094562 2384820 2384820 defendant Langholme John, junior gent 585964 585964 Langholme, John, junior, of Louthe, Lincs, gent 0
5118512 2391849 2391849 defendant Gyldern William chapman 585964 585964 Gyldern, William, of Louthe, Lincs, chapman 3
5182643 2410678 2410678 defendant Roughton William chaplain 585964 585964 Roughton, William, of Louthe, Lincs, chaplain 1
5195168 2414330 2414330 defendant Gyldern William chapman 585964 585964 Gyldern, William, of Louthe, Lincs, chapman 4
5203507 2416778 2416778 defendant Roughton William chaplain 585964 585964 Roughton, William, of Louthe, Lincs, chaplain 1
5203512 2416779 2416779 defendant Roughton William chaplain 585964 585964 Roughton, William, of Louthe, Lincs, chaplain 1
5209133 2418399 2418399 defendant Gildern William chapman 585964 585964 Gildern, William, of Louthe, Lincs, chapman 4
5225095 2423007 2423007 defendant Gildern William chapman 585964 585964 Gildern, William, of Louthe, Lincs, chapman 3
5250283 2430195 2430195 defendant Gildon William chapman 585964 585964 Gildon, William, of Louthe, Lincs, chapman 2
5277025 2438363 2438363 defendant Coper Richard cooper 585964 585964 Coper, Richard, of Louthe, Lincs, cooper 1
5279201 2439015 2439015 defendant Coper Richard cooper 585964 585964 Coper, Richard, of Louthe, Lincs, cooper 1
5310959 2448315 2448315 defendant Johnson Richard dyer 585964 585964 Johnson, Richard, of Louthe, Lincs, dyer 0
5372673 2467050 2467050 defendant Aleby Thomas husbandman 585964 585964 Aleby, Thomas, of Louthe, Lincs, husbandman 4
5530618 2514092 2514092 defendant Bonyffe Roger yeoman 585964 585964 Bonyffe, Roger, of Louthe, Lincs, yeoman 0
5530620 2514093 2514093 defendant Bonyffe Roger yeoman 585964 585964 Bonyffe, Roger, of Louthe, Lincs, 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);