names

71 rows where place_id = 586499

✎ 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
3588889 1864173 1864173 defendant Cokson William husbandman 586499 586499 Cokson, William, of Estwell, husbandman 0
3588890 1864173 1864173 defendant Carter John husbandman 586499 586499 Carter, John, of Estwell, husbandman 1
3588891 1864173 1864173 defendant Symson Robert husbandman 586499 586499 Symson, Robert, of Estwell, husbandman 2
3588893 1864173 1864173 defendant Brigge John husbandman 586499 586499 Brigge, John, of Estwell, husbandman 4
3606935 1869833 1869833 defendant Alfy or Alsy Robert husbandman 586499 586499 Alfy or Alsy, Robert, of Estwell, husbandman 3
3609729 1870710 1870710 defendant Moyle John esq 586499 586499 Moyle, John, of Estwell, esq 0
3610035 1870811 1870811 defendant Huddelston James gent 586499 586499 Huddelston, James, of Estwell, gent 0
3610036 1870811 1870811 defendant Sewell William husbandman 586499 586499 Sewell, William, of Estwell, husbandman 1
3610037 1870811 1870811 defendant Johnson George husbandman 586499 586499 Johnson, George, of Estwell, husbandman 2
3610038 1870811 1870811 defendant Taillour Thomas husbandman 586499 586499 Taillour, Thomas, of Estwell, husbandman 3
3610039 1870811 1870811 defendant Sytheston Robert husbandman 586499 586499 Sytheston, Robert, of Estwell, husbandman 4
3610040 1870811 1870811 defendant Bradshawe Thomas husbandman 586499 586499 Bradshawe, Thomas, of Estwell, husbandman 5
3610041 1870811 1870811 defendant Mellers William yeoman 586499 586499 Mellers, William, of Estwell, yeoman 6
3610493 1870946 1870946 defendant Lane Robert clerk 586499 586499 Lane, Robert, of Estwell, clerk 0
3610495 1870946 1870946 defendant Hellys John gent 586499 586499 Hellys, John, of Estwell, gent 2
3613195 1871781 1871781 defendant Carter John husbandman 586499 586499 Carter, John, of Estwell, husbandman 3
3622016 1874427 1874427 defendant Neme Henry weaver 586499 586499 Neme, Henry, of Estwell, weaver 2
3627567 1903480 1903480 plaintiff Brabason William gent 586499 586499 Brabason, William, of Estwell, gent 0
3671218 1916971 1916971 defendant Moyle John gent 586499 586499 Moyle, John, of Estwell, gent 0
3758015 1944491 1944491 defendant Stonysby John gent 586499 586499 Stonysby, John, of Estwell, gent 0
3779894 1951441 1951441 plaintiff Flower Robert husbandman 586499 586499 Flower, Robert, of Estwell, husbandman 0
3780250 1951551 1951551 defendant Stonysby John gent 586499 586499 Stonysby, John, of Estwell, gent 0
3855676 1975413 1975413 defendant Jurden John husbandman 586499 586499 Jurden, John, of Estwell, husbandman 0
3855678 1975413 1975413 defendant Marchall Bartholomew husbandman 586499 586499 Marchall, Bartholomew, of Estwell, husbandman 2
3863119 1977865 1977865 defendant Whittell William yeoman 586499 586499 Whittell, William, of Estwell, yeoman 1
4454482 2186416 2186416 plaintiff Magson William   586499 586499 Magson, William, of Estwell 0
4454483 2186416 2186416 defendant Brabason John   586499 586499 Brabason, John, of Estwell 0
4532552 2210446 2210446 defendant Haukyn John   586499 586499 Haukyn, John, of Estwell 3
4757341 2282668 2282668 defendant Botyld John husbandman 586499 586499 Botyld, John, of Estwell, husbandman 0
4831307 2305822 2305822 defendant Walter John husbandman 586499 586499 Walter, John, of Estwell, husbandman 0
4851780 2311996 2311996 defendant Brabson Thomas clerk 586499 586499 Brabson, Thomas, of Estwell, clerk 1
4858669 2314086 2314086 defendant Walter John husbandman 586499 586499 Walter, John, of Estwell, husbandman 0
4918731 2332372 2332372 defendant atte Kyrke Ralph husbandman 586499 586499 atte Kyrke, Ralph, of Estwell, husbandman 3
4918732 2332372 2332372 defendant Geffe Thomas husbandman 586499 586499 Geffe, Thomas, of Estwell, husbandman 4
4918737 2332373 2332373 defendant atte Kyrke Ralph husbandman 586499 586499 atte Kyrke, Ralph, of Estwell, husbandman 3
4918738 2332373 2332373 defendant Geffe Thomas husbandman 586499 586499 Geffe, Thomas, of Estwell, husbandman 4
4935797 2337587 2337587 defendant Waltham Thomas   586499 586499 Waltham, Thomas, of Estwell, servant 0
4935799 2337587 2337587 defendant Styward Robert   586499 586499 Styward, Robert, of Estwell, servant 2
4935800 2337587 2337587 defendant Holme James   586499 586499 Holme, James, of Estwell, servant 3
4971018 2348272 2348272 defendant Benet John fuller 586499 586499 Benet, John, of Estwell, fuller 2
5037422 2367815 2367815 defendant Benet John fuller 586499 586499 Benet, John, of Estwell, fuller 2
5045060 2370156 2370156 defendant Bygge John baker 586499 586499 Bygge, John, of Estwell, baker 2
5213129 2419572 2419572 defendant Jourden Simon butcher 586499 586499 Jourden, Simon, of Estwell, butcher 2
5213130 2419572 2419572 defendant Colman William cooper 586499 586499 Colman, William, of Estwell, cooper 3
5213133 2419573 2419573 defendant Jourden Simon butcher 586499 586499 Jourden, Simon, of Estwell, butcher 1
5213134 2419573 2419573 defendant Colman William cooper 586499 586499 Colman, William, of Estwell, cooper 2
5213138 2419574 2419574 defendant Colman William cooper 586499 586499 Colman, William, of Estwell, cooper 1
5213139 2419574 2419574 defendant Jordon Simon butcher 586499 586499 Jordon, Simon, of Estwell, butcher 2
5213140 2419574 2419574 defendant Rycard John weaver 586499 586499 together with Rycard, John, of Estwell, weaver 3
5213143 2419575 2419575 defendant Rycard John weaver 586499 586499 Rycard, John, of Estwell, weaver 0
5222796 2422382 2422382 defendant Blossum William yeoman 586499 586499 Blossum, William, of Estwell, yeoman 0
5275966 2438045 2438045 defendant Lane John clerk 586499 586499 Lane, John, of Estwell, clerk 0
5360328 2463265 2463265 defendant Somer Roger husbandman 586499 586499 Somer, Roger, of Estwell, husbandman 0
5360333 2463266 2463266 defendant Somer Roger husbandman 586499 586499 Somer, Roger, of Estwell, husbandman 0
5384705 2470710 2470710 defendant Geyle John husbandman 586499 586499 Geyle, John, of Estwell, husbandman 0
5384706 2470710 2470710 defendant Taylor Richard husbandman 586499 586499 Taylor, Richard, of Estwell, husbandman 1
5396695 2474146 2474146 defendant Geall John husbandman 586499 586499 Geall, John, of Estwell, husbandman 0
5433697 2485042 2485042 plaintiff Moylle Walter (legal representative) 586499 586499 Moylle, Walter, of Estwell, knight, executrix of 0
5442839 2487771 2487771 plaintiff Brabason Maud widow & gentlewoman 586499 586499 Brabason, Maud, of Estwell, widow & gentlewoman 0
5442844 2487772 2487772 defendant Geyle John husbandman 586499 586499 Geyle, John, of Estwell, husbandman 0
5442845 2487772 2487772 defendant Tayllour Richard husbandman 586499 586499 Tayllour, Richard, of Estwell, husbandman 1
5442847 2487773 2487773 defendant Geyle John husbandman 586499 586499 Geyle, John, of Estwell, husbandman 0
5442848 2487773 2487773 defendant Taylour Richard husbandman 586499 586499 Taylour, Richard, of Estwell, husbandman 1
5442850 2487774 2487774 defendant Geyle John husbandman 586499 586499 Geyle, John, of Estwell, husbandman 0
5442851 2487774 2487774 defendant Taylour Richard husbandman 586499 586499 Taylour, Richard, of Estwell, husbandman 1
5535545 2515646 2515646 defendant Ingelton Richard husbandman 586499 586499 Ingelton, Richard, of Estwell, husbandman 0
5535546 2515646 2515646 defendant Eynesworth Roger husbandman 586499 586499 Eynesworth, Roger, of Estwell, husbandman 1
5535547 2515646 2515646 defendant Middelton William husbandman 586499 586499 Middelton, William, of Estwell, husbandman 2
5564831 2524297 2524297 defendant Foxe William husbandman 586499 586499 Foxe, William, of Estwell, husbandman 0
5590090 2531883 2531883 defendant Alsy or Alfy Robert laborer 586499 586499 Alsy or Alfy, Robert, of Estwell, laborer 2
5602799 2535755 2535755 defendant Fox William yeoman 586499 586499 Fox, William, of Estwell, yeoman 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);