names

57 rows where place_id = 589855

✎ 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
3599001 1867321 1867321 defendant Dawebeney John husbandman 589855 589855 Dawebeney, John, of Walesby, husbandman 0
3900133 1990268 1990268 defendant Serle John laborer 589855 589855 Serle, John, of Walesby, laborer 1
3933311 2001437 2001437 defendant Knottesworth Hamon yeoman 589855 589855 Knottesworth, Hamon, of Walesby, yeoman 0
4097314 2059357 2059357 defendant Broxolme William gent 589855 589855 Broxolme, William, of Walesby, gent 0
4172379 2085800 2085800 defendant Grantham Anthony yeoman 589855 589855 Grantham, Anthony, of Walesby, yeoman 0
4195612 2094015 2094015 defendant Grantham Anthony yeoman 589855 589855 Grantham, Anthony, of Walesby, yeoman 0
4266995 2118603 2118603 defendant Broxholme William gent 589855 589855 Broxholme, William, of Walesby, gent 0
4325724 2138980 2138980 defendant Pecke William husbandman 589855 589855 Pecke, William, of Walesby, husbandman 0
4460572 2188364 2188364 defendant Curteys John   589855 589855 Curteys, John, of Walesby 0
4524385 2207966 2207966 plaintiff Holdon William   589855 589855 Holdon, William, of Walesby 0
4565127 2220663 2220663 defendant Hibdon William   589855 589855 Hibdon, William, of Walesby 0
4566984 2221234 2221234 defendant West John   589855 589855 West, John, of Walesby 6
4568659 2221777 2221777 defendant Sandholme John   589855 589855 Sandholme, John, of Walesby 1
4618610 2236830 2236830 plaintiff Haunsard Gilbert   589855 589855 Haunsard, Gilbert, of Walesby 0
4642498 2243931 2243931 plaintiff Haunsard Gilbert   589855 589855 Haunsard, Gilbert, of Walesby 0
4664747 2250453 2250453 defendant Walesby Henry husbandman 589855 589855 Walesby, Henry, of Walesby, husbandman 0
4685514 2261064 2261064 defendant Tamworth Richard chaplain 589855 589855 Tamworth, Richard, of Walesby, chaplain 0
4685518 2261064 2261064 defendant Bughton William   589855 589855 Bughton, William, of Walesby, cartwright 4
4715284 2270113 2270113 defendant Sprent William husbandman 589855 589855 Sprent, William, of Walesby, husbandman 0
4721657 2272107 2272107 defendant Walesby Henry gent 589855 589855 Walesby, Henry, of Walesby, gent 0
4727626 2273880 2273880 plaintiff Higdon William   589855 589855 Higdon, William, of Walesby 0
4727628 2273881 2273881 plaintiff Higdon William   589855 589855 Higdon, William, of Walesby 0
4795756 2294824 2294824 defendant Trewe William husbandman 589855 589855 Trewe, William, of Walesby, husbandman 0
4811938 2299846 2299846 defendant Walesby Henry (legal representative) 589855 589855 Walesby, Henry, of Walesby, executors of 0
4811939 2299846 2299846 defendant Walesby Helen widow 589855 589855 (Walesby, Helen, of Walesby, widow 1
4811940 2299846 2299846 defendant Walesby Joan widow 589855 589855 Walesby, Joan, of Walesby, widow 2
4860788 2314734 2314734 defendant Barker John husbandman 589855 589855 Barker, John, of Walesby, husbandman 0
4865809 2316276 2316276 defendant Randolf John husbandman 589855 589855 Randolf, John, of Walesby, husbandman 0
4865814 2316277 2316277 defendant Godhand Andrew husbandman 589855 589855 Godhand, Andrew, of Walesby, husbandman 0
4865815 2316277 2316277 defendant West John husbandman 589855 589855 West, John, of Walesby, husbandman 1
4865816 2316277 2316277 defendant Mumby John chaplain 589855 589855 Mumby, John, of Walesby, chaplain 2
4921106 2333116 2333116 defendant Raulyn John   589855 589855 Raulyn, John, of Walesby, servant 0
4972516 2348711 2348711 defendant Yerburgh Henry miller 589855 589855 Yerburgh, Henry, of Walesby, miller 1
4995723 2355561 2355561 defendant Walesby Helen widow 589855 589855 Walesby, Helen, of Walesby, widow 0
4995725 2355561 2355561 defendant Wardall John gent 589855 589855 Wardall, John, of Walesby, gent 2
4998748 2356514 2356514 plaintiff Knyght Roger   589855 589855 Knyght, Roger, of Walesby 0
5002282 2357572 2357572 defendant Browne John yeoman 589855 589855 Browne, John, of Walesby, yeoman 1
5020318 2362830 2362830 defendant Godhand Andrew gent 589855 589855 Godhand, Andrew, of Walesby, gent 5
5025806 2364447 2364447 plaintiff Knyght Roger   589855 589855 Knyght, Roger, of Walesby 0
5028669 2365261 2365261 defendant Nuney John clerk 589855 589855 Nuney, John, of Walesby, clerk 3
5240800 2427520 2427520 defendant Wardall Alice widow 589855 589855 Wardall Alice, of Walesby, widow 0
5240801 2427520 2427520 defendant Wardall Thomas gent 589855 589855 Wardall, Thomas, of Walesby, gent 1
5240802 2427520 2427520 defendant Wardall John gent 589855 589855 Wardall, John, of Walesby, gent 2
5287712 2441429 2441429 defendant Wardall Thomas gent 589855 589855 Wardall, Thomas, of Walesby, gent 4
5403475 2476065 2476065 defendant Milner Henry milner 589855 589855 Milner, Henry, of Walesby, milner 1
5416544 2479866 2479866 defendant Milner Henry milner 589855 589855 Milner, Henry, of Walesby, milner 1
5502394 2505672 2505672 defendant Bothomley George husbandman 589855 589855 Bothomley, George, of Walesby, husbandman 0
5502396 2505672 2505672 defendant Martyn John   589855 589855 Martyn, John, of Walesby, wright 2
5505481 2506630 2506630 defendant Marton John   589855 589855 Marton, John, of Walesby, wright 1
5517669 2510365 2510365 defendant Broun Thomas husbandman 589855 589855 Broun, Thomas, of Walesby, husbandman 0
5517670 2510365 2510365 defendant Clapeham Robert husbandman 589855 589855 Clapeham, Robert, of Walesby, husbandman 1
5517671 2510365 2510365 defendant Daubeney John husbandman 589855 589855 Daubeney, John, of Walesby, husbandman 2
5517672 2510365 2510365 defendant Tayllour Richard husbandman 589855 589855 Tayllour, Richard, of Walesby, husbandman 3
5517673 2510365 2510365 defendant Boughton John husbandman 589855 589855 Boughton, John, of Walesby, husbandman 4
5526543 2512869 2512869 defendant Daubeney Henry husbandman 589855 589855 Daubeney, Henry, of Walesby, husbandman 1
5634744 2554864 2554864 plaintiff Walesby John   589855 589855 Walesby, John, of Walesby 0
5635225 2554988 2554988 defendant Walesby John   589855 589855 Walesby, John, of Walesby 1

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