names

174 rows where place_id = 586179

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588093 1863925 1863925 defendant Gytton Richard innholder 586179 586179 Gytton, Richard, of Croydon, Surrey, innholder 0
3592096 1865143 1865143 defendant Hegons John clerk 586179 586179 Hegons, John, of Croydon, Surrey, clerk 0
3594167 1865818 1865818 defendant Middelton Richard innholder 586179 586179 Middelton, Richard, of Croydon, Surrey, innholder 0
3600632 1867845 1867845 defendant Lincolne William innholder 586179 586179 Lincolne, William, of Croydon, Surrey, innholder 3
3603156 1868651 1868651 defendant Mapulton John collier 586179 586179 Mapulton, John, of Croydon, Surrey, collier 4
3608358 1870273 1870273 defendant Palmer Hugh tailor 586179 586179 Palmer, Hugh, of Croydon, Surrey, tailor 0
3631539 1904680 1904680 defendant Hampsher Thomas glover 586179 586179 Hampsher, Thomas, of Croydon, Surrey, glover 1
3632774 1905064 1905064 defendant Morton Robert   586179 586179 Morton, Robert, of Croydon, Surrey, knight 0
3639427 1907139 1907139 defendant Bowmer Nicholas husbandman 586179 586179 Bowmer, Nicholas, of Croydon, Surrey, husbandman 3
3639432 1907140 1907140 defendant Bowmer Nicholas husbandman 586179 586179 Bowmer, Nicholas, of Croydon, Surrey, husbandman 3
3641686 1907857 1907857 defendant Elys John clothier 586179 586179 Elys, John, of Croydon, Surrey, clothier 0
3644625 1908730 1908730 defendant Parker William yeoman 586179 586179 Parker, William, of Croydon, Surrey, yeoman 1
3645022 1908851 1908851 defendant Parker William yeoman 586179 586179 Parker, William, of Croydon, Surrey, yeoman 0
3669905 1916532 1916532 defendant Wattes John yeoman 586179 586179 Wattes, John, of Croydon, Surrey, yeoman 1
3670672 1916792 1916792 defendant Wattes John yeoman 586179 586179 Wattes, John, of Croydon, Surrey, yeoman 1
3696945 1925267 1925267 defendant Snowe Wiklliam butcher 586179 586179 Snowe, Wiklliam, of Croydon, Surrey, butcher 0
3697383 1925400 1925400 defendant Benskyn John   586179 586179 Benskyn, John, of Croydon, Surrey, wheelwright 3
3714471 1930821 1930821 defendant Brand John shoemaker 586179 586179 Brand, John, of Croydon, Surrey, shoemaker 1
3728932 1935295 1935295 defendant Broun Mathew   586179 586179 Broun, Mathew, of Croydon, Surrey, knight 1
3731144 1935965 1935965 defendant Warr John yeoman 586179 586179 Warr, John, of Croydon, Surrey, yeoman 0
3736912 1937797 1937797 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 2
3741388 1939174 1939174 defendant Teder John innholder 586179 586179 Teder, John, of Croydon, Surrey, innholder 0
3749870 1941873 1941873 defendant Benskyn John   586179 586179 Benskyn, John, of Croydon, Surrey, wheelwright 1
3754080 1943221 1943221 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 0
3758361 1944610 1944610 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 0
3758365 1944611 1944611 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 0
3766551 1947197 1947197 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 0
3768933 1947935 1947935 defendant Heron Thomas gent 586179 586179 Heron, Thomas, of Croydon, Surrey, gent 0
3772623 1949130 1949130 defendant Warham Hugh esq 586179 586179 Warham, Hugh, of Croydon, Surrey, esq 1
3772637 1949134 1949134 defendant Warham Hugh esq 586179 586179 Warham, Hugh, of Croydon, Surrey, esq 1
3791102 1955051 1955051 defendant Davy Thomas butcher 586179 586179 Davy, Thomas, of Croydon, Surrey, butcher 0
3791189 1955077 1955077 defendant Davy Thomas butcher 586179 586179 Davy, Thomas, of Croydon, Surrey, butcher 0
3847063 1972632 1972632 defendant Wynder Thomas draper 586179 586179 Wynder, Thomas, of Croydon, Surrey, draper 0
3848806 1973212 1973212 defendant Heron Thomas esq 586179 586179 Heron, Thomas, of Croydon, Surrey, esq 0
3979347 2017362 2017362 defendant Weller EdWard yeoman 586179 586179 Weller, EdWard, of Croydon, Surrey, yeoman 3
3999800 2024690 2024690 defendant Tyson John   586179 586179 Tyson, John, of Croydon, Surrey, gent, mayor and aldermen of London ex parte 0
4015259 2030150 2030150 defendant Pygott Robert brewer 586179 586179 Pygott, Robert, of Croydon, Surrey, brewer 1
4015453 2030223 2030223 defendant Pygott Robert brewer 586179 586179 Pygott, Robert, of Croydon, Surrey, brewer 2
4019869 2031838 2031838 defendant Talbott John gent 586179 586179 Talbott, John, of Croydon, Surrey, gent 2
4019873 2031839 2031839 defendant Talbott John gent 586179 586179 Talbott, John, of Croydon, Surrey, gent 2
4031813 2036040 2036040 defendant Hatcher John (legal representative) 586179 586179 Hatcher, John, of Croydon, Surrey, yeoman, executors of 1
4049918 2042402 2042402 plaintiff Walker Edward yeoman 586179 586179 Walker, Edward, of Croydon, Surrey, yeoman 0
4050743 2042702 2042702 plaintiff Weller Edward yeoman 586179 586179 Weller, Edward, of Croydon, Surrey, yeoman 0
4080912 2053488 2053488 plaintiff Weller Edward gent 586179 586179 Weller, Edward, of Croydon, Surrey, gent 0
4081826 2053803 2053803 defendant Dawse Mathew yeoman 586179 586179 Dawse, Mathew, of Croydon, Surrey, yeoman 0
4095104 2058578 2058578 defendant Bowdon Henry tailor 586179 586179 Bowdon, Henry, of Croydon, Surrey, tailor 1
4097288 2059349 2059349 defendant Dawes Mathew husbandman 586179 586179 Dawes, Mathew, of Croydon, Surrey, husbandman 2
4154069 2079517 2079517 defendant Dannett John esq 586179 586179 Dannett, John, of Croydon, Surrey, esq 0
4179584 2088335 2088335 defendant Boydon John yeoman 586179 586179 Boydon, John, of Croydon, Surrey, yeoman 1
4197656 2094737 2094737 defendant Heron Poyning gent 586179 586179 Heron, Poyning, of Croydon, Surrey, gent 0
4208611 2098561 2098561 defendant Browne William cordwainer 586179 586179 Browne, William, of Croydon, Surrey, yeoman, or of Readinge, Berks, cordwainer 0
4212892 2100040 2100040 defendant Wyther- George gent 586179 586179 Wyther-, George, of Croydon, Surrey, gent 1
4235686 2108049 2108049 defendant Hollydaye John yeoman 586179 586179 Hollydaye, John, of Croydon, Surrey, yeoman 0
4289417 2126273 2126273 defendant Cookson Francis tailor 586179 586179 Cookson, Francis, of Croydon, Surrey, tailor 0
4298053 2129407 2129407 defendant Chittey Edward glover 586179 586179 Chittey, Edward, of Croydon, Surrey, glover 0
4302928 2131147 2131147 defendant Curtis William yeoman 586179 586179 Curtis, William, of Croydon, Surrey, yeoman 0
4325229 2138817 2138817 defendant Mace alias Tyler George innholder 586179 586179 Mace alias Tyler, George, of Croydon, Surrey, innholder 0
4357983 2150034 2150034 defendant Bucksted Valentine chapman 586179 586179 Bucksted, Valentine, of Croydon, Surrey, chapman 2
4382376 2158806 2158806 defendant Bucksead Valentine chapman 586179 586179 Bucksead, Valentine, of Croydon, Surrey, chapman 2
4414022 2169287 2169287 defendant Hattere John le timber monger 586179 586179 Hattere, John le, of Croydon, Surrey, timber monger 0
4421059 2171478 2171478 defendant Hattere John le timber monger 586179 586179 Hattere, John le, of Croydon, Surrey, timber monger 0
4530064 2209692 2209692 defendant Bocher Adam   586179 586179 Bocher, Adam, of Croydon, Surrey 0
4612937 2235107 2235107 defendant Hill John   586179 586179 Hill, John, of Croydon, Surrey 0
4627875 2239648 2239648 defendant Dodch Robert   586179 586179 Dodch, Robert, of Croydon, Surrey 1
4651735 2246508 2246508 defendant Jay Thomas husbandman 586179 586179 Jay, Thomas, of Croydon, Surrey, husbandman 14
4698185 2264918 2264918 defendant More William   586179 586179 More, William, of Croydon, Surrey, tile maker 0
4703131 2266356 2266356 defendant Spycer John husbandman 586179 586179 Spycer, John, of Croydon, Surrey, husbandman 0
4769529 2286449 2286449 defendant Bray John gent 586179 586179 Bray, John, of Croydon, Surrey, gent 3
4780205 2289806 2289806 defendant Sal- John carpenter 586179 586179 together with Sal-, John, of Croydon, Surrey, carpenter 3
4785661 2291544 2291544 defendant Carne or Carve Nicholas, junior esq 586179 586179 Carne or Carve, Nicholas, junior, of Croydon, Surrey, esq 0
4789606 2292821 2292821 defendant Knyght John   586179 586179 Knyght, John, of Croydon, Surrey, tile maker 0
4789617 2292823 2292823 defendant Knyght John   586179 586179 Knyght, John, of Croydon, Surrey, tile maker 0
4836482 2307389 2307389 defendant Wayte Stephen husbandman 586179 586179 Wayte, Stephen, of Croydon, Surrey, husbandman 0
4857420 2313708 2313708 defendant Hiller Thomas chadnler 586179 586179 Hiller, Thomas, of Croydon, Surrey, chadnler 3
4858327 2313977 2313977 defendant Purdeaux John rypyer or fishminger 586179 586179 Purdeaux, John, of Croydon, Surrey, rypyer or fishminger 0
4867545 2316819 2316819 plaintiff Hogge Hugh baker 586179 586179 Hogge, Hugh, of Croydon, Surrey, baker 0
4947895 2341325 2341325 defendant Ukfelde John husbandman 586179 586179 Ukfelde, John, of Croydon, Surrey, husbandman 0
4950575 2342142 2342142 defendant Edward John shoemaker 586179 586179 Edward, John, of Croydon, Surrey, shoemaker 2
4950580 2342143 2342143 defendant Edward John shoemaker 586179 586179 Edward, John, of Croydon, Surrey, shoemaker 2
4987513 2353222 2353222 defendant Esgar Thomas yeoman 586179 586179 Esgar, Thomas, of Croydon, Surrey, yeoman 3
4991605 2354371 2354371 defendant Dokell Richard husbandman 586179 586179 Dokell, Richard, of Croydon, Surrey, husbandman 1
5006210 2358708 2358708 defendant (illegible) Walter, sen husbandman 586179 586179 _, Walter, sen, of Croydon, Surrey, husbandman 0
5018304 2362238 2362238 defendant Dukhill Richard yeoman 586179 586179 Dukhill, Richard, of Croydon, Surrey, yeoman 1
5055270 2373161 2373161 defendant Schirle Reginald husbandman 586179 586179 Schirle, Reginald, of Croydon, Surrey, husbandman 0
5055272 2373162 2373162 defendant Schirle Reginald husbandman 586179 586179 Schirle, Reginald, of Croydon, Surrey, husbandman 0
5055276 2373164 2373164 defendant Snelle or Suelle John husbandman 586179 586179 Snelle or Suelle, John, of Croydon, Surrey, husbandman 0
5055279 2373165 2373165 defendant Snelle or Suelle John husbandman 586179 586179 Snelle or Suelle, John, of Croydon, Surrey, husbandman 0
5064967 2376056 2376056 defendant Prynce William gent 586179 586179 Prynce, William, of Croydon, Surrey, gent 3
5064974 2376057 2376057 defendant Prynce William gent 586179 586179 Prynce, William, of Croydon, Surrey, gent 2
5070372 2377631 2377631 defendant Vernon John gent 586179 586179 (Vernon, John, of Croydon, Surrey, gent 1
5072407 2378235 2378235 defendant Jenyn James gent 586179 586179 Jenyn, James, of Croydon, Surrey, gent 0
5078811 2380150 2380150 defendant Snypston Anne widow 586179 586179 (Snypston, Anne, of Croydon, Surrey, widow 1
5081796 2381053 2381053 defendant Prynce William husbandman 586179 586179 Prynce, William, of Croydon, Surrey, husbandman 0
5081802 2381054 2381054 defendant Prynce William husbandman 586179 586179 Prynce, William, of Croydon, Surrey, husbandman 0
5094871 2384916 2384916 defendant Piers Walter, junior yeoman 586179 586179 Piers, Walter, junior, of Croydon, Surrey, yeoman 1
5097881 2385808 2385808 defendant Prynce William husbandman 586179 586179 Prynce, William, of Croydon, Surrey, husbandman 0
5104247 2387665 2387665 defendant Shyrley John husbandman 586179 586179 Shyrley, John, of Croydon, Surrey, husbandman 0
5105278 2387986 2387986 defendant Hall Robert carpenter 586179 586179 Hall, Robert, of Croydon, Surrey, carpenter 0
5123699 2393390 2393390 defendant Shirley Reginald yeoman 586179 586179 Shirley, Reginald, of Croydon, Surrey, yeoman 1
5143757 2399306 2399306 defendant Croucher John butcher 586179 586179 Croucher, John, of Croydon, Surrey, butcher 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);