names

51 rows where place_id = 592388

✎ 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
3607560 1870022 1870022 defendant Porter Thomas innholder 592388 592388 Porter, Thomas, of Newemarket, innholder 0
3612525 1871549 1871549 defendant Edon William chaplain 592388 592388 Edon, William, of Newemarket, chaplain 0
3612526 1871549 1871549 defendant Pretrye John barber 592388 592388 Pretrye, John, of Newemarket, barber 1
3614393 1872151 1872151 plaintiff Bright John   592388 592388 Bright, John, of Newemarket 0
3617865 1873211 1873211 defendant Kyng Walter yeoman 592388 592388 Kyng, Walter, of Newemarket, yeoman 0
3617866 1873211 1873211 defendant Kyng John pulter 592388 592388 Kyng, John, of Newemarket, pulter 1
3617867 1873211 1873211 defendant Kyng William husbandman 592388 592388 Kyng, William, of Newemarket, husbandman 2
3619228 1873616 1873616 defendant Leyfeld William chaplain 592388 592388 Leyfeld, William, of Newemarket, chaplain 0
3619231 1873617 1873617 defendant Leyfeld William chaplain 592388 592388 Leyfeld, William, of Newemarket, chaplain 0
4026107 2033983 2033983 defendant Cowper John beer brewer 592388 592388 Cowper, John, of Newemarket, beer brewer 1
4441048 2182124 2182124 defendant Wyk Thomas   592388 592388 Wyk, Thomas, of Newemarket, son of Ralph 0
4441050 2182125 2182125 defendant Wyke Thomas   592388 592388 Wyke, Thomas, of Newemarket, son of Ralph 0
4525323 2208261 2208261 defendant Bocher Walter   592388 592388 Bocher, Walter, of Newemarket 2
4534808 2211169 2211169 defendant Skynnere Walter   592388 592388 Skynnere, Walter, of Newemarket 0
4539592 2212642 2212642 defendant Lucas John   592388 592388 Lucas, John, of Newemarket 1
4543355 2213809 2213809 defendant Skynnere Walter   592388 592388 Skynnere, Walter, of Newemarket 0
4548776 2215553 2215553 defendant Kirkeby John   592388 592388 Kirkeby, John, of Newemarket 3
4560883 2219357 2219357 defendant Kyrkeby John   592388 592388 Kyrkeby, John, of Newemarket 0
4565231 2220698 2220698 defendant Taillour Ralph   592388 592388 Taillour, Ralph, of Newemarket 1
4565232 2220698 2220698 defendant Ede Margery   592388 592388 Ede, Margery, of Newemarket 2
4613544 2235253 2235253 defendant Chapman Nicholas   592388 592388 Chapman, Nicholas, of Newemarket 2
4613550 2235254 2235254 defendant Chapman Nicholas   592388 592388 Chapman, Nicholas, of Newemarket 2
4628533 2239846 2239846 defendant Taillour John   592388 592388 Taillour, John, of Newemarket 0
4649615 2245919 2245919 defendant Taillour John   592388 592388 Taillour, John, of Newemarket 1
4666219 2250905 2250905 defendant Fysshere William husbandman 592388 592388 Fysshere, William, of Newemarket, husbandman 2
4666220 2250905 2250905 defendant Shawe William fisher 592388 592388 Shawe, William, of Newemarket, fisher 3
4684897 2260870 2260870 defendant Den William husbandman 592388 592388 Den, William, of Newemarket, husbandman 0
4698474 2265000 2265000 defendant Heigham John yeoman 592388 592388 Heigham, John, of Newemarket, yeoman 3
4746115 2279360 2279360 defendant Joce John (legal representative) 592388 592388 Joce, John, of Newemarket, executors of 0
4783034 2290712 2290712 defendant Genote John husbandman 592388 592388 Genote, John, of Newemarket, husbandman 1
4821988 2302947 2302947 defendant Taillour John husbandman 592388 592388 Taillour, John, of Newemarket, husbandman 2
4936642 2337845 2337845 defendant Wynter John, senior cordwainer 592388 592388 Wynter, John, senior, of Newemarket, cordwainer 1
4936643 2337845 2337845 defendant Dewesly or Dewesby John hosteler 592388 592388 Dewesly or Dewesby, John, of Newemarket, hosteler 2
4939549 2338755 2338755 defendant atte Wode Agnes widow 592388 592388 atte Wode, Agnes, of Newemarket, widow 2
4940587 2339083 2339083 defendant Joos John gent 592388 592388 Joos, John, of Newemarket, gent 0
5051279 2371994 2371994 defendant Leycester John Chapman 592388 592388 Leycester, John, of Newemarket, Chapman 3
5067634 2376814 2376814 defendant Howelet Richard pedder 592388 592388 Howelet, Richard, of Newemarket, pedder 0
5261385 2433669 2433669 defendant Cok Ralph hosteler 592388 592388 Cok, Ralph, of Newemarket, hosteler 0
5261386 2433669 2433669 defendant Lote Nicholas laborer 592388 592388 Lote, Nicholas, of Newemarket, laborer 1
5280935 2439499 2439499 defendant Wulpytte Thomas husbandman 592388 592388 Wulpytte, Thomas, of Newemarket, husbandman 0
5303331 2445993 2445993 defendant Dale Henry shoemaker 592388 592388 Dale, Henry, of Newemarket, shoemaker 0
5423596 2482022 2482022 plaintiff Boydone Thomas   592388 592388 Boydone, Thomas, of Newemarket 0
5457840 2492241 2492241 defendant Boydon Thomas innholder 592388 592388 Boydon, Thomas, of Newemarket, innholder 0
5457841 2492241 2492241 defendant Baker Thomas yeoman 592388 592388 Baker, Thomas, of Newemarket, yeoman 1
5485147 2500478 2500478 defendant Boydon Thomas yeoman 592388 592388 Boydon, Thomas, of Newemarket, yeoman 0
5485148 2500478 2500478 defendant Porter Thomas yeoman 592388 592388 Porter, Thomas, of Newemarket, yeoman 1
5485149 2500478 2500478 defendant Depden John yeoman 592388 592388 Depden, John, of Newemarket, yeoman 2
5622598 2550997 2550997 defendant Clerk Richard   592388 592388 Clerk, Richard, of Newemarket 4
5625979 2552085 2552085 plaintiff Leycetre John   592388 592388 Leycetre, John, of Newemarket 1
5625982 2552086 2552086 plaintiff Leycetre John   592388 592388 Leycetre, John, of Newemarket 1
5629916 2553360 2553360 defendant Frost John barber 592388 592388 Frost, John, of Newemarket, barber 0

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