names

124 rows where place_id = 596963

✎ 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
3626765 1903218 1903218 defendant Jepson Stephen husbandman 596963 596963 Jepson, Stephen, of Barley, husbandman 2
3626766 1903218 1903218 defendant Lee William husbandman 596963 596963 Lee, William, of Barley, husbandman 3
3639028 1907028 1907028 defendant Grey John gent 596963 596963 Grey, John, of Barley, gent 1
3647475 1909600 1909600 defendant Grenell of Grevell John husbandman 596963 596963 Grenell of Grevell, John, of Barley, husbandman 0
3652360 1911074 1911074 defendant Grenehyll Thomas husbandman 596963 596963 Grenehyll, Thomas, of Barley, husbandman 0
3668980 1916230 1916230 defendant Fletcher John husbandman 596963 596963 Fletcher, John, of Barley, husbandman 0
3668981 1916230 1916230 defendant Wylle Thomas bloomer 596963 596963 Wylle, Thomas, of Barley, bloomer 1
3673730 1917811 1917811 defendant Barley Robert esq 596963 596963 Barley, Robert, of Barley, esq 0
3673732 1917812 1917812 defendant Barley Robert esq 596963 596963 Barley, Robert, of Barley, esq 0
3673733 1917812 1917812 defendant Mawer George yeoman 596963 596963 Mawer, George, of Barley, yeoman 1
3673734 1917812 1917812 defendant Barley Henry clerk 596963 596963 Barley, Henry, of Barley, clerk 2
3673735 1917812 1917812 defendant Platt William yeoman 596963 596963 Platt, William, of Barley, yeoman 3
3673736 1917812 1917812 defendant Coke John yeoman 596963 596963 Coke, John, of Barley, yeoman 4
3673737 1917812 1917812 defendant Gory Richard yeoman 596963 596963 Gory, Richard, of Barley, yeoman 5
3673746 1917816 1917816 defendant Welby Thomas husbandman 596963 596963 Welby, Thomas, of Barley, husbandman 0
3673747 1917816 1917816 defendant Byrkynshawe Richard yeoman 596963 596963 Byrkynshawe, Richard, of Barley, yeoman 1
3673748 1917816 1917816 defendant Hancok Richard husbandman 596963 596963 Hancok, Richard, of Barley, husbandman 2
3673749 1917816 1917816 defendant Cartwryght Robert husbandman 596963 596963 Cartwryght, Robert, of Barley, husbandman 3
3676382 1918658 1918658 defendant Robert John butcher 596963 596963 Robert, John, of Barley, butcher 0
3689726 1922944 1922944 defendant Bagshawe Henry yeoman 596963 596963 Bagshawe, Henry, of Barley, yeoman 0
3689727 1922944 1922944 defendant Byrkynshawe James yeoman 596963 596963 Byrkynshawe, James, of Barley, yeoman 1
3689729 1922945 1922945 defendant Barley Arthur gent 596963 596963 Barley, Arthur, of Barley, gent 0
3689730 1922945 1922945 defendant Wheyt Thomas yeoman 596963 596963 Wheyt, Thomas, of Barley, yeoman 1
3689731 1922945 1922945 defendant Grande Thomas yeoman 596963 596963 Grande, Thomas, of Barley, yeoman 2
3689732 1922945 1922945 defendant Cartwryght Robert yeoman 596963 596963 Cartwryght, Robert, of Barley, yeoman 3
3689733 1922945 1922945 defendant Byrkynshawe James yeoman 596963 596963 Byrkynshawe, James, of Barley, yeoman 4
3689736 1922947 1922947 plaintiff Fletcher John   596963 596963 Fletcher, John, of Barley 0
3692725 1923912 1923912 defendant Wylly Thomas yeoman 596963 596963 Wylly, Thomas, of Barley, yeoman 1
3700052 1926248 1926248 defendant Roberd John butcher 596963 596963 Roberd, John, of Barley, butcher 3
3704498 1927703 1927703 defendant Barley Robert esq 596963 596963 Barley, Robert, of Barley, esq 0
3704499 1927703 1927703 defendant Mawer George yeoman 596963 596963 Mawer, George, of Barley, yeoman 1
3704500 1927703 1927703 defendant Barley Henry clerk 596963 596963 Barley, Henry, of Barley, clerk 2
3704501 1927703 1927703 defendant Platt William yeoman 596963 596963 Platt, William, of Barley, yeoman 3
3704502 1927703 1927703 defendant Coke John yeoman 596963 596963 Coke, John, of Barley, yeoman 4
3704503 1927703 1927703 defendant Gory Richard yeoman 596963 596963 Gory, Richard, of Barley, yeoman 5
3704505 1927704 1927704 defendant Wylly Thomas husbandman 596963 596963 Wylly, Thomas, of Barley, husbandman 0
3704506 1927704 1927704 defendant Kyrkynshawe Richard yeoman 596963 596963 Kyrkynshawe, Richard, of Barley, yeoman 1
3704507 1927704 1927704 defendant Hancok Richard husbandman 596963 596963 Hancok, Richard, of Barley, husbandman 2
3704508 1927704 1927704 defendant Cartwright Robert husbandman 596963 596963 Cartwright, Robert, of Barley, husbandman 3
3714575 1930855 1930855 defendant Kendall William laborer 596963 596963 Kendall, William, of Barley, laborer 2
3776042 1950251 1950251 defendant Fletcher John   596963 596963 Fletcher, John, of Barley, scythe smith 1
3778050 1950849 1950849 defendant Asteley Henry gent 596963 596963 Asteley, Henry, of Barley, gent 0
3789334 1954484 1954484 defendant Assheley Henry gent 596963 596963 Assheley, Henry, of Barley, gent 2
3799038 1957610 1957610 defendant Totnam William husbandman 596963 596963 Totnam, William, of Barley, husbandman 1
3800179 1957976 1957976 defendant Grice Thomas husbandman 596963 596963 Grice, Thomas, of Barley, husbandman 1
3800180 1957976 1957976 defendant Kendall William fisher 596963 596963 Kendall, William, of Barley, fisher 2
3817501 1963382 1963382 defendant Thomason Christopher husbandman 596963 596963 Thomason, Christopher, of Barley, husbandman 8
3817502 1963382 1963382 defendant Wroos George sherman 596963 596963 Wroos, George, of Barley, sherman 9
3817503 1963382 1963382 defendant Thacwray Miles yeoman 596963 596963 Thacwray, Miles, of Barley, yeoman 10
3826285 1966070 1966070 plaintiff Astley Henry gent 596963 596963 Astley, Henry, of Barley, gent 0
3882527 1984423 1984423 defendant Fayrebrother Henry tailor 596963 596963 Fayrebrother, Henry, of Barley, tailor 0
3888871 1986526 1986526 defendant Cartwryght John husbandman 596963 596963 Cartwryght, John, of Barley, husbandman 1
3902459 1991053 1991053 defendant Langley Thomas yeoman 596963 596963 Langley, Thomas, of Barley, yeoman 0
3903242 1991309 1991309 defendant Whetcroft James husbandman 596963 596963 Whetcroft, James, of Barley, husbandman 0
3903243 1991309 1991309 defendant Moyre James husbandman 596963 596963 Moyre, James, of Barley, husbandman 1
3917383 1996173 1996173 plaintiff Grey John gent 596963 596963 Grey, John, of Barley, gent 0
3948008 2006367 2006367 defendant Tayler Thomas husbandman 596963 596963 Tayler, Thomas, of Barley, husbandman 0
4080725 2053416 2053416 defendant Nedham Alice widow 596963 596963 Nedham, Alice, of Barley, widow 1
4106707 2062690 2062690 defendant Jenynges Thomas yeoman 596963 596963 Jenynges, Thomas, of Barley, yeoman 0
4127918 2070275 2070275 defendant Chapman Stephen   596963 596963 Chapman, Stephen, of Barley, oatmeal man 0
4146998 2077096 2077096 defendant Morrys Anthony yeoman 596963 596963 Morrys, Anthony, of Barley, yeoman 0
4159006 2081218 2081218 defendant Calton John husbandman 596963 596963 Calton, John, of Barley, husbandman 0
4190327 2092133 2092133 defendant Stiff Humphrey innholder 596963 596963 Stiff, Humphrey, of Barley, or of Barkwaye, Herts, innholder 0
4199836 2095494 2095494 defendant Holbeame Thomas yeoman 596963 596963 Holbeame, Thomas, of Barley, yeoman 1
4236735 2108422 2108422 defendant Barley James gent 596963 596963 Barley, James, of Barley, gent 0
4274978 2121201 2121201 defendant Smythe Robert yeoman 596963 596963 (Smythe, Robert, of Barley, yeoman 1
4281104 2123291 2123291 defendant Parker Richard   596963 596963 Parker, Richard, of Barley, yeoman, his son 1
4315862 2135656 2135656 defendant Steed Nicholas yeoman 596963 596963 Steed, Nicholas, of Barley, yeoman 0
4319639 2136983 2136983 defendant Holbeame Thomas laborer 596963 596963 Holbeame, Thomas, of Barley, laborer 0
4385239 2159753 2159753 defendant Bolton Edmund yeoman 596963 596963 Bolton, Edmund, of Barley, yeoman 0
4390286 2161373 2161373 defendant Hancocke John husbandman 596963 596963 Hancocke, John, of Barley, husbandman 1
4397022 2163572 2163572 defendant Grinnell William yeoman 596963 596963 Grinnell, William, of Barley, yeoman 0
4411947 2168589 2168589 defendant Williatt Andrew clerk 596963 596963 Williatt, Andrew, of Barley, clerk 1
4467643 2190557 2190557 defendant Parker William   596963 596963 Parker, William, of Barley 0
4522179 2207282 2207282 defendant Jonesson Roger   596963 596963 Jonesson, Roger, of Barley 0
4522180 2207282 2207282 defendant Haseland John de   596963 596963 Haseland, John de, of Barley 1
4522182 2207282 2207282 defendant Clerk William   596963 596963 Clerk, William, of Barley 3
4573429 2223219 2223219 plaintiff Barley Robert   596963 596963 Barley, Robert, of Barley 0
4613493 2235238 2235238 plaintiff Darley Robert   596963 596963 Darley, Robert, of Barley 0
4671655 2256781 2256781 defendant del More Nicholas husbandman 596963 596963 del More, Nicholas, of Barley, husbandman 0
4681240 2259759 2259759 defendant Baysys John husbandman 596963 596963 Baysys, John, of Barley, husbandman 1
4682493 2260151 2260151 defendant Barley William gent 596963 596963 Barley, William, of Barley, gent 1
4743284 2278562 2278562 defendant Knotton John husbandman 596963 596963 Knotton, John, of Barley, husbandman 1
4743285 2278562 2278562 defendant Flecher Robert husbandman 596963 596963 Flecher, Robert, of Barley, husbandman 2
4744488 2278911 2278911 defendant Smyth Hugh husbandman 596963 596963 Smyth, Hugh, of Barley, husbandman 0
4744489 2278911 2278911 defendant Baxster William husbandman 596963 596963 Baxster, William, of Barley, husbandman 1
4821660 2302852 2302852 defendant Cartwryght William husbandman 596963 596963 Cartwryght, William, of Barley, husbandman 1
4821665 2302852 2302852 defendant Flemyng John husbandman 596963 596963 Flemyng, John, of Barley, husbandman 6
4875975 2319446 2319446 defendant Fencham John husbandman 596963 596963 Fencham, John, of Barley, husbandman 0
4930088 2335817 2335817 plaintiff Teye John   596963 596963 Teye, John, of Barley 0
4963512 2345999 2345999 defendant Hanson Richard yeoman 596963 596963 Hanson, Richard, of Barley, yeoman 0
5019635 2362632 2362632 defendant Porter Thomas husbandman 596963 596963 Porter, Thomas, of Barley, husbandman 0
5019636 2362632 2362632 defendant Page Richard   596963 596963 Page, Richard, of Barley, servant 1
5019637 2362632 2362632 defendant Couper William husbandman 596963 596963 Couper, William, of Barley, husbandman 2
5019638 2362632 2362632 defendant Preston William husbandman 596963 596963 Preston, William, of Barley, husbandman 3
5019639 2362632 2362632 defendant Chircheman John husbandman 596963 596963 Chircheman, John, of Barley, husbandman 4
5099849 2386392 2386392 defendant Drabull James laborer 596963 596963 Drabull, James, of Barley, laborer 6
5142362 2398888 2398888 plaintiff Whyte Robert   596963 596963 Whyte, Robert, of Barley 0
5342095 2457723 2457723 defendant Frere William husbandman 596963 596963 Frere, William, of Barley, husbandman 0
5354304 2461413 2461413 defendant Barre John husbandman 596963 596963 Barre, John, of Barley, husbandman 1

Next page

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