names

224 rows where place_id = 589150

✎ 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
3596697 1866602 1866602 defendant Sleand Richard chapman 589150 589150 Sleand, Richard, of Maldon, essex, chapman 0
3604711 1869136 1869136 defendant Sellys Ralph husbandman 589150 589150 Sellys, Ralph, of Maldon, Essex, husbandman 1
3612812 1871657 1871657 defendant Porter Richard dyer 589150 589150 Porter, Richard, of Maldon, Essex, dyer 0
3612823 1871659 1871659 defendant Porter Richard dyer 589150 589150 Porter, Richard, of Maldon, Essex, dyer 0
3618727 1873479 1873479 defendant Groce Thomas mercer 589150 589150 Groce, Thomas, of Maldon, Essex, mercer 0
3619952 1873815 1873815 defendant Darell Thomas gent 589150 589150 Darell, Thomas, of Maldon, Essex, gent 0
3659450 1913214 1913214 defendant Eley Edward yeoman 589150 589150 Eley, Edward, of Maldon, Essex, yeoman 4
3665719 1915226 1915226 defendant Paiet John yeoman 589150 589150 Paiet, John, of Maldon, Essex, yeoman 0
3675451 1918360 1918360 defendant Gate Thomas tailor 589150 589150 Gate, Thomas, of Maldon, Essex, tailor 3
3701015 1926564 1926564 plaintiff Beynham Richard gent 589150 589150 Beynham, Richard, of Maldon, Essex, gent 0
3702964 1927197 1927197 defendant Some Thomas butcher 589150 589150 Some, Thomas, of Maldon, Essex, butcher 0
3702966 1927198 1927198 defendant Some Thomas butcher 589150 589150 Some, Thomas, of Maldon, Essex, butcher 0
3720848 1932814 1932814 defendant Dawes John merchant 589150 589150 Dawes, John, of Maldon, Essex, merchant 0
3720850 1932815 1932815 defendant Dawes John merchant 589150 589150 Dawes, John, of Maldon, Essex, merchant 0
3736181 1937558 1937558 defendant Snell Hugh chapman 589150 589150 Snell, Hugh, of Maldon, Essex, chapman 0
3747057 1940994 1940994 defendant Clelond Henry yeoman 589150 589150 Clelond, Henry, of Maldon, Essex, yeoman 3
3747860 1941254 1941254 defendant Loughborowe John brewer 589150 589150 Loughborowe, John, of Maldon, Essex, brewer 0
3751961 1942530 1942530 defendant Dowse John merchant 589150 589150 Dowse, John, of Maldon, Essex, merchant 0
3811638 1961538 1961538 defendant Baynham Richard gent 589150 589150 Baynham, Richard, of Maldon, Essex, gent 0
3848059 1972968 1972968 defendant Grene John mariner 589150 589150 Grene, John, of Maldon, Essex, mariner 1
3852873 1974510 1974510 defendant Pytman John mercer 589150 589150 Pytman, John, of Maldon, Essex, mercer 0
3855092 1975224 1975224 defendant Dowse John merchant 589150 589150 Dowse, John, of Maldon, Essex, merchant 0
3898300 1989640 1989640 defendant Grene John yeoman 589150 589150 Grene, John, of Maldon, Essex, yeoman 0
3961406 2011085 2011085 defendant Harrys William esq 589150 589150 Harrys, William, of Maldon, Essex, esq 2
3974972 2015808 2015808 defendant Browynynge William chapman 589150 589150 Browynynge, William, of Maldon, Essex, chapman 1
3980637 2017841 2017841 defendant Coxson Mathew yeoman 589150 589150 Coxson, Mathew, of Maldon, Essex, yeoman 0
3983512 2018877 2018877 plaintiff Sparrowe Anthony yeoman 589150 589150 Sparrowe, Anthony, of Maldon, Essex, yeoman 0
3987893 2020415 2020415 defendant Clarke Thomas clothier 589150 589150 Clarke, Thomas, of Maldon, Essex, clothier 0
3987950 2020436 2020436 defendant Coker Edward eoman 589150 589150 Coker, Edward, of Maldon, Essex, eoman 1
3989033 2020821 2020821 defendant Harrys Vincent esq 589150 589150 Harrys, Vincent, of Maldon, Essex, esq 0
3989035 2020822 2020822 defendant Harrys Vincent esq 589150 589150 Harrys, Vincent, of Maldon, Essex, esq 0
4000656 2025008 2025008 defendant Clerke Thomas gent 589150 589150 Clerke, Thomas, of Maldon, Essex, gent 0
4011002 2028711 2028711 defendant Stayeb John yeoman 589150 589150 Stayeb, John, of Maldon, Essex, yeoman 2
4033986 2036810 2036810 defendant Michelson Andrew mariner 589150 589150 Michelson, Andrew, of Maldon, Essex, mariner 0
4033991 2036811 2036811 defendant Mychelson Andrew mariner 589150 589150 Mychelson, Andrew, of Maldon, Essex, mariner 0
4082114 2053902 2053902 defendant Withers Fabian   589150 589150 Withers, Fabian, of Maldon, Essex, gent, professor of theology 1
4136741 2073489 2073489 defendant Kesford or Kefford Richard butcher 589150 589150 Kesford or Kefford, Richard, of Maldon, Essex, butcher 0
4200855 2095858 2095858 defendant Hornclyff John cordwainer 589150 589150 Hornclyff, John, of Maldon, Essex, cordwainer 0
4201675 2096130 2096130 defendant Syday John yeoman 589150 589150 Syday, John, of Maldon, Essex, yeoman 1
4212578 2099940 2099940 defendant Blackborne John carpenter 589150 589150 Blackborne, John, of Maldon, Essex, carpenter 0
4230215 2106054 2106054 defendant Furnes Thomas merchant 589150 589150 Furnes, Thomas, of Maldon, Essex, merchant 0
4335787 2142245 2142245 defendant Reynes Thomas miller 589150 589150 Reynes, Thomas, of Maldon, Essex, miller 2
4349014 2146918 2146918 defendant Pike Edward merchant 589150 589150 Pike, Edward, of Maldon, Essex, merchant 0
4395006 2162915 2162915 defendant Pyke Edward merchant 589150 589150 Pyke, Edward, of Maldon, Essex, merchant 0
4406990 2166897 2166897 defendant Hynde Richard tailor 589150 589150 Hynde, Richard, of Maldon, Essex, tailor 3
4522843 2207483 2207483 defendant Man Peter (legal representative) 589150 589150 Man, Peter, of Maldon, Essex, executrix of 0
4525072 2208183 2208183 plaintiff Husk David   589150 589150 Husk, David, of Maldon, Essex, formerly vicar 0
4529613 2209542 2209542 defendant Burges John   589150 589150 Burges, John, of Maldon, Essex 0
4566700 2221160 2221160 defendant Burgeys John merchant 589150 589150 Burgeys, John, of Maldon, Essex, merchant 0
4566702 2221161 2221161 defendant Burgeys John merchant 589150 589150 Burgeys, John, of Maldon, Essex, merchant 0
4589546 2228103 2228103 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 3
4589554 2228104 2228104 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 3
4589562 2228105 2228105 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 3
4603204 2232210 2232210 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 0
4604046 2232433 2232433 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 0
4655920 2247731 2247731 plaintiff Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex 0
4656618 2247962 2247962 defendant Benet William chapman 589150 589150 Benet, William, of Maldon, Essex, chapman 3
4656870 2248045 2248045 defendant Burgeys John merchant 589150 589150 Burgeys, John, of Maldon, Essex, merchant 2
4661918 2249574 2249574 defendant Flore John yeoman 589150 589150 Flore, John, of Maldon, Essex, yeoman 2
4661922 2249575 2249575 defendant Flore John yeoman 589150 589150 Flore, John, of Maldon, Essex, yeoman 2
4669312 2256109 2256109 defendant Burgeys John   589150 589150 Burgeys, John, of Maldon, Essex, franklin 1
4669314 2256109 2256109 defendant atte Wode Richard yeoman 589150 589150 atte Wode, Richard, of Maldon, Essex, yeoman 3
4680176 2259408 2259408 defendant Burgeys John husbandman 589150 589150 Burgeys, John, of Maldon, Essex, husbandman 2
4687995 2261814 2261814 defendant Coupere John   589150 589150 Coupere, John, of Maldon, Essex, ---, his wife 1
4699995 2265420 2265420 defendant Darcy Robert gent 589150 589150 (Darcy, Robert, of Maldon, Essex, gent 1
4706695 2267479 2267479 defendant Motte Thomas   589150 589150 Motte, Thomas, of Maldon, Essex, wright 0
4706722 2267487 2267487 defendant Motte Thomas   589150 589150 Motte, Thomas, of Maldon, Essex, wright 0
4707264 2267651 2267651 defendant Lyndesey Roger drover 589150 589150 Lyndesey, Roger, of Maldon, Essex, drover 0
4707269 2267652 2267652 defendant Lyndesey Roger drover 589150 589150 Lyndesey, Roger, of Maldon, Essex, drover 0
4707595 2267736 2267736 defendant Kays William husbandman 589150 589150 Kays, William, of Maldon, Essex, husbandman 1
4709384 2268287 2268287 defendant Fuller Andrew yeoman 589150 589150 Fuller, Andrew, of Maldon, Essex, yeoman 1
4710799 2268733 2268733 defendant Gate Rose   589150 589150 Gate, Rose, of Maldon, Essex, formerly wife of William 2
4711517 2268931 2268931 defendant Burgeys John chapman 589150 589150 Burgeys, John, of Maldon, Essex, chapman 0
4729463 2274427 2274427 defendant Lyndesey Roger husbandman 589150 589150 Lyndesey, Roger, of Maldon, Essex, husbandman 2
4732445 2275321 2275321 defendant Kyng John husbandman 589150 589150 Kyng, John, of Maldon, Essex, husbandman 0
4740846 2277837 2277837 defendant Wynchestre John   589150 589150 Wynchestre, John, of Maldon, Essex, executrix 2
4741186 2277923 2277923 defendant Wynchestre John (legal representative) 589150 589150 Wynchestre, John, of Maldon, Essex, executrix of 2
4741196 2277924 2277924 defendant Wynchestre John (legal representative) 589150 589150 Wynchestre, John, of Maldon, Essex, executrix of 2
4743886 2278741 2278741 defendant Scotte John husbandman 589150 589150 Scotte, John, of Maldon, Essex, husbandman 1
4743893 2278742 2278742 defendant Scotte John husbandman 589150 589150 Scotte, John, of Maldon, Essex, husbandman 1
4749684 2280392 2280392 defendant Ailwyn Andrew fuller 589150 589150 Ailwyn, Andrew, of Maldon, Essex, fuller 0
4749686 2280393 2280393 defendant Ailwyn Andrew fuller 589150 589150 Ailwyn, Andrew, of Maldon, Essex, fuller 0
4760884 2283745 2283745 defendant Scot John husbandman 589150 589150 Scot, John, of Maldon, Essex, husbandman 0
4761787 2284029 2284029 defendant Rydeler Walter husbandman 589150 589150 Rydeler, Walter, of Maldon, Essex, husbandman 0
4769471 2286429 2286429 defendant Ailewyn Andrew fuller 589150 589150 Ailewyn, Andrew, of Maldon, Essex, fuller 0
4790059 2292964 2292964 defendant Bramcote William chapman 589150 589150 Bramcote, William, of Maldon, Essex, chapman 1
4795416 2294721 2294721 defendant Lyndesey Roger courser 589150 589150 Lyndesey, Roger, of Maldon, Essex, courser 2
4798521 2295716 2295716 defendant Coupere John merchant 589150 589150 Coupere, John, of Maldon, Essex, merchant 0
4802874 2297087 2297087 defendant Burgeys John merchant 589150 589150 Burgeys, John, of Maldon, Essex, merchant 0
4825329 2303966 2303966 defendant Baker John maltman 589150 589150 Baker, John, of Maldon, Essex, maltman 0
4830291 2305511 2305511 defendant Bacheler John esq 589150 589150 Bacheler, John, of Maldon, Essex, esq 0
4836917 2307504 2307504 defendant Durdey John shipman 589150 589150 Durdey, John, of Maldon, Essex, shipman 2
4841847 2308983 2308983 plaintiff Kynge Richard   589150 589150 Kynge, Richard, of Maldon, Essex 0
4864192 2315777 2315777 defendant Durdey John shipman 589150 589150 Durdey, John, of Maldon, Essex, shipman 2
4866616 2316520 2316520 defendant Bacheler John gent 589150 589150 Bacheler, John, of Maldon, Essex, gent 0
4876264 2319537 2319537 defendant Hoberd Thomas chapman 589150 589150 Hoberd, Thomas, of Maldon, Essex, chapman 0
4881965 2321258 2321258 defendant Smyth John shipman 589150 589150 Smyth, John, of Maldon, Essex, shipman 1
4884231 2321976 2321976 defendant Westcote Thomas   589150 589150 Westcote, Thomas, of Maldon, Essex, mason 1
4916992 2331820 2331820 defendant Snape John butcher 589150 589150 Snape, John, of Maldon, Essex, butcher 2
4916998 2331821 2331821 defendant Snape John butcher 589150 589150 Snape, John, of Maldon, Essex, butcher 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);