names

92 rows where place_id = 589874

✎ 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
3599089 1867351 1867351 defendant Rygald Godfrey yeoman 589874 589874 Rygald, Godfrey, of Claxton, yeoman 0
3600563 1867822 1867822 defendant Lokwode John gent 589874 589874 Lokwode, John, of Claxton, gent 1
3604876 1869189 1869189 defendant Smalley John yeoman 589874 589874 Smalley, John, of Claxton, yeoman 4
3619078 1873569 1873569 defendant Wellys Thomas husbandman 589874 589874 Wellys, Thomas, of Claxton, husbandman 1
3626351 1903100 1903100 defendant Oxton Robert husbandman 589874 589874 Oxton, Robert, of Claxton, husbandman 0
3626354 1903101 1903101 defendant Pyne Robert husbandman 589874 589874 Pyne, Robert, of Claxton, husbandman 1
3637199 1906434 1906434 defendant Oxton Robert husbandman 589874 589874 Oxton, Robert, of Claxton, husbandman 1
3697459 1925424 1925424 defendant Gavell or Gabell Robert gent 589874 589874 Gavell or Gabell, Robert, of Claxton, gent 2
3765862 1946989 1946989 defendant Hill Thomas husbandman 589874 589874 Hill, Thomas, of Claxton, husbandman 0
3789586 1954570 1954570 defendant Gavell Robert gent 589874 589874 Gavell, Robert, of Claxton, gent 1
3831495 1967735 1967735 defendant Gavell Robert gent 589874 589874 Gavell, Robert, of Claxton, gent 4
3872964 1981172 1981172 defendant Hooys William laborer 589874 589874 Hooys, William, of Claxton, laborer 0
3872965 1981172 1981172 defendant Levers Thomas husbandman 589874 589874 Levers, Thomas, of Claxton, husbandman 1
3872966 1981172 1981172 defendant Curson William husbandman 589874 589874 Curson, William, of Claxton, husbandman 2
3872967 1981172 1981172 defendant Hiklyng Richard husbandman 589874 589874 Hiklyng, Richard, of Claxton, husbandman 3
3886588 1985763 1985763 defendant Mower John husbandman 589874 589874 Mower, John, of Claxton, husbandman 0
3905662 1992167 1992167 defendant Webster Richard clerk 589874 589874 Webster, Richard, of Claxton, clerk 0
3917239 1996125 1996125 defendant Denys Edward yeoman 589874 589874 Denys, Edward, of Claxton, yeoman 0
3964446 2012167 2012167 defendant Bert John yeoman 589874 589874 Bert, John, of Claxton, yeoman 0
3970765 2014367 2014367 plaintiff Doraunte Thomas yeoman 589874 589874 Doraunte, Thomas, of Claxton, yeoman 0
3996027 2023333 2023333 defendant Durrant Thomas husbandman 589874 589874 Durrant, Thomas, of Claxton, husbandman 1
3996036 2023335 2023335 defendant Durrant Thomas husbandman 589874 589874 Durrant, Thomas, of Claxton, husbandman 1
4003171 2025894 2025894 defendant Durrant Thomas husbandman 589874 589874 Durrant, Thomas, of Claxton, husbandman 0
4029316 2035128 2035128 defendant Durrant Thomas husbandman 589874 589874 Durrant, Thomas, of Claxton, husbandman 0
4029321 2035129 2035129 defendant Durrant Thomas husbandman 589874 589874 Durrant, Thomas, of Claxton, husbandman 1
4059246 2045701 2045701 defendant Durraunt Thomas husbandman 589874 589874 Durraunt, Thomas, of Claxton, husbandman 2
4078051 2052452 2052452 defendant Beamys Francis husbandman 589874 589874 Beamys, Francis, of Claxton, husbandman 1
4264886 2117893 2117893 defendant Durrant Thomas yeoman 589874 589874 Durrant, Thomas, of Claxton, yeoman 0
4264887 2117893 2117893 defendant Durrant William husbandman 589874 589874 Durrant, William, of Claxton, husbandman 1
4286199 2125118 2125118 defendant Heywarde Henry (legal representative) 589874 589874 Heywarde, Henry, of Claxton, gent, administrator of 0
4301946 2130805 2130805 defendant Webb John (legal representative) 589874 589874 Webb, John, of Claxton , Midsomer Norton yeoman, executrix of 0
4324612 2138623 2138623 defendant Legat Thomas carpenter 589874 589874 Legat, Thomas, of Claxton, carpenter 0
4324613 2138623 2138623 defendant Durrant William husbandman 589874 589874 Durrant, William, of Claxton, husbandman 1
4324615 2138623 2138623 defendant Durrant Thomas yeoman 589874 589874 Durrant, Thomas, of Claxton, yeoman 3
4384926 2159649 2159649 defendant Legate Silvester husbandman 589874 589874 Legate, Silvester, of Claxton, husbandman 1
4386925 2160291 2160291 defendant Durrant Thomas yeoman 589874 589874 Durrant, Thomas, of Claxton, yeoman 3
4386937 2160293 2160293 defendant Browne Thomas husbandman 589874 589874 Browne, Thomas, of Claxton, husbandman 3
4436143 2176045 2176045 defendant Erle Ralph   589874 589874 Erle, Ralph, of Claxton 2
4436146 2176046 2176046 defendant Agas Ralph   589874 589874 Agas, Ralph, of Claxton 1
4575325 2223794 2223794 defendant Lonseby John   589874 589874 Lonseby, John, of Claxton 0
4602399 2231966 2231966 defendant Drapur Thomas   589874 589874 Drapur, Thomas, of Claxton 0
4611862 2234773 2234773 defendant Wyreham Geoffrey   589874 589874 Wyreham, Geoffrey, of Claxton 0
4679019 2259044 2259044 defendant Kese Thomas yeoman 589874 589874 Kese, Thomas, of Claxton, yeoman 2
4713468 2269534 2269534 defendant Claxton Isabel widow 589874 589874 Claxton, Isabel, of Claxton, widow 5
4736425 2276524 2276524 plaintiff Taillour Gilbert   589874 589874 Taillour, Gilbert, of Claxton 0
4754364 2281744 2281744 plaintiff Wymondeham Edward   589874 589874 Wymondeham, Edward, of Claxton 0
4754366 2281745 2281745 plaintiff Wymondeham Edward   589874 589874 Wymondeham, Edward, of Claxton 0
4833407 2306455 2306455 defendant Mortemer John husbandman 589874 589874 Mortemer, John, of Claxton, husbandman 0
4875164 2319185 2319185 defendant Claxton John gent 589874 589874 Claxton, John, of Claxton, gent 1
4919975 2332759 2332759 defendant Monk Robert husbandman 589874 589874 Monk, Robert, of Claxton, husbandman 0
4922055 2333309 2333309 defendant Draper John husbandman 589874 589874 Draper, John, of Claxton, husbandman 1
4941452 2339347 2339347 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 0
4941456 2339348 2339348 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 0
4958416 2344484 2344484 defendant Ayleward Thomas yeoman 589874 589874 Ayleward, Thomas, of Claxton, yeoman 0
4958417 2344484 2344484 defendant Deynes Henry   589874 589874 Deynes, Henry, of Claxton, servant 1
4958419 2344485 2344485 defendant Deynes Henry   589874 589874 Deynes, Henry, of Claxton, servant 0
4959125 2344698 2344698 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 2
4969295 2347776 2347776 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 0
4975814 2349732 2349732 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 0
4975822 2349735 2349735 defendant Kerdeston Thomas   589874 589874 Kerdeston, Thomas, of Claxton, knight 1
4978215 2350434 2350434 defendant Ayleward Thomas yeoman 589874 589874 Ayleward, Thomas, of Claxton, yeoman 0
4998502 2356433 2356433 defendant Porter John husbandman 589874 589874 Porter, John, of Claxton, husbandman 0
5047114 2370760 2370760 defendant Kerdston Thomas (legal representative) 589874 589874 Kerdston, Thomas, of Claxton, knight, executrix of 0
5047197 2370782 2370782 defendant Cres-am Thomas   589874 589874 Cres-am, Thomas, of Claxton, servant 2
5047199 2370782 2370782 defendant Wrote Margaret   589874 589874 Wrote, Margaret, of Claxton, servant 4
5067682 2376827 2376827 defendant Dowes John yeoman 589874 589874 Dowes, John, of Claxton, yeoman 2
5187289 2412009 2412009 defendant May Thomas husbandman 589874 589874 May, Thomas, of Claxton, husbandman 1
5187290 2412009 2412009 defendant Boney Robert husbandman 589874 589874 Boney, Robert, of Claxton, husbandman 2
5259566 2433113 2433113 defendant Smyth James husbandman 589874 589874 Smyth, James, of Claxton, husbandman 1
5293304 2443024 2443024 defendant Toke Henry husbandman 589874 589874 Toke, Henry, of Claxton, husbandman 0
5293310 2443025 2443025 defendant Toke Henry husbandman 589874 589874 Toke, Henry, of Claxton, husbandman 0
5305805 2446739 2446739 defendant Herte John   589874 589874 Herte, John, of Claxton, formerly vicar & clerk 4
5329293 2453843 2453843 defendant Wellys Thomas husbandman 589874 589874 Wellys, Thomas, of Claxton, husbandman 2
5358398 2462680 2462680 defendant Welles Thomas yeoman 589874 589874 Welles, Thomas, of Claxton, yeoman 3
5390911 2472469 2472469 plaintiff Neweman William   589874 589874 Neweman, William, of Claxton 0
5390912 2472469 2472469 plaintiff Neweman John   589874 589874 Neweman, John, of Claxton 1
5390913 2472469 2472469 plaintiff Neweman Isabel   589874 589874 Neweman, Isabel, of Claxton 2
5390914 2472469 2472469 plaintiff Neweman Margaret   589874 589874 Neweman, Margaret, of Claxton 3
5403861 2476178 2476178 plaintiff Neweman William   589874 589874 Neweman, William, of Claxton 0
5403862 2476178 2476178 plaintiff Neweman John   589874 589874 Neweman, John, of Claxton 1
5403863 2476178 2476178 plaintiff Neweman Isabel   589874 589874 Neweman, Isabel, of Claxton 2
5403864 2476178 2476178 plaintiff Neweman Margaret   589874 589874 Neweman, Margaret, of Claxton 3
5416974 2479991 2479991 plaintiff Neweman William   589874 589874 Neweman, William, of Claxton 0
5416975 2479991 2479991 plaintiff Neweman John   589874 589874 Neweman, John, of Claxton 1
5416976 2479991 2479991 plaintiff Neweman Isabel   589874 589874 Neweman, Isabel, of Claxton 2
5416977 2479991 2479991 plaintiff Neweman Margaret   589874 589874 Neweman, Margaret, of Claxton 3
5490986 2502204 2502204 defendant Barret John husbandman 589874 589874 Barret, John, of Claxton, husbandman 1
5497129 2504079 2504079 defendant Toke Henry yeoman 589874 589874 Toke, Henry, of Claxton, yeoman 2
5497365 2504150 2504150 defendant Thomrison Robert husbandman 589874 589874 Thomrison, Robert, of Claxton, husbandman 3
5500888 2505210 2505210 defendant Robyn William husbandman 589874 589874 Robyn, William, of Claxton, husbandman 0
5506905 2507076 2507076 defendant Blyklyng Leonard chaplain 589874 589874 Blyklyng, Leonard, of Claxton, chaplain 1
5512163 2508667 2508667 defendant Toke Henry yeoman 589874 589874 Toke, Henry, of Claxton, 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);