names

76 rows where place_id = 586820

✎ 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
3589731 1864427 1864427 defendant Jay Robert yeoman 586820 586820 Jay, Robert, of Swanton Abbot, yeoman 1
3598216 1867073 1867073 defendant Geay John yeoman 586820 586820 Geay, John, of Swanton Abbot, yeoman 1
3604298 1869008 1869008 defendant Jaye John   586820 586820 Jaye, John, of Swanton Abbot, worsted weaver 0
3648605 1909952 1909952 defendant Jay John   586820 586820 Jay, John, of Swanton, worsted weaver 4
3684307 1921226 1921226 defendant Persen John husbandman 586820 586820 Persen, John, of Swanton, husbandman 3
3781480 1951945 1951945 defendant Scothowe John husbandman 586820 586820 Scothowe, John, of Swanton Abbot, husbandman 2
3792381 1955478 1955478 defendant Wysse John husbandman 586820 586820 Wysse, John, of Swanton, husbandman 1
3803904 1959133 1959133 defendant Postell Richard husbandman 586820 586820 Postell, Richard, of Swanton Abbot, husbandman 2
3812039 1961675 1961675 defendant Ponyett Richard, junior laborer 586820 586820 Ponyett, Richard, junior, of Swanton, laborer 0
3823027 1965111 1965111 defendant Postell John   586820 586820 Postell, John, of Swanton Abbot, worsted weaver 0
3823029 1965112 1965112 defendant Postes Richard   586820 586820 Postes, Richard, of Swanton Abbot, worsted weaver 0
3834868 1968846 1968846 defendant Postyll John   586820 586820 Postyll, John, of Swanton, worsted weaver 1
3836772 1969399 1969399 defendant Postyll Richard husbandman 586820 586820 Postyll, Richard, of Swanton Abbot, husbandman 3
3849357 1973396 1973396 defendant Petyll Richard   586820 586820 Petyll, Richard, of Swanton Abbot, worsted weaver 0
3864273 1978244 1978244 defendant Pestyll Richard   586820 586820 Pestyll, Richard, of Swanton Abbot, worsted weaver 0
4038456 2038392 2038392 plaintiff Lawes Robert (legal representative) 586820 586820 Lawes, Robert, of Swanton, butcher, executors of 0
4052028 2043150 2043150 defendant Lawes Robert (legal representative) 586820 586820 Lawes, Robert, of Swanton, butcher, executors of 0
4131459 2071571 2071571 defendant Robert John husbandman 586820 586820 Robert, John, of Swanton Abbot, husbandman 0
4139088 2074347 2074347 defendant Gryme Robert shoemaker 586820 586820 Gryme, Robert, of Swanton, shoemaker 1
4145951 2076738 2076738 defendant Robertes John yeoman 586820 586820 Robertes, John, of Swanton Abbot, yeoman 2
4148389 2077566 2077566 defendant Stowe John tailor 586820 586820 Stowe, John, of Swanton Nover, tailor 2
4155171 2079901 2079901 defendant Robert John husbandman 586820 586820 Robert, John, of Swanton Abbot, husbandman 0
4160893 2081882 2081882 defendant Robard John yeoman 586820 586820 Robard, John, of Swanton Abbot, yeoman 0
4310275 2133747 2133747 defendant Sheringham George yeoman 586820 586820 Sheringham, George, of Swanton, or of Est Derham, yeoman 0
4344619 2145397 2145397 defendant Beckham Edward yeoman 586820 586820 Beckham, Edward, of Swanton, yeoman 1
4389360 2161067 2161067 defendant Myller John weaver 586820 586820 Myller, John, of Swanton, weaver 3
4464973 2189711 2189711 defendant Tubbe Thomas   586820 586820 Tubbe, Thomas, of Swanton 0
4464975 2189711 2189711 defendant Dennys Peter   586820 586820 Dennys, Peter, of Swanton 2
4518488 2206155 2206155 defendant Pye Oliver   586820 586820 Pye, Oliver, of Swanton 0
4579024 2224920 2224920 defendant Pye Oliver   586820 586820 Pye, Oliver, of Swanton 0
4593739 2229314 2229314 defendant Bunch Thomas   586820 586820 Bunch, Thomas, of Swanton, bailiff 3
4612448 2234959 2234959 plaintiff Coupere John   586820 586820 Coupere, John, of Swanton 0
4630681 2240500 2240500 defendant Ropere Nicholas   586820 586820 Ropere, Nicholas, of Swanton 3
4651200 2246380 2246380 defendant Reed William yeoman 586820 586820 Reed, William, of Swanton Abbot, yeoman 1
4683686 2260498 2260498 defendant Rede William yeoman 586820 586820 Rede, William, of Swanton, yeoman 3
4732607 2275375 2275375 plaintiff Bernard John   586820 586820 Bernard, John, of Swanton 1
4768227 2286034 2286034 defendant Cay Richard chaplain 586820 586820 Cay, Richard, of Swanton, chaplain 0
4768230 2286035 2286035 defendant Cay Richard chaplain 586820 586820 Cay, Richard, of Swanton, chaplain 0
4814202 2300547 2300547 defendant Horn Thomas yeoman 586820 586820 Horn, Thomas, of Swanton Abbot, yeoman 2
4840844 2308672 2308672 defendant Holm Robert yeoman 586820 586820 Holm, Robert, of Swanton Abbot, yeoman 0
4847655 2310757 2310757 defendant Lenton William chaplain 586820 586820 Lenton, William, of Swanton Abbot, chaplain 0
4867305 2316737 2316737 defendant Dokkyng Robert husbandman 586820 586820 Dokkyng, Robert, of Swanton, husbandman 2
5024714 2364149 2364149 defendant Bolt Richard butcher 586820 586820 Bolt, Richard, of Swanton Abbot, butcher 2
5025103 2364241 2364241 defendant Holme John yeoman 586820 586820 Holme, John, of Swanton Abbot, yeoman 3
5025104 2364241 2364241 defendant Holme Oliver yeoman 586820 586820 Holme, Oliver, of Swanton Abbot, yeoman 4
5065831 2376301 2376301 defendant Horn Thomas   586820 586820 Horn, Thomas, of Swanton Abbot, ploughwright 0
5065832 2376301 2376301 defendant Tuk John yeoman 586820 586820 Tuk, John, of Swanton Abbot, yeoman 1
5065834 2376301 2376301 defendant Sawer Edmund sawyer 586820 586820 Sawer, Edmund, of Swanton Abbot, sawyer 3
5065835 2376301 2376301 defendant Wright Henry yeoman 586820 586820 Wright, Henry, of Swanton Abbot, yeoman 4
5069265 2377295 2377295 defendant Sawer Edmund sawyer 586820 586820 Sawer, Edmund, of Swanton Abbot, sawyer 6
5092332 2384135 2384135 defendant Doule or Donle Walter laborer 586820 586820 Doule or Donle, Walter, of Swanton Abbot, laborer 2
5118100 2391726 2391726 defendant Dowe Walter husbandman 586820 586820 Dowe, Walter, of Swanton Abbot, husbandman 9
5123814 2393422 2393422 plaintiff Wrighte Simon (legal representative) 586820 586820 Wrighte, Simon, of Swanton Abbot, executors of 0
5137103 2397365 2397365 defendant Holm Oliver yeoman 586820 586820 Holm, Oliver, of Swanton Abbot, yeoman 0
5143536 2399245 2399245 defendant Suffen Robert weaver 586820 586820 Suffen, Robert, of Swanton Abbot, weaver 0
5157727 2403389 2403389 defendant Holm Olver yeoman 586820 586820 Holm, Olver, of Swanton Abbot, yeoman 0
5231096 2424692 2424692 plaintiff Bernard William   586820 586820 Bernard, William, of Swanton 2
5239978 2427268 2427268 defendant Doredraught Henry yeoman 586820 586820 Doredraught, Henry, of Swanton Abbot, yeoman 1
5239983 2427269 2427269 defendant Skothowe William yeoman 586820 586820 Skothowe, William, of Swanton Abbot, yeoman 1
5239984 2427269 2427269 defendant Ante Robert yeoman 586820 586820 Ante, Robert, of Swanton Abbot, yeoman 2
5239996 2427274 2427274 defendant Edmondes Robert yeoman 586820 586820 Edmondes, Robert, of Swanton Abbot, yeoman 0
5254546 2431543 2431543 defendant Derdraught Henry husbandman 586820 586820 Derdraught, Henry, of Swanton Abbot, husbandman 3
5278621 2438860 2438860 defendant Hoddys Robert yeoman 586820 586820 Hoddys, Robert, of Swanton Abbot, yeoman 2
5323509 2452111 2452111 defendant Monyment John laborer 586820 586820 Monyment, John, of Swanton Abbot, laborer 3
5331745 2454579 2454579 defendant Edmondys Robert husbandman 586820 586820 Edmondys, Robert, of Swanton Abbot, husbandman 2
5352166 2460778 2460778 plaintiff Emondys Robert   586820 586820 Emondys, Robert, of Swanton Abbot 0
5358417 2462684 2462684 defendant Lesyngham Robert yeoman 586820 586820 Lesyngham, Robert, of Swanton, yeoman 1
5391296 2472590 2472590 defendant Jaye Robert   586820 586820 Jaye, Robert, of Swanton Abbot, worsted weaver 0
5480261 2499077 2499077 defendant Emmundys Robert courser 586820 586820 Emmundys, Robert, of Swanton Abbot, courser 0
5480263 2499078 2499078 defendant Emondys Robert courser 586820 586820 Emondys, Robert, of Swanton Abbot, courser 0
5480265 2499079 2499079 defendant Emundys Robert courser 586820 586820 Emundys, Robert, of Swanton Abbot, courser 0
5491251 2502270 2502270 defendant Tucke John yeoman 586820 586820 Tucke, John, of Swanton Abbot, yeoman 3
5491252 2502270 2502270 defendant Sporell John yeoman 586820 586820 Sporell, John, of Swanton Abbot, yeoman 4
5546063 2518844 2518844 defendant Geay Robert yeoman 586820 586820 Geay, Robert, of Swanton Abbot, yeoman 0
5577185 2527915 2527915 plaintiff Warner Richard clerk 586820 586820 Warner, Richard, of Swanton Abbot, clerk 0
5603750 2536042 2536042 defendant Jay John   586820 586820 Jay, John, of Swanton Abbot, worsted weaver 3

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