names

220 rows where place_id = 585902

✎ 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
3587457 1863725 1863725 defendant Tomlyn John laborer 585902 585902 Tomlyn, John, of Reynham, laborer 0
3599753 1867567 1867567 defendant Savage William gent 585902 585902 Savage, William, of Reynham, gent 0
3599754 1867567 1867567 defendant Savage Henry gent 585902 585902 Savage, Henry, of Reynham, gent 1
3599755 1867567 1867567 defendant More John laborer 585902 585902 More, John, of Reynham, laborer 2
3599756 1867567 1867567 defendant Clayter Thomas tailor 585902 585902 Clayter, Thomas, of Reynham, tailor 3
3599758 1867568 1867568 defendant Savage William gent 585902 585902 Savage, William, of Reynham, gent 0
3599759 1867568 1867568 defendant Savage Henry gent 585902 585902 Savage, Henry, of Reynham, gent 1
3599760 1867568 1867568 defendant More John laborer 585902 585902 More, John, of Reynham, laborer 2
3599761 1867568 1867568 defendant Clayter Thomas tailor 585902 585902 Clayter, Thomas, of Reynham, tailor 3
3611149 1871162 1871162 defendant Sandon William yeoman 585902 585902 Sandon, William, of Reynham, yeoman 0
3616591 1872821 1872821 defendant Sandon John husbandman 585902 585902 Sandon, John, of Reynham, husbandman 3
3616592 1872821 1872821 defendant Godstone John esq 585902 585902 Godstone, John, of Reynham, esq 4
3651438 1910814 1910814 defendant Skelton Thomas husbandman 585902 585902 Skelton, Thomas, of Reynham, husbandman 0
3680190 1919876 1919876 defendant Turpyn William husbandman 585902 585902 Turpyn, William, of reynham, husbandman 3
3742973 1939650 1939650 plaintiff Pratt William yeoman 585902 585902 Pratt, William, of Reynham, yeoman 1
3746122 1940696 1940696 plaintiff Coler William   585902 585902 Coler, William, of Reynham 3
3748976 1941611 1941611 defendant Wulby John woolman 585902 585902 Wulby, John, of Reynham, woolman 4
3755671 1943730 1943730 defendant Sede Richard yeoman 585902 585902 Sede, Richard, of Reynham, yeoman 0
3763520 1946226 1946226 defendant Wulby John woolman 585902 585902 Wulby, John, of Reynham, woolman 0
3773197 1949324 1949324 defendant Sede Richard yeoman 585902 585902 Sede, Richard, of Reynham, yeoman 0
3777196 1950620 1950620 plaintiff Bloor William   585902 585902 Bloor, William, of Reynham 3
3777201 1950621 1950621 plaintiff Bloor William   585902 585902 Bloor, William, of Reynham 3
3777206 1950622 1950622 plaintiff Bloor William   585902 585902 Bloor, William, of Reynham 3
3777214 1950623 1950623 plaintiff Bloor William   585902 585902 Bloor, William, of Reynham 3
3777448 1950695 1950695 defendant Cook Thomas yeoman 585902 585902 Cook, Thomas, of Reynham, yeoman 0
3796444 1956759 1956759 defendant Stonard William husbandman 585902 585902 Stonard, William, of Reynham, husbandman 0
3796445 1956759 1956759 defendant Stonard Thomas husbandman 585902 585902 Stonard, Thomas, of Reynham, husbandman 1
3796446 1956760 1956760 plaintiff Elmyston John yeoman 585902 585902 Elmyston, John, of Reynham, yeoman 0
3796447 1956760 1956760 defendant Stonnard Henry yeoman 585902 585902 Stonnard, Henry, of Reynham, yeoman 0
3796449 1956761 1956761 defendant Quynten John   585902 585902 Quynten, John, of Reynham, wheelwright 0
3796450 1956761 1956761 defendant Page William butcher 585902 585902 Page, William, of Reynham, butcher 1
3797590 1957142 1957142 defendant Worcoppe Vincent clerk 585902 585902 Worcoppe, Vincent, of Reynham, clerk 1
3815128 1962651 1962651 defendant Fayrwell Gregory clerk 585902 585902 Fayrwell, Gregory, of Reynham, clerk 0
3844256 1971753 1971753 defendant Clark Robert husbandman 585902 585902 Clark, Robert, of Reynham, husbandman 0
3844257 1971753 1971753 defendant Osborn William husbandman 585902 585902 Osborn, William, of Reynham, husbandman 1
4039263 2038670 2038670 defendant Wylkyn David gent 585902 585902 Wylkyn, David, of Reynham, gent 0
4077650 2052293 2052293 defendant Dawghton Robert yeoman 585902 585902 Dawghton, Robert, of Reynham, yeoman 2
4162651 2082497 2082497 defendant Warrant Roger butcher 585902 585902 Warrant, Roger, of Reynham, butcher 0
4174486 2086543 2086543 defendant Allen John yeoman 585902 585902 Allen, John, of Reynham, yeoman 0
4273343 2120647 2120647 defendant Mosby William tailor 585902 585902 Mosby, William, of Reynham, tailor 0
4493615 2198705 2198705 defendant Couper Richard   585902 585902 Couper, Richard, of Reynham 3
4499911 2200609 2200609 defendant But John   585902 585902 But, John, of Reynham 0
4519752 2206535 2206535 defendant Welewere John   585902 585902 Welewere, John, of Reynham 0
4554712 2217399 2217399 defendant Baxstone Richard   585902 585902 Baxstone, Richard, of Reynham 2
4555377 2217616 2217616 plaintiff Hende John   585902 585902 Hende, John, of Reynham 0
4555378 2217616 2217616 defendant Joce William   585902 585902 Joce, William, of Reynham 0
4567763 2221483 2221483 defendant Graungeman John   585902 585902 Graungeman, John, of Reynham 0
4582799 2226054 2226054 defendant Adam John   585902 585902 Adam, John, of Reynham 5
4584874 2226700 2226700 defendant Stylere John   585902 585902 Stylere, John, of Reynham 0
4601907 2231822 2231822 defendant Duc John   585902 585902 Duc, John, of Reynham 2
4610746 2234427 2234427 plaintiff Champeneys William   585902 585902 Champeneys, William, of Reynham 0
4611520 2234665 2234665 defendant Elys Guy   585902 585902 Elys, Guy, of Reynham 0
4640874 2243428 2243428 defendant Chirell John   585902 585902 Chirell, John, of Reynham 0
4656646 2247974 2247974 plaintiff Champneys John   585902 585902 Champneys, John, of Reynham 0
4662544 2249754 2249754 defendant Rawelyn Roger shipman 585902 585902 Rawelyn, Roger, of Reynham, shipman 2
4663841 2250175 2250175 defendant Redyng John laborer 585902 585902 Redyng, John, of Reynham, laborer 0
4669592 2256199 2256199 defendant Whiteley John husbandman 585902 585902 Whiteley, John, of Reynham, husbandman 0
4675051 2257807 2257807 defendant Walwer John butcher 585902 585902 Walwer, John, of Reynham, butcher 0
4675052 2257807 2257807 defendant Daleys Thomas yeoman 585902 585902 Daleys, Thomas, of Reynham, yeoman 1
4687847 2261764 2261764 defendant Grene John   585902 585902 Grene, John, of Reynham 4
4687913 2261785 2261785 defendant Wormesell Lawrence miller 585902 585902 Wormesell, Lawrence, of Reynham, miller 0
4704088 2266657 2266657 defendant Godston John   585902 585902 Godston, John, of Reynham, Essex. Gent 1
4707503 2267720 2267720 defendant Botton John laborer 585902 585902 Botton, John, of Reynham, laborer 1
4711240 2268866 2268866 defendant Bedell Thomas carter 585902 585902 Bedell, Thomas, of Reynham, carter 2
4712652 2269273 2269273 defendant Dillay John husbandman 585902 585902 Dillay, John, of Reynham, husbandman 2
4718362 2271083 2271083 defendant Bromfeld Richard, sen husbandman 585902 585902 Bromfeld, Richard, sen, of Reynham, husbandman 0
4718363 2271083 2271083 defendant Bromfeld Thomas laborer 585902 585902 Bromfeld, Thomas, of Reynham, laborer 1
4718891 2271250 2271250 defendant Whitclyve John (legal representative) 585902 585902 Whitclyve, John, of Reynham, executrix of 3
4740507 2277735 2277735 defendant Baret James   585902 585902 Baret, James, of Reynham, servant, & son of Roger Baret 2
4741250 2277939 2277939 defendant Hocstoft Thomas yeoman 585902 585902 Hocstoft, Thomas, of Reynham, yeoman 0
4746641 2279507 2279507 defendant Ryvell John yeoman 585902 585902 Ryvell, John, of Reynham, yeoman 3
4755638 2282145 2282145 defendant Justys William husbandman 585902 585902 Justys, William, of Reynham, husbandman 0
4756367 2282356 2282356 defendant Frende John husbandman 585902 585902 Frende, John, of Reynham, husbandman 2
4767864 2285923 2285923 defendant Merdale Nicholas husbandman 585902 585902 Merdale, Nicholas, of Reynham, husbandman 0
4795483 2294739 2294739 defendant Faucon Ralph yeoman 585902 585902 Faucon, Ralph, of Reynham, yeoman 0
4800492 2296335 2296335 defendant Gelay Roger butcher 585902 585902 Gelay, Roger, of Reynham, butcher 3
4809203 2299054 2299054 defendant Smyth Richard   585902 585902 Smyth, Richard, of Reynham, shepherd 1
4814409 2300616 2300616 defendant Saundyr John husbandman 585902 585902 Saundyr, John, of Reynham, husbandman 0
4815760 2301031 2301031 defendant Wylby William   585902 585902 Wylby, William, of Reynham, vicar 0
4820124 2302370 2302370 defendant Prynce John   585902 585902 Prynce, John, of Reynham, mill wright 0
4838568 2307983 2307983 defendant Maas John husbandman 585902 585902 Maas, John, of Reynham, husbandman 0
4838569 2307983 2307983 defendant Grean John carpenter 585902 585902 Grean, John, of Reynham, carpenter 1
4844802 2309896 2309896 defendant Botte Robert husbandman 585902 585902 Botte, Robert, of Reynham, husbandman 0
4861057 2314816 2314816 defendant Mace John husbandman 585902 585902 Mace, John, of Reynham, husbandman 0
4865061 2316048 2316048 defendant Geffrey Adam carpenter 585902 585902 Geffrey, Adam, of Reynham, carpenter 3
4869518 2317433 2317433 defendant Grene Thomas husbandman 585902 585902 Grene, Thomas, of Reynham, husbandman 1
4877882 2320038 2320038 defendant Marchale William gent 585902 585902 Marchale, William, of Reynham, gent 2
4894514 2324957 2324957 defendant Maas John husbandman 585902 585902 Maas, John, of Reynham, husbandman 1
4907199 2328816 2328816 defendant Green William carpenter 585902 585902 Green, William, of Reynham, carpenter 1
4920690 2332985 2332985 plaintiff Ryefeld Richard   585902 585902 Ryefeld, Richard, of Reynham 2
4920693 2332985 2332985 defendant Ryefeld Richard   585902 585902 Ryefeld, Richard, of Reynham 2
4925023 2334258 2334258 defendant Culter Nicholas butcher 585902 585902 Culter, Nicholas, of Reynham, butcher 1
4956585 2343923 2343923 defendant Bromfeld Thomas husbandman 585902 585902 Bromfeld, Thomas, of Reynham, husbandman 4
4963987 2346139 2346139 defendant Culter Nicholas husbandman 585902 585902 Culter, Nicholas, of Reynham, husbandman 0
4968658 2347595 2347595 defendant Bekham John butcher 585902 585902 Bekham, John, of Reynham, butcher 0
4978516 2350524 2350524 defendant Danyell John husbandman 585902 585902 Danyell, John, of Reynham, husbandman 0
4987937 2353358 2353358 defendant atte Hethe Thomas husbandman 585902 585902 atte Hethe, Thomas, of Reynham, husbandman 1
4995368 2355456 2355456 defendant Fairwalle Robert yeoman 585902 585902 Fairwalle, Robert, of Reynham, yeoman 5
5020783 2362975 2362975 defendant Chauntrell John carpenter 585902 585902 Chauntrell, John, of Reynham, carpenter 0
5020784 2362975 2362975 defendant Whitlok John husbandman 585902 585902 Whitlok, John, of Reynham, husbandman 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);