names

115 rows where place_id = 586425

✎ 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
3588690 1864106 1864106 defendant Fryday William husbandman 586425 586425 Fryday, William, of Braughyng, husbandman 2
3604448 1869059 1869059 defendant Dalawey Gilbert carpenter 586425 586425 Dalawey, Gilbert, of Braughyng, carpenter 0
3604449 1869059 1869059 defendant Gregory Robert husbandman 586425 586425 Gregory, Robert, of Braughyng, husbandman 1
3604451 1869060 1869060 defendant Dalawey Gilbert carpenter 586425 586425 Dalawey, Gilbert, of Braughyng, carpenter 0
3604452 1869060 1869060 defendant Gregory Robert husbandman 586425 586425 Gregory, Robert, of Braughyng, husbandman 1
3608906 1870443 1870443 defendant Pery John husbandman 586425 586425 Pery, John, of Braughyng, husbandman 0
3626821 1903238 1903238 defendant Halfhyde William husbandman 586425 586425 Halfhyde, William, of Braughyng, husbandman 4
3632666 1905031 1905031 defendant Broke William, senior maltman 586425 586425 Broke, William, senior, of Braughyng, maltman 1
3673639 1917787 1917787 defendant Snowe Thomas husbandman 586425 586425 Snowe, Thomas, of Braughyng, husbandman 1
3673640 1917787 1917787 defendant Newman Nicholas laborer 586425 586425 Newman, Nicholas, of Braughyng, laborer 2
3673647 1917789 1917789 defendant Phylipson Robert clerk 586425 586425 Phylipson, Robert, of Braughyng, clerk 0
3690533 1923205 1923205 defendant Halfhyde William husbandman 586425 586425 Halfhyde, William, of Braughyng, husbandman 0
3719015 1932222 1932222 defendant FitzHerbert Humphrey gent 586425 586425 FitzHerbert, Humphrey, of Braughyng, gent 0
3725750 1934342 1934342 defendant Grytton Christopher laborer 586425 586425 Grytton, Christopher, of Braughyng, laborer 0
3725751 1934342 1934342 defendant Bardall Nicholas laborer 586425 586425 Bardall, Nicholas, of Braughyng, laborer 1
3728754 1935234 1935234 defendant Broke William innholder 586425 586425 Broke, William, of Braughyng, innholder 0
3728755 1935234 1935234 defendant Quarteyn Edward husbandman 586425 586425 Quarteyn, Edward, of Braughyng, husbandman 1
3728756 1935234 1935234 defendant Perle John chapman 586425 586425 Perle, John, of Braughyng, chapman 2
3734788 1937125 1937125 defendant FitzHerbert Humphrey gent 586425 586425 FitzHerbert, Humphrey, of Braughyng, gent 0
3763544 1946232 1946232 defendant Snowe Henry maltman 586425 586425 Snowe, Henry, of Braughyng, maltman 1
3773988 1949578 1949578 defendant Warner John husbandman 586425 586425 Warner, John, of Braughyng, husbandman 0
3779328 1951257 1951257 defendant Warner Thomas husbandman 586425 586425 Warner, Thomas, of Braughyng, husbandman 0
3781239 1951872 1951872 defendant Gylby Thomas tapster 586425 586425 Gylby, Thomas, of Braughyng, tapster 2
3781240 1951872 1951872 defendant Halden Richard maltman 586425 586425 Halden, Richard, of Braughyng, maltman 3
3781241 1951872 1951872 defendant Semer John butcher 586425 586425 Semer, John, of Braughyng, butcher 4
3790387 1954811 1954811 defendant Edmunde Henry maltman 586425 586425 Edmunde, Henry, of Braughyng, maltman 0
3790388 1954811 1954811 defendant Rote Richard laborer 586425 586425 Rote, Richard, of Braughyng, laborer 1
3797239 1957020 1957020 defendant Hampton John husbandman 586425 586425 Hampton, John, of Braughyng, husbandman 0
3803470 1958989 1958989 defendant Cole William husbandman 586425 586425 Cole, William, of Braughyng, husbandman 0
3814929 1962585 1962585 defendant FitzHerbert Humphrey esq 586425 586425 FitzHerbert, Humphrey, of Braughyng, esq 0
3819437 1963964 1963964 defendant Hemmyng Christopher carpenter 586425 586425 Hemmyng, Christopher, of Braughyng, carpenter 1
3824264 1965463 1965463 defendant Roote John husbandman 586425 586425 Roote, John, of Braughyng, husbandman 0
3827550 1966479 1966479 defendant Rutter William butcher 586425 586425 Rutter, William, of Braughyng, butcher 0
3840832 1970702 1970702 defendant Warner Thomas husbandman 586425 586425 Warner, Thomas, of Braughyng, husbandman 0
3843466 1971494 1971494 plaintiff Clerke Henry miller 586425 586425 Clerke, Henry, of Braughyng, miller 0
3890549 1987101 1987101 defendant Broke William yeoman 586425 586425 Broke, William, of Braughyng, yeoman 0
3894657 1988419 1988419 defendant Payne John butcher 586425 586425 Payne, John, of Braughyng, butcher 1
3917585 1996240 1996240 defendant Broke William, senior husbandman 586425 586425 Broke, William, senior, of Braughyng, husbandman 0
3917586 1996240 1996240 defendant Broke William, junior husbandman 586425 586425 Broke, William, junior, of Braughyng, husbandman 1
3924072 1998361 1998361 defendant Broke Bartholomew husbandman 586425 586425 Broke, Bartholomew, of Braughyng, husbandman 1
3931733 2000915 2000915 defendant Hamond Edmund maltman 586425 586425 Hamond, Edmund, of Braughyng, maltman 1
3934172 2001722 2001722 defendant Tayler John husbandman 586425 586425 Tayler, John, of Braughyng, husbandman 0
3950531 2007266 2007266 defendant Huchyn William maltman 586425 586425 Huchyn, William, of Braughyng, maltman 1
4496579 2199603 2199603 defendant Farnham John   586425 586425 Farnham, John, of Braughyng 3
4731187 2274955 2274955 defendant Hormede William husbandman 586425 586425 Hormede, William, of Braughyng, husbandman 0
4928356 2335292 2335292 defendant Hampton William maltman 586425 586425 Hampton, William, of Braughyng, maltman 3
4994509 2355221 2355221 defendant Smyth Thomas laborer 586425 586425 Smyth, Thomas, of Braughyng, laborer 0
5025786 2364440 2364440 defendant Hampton William husbandman 586425 586425 Hampton, William, of Braughyng, husbandman 0
5025789 2364441 2364441 defendant Cherchesey Richard miller 586425 586425 Cherchesey, Richard, of Braughyng, miller 1
5028449 2365196 2365196 defendant Joskyn John gent 586425 586425 Joskyn, John, of Braughyng, gent 0
5028450 2365196 2365196 defendant Elveden or Elneden Henry esq 586425 586425 Elveden or Elneden, Henry, of Braughyng, esq 1
5028452 2365196 2365196 defendant Isak John husbandman 586425 586425 Isak, John, of Braughyng, husbandman 3
5028458 2365196 2365196 defendant Snowe William maltman 586425 586425 Snowe, William, of Braughyng, maltman 9
5028459 2365196 2365196 defendant Cherchesey Richard miller 586425 586425 Cherchesey, Richard, of Braughyng, miller 10
5028460 2365196 2365196 defendant Shyngey William husbandman 586425 586425 Shyngey, William, of Braughyng, husbandman 11
5028461 2365196 2365196 defendant Hampton William husbandman 586425 586425 Hampton, William, of Braughyng, husbandman 12
5076094 2379349 2379349 defendant Snowe William maltman 586425 586425 Snowe, William, of Braughyng, maltman 1
5077549 2379784 2379784 defendant Wayte William maltman 586425 586425 Wayte, William, of Braughyng, maltman 0
5077550 2379784 2379784 defendant Wenham William laborer 586425 586425 Wenham, William, of Braughyng, laborer 1
5077551 2379784 2379784 defendant Dethsale Thomas laborer 586425 586425 Dethsale, Thomas, of Braughyng, laborer 2
5088956 2383146 2383146 defendant Wayte William maltman 586425 586425 Wayte, William, of Braughyng, maltman 0
5088957 2383146 2383146 defendant Wenham William laborer 586425 586425 Wenham, William, of Braughyng, laborer 1
5088958 2383146 2383146 defendant Dethsale Thomas laborer 586425 586425 Dethsale, Thomas, of Braughyng, laborer 2
5143625 2399270 2399270 defendant Isaake John husbandman 586425 586425 Isaake, John, of Braughyng, husbandman 0
5180275 2409969 2409969 defendant Elys Thomas laborer 586425 586425 Elys, Thomas, of Braughyng, laborer 0
5180276 2409969 2409969 defendant Vuet or Unet John laborer 586425 586425 Vuet or Unet, John, of Braughyng, laborer 1
5180280 2409970 2409970 defendant Grene Nicholas maltman 586425 586425 together with Grene, Nicholas, of Braughyng, maltman 2
5180284 2409971 2409971 defendant Grene Nicholas maltman 586425 586425 together with Grene, Nicholas, of Braughyng, maltman 2
5180286 2409972 2409972 defendant Grene Nicholas maltman 586425 586425 Grene, Nicholas, of Braughyng, maltman 0
5233062 2425253 2425253 defendant Grene John   586425 586425 Grene, John, of Braughyng 0
5233063 2425253 2425253 defendant Broke William   586425 586425 Broke, William, of Braughyng 1
5311694 2448518 2448518 defendant Grene Nicholas maltman 586425 586425 Grene, Nicholas, of Braughyng, maltman 0
5313811 2449158 2449158 defendant Joskyn Edward gent 586425 586425 Joskyn, Edward, of Braughyng, gent 0
5340957 2457369 2457369 defendant Bayford William butcher 586425 586425 Bayford, William, of Braughyng, butcher 0
5349800 2460073 2460073 defendant Stokell Thomas laborer 586425 586425 Stokell, Thomas, of Braughyng, laborer 0
5353727 2461232 2461232 plaintiff Grene Nicholas   586425 586425 Grene, Nicholas, of Braughyng 0
5370496 2466355 2466355 defendant Beyforde William butcher 586425 586425 Beyforde, William, of Braughyng, butcher 0
5374870 2467735 2467735 defendant Snowe John husbandman 586425 586425 Snowe, John, of Braughyng, husbandman 1
5374871 2467735 2467735 defendant Halden Richard husbandman 586425 586425 Halden, Richard, of Braughyng, husbandman 2
5374872 2467735 2467735 defendant Broke John husbandman 586425 586425 Broke, John, of Braughyng, husbandman 3
5381466 2469761 2469761 defendant Desale Richard husbandman 586425 586425 Desale, Richard, of Braughyng, husbandman 0
5388940 2471898 2471898 defendant Desale Richard husbandman 586425 586425 Desale, Richard, of Braughyng, husbandman 0
5401655 2475536 2475536 defendant Desale Richard husbandman 586425 586425 Desale, Richard, of Braughyng, husbandman 0
5413925 2479095 2479095 plaintiff Grene Nicholas   586425 586425 Grene, Nicholas, of Braughyng 0
5413926 2479095 2479095 defendant Neweman William laborer 586425 586425 Neweman, William, of Braughyng, laborer 0
5434895 2485368 2485368 defendant Joskyn Agnes widow 586425 586425 Joskyn, Agnes, of Braughyng, widow 0
5459073 2492609 2492609 plaintiff Grene Nicholas   586425 586425 Grene, Nicholas, of Braughyng 0
5470701 2496158 2496158 plaintiff Grene Nicholas   586425 586425 Grene, Nicholas, of Braughyng 0
5505751 2506716 2506716 defendant Gregory Robert husbandman 586425 586425 Gregory, Robert, of Braughyng, husbandman 0
5533666 2515078 2515078 defendant Pury John yeoman 586425 586425 Pury, John, of Braughyng, yeoman 0
5533667 2515078 2515078 defendant Ederiche William miller 586425 586425 Ederiche, William, of Braughyng, miller 1
5534495 2515335 2515335 defendant Thyrkyll John butcher 586425 586425 Thyrkyll, John, of Braughyng, butcher 1
5552722 2520845 2520845 defendant Broke Richard (legal representative) 586425 586425 Broke, Richard, of Braughyng, maltman, executors of 0
5552723 2520845 2520845 defendant Broke Elizabeth widow 586425 586425 (Broke, Elizabeth, of Braughyng, widow 1
5552724 2520845 2520845 defendant Broke John husbandman 586425 586425 Broke, John, of Braughyng, husbandman 2
5552726 2520846 2520846 defendant Broke Richard (legal representative) 586425 586425 Broke, Richard, of Braughyng, maltman, executors of 0
5552727 2520846 2520846 defendant Broke Elizabeth widow 586425 586425 (Broke, Elizabeth, of Braughyng, widow 1
5552728 2520846 2520846 defendant Broke John husbandman 586425 586425 Broke, John, of Braughyng, husbandman 2
5552729 2520847 2520847 plaintiff FitzHerberd Walter gent 586425 586425 FitzHerberd, Walter, of Braughyng, gent administrator of 0
5552730 2520847 2520847 plaintiff FitzHerberd John clerk 586425 586425 FitzHerberd, John, of Braughyng, clerk 1

Next page

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