names

71 rows where place_id = 590271

✎ 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
3600444 1867786 1867786 defendant Nagyr Henry husbandman 590271 590271 Nagyr, Henry, of Crendon, husbandman 2
3623857 1874992 1874992 defendant Padnale John husbandman 590271 590271 Padnale, John, of Crendon, husbandman 0
3624427 1875174 1875174 defendant Padnall John yeoman 590271 590271 Padnall, John, of Crendon, yeoman 1
3636207 1906113 1906113 defendant Pede John husbandman 590271 590271 Pede, John, of Crendon, husbandman 0
3641420 1907772 1907772 defendant Pede John husbandman 590271 590271 Pede, John, of Crendon, husbandman 0
3669733 1916479 1916479 defendant Pede Henry husbandman 590271 590271 Pede, Henry, of Crendon, husbandman 0
3687308 1922211 1922211 defendant Byrtte William husbandman 590271 590271 Byrtte, William, of Crendon, husbandman 0
3692465 1923825 1923825 defendant Brytte William husbandman 590271 590271 Brytte, William, of Crendon, husbandman 0
3703677 1927430 1927430 defendant Birte William husbandman 590271 590271 Birte, William, of Crendon, husbandman 0
3730194 1935669 1935669 defendant Horwood Richard husbandman 590271 590271 Horwood, Richard, of Crendon, husbandman 0
3731651 1936127 1936127 defendant Byrtte William husbandman 590271 590271 Byrtte, William, of Crendon, husbandman 0
3740048 1938742 1938742 defendant Pede John husbandman 590271 590271 Pede, John, of Crendon, husbandman 0
3745743 1940570 1940570 plaintiff Byrte William   590271 590271 Byrte, William, of Crendon 0
3752479 1942699 1942699 defendant Pede John husbandman 590271 590271 Pede, John, of Crendon, husbandman 0
3794321 1956100 1956100 defendant Byrt William   590271 590271 Byrt, William, of Crendon, husbandman, son of Byrt, Henry, of Chilton 0
4276963 2121873 2121873 defendant Greenynge John husbandman 590271 590271 Greenynge, John, of Crendon, husbandman 1
4420304 2171252 2171252 defendant fitz Pieris John   590271 590271 fitz Pieris, John, of Crendon 0
4434713 2175620 2175620 plaintiff Clifford John   590271 590271 Clifford, John, of Crendon 1
4458424 2187677 2187677 plaintiff Ram John, junior   590271 590271 Ram, John, junior, of Crendon 0
4714759 2269946 2269946 defendant Tyler John husbandman 590271 590271 Tyler, John, of Crendon, husbandman 0
4738730 2277201 2277201 plaintiff Wilkyn Richard   590271 590271 Wilkyn, Richard, of Crendon 0
4738731 2277201 2277201 defendant Tyrke John, sen yeoman 590271 590271 Tyrke, John, sen, of Crendon, yeoman 0
4749048 2280205 2280205 defendant Smale alias Merkall Thomas shoemaker 590271 590271 Smale alias Merkall, Thomas, of Crendon, shoemaker 0
4805299 2297860 2297860 defendant Appelford John husbandman 590271 590271 Appelford, John, of Crendon, husbandman 0
4945667 2340625 2340625 defendant Salman William husbandman 590271 590271 Salman, William, of Crendon, husbandman 0
4950704 2342186 2342186 defendant Drakelowe John, senior husbandman 590271 590271 Drakelowe, John, senior, of Crendon, husbandman 0
5040865 2368885 2368885 defendant Wygynton alias Bailly William husbandman 590271 590271 Wygynton alias Bailly, William, of Crendon, husbandman 0
5093686 2384551 2384551 defendant Mascall Thomas husbandman 590271 590271 Mascall, Thomas, of Crendon, husbandman 0
5118980 2391986 2391986 defendant West William husbandman 590271 590271 West, William, of Crendon, husbandman 0
5172861 2407796 2407796 defendant Pede John husbandman 590271 590271 Pede, John, of Crendon, husbandman 0
5172862 2407796 2407796 defendant Salman John husbandman 590271 590271 Salman, John, of Crendon, husbandman 1
5200193 2415814 2415814 defendant Batyn John husbandman 590271 590271 Batyn, John, of Crendon, husbandman 0
5220058 2421576 2421576 defendant Flynte Richard   590271 590271 Flynte, Richard, of Crendon, tallow chandler 0
5307982 2447404 2447404 defendant Anthony John   590271 590271 Anthony, John, of Crendon 0
5319576 2450948 2450948 defendant Salman John husbandman 590271 590271 Salman, John, of Crendon, husbandman 1
5319577 2450948 2450948 defendant Harriot William husbandman 590271 590271 Harriot, William, of Crendon, husbandman 2
5346181 2458942 2458942 defendant Adam Roger husbandman 590271 590271 Adam, Roger, of Crendon, husbandman 1
5346182 2458942 2458942 defendant Idylmere John butcher 590271 590271 Idylmere, John, of Crendon, butcher 2
5365136 2464768 2464768 defendant Millen Henry butcher 590271 590271 Millen, Henry, of Crendon, butcher 0
5366457 2465164 2465164 defendant Millen Henry butcher 590271 590271 Millen, Henry, of Crendon, butcher 0
5372503 2466997 2466997 defendant Millen John butcher 590271 590271 Millen, John, of Crendon, butcher 0
5374936 2467755 2467755 defendant Newegar Henry husbandman 590271 590271 Newegar, Henry, of Crendon, husbandman 1
5388965 2471899 2471899 defendant Loveden William gent 590271 590271 Loveden, William, of Crendon, gent 11
5391165 2472550 2472550 defendant Nasshe John shoemaker 590271 590271 Nasshe, John, of Crendon, shoemaker 0
5402606 2475818 2475818 defendant Millen Henry butcher 590271 590271 Millen, Henry, of Crendon, butcher 0
5410333 2478044 2478044 defendant Naweyer Henry husbandman 590271 590271 Naweyer, Henry, of Crendon, husbandman 0
5410334 2478044 2478044 defendant Mylen Henry husbandman 590271 590271 Mylen, Henry, of Crendon, husbandman 1
5410969 2478232 2478232 defendant Naweger Henry husbandman 590271 590271 Naweger, Henry, of Crendon, husbandman 0
5410970 2478232 2478232 defendant Salman John husbandman 590271 590271 Salman, John, of Crendon, husbandman 1
5424181 2482197 2482197 defendant Naweger Henry husbandman 590271 590271 Naweger, Henry, of Crendon, husbandman 0
5424182 2482197 2482197 defendant Milon Henry husbandman 590271 590271 Milon, Henry, of Crendon, husbandman 1
5425117 2482475 2482475 defendant Naweger Henry husbandman 590271 590271 Naweger, Henry, of Crendon, husbandman 0
5425118 2482475 2482475 defendant Salmon John husbandman 590271 590271 Salmon, John, of Crendon, husbandman 1
5434496 2485260 2485260 plaintiff Padnale or Padvale Thomas   590271 590271 Padnale or Padvale, Thomas, of Crendon 0
5434498 2485261 2485261 plaintiff Padnale or Padvale Thomas   590271 590271 Padnale or Padvale, Thomas, of Crendon 0
5434500 2485262 2485262 plaintiff Padvale Thomas   590271 590271 Padvale, Thomas, of Crendon 0
5449876 2489852 2489852 plaintiff Padvale Thomas   590271 590271 Padvale, Thomas, of Crendon 0
5462048 2493543 2493543 plaintiff Padvale Thomas   590271 590271 Padvale, Thomas, of Crendon 0
5462050 2493544 2493544 plaintiff Padvale Thomas   590271 590271 Padvale, Thomas, of Crendon 0
5462386 2493651 2493651 defendant Naweger Henry husbandman 590271 590271 Naweger, Henry, of Crendon, husbandman 0
5473860 2497161 2497161 defendant Naweger Henry husbandman 590271 590271 Naweger, Henry, of Crendon, husbandman 0
5490967 2502199 2502199 defendant Salmon John husbandman 590271 590271 Salmon, John, of Crendon, husbandman 0
5490968 2502199 2502199 defendant Nawegur Henry husbandman 590271 590271 Nawegur, Henry, of Crendon, husbandman 1
5490969 2502199 2502199 defendant Canon Henry husbandman 590271 590271 Canon, Henry, of Crendon, husbandman 2
5490970 2502199 2502199 defendant West William husbandman 590271 590271 West, William, of Crendon, husbandman 3
5492957 2502800 2502800 defendant Byrt William yeoman 590271 590271 Byrt, William, of Crendon, yeoman 1
5498739 2504568 2504568 plaintiff Padnall Thomas (legal representative) 590271 590271 Padnall, Thomas, of Crendon, executors of 0
5498746 2504569 2504569 plaintiff Padnall Thomas (legal representative) 590271 590271 Padnall, Thomas, of Crendon, executors of 0
5513425 2509047 2509047 plaintiff Padnall Thomas (legal representative) 590271 590271 Padnall, Thomas, of Crendon, executors of 0
5518279 2510543 2510543 defendant Nanger or Nauger Henry husbandman 590271 590271 Nanger or Nauger, Henry, of Crendon, husbandman 3
5602710 2535725 2535725 defendant Rede Thomas husbandman 590271 590271 Rede, Thomas, of Crendon, husbandman 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);