names

126 rows where place_id = 596671

✎ 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
3625698 1875575 1875575 defendant Gerlyng Robert yeoman 596671 596671 Gerlyng, Robert, of Wykham Market, yeoman 0
3631299 1904602 1904602 defendant Leche John smith 596671 596671 Leche, John, of Wykham Market, smith 7
3645321 1908945 1908945 defendant Flewet Richard husbandman 596671 596671 Flewet, Richard, of Wykham Market, husbandman 0
3646637 1909353 1909353 defendant Wolmer Walter yeoman 596671 596671 Wolmer, Walter, of Wykham Market, yeoman 3
3646639 1909354 1909354 defendant Wenge John mercer 596671 596671 Wenge, John, of Wykham Market, mercer 0
3671676 1917128 1917128 defendant Bradlawe William chapman 596671 596671 Bradlawe, William, of Wykham Market, chapman 0
3679956 1919796 1919796 defendant More Robert   596671 596671 More, Robert, of Wykham Market, paten maker 2
3680498 1919983 1919983 defendant Gyrlyng Thomas yeoman 596671 596671 Gyrlyng, Thomas, of Wykham Market, yeoman 1
3681526 1920312 1920312 defendant Cros John dyer 596671 596671 Cros, John, of Wykham Market, dyer 3
3687607 1922296 1922296 defendant Hankok John yeoman 596671 596671 Hankok, John, of Wykham Market, yeoman 0
3690073 1923056 1923056 defendant Grenlyng Thomasm   596671 596671 Grenlyng, Thomasm, of Wykham Market, court holder 0
3690230 1923103 1923103 defendant Downyng John baker 596671 596671 Downyng, John, of Wykham Market, baker 1
3694195 1924389 1924389 defendant Downyng John baker 596671 596671 Downyng, John, of Wykham Market, baker 1
3705856 1928114 1928114 defendant Gyrlyng Thomas   596671 596671 Gyrlyng, Thomas, of Wykham Market, court holder 3
3710709 1929669 1929669 defendant Blynde William yeoman 596671 596671 Blynde, William, of Wykham Market, yeoman 0
3729667 1935530 1935530 defendant Downyng Richard baker 596671 596671 Downyng, Richard, of Wykham Market, baker 2
3766183 1947077 1947077 defendant Gyrlyng Thomas   596671 596671 Gyrlyng, Thomas, of Wykham Market, court holder 0
3810695 1961244 1961244 plaintiff Brylle Edmund   596671 596671 Brylle, Edmund, of Wykham Market 0
3810696 1961244 1961244 plaintiff Brylle William   596671 596671 Brylle, William, of Wykham Market 1
3833474 1968399 1968399 defendant Lully John yeoman 596671 596671 Lully, John, of Wykham Market, yeoman 3
3836323 1969268 1969268 defendant Bokenham William mercer 596671 596671 Bokenham, William, of Wykham Market, mercer 1
3841861 1971031 1971031 defendant Blynde William yeoman 596671 596671 Blynde, William, of Wykham Market, yeoman 4
4548918 2215594 2215594 defendant Chaunpeneys Thomas   596671 596671 Chaunpeneys, Thomas, of Wykham Market 1
4610514 2234359 2234359 defendant Champenays Thomas   596671 596671 Champenays, Thomas, of Wykham Market 0
4660423 2249084 2249084 defendant Champenays Thomas husbandman 596671 596671 Champenays, Thomas, of Wykham Market, husbandman 2
4671745 2256807 2256807 defendant Skynnere Robert skinner 596671 596671 Skynnere, Robert, of Wykham Market, skinner 0
4679231 2259112 2259112 defendant Halle John woolman 596671 596671 Halle, John, of Wykham Market, woolman 0
4681767 2259909 2259909 defendant Fisshere Roger butcher 596671 596671 Fisshere, Roger, of wykham Market, butcher 0
4681768 2259909 2259909 defendant Brundyssh Edmund husbandman 596671 596671 Brundyssh, Edmund, of Wykham Market, husbandman 1
4683092 2260326 2260326 defendant Cooke John butcher 596671 596671 Cooke, John, of Wykham Market, butcher 2
4683661 2260491 2260491 defendant Fisshere alias Clopton Roger husbandman 596671 596671 Fisshere alias Clopton, Roger, of Wykham Market, husbandman 0
4686419 2261357 2261357 defendant Risshere Roger butcher 596671 596671 Risshere, Roger, of Wykham Market, butcher 0
4686420 2261357 2261357 defendant Baxtere Benedict baker 596671 596671 Baxtere, Benedict, of Wykham Market, baker 1
4689324 2262221 2262221 defendant Skynner Robert yeoman 596671 596671 Skynner, Robert, of Wykham Market, yeoman 0
4690429 2262566 2262566 defendant Blak Robert butcher 596671 596671 Blak, Robert, of Wykham Market, butcher 4
4695935 2264214 2264214 defendant Spyce John husbandman 596671 596671 Spyce, John, of Wykham Market, husbandman 2
4705438 2267067 2267067 defendant Halle John   596671 596671 Halle, John, of Wykham Market, wool man 2
4715009 2270025 2270025 defendant Skynner Robert yeoman 596671 596671 Skynner, Robert, of Wykham Market, yeoman 0
4724619 2272999 2272999 defendant Blak Robert butcher 596671 596671 Blak, Robert, of Wykham Market, butcher 2
4749803 2280418 2280418 defendant Fyssher Roger husbandman 596671 596671 Fyssher, Roger, of Wykham Market, husbandman 1
4756692 2282457 2282457 defendant Blakke Robert butcher 596671 596671 Blakke, Robert, of Wykham Market, butcher 0
4758185 2282933 2282933 defendant Blak Robert butcher 596671 596671 Blak, Robert, of Wykham Market, butcher 3
4763672 2284626 2284626 plaintiff Grome John (legal representative) 596671 596671 Grome, John, of Wykham Market, executors of 0
4770241 2286666 2286666 defendant Blakke Robert butcher 596671 596671 Blakke, Robert, of Wykham Market, butcher 0
4782466 2290525 2290525 defendant Miles Richard mercer 596671 596671 Miles, Richard, of Wykham Market, mercer 1
4832946 2306324 2306324 defendant Bokelard Robert smith 596671 596671 Bokelard, Robert, of Wykham Market, smith 1
4832947 2306324 2306324 defendant Hadley John husbandman 596671 596671 Hadley, John, of Wykham Market, husbandman 2
4835805 2307192 2307192 defendant Cristemesse William yeoman 596671 596671 Cristemesse, William, of Wykham Market, yeoman 6
4868851 2317234 2317234 plaintiff Kentewell Thomas draper 596671 596671 Kentewell, Thomas, of Wykham Market, draper 0
4927885 2335157 2335157 defendant Baker William weaver 596671 596671 Baker, William, of Wykham Market, weaver 0
4928059 2335208 2335208 defendant Glannvyle Richard husbandman 596671 596671 Glannvyle, Richard, of Wykham Market, husbandman 0
4933187 2336772 2336772 defendant Rowghe Simon baker 596671 596671 Rowghe, Simon, of Wykham Market, baker 0
4933188 2336772 2336772 defendant Bradlawe John pedder 596671 596671 Bradlawe, John, of Wykham Market, pedder 1
4935084 2337382 2337382 defendant Buntyng Richard husbandman 596671 596671 Buntyng, Richard, of Wykham Market, husbandman 2
4966438 2346895 2346895 defendant Cheny Thomas husbandman 596671 596671 Cheny, Thomas, of Wykham Market, husbandman 0
4972259 2348649 2348649 plaintiff Kentwell Thomas   596671 596671 Kentwell, Thomas, of Wykham Market 0
4989628 2353820 2353820 defendant Bbuntyng Robert husbandman 596671 596671 Bbuntyng, Robert, of Wykham market, husbandman 2
4989946 2353902 2353902 defendant Ketyll William draper 596671 596671 Ketyll, William, of Wykham Market, draper 0
4996083 2355685 2355685 defendant Gulle Richard skinner 596671 596671 Gulle, Richard, of Wykham Market, skinner 0
5004473 2358207 2358207 defendant Grey John smith 596671 596671 Grey, John, of Wykham Market, smith 0
5025598 2364395 2364395 plaintiff Kentewell Thomas   596671 596671 Kentewell, Thomas, of Wykham Market 0
5025599 2364395 2364395 plaintiff Ketyll William   596671 596671 Ketyll, William, of Wykham Market 1
5086671 2382493 2382493 defendant Ketyll William hosier 596671 596671 together with Ketyll, William, of Wykham Market, hosier 1
5086675 2382494 2382494 defendant Ketyll William hosier 596671 596671 Ketyll, William, of Wykham Market, hosier 0
5109887 2389319 2389319 defendant Deynes John cutler 596671 596671 Deynes, John, of Wykham Market, cutler 0
5113662 2390388 2390388 defendant Deynys John cutler 596671 596671 Deynys, John, of Wykham Market, cutler 2
5118941 2391972 2391972 defendant Hese Stephen husbandman 596671 596671 Hese, Stephen, of Wykham Market, husbandman 3
5125256 2393864 2393864 defendant Hose Stephen husbandman 596671 596671 Hose, Stephen, of Wykham Market, husbandman 0
5138193 2397683 2397683 defendant Browe William pedder 596671 596671 Browe, William, of Wykham Market, pedder 0
5138221 2397691 2397691 defendant Brundysh John yeoman 596671 596671 Brundysh, John, of Wykham Market, yeoman 0
5138222 2397691 2397691 defendant Ketyll William yeoman 596671 596671 Ketyll, William, of Wykham Market, yeoman 1
5138223 2397691 2397691 defendant Brylle John yeoman 596671 596671 Brylle, John, of Wykham Market, yeoman 2
5158967 2403743 2403743 defendant Crowe William   596671 596671 Crowe, William, of Wykham Market, pedlar 0
5158969 2403744 2403744 defendant Crowe William   596671 596671 Crowe, William, of Wykham Market, pedlar 0
5159005 2403753 2403753 defendant Brundysh John yeoman 596671 596671 Brundysh, John, of Wykham Market, yeoman 0
5159006 2403753 2403753 defendant Ketyll William yeoman 596671 596671 Ketyll, William, of Wykham Market, yeoman 1
5159007 2403753 2403753 defendant Brylle John yeoman 596671 596671 Brylle, John, of Wykham Market, yeoman 2
5174246 2408172 2408172 defendant Crowe William   596671 596671 Crowe, William, of Wykham Market, pedlar 0
5174275 2408181 2408181 defendant Brundyssh John yeoman 596671 596671 Brundyssh, John, of Wykham Market, yeoman 0
5174276 2408181 2408181 defendant Ketyll William yeoman 596671 596671 Ketyll, William, of Wykham Market, yeoman 1
5174277 2408181 2408181 defendant Brylle John yeoman 596671 596671 Brylle, John, of Wykham Market, yeoman 2
5208994 2418362 2418362 defendant Brundyssh John yeoman 596671 596671 Brundyssh, John, of Wykham Market, yeoman 0
5208995 2418362 2418362 defendant Ketyll William yeoman 596671 596671 Ketyll, William, of Wykham Market, yeoman 1
5208996 2418362 2418362 defendant Brylle John yeoman 596671 596671 Brylle, John, of Wykham Market, yeoman 2
5208998 2418363 2418363 defendant Ketyll William yeoman 596671 596671 Ketyll, William, of Wykham Market, yeoman 0
5209000 2418364 2418364 defendant Crowe William   596671 596671 Crowe, William, of Wykham Market, pedlar 0
5212844 2419500 2419500 defendant Crowe John husbandman 596671 596671 Crowe, John, of Wykham Market, husbandman 2
5216440 2420537 2420537 defendant Deyn John cutler 596671 596671 Deyn, John, of Wykham Market, cutler 4
5232297 2425025 2425025 defendant Buntyng Richard husbandman 596671 596671 Buntyng, Richard, of Wykham Market, husbandman 2
5242017 2427867 2427867 defendant Ayschele Stephen yeoman 596671 596671 Ayschele, Stephen, of Wykham Market, yeoman 0
5247216 2429345 2429345 defendant Deynes John cutler 596671 596671 Deynes, John, of Wykham Market, cutler 0
5254676 2431582 2431582 defendant Sampson William tailor 596671 596671 Sampson, William, of Wykham Market, tailor 0
5254678 2431582 2431582 defendant Elman John cordwainer 596671 596671 Elman, John, of Wykham Market, cordwainer 2
5257675 2432521 2432521 defendant Frere Alexander draper 596671 596671 Frere, Alexander, of Wykham Market, draper 0
5263488 2434328 2434328 defendant Bernard Edward butcher 596671 596671 Bernard, Edward, of Wykham Market, butcher 0
5265097 2434843 2434843 defendant Troppenell Thomas butcher 596671 596671 Troppenell, Thomas, of Wykham Market, butcher 0
5283956 2440334 2440334 defendant Ketyll William draper 596671 596671 Ketyll, William, of Wykham Market, draper 3
5312890 2448888 2448888 defendant Dyer Edward dyer 596671 596671 Dyer, Edward, of Wykham Market, dyer 0
5312891 2448888 2448888 defendant Cotell Richard fuller 596671 596671 Cotell, Richard, of Wykham Market, fuller 1
5312893 2448888 2448888 defendant Burgeys John dyer 596671 596671 Burgeys, John, of Wykham Market, dyer 3

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