names

62 rows where place_id = 589069

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596417 1866509 1866509 defendant Clay William carpenter 589069 589069 Clay, William, of Potton, Beds, carpenter 0
3675145 1918255 1918255 defendant Unwyn William yeoman 589069 589069 Unwyn, William, of Potton, Beds, yeoman 0
3745577 1940522 1940522 defendant Lyon John courser 589069 589069 Lyon, John, of Potton, Beds, courser 0
3762900 1946031 1946031 defendant Harvard Edward husbandman 589069 589069 Harvard, Edward, of Potton, Beds, husbandman 2
3762905 1946032 1946032 defendant Harvard Edward husbandman 589069 589069 Harvard, Edward, of Potton, Beds, husbandman 2
3778109 1950866 1950866 defendant Nawgor Thomas butcher 589069 589069 Nawgor, Thomas, of Potton, Beds, butcher 0
3778114 1950867 1950867 defendant Nawgre Thomas butcher 589069 589069 Nawgre, Thomas, of Potton, Beds, butcher 0
3786094 1953441 1953441 defendant Harper Thomas smith 589069 589069 Harper, Thomas, of Potton, Beds, smith 1
3802747 1958757 1958757 defendant Byrche Thomas yeoman 589069 589069 Byrche, Thomas, of Potton, Beds, yeoman 1
3877894 1982849 1982849 defendant Akworth George gent 589069 589069 Akworth, George, of Potton, Beds, gent 1
3900192 1990289 1990289 defendant Atkyn Hugh yeoman 589069 589069 (Atkyn, Hugh, of Potton, Beds, yeoman 1
3900196 1990290 1990290 defendant Atkyn Hugh yeoman 589069 589069 (Atkyn, Hugh, of Potton, Beds, yeoman 1
3901704 1990793 1990793 defendant Corbett Robert pewterer 589069 589069 Corbett, Robert, of Potton, Beds, pewterer 2
3950918 2007387 2007387 defendant Ellys William husbandman 589069 589069 Ellys, William, of Potton, Beds, or of Granesden Parva, Cams, husbandman 0
3959731 2010494 2010494 defendant Botomley John innholder 589069 589069 Botomley, John, of Potton, Beds, innholder 0
3983158 2018749 2018749 defendant Botomley John innholder 589069 589069 Botomley, John, of Potton, Beds, innholder 0
4010781 2028633 2028633 defendant Bottomley John chapman 589069 589069 Bottomley, John, of Potton, Beds, chapman 1
4019699 2031776 2031776 defendant Godfrey Robert yeoman 589069 589069 Godfrey, Robert, of Potton, Beds, yeoman 0
4034623 2037059 2037059 defendant Bottomley John chapman 589069 589069 Bottomley, John, of Potton, Beds, chapman 0
4041466 2039438 2039438 defendant Broun John laborer 589069 589069 Broun, John, of Potton, Beds, laborer 0
4041469 2039439 2039439 defendant Broun John laborer 589069 589069 Broun, John, of Potton, Beds, laborer 0
4044790 2040588 2040588 defendant Cowper John yeoman 589069 589069 Cowper, John, of Potton, Beds, yeoman 0
4044792 2040589 2040589 defendant Cowper John yeoman 589069 589069 Cowper, John, of Potton, Beds, yeoman 0
4070525 2049751 2049751 defendant Wetche Thomas poulter 589069 589069 Wetche, Thomas, of Potton, Beds, poulter 1
4106846 2062741 2062741 defendant Sellar Baptista grocer 589069 589069 Sellar, Baptista, of Potton, Beds, grocer 2
4113815 2065224 2065224 defendant Parcell Richard gent 589069 589069 Parcell, Richard, of Potton, Beds, gent 0
4185731 2090512 2090512 defendant Mayse Richard yeoman 589069 589069 Mayse, Richard, of Potton, Beds, yeoman 0
4207299 2098106 2098106 defendant Mayes Richard yeoman 589069 589069 Mayes, Richard, of Potton, Beds, yeoman 1
4311837 2134276 2134276 defendant Goodale Mathew shoemaker 589069 589069 Goodale, Mathew, of Potton, Beds, shoemaker 2
4325978 2139062 2139062 defendant Williams Thomas draper 589069 589069 Williams, Thomas, of Potton, Beds, draper 0
4332892 2141284 2141284 defendant Williams Thomas   589069 589069 Williams, Thomas, of Potton, Beds, linen draper 2
4349384 2147048 2147048 defendant Williams Thomas yeoman 589069 589069 Williams, Thomas, of Potton, Beds, yeoman 0
4370762 2154596 2154596 defendant Serle Thomas husbandman 589069 589069 Serle, Thomas, of Potton, Beds, husbandman 1
4725419 2273245 2273245 defendant Gurnard Richard fishmonger 589069 589069 Gurnard, Richard, of Potton, Beds, fishmonger 0
4725420 2273245 2273245 defendant Wendey Thomas thatcher 589069 589069 Wendey, Thomas, of Potton, Beds, thatcher 1
4804443 2297574 2297574 defendant Bocher Robert butcher 589069 589069 Bocher, Robert, of Potton, Beds, butcher 2
4838263 2307886 2307886 defendant Flemynges Simon chapman 589069 589069 Flemynges, Simon, of Potton, Beds, chapman 0
4838268 2307887 2307887 defendant Flemyng Simon chapman 589069 589069 Flemyng, Simon, of Potton, Beds, chapman 0
4843261 2309409 2309409 defendant Thake john tailor 589069 589069 Thake, john, of Potton, Beds, tailor 0
4865515 2316178 2316178 defendant Flemyng Simon chapman 589069 589069 Flemyng, Simon, of Potton, Beds, chapman 0
4922925 2333590 2333590 defendant Hall Richard husbandman 589069 589069 Hall, Richard, of Potton, Beds, husbandman 0
4934638 2337226 2337226 defendant Bocher Robert butcher 589069 589069 Bocher, Robert, of Potton, Beds, butcher 1
4948832 2341616 2341616 defendant White William husbandman 589069 589069 White, William, of Potton, Beds, husbandman 3
4965602 2346628 2346628 defendant Wolrich William yeoman 589069 589069 Wolrich, William, of Potton, Beds, yeoman 0
4965604 2346629 2346629 defendant Wolrych William yeoman 589069 589069 Wolrych, William, of Potton, Beds, yeoman 0
4982962 2351819 2351819 defendant Clement Thomas chandler 589069 589069 Clement, Thomas, of Potton, Beds, chandler 0
5023264 2363708 2363708 defendant Bocher Robert husbandman 589069 589069 Bocher, Robert, of Potton, Beds, husbandman 2
5023267 2363709 2363709 defendant Bocher Robert butcher 589069 589069 Bocher, Robert, of Potton, Beds, butcher 0
5194780 2414215 2414215 defendant Marchall John chapman 589069 589069 Marchall, John, of Potton, Beds, chapman 3
5194785 2414216 2414216 defendant Marchall John chapman 589069 589069 Marchall, John, of Potton, Beds, chapman 3
5208929 2418339 2418339 defendant Marchall John chapman 589069 589069 Marchall, John, of Potton, Beds, chapman 0
5208931 2418340 2418340 defendant Marchall John chapman 589069 589069 Marchall, John, of Potton, Beds, chapman 0
5224827 2422932 2422932 defendant Marchall John chapman 589069 589069 Marchall, John, of Potton, Beds, chapman 1
5298127 2444466 2444466 defendant Clark Robert yeoman 589069 589069 Clark, Robert, of Potton, Beds, yeoman 1
5298132 2444467 2444467 defendant Clerk Robert yeoman 589069 589069 Clerk, Robert, of Potton, Beds, yeoman 1
5371376 2466627 2466627 defendant Degon alias Parker Henry husbandman 589069 589069 Degon alias Parker, Henry, of Potton, Beds, husbandman 0
5377913 2468667 2468667 defendant Rotoure Henry yeoman 589069 589069 Rotoure, Henry, of Potton, Beds, yeoman 1
5486104 2500728 2500728 defendant Clay William carpenter 589069 589069 Clay, William, of Potton, Beds, carpenter 0
5527443 2513165 2513165 defendant Birche Thomas tailor 589069 589069 Birche, Thomas, of Potton, Beds, tailor 0
5540973 2517300 2517300 defendant Pery Nicholas maltman 589069 589069 Pery, Nicholas, of Potton, Beds, maltman 0
5540976 2517301 2517301 defendant Pery Nicholas maltman 589069 589069 Pery, Nicholas, of Potton, Beds, maltman 0
5584134 2530109 2530109 defendant Pery Nicholas weaver 589069 589069 Pery, Nicholas, of Potton, Beds, weaver 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);