names

48 rows where place_id = 606661

✎ 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
3666072 1915329 1915329 defendant Parker John clerk 606661 606661 Parker, John, of Bardney, clerk 0
3691083 1923372 1923372 defendant Lyncoln George mercer 606661 606661 Lyncoln, George, of Bardney, mercer 3
3799547 1957780 1957780 defendant Fowler Thomas fisher 606661 606661 Fowler, Thomas, of Bardney, fisher 0
3974300 2015580 2015580 defendant Johnson George yeoman 606661 606661 Johnson, George, of Bardney, yeoman 0
3978417 2017036 2017036 defendant Hogeson Anthony husbandman 606661 606661 Hogeson, Anthony, of Bardney, husbandman 3
3984719 2019292 2019292 defendant Noble Richard yeoman 606661 606661 Noble, Richard, of Bardney, yeoman 1
4068366 2048986 2048986 defendant Trusse Lawrence gent 606661 606661 Trusse, Lawrence, of Bardney, gent 2
4124972 2069221 2069221 defendant Mawe Richard cornwainer 606661 606661 Mawe, Richard, of Bardney, cornwainer 0
4124973 2069221 2069221 defendant Harrison Thomas cordwainer 606661 606661 Harrison, Thomas, of Bardney, cordwainer 1
4132358 2071886 2071886 defendant Cooke Benjamin husbandman 606661 606661 Cooke, Benjamin, of Bardney, or of Timberland, husbandman 0
4174760 2086641 2086641 defendant Shepperd Walter clerk 606661 606661 Shepperd, Walter, of Bardney, clerk 1
4175685 2086966 2086966 defendant Mowbraye Henry   606661 606661 Mowbraye, Henry, of Bardney, shipwright 0
4178837 2088073 2088073 defendant Clarkson Edward butcher 606661 606661 Clarkson, Edward, of Bardney, butcher 0
4178839 2088074 2088074 defendant Clarkson Edward butcher 606661 606661 Clarkson, Edward, of Bardney, butcher 0
4184419 2090055 2090055 defendant Warde John butcher 606661 606661 Warde, John, of Bardney, butcher 0
4192398 2092896 2092896 defendant Pate Richard   606661 606661 Pate, Richard, of Bardney, surgeon 0
4207861 2098307 2098307 defendant Warde John butcher 606661 606661 Warde, John, of Bardney, butcher 0
4207862 2098307 2098307 defendant Varley Richard yeoman 606661 606661 Varley, Richard, of Bardney, yeoman 1
4208273 2098443 2098443 defendant Warde John butcher 606661 606661 Warde, John, of Bardney, butcher 0
4236265 2108252 2108252 defendant Mowbrey Henry (legal representative) 606661 606661 Mowbrey, Henry, of Bardney, shipwright, executors of 0
4236266 2108252 2108252 defendant Hodgenesse John yeoman 606661 606661 (Hodgenesse, John, of Bardney, yeoman 1
4243176 2110711 2110711 defendant Brumbye Stephen yeoman 606661 606661 Brumbye, Stephen, of Bardney, yeoman 0
4250713 2113215 2113215 defendant Greene William laborer 606661 606661 Greene, William, of Bardney, laborer 2
4253510 2114163 2114163 defendant Brumbye Stephen yeoman 606661 606661 Brumbye, Stephen, of Bardney, yeoman 0
4274136 2120895 2120895 defendant Kendall Robert yeoman 606661 606661 Kendall, Robert, of Bardney, yeoman 0
4285679 2124929 2124929 defendant Creswell John (legal representative) 606661 606661 Creswell, John, of Bardney, yeoman, executors of 0
4295591 2128509 2128509 defendant Wytton Robert yeoman 606661 606661 Wytton, Robert, of Bardney, yeoman 0
4295592 2128509 2128509 defendant Clarke William shoemaker 606661 606661 Clarke, William, of Bardney, shoemaker 1
4299700 2129981 2129981 defendant Pate Henry butcher 606661 606661 Pate, Henry, of Bardney, butcher 1
4341278 2144222 2144222 defendant Witton Robert yeoman 606661 606661 Witton, Robert, of Bardney, yeoman 0
4345055 2145546 2145546 defendant Cartwright Richard husbandman 606661 606661 Cartwright, Richard, of Bardney, husbandman 0
4345077 2145554 2145554 defendant Knowles Richard clerk 606661 606661 Knowles, Richard, of Bardney, or of Billinghay, clerk 1
4353834 2148562 2148562 defendant Dickonson Cuthbert tailor 606661 606661 Dickonson, Cuthbert, of Bardney, tailor 0
4354479 2148801 2148801 defendant Bayntman William laborer 606661 606661 Bayntman, William, of Bardney, ,laborer 0
4363284 2151939 2151939 defendant Witton Robert painter 606661 606661 Witton, Robert, of Bardney, painter 0
4363285 2151939 2151939 defendant Kendall Robert yeoman 606661 606661 Kendall, Robert, of Bardney, yeoman 1
4363471 2152009 2152009 defendant Skipwith Lion gent 606661 606661 Skipwith, Lion, of Bardney, yeoman, or of Ormesby, gent 0
4363480 2152012 2152012 defendant Skipwith Lionel gent 606661 606661 Skipwith, Lionel, of Bardney, gent 1
4364872 2152488 2152488 defendant Kendall Robert yeoman 606661 606661 Kendall, Robert, of Bardney, yeoman 0
4367806 2153537 2153537 defendant Barker John baker 606661 606661 Barker, John, of Bardney, baker 0
4367807 2153537 2153537 defendant Atkinson John waterman 606661 606661 Atkinson, John, of Bardney, waterman 1
4371999 2155047 2155047 defendant Wylton Robert yeoman 606661 606661 Wylton, Robert, of Bardney, yeoman 3
4407327 2167012 2167012 defendant Witton Robert painter 606661 606661 Witton, Robert, of Bardney, painter 0
4447792 2184239 2184239 defendant Couper Robert   606661 606661 Couper, Robert, of Bardney 0
5304445 2446327 2446327 plaintiff Horncastell Richard   606661 606661 Horncastell, Richard, of Bardney, abbot 0
5339133 2456817 2456817 defendant Wylkynson Thomas husbandman 606661 606661 Wylkynson, Thomas, of Bardney, husbandman 2
5339134 2456817 2456817 defendant Vessy John husbandman 606661 606661 Vessy, John, of Bardney, husbandman 3
5522659 2511912 2511912 defendant Balfronde Hugh gent 606661 606661 Balfronde, Hugh, of Bardney, gent 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);