names

96 rows where place_id = 587686

✎ 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
3592149 1865164 1865164 defendant Rutter Thomas butcher 587686 587686 Rutter, Thomas, of Stortford, Herts, butcher 0
3608220 1870227 1870227 defendant Jenyn John yeoman 587686 587686 Jenyn, John, of Stortford, Herts, yeoman 0
3608285 1870248 1870248 defendant Shapthorp Richard butcher 587686 587686 Shapthorp, Richard, of Stortford, Herts, butcher 1
3623342 1874831 1874831 defendant Clerk John innholder 587686 587686 Clerk, John, of Stortford, Herts, innholder 0
3623822 1874981 1874981 defendant Clerk John husbandman 587686 587686 Clerk, John, of Stortford, Herts, husbandman 3
3623830 1874982 1874982 defendant Clerk John husbandman 587686 587686 Clerk, John, of Stortford, Herts, husbandman 3
3624455 1875184 1875184 defendant Enfeld Robert husbandman 587686 587686 Enfeld, Robert, of Stortford, Herts, husbandman 2
3625911 1902959 1902959 defendant Berners John gent 587686 587686 Berners, John, of Stortford, Herts, gent 0
3625913 1902960 1902960 defendant Berners John gent 587686 587686 Berners, John, of Stortford, Herts, gent 0
3627004 1903305 1903305 defendant Aprice John gent 587686 587686 (Aprice, John, of Stortford, Herts, gent 1
3632174 1904877 1904877 defendant Berne John gent 587686 587686 Berne, John, of Stortford, Herts, gent 0
3656249 1912201 1912201 defendant Jardfeld Richard tanner 587686 587686 Jardfeld, Richard, of Stortford, Herts, tanner 0
3676461 1918683 1918683 defendant Pylesdon John yeoman 587686 587686 Pylesdon, John, of Stortford, herts, yeoman 0
3723001 1933459 1933459 defendant Ronyngton or Rovyngton William   587686 587686 Ronyngton or Rovyngton, William, of Stortford, Herts, wheelwright 0
3785378 1953214 1953214 defendant Page John butcher 587686 587686 Page, John, of Stortford, Herts, butcher 2
3790991 1955019 1955019 defendant Newman Thomas yeoman 587686 587686 (Newman, Thomas, of Stortford, Herts, yeoman 1
3801885 1958488 1958488 defendant Crathorne John chapman 587686 587686 Crathorne, John, of Stortford, Herts, chapman 0
3807265 1960170 1960170 defendant Newman Thomas yeoman 587686 587686 (Newman, Thomas, of Stortford, Herts, yeoman 1
3807861 1960344 1960344 defendant Newman Thomas yeoman 587686 587686 (Newman, Thomas, of Stortford, Herts, yeoman 1
3808557 1960554 1960554 defendant Newman John baker 587686 587686 Newman, John, of Stortford, Herts, baker 1
3819893 1964102 1964102 defendant Maydeston John yeoman 587686 587686 Maydeston, John, of Stortford, Herts, yeoman 0
3879713 1983469 1983469 defendant Sturdy Margaret widow 587686 587686 Sturdy, Margaret, of Stortford, Herts, widow 0
3882629 1984454 1984454 defendant Snaw John shoemaker 587686 587686 Snaw, John, of Stortford, Herts, shoemaker 0
3898082 1989568 1989568 defendant Langham William butcher 587686 587686 Langham, William, of Stortford, Herts, butcher 0
3908295 1993071 1993071 defendant Lee Ralph pulter 587686 587686 Lee, Ralph, of Stortford, Herts, pulter 1
3909503 1993479 1993479 plaintiff Smyth John   587686 587686 Smyth, John, of Stortford, Herts 0
3910209 1993728 1993728 defendant Whyte Thomas laborer 587686 587686 Whyte, Thomas, of Stortford, Herts, laborer 2
3929593 2000248 2000248 plaintiff Carowe Thomas (legal representative) 587686 587686 Carowe, Thomas, of Stortford, Herts, yeoman, executors of: (Archer, William, of Copsale 0
3944616 2005214 2005214 plaintiff Bayford John   587686 587686 Bayford, John, of Stortford, Herts 0
3958657 2010103 2010103 defendant Pylston William yeoman 587686 587686 Pylston, William, of Stortford, Herts, yeoman 0
3975895 2016133 2016133 defendant Barnes Mathew chapman 587686 587686 Barnes, Mathew, of Stortford, Herts, chapman 2
4015825 2030344 2030344 plaintiff Southe John maltman 587686 587686 Southe, John, of Stortford, Herts, maltman 0
4059903 2045940 2045940 plaintiff Crabbe Thomas   587686 587686 Crabbe, Thomas, of Stortford, Herts, linen draper 0
4070332 2049684 2049684 defendant Pilston William yeoman 587686 587686 Pilston, William, of Stortford, Herts, yeoman 0
4182337 2089298 2089298 defendant Jaringan Thomas gent 587686 587686 Jaringan, Thomas, of Stortford, Herts, gent 0
4220836 2102783 2102783 defendant Grave Richard husbandman 587686 587686 Grave, Richard, of Stortford, Herts, husbandman 0
4220841 2102784 2102784 defendant Grave Richard husbandman 587686 587686 Grave, Richard, of Stortford, Herts, husbandman 2
4246694 2111871 2111871 defendant Grave Richard husbandman 587686 587686 Grave, Richard, of Stortford, Herts, husbandman 0
4246699 2111872 2111872 defendant Grave Richard husbandman 587686 587686 Grave, Richard, of Stortford, Herts, husbandman 2
4255450 2114816 2114816 defendant Abbott George tailor 587686 587686 Abbott, George, of Stortford, Herts, tailor 1
4267880 2118892 2118892 defendant Abbott George tailor 587686 587686 Abbott, George, of Stortford, Herts, tailor 1
4310092 2133687 2133687 defendant Grave Richard yeoman 587686 587686 Grave, Richard, of Stortford, Herts, yeoman 0
4349543 2147100 2147100 defendant Norton John tanner 587686 587686 Norton, John, of Stortford, Herts, tanner 1
4351942 2147915 2147915 defendant Blanke John yeoman 587686 587686 Blanke, John, of Stortford, Herts, yeoman 1
4354761 2148886 2148886 defendant Chandler Thomas chapman 587686 587686 Chandler, Thomas, of Stortford, Herts, chapman 0
4372495 2155231 2155231 defendant Barnard Nicholas tailor 587686 587686 Barnard, Nicholas, of Stortford, Herts, tailor 0
4379106 2157608 2157608 defendant Skingle John (legal representative) 587686 587686 Skingle, John, of Stortford, Herts, husbandman, administratrix of 2
4856850 2313519 2313519 defendant Hogon John scalder 587686 587686 Hogon, John, of Stortford, Herts, scalder 0
4876184 2319510 2319510 defendant Barbour Thomas yeoman 587686 587686 Barbour, Thomas, of Stortford, Herts, yeoman 2
4893243 2324597 2324597 defendant Cristemas John husbandman 587686 587686 Cristemas, John, of Stortford, Herts, husbandman 0
4991580 2354366 2354366 defendant Bryan Roger husbandman 587686 587686 Bryan, Roger, of Stortford, Herts, husbandman 2
5043482 2369672 2369672 defendant Goos John   587686 587686 Goos, John, of Stortford, Herts, tallow chandler 2
5084764 2381951 2381951 defendant Walays William husbandman 587686 587686 Walays, William, of Stortford, Herts, husbandman 1
5090602 2383633 2383633 defendant Davy William cordwainer 587686 587686 Davy, William, of Stortford, Herts, cordwainer 0
5100873 2386671 2386671 defendant Cristmesse Edmund yeoman 587686 587686 Cristmesse, Edmund, of Stortford, Herts, yeoman 1
5145689 2399882 2399882 defendant Thacham John gent 587686 587686 Thacham, John, of Stortford, Herts, gent 0
5146122 2399992 2399992 defendant Thacham John gent 587686 587686 Thacham, John, of Stortford, Herts, gent 1
5197213 2414923 2414923 defendant Begon John chapman 587686 587686 Begon, John, of Stortford, Herts, chapman 3
5207186 2417841 2417841 defendant Rotur Thomas butcher 587686 587686 Rotur, Thomas, of Stortford, Herts, butcher 0
5207188 2417841 2417841 defendant Gaterote John fishmonger 587686 587686 Gaterote, John, of Stortford, Herts, fishmonger 2
5209977 2418649 2418649 defendant Gegon John chapman 587686 587686 Gegon, John, of Stortford, Herts, chapman 3
5225474 2423125 2423125 defendant Rotour Thomas butcher 587686 587686 Rotour, Thomas, of Stortford, Herts, butcher 0
5237104 2426437 2426437 defendant Thurkyld John butcher 587686 587686 Thurkyld, John, of Stortford, Herts, butcher 0
5239221 2427058 2427058 defendant Gegon John chapman 587686 587686 Gegon, John, of Stortford, Herts,chapman 3
5239226 2427059 2427059 defendant Gegon John chapman 587686 587686 Gegon, John, of Stortford, Herts, chapman 3
5240579 2427458 2427458 defendant Rotour Thomas butcher 587686 587686 Rotour, Thomas, of Stortford, Herts, butcher 0
5242485 2428011 2428011 defendant Hunte William smith 587686 587686 Hunte, William, of Stortford, Herts, smith 1
5243923 2428414 2428414 defendant Sturdy John husbandman 587686 587686 Sturdy, John, of Stortford, Herts, husbandman 2
5248159 2429595 2429595 defendant Roter John butcher 587686 587686 Roter, John, of Stortford, Herts, butcher 3
5273274 2437250 2437250 defendant Seynden William gent 587686 587686 Seynden, William, of Stortford, Herts, gent 4
5289431 2441909 2441909 defendant Mounke John, senior husbandman 587686 587686 Mounke, John, senior, of Stortford, Herts, husbandman 4
5302332 2445666 2445666 defendant Edwyn William champman 587686 587686 Edwyn, William, of Stortford, Herts, champman 1
5325023 2452565 2452565 defendant Patener William   587686 587686 Patener, William, of Stortford, Herts, yeoman, dwelling with Gray, Thomas, knight 0
5325027 2452566 2452566 defendant Patoner or Patover William   587686 587686 Patoner or Patover, William, of Stortford, Herts, yeoman, dwelling with Grey, Thomas, knight 1
5325961 2452856 2452856 defendant Gegon John yeoman 587686 587686 Gegon, John, of Stortford, Herts, yeoman 1
5328159 2453496 2453496 defendant Bryon Roger yeoman 587686 587686 Bryon, Roger, of Stortford, Herts, yeoman 0
5343205 2458068 2458068 defendant Gogon John yeoman 587686 587686 Gogon, John, of Stortford, Herts, yeoman 1
5365581 2464907 2464907 defendant Maryon John husbandman 587686 587686 Maryon, John, of Stortford, Herts, husbandman 0
5365583 2464908 2464908 defendant Maryon John husbandman 587686 587686 Maryon, John, of Stortford, Herts, husbandman 0
5369893 2466171 2466171 defendant Rotour Thomas butcher 587686 587686 Rotour, Thomas, of Stortford, Herts, butcher 0
5374546 2467643 2467643 defendant Fordham John, junior husbandman 587686 587686 Fordham, John, junior, of Stortford, Herts, husbandman 1
5382733 2470124 2470124 defendant Rutter Thomas butcher 587686 587686 Rutter, Thomas, of Stortford, Herts, butcher 2
5414021 2479131 2479131 defendant Cutrode Thomas   587686 587686 Cutrode, Thomas, of Stortford, Herts, pedlar 4
5429560 2483778 2483778 defendant Entrode Thomas   587686 587686 Entrode, Thomas, of Stortford, Herts, pedlar 4
5446524 2488847 2488847 defendant Cutrode Thomas   587686 587686 Cutrode, Thomas, of Stortford, Herts, pedlar 4
5479618 2498916 2498916 defendant Bolyngton John husbandman 587686 587686 Bolyngton, John, of Stortford, Herts, husbandman 0
5492656 2502717 2502717 defendant Roberd Richard husbandman 587686 587686 Roberd, Richard, of Stortford, Herts, husbandman 0
5493864 2503073 2503073 defendant Fraunceys John   587686 587686 Fraunceys, John, of Stortford, Herts, paten maker 3
5501132 2505290 2505290 defendant Palmer Thomas butcher 587686 587686 Palmer, Thomas, of Stortford, Herts, butcher 0
5503789 2506102 2506102 defendant Edwyn William chapman 587686 587686 Edwyn, William, of Stortford, Herts, chapman 2
5512769 2508848 2508848 defendant Jenyn John yeoman 587686 587686 Jenyn, John, of Stortford, Herts, yeoman 1
5561896 2523465 2523465 defendant Denys Thomas tanner 587686 587686 Denys, Thomas, of Stortford, Herts, tanner 1
5562696 2523681 2523681 defendant Joslyn John yeoman 587686 587686 Joslyn, John, of Stortford, Herts, yeoman 0
5562988 2523771 2523771 defendant Apris John yeoman 587686 587686 Apris, John, of Stortford, Herts, yeoman 3
5594499 2533261 2533261 defendant Apryce John gent 587686 587686 Apryce, John, of Stortford, Herts, gent 0
5596599 2533854 2533854 defendant Langham William gent 587686 587686 Langham, William, of Stortford, Herts, gent 4

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