names

61 rows where place_id = 624025

✎ 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
3755699 1943742 1943742 defendant Clyvelode John fuller 624025 624025 Clyvelode, John, of Bekyngton, Soms, fuller 0
3779078 1951183 1951183 defendant Peryn John yeoman 624025 624025 Peryn, John, of Bekyngton, Soms, yeoman 0
3829908 1967246 1967246 defendant Peryn John yeoman 624025 624025 Peryn, John, of Bekyngton, Soms, yeoman 0
3856152 1975546 1975546 defendant Reynold John husbandman 624025 624025 Reynold, John, of Bekyngton, Soms, husbandman 1
3863443 1977965 1977965 defendant Myles Thomas husbandman 624025 624025 Myles, Thomas, of Bekyngton, Soms, husbandman 0
3906485 1992461 1992461 defendant Slege Thomas butcher 624025 624025 Slege, Thomas, of Bekyngton, Soms, butcher 0
4020399 2032017 2032017 defendant Longe Thomas gent 624025 624025 Longe, Thomas, of Bekyngton, Soms, gent 1
4585489 2226887 2226887 plaintiff Hamelyn John   624025 624025 Hamelyn, John, of Bekyngton, Soms 0
4676357 2258217 2258217 defendant Porveour Lawrence draper 624025 624025 Porveour, Lawrence, of Bekyngton, Soms, draper 0
4701606 2265896 2265896 defendant Porneour alias Purveour Lawrence draper 624025 624025 Porneour alias Purveour, Lawrence, of Bekyngton, Soms, draper 0
4707482 2267714 2267714 defendant Bosse Thomas   624025 624025 Bosse, Thomas, of Bekyngton, Soms, mason 1
4712260 2269151 2269151 defendant Dawe John, sen weaver 624025 624025 Dawe, John, sen, of Bekyngton, Soms, weaver 1
4716140 2270355 2270355 defendant Durley Edward fuller 624025 624025 Durley, Edward, of Bekyngton, Soms, fuller 1
4717453 2270796 2270796 defendant Mulward John weaver 624025 624025 Mulward, John, of Bekyngton, Soms, weaver 2
4718662 2271176 2271176 defendant Milward John weaver 624025 624025 Milward, John, of Bekyngton, Soms, weaver 2
4725619 2273299 2273299 defendant Prynce Richard weaver 624025 624025 Prynce, Richard, of Bekyngton, Soms, weaver 1
4726674 2273613 2273613 defendant Purveiour Lawrence   624025 624025 Purveiour, Lawrence, of Bekyngton, Soms, merchant, administrators of 0
4763071 2284433 2284433 defendant Prynce William husbandman 624025 624025 Prynce, William, of Bekyngton, Soms, husbandman 0
4763074 2284433 2284433 defendant Rose John baker 624025 624025 Rose, John, of Bekyngton, Soms, baker 3
4794975 2294570 2294570 defendant Barley Edward chapman 624025 624025 Barley, Edward, of Bekyngton, Soms, chapman 0
4836462 2307383 2307383 defendant Lane John   624025 624025 Lane, John, of Bekyngton, Soms, parson 0
4851588 2311930 2311930 defendant Asshewell John chapman 624025 624025 Asshewell, John, of Bekyngton, Soms, chapman 0
4871782 2318144 2318144 defendant Cantrell John chapman 624025 624025 Cantrell, John, of Bekyngton, Soms, chapman 1
4918580 2332328 2332328 defendant Wyskeley John husbandman 624025 624025 Wyskeley, John, of Bekyngton, Soms, husbandman 0
4933583 2336884 2336884 defendant Wyggysbe John yeoman 624025 624025 Wyggysbe, John, of Bekyngton, Soms, yeoman 2
4943079 2339809 2339809 defendant Wygysle John yeoman 624025 624025 Wygysle, John, of Bekyngton, Soms, yeoman 4
4948982 2341667 2341667 defendant Gaunterell John weaver 624025 624025 Gaunterell, John, of Bekyngton, Soms, weaver 0
4951935 2342553 2342553 defendant Nete John weaver 624025 624025 Nete, John, of Bekyngton, Soms, weaver 2
4963424 2345971 2345971 defendant Coke Robert carrier 624025 624025 Coke, Robert, of Bekyngton, Soms, carrier 3
4974797 2349433 2349433 defendant Canterell John weaver 624025 624025 Canterell, John, of Bekyngton, Soms, weaver 0
4984537 2352305 2352305 defendant Nete John chapman 624025 624025 Nete, John, of Bekyngton, Soms, ,chapman 2
4994113 2355113 2355113 defendant Gauter John merchant 624025 624025 Gauter, John, of Bekyngton, Soms, merchant 0
5008726 2359442 2359442 defendant Milleward John   624025 624025 Milleward, John, of Bekyngton, Soms, cloth maker 1
5011539 2360242 2360242 defendant Nete John chapman 624025 624025 Nete, John, of Bekyngton, Soms, chapman 1
5011596 2360252 2360252 defendant Nete John chapman 624025 624025 Nete, John, of Bekyngton, Soms, chapman 1
5028161 2365108 2365108 defendant Ganterell John weaver 624025 624025 Ganterell, John, of Bekyngton, Soms, weaver 0
5040728 2368839 2368839 defendant Nete John clothman 624025 624025 Nete, John, of Bekyngton, Soms, clothman 0
5046380 2370556 2370556 defendant Grenelane Thomas husbandman 624025 624025 Grenelane, Thomas, of Bekyngton, Soms, husbandman 0
5049372 2371446 2371446 defendant Nede John weaver 624025 624025 Nede, John, of Bekyngton, Soms, weaver 0
5062258 2375273 2375273 defendant Nete John clothmaker 624025 624025 Nete, John, of Bekyngton, Soms, clothmaker 0
5069154 2377271 2377271 defendant Donet Robert carrier 624025 624025 Donet, Robert, of Bekyngton, Soms, carrier 2
5073181 2378467 2378467 defendant Lane Walter clothier 624025 624025 Lane, Walter, of Bekyngton, Soms, clothier 0
5112206 2389951 2389951 defendant Brynkeley William clothier 624025 624025 Brynkeley, William, of Bekyngton, Soms, clothier 3
5151507 2401589 2401589 defendant Trappe Robert   624025 624025 Trappe, Robert, of Bekyngton, Soms, cloth maker 5
5169627 2406852 2406852 defendant Trappe Robert   624025 624025 Trappe, Robert, of Bekyngton, Soms, cloth maker 5
5190724 2413038 2413038 defendant Saymour Thomas   624025 624025 Saymour, Thomas, of Bekyngton, Soms, knight 0
5252603 2430930 2430930 defendant de St Mawr Thomas   624025 624025 de St Mawr, Thomas, of Bekyngton, Soms, knight 0
5315242 2449613 2449613 defendant Mayn John chapman 624025 624025 Mayn, John, of Bekyngton, Soms, chapman 3
5357800 2462510 2462510 defendant Favell or Fabell Roger clerk 624025 624025 Favell or Fabell, Roger, of Bekyngton, Soms, clerk 3
5434312 2485199 2485199 defendant Favell Roger clerk 624025 624025 Favell, Roger, of Bekyngton, Soms, clerk 4
5451088 2490217 2490217 plaintiff Sampson John clothman 624025 624025 Sampson, John, of Bekyngton, Soms, clothman 0
5461780 2493465 2493465 defendant Fabell Roger clerk 624025 624025 Fabell, Roger, of Bekyngton, Soms, clerk 4
5462759 2493772 2493772 defendant St More Thomas   624025 624025 St More, Thomas, of Bekyngton, Soms, knight 0
5462769 2493774 2493774 defendant Seymore Thomas   624025 624025 Seymore, Thomas, of Bekyngton, Soms, knight 0
5463206 2493909 2493909 plaintiff Sampson John clothman 624025 624025 Sampson, John, of Bekyngton, Soms, clothman 0
5473298 2496977 2496977 defendant Fabell Roger clerk 624025 624025 Fabell, Roger, of Bekyngton, Soms, clerk 4
5474302 2497291 2497291 defendant Seymore Thomas   624025 624025 Seymore, Thomas, of Bekyngton, Soms, knight 0
5474770 2497436 2497436 plaintiff Sampson John clothman 624025 624025 Sampson, John, of Bekyngton, Soms, clothman 0
5485742 2500632 2500632 defendant Seymore Thomas   624025 624025 Seymore, Thomas, of Bekyngton, Soms, knight 0
5485746 2500633 2500633 defendant Seyntmore Thomas   624025 624025 Seyntmore, Thomas, of Bekyngton, Soms, knight 0
5485750 2500634 2500634 defendant Seyntmore Thomas   624025 624025 Seyntmore, Thomas, of Bekyngton, Soms, knight 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);