names

180 rows where place_id = 586944

✎ 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
3590046 1864526 1864526 defendant Forth Nicholas tailor 586944 586944 Forth, Nicholas, of Waltham Holy Cross, Essex, tailor 0
3590048 1864527 1864527 defendant Forth Nicholas tailor 586944 586944 Forth, Nicholas, of Waltham Holy Cross, Essex, tailor 0
3594615 1865946 1865946 defendant Forde John hosier 586944 586944 Forde, John, of Waltham Holy Cross, Essex, hosier 0
3594622 1865947 1865947 defendant Norrys John gent 586944 586944 Norrys, John, of Waltham Holy Cross, Essex, gent 4
3601607 1868158 1868158 defendant Lowe Richard gent 586944 586944 Lowe, Richard, of Waltham Holy Cross, Essex, gent 1
3601760 1868208 1868208 defendant Duren Richard   586944 586944 Duren, Richard, of Waltham Holy Cross, Essex, basket maker 0
3601762 1868209 1868209 defendant Duren Robert   586944 586944 Duren, Robert, of Waltham Holy Cross, Essex, basket maker 0
3615467 1872480 1872480 defendant Foirde Nicholas tailor 586944 586944 Foirde, Nicholas, of Waltham Holy Cross, Essex, tailor 0
3615470 1872481 1872481 defendant Foirde Nicholas tailor 586944 586944 Foirde, Nicholas, of Waltham Holy Cross, Essex, tailor 0
3619004 1873553 1873553 defendant Forthe Nicholas tailor 586944 586944 Forthe, Nicholas, of Waltham Holy Cross, Essex, tailor 2
3628031 1903620 1903620 defendant Arnolde Roger tailor 586944 586944 Arnolde, Roger, of Waltham Holy Cross, Essex, tailor 0
3639609 1907198 1907198 defendant Pest Robert, junior yeoman 586944 586944 Pest, Robert, junior, of Waltham Holy Cross, Essex, yeoman 4
3650661 1910572 1910572 defendant Marsham Robert baker 586944 586944 Marsham, Robert, of Waltham Holy Cross, Essex, baker 1
3654200 1911575 1911575 defendant Dady Hugh chaplain 586944 586944 Dady, Hugh, of Waltham Holy Cross, Essex, chaplain 0
3662294 1914122 1914122 defendant Shynnok John   586944 586944 (Shynnok, John, of Waltham Holy Cross, Essex 2
3662295 1914122 1914122 defendant Kelsey Gerard yeoman 586944 586944 Kelsey, Gerard, of Waltham Holy Cross, Essex, yeoman 3
3679241 1919573 1919573 defendant Archer John, senior yeoman 586944 586944 Archer, John, senior, of Waltham Holy Cross, Essex, yeoman 1
3679259 1919576 1919576 defendant Archer John draper 586944 586944 Archer, John, of Waltham Holy Cross, essex, draper 0
3688196 1922457 1922457 defendant Archer John yeoman 586944 586944 Archer, John, of Waltham Holy Cross, Essex, yeoman 0
3694121 1924366 1924366 plaintiff Morgan John merchant of the staple 586944 586944 Morgan, John, of Waltham Holy Cross, Essex, merchant of the staple 0
3701125 1926599 1926599 defendant Pychard Walter yeoman 586944 586944 Pychard, Walter, of Waltham Holy Cross, Essex, yeoman 0
3703776 1927461 1927461 defendant Archer John yeoman 586944 586944 Archer, John, of Waltham Holy Cross, Essex, yeoman 0
3708114 1928835 1928835 defendant Turnor Thomas yeoman 586944 586944 Turnor, Thomas, of Waltham Holy Cross, Essex, yeoman 0
3719752 1932442 1932442 defendant Smyth Thomas yeoman 586944 586944 Smyth, Thomas, of Waltham Holy Cross, Essex, yeoman 3
3721926 1933121 1933121 defendant Archer John yeoman 586944 586944 Archer, John, of Waltham Holy Cross, Essex, yeoman 1
3721931 1933122 1933122 defendant Archer John yeoman 586944 586944 Archer, John,of Waltham Holy Cross, Essex, yeoman 1
3739760 1938647 1938647 defendant Archer John yeoman 586944 586944 Archer, John, of Waltham Holy Cross, Essex, yeoman 0
3770767 1948545 1948545 defendant Browne William brewer 586944 586944 Browne, William, of Waltham Holy Cross, Essex, brewer 0
3822089 1964801 1964801 defendant Meryton William husbandman 586944 586944 Meryton, William, of Waltham Holy Cross, Essex, husbandman 0
3898691 1989768 1989768 defendant Walenger Richard yeoman 586944 586944 Walenger, Richard, of Waltham Holy Cross, Essex, yeoman 3
3912724 1994589 1994589 defendant Bryges John husbandman 586944 586944 Bryges, John, of Waltham Holy Cross, Essex, husbandman 2
3915656 1995607 1995607 plaintiff Daysburye Thomas maltman 586944 586944 Daysburye, Thomas, of Waltham Holy Cross, Essex, maltman 0
3953050 2008131 2008131 defendant Nicholson Lawrence gent 586944 586944 Nicholson, Lawrence, of Waltham Holy Cross, Essex, gent 0
3956484 2009333 2009333 defendant Androwes John (legal representative) 586944 586944 Androwes, John, of Waltham Holy Cross, Essex, husbandman, executors of 0
3966157 2012792 2012792 defendant Sutton Thomas gent 586944 586944 Sutton, Thomas, of Waltham Holy Cross, Essex, gent 0
3979577 2017455 2017455 defendant Rygbye John gent 586944 586944 Rygbye, John, of Waltham Holy Cross, Essex, gent 0
4024670 2033502 2033502 defendant Frauncis Peter gent 586944 586944 Frauncis, Peter, of Waltham Holy Cross, Essex, gent 0
4042217 2039697 2039697 defendant Brady Stephen yeoman 586944 586944 Brady, Stephen, of Waltham Holy Cross, Essex, yeoman 0
4042221 2039698 2039698 defendant Brady Stephen yeoman 586944 586944 Brady, Stephen, of Waltham Holy Cross, Essex, yeoman 0
4059345 2045734 2045734 plaintiff Colt Thomas (legal representative) 586944 586944 Colt, Thomas, of Waltham Holy Cross, Essex, esq, executrix of 0
4059348 2045735 2045735 plaintiff Colt Thomas (legal representative) 586944 586944 Colt, Thomas, of Waltham Holy Cross, Essex, gemt, executrix of 0
4090307 2056818 2056818 defendant Grevill Edward gent 586944 586944 Grevill, Edward, of Waltham Holy Cross, Essex, gent 0
4093280 2057912 2057912 defendant Heydon Jerome yeoman 586944 586944 Heydon, Jerome, of Waltham Holy Cross, Essex, yeoman 3
4194752 2093723 2093723 defendant Cordell Roger tanner 586944 586944 Cordell, Roger, of Waltham Holy Cross, Essex, tanner 0
4247980 2112312 2112312 defendant Denny Edward esq 586944 586944 Denny, Edward, of Waltham Holy Cross, Essex, knight, brother of Robert Denny, esq, son of Henry Denny, of Dallonce, Essex, esq 0
4349444 2147069 2147069 defendant Harryson Joan widow 586944 586944 Harryson, Joan, of Waltham Holy Cross, Essex, widow 1
4352890 2148236 2148236 defendant Warren Thomas yeoman 586944 586944 Warren, Thomas, of Waltham Holy Cross, Essex, yeoman 2
4373524 2155599 2155599 defendant Harryson William (legal representative) 586944 586944 Harryson, William, of Waltham Holy Cross, Essex, yeoman, executrix of 0
4385928 2159985 2159985 defendant Webbe John clerk 586944 586944 Webbe, John, of Waltham Holy Cross, Essex, clerk 0
4739818 2277529 2277529 defendant Croydon Thomas gent 586944 586944 Croydon, Thomas, of Waltham Holy Cross, Essex, gent 3
4780421 2289874 2289874 defendant Eton Thomas husbandman 586944 586944 Eton, Thomas, of Waltham Holy Cross, Essex, husbandman 1
4790714 2293182 2293182 defendant Dalom John husbandman 586944 586944 Dalom, John, of Waltham Holy Cross, Essex, husbandman 0
4790719 2293184 2293184 defendant Dalom John husbandman 586944 586944 Dalom, John, of Waltham Holy Cross, Essex, husbandman 0
4811808 2299806 2299806 defendant Worsop Thomas gent 586944 586944 Worsop, Thomas, of Waltham Holy Cross, Essex, gent 0
4812955 2300165 2300165 defendant Curson Robert gent 586944 586944 Curson, Robert, of Waltham Holy Cross, Essex, gent 0
4813282 2300269 2300269 plaintiff Hertford William   586944 586944 Hertford, William, of Waltham Holy Cross, Essex, abbot 0
4870641 2317796 2317796 plaintiff Gladewyn John, senior   586944 586944 Gladewyn, John, senior, of Waltham Holy Cross, Essex 1
4870646 2317797 2317797 plaintiff Gladewyn John, senior   586944 586944 Gladewyn, John, senior, of Waltham Holy Cross, Essex 1
4888198 2323115 2323115 defendant Helder Thomas husbandman 586944 586944 Helder, Thomas, of Waltham Holy Cross, Essex, husbandman 1
4888481 2323193 2323193 defendant Whitmerssh John, senior draper 586944 586944 Whitmerssh, John, senior, of Waltham Holy Cross, Essex, draper 3
4897060 2325735 2325735 defendant Dyer Nicholas husbandman 586944 586944 Dyer, Nicholas, of Waltham Holy Cross, Essex, husbandman 0
4904453 2328003 2328003 defendant Whitmerssh John, senior draper 586944 586944 Whitmerssh, John, senior, of Waltham Holy Cross, Essex, draper 3
4920730 2332999 2332999 defendant atte Hille John smith 586944 586944 atte Hille, John, of Waltham Holy Cross, Essex, smith 0
4920734 2333000 2333000 plaintiff Jurdon Edmund   586944 586944 Jurdon, Edmund, of Waltham Holy Cross, Essex 0
4922595 2333482 2333482 defendant Chapman Nicholas chapman 586944 586944 Chapman, Nicholas, of Waltham Holy Cross, Essex, chapman 0
4922613 2333485 2333485 defendant Chapman Nicholas goldsmith 586944 586944 Chapman, Nicholas, of Waltham Holy Cross, Essex, chapman: Sawston, John, junior, of Cambridge, Cambs, goldsmith 0
4925063 2334269 2334269 defendant Raymond John loder 586944 586944 Raymond, John, of Waltham Holy Cross, Essex, loder 2
4955656 2343658 2343658 defendant Gladwyn John husbandman 586944 586944 Gladwyn, John, of Waltham Holy Cross, Essex, husbandman 0
4955659 2343659 2343659 defendant Gladwyn John husbandman 586944 586944 Gladwyn, John, of Waltham Holy Cross, Essex, husbandman 0
4961475 2345395 2345395 plaintiff Bole Walter   586944 586944 Bole, Walter, of Waltham Holy Cross, Essex 0
4968880 2347655 2347655 defendant Dyer John draper 586944 586944 Dyer, John, of Waltham Holy Cross, Essex, draper 0
4979193 2350735 2350735 defendant Smyth William yeoman 586944 586944 Smyth, William, of Waltham Holy Cross, Essex, yeoman 0
4982129 2351572 2351572 defendant More John barber 586944 586944 More, John, of Waltham Holy Cross, Essex, barber 0
4984252 2352219 2352219 defendant More William clerk 586944 586944 More, William, of Waltham Holy Cross, Essex, clerk 0
4986348 2352843 2352843 defendant Streteman William yeoman 586944 586944 Streteman, William, of Waltham Holy Cross, Essex, yeoman 4
4986354 2352844 2352844 defendant Streteman William yeoman 586944 586944 Streteman, William, of Waltham Holy Cross, Essex, yeoman 4
4997598 2356135 2356135 defendant Stabull Richard husbandman 586944 586944 Stabull, Richard, of Waltham Holy Cross, Essex, husbandman 3
4997604 2356136 2356136 defendant Stabull Richard husbandman 586944 586944 Stabull, Richard, of Waltham Holy Cross, Essex, husbandman 3
5000548 2357030 2357030 defendant Dyer John draper 586944 586944 Dyer, John, of Waltham Holy Cross, Essex, draper 2
5036153 2367427 2367427 defendant Crempe Roger brewer 586944 586944 Crempe, Roger, of Waltham Holy Cross, Essex, brewer 0
5046127 2370470 2370470 defendant Blakemore Robert tanner 586944 586944 Blakemore, Robert, of Waltham Holy Cross, Essex, tanner 0
5049190 2371393 2371393 defendant Dyer John yeoman 586944 586944 Dyer, John, of Waltham Holy Cross, Essex, yeoman 0
5066654 2376554 2376554 defendant Dyer John chapman 586944 586944 Dyer, John, of Waltham Holy Cross, Essex, chapman 0
5066656 2376555 2376555 defendant Dyer John chapman 586944 586944 Dyer, John, of Waltham Holy Cross, Essex, chapman 0
5112088 2389920 2389920 plaintiff Hosyer John   586944 586944 Hosyer, John, of Waltham Holy Cross, Essex 0
5121046 2392584 2392584 defendant Huntyngdon Isabel widow 586944 586944 Huntyngdon, Isabel, of Waltham Holy Cross, Essex, widow 2
5123711 2393394 2393394 defendant Waltston John butcher 586944 586944 Waltston, John, of Waltham Holy Cross, Essex, butcher 1
5133739 2396360 2396360 defendant Romeyn John parker 586944 586944 Romeyn, John, of Waltham Holy Cross, Essex, parker 3
5154697 2402529 2402529 defendant Romeyn John   586944 586944 Romeyn, John, of Waltham Holy Cross, Essex, park man 1
5157712 2403384 2403384 defendant Denham John tanner 586944 586944 Denham, John, of Waltham Holy Cross, Essex, tanner 0
5170926 2407219 2407219 defendant Rometyn John   586944 586944 Rometyn, John, of Waltham Holy Cross, Essex, park man 1
5213231 2419601 2419601 plaintiff Bleche John gent 586944 586944 Bleche, John, of Waltham Holy Cross, Essex, gent 0
5213233 2419602 2419602 plaintiff Bleche John gent 586944 586944 Bleche, John, of Waltham Holy Cross, Essex, gent 0
5224545 2422847 2422847 defendant Smyth Robert husbandman 586944 586944 Smyth, Robert, of Waltham Holy Cross, Essex, husbandman 0
5225639 2423170 2423170 defendant Colyns John chapman 586944 586944 Colyns, John, of Waltham Holy Cross, Essex, chapman 4
5252558 2430913 2430913 defendant Smyth Robert husbandman 586944 586944 Smyth, Robert, of Waltham Holy Cross, Essex, husbandman 2
5252562 2430914 2430914 defendant Smyth Robert husbandman 586944 586944 Smyth, Robert, of Waltham Holy Cross, Essex, husbandman 2
5274935 2437753 2437753 defendant Smyth Robert husbandman 586944 586944 Smyth, Robert, of Waltham Holy Cross, Essex, husbandman 1
5274957 2437760 2437760 defendant Barbour John yeoman 586944 586944 Barbour, John, of Waltham Holy Cross, Essex, yeoman 5
5304146 2446248 2446248 defendant Langryche Robert gent 586944 586944 Langryche, Robert, of Waltham Holy Cross, Essex, gent 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);