names

124 rows where place_id = 593363

✎ 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
3611495 1871268 1871268 defendant Meysand John clerk 593363 593363 Meysand, John, of Thrapston, clerk 0
3670775 1916821 1916821 defendant Bywater Geoffrey mercer 593363 593363 Bywater, Geoffrey, of Thrapston, mercer 1
3672183 1917299 1917299 defendant Bywater Geoffrey yeoman 593363 593363 Bywater, Geoffrey, of Thrapston, yeoman 0
3674203 1917969 1917969 defendant Bywater Geoffrey merchant 593363 593363 Bywater, Geoffrey, of Thrapston, merchant 1
3764743 1946637 1946637 defendant Barnard John husbandman 593363 593363 Barnard, John, of Thrapston, husbandman 0
4009433 2028139 2028139 plaintiff Nethercote Thomas yeoman 593363 593363 Nethercote, Thomas, of Thrapston, yeoman 0
4020493 2032052 2032052 plaintiff Willoughby Francis gent 593363 593363 Willoughby, Francis, of Thrapston, gent 0
4175981 2087077 2087077 defendant Goodfellowe John   593363 593363 Goodfellowe, John, of Thrapston, linen draper 0
4185929 2090567 2090567 defendant Manle George clothier 593363 593363 Manle, George, of Thrapston, yeoman, or of Naylond, Suff, clothier 0
4185989 2090588 2090588 defendant Downhall William gent 593363 593363 (Downhall, William, of Thrapston, gent 1
4190480 2092224 2092224 defendant Willoughbye Francis   593363 593363 Willoughbye, Francis, of Thrapston, gent, administrators of 0
4199294 2095306 2095306 defendant Goodfellowe John   593363 593363 Goodfellowe, John, of Thrapston, linen draper 0
4199295 2095306 2095306 defendant Sharpe John cordwainer 593363 593363 Sharpe, John, of Thrapston, cordwainer 1
4353950 2148609 2148609 plaintiff Southwell John   593363 593363 Southwell, John, of Thrapston 0
4353952 2148610 2148610 plaintiff Southwell John   593363 593363 Southwell, John, of Thrapston 0
4433077 2175098 2175098 defendant Clerk Edmund le   593363 593363 Clerk, Edmund le, of Thrapston, son of William 0
4434985 2175704 2175704 plaintiff Mayhu John   593363 593363 Mayhu, John, of Thrapston 0
4451572 2185462 2185462 defendant Bollewyk John smith 593363 593363 Bollewyk, John, of Thrapston, smith 0
4503517 2201673 2201673 plaintiff Petelyng Henry   593363 593363 Petelyng, Henry, of Thrapston, parson 0
4503518 2201673 2201673 defendant Drawghton Thomas   593363 593363 Drawghton, Thomas, of Thrapston 0
4503519 2201673 2201673 defendant Dykon John   593363 593363 Dykon, John, of Thrapston 1
4532990 2210589 2210589 defendant May William   593363 593363 May, William, of Thrapston 1
4533008 2210593 2210593 defendant Bakster John   593363 593363 Bakster, John, of Thrapston 1
4539618 2212652 2212652 defendant Dulryng William   593363 593363 Dulryng, William, of Thrapston 0
4572112 2222830 2222830 defendant Wryght John   593363 593363 Wryght, John, of Thrapston 10
4586120 2227083 2227083 defendant Phypson John   593363 593363 Phypson, John, of Thrapston 0
4610744 2234426 2234426 plaintiff Chambre William   593363 593363 Chambre, William, of Thrapston, parson 0
4618861 2236896 2236896 plaintiff Thame Alan de   593363 593363 (Thame, Alan de, of Thrapston, parson 1
4618870 2236898 2236898 plaintiff Tame Alan de   593363 593363 (Tame, Alan de, of Thrapston, formerly parson 1
4644680 2244529 2244529 defendant Oude Henry   593363 593363 Oude, Henry, of Thrapston 0
4660429 2249087 2249087 defendant Draughton John   593363 593363 Draughton, John, of Thrapston, mason 0
4660814 2249206 2249206 defendant Draughton John   593363 593363 Draughton, John, of Thrapston, mason 0
4683752 2260521 2260521 defendant Daundeleyn William husbandman 593363 593363 Daundeleyn, William, of Thrapston, husbandman 0
4683754 2260522 2260522 defendant Daundeleyn William husbandman 593363 593363 Daundeleyn, William, of Thrapston, husbandman 0
4715573 2270198 2270198 defendant Wryght Thomas husbandman 593363 593363 Wryght, Thomas, of Thrapston, husbandman 0
4715574 2270198 2270198 defendant Dycon Henry husbandman 593363 593363 Dycon, Henry, of Thrapston, husbandman 1
4737385 2276810 2276810 defendant Daundlyn William husbandman 593363 593363 Daundlyn, William, of Thrapston, husbandman 0
4760124 2283512 2283512 plaintiff Comfort Simon   593363 593363 Comfort, Simon, of Thrapston 0
4764959 2285016 2285016 defendant Cumfort Simon drover 593363 593363 Cumfort, Simon, of Thrapston, drover 0
4780330 2289847 2289847 defendant Tyther Thomas husbandman 593363 593363 Tyther, Thomas, of Thrapston, husbandman 0
4782389 2290497 2290497 plaintiff Comfort Simon   593363 593363 Comfort, Simon, of Thrapston 0
4804437 2297572 2297572 defendant Laverok Henry   593363 593363 Laverok, Henry, of Thrapston 0
4831657 2305930 2305930 defendant Conforth Simon husbandman 593363 593363 Conforth, Simon, of Thrapston, husbandman 0
4831658 2305930 2305930 defendant Glover John husbandman 593363 593363 Glover, John, of Thrapston, husbandman 1
4838739 2308042 2308042 defendant Comford Simon husbandman 593363 593363 Comford, Simon, of Thrapston, husbandman 0
4838740 2308042 2308042 defendant Glover John   593363 593363 Glover, John, of Thrapston husbandman 1
4841121 2308757 2308757 defendant Chaumberlyn John (legal representative) 593363 593363 Chaumberlyn, John, of Thrapston, husbandman, executors of 0
4841123 2308757 2308757 defendant Tychemerssh Henry husbandman 593363 593363 Tychemerssh, Henry, of Thrapston, husbandman 2
4841726 2308950 2308950 defendant Comfort Simon yeoman 593363 593363 Comfort, Simon, of Thrapston, yeoman 0
4844303 2309726 2309726 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 0
4853211 2312421 2312421 defendant Feker William chapman 593363 593363 Feker, William, of Thrapston, chapman 0
4853212 2312421 2312421 defendant Draper John chapman 593363 593363 Draper, John, of Thrapston, chapman 1
4855301 2313010 2313010 defendant Bocher John husbandman 593363 593363 Bocher, John, of Thrapston, husbandman 0
4857385 2313699 2313699 plaintiff Bocher Robert   593363 593363 Bocher, Robert, of Thrapston 0
4857388 2313699 2313699 defendant Feker William drover 593363 593363 Feker, William, of Thrapston, drover 2
4863157 2315454 2315454 defendant Counfort Simon husbandman 593363 593363 Counfort, Simon, of Thrapston, husbandman 2
4865878 2316301 2316301 defendant Glover John husbandman 593363 593363 Glover, John, of Thrapston, husbandman 0
4868337 2317074 2317074 defendant Daundelyon John husbandman 593363 593363 Daundelyon, John, of Thrapston, husbandman 0
4873921 2318782 2318782 defendant Comfort John husbandman 593363 593363 Comfort, John, of Thrapston, husbandman 1
4873923 2318783 2318783 defendant Glover John wellman 593363 593363 Glover, John, of Thrapston, wellman 0
4879070 2320385 2320385 defendant Foker William yeoman 593363 593363 Foker, William, of Thrapston, yeoman 0
4881053 2320985 2320985 defendant Feker William chapman 593363 593363 Feker, William, of Thrapston, chapman 0
4881054 2320985 2320985 defendant Draper John chapman 593363 593363 Draper, John, of Thrapston, chapman 1
4884552 2322076 2322076 defendant Counford Simon husbandman 593363 593363 Counford, Simon, of Thrapston, husbandman 0
4884553 2322076 2322076 defendant Counford John husbandman 593363 593363 Counford, John, of Thrapston, husbandman 1
4886831 2322735 2322735 defendant Comfort Simon ostler 593363 593363 Comfort, Simon, of Thrapston, ostler 0
4889980 2323651 2323651 defendant Comford Simon husbandman 593363 593363 Comford, Simon, of Thrapston, husbandman 0
4890001 2323656 2323656 defendant Glover John glover 593363 593363 Glover, John, of Thrapston, glover 0
4890002 2323656 2323656 defendant Glover Thomas glover 593363 593363 Glover, Thomas, of Thrapston, glover 1
4900212 2326693 2326693 plaintiff Comfort Simon   593363 593363 Comfort, Simon, of Thrapston 0
4902746 2327478 2327478 defendant Counfort Simon husbandman 593363 593363 Counfort, Simon, of Thrapston, husbandman 0
4916901 2331789 2331789 defendant Glover Thomas glover 593363 593363 Glover, Thomas, of Thrapston, glover 0
4925100 2334283 2334283 defendant Cownford Simon husbandman 593363 593363 Cownford, Simon, of Thrapston, husbandman 0
4925104 2334283 2334283 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 4
4926845 2334826 2334826 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 1
4926848 2334827 2334827 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 1
4927683 2335091 2335091 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 1
4927685 2335091 2335091 defendant Olover John chapman 593363 593363 Olover, John, of Thrapston, chapman 3
4927686 2335091 2335091 defendant Walton William   593363 593363 Walton, William, of Thrapston, servant 4
4927687 2335091 2335091 defendant Grymbold Richard husbandman 593363 593363 Grymbold, Richard, of Thrapston, husbandman 5
4932017 2336402 2336402 defendant Coumfort Simon husbandman 593363 593363 Coumfort, Simon, of Thrapston, husbandman 0
4940959 2339197 2339197 defendant Sherde Ralph   593363 593363 Sherde, Ralph, of Thrapston, wright 0
4947111 2341090 2341090 defendant Walton William   593363 593363 Walton, William, of Thrapston, servant 1
4955669 2343663 2343663 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 0
4955671 2343664 2343664 defendant Bocher John butcher 593363 593363 Bocher, John, of Thrapston, butcher 0
4957409 2344184 2344184 defendant Comfort Simon yeoman 593363 593363 Comfort, Simon, of Thrapston, yeoman 0
4968538 2347558 2347558 defendant Shyngelton John fuller 593363 593363 Shyngelton, John, of Thrapston, fuller 0
4983832 2352092 2352092 defendant Comford Simon yeoman 593363 593363 Comford, Simon, of Thrapston, yeoman 0
4983840 2352093 2352093 defendant Counfort or Counsort Simon yeoman 593363 593363 Counfort or Counsort, Simon, of Thrapston, yeoman 0
5042718 2369430 2369430 defendant Crabbe Henry husbandman 593363 593363 Crabbe, Henry, of Thrapston, husbandman 0
5045386 2370249 2370249 defendant Palmer John husbandman 593363 593363 Palmer, John, of Thrapston, husbandman 2
5047825 2370966 2370966 defendant Person Thomas clerk 593363 593363 Person, Thomas, of Thrapston, clerk 2
5051241 2371986 2371986 defendant Comford Simon yeoman 593363 593363 Comford, Simon, of Thrapston, yeoman 0
5070051 2377536 2377536 defendant Comford Simon yeoman 593363 593363 Comford, Simon, of Thrapston, yeoman 1
5072174 2378166 2378166 defendant Dyer John dyer 593363 593363 Dyer, John, of Thrapston, dyer 0
5098345 2385945 2385945 defendant Bocher John yeoman 593363 593363 Bocher, John, of Thrapston, yeoman 0
5098351 2385948 2385948 plaintiff Veer Richard esq 593363 593363 Veer, Richard, of Thrapston, esq 0
5098352 2385948 2385948 defendant Schyllyng John yeoman 593363 593363 Schyllyng, John, of Thrapston, yeoman 0
5098353 2385948 2385948 defendant Coumford Simon yeoman 593363 593363 Coumford, Simon, of Thrapston, yeoman 1
5098354 2385948 2385948 defendant Gardyner Richard husbandman 593363 593363 Gardyner, Richard, of Thrapston, husbandman 2

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