names

219 rows where place_id = 586111

✎ 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
3587965 1863890 1863890 plaintiff Baker John   586111 586111 Baker, John, of Lamport 0
3589474 1864343 1864343 defendant Spencer William tanner 586111 586111 Spencer, William, of Lamport Estover, tanner 8
3589475 1864343 1864343 defendant Hyndon John dyer 586111 586111 Hyndon, John, of Lamport Estover, dyer 9
3601430 1868107 1868107 plaintiff Baker John   586111 586111 Baker, John, of Lamport 0
3601432 1868108 1868108 plaintiff Baker John   586111 586111 Baker, John, of Lamport 0
3601434 1868109 1868109 plaintiff Baker John   586111 586111 Baker, John, of Lamport 0
3603543 1868777 1868777 defendant Portyngale John dyer 586111 586111 Portyngale, John, of Lamport, dyer 1
3623110 1874750 1874750 defendant Smyth alias Glover Richard smith 586111 586111 Smyth alias Glover, Richard, of Lamport, smith 0
3640123 1907356 1907356 defendant Myddell Thomas smith 586111 586111 Myddell, Thomas, of Lamport, smith 1
3646030 1909155 1909155 defendant Bele Thomas yeoman 586111 586111 Bele, Thomas, of Lamport, yeoman 0
3646032 1909156 1909156 defendant Bele Thomas yeoman 586111 586111 Bele, Thomas, of Lamport, yeoman 0
3671089 1916924 1916924 defendant Bowyes Alice widow 586111 586111 Bowyes, Alice, of Lamport Estover, widow 7
3706250 1928242 1928242 defendant Dyar Richard innholder 586111 586111 Dyar, Richard, of Lamport, innholder 3
3733884 1936845 1936845 defendant Belsher Robert yeoman 586111 586111 Belsher, Robert, of Lamport, yeoman 1
3761658 1945658 1945658 defendant Belther Robert yeoman 586111 586111 Belther, Robert, of Lamport, yeoman 2
3780385 1951599 1951599 defendant Spencer Richard yeoman 586111 586111 Spencer, Richard, of Lamport, yeoman 0
3781301 1951892 1951892 defendant Spencer Richard yeoman 586111 586111 Spencer, Richard, of Lamport Estover, yeoman 2
3843146 1971382 1971382 defendant Borne John gent 586111 586111 Borne, John, of Lamport, gent 0
3883212 1984646 1984646 defendant Cole John husbandman 586111 586111 Cole, John, of Lamport, husbandman 0
3904962 1991921 1991921 defendant Spencer Richard husbandman 586111 586111 Spencer, Richard, of Lamport, husbandman 1
3911099 1994039 1994039 defendant Wytcombe William gent 586111 586111 Wytcombe, William, of Lamport, gent 0
3980791 2017892 2017892 defendant Rede Agnes widow 586111 586111 Rede, Agnes, of Lamport, widow 2
4067363 2048632 2048632 plaintiff Isham John esq 586111 586111 Isham, John, of Lamport, esq 0
4067366 2048633 2048633 plaintiff Isham John esq 586111 586111 Isham, John, of Lamport, esq 0
4087425 2055796 2055796 defendant Rede Thomas tanner 586111 586111 Rede, Thomas, of Lamport, tanner 0
4140012 2074673 2074673 defendant Boyes Richard pewterer 586111 586111 Boyes, Richard, of Lamport, pewterer 0
4152986 2079149 2079149 defendant Walse Walter fuller 586111 586111 Walse, Walter, of Lamport, fuller 3
4441197 2182176 2182176 defendant Raybon Richard   586111 586111 Raybon, Richard, of Lamport 0
4444167 2183153 2183153 defendant Craft Thomas   586111 586111 Craft, Thomas, of Lamport 1
4445453 2183532 2183532 defendant Goldsmyth Edward   586111 586111 Goldsmyth, Edward, of Lamport 0
4465874 2189992 2189992 defendant Webbe Robert   586111 586111 Webbe, Robert, of Lamport 0
4465875 2189992 2189992 defendant Chapman Adam   586111 586111 Chapman, Adam, of Lamport 1
4475831 2193111 2193111 defendant Goldsmyth Hugh   586111 586111 Goldsmyth, Hugh, of Lamport 0
4476329 2193260 2193260 defendant Craft Thomas   586111 586111 Craft, Thomas, of Lamport 1
4477025 2193475 2193475 defendant Elys John   586111 586111 Elys, John, of Lamport 0
4477026 2193475 2193475 defendant Somer John   586111 586111 Somer, John, of Lamport, son of Thomas Somer 1
4478003 2193788 2193788 defendant Goldsmyth Edward   586111 586111 Goldsmyth, Edward, of Lamport 0
4479753 2194330 2194330 defendant Fyssher John   586111 586111 Fyssher, John, of Lamport 0
4480598 2194602 2194602 defendant Dyere James   586111 586111 Dyere, James, of Lamport 0
4488711 2197194 2197194 defendant Bocher Thomas   586111 586111 Bocher, Thomas, of Lamport 0
4504489 2201963 2201963 defendant Elys John   586111 586111 Elys, John, of Lamport 0
4513718 2204719 2204719 defendant Dynge John   586111 586111 Dynge, John, of Lamport 0
4513792 2204740 2204740 defendant Grey William   586111 586111 Grey, William, of Lamport 0
4518541 2206172 2206172 defendant Grey William   586111 586111 Grey, William, of Lamport 2
4524841 2208109 2208109 defendant Bakere Thomas   586111 586111 Bakere, Thomas, of Lamport 1
4529076 2209367 2209367 defendant Craft Robert   586111 586111 Craft, Robert, of Lamport 0
4529077 2209367 2209367 defendant Baker John butcher 586111 586111 Baker, John, of Lamport, butcher 1
4529376 2209475 2209475 defendant Elys John   586111 586111 Elys, John, of Lamport 0
4543405 2213826 2213826 defendant Tannere Thomas   586111 586111 Tannere, Thomas, of Lamport 0
4549263 2215707 2215707 plaintiff Combe John   586111 586111 Combe, John, of Lamport 0
4556311 2217915 2217915 defendant Forde Andrew   586111 586111 Forde, Andrew, of Lamport 0
4558970 2218767 2218767 defendant Camlys John   586111 586111 Camlys, John, of Lamport 5
4558986 2218770 2218770 defendant combys John   586111 586111 combys, John, of Lamport 4
4558992 2218771 2218771 defendant Combys John   586111 586111 Combys, John, of Lamport 4
4562872 2219950 2219950 defendant Ferour Henry   586111 586111 Ferour, Henry, of Lamport 2
4582702 2226032 2226032 plaintiff Fayrewyte John   586111 586111 Fayrewyte, John, of Lamport 0
4582708 2226033 2226033 plaintiff Fayrewyte John   586111 586111 Fayrewyte, John, of Lamport 0
4602765 2232080 2232080 defendant Gryme John   586111 586111 Gryme, John, of Lamport 0
4609839 2234171 2234171 defendant Bryt Thomas   586111 586111 Bryt, Thomas, of Lamport 0
4612512 2234981 2234981 plaintiff Courtenay John   586111 586111 Courtenay, John, of Lamport 0
4614511 2235545 2235545 defendant Halperton Philip   586111 586111 Halperton, Philip, of Lamport 1
4615233 2235774 2235774 defendant Wilkyns John dyer 586111 586111 Wilkyns, John, of Lamport, dyer 2
4621109 2237583 2237583 defendant Davy John   586111 586111 Davy, John, of Lamport 4
4622323 2237961 2237961 defendant Cook Thomas   586111 586111 Cook, Thomas, of Lamport 0
4627701 2239594 2239594 defendant Bakere John dyer 586111 586111 Bakere, John, of Lamport, dyer 0
4638165 2242703 2242703 plaintiff Byne John   586111 586111 Byne, John, of Lamport 0
4641036 2243470 2243470 defendant Davy alias Dawe John   586111 586111 Davy alias Dawe, John, of Lamport 2
4647148 2245218 2245218 defendant Comes John   586111 586111 Comes, John, of Lamport 1
4647160 2245219 2245219 defendant Comes John   586111 586111 Comes, John, of Lamport 1
4663530 2250071 2250071 defendant Smyth Walter smith 586111 586111 Smyth, Walter, of Lamport, smith 0
4670329 2256424 2256424 defendant Strode John clerk 586111 586111 Strode, John, of Lamport, clerk 4
4670377 2256430 2256430 defendant Fysshe alias Craft William yeoman 586111 586111 Fysshe alias Craft, William, of Lamport, yeoman 1
4670386 2256431 2256431 defendant Aude John laborer 586111 586111 Aude, John, of Lamport, laborer 1
4682347 2260101 2260101 defendant Taillour Richard tailor 586111 586111 Taillour, Richard, of Lamport, tailor 3
4687609 2261709 2261709 defendant Betfeld John yeoman 586111 586111 Betfeld, John, of Lamport, yeoman 1
4688827 2262062 2262062 defendant Taillour Richard yeoman 586111 586111 Taillour, Richard, of Lamport, yeoman 0
4690873 2262678 2262678 defendant Plomer Thomas dyer 586111 586111 Plomer, Thomas, of Lamport, dyer 0
4690876 2262678 2262678 defendant Boldlhay John, junior husbandman 586111 586111 Boldlhay, John, junior, of Lamport, husbandman 3
4696664 2264433 2264433 defendant Sloo John skinner 586111 586111 Sloo, John, of Lamport, skinner 0
4697034 2264551 2264551 defendant Sloo John ostler 586111 586111 Sloo, John, of Lamport, ostler 4
4702685 2266240 2266240 defendant Swyft John baker 586111 586111 Swyft, John, of Lamport, baker 0
4702687 2266240 2266240 defendant Raybon Richard   586111 586111 Raybon, Richard, of Lamport, husb 2
4706627 2267453 2267453 defendant Wylkyn John husbandman 586111 586111 Wylkyn, John, of Lamport, husbandman 0
4725912 2273391 2273391 defendant Smyth John summoner 586111 586111 Smyth, John, of Lamport, summoner 2
4725914 2273391 2273391 defendant Bidmore John shoemaker 586111 586111 Bidmore, John, of Lamport, shoemaker 4
4741976 2278152 2278152 defendant Tothe Edward yeoman 586111 586111 Tothe, Edward, of Lamport, yeoman 0
4746076 2279351 2279351 defendant Elys John butcher 586111 586111 Elys, John, of Lamport, butcher 0
4763609 2284604 2284604 defendant Clerk Robert tailor 586111 586111 Clerk, Robert, of Lamport, tailor 1
4763610 2284604 2284604 defendant Lyly John   586111 586111 Lyly, John, of Lamport, shoe maker 2
4763612 2284604 2284604 defendant Tyler William husbandman 586111 586111 Tyler, William, of Lamport, husbandman 4
4765858 2285317 2285317 defendant Wynter Benedict chapman 586111 586111 Wynter, Benedict, of Lamport, chapman 4
4771126 2286952 2286952 defendant Touche Edward husbandman 586111 586111 Touche, Edward, of Lamport, husbandman 0
4771127 2286952 2286952 defendant Dyer John drover 586111 586111 Dyer, John, of Lamport, drover 1
4771128 2286952 2286952 defendant Holton Richard dyer 586111 586111 Holton, Richard, of Lamport, dyer 2
4787293 2292096 2292096 defendant Clerk Robert tailor 586111 586111 Clerk, Robert, of Lamport, tailor 1
4787294 2292096 2292096 defendant Lyly John shoemaker 586111 586111 Lyly, John, of Lamport, shoemaker 2
4787296 2292096 2292096 defendant Tyler William husbandman 586111 586111 Tyler, William, of Lamport, husbandman 4
4811946 2299848 2299848 defendant Grendell Henry husbandman 586111 586111 Grendell, Henry, of Lamport, husbandman 0
4818001 2301711 2301711 defendant Ande or Aude John, junior   586111 586111 Ande or Aude, John, junior, of Lamport, wax burner, 4
4832153 2306086 2306086 defendant Sparke William husbandman 586111 586111 Sparke, William, of Lamport Estover, husbandman 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);