names

165 rows where place_id = 753386

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3817471 1963376 1963376 defendant Cheyne Christopher   753386 753386 Cheyne, Christopher, of Branketre, Essex tailor 2
4413137 2168978 2168978 defendant Dassh John fishmonger 753386 753386 Dassh, John, of Branketre, fishmonger 0
4418412 2170635 2170635 defendant Maffe William   753386 753386 Maffe, William, of Branketre 1
4421178 2171518 2171518 plaintiff Clerk Ralph le   753386 753386 Clerk, Ralph le, of Branketre 0
4421180 2171518 2171518 defendant Lasscher Simon   753386 753386 Lasscher, Simon, of Branketre 0
4448479 2184458 2184458 plaintiff Fratyng Thomas   753386 753386 Fratyng, Thomas, of Branketre, vicar 0
4462471 2188955 2188955 plaintiff Taillour Thomas   753386 753386 Taillour, Thomas, of Branketre 0
4470394 2191389 2191389 defendant Ferrour William   753386 753386 Ferrour, William, of Branketre 0
4501470 2201062 2201062 defendant Naylyngherst Thomas   753386 753386 Naylyngherst, Thomas, of Branketre 0
4502742 2201436 2201436 defendant Spark John turner 753386 753386 Spark, John, of Branketre, turner 0
4505292 2202185 2202185 plaintiff Turnour John   753386 753386 Turnour, John, of Branketre 1
4517581 2205894 2205894 plaintiff Curteys Thomas   753386 753386 Curteys, Thomas, of Branketre 0
4519863 2206563 2206563 defendant Swetyng John   753386 753386 Swetyng, John, of Branketre 0
4523831 2207781 2207781 defendant Smyth John   753386 753386 Smyth, John, of Branketre 7
4539740 2212689 2212689 defendant Chapman Henry   753386 753386 Chapman, Henry, of Branketre 3
4539748 2212690 2212690 defendant Chapman Henry   753386 753386 Chapman, Henry, of Branketre 3
4544572 2214218 2214218 defendant Ferour William   753386 753386 Ferour, William, of Branketre 1
4544575 2214219 2214219 defendant Ferour William   753386 753386 Ferour, William, of Branketre 1
4552425 2216712 2216712 defendant Wylde John baker 753386 753386 Wylde, John, of Branketre, baker 0
4561147 2219446 2219446 defendant Dassh John   753386 753386 Dassh, John, of Branketre 0
4565212 2220694 2220694 plaintiff Skynnere John (legal representative) 753386 753386 Skynnere, John, of Branketre, executors of 0
4574044 2223405 2223405 plaintiff Bedell John   753386 753386 Bedell, John, of Branketre 0
4577281 2224414 2224414 defendant Bocher Thomas   753386 753386 Bocher, Thomas, of Branketre 0
4586144 2227088 2227088 defendant Normandy Robert   753386 753386 Normandy, Robert, of Branketre 3
4588161 2227695 2227695 defendant West John (legal representative) 753386 753386 West, John, of Branketre, executors of 0
4605766 2232918 2232918 defendant Keyntyssh John, sen   753386 753386 Keyntyssh, John, sen, of Branketre 3
4607570 2233476 2233476 defendant Bedell William carter 753386 753386 Bedell, William, of Branketre, carter 2
4609344 2234022 2234022 plaintiff Bryd John   753386 753386 Bryd, John, of Branketre 0
4610650 2234396 2234396 defendant Wilde John   753386 753386 Wilde, John, of Branketre 5
4611669 2234711 2234711 plaintiff Coket Walter draper 753386 753386 Coket, Walter, of Branketre, draper 0
4611671 2234711 2234711 plaintiff Barbour William   753386 753386 Barbour, William, of Branketre 2
4611672 2234711 2234711 defendant Chapman Henry   753386 753386 Chapman, Henry, of Branketre 0
4615308 2235794 2235794 defendant Gateshed alias Spicer John   753386 753386 Gateshed alias Spicer, John, of Branketre 1
4618016 2236643 2236643 defendant Gateshed alias Spicer John   753386 753386 Gateshed alias Spicer, John, of Branketre 1
4618917 2236909 2236909 defendant Barbour William   753386 753386 Barbour, William, of Branketre 0
4618918 2236909 2236909 defendant Corsour Nicholas   753386 753386 Corsour, Nicholas, of Branketre 1
4618920 2236909 2236909 defendant Ferrour John carpenter 753386 753386 Ferrour, John, of Branketre, carpenter 3
4623817 2238425 2238425 plaintiff Mody Adam   753386 753386 Mody, Adam, of Branketre 0
4628008 2239682 2239682 plaintiff Rygewyn Henry chapman 753386 753386 Rygewyn, Henry, of Branketre, chapman 0
4631261 2240672 2240672 defendant Colyn John   753386 753386 Colyn, John, of Branketre 2
4631262 2240672 2240672 defendant Martyn John   753386 753386 Martyn, John, of Branketre 3
4633181 2241247 2241247 defendant Whitchod Edmund butcher 753386 753386 Whitchod, Edmund, of Branketre, butcher 0
4639787 2243141 2243141 defendant Bedell John baker 753386 753386 Bedell, John, of Branketre, baker 0
4643290 2244142 2244142 defendant Spicer John   753386 753386 Spicer, John, of Branketre 6
4648213 2245542 2245542 defendant Corsour Nicholas   753386 753386 Corsour, Nicholas, of Branketre 2
4648258 2245552 2245552 defendant Bedell John baker 753386 753386 Bedell, John, of Branketre, baker 0
4658691 2248591 2248591 defendant Glover Geoffrey glover 753386 753386 Glover, Geoffrey, of Branketre, glover 1
4660941 2249247 2249247 defendant Lynton John yeoman 753386 753386 Lynton, John, of Branketre, yeoman 2
4660943 2249247 2249247 defendant Chaloner Richard chaloner or blanket maker 753386 753386 Chaloner, Richard, of Branketre, chaloner or blanket maker 4
4660945 2249248 2249248 defendant Pryour Stephen ploughman 753386 753386 Pryour, Stephen, of Branketre, ploughman 0
4660948 2249248 2249248 defendant Corsour Nicholas yeoman 753386 753386 Corsour, Nicholas, of Branketre, yeoman 3
4660949 2249248 2249248 defendant Swetyng Joan spinster 753386 753386 Swetyng, Joan, of Branketre, spinster 4
4660950 2249248 2249248 defendant Runton John yeoman 753386 753386 Runton, John, of Branketre, yeoman 5
4663206 2249960 2249960 defendant Brunne Henry fuller 753386 753386 Brunne, Henry, of Branketre, fuller 0
4672506 2257051 2257051 plaintiff Coket Walter (legal representative) 753386 753386 Coket, Walter, of Branketre, draper, executors of 0
4673277 2257283 2257283 defendant Dasshe John fisher 753386 753386 Dasshe, John, of Branketre, fisher 1
4673295 2257287 2257287 defendant Dasshe John fisher 753386 753386 Dasshe, John, of Branketre, fisher 1
4675258 2257873 2257873 defendant Gernon Roger smith 753386 753386 Gernon, Roger, of Branketre, smith 1
4677833 2258682 2258682 defendant Routon Robert husbandman 753386 753386 Routon, Robert, of Branketre, husbandman 3
4677843 2258685 2258685 defendant Hemstede William weaver 753386 753386 Hemstede, William, of Branketre, weaver 3
4678397 2258849 2258849 defendant Flaxer Richard   753386 753386 Flaxer, Richard, of Branketre, administrators of 4
4683731 2260513 2260513 defendant Sprot John husbandman 753386 753386 Sprot, John, of Branketre, husbandman 3
4686475 2261375 2261375 defendant Lynton John husbandman 753386 753386 Lynton, John, of Branketre, husbandman 1
4686495 2261383 2261383 plaintiff smyth John draper 753386 753386 smyth, John, of Branketre, draper 0
4690186 2262486 2262486 defendant Bery John   753386 753386 Bery, John, of Branketre 1
4712838 2269325 2269325 defendant Coket John yeoman 753386 753386 Coket, John, of Branketre, yeoman 2
4717735 2270884 2270884 plaintiff Argeston John mercer 753386 753386 Argeston, John, of Branketre, mercer 0
4721907 2272183 2272183 defendant Smyth Thomas draper 753386 753386 Smyth, Thomas, of Branketre, draper 0
4722451 2272341 2272341 defendant Goce John husbandman 753386 753386 Goce, John, of Branketre, husbandman 0
4734918 2276080 2276080 defendant Bele Thomas smith 753386 753386 Bele, Thomas, of Branketre, smith 1
4737313 2276788 2276788 defendant Bele Thomas smith 753386 753386 Bele, Thomas, of Branketre, smith 0
4747391 2279741 2279741 defendant Curteys Thomas yeoman 753386 753386 Curteys, Thomas, of Branketre, yeoman 0
4751086 2280799 2280799 defendant Hampstede William yeoman 753386 753386 Hampstede, William, of Branketre, yeoman 2
4766735 2285586 2285586 defendant Hempstede Thomas weaver 753386 753386 Hempstede, Thomas, of Branketre, weaver 2
4770392 2286709 2286709 defendant Stokdale John yeoman 753386 753386 Stokdale, John, of Branketre, yeoman 3
4772875 2287487 2287487 defendant Spycer John yeoman 753386 753386 Spycer, John, of Branketre, yeoman 3
4776662 2288692 2288692 defendant Clerk John hosier 753386 753386 Clerk, John, of Branketre, hosier 0
4776664 2288693 2288693 defendant Clerk John hosier 753386 753386 Clerk, John, of Branketre, hosier 0
4796446 2295042 2295042 defendant Belle John carpenter 753386 753386 Belle, John, of Branketre, carpenter 1
4809571 2299160 2299160 defendant Wrasteler John laborer 753386 753386 Wrasteler, John, of Branketre, laborer 0
4813715 2300399 2300399 defendant Argeston John mercer 753386 753386 Argeston, John, of Branketre, mercer 0
4824634 2303754 2303754 defendant Archiston alias Lyntowe John chapman 753386 753386 Archiston alias Lyntowe, John, of Branketre, chapman 0
4824635 2303754 2303754 defendant Bele Thomas smith 753386 753386 Bele, Thomas, of Branketre, smith 1
4824638 2303755 2303755 defendant Archiston alias Lyntowe John chapman 753386 753386 Archiston alias Lyntowe, John, of Branketre, chapman 0
4824639 2303755 2303755 defendant Bele Thomas smith 753386 753386 Bele, Thomas, of Branketre, smith 1
4830853 2305677 2305677 defendant Spicer John yeoman 753386 753386 Spicer, John, of Branketre, yeoman 0
4836002 2307242 2307242 defendant Huerde Thomas husbandman 753386 753386 Huerde, Thomas, of Branketre, husbandman 0
4850593 2311647 2311647 defendant Archiston John chapman 753386 753386 Archiston, John, of Branketre, chapman 0
4850964 2311751 2311751 defendant Curteys John husbandman 753386 753386 Curteys, John, of Branketre, husbandman 4
4851878 2312022 2312022 defendant Smyth John draper 753386 753386 Smyth, John, of Branketre, draper 0
4851880 2312022 2312022 defendant Pacche John weaver 753386 753386 Pacche, John, of Branketre, weaver 2
4852823 2312300 2312300 defendant Curteys Thomas husbandman 753386 753386 Curteys, Thomas, of Branketre, husbandman 0
4853090 2312385 2312385 defendant Lyntowe John mercer 753386 753386 Lyntowe, John, of Branketre, mercer 0
4853091 2312385 2312385 defendant Hall John, sen husbandman 753386 753386 Hall, John, sen, of Branketre, husbandman 1
4870059 2317601 2317601 defendant Curteys Alice widow 753386 753386 Curteys, Alice, of Branketre, widow 4
4878948 2320348 2320348 defendant Curteys John husbandman 753386 753386 Curteys, John, of Branketre, husbandman 4
4903853 2327820 2327820 defendant Spycer John husbandman 753386 753386 Spycer, John, of Branketre, husbandman 0
4904116 2327900 2327900 defendant Halle John husbandman 753386 753386 Halle, John, of Branketre, husbandman 0
4917898 2332112 2332112 defendant Curteys John husbandman 753386 753386 Curteys, John, of Branketre, husbandman 0
4924443 2334083 2334083 plaintiff Norman William draper 753386 753386 Norman, William, of Branketre, draper 0

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