names

53 rows where place_id = 617974

✎ 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
3722148 1933189 1933189 defendant Estwode Thomas husbandman 617974 617974 Estwode, Thomas, of Benyngworth, husbandman 1
3729859 1935596 1935596 defendant Barkworth Thomas husbandman 617974 617974 Barkworth, Thomas, of Benyngworth, husbandman 1
3833951 1968558 1968558 defendant Dowco William husbandman 617974 617974 Dowco, William, of Benyngworth, husbandman 0
3838606 1970001 1970001 defendant Marlynge John gent 617974 617974 Marlynge, John, of Benyngworth, gent 0
3849991 1973584 1973584 defendant Dowce William husbandman 617974 617974 Dowce, William,of Benyngworth, husbandman 0
3854893 1975174 1975174 defendant Marlyng John gent 617974 617974 Marlyng, John, of Benyngworth, gent 0
3859057 1976520 1976520 defendant Berkworth Thomas yeoman 617974 617974 Berkworth, Thomas, of Benyngworth, yeoman 0
3859058 1976520 1976520 defendant Berkworth George yeoman 617974 617974 Berkworth, George, of Benyngworth, yeoman 1
3863085 1977854 1977854 defendant Barkworth Thomas husbandman 617974 617974 Barkworth, Thomas, of Benyngworth, husbandman 0
3873216 1981258 1981258 defendant Berkworth Thomas yeoman 617974 617974 Berkworth, Thomas, of Benyngworth, yeoman 0
3873217 1981258 1981258 defendant Berkworth George yeoman 617974 617974 Berkworth, George, of Benyngworth, yeoman 1
3873219 1981259 1981259 defendant Berkworth Thomas yeoman 617974 617974 Berkworth, Thomas, of Benyngworth, yeoman 0
3873220 1981259 1981259 defendant Berkworth George yeoman 617974 617974 Berkworth, George, of Benyngworth, yeoman 1
3984332 2019159 2019159 plaintiff Symcott William gent 617974 617974 Symcott, William, of Benyngworth, or of Lowthe, gent 0
4367792 2153532 2153532 defendant Mumbye Elizabeth widow 617974 617974 Mumbye, Elizabeth, of Benyngworth, widow 4
4416007 2169896 2169896 plaintiff Lavyngton John de (legal representative) 617974 617974 Lavyngton, John de, of Benyngworth, parson, executor of 0
4420563 2171333 2171333 defendant Donyngton Robert de   617974 617974 Donyngton, Robert de, of Benyngworth, knight 0
4423439 2172182 2172182 defendant Rose William chaplain 617974 617974 Rose, William, of Benyngworth, chaplain 1
4475477 2193007 2193007 defendant Denyngton Robert   617974 617974 Denyngton, Robert, of Benyngworth 1
4506450 2202518 2202518 defendant Donyngton Robert de   617974 617974 Donyngton, Robert de, of Benyngworth 0
4507412 2202783 2202783 defendant Donyngton John de   617974 617974 Donyngton, John de, of Benyngworth 0
4538075 2212191 2212191 defendant Donyngton Robert de   617974 617974 Donyngton, Robert de, of Benyngworth 0
4554673 2217389 2217389 plaintiff Halgarth William   617974 617974 Halgarth, William, of Benyngworth 0
4558178 2218499 2218499 defendant donyngton John   617974 617974 donyngton, John, of Benyngworth 2
4839928 2308400 2308400 defendant Donyngton Robert husbandman 617974 617974 Donyngton, Robert, of Benyngworth, husbandman 3
4856271 2313333 2313333 defendant Scamulssby Robert husbandman 617974 617974 Scamulssby, Robert, of Benyngworth, husbandman 1
4856272 2313333 2313333 defendant Belle John husbandman 617974 617974 Belle, John, of Benyngworth, husbandman 2
4857026 2313577 2313577 defendant Scamulsby Robert husbandman 617974 617974 Scamulsby, Robert, of Benyngworth, husbandman 2
4857027 2313577 2313577 defendant Wells John husbandman 617974 617974 Wells, John, of Benyngworth, husbandman 3
4867201 2316702 2316702 defendant Donyngton Robert husbandman 617974 617974 Donyngton, Robert, of Benyngworth, husbandman 2
4932843 2336658 2336658 defendant Grene Robert husbandman 617974 617974 Grene, Robert, of Benyngworth, husbandman 0
4951801 2342513 2342513 defendant Donyngton Robert merchant 617974 617974 Donyngton, Robert, of Benyngworth, merchant 0
5016474 2361713 2361713 defendant Hanne Thomas husbandman 617974 617974 Hanne, Thomas, of Benyngworth, husbandman 2
5016475 2361713 2361713 defendant Forster John husbandman 617974 617974 Forster, John, of Benyngworth, husbandman 3
5016477 2361713 2361713 defendant Grene Robert husbandman 617974 617974 Grene, Robert, of Benyngworth, husbandman 5
5016480 2361713 2361713 defendant Madour John husbandman 617974 617974 Madour, John, of Benyngworth, husbandman 8
5059120 2374294 2374294 defendant Madyr John yeoman 617974 617974 Madyr, John, of Benyngworth, yeoman 1
5072955 2378396 2378396 defendant Otby Robert gent 617974 617974 (Otby, Robert, of Benyngworth, gent 3
5099995 2386436 2386436 defendant Mader John husbandman 617974 617974 Mader, John, of Benyngworth, husbandman 1
5109292 2389144 2389144 defendant Scamulsby Robert husbandman 617974 617974 Scamulsby, Robert, of Benyngworth, husbandman 0
5109293 2389144 2389144 defendant Madyr John husbandman 617974 617974 Madyr, John, of Benyngworth, husbandman 1
5139540 2398051 2398051 defendant Madyr (illegible) husbandman 617974 617974 Madyr, ---, of Benyngworth, husbandman 1
5228153 2423842 2423842 defendant Mader John husbandman 617974 617974 Mader, John, of Benyngworth, husbandman 0
5240783 2427515 2427515 defendant Mather John husbandman 617974 617974 Mather, John, of Benyngworth, husbandman 1
5240786 2427516 2427516 defendant Mather John husbandman 617974 617974 Mather, John, of Benyngworth, husbandman 1
5242065 2427881 2427881 defendant Madyr John, senior husbandman 617974 617974 Madyr, John, senior, of Benyngworth, husbandman 0
5242066 2427881 2427881 defendant Madyr John, junior husbandman 617974 617974 Madyr, John, junior, of Benyngworth, husbandman 1
5261641 2433751 2433751 defendant Barkeworth John gent 617974 617974 Barkeworth, John, of Benyngworth, gent 0
5266530 2435281 2435281 defendant Fryth Thomas husbandman 617974 617974 Fryth, Thomas, of Benyngworth, husbandman 0
5266531 2435281 2435281 defendant Boret Robert husbandman 617974 617974 Boret, Robert, of Benyngworth, husbandman 1
5266532 2435281 2435281 defendant Smyth John husbandman 617974 617974 Smyth, John, of Benyngworth, husbandman 2
5525364 2512522 2512522 defendant Wentworth Francis yeoman 617974 617974 Wentworth, Francis, of Benyngworth, yeoman 1
5530745 2514133 2514133 defendant Skamelsby William yeoman 617974 617974 Skamelsby, William, of Benyngworth, yeoman 2

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