names

80 rows where place_id = 594575

✎ 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
3616649 1872837 1872837 defendant Daweney Richard tailor 594575 594575 Daweney, Richard, of Est Sutton, tailor 3
3635641 1905949 1905949 defendant Boycott John husbandman 594575 594575 Boycott, John, of Est Sutton, husbandman 0
3635645 1905950 1905950 plaintiff Pende Stephen gent 594575 594575 Pende, Stephen, of Est Sutton, gent 0
3649669 1910268 1910268 defendant Pratt Thomas (legal representative) 594575 594575 Pratt, Thomas, of Est Sutton, administratrix of 0
3669360 1916355 1916355 defendant Edyall William clerk 594575 594575 Edyall, William, of Est Sutton juxta Dover, clerk 0
3686109 1921815 1921815 defendant Peers Richard yeoman 594575 594575 Peers, Richard, of Est Sutton, yeoman 0
3694034 1924338 1924338 defendant Pyerce Richard fuller 594575 594575 Pyerce, Richard, of Est Sutton, fuller 0
3694036 1924339 1924339 defendant Pyerce Richard fuller 594575 594575 Pyerce, Richard, of Est Sutton, fuller 0
3694991 1924645 1924645 defendant Stokes Thomas husbandman 594575 594575 Stokes, Thomas, of East Sutton, husbandman 3
3704404 1927676 1927676 defendant Pende Stephen gent 594575 594575 Pende, Stephen, of East Sutton, gent 0
3704411 1927677 1927677 defendant Pende Stephen gent 594575 594575 Pende, Stephen, of East Sutton, gent 0
3708978 1929102 1929102 defendant Stokys Thomas husbandman 594575 594575 Stokys, Thomas, of East Sutton, husbandman 0
3776422 1950381 1950381 defendant Byx Thomas butcher 594575 594575 Byx, Thomas, of Est Sutton, butcher 0
3782708 1952334 1952334 defendant Byx Thomas butcher 594575 594575 Byx, Thomas, of Est Sutton, butcher 0
3788577 1954226 1954226 defendant Byx Thomas butcher 594575 594575 Byx, Thomas, of Est Sutton, butcher 0
3802572 1958700 1958700 plaintiff Pende Stephen gent 594575 594575 Pende, Stephen, of Est Sutton, gent 0
3803106 1958874 1958874 defendant Pers Richard clothmaker 594575 594575 Pers, Richard, of East Sutton, clothmaker 1
3808090 1960422 1960422 defendant Reder John shoemaker 594575 594575 Reder, John, of Est Sutton, shoemaker 1
3818224 1963614 1963614 defendant Pers Richard clothier 594575 594575 Pers, Richard, of Est Sutton, clothier 0
3820025 1964144 1964144 plaintiff Pende Stephen gent 594575 594575 Pende, Stephen, of Est Sutton, gent 0
3820030 1964145 1964145 plaintiff Pende Stephen gent 594575 594575 Pende, Stephen, of Est Sutton, gent 0
3821040 1964472 1964472 defendant Wylcok Thomas tanner 594575 594575 Wylcok, Thomas, of Est Sutton, tanner 1
3824303 1965473 1965473 defendant Byx Thomas butcher 594575 594575 Byx, Thomas, of Est Sutton, butcher 0
3834214 1968642 1968642 defendant Pryce Richard fuller 594575 594575 Pryce, Richard, of Est Sutton, fuller 1
3848419 1973082 1973082 defendant Neleson Richard husbandman 594575 594575 Neleson, Richard, of Est Sutton, husbandman 1
3861892 1977437 1977437 defendant Nelson Richard husbandman 594575 594575 Nelson, Richard, of East Sutton, husbandman 0
3861894 1977437 1977437 defendant Crotynden William sawyer 594575 594575 Crotynden, William, of East Sutton, sawyer 2
3861895 1977437 1977437 defendant Spyllet Edward husbandman 594575 594575 Spyllet, Edward, of East Sutton, husbandman 3
4322363 2137893 2137893 defendant Husmer Richard, junior butcher 594575 594575 Husmer, Richard, junior, of East Sutton, butcher 0
4332421 2141134 2141134 defendant Sacharye Thomas butcher 594575 594575 Sacharye, Thomas, of East Sutton, or of Hedcorne, butcher 0
4358214 2150104 2150104 defendant Byll George clothier 594575 594575 Byll, George, of East Sutton, clothier 1
4568522 2221729 2221729 plaintiff Vyn Robert   594575 594575 Vyn, Robert, of East Sutton 0
4645599 2244783 2244783 defendant Charlton John   594575 594575 Charlton, John, of East Sutton 1
4658618 2248572 2248572 defendant Barlyng Thomas husbandman 594575 594575 Barlyng, Thomas, of Est Sutton, husbandman 0
4658619 2248572 2248572 defendant Barlyng William husbandman 594575 594575 Barlyng, William, of Est Sutton, husbandman 1
4658620 2248572 2248572 defendant Barlyng John husbandman 594575 594575 Barlyng, John, of Est Sutton, husbandman 2
4662795 2249821 2249821 defendant atte Walle Robert sawyer 594575 594575 atte Walle, Robert, of Est Sutton, sawyer 3
4686832 2261493 2261493 defendant Cristemasse John husbandman 594575 594575 Cristemasse, John, of East Sutton, husbandman 0
4727741 2273921 2273921 defendant Charlton John husbandman 594575 594575 Charlton, John, of East Sutton, husbandman 0
4750216 2280541 2280541 defendant Cristemasse John draper 594575 594575 Cristemasse, John, of East Sutton, draper 0
4769275 2286369 2286369 defendant Cristemasse atte Helle John, sen husbandman 594575 594575 Cristemasse atte Helle, John, sen, of East Sutton, husbandman 0
4782130 2290411 2290411 defendant Ch- John tailor 594575 594575 Ch-, John, of Est Sutton, tailor 1
4782854 2290656 2290656 defendant Dawdymers Richard husbandman 594575 594575 Dawdymers, Richard, of Est Sutton, husbandman 0
4783255 2290782 2290782 defendant Cristemasse atte Helle John, senior husbandman 594575 594575 Cristemasse atte Helle, John, senior, of Est Sutton, husbandman 0
4783256 2290782 2290782 defendant Cristemasse atte Helle John, junior husbandman 594575 594575 Cristemasse atte Helle, John, junior, of Est Sutton, husbandman 1
4791227 2293355 2293355 defendant Dunbury Stephen husbandman 594575 594575 Dunbury, Stephen, of Est Sutton, husbandman 1
4893770 2324747 2324747 defendant Dandemer Richard husbandman 594575 594575 Dandemer, Richard, of Est Sutton, husbandman 0
4893771 2324747 2324747 defendant Barlyng William husbandman 594575 594575 Barlyng, William, of Est Sutton, husbandman 1
4903788 2327803 2327803 defendant Dandemere Richard husbandman 594575 594575 Dandemere, Richard, of Est Sutton, husbandman 0
4905671 2328375 2328375 defendant Donnyng or Dounyng John   594575 594575 Donnyng or Dounyng, John, of Est Sutton, chalon weaver 1
4919946 2332749 2332749 defendant Dowenyng John husbandman 594575 594575 Dowenyng, John, of East Sutton, husbandman 0
4971042 2348278 2348278 defendant Alby John husbandman 594575 594575 Alby, John, of Est Sutton, husbandman 0
4986247 2352816 2352816 defendant Dounyng John weaver 594575 594575 Dounyng, John, of East Sutton, weaver 0
4997538 2356116 2356116 defendant Alby John laborer 594575 594575 Alby, John, of East Sutton, laborer 0
5032032 2366242 2366242 defendant Daundemer Richard husbandman 594575 594575 Daundemer, Richard, of Est Sutton, husbandman 1
5046493 2370589 2370589 defendant Stont or Stout John clerk 594575 594575 Stont or Stout, John, of East Sutton, clerk 5
5110686 2389529 2389529 defendant Tastelbak Thomas husbandman 594575 594575 Tastelbak, Thomas, of Est Sutton, husbandman 0
5110687 2389529 2389529 defendant Barlyng William husbandman 594575 594575 Barlyng, William, of Est Sutton, husbandman 1
5143223 2399153 2399153 defendant Alby John husbandman 594575 594575 Alby, John, of East Sutton, husbandman 0
5152593 2401899 2401899 defendant Couper Thomas cooper 594575 594575 Couper, Thomas, of East Sutton, cooper 0
5178676 2409478 2409478 defendant Tebbe John yeoman 594575 594575 Tebbe, John, of East Sutton, yeoman 0
5297786 2444359 2444359 defendant Chirche Thomas husbandman 594575 594575 Chirche, Thomas, of East Sutton, husbandman 0
5311904 2448587 2448587 defendant Tebbe Agnes widow 594575 594575 Tebbe, Agnes, of East Sutton, widow 1
5349191 2459871 2459871 defendant Cherche Thomas husbandman 594575 594575 Cherche, Thomas, of Est Sutton, husbandman 0
5361066 2463487 2463487 defendant Usmere Robert husbandman 594575 594575 Usmere, Robert, of Est Sutton, husbandman 0
5438412 2486421 2486421 defendant Burges Thomas husbandman 594575 594575 Burges, Thomas, of East Sutton, husbandman 0
5447168 2489043 2489043 defendant Taylour William husbandman 594575 594575 Taylour, William, of East Sutton, husbandman 0
5456005 2491709 2491709 defendant Taylour William husbandman 594575 594575 Taylour, William, of East Sutton, husbandman 0
5461379 2493353 2493353 defendant Burly Thomas husbandman 594575 594575 Burly, Thomas, of East Sutton, husbandman 0
5467849 2495323 2495323 defendant Taylour William husbandman 594575 594575 together with Taylour, William, of East Sutton, husbandman 1
5471300 2496353 2496353 defendant Taylour William husbandman 594575 594575 Taylour, William, of East Sutton, husbandman 0
5498181 2504407 2504407 defendant Thowe Thomas gent 594575 594575 Thowe, Thomas, of Est Sutton, gent 0
5505668 2506693 2506693 defendant Elcok Robert husbandman 594575 594575 Elcok, Robert, of Est Sutton, husbandman 0
5530601 2514085 2514085 defendant Rokhole John husbandman 594575 594575 Rokhole, John, of Est Sutton, husbandman 4
5537875 2516333 2516333 defendant Osmer Robert husbandman 594575 594575 Osmer, Robert, of Est Sutton, husbandman 1
5581274 2529214 2529214 defendant Eldregge James, senior clothmaker 594575 594575 Eldregge, James, senior, of Est Sutton, clothmaker 3
5581275 2529214 2529214 defendant Eldregge James, junior   594575 594575 Eldregge, James, junior, of Est Sutton 4
5591720 2532397 2532397 defendant Dawny Richard tailor 594575 594575 Dawny, Richard, of East Sutton, tailor 1
5603667 2536014 2536014 defendant Glover William laborer 594575 594575 Glover, William, of Est Sutton, laborer 2
5607314 2537177 2537177 defendant Burden Robert fuller 594575 594575 Burden, Robert, of Est Sutton, fuller 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);