names

48 rows where place_id = 605348

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3661262 1913798 1913798 defendant Spycer Thomas taverner 605348 605348 Spycer, Thomas, of Tewkesbury, Gloucs, taverner 0
3661265 1913799 1913799 defendant Spycer Thomas taverner 605348 605348 Spycer, Thomas, of Tewkesbury, Gloucs, taverner 0
3664861 1914955 1914955 defendant Gyldyng John yeoman 605348 605348 Gyldyng, John, of Tewkesbury, Gloucs, yeoman 0
3939465 2003505 2003505 defendant Flower James   605348 605348 Flower, James, of Tewkesbury, Gloucs, shoe maker 0
3939834 2003622 2003622 defendant Grene Robert   605348 605348 Grene, Robert, of Tewkesbury, Gloucs, cloth maker 2
4734001 2275820 2275820 defendant Apperley Adam gent 605348 605348 Apperley, Adam, of Tewkesbury, Gloucs, gent 0
4736819 2276644 2276644 defendant Tele John glover 605348 605348 Tele, John, of Tewkesbury, Gloucs, glover 2
4771598 2287095 2287095 defendant Adams John plumber 605348 605348 Adams, John, of Tewkesbury, Gloucs, plumber 0
4827201 2304556 2304556 defendant Roket Robert husbandman 605348 605348 Roket, Robert, of Tewkesbury, Gloucs, husbandman 0
4837686 2307719 2307719 defendant Bradwey Walter ironmonger 605348 605348 Bradwey, Walter, of Tewkesbury, Gloucs, ironmonger 1
4843458 2309472 2309472 defendant Draper Edmund chapman 605348 605348 Draper, Edmund, of Tewkesbury, Gloucs, chapman 0
4845981 2310247 2310247 defendant Carwent John chapman 605348 605348 Carwent, John, of Tewkesbury, Gloucs, chapman 3
4930201 2335851 2335851 defendant Bettys John, junior gent 605348 605348 Bettys, John, junior, of Tewkesbury, Gloucs, gent 0
4989512 2353797 2353797 defendant Webbe Thomas chapman 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, chapman 2
4993299 2354869 2354869 defendant Webbe Thomas chapman 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, chapman 2
4993303 2354870 2354870 defendant Webbe Thomas chapman 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, chapman 1
4994608 2355247 2355247 defendant Nelle Nicholas merchant 605348 605348 Nelle, Nicholas, of Tewkesbury, Gloucs, merchant 1
5000292 2356961 2356961 defendant Hobbys Richard carter 605348 605348 Hobbys, Richard, of Tewkesbury, Gloucs, carter 1
5001462 2357317 2357317 defendant Webbe Thomas mercer 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, mercer 1
5002876 2357744 2357744 defendant Webbe Thomas chapman 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, chapman 0
5002878 2357745 2357745 defendant Webbe Thomas chapman 605348 605348 Webbe, Thomas, of Tewkesbury, Gloucs, chapman 0
5005241 2358430 2358430 defendant Horsley Thomas chapman 605348 605348 Horsley, Thomas, of Tewkesbury, Gloucs, chapman 1
5005828 2358604 2358604 defendant Horsley Thomas chapman 605348 605348 Horsley, Thomas, of Tewkesbury, Gloucs, chapman 1
5011552 2360244 2360244 defendant Skotte Edmund chapman 605348 605348 Skotte, Edmund, of Tewkesbury, Gloucs, chapman 0
5011659 2360262 2360262 defendant Skotte Edmund chapman 605348 605348 Skotte, Edmund, of Tewkesbury, Gloucs, chapman 0
5011828 2360309 2360309 defendant Wylteschire John yeoman 605348 605348 Wylteschire, John, of Tewkesbury, Gloucs, yeoman 1
5011831 2360310 2360310 defendant Wylteschire John yeoman 605348 605348 Wylteschire, John, of Tewkesbury, Gloucs, yeoman 1
5047080 2370751 2370751 defendant Taillour Edmund tailor 605348 605348 Taillour, Edmund, of Tewkesbury, Gloucs, tailor 0
5128818 2394913 2394913 defendant Jet William mercer 605348 605348 Jet, William, of Tewkesbury, Gloucs, mercer 4
5185644 2411552 2411552 defendant Urle Roger shoemaker 605348 605348 Urle, Roger, of Tewkesbury, Gloucs, shoemaker 1
5186110 2411688 2411688 defendant Barton Ralph chapman 605348 605348 Barton, Ralph, of Tewkesbury, Gloucs, chapman 3
5197659 2415054 2415054 defendant Berton Ralph mercer 605348 605348 Berton, Ralph, of Tewkesbury, Gloucs, mercer 0
5199286 2415544 2415544 defendant Throgmerton John esq 605348 605348 Throgmerton, John, of Tewkesbury, Gloucs, esq 4
5204867 2417176 2417176 defendant Urle Roger   605348 605348 Urle, Roger, of Tewkesbury, Gloucs, shoe maker 1
5211046 2418963 2418963 defendant Throgmerton John esq 605348 605348 Throgmerton, John, of Tewkesbury, Gloucs, esq 4
5211058 2418964 2418964 defendant Throgmerton John esq 605348 605348 Throgmerton, John, of Tewkesbury, Gloucs, esq 4
5275142 2437805 2437805 defendant Weston Richard chapman 605348 605348 Weston, Richard, of Tewkesbury, Gloucs, chapman 0
5297677 2444326 2444326 defendant Whitfare William mercer 605348 605348 Whitfare, William, of Tewkesbury, Gloucs, mercer 1
5365635 2464921 2464921 defendant Comyn Henry yeoman 605348 605348 Comyn, Henry, of Tewkesbury, Gloucs, yeoman 0
5365641 2464922 2464922 defendant Comyn Henry yeoman 605348 605348 Comyn, Henry, of Tewkesbury, Gloucs, yeoman 0
5378773 2468948 2468948 defendant Boys William chapman 605348 605348 Boys, William, of Tewkesbury, Gloucs, chapman 0
5388074 2471649 2471649 defendant Rogers John butcher 605348 605348 Rogers, John, of Tewkesbury, Gloucs, butcher 0
5392962 2473056 2473056 defendant Hill Richard   605348 605348 Hill, Richard, of Tewkesbury, Gloucs 0
5392966 2473058 2473058 defendant Hyot Richard carrier 605348 605348 Hyot, Richard, of Tewkesbury, Gloucs, carrier 0
5394662 2473536 2473536 defendant ap John Burnam David yeoman 605348 605348 ap John Burnam, David, of Tewkesbury, Gloucs, yeoman 2
5407903 2477340 2477340 defendant ap John Burnam David yeoman 605348 605348 ap John Burnam, David, of Tewkesbury, Gloucs, yeoman 2
5441215 2487283 2487283 defendant Broke William chapman 605348 605348 Broke, William, of Tewkesbury, Gloucs, chapman 3
5448312 2489391 2489391 defendant Kyng Thomas chapman 605348 605348 Kyng, Thomas, of Tewkesbury, Gloucs, chapman 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);