names

97 rows where place_id = 591070

✎ 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
3603228 1868678 1868678 defendant Insam William husbandman 591070 591070 Insam, William, of Refham, husbandman 0
3616034 1872648 1872648 defendant Alpe Walter butcher 591070 591070 Alpe, Walter, of Refham, butcher 5
3631333 1904610 1904610 defendant Burre John pedder 591070 591070 Burre, John, of Refham, pedder 0
3735593 1937366 1937366 defendant Cokkyll Roger draper 591070 591070 Cokkyll, Roger, of Refham or of Buxston, draper 1
3735597 1937367 1937367 defendant Cokkyll Roger draper 591070 591070 Cokkyll, Roger, of Refham or of Buxston, draper 1
3744491 1940179 1940179 defendant Burre George husbandman 591070 591070 Burre, George, of Refham, husbandman 0
3744492 1940179 1940179 defendant Cady Edmund husbandman 591070 591070 Cady, Edmund, of Refham, husbandman 1
3840744 1970671 1970671 defendant Harvy Robert painter 591070 591070 Harvy, Robert, of Refham, painter 1
4459139 2187904 2187904 defendant Aleyn Richard, junior   591070 591070 Aleyn, Richard, junior, of Refham 4
4471880 2191869 2191869 plaintiff Childle John   591070 591070 Childle, John, of refham 0
4482094 2195111 2195111 defendant Bayly John   591070 591070 Bayly, John, of Refham 0
4486215 2196395 2196395 plaintiff Ruald Thomas   591070 591070 Ruald, Thomas, of Refham, administrators of 0
4492408 2198307 2198307 plaintiff Yerburgh John de   591070 591070 Yerburgh, John de, of Refham, on his own account 0
4492415 2198309 2198309 defendant Jakson John   591070 591070 Jakson, John, of Refham 0
4543877 2213986 2213986 plaintiff Bailly John   591070 591070 Bailly, John, of Refham 0
4543879 2213986 2213986 defendant Child John   591070 591070 Child, John, of Refham 1
4562358 2219789 2219789 defendant Popy Richard chaplain 591070 591070 Popy, Richard, of Refham, chaplain 1
4565088 2220651 2220651 defendant Popy Richard   591070 591070 Popy, Richard, of Refham 1
4565090 2220651 2220651 defendant Grey Thomas   591070 591070 Grey, Thomas, of Refham 3
4577631 2224508 2224508 defendant Hannay William   591070 591070 Hannay, William, of Refham 2
4581252 2225603 2225603 defendant Greyve Thomas   591070 591070 Greyve, Thomas, of Refham 3
4595617 2229896 2229896 plaintiff Ricald Geoffrey   591070 591070 Ricald, Geoffrey, of Refham 0
4671141 2256638 2256638 defendant Smythe Robert husbandman 591070 591070 Smythe, Robert, of Refham, husbandman 3
4741142 2277914 2277914 defendant Asselyn William husbandman 591070 591070 Asselyn, William, of Refham, husbandman 2
4932923 2336686 2336686 defendant Leyceter Robert clerk 591070 591070 Leyceter, Robert, of Refham, clerk 0
4949332 2341775 2341775 defendant Burre John pedder 591070 591070 Burre, John, of Refham, pedder 3
4959597 2344829 2344829 defendant Dawes Robert husbandman 591070 591070 Dawes, Robert, of Refham, husbandman 1
4972328 2348663 2348663 defendant Tetill Richard   591070 591070 Tetill, Richard, of Refham, servant 3
4998636 2356477 2356477 defendant Strugges William husbandman 591070 591070 Strugges, William, of Refham, husbandman 0
5030859 2365896 2365896 defendant Brysle Thomas husbandman 591070 591070 Brysle, Thomas, of Refham, husbandman 0
5030860 2365896 2365896 defendant Hare Geoffrey husbandman 591070 591070 Hare, Geoffrey, of Refham, husbandman 1
5047602 2370901 2370901 defendant Ryborgh John tailor 591070 591070 Ryborgh, John, of Refham, tailor 2
5055601 2373250 2373250 defendant Jurdon William yeoman 591070 591070 Jurdon, William, of Refham, yeoman 1
5067680 2376827 2376827 defendant Whele Robert husbandman 591070 591070 Whele, Robert, of Refham, husbandman 0
5070433 2377649 2377649 defendant Twytney John fuller 591070 591070 Twytney, John, of Refham, fuller 2
5111290 2389692 2389692 plaintiff Herth or Hert Robert (legal representative) 591070 591070 Herth or Hert, Robert, of Refham, executors of 0
5137353 2397437 2397437 defendant Branton John husbandman 591070 591070 Branton, John, of Refham, husbandman 1
5158004 2403464 2403464 defendant Branton John husbandman 591070 591070 Branton, John, of Refham, husbandman 1
5270552 2436483 2436483 defendant Plattyng John butcher 591070 591070 Plattyng, John, of Refham, butcher 1
5280578 2439396 2439396 defendant Cok Robert husbandman 591070 591070 Cok, Robert, of Refham, husbandman 0
5281816 2439754 2439754 defendant Mannyng John laborer 591070 591070 Mannyng, John, of Refham, laborer 0
5288076 2441529 2441529 defendant Plattyng John butcher 591070 591070 Plattyng, John, of Refham, butcher 0
5288477 2441648 2441648 defendant Laverok John laborer 591070 591070 Laverok, John, of Refham, laborer 13
5289216 2441849 2441849 defendant Dakke or Bakke John, junior husbandman 591070 591070 Dakke or Bakke, John, junior, of Refham, husbandman 0
5294222 2443281 2443281 plaintiff Stemmes William clerk 591070 591070 Stemmes, William, of Refham, clerk 0
5294229 2443282 2443282 plaintiff Stemmes William clerk 591070 591070 Stemmes, William, of Refham, clerk 0
5300655 2445158 2445158 plaintiff Cok Robert   591070 591070 Cok, Robert, of Refham 0
5300658 2445158 2445158 defendant Carter John husbandman 591070 591070 Carter, John, of Refham, husbandman 2
5307996 2447409 2447409 defendant Burre Roger laborer 591070 591070 Burre, Roger, of Refham, laborer 1
5324675 2452451 2452451 defendant Burre Roger laborer 591070 591070 Burre, Roger, of Refham, laborer 1
5324800 2452495 2452495 defendant Plattyng John husbandman 591070 591070 Plattyng, John, of Refham, husbandman 3
5325051 2452573 2452573 defendant Burre Roger husbandman 591070 591070 Burre, Roger, of Refham, husbandman 3
5339919 2457054 2457054 defendant Redman Thomas chapman 591070 591070 Redman, Thomas, of Refham, chapman 0
5347720 2459440 2459440 defendant Burre John pedder 591070 591070 Burre, John, of Refham, pedder 4
5348873 2459778 2459778 defendant Growete William husbandman 591070 591070 Growete, William, of Refham, husbandman 0
5359251 2462930 2462930 defendant Hagon Richard husbandman 591070 591070 Hagon, Richard, of Refham, husbandman 4
5366524 2465185 2465185 defendant Frosteyn William carpenter 591070 591070 Frosteyn, William, of Refham, carpenter 0
5366525 2465185 2465185 defendant Basse Benedict laborer 591070 591070 Basse, Benedict, of Refham, laborer 1
5375112 2467801 2467801 defendant Cady Thomas fuller 591070 591070 Cady, Thomas, of Refham, fuller 0
5377353 2468508 2468508 plaintiff Stemmes William (legal representative) 591070 591070 Stemmes, William, of Refham, clerk, executors of 0
5384776 2470725 2470725 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5394682 2473541 2473541 defendant Carter John husbandman 591070 591070 Carter, John, of Refham, husbandman 9
5396793 2474170 2474170 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5406435 2476914 2476914 plaintiff Stemines or Stemmes William (legal representative) 591070 591070 Stemines or Stemmes, William, of Refham, clerk, executors of 0
5406444 2476915 2476915 plaintiff Stemines William (legal representative) 591070 591070 Stemines, William, of Refham, clerk, executors of 0
5410038 2477962 2477962 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5414068 2479141 2479141 defendant Myllyngton Thomas husbandman 591070 591070 Myllyngton, Thomas, of Refham, husbandman 2
5419558 2480773 2480773 plaintiff Stevines William (legal representative) 591070 591070 Stevines, William, of Refham, clerk, executors of 0
5419566 2480774 2480774 plaintiff Stevunes William (legal representative) 591070 591070 Stevunes, William, of Refham, clerk, executors of 0
5429679 2483814 2483814 defendant Myllyngton Thomas husbandman 591070 591070 Myllyngton, Thomas, of Refham, husbandman 2
5429683 2483815 2483815 defendant Myllyngton Thomas husbandman 591070 591070 Myllyngton, Thomas, of Refham, husbandman 2
5429687 2483816 2483816 defendant Myllyngton Thomas husbandman 591070 591070 Myllyngton, Thomas, of Refham, husbandman 2
5430637 2484101 2484101 defendant Redeman Thomas husbandman 591070 591070 Redeman, Thomas, of Refham, husbandman 3
5437939 2486284 2486284 plaintiff Stemmes William (legal representative) 591070 591070 Stemmes, William, of Refham, clerk, executors of 0
5437946 2486285 2486285 plaintiff Stemmes William (legal representative) 591070 591070 Stemmes, William, of Refham, clerk, executors of 0
5440320 2487005 2487005 defendant Carter John husbandman 591070 591070 Carter, John, of Refham, husbandman 8
5449805 2489831 2489831 defendant Arnald William yeoman 591070 591070 Arnald, William, of Refham, yeoman 1
5450069 2489909 2489909 defendant Redman Thomas husbandman 591070 591070 Redman, Thomas, of Refham, husbandman 5
5458147 2492345 2492345 defendant Arnold William   591070 591070 Arnold, William, of Refham, mason 0
5461973 2493521 2493521 defendant Arnald William yeoman 591070 591070 Arnald, William, of Refham, yeoman 2
5462241 2493608 2493608 defendant Redman Thomas husbandman 591070 591070 Redman, Thomas, of Refham, husbandman 4
5469841 2495908 2495908 defendant Arnold William   591070 591070 Arnold, William, of Refham, mason 0
5473483 2497032 2497032 defendant Arnaold William yeoman 591070 591070 Arnaold, William, of Refham, yeoman 1
5485008 2500436 2500436 defendant Arnold alias Podde William yeoman 591070 591070 Arnold alias Podde, William, of Refham, yeoman 0
5485016 2500437 2500437 defendant Recokke John husbandman 591070 591070 Recokke, John, of Refham, husbandman 3
5496492 2503860 2503860 defendant Grene Thomas clerk 591070 591070 Grene, Thomas, of Refham, clerk 0
5498585 2504519 2504519 defendant Arnold alias Podde William yeoman 591070 591070 Arnold alias Podde, William, of Refham, yeoman 3
5500873 2505204 2505204 defendant Twydney John husbandman 591070 591070 Twydney, John, of Refham, husbandman 1
5501718 2505470 2505470 plaintiff Stemmes William (legal representative) 591070 591070 Stemmes, William, of Refham, clerk, executors of 0
5504333 2506269 2506269 defendant Cady Thomas sherman 591070 591070 Cady, Thomas, of Refham, sherman 0
5532065 2514570 2514570 defendant Clerke Robert husbandman 591070 591070 Clerke, Robert, of Refham, husbandman 0
5566607 2524828 2524828 defendant Fyssher John butcher 591070 591070 Fyssher, John, of Refham, butcher 0
5570754 2526006 2526006 defendant Lowes William   591070 591070 Lowes, William, of Refham, wax chandler 0
5574339 2527062 2527062 defendant Fysher John husbandman 591070 591070 Fysher, John, of Refham, husbandman 3
5581525 2529296 2529296 defendant Fyssher John butcher 591070 591070 Fyssher, John, of Refham, butcher 0
5620380 2550233 2550233 defendant Umfrey Adam   591070 591070 Umfrey, Adam, of Refham 0
5635229 2554988 2554988 defendant Bailly John   591070 591070 Bailly, John, of Refham 5

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