names

229 rows where place_id = 589887

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599127 1867364 1867364 defendant Bocher John butcher 589887 589887 Bocher, John, of Pontefract, butcher 0
3601033 1867989 1867989 defendant Richardson John husbandman or dyer 589887 589887 Richardson, John, of Pontefract, husbandman or dyer 1
3602073 1868310 1868310 defendant Coke Thomas yeoman 589887 589887 Coke, Thomas, of Pontefract, yeoman 2
3644716 1908756 1908756 defendant Man John yeoman 589887 589887 Man, John, of Pontefract, yeoman 0
3644717 1908756 1908756 defendant Fernhill Robert yeoman 589887 589887 Fernhill, Robert, of Pontefract, yeoman 1
3646220 1909211 1909211 defendant Bull Alexander yeoman of the crown 589887 589887 Bull, Alexander, of Pontefract, yeoman of the crown 0
3661146 1913764 1913764 defendant Couper Robert draper 589887 589887 Couper, Robert, of Pontefract, draper 0
3676503 1918695 1918695 defendant Man John yeoman 589887 589887 Man, John, of Pontefract, yeoman 0
3767113 1947367 1947367 defendant Chyld Gilbert yeoman 589887 589887 Chyld, Gilbert, of Pontefract, yeoman 2
3797780 1957204 1957204 defendant Beke John chapman 589887 589887 Beke, John, of Pontefract, chapman 0
3823548 1965267 1965267 defendant Clerkson John fisher 589887 589887 Clerkson, John, of Pontefract, fisher 0
3834636 1968767 1968767 defendant Ellys William esq 589887 589887 Ellys, William, of Pontefract, esq 0
3834638 1968768 1968768 defendant Ellys William esq 589887 589887 Ellys, William, of Pontefract, esq 0
3852971 1974551 1974551 plaintiff Fernell Robert   589887 589887 Fernell, Robert, of Pontefract 1
3941666 2004225 2004225 plaintiff Wakefeld Peter gent 589887 589887 Wakefeld, Peter, of Pontefract, gent 0
3972169 2014829 2014829 plaintiff Franck Percival (legal representative) 589887 589887 Franck, Percival, of Pontefract, gent, executors of 0
4014111 2029776 2029776 plaintiff Savage Alan gent 589887 589887 Savage, Alan, of Pontefract, gent 0
4030853 2035700 2035700 plaintiff Etherington Peter merchant 589887 589887 Etherington, Peter, of Pontefract, merchant 0
4046621 2041243 2041243 defendant Norton Joan widow 589887 589887 Norton, Joan, of Pontefract, widow 0
4046623 2041244 2041244 defendant Norton Joan widow 589887 589887 Norton, Joan, of Pontefract, widow 0
4046627 2041246 2041246 defendant Newbie Richard yeoman 589887 589887 Newbie, Richard, of Pontefract, yeoman 0
4046629 2041247 2041247 defendant Newbye Richard yeoman 589887 589887 Newbye, Richard, of Pontefract, yeoman 0
4080424 2053310 2053310 plaintiff Warde Robert   589887 589887 Warde, Robert, of Pontefract 0
4093310 2057924 2057924 plaintiff Etherington Peter merchant 589887 589887 Etherington, Peter, of Pontefract, merchant 0
4115830 2065946 2065946 defendant Wytham Robert gent 589887 589887 Wytham, Robert, of Pontefract, gent 0
4149620 2077992 2077992 defendant Crosby Thomas gent 589887 589887 Crosby, Thomas, of Pontefract, gent 0
4149623 2077993 2077993 defendant Crosbye Thomas gent 589887 589887 Crosbye, Thomas, of Pontefract, gent 0
4153529 2079327 2079327 defendant Calbecke William alderman 589887 589887 Calbecke, William, of Pontefract, alderman 1
4216929 2101414 2101414 defendant Durham Bartholomew yeoman 589887 589887 Durham, Bartholomew, of Pontefract, yeoman 0
4250637 2113197 2113197 defendant Bramhall John gent 589887 589887 Bramhall, John, of Pontefract, gent 2
4266663 2118494 2118494 defendant Durham Bartholomew yeoman 589887 589887 Durham, Bartholomew, of Pontefract, yeoman 0
4274323 2120965 2120965 defendant Bunyard John yeoman 589887 589887 Bunyard, John, of Pontefract, or of Wortley, Yorks, yeoman 0
4281049 2123271 2123271 defendant Wood Richard yeoman 589887 589887 Wood, Richard, of Pontefract, yeoman 0
4281050 2123271 2123271 defendant Tatam John   589887 589887 Tatam, John, of Pontefract 1
4282719 2123860 2123860 defendant Gilson Thomas saddler 589887 589887 together with Gilson, Thomas, of Pontefract, saddler 1
4282720 2123860 2123860 defendant Cliffe John carpenter 589887 589887 Cliffe, John, of Pontefract, carpenter 2
4282721 2123860 2123860 defendant Adams William yeoman 589887 589887 Adams, William, of Pontefract, yeoman 3
4312068 2134361 2134361 defendant Dorham Bartholomew laborer 589887 589887 Dorham, Bartholomew, of Pontefract, laborer 1
4312622 2134549 2134549 defendant Turner Robert weaver 589887 589887 Turner, Robert, of Pontefract, weaver 0
4312683 2134568 2134568 defendant Hardwicke John tailor 589887 589887 Hardwicke, John, of Pontefract, tailor 2
4313878 2134960 2134960 defendant Dixson William yeoman 589887 589887 Dixson, William, of Pontefract, yeoman 1
4318979 2136752 2136752 defendant Boothe Nicholas gent 589887 589887 Boothe, Nicholas, of Pontefract, gent 1
4320517 2137270 2137270 defendant Hodgson Robert glover 589887 589887 Hodgson, Robert, of Pontefract, glover 2
4352875 2148232 2148232 defendant Holgaite William innholder 589887 589887 Holgaite, William, of Pontefract, innholder 2
4352876 2148232 2148232 defendant Bateson Alan mercer 589887 589887 Bateson, Alan, of Pontefract, mercer 3
4379616 2157802 2157802 defendant Barker Lawrence   589887 589887 Barker, Lawrence, of Pontefract, clerk, Master of Arts, Cambridge University 0
4415331 2169690 2169690 defendant Richeman John   589887 589887 Richeman, John, of Pontefract 0
4417376 2170317 2170317 defendant Lewes Thomas de   589887 589887 Lewes, Thomas de, of Pontefract 0
4431418 2174596 2174596 defendant Norton Thomas de   589887 589887 Norton, Thomas de, of Pontefract 1
4460355 2188299 2188299 plaintiff Sherman Richard   589887 589887 Sherman, Richard, of Pontefract, on his own account 0
4461411 2188651 2188651 defendant Sherwynd Thomas   589887 589887 Sherwynd, Thomas, of Pontefract 1
4464247 2189481 2189481 defendant Sherwynd Thomas   589887 589887 Sherwynd, Thomas, of Pontefract 0
4479434 2194224 2194224 plaintiff Hyperom John   589887 589887 Hyperom, John, of Pontefract 0
4491020 2197885 2197885 defendant Iperon John   589887 589887 Iperon, John, of Pontefract 0
4507718 2202873 2202873 defendant Fraunceys William   589887 589887 Fraunceys, William, of Pontefract 3
4512551 2204365 2204365 plaintiff Box John   589887 589887 Box, John, of Pontefract 0
4512554 2204366 2204366 plaintiff Box John   589887 589887 Box, John, of Pontefract 0
4512557 2204367 2204367 plaintiff Box John   589887 589887 Box, John, of Pontefract 0
4515338 2205210 2205210 defendant Dunsford John butcher 589887 589887 Dunsford, John, of Pontefract, butcher 1
4518767 2206243 2206243 defendant Wolman Thomas   589887 589887 Wolman, Thomas, of Pontefract 2
4520818 2206853 2206853 defendant Tankerslay John   589887 589887 Tankerslay, John, of Pontefract 0
4530335 2209775 2209775 defendant Box John   589887 589887 Box, John, of Pontefract 0
4530341 2209776 2209776 defendant Box John   589887 589887 Box, John, of Pontefract 0
4534307 2210994 2210994 defendant Elys Ralph   589887 589887 Elys, Ralph, of Pontefract 0
4567336 2221340 2221340 defendant Garford John   589887 589887 Garford, John, of Pontefract 1
4575688 2223910 2223910 defendant Scriviner William   589887 589887 Scriviner, William, of Pontefract 1
4575689 2223910 2223910 defendant Shirwynd Thomas   589887 589887 Shirwynd, Thomas, of Pontefract 2
4600679 2231441 2231441 plaintiff Tourton Thomas master of St Nicholas' hospital 589887 589887 Tourton, Thomas, of Pontefract, master of St Nicholas' hospital 0
4631899 2240861 2240861 plaintiff Toueton Thomas master of the hospital of St Nicholas 589887 589887 Toueton, Thomas, of Pontefract, master of the hospital of St Nicholas 0
4631939 2240873 2240873 plaintiff Toweton Thomas de master of the hospital of St Nicholas 589887 589887 Toweton, Thomas de, of Pontefract, master of the hospital of St Nicholas 0
4642897 2244034 2244034 defendant Box John   589887 589887 Box, John, of Pontefract 0
4647014 2245189 2245189 plaintiff Rowler John   589887 589887 Rowler, John, of Pontefract, administrators of 0
4703903 2266597 2266597 defendant Casteler William dyer 589887 589887 Casteler, William, of Pontefract, dyer 0
4710658 2268690 2268690 defendant York John yeoman 589887 589887 York, John, of Pontefract, yeoman 0
4713861 2269660 2269660 plaintiff Taillour Henry   589887 589887 Taillour, Henry, of Pontefract 0
4714146 2269756 2269756 plaintiff Thornton John   589887 589887 Thornton, John, of Pontefract, vicar 0
4714498 2269865 2269865 plaintiff Toveton Thomas de master of the hospital of St Nicholas 589887 589887 Toveton, Thomas de, of Pontefract, master of the hospital of St Nicholas 0
4714500 2269866 2269866 plaintiff Toveton Thomas de master of the hospital of St Nicholas 589887 589887 Toveton, Thomas de, of Pontefract, master of the hospital of St Nicholas 0
4714502 2269867 2269867 plaintiff Toveton Thomas de master of the hospital of St Nicholas 589887 589887 Toveton, Thomas de, of Pontefract, master of the hospital of St Nicholas 0
4716768 2270567 2270567 plaintiff Wragby Robert   589887 589887 Wragby, Robert, of Pontefract 0
4716769 2270567 2270567 defendant del More Richard   589887 589887 del More, Richard, of Pontefract, spice seller 0
4723389 2272625 2272625 plaintiff del Hale William   589887 589887 del Hale, William, of Pontefract 0
4724928 2273088 2273088 defendant Halyday John yeoman 589887 589887 Halyday, John, of Pontefract, yeoman 0
4736871 2276659 2276659 defendant Frankys Thomas   589887 589887 Frankys, Thomas, of Pontefract, son of William 5
4736926 2276679 2276679 plaintiff Toveton Thomas de master of the hospital of St Nicholas 589887 589887 Toveton, Thomas de, of Pontefract, master of the hospital of St Nicholas 0
4750478 2280622 2280622 defendant Yorke John yeoman 589887 589887 Yorke, John, of Pontefract, yeoman 3
4752780 2281269 2281269 plaintiff Toueton Thomas master of St Nicholas' hospital 589887 589887 Toueton, Thomas, of Pontefract, master of St Nicholas' hospital 0
4755589 2282130 2282130 plaintiff Baghyll Thomas (legal representative) 589887 589887 Baghyll, Thomas, of Pontefract, executor of 0
4757675 2282776 2282776 defendant Brertwysyll John tailor 589887 589887 Brertwysyll, John, of Pontefract, tailor 0
4758173 2282930 2282930 defendant Otheall William chaplain 589887 589887 Otheall, William, of Pontefract, chaplain 0
4758174 2282930 2282930 defendant Skynner Thomas yeoman 589887 589887 Skynner, Thomas, of Pontefract, yeoman 1
4762896 2284376 2284376 defendant del Yorke John yeoman 589887 589887 del Yorke, John, of Pontefract, yeoman 4
4765364 2285151 2285151 plaintiff Cudworth John master of Holy Trinity college 589887 589887 Cudworth, John, of Pontefract, master of Holy Trinity college 2
4765365 2285151 2285151 defendant Retford Thomas   589887 589887 Retford, Thomas, of Pontefract, spice seller 0
4770380 2286706 2286706 plaintiff Radclyf John (legal representative) 589887 589887 Radclyf, John, of Pontefract, administrator of 0
4770382 2286706 2286706 defendant Scorthebeef Robert husbandman 589887 589887 Scorthebeef, Robert, of Pontefract, husbandman 0
4770623 2286794 2286794 defendant Hall William de butcher 589887 589887 Hall, William de, of Pontefract, butcher 1
4771549 2287079 2287079 defendant Denys Richard slater 589887 589887 Denys, Richard, of Pontefract, slater 0
4772588 2287396 2287396 defendant Denyas Richard slater 589887 589887 Denyas, Richard, of Pontefract, slater 2
4773157 2287574 2287574 plaintiff Sutton John   589887 589887 Sutton, John, of Pontefract 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);