names

226 rows where place_id = 588219

✎ 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
3593771 1865689 1865689 plaintiff Horn Edward   588219 588219 Horn, Edward, of Swafham 0
3597359 1866794 1866794 defendant Carter Geoffrey   588219 588219 Carter, Geoffrey, of Swafham, wool chapman 0
3597360 1866794 1866794 defendant Carter Richard husbandman 588219 588219 Carter, Richard, of Swafham, husbandman 1
3606525 1869712 1869712 defendant Lawes Richard carpenter 588219 588219 Lawes, Richard, of Swafham, carpenter 4
3641329 1907741 1907741 plaintiff Blake Simon (legal representative) 588219 588219 Blake, Simon, of Swafham, gent, executor of 0
3678594 1919362 1919362 defendant Walden John   588219 588219 Walden, John, of Swafham yeoman 1
3700767 1926492 1926492 defendant Olde John yeoman 588219 588219 Olde, John, of Swafham, yeoman 1
3700768 1926492 1926492 defendant Walden John yeoman 588219 588219 Walden, John, of Swafham, yeoman 2
3706169 1928221 1928221 defendant Draswer Thomas husbandman 588219 588219 Draswer, Thomas, of Swafham, husbandman 1
3721360 1932988 1932988 defendant Bryell Theobald yeoman 588219 588219 Bryell, Theobald, of Swafham, yeoman 0
3721376 1932993 1932993 defendant Bryell Theobald   588219 588219 Bryell, Theobald, of Swafham, surgeon 0
3736809 1937764 1937764 defendant Bosom Robert chaplain 588219 588219 Bosom, Robert, of Swafham, chaplain 0
3755820 1943773 1943773 defendant Payn Walter yeoman 588219 588219 Payn, Walter, of Swafham, yeoman 0
3766828 1947290 1947290 defendant Leman Thomas husbandman 588219 588219 Leman, Thomas, of Swafham, husbandman 1
3774109 1949617 1949617 plaintiff Alpe William   588219 588219 Alpe, William, of Swafham 0
3780952 1951777 1951777 defendant Stokys John   588219 588219 Stokys, John, of Swafham, hair maker 0
3793189 1955727 1955727 defendant Cokke Robert husbandman 588219 588219 Cokke, Robert, of Swafham, husbandman 3
3799623 1957805 1957805 defendant Bucke Robert   588219 588219 Bucke, Robert, of Swafham, wool merchant 2
3801195 1958295 1958295 defendant Leman Thomas husbandman 588219 588219 Leman, Thomas, of Swafham, husbandman 1
3801199 1958296 1958296 defendant Leman Thomas husbandman 588219 588219 Leman, Thomas, of Swafham, husbandman 1
3814963 1962599 1962599 defendant Atmere John husbandman 588219 588219 Atmere, John, of Swafham, husbandman 0
3818690 1963748 1963748 defendant Leman Thomas husbandman 588219 588219 Leman, Thomas, of Swafham, husbandman 1
3833430 1968382 1968382 defendant Lynne Thomas husbandman 588219 588219 Lynne, Thomas, of Swafham, husbandman 0
3839649 1970325 1970325 defendant Cambrygge Thomas husbandman 588219 588219 Cambrygge, Thomas, of Swafham Prior, husbandman 4
3846545 1972476 1972476 defendant Walters William husbandman 588219 588219 Walters, William, of Swafham, husbandman 1
3846564 1972482 1972482 defendant Walters William husbandman 588219 588219 Walters, William, of Swafham, husbandman 0
3932699 2001235 2001235 defendant Agge Robert yeoman 588219 588219 Agge, Robert, of Swafham, yeoman 0
4026686 2034190 2034190 plaintiff Cannon John   588219 588219 Cannon, John, of Swafham, wollen draper 0
4036841 2037860 2037860 plaintiff Jackson John innholder 588219 588219 Jackson, John, of Swafham, innholder 0
4421735 2171680 2171680 defendant Pra John   588219 588219 Pra, John, of Swafham 0
4421739 2171680 2171680 defendant Lystere John   588219 588219 Lystere, John, of Swafham 4
4424089 2172388 2172388 defendant Chaumbre Henry de la   588219 588219 Chaumbre, Henry de la, of Swafham 0
4424221 2172422 2172422 defendant Prat Thomas   588219 588219 Prat, Thomas, of Swafham 0
4441155 2182161 2182161 defendant Cote William   588219 588219 Cote, William, of Swafham 0
4448405 2184431 2184431 plaintiff Baudewyne John   588219 588219 Baudewyne, John, of Swafham 2
4465394 2189850 2189850 plaintiff Wombe Thomas (legal representative) 588219 588219 Wombe, Thomas, of Swafham, executors of 0
4467515 2190520 2190520 defendant Cursoun John   588219 588219 Cursoun, John, of Swafham 1
4471903 2191876 2191876 defendant Kele John   588219 588219 Kele, John, of Swafham 0
4480574 2194592 2194592 defendant Foulere John   588219 588219 Foulere, John, of Swafham 0
4498575 2200196 2200196 plaintiff Smyth John   588219 588219 Smyth, John, of Swafham prior 1
4499840 2200581 2200581 defendant Tavernber John   588219 588219 Tavernber, John, of Swafham 0
4512830 2204445 2204445 defendant Spencer Richard   588219 588219 Spencer, Richard, of Swafham 3
4516316 2205513 2205513 defendant Wryght William   588219 588219 Wryght, William, of Swafham 0
4518782 2206248 2206248 defendant Wolleman Geoffrey   588219 588219 Wolleman, Geoffrey, of Swafham 0
4533144 2210632 2210632 defendant Spenser Richard   588219 588219 Spenser, Richard, of Swafham 0
4533494 2210745 2210745 plaintiff Robyn John   588219 588219 Robyn, John, of Swafham 0
4544111 2214072 2214072 plaintiff Barbour Thomas   588219 588219 Barbour, Thomas, of Swafham 0
4544112 2214072 2214072 defendant Peper Margaret   588219 588219 Peper, Margaret, of Swafham 0
4547917 2215283 2215283 defendant Wolleman Bartholomew   588219 588219 Wolleman, Bartholomew, of Swafham 0
4557227 2218194 2218194 defendant Granour Richard   588219 588219 Granour, Richard, of Swafham 1
4557229 2218194 2218194 defendant Lenton John   588219 588219 Lenton, John, of Swafham 3
4557232 2218195 2218195 defendant Granour Richard   588219 588219 Granour, Richard, of Swafham 1
4557234 2218195 2218195 defendant Lenton John   588219 588219 Lenton, John, of Swafham 3
4565411 2220753 2220753 plaintiff Smyth John   588219 588219 Smyth, John, of Swafham Prior 0
4567040 2221247 2221247 defendant Bacheler Thomas   588219 588219 Bacheler, Thomas, of Swafham 0
4568455 2221706 2221706 defendant Trigge Richard   588219 588219 Trigge, Richard, of Swafham 0
4582211 2225874 2225874 defendant Pacch John   588219 588219 Pacch, John, of Swafham 0
4599772 2231151 2231151 defendant Gardyner Roger   588219 588219 Gardyner, Roger, of Swafham 0
4603711 2232349 2232349 plaintiff Wryghte Peter   588219 588219 Wryghte, Peter, of Swafham 0
4614629 2235584 2235584 defendant Pekke Geoffrey   588219 588219 Pekke, Geoffrey, of Swafham 2
4614630 2235584 2235584 defendant Taverner John   588219 588219 Taverner, John, of Swafham 3
4630791 2240521 2240521 plaintiff Baxster John   588219 588219 Baxster, John, of Swafham 1
4631768 2240817 2240817 defendant Joce John   588219 588219 Joce, John, of Swafham 0
4633455 2241316 2241316 defendant Lyster John   588219 588219 Lyster, John, of Swafham 3
4636206 2242155 2242155 defendant Taverner Thomas   588219 588219 Taverner, Thomas, of Swafham 0
4639080 2242949 2242949 defendant Deye Thomas   588219 588219 Deye, Thomas, of Swafham 1
4639081 2242949 2242949 defendant Wauton Peter   588219 588219 Wauton, Peter, of Swafham 2
4641880 2243732 2243732 defendant Hurt Thomas   588219 588219 Hurt, Thomas, of Swafham Prior 0
4645217 2244673 2244673 plaintiff Motte John   588219 588219 Motte, John, of Swafham Prior 0
4645218 2244673 2244673 plaintiff Baldewyn John   588219 588219 Baldewyn, John, of Swafham Prior 1
4647441 2245313 2245313 defendant Vyncent John   588219 588219 Vyncent, John, of Swafham 0
4647459 2245317 2245317 defendant Ede Thomas   588219 588219 Ede, Thomas, of Swafham 5
4648993 2245754 2245754 defendant Elmham John, sen   588219 588219 Elmham, John, sen, of Swafham 1
4649839 2245973 2245973 defendant Wantone Peter   588219 588219 Wantone, Peter, of Swafham 4
4651043 2246327 2246327 defendant Tryg Richard husbandman 588219 588219 Tryg, Richard, of Swafham, husbandman 0
4658706 2248597 2248597 plaintiff Crosse Richard   588219 588219 Crosse, Richard, of Swafham 0
4658707 2248597 2248597 defendant Robyn William husbandman 588219 588219 Robyn, William, of Swafham, husbandman 0
4678047 2258743 2258743 defendant Mot John husbandman 588219 588219 Mot, John, of Swafham Prior, husbandman 1
4687846 2261764 2261764 defendant Belton William laborer 588219 588219 Belton, William, of Swafham, laborer 3
4690052 2262441 2262441 defendant Bette Stephen   588219 588219 Bette, Stephen, of Swafham prior, mason 1
4692883 2263280 2263280 plaintiff Bacheler Thomas (legal representative) 588219 588219 Bacheler, Thomas, of Swafham, administrator of 0
4698485 2265002 2265002 plaintiff Crosse Richard   588219 588219 Crosse, Richard, of Swafham 3
4702727 2266252 2266252 defendant Ordewe John husbandman 588219 588219 Ordewe, John, of Swafham Prior, husbandman 1
4708118 2267915 2267915 defendant Teversham Thomas butcher 588219 588219 Teversham, Thomas, of Swafham, butcher 1
4715167 2270072 2270072 defendant Vyncent John tanner 588219 588219 Vyncent, John, of Swafham, tanner 2
4716085 2270338 2270338 defendant Baxter Henry   588219 588219 Baxter, Henry, of Swafham, bailiff 1
4734020 2275825 2275825 defendant Mapurly John   588219 588219 Mapurly, John, of Swafham, parson 1
4735967 2276396 2276396 defendant Belton William yeoman 588219 588219 Belton, William, of Swafham, yeoman 2
4735974 2276397 2276397 defendant Belton William yeoman 588219 588219 Belton, William, of Swafham, yeoman 3
4736019 2276404 2276404 defendant Belton William yeoman 588219 588219 Belton, William, of Swafham, yeoman 8
4736096 2276428 2276428 defendant Robyns John husbandman 588219 588219 Robyns, John, of Swafham, husbandman 3
4738306 2277075 2277075 defendant Sely Richard husbandman 588219 588219 Sely, Richard, of Swafham, husbandman 1
4739052 2277306 2277306 defendant Shepherde William husbandman 588219 588219 Shepherde, William, of Swafham Prior, husbandman 0
4746146 2279365 2279365 defendant Paschelwe Martine husbandman 588219 588219 Paschelwe, Martine, of Swafham Prior, husbandman 0
4746147 2279365 2279365 defendant Gylly Henry husbandman 588219 588219 Gylly, Henry, of Swafham Prior, husbandman 1
4746148 2279365 2279365 defendant Kyng Thomas husbandman 588219 588219 Kyng, Thomas, of Swafham Prior, husbandman 2
4746149 2279365 2279365 defendant Joce John husbandman 588219 588219 Joce, John, of Swafham Prior, husbandman 3
4752063 2281089 2281089 defendant Belton William yeoman 588219 588219 Belton, William, of Swafham, yeoman 6
4754708 2281856 2281856 defendant Hamond John husbandman 588219 588219 Hamond, John, of Swafham, husbandman 0
4755275 2282037 2282037 defendant Bogeys William husbandman 588219 588219 Bogeys, William, of Swafham Prior, 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);