names

51 rows where place_id = 638472

✎ 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
3842747 1971263 1971263 defendant Wolman John husbandman 638472 638472 Wolman, John, of Beklys, husbandman 4
4498934 2200306 2200306 plaintiff Godewyn Robert   638472 638472 Godewyn, Robert, of Beklys, on his own account 0
4498944 2200309 2200309 plaintiff Godwyn Robert   638472 638472 Godwyn, Robert, of Beklys, on his own account 0
4498945 2200309 2200309 defendant Coupere Matilda   638472 638472 Coupere, Matilda, of Beklys 0
4505682 2202289 2202289 defendant Rode John   638472 638472 Rode, John, of Beklys 0
4552074 2216600 2216600 defendant Taillour Richard   638472 638472 Taillour, Richard, of Beklys 0
4555929 2217793 2217793 plaintiff Hokham John   638472 638472 Hokham, John, of Beklys 0
4578743 2224839 2224839 defendant Walsyngham John   638472 638472 Walsyngham, John, of Beklys 3
4599425 2231036 2231036 plaintiff Styward John   638472 638472 Styward, John, of Beklys 0
4599428 2231036 2231036 defendant Sawer John   638472 638472 Sawer, John, of Beklys 2
4613615 2235272 2235272 defendant Slole John   638472 638472 Slole, John, of Beklys 1
4620827 2237492 2237492 defendant Rothe Walter   638472 638472 Rothe, Walter, of Beklys 4
4633216 2241258 2241258 defendant Rode Walter   638472 638472 Rode, Walter, of Beklys 3
4645229 2244675 2244675 defendant Scherman William   638472 638472 Scherman, William, of Beklys 5
4653452 2247010 2247010 defendant Wylde Henry yeoman 638472 638472 Wylde, Henry, of Beklys, yeoman 2
4736652 2276592 2276592 defendant Danby Robert mercer 638472 638472 Danby, Robert, of Beklys, mercer 0
4748833 2280146 2280146 defendant atte Mere William   638472 638472 atte Mere, William, of Beklys, sheep reeve or chief shepherd 0
4782939 2290684 2290684 defendant Dully John laborer 638472 638472 Dully, John, of Beklys, laborer 1
4793720 2294153 2294153 defendant Dersyngham Henry sherman 638472 638472 Dersyngham, Henry, of Beklys, sherman 0
4795746 2294821 2294821 plaintiff Roo John   638472 638472 Roo, John, of Beklys 0
4795748 2294822 2294822 plaintiff Roo John   638472 638472 Roo, John, of Beklys 0
4865366 2316136 2316136 defendant Shirrewhit Thomas carpenter 638472 638472 Shirrewhit, Thomas, of Beklys, carpenter 0
4865367 2316136 2316136 defendant Fraunceys Isabel widow 638472 638472 Fraunceys, Isabel, of Beklys, widow 1
4881699 2321176 2321176 defendant Wyske John laborer 638472 638472 Wyske, John, of Beklys, laborer 0
4881700 2321176 2321176 defendant Wyske Alan butcher 638472 638472 Wyske, Alan, of Beklys, butcher 1
4895103 2325131 2325131 defendant Cotowan William husbandman 638472 638472 Cotowan, William, of Beklys, husbandman 2
4896514 2325580 2325580 defendant Fraunceys William yeoman 638472 638472 Fraunceys, William, of Beklys, yeoman 0
4898456 2326171 2326171 defendant Cotewan William husbandman 638472 638472 Cotewan, William, of Beklys, husbandman 2
4899474 2326477 2326477 defendant Dykes Thomas   638472 638472 Dykes, Thomas, of Beklys, servant 0
4934795 2337280 2337280 defendant Clerk Simon baker 638472 638472 Clerk, Simon, of Beklys, baker 2
5031395 2366039 2366039 defendant Walpole William sawyer 638472 638472 Walpole, William, of Beklys, sawyer 0
5060276 2374645 2374645 defendant Burnham Richard tailor 638472 638472 Burnham, Richard, of Beklys, tailor 0
5060277 2374645 2374645 defendant Halle Edmund smith 638472 638472 Halle, Edmund, of Beklys, smith 1
5064377 2375892 2375892 defendant Brymmouth John yeoman 638472 638472 Brymmouth, John, of Beklys, yeoman 6
5076353 2379430 2379430 defendant Talbot Roger dyer 638472 638472 Talbot, Roger, of Beklys, dyer 0
5076356 2379431 2379431 defendant Talbott Roger dyer 638472 638472 Talbott, Roger, of Beklys, dyer 0
5334484 2455388 2455388 defendant Wolsy William   638472 638472 Wolsy, William, of Beklys, tallow chandler 0
5340579 2457254 2457254 defendant Chapeleyn Geoffrey yeoman 638472 638472 Chapeleyn, Geoffrey, of Beklys, yeoman 0
5340581 2457255 2457255 defendant Chapeleyn Geoffrey yeoman 638472 638472 Chapeleyn, Geoffrey, of Beklys, yeoman 0
5346854 2459173 2459173 defendant Godwyn John barker 638472 638472 Godwyn, John, of Beklys, barker 0
5346856 2459174 2459174 defendant Goodwyn John barker 638472 638472 Goodwyn, John, of Beklys, barker 0
5353016 2461032 2461032 defendant Boteswayn Thomas baker 638472 638472 Boteswayn, Thomas, of Beklys, baker 0
5353017 2461032 2461032 defendant Frebarne Thomas baker 638472 638472 Frebarne, Thomas, of Beklys, baker 1
5353018 2461032 2461032 defendant Bungey Thomas baker 638472 638472 Bungey, Thomas, of Beklys, baker 2
5423243 2481916 2481916 defendant Goche Robert butcher 638472 638472 Goche, Robert, of Beklys, butcher 0
5423249 2481918 2481918 defendant Goche Robert butcher 638472 638472 Goche, Robert, of Beklys, butcher 0
5471042 2496277 2496277 defendant Bakke John yeoman 638472 638472 Bakke, John, of Beklys, yeoman 2
5488245 2501384 2501384 defendant Moyse John butcher 638472 638472 Moyse, John, of Beklys, butcher 0
5504195 2506227 2506227 defendant Foxley John husbandman 638472 638472 Foxley, John, of Beklys, husbandman 1
5630856 2553658 2553658 defendant Billyng John sherman 638472 638472 Billyng, John, of Beklys, sherman 0
5630857 2553658 2553658 defendant Sherman William sherman 638472 638472 Sherman, William, of Beklys, sherman 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);