names

81 rows where place_id = 589500

✎ 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
3597802 1866929 1866929 defendant Claypole Robert yeoman 589500 589500 Claypole, Robert, of Haloughton, yeoman 0
3621454 1874248 1874248 defendant Cleypole Robert yeoman 589500 589500 Cleypole, Robert, of Haloughton, yeoman 0
3621456 1874249 1874249 defendant Cleypole Robert yeoman 589500 589500 Cleypole, Robert, of Haloughton, yeoman 0
3638698 1906918 1906918 defendant Vowe William gent 589500 589500 Vowe, William, of Haloughton, gent 0
3656940 1912428 1912428 defendant Vowe William gent 589500 589500 Vowe, William, of Haloughton, gent 0
3662961 1914327 1914327 defendant Ryseham John husbandman 589500 589500 Ryseham, John, of Haloughton, husbandman 0
3666618 1915501 1915501 defendant Pyke Richard husbandman 589500 589500 Pyke, Richard, of Haloughton, husbandman 0
3678011 1919165 1919165 defendant Cleypole William yeoman 589500 589500 Cleypole, William, of Haloughton, yeoman 0
3685068 1921474 1921474 defendant Godeman Thomas husbandman 589500 589500 Godeman, Thomas, of Haloughton, husbandman 0
3749174 1941670 1941670 defendant Vowe William gent 589500 589500 Vowe, William, of Haloughton, gent 0
3798759 1957526 1957526 defendant Mytton John husbandman 589500 589500 Mytton, John, of Haloughton, husbandman 0
3803665 1959063 1959063 defendant Gudman William husbandman 589500 589500 Gudman, William, of Haloughton, husbandman 0
3819256 1963912 1963912 defendant Goodman William husbandman 589500 589500 Goodman, William, of Haloughton, husbandman 0
3865932 1978836 1978836 defendant Powyll John husbandman 589500 589500 (Powyll, John, of Haloughton, husbandman 1
3869394 1980002 1980002 defendant Willyng Thomas miller 589500 589500 Willyng, Thomas, of Haloughton, miller 1
3869395 1980002 1980002 defendant Irelond Richard gent 589500 589500 Irelond, Richard, of Haloughton, gent 2
3870776 1980474 1980474 defendant Dyxon James glover 589500 589500 Dyxon, James, of Haloughton, glover 0
3883202 1984644 1984644 defendant Hasylryg Bartholomew esq 589500 589500 Hasylryg, Bartholomew, of Haloughton, esq 0
3883203 1984644 1984644 defendant Willyng Thomas miller 589500 589500 Willyng, Thomas, of Haloughton, miller 1
3883204 1984644 1984644 defendant Irelond Richard gent 589500 589500 Irelond, Richard, of Haloughton, gent 2
3888075 1986265 1986265 defendant Cleypole Edward yeoman 589500 589500 Cleypole, Edward, of Haloughton, yeoman 0
3892582 1987761 1987761 defendant Pole John husbandman 589500 589500 Pole, John, of Haloughton, husbandman 0
3897858 1989488 1989488 defendant Poll John husbandman 589500 589500 Poll, John, of Haloughton, husbandman 0
4469219 2191042 2191042 defendant Taillour John   589500 589500 Taillour, John, of Haloughton 0
4497342 2199815 2199815 defendant Veysy John   589500 589500 Veysy, John, of Haloughton 1
4663021 2249900 2249900 defendant Taillour John butcher 589500 589500 Taillour, John, of Haloughton, butcher 0
4696687 2264440 2264440 defendant Ratclyf William husbandman 589500 589500 Ratclyf, William, of Haloughton, husbandman 0
4716786 2270574 2270574 defendant Sprotte William husbandman 589500 589500 Sprotte, William, of Haloughton, husbandman 0
4719512 2271446 2271446 plaintiff Blakesle Lawrence (legal representative) 589500 589500 Blakesle, Lawrence, of Haloughton, parson of half the church, executors of 0
4719520 2271447 2271447 plaintiff Blakesle Lawrence (legal representative) 589500 589500 Blakesle, Lawrence, of Haloughton, formerly parson of half the church, executors of 0
4735158 2276143 2276143 defendant Lister John husbandman 589500 589500 Lister, John, of Haloughton, husbandman 0
4749568 2280356 2280356 defendant Goodfalawe William husbandman 589500 589500 Goodfalawe, William, of Haloughton, husbandman 0
4749569 2280356 2280356 defendant Reefham Thomas husbandman 589500 589500 Reefham, Thomas, of Haloughton, husbandman 1
4756919 2282531 2282531 plaintiff Blakesle Laurence (legal representative) 589500 589500 Blakesle, Laurence, of Haloughton, parson of half the church, executors of 0
4810771 2299492 2299492 defendant Veysy Hugh gent 589500 589500 Veysy, Hugh, of Haloughton, gent 0
4834930 2306927 2306927 defendant Crysall Thomas husbandman 589500 589500 Crysall, Thomas, of Haloughton, husbandman 0
4838916 2308103 2308103 defendant Veysy Hugh yeoman 589500 589500 Veysy, Hugh, of Haloughton, yeoman 0
4959370 2344769 2344769 defendant Veysy Hugh (legal representative) 589500 589500 Veysy, Hugh, of Haloughton, executors of 0
5044158 2369879 2369879 defendant Ladde John husbandman 589500 589500 Ladde, John, of Haloughton, husbandman 0
5079937 2380477 2380477 defendant Bothe Robert husbandman 589500 589500 Bothe, Robert, of Haloughton, husbandman 2
5080329 2380608 2380608 defendant Bothe Robert husbandman 589500 589500 Bothe, Robert, of Haloughton, husbandman 2
5102011 2387012 2387012 plaintiff Bay John   589500 589500 Bay, John, of Haloughton 0
5103886 2387561 2387561 defendant Bothe Robert husbandman 589500 589500 Bothe,Robert, of Haloughton, husbandman 0
5106583 2388353 2388353 defendant Kynge Richard butcher 589500 589500 Kynge, Richard, of Haloughton, butcher 0
5106918 2388450 2388450 defendant Clerk Roger gent 589500 589500 Clerk, Roger, of Haloughton, gent 2
5132330 2395952 2395952 defendant Barker Peter weaver 589500 589500 Barker, Peter, of Haloughton, weaver 3
5134370 2396549 2396549 defendant Clerk Roger gent 589500 589500 Clerk, Roger, of Haloughton, gent 2
5140542 2398342 2398342 defendant Baker Peter weaver 589500 589500 Baker, Peter, of Haloughton, weaver 0
5152091 2401748 2401748 defendant Barker Peter weaver 589500 589500 Barker, Peter, of Haloughton, weaver 2
5153885 2402291 2402291 defendant Clerk Robert gent 589500 589500 Clerk, Robert, of Haloughton, gent 2
5161674 2404517 2404517 defendant Barker Peter weaver 589500 589500 Barker, Peter, of Haloughton, weaver 0
5171138 2407281 2407281 defendant Clerk Roger gent 589500 589500 Clerk, Roger, of Haloughton, gent 2
5195919 2414551 2414551 defendant Birde Robert husbandman 589500 589500 Birde, Robert, of Haloughton, husbandman 0
5195920 2414551 2414551 defendant Bay William husbandman 589500 589500 Bay, William, of Haloughton, husbandman 1
5195922 2414552 2414552 defendant Bothe Robert husbandman 589500 589500 Bothe, Robert, of Haloughton, husbandman 0
5195923 2414552 2414552 defendant Vow Wilai gent 589500 589500 Vow, Wilai, of Haloughton, gent 1
5195924 2414552 2414552 defendant Bothe John husbandman 589500 589500 Bothe, John, of Haloughton, husbandman 2
5197733 2415081 2415081 defendant Baker Peter weaver 589500 589500 Baker, Peter, of Haloughton, weaver 0
5221385 2421954 2421954 defendant Clerk Roger gent 589500 589500 Clerk, Roger, of Haloughton, gent 2
5264442 2434635 2434635 defendant Bay William husbandman 589500 589500 Bay, William, of Haloughton, husbandman 1
5279627 2439120 2439120 defendant Wodcok John husbandman 589500 589500 Wodcok, John, of Haloughton, husbandman 0
5354567 2461506 2461506 defendant Lovet William gent 589500 589500 Lovet, William, of Haloughton, gent 0
5378649 2468907 2468907 defendant Sharp William butcher 589500 589500 Sharp, William, of Haloughton, butcher 0
5412731 2478758 2478758 defendant Claypole Robert yeoman 589500 589500 Claypole, Robert, of Haloughton, yeoman 0
5412732 2478758 2478758 defendant Scotte Henry butcher 589500 589500 Scotte, Henry, of Haloughton, butcher 1
5425492 2482600 2482600 defendant William John husbandman 589500 589500 William, John, of Haloughton, husbandman 0
5468553 2495535 2495535 defendant Mathewe John clerk 589500 589500 Mathewe, John, of Haloughton, clerk 0
5473234 2496956 2496956 defendant Plomer Thomas husbandman 589500 589500 Plomer, Thomas, of Haloughton, husbandman 0
5490913 2502182 2502182 defendant Dorman Edmund husbandman 589500 589500 Dorman, Edmund, of Haloughton, husbandman 0
5491802 2502449 2502449 defendant Miller Hugh miller 589500 589500 Miller, Hugh, of Haloughton, miller 0
5506645 2506992 2506992 defendant Myller Hugh miller 589500 589500 Myller, Hugh, of Haloughton, miller 0
5518406 2510583 2510583 defendant Cleypole John gent 589500 589500 Cleypole, John, of Haloughton, gent 0
5529050 2513605 2513605 defendant Johnson John husbandman 589500 589500 Johnson, John, of Haloughton, husbandman 3
5530827 2514157 2514157 defendant Broke John (legal representative) 589500 589500 Broke, John, of Haloughton, husbandman, executors of 0
5530828 2514157 2514157 defendant Broke Isabel widow 589500 589500 (Broke, Isabel, of Haloughton, widow 1
5530829 2514157 2514157 defendant Broke or Croke John husbandman 589500 589500 Broke or Croke, John, of Haloughton, husbandman 2
5532147 2514598 2514598 defendant Warter Edmund clerk 589500 589500 Warter, Edmund, of Haloughton, clerk 1
5556667 2521905 2521905 defendant Bay Thomas husbandman 589500 589500 Bay, Thomas, of Haloughton, husbandman 0
5560600 2523062 2523062 defendant Claypole Robert yeoman 589500 589500 Claypole, Robert, of Haloughton, yeoman 0
5587990 2531255 2531255 defendant Ryfam John butcher 589500 589500 Ryfam, John, of Haloughton, butcher 0
5589432 2531697 2531697 defendant Hubberd Thomas mercer 589500 589500 Hubberd, Thomas, of Haloughton, mercer 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);