names

163 rows where place_id = 586058

✎ 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
3587827 1863839 1863839 defendant Goderd Thomas maltman 586058 586058 Goderd, Thomas, of Enfeld, Middx, maltman 0
3590787 1864757 1864757 defendant Barley William maltman 586058 586058 Barley, William, of Enfeld, Middx, maltman 0
3590789 1864758 1864758 defendant Barley William maltman 586058 586058 Barley, William, of Enfeld, Middx, maltman 0
3603826 1868869 1868869 defendant Wybarn Nicholas brewer 586058 586058 Wybarn, Nicholas, of Enfeld, Middx, brewer 0
3604533 1869083 1869083 defendant Westowe Andrew smith 586058 586058 Westowe, Andrew, of Enfeld, Middx, smith 0
3618730 1873480 1873480 defendant More Thomas, junior tailor 586058 586058 More, Thomas, junior, of Enfeld, Middx, tailor 1
3621136 1874162 1874162 defendant Selby John yeoman 586058 586058 Selby, John, of Enfeld, Middx, yeoman 19
3623243 1874798 1874798 defendant Okeborn William husbandman 586058 586058 Okeborn, William, of Enfeld, Middx, husbandman 0
3631502 1904667 1904667 defendant Mayneburgh alias Sarwe William gent 586058 586058 Mayneburgh alias Sarwe, William, of Enfeld, Middx, gent 0
3637422 1906509 1906509 defendant Ase William maltman 586058 586058 Ase, William, of Enfeld, Middx, maltman 1
3657130 1912494 1912494 defendant Keld alias Roger Thomas gent 586058 586058 Keld alias Roger, Thomas, of Enfeld, Middx, gent 0
3657139 1912497 1912497 defendant Kyrby William gent 586058 586058 Kyrby, William, of Enfeld, Middx, gent 0
3687892 1922375 1922375 defendant Sexten Thomas laborer 586058 586058 Sexten, Thomas, of Enfeld, Middx, laborer 0
3688293 1922484 1922484 defendant Westbery William (legal representative) 586058 586058 Westbery, William, of Enfeld, Middx, maltman, executors of 0
3701592 1926746 1926746 defendant Wrothe Robert gent 586058 586058 Wrothe, Robert, of Enfeld, Middx, gent 1
3703253 1927288 1927288 defendant Ace William maltman 586058 586058 Ace, William, of Enfeld, Middx, maltman 1
3706360 1928279 1928279 defendant Foster William maltman 586058 586058 Foster, William, of Enfeld, Middx, maltman 0
3733086 1936572 1936572 defendant Craster Edmund gent 586058 586058 Craster, Edmund, of Enfeld, Middx, gent 0
3736536 1937677 1937677 defendant Lovell Francis esq 586058 586058 Lovell, Francis, of Enfeld, Middx, esq 2
3760735 1945358 1945358 defendant Crafter or Craster Edmund gent 586058 586058 Crafter or Craster, Edmund, of Enfeld, Middx, gent 0
3762152 1945806 1945806 defendant Calles John maltman 586058 586058 Calles, John, of Enfeld, Middx, maltman 0
3762829 1946011 1946011 defendant Foxley Lawrence   586058 586058 Foxley, Lawrence, of Enfeld, Middx, gent, servant of Lovell, Thomas, senior, knight 2
3778019 1950836 1950836 defendant Hunysden Thomas maltman 586058 586058 Hunysden, Thomas, of Enfeld, Middx, maltman 1
3798804 1957540 1957540 defendant Walles Robert gent 586058 586058 Walles, Robert, of Enfeld, Middx, gent 0
3801032 1958237 1958237 defendant Cordell Thomas maltman 586058 586058 Cordell, Thomas, of Enfeld, Middx, maltman 0
3808285 1960465 1960465 defendant Wright William smith 586058 586058 Wright, William, of Enfeld, Middx, smith 2
3847715 1972856 1972856 defendant Hogge William maltman 586058 586058 Hogge, William, of Enfeld, Middx, maltman 2
3847883 1972915 1972915 defendant Spencer Thomas maltman 586058 586058 Spencer, Thomas, of Enfeld, Middx, maltman 0
3863871 1978091 1978091 defendant Bewall Thomas smith 586058 586058 Bewall, Thomas, of Enfeld, Middx, smith 2
3879207 1983300 1983300 defendant Lewes Richard laborer 586058 586058 Lewes, Richard, of Enfeld, Middx, laborer 0
3880418 1983706 1983706 defendant Forest Roger yeoman 586058 586058 Forest, Roger, of Enfeld, Middx, yeoman 2
3953101 2008151 2008151 defendant Helder Christopher yeoman 586058 586058 Helder, Christopher, of Enfeld, Middx, yeoman 0
3959985 2010591 2010591 defendant Saer William maltman 586058 586058 Saer, William, of Enfeld, Middx, maltman 1
3963237 2011746 2011746 plaintiff Wylkynson Agnes widow 586058 586058 Wylkynson, Agnes, of Enfeld, Middx, widow 1
3977162 2016582 2016582 defendant Tyllysley James yeoman 586058 586058 Tyllysley, James, of Enfeld, Middx, yeoman 0
3987796 2020380 2020380 defendant Hodge John yeoman 586058 586058 Hodge, John, of Enfeld, Middx, yeoman 0
4044834 2040603 2040603 defendant Westbury Richard yeoman 586058 586058 Westbury, Richard, of Enfeld, Middx, yeoman 0
4044840 2040605 2040605 defendant Westbury Richard yeoman 586058 586058 Westbury, Richard, of Enfeld, Middx, yeoman 0
4192336 2092877 2092877 defendant Wroth Robert esq 586058 586058 Wroth, Robert, of Enfeld, Middx, esq 1
4265555 2118119 2118119 defendant Daynes alias Harringford John maltman 586058 586058 Daynes alias Harringford, John, of Enfeld, Middx, maltman 1
4532862 2210546 2210546 defendant Ryngyll Robert   586058 586058 Ryngyll, Robert, of Enfeld, Middx 5
4593730 2229312 2229312 defendant Elys John   586058 586058 Elys, John, of Enfeld, Middx 0
4656120 2247794 2247794 defendant Crouche John butcher 586058 586058 Crouche, John, of Enfeld, Middx, butcher 1
4656874 2248046 2248046 defendant Nicholas William maltman 586058 586058 Nicholas, William, of Enfeld, Middx, maltman 0
4676194 2258166 2258166 defendant Wroth John esq 586058 586058 Wroth, John, of Enfeld, Middx, esq 2
4852056 2312073 2312073 defendant Malton Thomas gent 586058 586058 Malton, Thomas, of Enfeld, Middx, gent 4
4855871 2313209 2313209 defendant Westbury William smith 586058 586058 Westbury, William, of Enfeld, Middx, smith 0
4860769 2314729 2314729 defendant Howe Thomas husbandman 586058 586058 Howe, Thomas, of Enfeld, Middx, husbandman 2
4860784 2314732 2314732 defendant Howe Thomas husbandman 586058 586058 Howe, Thomas, of Enfeld, Middx, husbandman 4
4865521 2316180 2316180 defendant Malton Thomas esq 586058 586058 Malton, Thomas, of Enfeld, Middx, esq 0
4865524 2316181 2316181 defendant Malton Thomas esq 586058 586058 Malton, Thomas, of Enfeld, Middx, esq 0
4883635 2321795 2321795 defendant Gerveys John loader 586058 586058 Gerveys, John, of Enfeld, Middx, loader 3
4884310 2321999 2321999 defendant Orpyn John maltman 586058 586058 Orpyn, John, of Enfeld, Middx, maltman 1
4889816 2323605 2323605 defendant Gerveys John loader 586058 586058 Gerveys, John, of Enfeld, Middx, loader 3
4895116 2325134 2325134 defendant Westbury William smith 586058 586058 Westbury, William, of Enfeld, Middx, smith 1
4913422 2330697 2330697 defendant Howe Thomas yeoman 586058 586058 Howe, Thomas, of Enfeld, Middx, yeoman 0
4914115 2330926 2330926 defendant Godard William maltman 586058 586058 Godard, William, of Enfeld, Middx, maltman 2
4917616 2332024 2332024 defendant Forde William butcher 586058 586058 Forde, William, of Enfeld, Middx, butcher 0
4919912 2332737 2332737 defendant Mordemore John gent 586058 586058 Mordemore, John, of Enfeld, Middx, gent 0
4971384 2348369 2348369 defendant Hundesden John maltman 586058 586058 Hundesden, John, of Enfeld, Middx, maltman 2
4971389 2348370 2348370 defendant Hundesdon John maltman 586058 586058 Hundesdon, John, of Enfeld, Middx, maltman 2
4976924 2350052 2350052 defendant Hogyn Edmund maltman 586058 586058 Hogyn, Edmund, of Enfeld, Middx, maltman 0
4984817 2352390 2352390 defendant Mayhewe Robert tanner 586058 586058 Mayhewe, Robert, of Enfeld, Middx, tanner 0
5000642 2357059 2357059 defendant Mordemore John gent 586058 586058 Mordemore, John, of Enfeld, Middx, gent 0
5009127 2359552 2359552 defendant Wroth William gent 586058 586058 Wroth, William, of Enfeld, Middx, gent 0
5016499 2361717 2361717 defendant Wrothe John esq 586058 586058 Wrothe, John, of Enfeld, Middx, esq 2
5016505 2361719 2361719 defendant Wrothe John esq 586058 586058 Wrothe, John, of Enfeld, Middx, esq 1
5038791 2368247 2368247 defendant Hoigges Thomas maltman 586058 586058 Hoigges, Thomas, of Enfeld, Middx, maltman 0
5038806 2368250 2368250 defendant Hoigges Thomas maltman 586058 586058 Hoigges, Thomas, of Enfeld, Middx, maltman 2
5054092 2372818 2372818 defendant Berley John maltman 586058 586058 Berley, John, of Enfeld, Middx, maltman 0
5058478 2374088 2374088 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5061891 2375151 2375151 defendant Berley John maltman 586058 586058 Berley, John, of Enfeld, Middx, maltman 0
5070709 2377734 2377734 defendant Gorewode Thomas   586058 586058 Gorewode, Thomas, of Enfeld, Middx 2
5075239 2379086 2379086 defendant Smyth John laborer 586058 586058 Smyth, John, of Enfeld, Middx, laborer 1
5076093 2379349 2379349 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5079419 2380341 2380341 defendant Bodvyle Richard merchant or maltman 586058 586058 Bodvyle, Richard, of Enfeld, Middx, merchant or maltman 0
5081686 2381028 2381028 defendant Bourne Johmn malrman 586058 586058 Bourne, Johmn, of Enfeld, Middx, malrman 0
5090406 2383575 2383575 defendant Bodoyle Richard maltman 586058 586058 Bodoyle, Richard,of Enfeld, Middx, maltman 0
5091225 2383833 2383833 defendant Brightmere John husbandman 586058 586058 Brightmere, John, of Enfeld, Middx, husbandman 3
5099122 2386169 2386169 defendant Turner Thomas maltman 586058 586058 Turner, Thomas, of Enfeld, Middx, maltman 7
5101390 2386819 2386819 defendant Goodar of the Guttyr William, junior brewer 586058 586058 Goodar of the Guttyr, William, junior, of Enfeld, Middx, brewer 0
5108756 2388997 2388997 defendant Sharp William maltman 586058 586058 Sharp, William, of Enfeld, Middx, maltman 2
5115558 2390977 2390977 defendant Brightmere John, senior husbandman 586058 586058 Brightmere, John, senior, of Enfeld, Middx, husbandman 2
5121463 2392710 2392710 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5121465 2392711 2392711 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5125231 2393857 2393857 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5132642 2396043 2396043 defendant Godard William brewer 586058 586058 Godard, William, of Enfeld, Middx, brewer 3
5135398 2396860 2396860 defendant Barler John   586058 586058 Barler, John, of Enfeld, Middx, malt man 1
5140221 2398239 2398239 defendant Brytemore William   586058 586058 Brytemore, William, of Enfeld, Middx, malt man 2
5143829 2399330 2399330 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5143831 2399331 2399331 defendant Bodevyle Richard maltman 586058 586058 Bodevyle, Richard, of Enfeld, Middx, maltman 0
5147768 2400489 2400489 defendant Wroth John esq 586058 586058 Wroth, John, of Enfeld, Middx, esq 0
5149551 2400997 2400997 defendant Wrothe John esq 586058 586058 Wrothe, John, of Enfeld, Middx, esq 2
5152465 2401855 2401855 defendant Godard William brewer 586058 586058 Godard, William, of Enfeld, Middx, brewer 1
5160523 2404168 2404168 defendant Bryghtmare John maltman 586058 586058 Bryghtmare, John, of Enfeld, Middx, maltman 4
5161300 2404399 2404399 defendant Brytemore William maltman 586058 586058 Brytemore, William, of Enfeld, Middx, maltman 2
5167318 2406175 2406175 defendant Wroth John esq 586058 586058 Wroth, John, of Enfeld, Middx, esq 0
5167320 2406176 2406176 defendant Wroth John esq 586058 586058 Wroth, John, of Enfeld, Middx, esq 0
5172180 2407585 2407585 defendant Barle John maltman 586058 586058 Barle, John, of Enfeld, Middx, maltman 1
5181689 2410385 2410385 defendant Wrothe John esq 586058 586058 Wrothe, John, of Enfeld, Middx, esq, son & heir of William Wrothe, sen, esq 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);