names

133 rows where place_id = 596221

✎ 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
3623730 1874955 1874955 defendant Tadlowe Thomas yeoman 596221 596221 Tadlowe, Thomas, of Lytlyngton, yeoman 0
3639336 1907112 1907112 defendant Johnson William yeoman 596221 596221 Johnson, William, of Lytlyngton, yeoman 0
3639753 1907243 1907243 defendant Tadelowe Thomas gent 596221 596221 Tadelowe, Thomas, of Lytlyngton, gent 0
3640067 1907341 1907341 defendant Atthowe William tailor 596221 596221 Atthowe, William, of Lytlyngton, tailor 0
3641280 1907725 1907725 plaintiff Betcote John husbandman 596221 596221 Betcote, John, of Lytlyngton, husbandman 0
3663796 1914610 1914610 defendant Bliton Walter husbandman 596221 596221 Bliton, Walter, of Lytlyngton, husbandman 0
3663797 1914610 1914610 defendant Ryseley Thomas husbandman 596221 596221 Ryseley, Thomas, of Lytlyngton, husbandman 1
3663799 1914611 1914611 defendant Riseley Thomas husbandman 596221 596221 Riseley, Thomas, of Lytlyngton, husbandman 0
3670965 1916890 1916890 defendant Bysshop Richard yeoman 596221 596221 Bysshop, Richard, of Lytlyngton, yeoman 0
3674969 1918203 1918203 defendant Dryver William laborer 596221 596221 Dryver, William, of Lytlyngton, laborer 0
3699814 1926165 1926165 defendant Rotes William gent 596221 596221 Rotes, William, of Lytlyngton, gent 10
3699815 1926165 1926165 defendant Broke James husbandman 596221 596221 Broke, James, of Lytlyngton, husbandman 11
3706029 1928177 1928177 defendant A Broke John, senior husbandman 596221 596221 A Broke, John, senior, of Lytlyngton, husbandman 0
3713295 1930468 1930468 plaintiff A Broke John   596221 596221 A Broke, John, of Lytlyngton 0
3722112 1933178 1933178 defendant Jourden William yeoman 596221 596221 Jourden, William, of Lytlyngton, yeoman 0
3728783 1935247 1935247 plaintiff A Broke John   596221 596221 A Broke, John, of Lytlyngton 0
3734770 1937119 1937119 defendant Dykyns Joan widow 596221 596221 Dykyns, Joan, of Lytlyngton, widow 0
3743944 1939995 1939995 plaintiff A Broke John   596221 596221 A Broke, John, of Lytlyngton 0
3816624 1963100 1963100 defendant Rote John (legal representative) 596221 596221 Rote, John, of Lytlyngton, gent, executor of 0
3850708 1973812 1973812 defendant Chamber Leonard husbandman 596221 596221 Chamber, Leonard, of Lytlyngton, husbandman 1
3856863 1975776 1975776 plaintiff A Broke Richard, senior   596221 596221 A Broke, Richard, senior, of Lytlyngton 0
3857786 1976074 1976074 defendant Cartwryght William (legal representative) 596221 596221 Cartwryght, William, of Lytlyngton, gent, executors of 0
3862402 1977617 1977617 defendant Ayer John husbandman 596221 596221 Ayer, John, of Lytlyngton, husbandman 4
3862520 1977660 1977660 defendant Stonley John husbandman 596221 596221 Stonley, John, of Lytlyngton, husbandman 0
3867567 1979387 1979387 defendant Pyte William husbandman 596221 596221 Pyte, William, of Lytlyngton, husbandman 3
3888706 1986479 1986479 defendant Chamber Richard yeoman 596221 596221 Chamber, Richard, of Lytlyngton, yeoman 2
3905189 1992000 1992000 defendant Parbery Hugh miller 596221 596221 Parbery, Hugh, of Lytlyngton, miller 0
3936542 2002546 2002546 plaintiff Marvell John   596221 596221 Marvell, John, of Lytlyngton 0
3943736 2004921 2004921 defendant Dycons Francis (legal representative) 596221 596221 Dycons, Francis, of Lytlyngton, gent, administrator of 0
3945763 2005591 2005591 plaintiff Broke Richard yeoman 596221 596221 Broke, Richard, of Lytlyngton, yeoman 0
3949616 2006940 2006940 defendant Julyan Thomas yeoman 596221 596221 (Julyan, Thomas, of Lytlyngton, yeoman 1
3964541 2012199 2012199 defendant Dycons Francis (legal representative) 596221 596221 Dycons, Francis, of Lytlyngton, or of Marston, gent, administrator of 0
4046164 2041069 2041069 plaintiff Sherman John yeoman 596221 596221 Sherman, John, of Lytlyngton, yeoman 0
4057377 2045020 2045020 defendant Iden Thomas clerk 596221 596221 Iden, Thomas, of Lytlyngton, clerk 1
4066460 2048298 2048298 defendant Iden Thomas clerk 596221 596221 Iden, Thomas, of Lytlyngton, clerk 2
4070090 2049592 2049592 defendant Abrooke John, junior yeoman 596221 596221 Abrooke, John, junior, of Lytlyngton, yeoman 0
4082151 2053925 2053925 plaintiff A Broke John   596221 596221 A Broke, John, of Lytlyngton, yeoman, son of James A Brooke 0
4107038 2062814 2062814 defendant Yden Thomas yeoman 596221 596221 Yden, Thomas, of Lytlyngton, yeoman 1
4108652 2063349 2063349 defendant Iden Thomas clerk 596221 596221 Iden, Thomas, of Lytlyngton, clerk 0
4126725 2069845 2069845 defendant Stonestrete Thomas butcher 596221 596221 Stonestrete, Thomas, of Lytlyngton, butcher 0
4129917 2071010 2071010 defendant Stonestrete Thomas butcher 596221 596221 Stonestrete, Thomas, of Lytlyngton, butcher 0
4136557 2073418 2073418 defendant Stonestrete Thomas butcher 596221 596221 Stonestrete, Thomas, of Lytlyngton, butcher 2
4137304 2073690 2073690 defendant Stonestrete Thomas butcher 596221 596221 Stonestrete, Thomas, of Lytlyngton, butcher 0
4137306 2073691 2073691 defendant Stonestrete Thomas butcher 596221 596221 Stonestrete, Thomas, of Lytlyngton, butcher 0
4140545 2074860 2074860 defendant Iden William husbandman 596221 596221 Iden, William, of Lytlyngton, husbandman 1
4147007 2077099 2077099 defendant Stonestreat Thomas butcher 596221 596221 Stonestreat, Thomas, of Lytlyngton, butcher 0
4152313 2078919 2078919 defendant Stonstrete Thomas butcher 596221 596221 Stonstrete, Thomas, of Lytlyngton, butcher 0
4415385 2169708 2169708 plaintiff Hastynges Thomas   596221 596221 Hastynges, Thomas, of Lytlyngton 0
4415386 2169708 2169708 plaintiff atte Funecle Henry   596221 596221 atte Funecle, Henry, of Lytlyngton 1
4443839 2183045 2183045 defendant Dych John   596221 596221 Dych, John, of Lytlyngton 2
4487952 2196955 2196955 defendant atte Wode Robert   596221 596221 atte Wode, Robert, of Lytlyngton 5
4487958 2196956 2196956 defendant A--- Robert   596221 596221 A---, Robert, of Lytlyngton 1
4586702 2227247 2227247 defendant Spenser John   596221 596221 Spenser, John, of Lytlyngton 2
4586738 2227254 2227254 defendant Plattyng Thomas   596221 596221 Plattyng, Thomas, of Lytlyngton 0
4586739 2227254 2227254 defendant Bette John   596221 596221 Bette, John, of Lytlyngton 1
4590078 2228259 2228259 defendant Norton John   596221 596221 Norton, John, of Lytlyngton 1
4604182 2232477 2232477 defendant Plattyng Thomas   596221 596221 Plattyng, Thomas, of Lytlyngton 1
4612264 2234901 2234901 plaintiff Cors John, sen   596221 596221 Cors, John, sen, of Lytlyngton 0
4614049 2235409 2235409 defendant Ray Lawrence   596221 596221 Ray, Lawrence, of Lytlyngton 0
4615729 2235919 2235919 defendant Meleman Geoffrey   596221 596221 Meleman, Geoffrey, of Lytlyngton 0
4628538 2239847 2239847 defendant Spenser John   596221 596221 Spenser, John, of Lytlyngton 2
4631743 2240813 2240813 defendant Spenser John   596221 596221 Spenser, John, of Lytlyngton 0
4644599 2244512 2244512 defendant Smyth alias Tayllour Thomas   596221 596221 Smyth alias Tayllour, Thomas, of Lytlyngton 0
4672468 2257040 2257040 defendant Wynter Robert maltman 596221 596221 Wynter, Robert, of Lytlyngton, maltman 0
4681369 2259795 2259795 defendant Smyth John tailor 596221 596221 Smyth, John, of Lytlyngton, tailor 0
4681370 2259795 2259795 defendant Smyth Thomas laborer 596221 596221 Smyth, Thomas, of Lytlyngton, laborer 1
4681544 2259838 2259838 defendant Lecche Roger husbandman 596221 596221 Lecche, Roger, of Lytlyngton, husbandman 0
4688136 2261860 2261860 plaintiff S--yon John   596221 596221 S--yon, John, of Lytlyngton 0
4728816 2274250 2274250 defendant Cors John husbandman 596221 596221 Cors, John, of Lytlyngton, husbandman 5
4734690 2276004 2276004 defendant Marles William carpenter 596221 596221 Marles, William, of Lytlyngton, carpenter 0
4781073 2290089 2290089 plaintiff Caumpe Thomas   596221 596221 Caumpe, Thomas, of Lytlyngton 0
4781492 2290222 2290222 defendant Brode John husbandman 596221 596221 Brode, John, of Lytlyngton, husbandman 0
4815639 2300997 2300997 defendant Roper John   596221 596221 Roper, John, of Lytlyngton, rope maker 0
4841668 2308926 2308926 defendant Strete Henry husbandman 596221 596221 Strete, Henry, of Lytlyngton, husbandman 0
4841687 2308934 2308934 defendant Botiller William yeoman 596221 596221 Botiller, William, of Lytlyngton, yeoman 0
4846602 2310448 2310448 defendant Botiller William yeoman 596221 596221 Botiller, William, of Lytlyngton, yeoman 0
4846606 2310450 2310450 defendant Botiller William yeoman 596221 596221 Botiller, William, of Lytlyngton, yeoman 0
4846608 2310451 2310451 defendant Botiller William yeoman 596221 596221 Botiller, William, of Lytlyngton, yeoman 0
4848978 2311146 2311146 plaintiff Palfot William   596221 596221 Palfot, William, of Lytlyngton 2
4869042 2317288 2317288 defendant Strete Henry husbandman 596221 596221 Strete, Henry, of Lytlyngton, husbandman 0
4882295 2321372 2321372 defendant Boteller Isabel   596221 596221 Boteller, Isabel, of Lytlyngton, widow of Boteller, William 1
4883280 2321697 2321697 defendant Pynke John husbandman 596221 596221 Pynke, John, of Lytlyngton, husbandman 0
4883282 2321698 2321698 defendant Pynke John husbandman 596221 596221 Pynke, John, of Lytlyngton, husbandman 0
4894029 2324834 2324834 plaintiff Smyth William   596221 596221 Smyth, William, of Lytlyngton 0
4894760 2325031 2325031 defendant Pynke John husbandman 596221 596221 Pynke, John, of Lytlyngton, husbandman 0
4908525 2329223 2329223 defendant Fenell Henry husbandman 596221 596221 Fenell, Henry, of Lytlyngton, husbandman 0
4908526 2329223 2329223 defendant Pope William laborer 596221 596221 Pope, William, of Lytlyngton, laborer 1
4908527 2329223 2329223 defendant Cheseman William husbandman 596221 596221 Cheseman, William, of lytlyngton, husbandman 2
4911123 2329990 2329990 defendant Trotymer William husbandman 596221 596221 Trotymer, William, of Lytlyngton, husbandman 1
4911935 2330239 2330239 plaintiff Caumpes Thomas gent 596221 596221 Caumpes, Thomas, of Lytlyngton, gent 2
4913086 2330590 2330590 defendant Campes Thomas gent 596221 596221 Campes, Thomas, of Lytlyngton, gent 2
4918188 2332209 2332209 defendant Trotemere William husbandman 596221 596221 Trotemere, William, of Lytlyngton, husbandman 0
4925793 2334499 2334499 defendant Archer Henry husbandman 596221 596221 Archer, Henry, of Lytlyngton, husbandman 0
4933163 2336765 2336765 defendant Lye Richard husbandman 596221 596221 Lye, Richard, of Lytlyngton, husbandman 0
4933167 2336766 2336766 defendant Cheseman William husbandman 596221 596221 Cheseman, William, of Lytlyngton, husbandman 0
4933168 2336766 2336766 defendant Fenell Henry husbandman 596221 596221 Fenell, Henry, of Lytlyngton, husbandman 1
4933169 2336766 2336766 defendant Lye Richard husbandman 596221 596221 Lye, Richard, of Lytlyngton, husbandman 2
4950357 2342077 2342077 plaintiff Palfot William   596221 596221 Palfot, William, of Lytlyngton 0
4950360 2342077 2342077 defendant Trotymere William husbandman 596221 596221 Trotymere, William, of Lytlyngton, husbandman 2
5011066 2360091 2360091 defendant Roper John husbandman 596221 596221 Roper, John, of Lytlyngton, husbandman 2

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);